Command line arguments

<< Click to Display Table of Contents >>

Navigation:  Reference >

Command line arguments

Easy Data Transform accepts the following command line arguments:

 

Argument

Description

<file name>

The .transform file to open at start-up.

-cli

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.

-new_window

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

-verbose

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.

 

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