2018.1

Sorting Settings
l
Use standard sort: Sort using the fields below:
l
Field Name: Use the drop-down to select which field to sort on.
l
Order: Use the drop-down to choose Ascending or Descending.
l Add: Click to add a new row to the sort list. The list that appears contains all the
fields in the Data Model, as well as a special <Document Length> option which is
used to sort by the number of pages in each document.
l
Delete: Click to delete the currently selected row in the list.
l
/ Move up / down: Click to move the currently selected row up or down within
the list.
l
Use external sort: Sort the records using some external sorting software. A CSV file is
exported, sorted by the external application and the sorted CSV file is returned and
integrated, with the records now sorted according to the new order in the CSV file.
Warning
External Sort commands must return a non-zero error code if an error occurs.
An external sort command could easily fail part way through processing and
generate only a partial output file. Without receiving a return code from the external
sort process, PrintShop Mail Connect cannot know if the sort has successfully
completed or not. Thus the sort program must generate a return code, with a code of
zero ('0') indicating success, and all non-zero results indicating failure.
l
Command: Enter either:
l The full path to the executable that will sort the CSV file.
l A valid Windows command line instruction to sort the records.
This instruction should do the following:
1. Do some processing of the input CSVfile which PrintShop Mail 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 PrintShop Mail Connect will pass through in the
position of the ${output} placeholder
For example: cmd /C sort /R ${input} ${output}
Page 545