2021.1

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 CSVfile.
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.
l
Click to remove a field from the list.
l
/ Click to move fields up or down in the order of output.
l 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.
l 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.
l Processing returns data checkbox:Select this if the sort processing will be
returning data. This activates the whole optional Processing returns data
subsection.
Page 1171