Error while triing to run xls file reader

CloverDX Platform
1

Hello,

Is someone can help me to read a xls file and to store it into MySql database.
To do so I build a very simple toto.xls file with only one column name toto containing only numeric values (1,2,…,28).

when I run my graph I get the following error :

Graph definition file: FilesGraph/toto.grf
INFO  [main] - Checking graph configuration...
INFO  [main] - Mapping type set to MAP_NAMES
Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFWorkbook
        at org.jetel.data.parser.XLSDataParser.setDataSource(XLSDataParser.java:174)
        at org.jetel.component.XLSReader.init(XLSReader.java:455)
        at org.jetel.component.XLSReader.checkConfig(XLSReader.java:253)
        at org.jetel.graph.Phase.checkConfig(Phase.java:187)
        at org.jetel.graph.TransformationGraph.checkConfig(TransformationGraph.java:881)
        at org.jetel.main.runGraph.main(runGraph.java:284)

My graph is the folowing

<?xml version="1.0" encoding="UTF-8"?>
<Graph name="toto">
<Global>
<Metadata fileURL="FilesFMT/toto.fmt" id="Metadata0"/>
<Property fileURL="workspace.prm" id="GraphParameter0"/>
</Global>
<Phase number="0">

  <Node	enabled="enabled" 
	fileURL="FilesDBF/toto.xls" 
	id="XLS_READER1"
	dataPolicy="Lenient"
	metadataRow="1"
	startRow="2"
	sheetNumber="0" 
	type="XLS_READER"/>

  <Node id="MYSQL_WRITER"
        type="MYSQL_DATA_WRITER"
        myload="myload"
        hostname="localhost"
        database="test"
        dbTable="toto"
        username="root"
	password="10Aolpd!!"/>

  <Edge fromNode="XLS_READER1:0" 
	guiBendpoints="" 
	id="INEDGE" 
	inPort="Port 0 (in)" 
	metadata="Metadata0" 
	outPort="Port 0 (out)" 
	toNode="MYSQL_WRITER:0"/>
</Phase>
</Graph>

I can’t even understand what is wrong.
What I understand is that the error is coming from the graph, but I don’t know what wrong with my graph.

Thanks

Regards,

Francois

2

Hello,
in earlier releases we used apache poi library to read data from xls file, now we use jxl. It seems that you try to run old Clover engine, but without poi library. Do you use GUI or run graphs from command line? In the case you run graph from command line the poi-2.5.1.jar must be in the classpath.

3

Thanks for your help.

I installed the new version of clover (2.2.1) and it worked perfectly.

Thanks again. :wink:

Regards