CloverETL CE questions

CloverDX Platform
1

Hello, I just have a quick question about the Community Edition.
1. If I create a graph in the workbench and save it can a user then then run this graph from the command line or in a batch file? The end goal is that the end user doesn’t do anything other than click a icon. Can this be done with the CE Edition only?

Thanks,

Rob

2

Hi, Rob,

I think everything you need for your task is written here: http://wiki.cloveretl.com/doku.php?id=running

It is pretty straightforward but if you had any more questions, do not hesitate to ask.

Best regards,

3

Hi Lubos, I followed your link and downloaded the engine and examples. I attempted to run …\…bin\clover.bat graph\graphSimpleCopy.grf but got numerous errors.
How or where do I create a log file so I can attach the file to the posting?

Thanks,

Rob

4

I am not sure if I fully understand but common redirect of output to some text file should be enough. This is the way it works for me:


C:\Program Files\CloverETL Designer Community\plugins\com.cloveretl.gui_3.3.0.021P\lib\bin>
clover.bat -contexturl C:\Downloads\cloverETL\examples\SimpleExamples\ graph\graphSimpleCopy.grf > C:\temp\cloverlog.txt

Regards,

5

OK, I think I’m getting closer.

I have attached the log. I think the problem is with the last couple lines.

Could this be my setup?

Thanks,

Rob

6

Rob,

according to your log it seems like an error in your command. I have a few questions for you:

1. Are you sure you have your command flawless? Can you please post it here? And also location of your project, your current working directory in cmd and location of your CloverETL installation, please.
2. Are you sure your graph is runnable from Designer? Graph file itself is not enough to run it, you need also input files, parameters file and so on.
3. If you are using a space character in your path, are you using also quotation marks?

Thank you.

Best regards,

7

Hi Lubos, I switched to trying to get graphIntroduction to run. Here are my steps.

I opened the graph in CloverETL CE and specified the input and output files.

I changed the input to a Data reader

I changed the outout to a Data Write

When I run the graph in CE 20 rows pass through and are written. If I open the data-out folder I can confirm they are written.

I then try and run graphIntroduction in clover.bat.
I open a command line in the bin directory and make the call to Clover.bat
C:\Program Files\CloverETL Designer Community\cloverETL\bin>clover.bat -contexturl C:\Users\Robert\CloverETLworkspace\SimpleExamples\RealWorldExamples graph\graphIntroduction.grf > c:\temp\CloverLog.log

I have attached the log file that was produced and snapshots of the file locations.

Thanks for the help.

Rob

8

I just noticed the bug at https://bug.javlin.eu/browse/CLO-192 - Remove org.jetel.license dependency from org.jetel.component plugin. This seems to be me my problem.

How do I go about being notified when this is corrected.

Thanks,

Rob

9

Hello, Rob,

You are right, this relates to https://bug.javlin.eu/browse/CLO-192. Fortunately, there is a simple workaround. I have tried it and it works for me.

In your downloaded package, there is a directory plugins\org.jetel.component. In this directory is a file plugin.xml. Line 21 of the file contains something like . Please, delete this whole line and save the file. That is all, your command is valid so graph run should be succesful after this little change.

Let me know with the results, please, thank you.

Best regards,

10

Hi Lubos,

Sorry to take so long to reply but I had other deadlines last week which took priority. Yes editing the plugins.xml file solved the problem.

Thanks for your time and patience,

Rob