Sorting Options
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
- Use standard sort: Sort
using the fields below:
- Field Name: Use the
drop-down to select which field to sort on.
- Order: Use the drop-down
to choose Ascending or Descending.
- Add: Click to add a
new row to the sort list. The list that appears contains all the
fields in the , as well as a special <Document Length>
option which is used to sort by the number of pages in each document.
- Delete: Click to delete
the currently selected row in the list.
- Move up: Click to move
the currently selected row up in the list.
- Move down: Click to
move the currently selected row down in the list.
- Use external sort: Sort
the records using an 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.
- Command: Enter either:
- The
full path to the executable that will sort the CSV file.
- A valid Windows command line instruction to sort the records.
This instruction should do the following:- Do some processing of the input CSV file which PlanetPress Connect will pass through in the position of the ${input} placeholder.
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.
- Separator: Enter the
field separator used in the CSV file, such as a comma (,), pipe
(|), semicolon (;), etc.
- Quote Character: Enter
the quoting character that wraps around any field that contains
the separator.
- Escape Character: Enter
the character use to escape the Quote character if it appears
in the field value.
- 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).
- 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.
- Exported sort data group:
- First row of sort data has field names checkbox: select to have field names placed on the first line of the exported CSV file.
- Fields to export: Lists
the fields to export in the CSV file. The buttons to the right of the table provide the following functionality:
Click to select from available datatfields. The Field Selection dialog will appear, which allows selection of one or several fields from those available. Click to remove a field from the
list. / Click to move fields up or down in the order of output.
- Record ID Field: The Record ID field is a database Primary Key field, which is automatically added to the exported data file. The Record ID field name defaults to RecID, but can be changed here as desired.
- Processing returns data group: This allows the external sort application to introduce new data for each record. This data can be embedded in the metadata and used as the source for additional content within PlanetPress Connect.
An example usage would be generating a postcode or postal barcode data from address details, making it available for use in PlanetPress Connect.
|
|