Command line arguments

<< Click to Display Table of Contents >>

Navigation:  Reference >

Command line arguments

Easy Data Transform accepts the following command line arguments:




<file name>

The .transform file to open at start-up.


Close the application once any processing on the opened file is complete.

-file <alias>=<location>

Sets the input or output file with the given alias to the location (path) specified. Input Excel files should include the sheet name, e.g. file.xlsx[sheet]. Output Excel files may optionally include a sheet name. The file type should be the same as the original.


Don't load the last opened .transform file, even if open previous file at start-up is checked in Preferences.


Output additional information to the terminal. Useful for debugging problems.


This allows you to run Easy Data Transform from the Windows Command Prompt or a .bat file. For example:


To run C:\Users\andy\Documents\myfile 1.transform with the output with alias output1 output instead to C:\Users\andy\Documents\data1.csv:


"C:\Program Files (x86)\EasyDataTransform_v1\EasyDataTransform.exe" "C:\Users\andy\Documents\myfile 1.transform" -file "output1=C:\Users\andy\Documents\data1.csv" -cli -verbose


To run C:\Users\andy\Documents\myfile2.transform with the input with alias input1 input instead from sheet sheet1 of C:\Users\andy\Documents\data 2.xlsx:


"C:\Program Files (x86)\EasyDataTransform_v1\EasyDataTransform.exe" "C:\Users\andy\Documents\myfile2.transform" -file "input1=C:\Users\andy\Documents\data 2.xlsx[sheet1]" -cli -verbose


To use a wildcard to transform multiple files in a folder:


forfiles /p C:\Users\andy\Desktop\cli /m in*.csv /c "cmd /c \"C:\Program Files (x86)\EasyDataTransform_v1\EasyDataTransform.exe\" C:\Users\andy\Desktop\cli\cli.transform -file \"cli-in=@file\" -file \"cli-out=out-@fname.csv\" -cli -verbose"


Put quotes (") around any arguments with spaces (as shown in the examples above).


To run from the command line on a schedule, call a script file (e.g. .bat or PowerShell) from a scheduling program, such as Windows Task Scheduler.


If you are using wildcards then it is usually a good idea to output to a different folder to your are inputting from.


Select File>Command Line... to show sample command line text which you can copy and modify. It will also warn you of potential issues.


See also:

Batch processing