2022.1

The Sorting Options page is used to sort the records in the output. Sorting is done from the top
to the bottom, one after the other.
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, then sorted by the external application and the resultant sorted CSV file is
returned and integrated, with all the records now being sorted according to the new order
within 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, PlanetPress 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 External Sort Settings group:
This section of the dialog is only activated if the Use external sort option has been
selected.
l Command: Enter either the full path of the executable file that will sort the CSV file,
or a valid Windows command line instruction to sort the records.
Placeholders can be used within this command, and are available via the Insert
Page 1240