Can't run graph CloverETL Engine: SPREADSHEET_READER unknown

CloverDX Platform
1

I created a graph with CloverETL Designer Community Edition 4.0.0 Build44 using SpreadsheetDataReader for XLSX files. This graph works fine with Designer.

Now I try to integrate my graph with CloverETL Engine Rel 4.0.0. In a simple main method I call runGraph.main with parameters for plugins directory and graph file. This results in an error in org.jetel.component.ComponentFactory

Unknown component: SPREADSHEET_READER class: SPREADSHEET_READER

Does it mean I can’t use SpreadsheetDataReader with CloverETL Engine? Or is there something else to do for running a graph outside Designer?

Thanks for your help.

Error details:
org.jetel.exception.XMLConfigurationException
at org.jetel.graph.TransformationGraphXMLReaderWriter.throwXMLConfigurationException(TransformationGraphXMLReaderWriter.java:1236)
at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiatePhases(TransformationGraphXMLReaderWriter.java:630)
at org.jetel.graph.TransformationGraphXMLReaderWriter.read(TransformationGraphXMLReaderWriter.java:493)
at org.jetel.graph.TransformationGraphXMLReaderWriter.read(TransformationGraphXMLReaderWriter.java:387)
at org.jetel.graph.TransformationGraphXMLReaderWriter.loadGraph(TransformationGraphXMLReaderWriter.java:273)
at org.jetel.main.runGraph.main(runGraph.java:403)
at de.esag.mind.banker.imports.TestETL.main(TestETL.java:91)
Caused by: org.jetel.exception.XMLConfigurationException
at org.jetel.graph.TransformationGraphXMLReaderWriter.throwXMLConfigurationException(TransformationGraphXMLReaderWriter.java:1236)
at org.jetel.graph.TransformationGraphXMLReaderWriter.throwXMLConfigurationException(TransformationGraphXMLReaderWriter.java:1231)
at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiateNodes(TransformationGraphXMLReaderWriter.java:683)
at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiatePhases(TransformationGraphXMLReaderWriter.java:624)
… 5 more
Caused by: java.lang.RuntimeException: Unknown component: SPREADSHEET_READER class: SPREADSHEET_READER
at org.jetel.component.ComponentFactory.getComponentClass(ComponentFactory.java:116)
at org.jetel.component.ComponentFactory.createComponent(ComponentFactory.java:150)
at org.jetel.graph.TransformationGraphXMLReaderWriter.instantiateNodes(TransformationGraphXMLReaderWriter.java:668)
… 6 more
Caused by: java.lang.ClassNotFoundException: SPREADSHEET_READER
at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:190)
at org.jetel.component.ComponentFactory.getComponentClass(ComponentFactory.java:106)
… 8 more

2

Hi concarde,

CloverETL Designer Community Edition (CE) and CloverETL Opensource Engine contain different set of components. SpreadsheetDataReader is available only in CE but is not available in the standalone engine which uses the old component XLSDataReader for reading of spreadsheets.

3

Thanks for your prompt reply and explanation. There’s no XLSDataReader in CE 4.0.0 which I could use instead of SpreadsheetDataReader. That means CE 4.0 in combination with standalone engine 4.0 doesn’t work for XLS/XLSX data processing. One could downgrade to CE 3.5 with appropriate standalone engine. But… where can I download an older version of CE?

4

Actually, XLSDataReader is still present in CE 4.0.0, it is just hidden as a deprecated component. You can unhide it when you right-click into Palette of components and then choose Customize.