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
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
-
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, -
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, -
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 -
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, -
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
<Node enabled="enabled" fileURL="${DATAIN_DIR}/delimited/addressbook.csv" guiHeight="93" guiName="UniversalDataReader" guiWidth="148" guiX="30" guiY="152" id="DATA_READER0" type="DATA_READER"/>
I changed the outout to a Data Write
<Node enabled="enabled" fileURL="${DATAOUT_DIR}/addressbook_short.txt" guiHeight="93" guiName="UniversalDataWriter" guiWidth="145" guiX="740" guiY="152" id="DATA_WRITER0" type="DATA_WRITER"/>
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 -
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 -
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 <import plugin-id="org.jetel.license"/>. 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,
Please sign in to leave a comment.
Comments 9