2022.1

Table Of Contents
input/output file placeholder options (expressed as either ${input} or
${output}) or via Job Creation runtime Parameters (expressed as
${params.xxxx}, where the xxxx is the name of the runtime parameter).
The Windows command line instruction should do something like the following:
1. Do some processing of the input CSVfile which PlanetPress Connect will
pass through in the position of the ${input} placeholder.
2. Generate an output file that contains the sorted data and must be named
according the file name PlanetPress Connect will pass through in the position
of the ${output} placeholder
For example: cmd /C sort /R ${input} ${output}
This would reverse the order of the ${input} file, and sent the output to the
${output} file.
l Timeout: Enter the number of seconds to wait for an external sort command to
complete before abandoning the external sort.
l Separator: Enter the field separator used in the CSV file, such as a comma (,), pipe
(|), semicolon (;), etc.
l Quote Character: Enter the quoting character that wraps around any field that
contains the separator.
l Escape Character: Enter the character use to escape the Quote character if it
appears in the field value.
l Line Ending: Use the drop-down to select which line ending to use. The selections
are: Windows Carriage Return/Line Feed combination (CRLF), Linux Line Feed
(LF) or Apple Macintosh Carriage Return (CR).
l Character Set: Use the drop-down to select which character set to use when
encoding the CSV file. This always defaults to UTF-8, as this caters for all possible
characters, is relatively compact (in terms of Unicode character sets) and is
compatible with standard ASCII.
l Exported sort data group:
l First row of sort data has field names checkbox: select to have field names
placed on the first line of the exported CSVfile.
l Fields to export: Lists the fields to export in the CSV file. The buttons to the
right of the table provide the following functionality:
l
Click to select from available datatfields. The Field Selection dialog
will appear, which allows selection of one or several fields from those
available.
Page 1241