error while triing to run xls file reader

tchoua_12

• October 09, 2007 00:00

• Answered

Follow

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

• 

  avackova

  • October 10, 2007 07:31

  0

  Comment actions Permalink

  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.
• 

  tchoua_12

  • October 10, 2007 18:04

  0

  Comment actions Permalink

  Thanks for your help.
  
  I installed the new version of clover (2.2.1) and it worked perfectly.
  
  Thanks again. :wink:
  
  Regards

Please sign in to leave a comment.