Page 1 of 1
EasyDataTransform (CSV to HTML table)
Posted: Fri Nov 25, 2022 11:09 am
by magnussandstrom
Hi, can anyone (Jimmy maybe) help me how to setup EasyDataTransform CLI (convert CSV to HTML table) in Switch? I have downloaded the trial version of EasyDataTransform, but struggle with the ExecuteCommand variables in Switch.
Re: EasyDataTransform (CSV to HTML table)
Posted: Fri Nov 25, 2022 1:15 pm
by JimmyHartington
Hi Magnus
I did struggle a bit with this myself.
And there is probably a better way, so if you find it please share.
But here is what I do.
I use the "Run Command" app which uses EasyDataTransform. The output is then placed in another folder.
"Inject job" is then used to replace the input with the output.
I did not succeed with getting the output from EasyDataTransform as output in Switch directly.
Example
HTML of flow:
https://d.pr/f/On8oFC+
By the way. I use EasyDataTransform a lot as a standalone app on my Mac as well.
For converting addresses for shipping systems, transform customers order Excels to our own internal lists and analyse custom log-files from Switch to give a pivot table of items processed for certain customers. It is a very powerfull tool.
Re: EasyDataTransform (CSV to HTML table)
Posted: Fri Nov 25, 2022 2:04 pm
by JimmyHartington
EasyDataTransform can have more than one file as output. It depends on how the transform is setup.
Maybe that is why it is difficult to get the output file(s) directly from the "Run Command" app?
Re: EasyDataTransform (CSV to HTML table)
Posted: Fri Nov 25, 2022 2:34 pm
by magnussandstrom
Great Jimmy, I got 'your setup' to work for me too, thanks! Yes it seems like a very powerful tool indeed!
Re: EasyDataTransform (CSV to HTML table)
Posted: Fri Nov 25, 2022 6:56 pm
by JimmyHartington
Good.
Please let me know if you find a better way to integrate it into Switch.
Re: EasyDataTransform (CSV to HTML table)
Posted: Sun Nov 27, 2022 4:59 pm
by Padawan
I don't have the tool, so I can't test to be sure, but the following should also work and avoid the need for the inject job.
Code: Select all
"C:\Program Files\EasyDataTransform_1_35_0\EasyDataTransform_1_35_0.exe" "D:\EasyDataTransform\graphware-efterkalkulation.transform" -file "input=%%InputFilePath%%" -file "output= "C:\Program Files\EasyDataTransform_1_35_0\EasyDataTransform_1_35_0.exe" "D:\EasyDataTransform\graphware-efterkalkulation.transform" -file "input=%%InputFilePath%%" -file "output= "C:\Program Files\EasyDataTransform_1_35_0\EasyDataTransform_1_35_0.exe" "D:\EasyDataTransform\graphware-efterkalkulation.transform" -file "input=%%InputFilePath%%" -file "output=%%OutputPath%%\[Job.UniqueNamePrefix].xlsx" -cli
Depending on the inner working of the tool this may work to
Code: Select all
"C:\Program Files\EasyDataTransform_1_35_0\EasyDataTransform_1_35_0.exe" "D:\EasyDataTransform\graphware-efterkalkulation.transform" -file "input=%%InputFilePath%%" -file "output= "C:\Program Files\EasyDataTransform_1_35_0\EasyDataTransform_1_35_0.exe" "D:\EasyDataTransform\graphware-efterkalkulation.transform" -file "input=%%InputFilePath%%" -file "output= "C:\Program Files\EasyDataTransform_1_35_0\EasyDataTransform_1_35_0.exe" "D:\EasyDataTransform\graphware-efterkalkulation.transform" -file "input=%%InputFilePath%%" -file "output=[Job.UniqueNamePrefix].xlsx" -cli
Re: EasyDataTransform (CSV to HTML table)
Posted: Mon Nov 28, 2022 8:05 am
by JimmyHartington
I can confirm both examples work in my setup.
So I do not need the inject job.
Thanks.
Re: EasyDataTransform (CSV to HTML table)
Posted: Mon Nov 28, 2022 9:33 am
by magnussandstrom
Thanks alot Padawan!