7.4

Output
The result of the query is output in the selected data format. The current emulation is changed to the selected format. Meta-
data and jobinfos are not modified in any way.
PlanetPress Database action task properties are as follows:
Database Connection tab
l Database group
l Location: Enter either the path and name of the database or a database connection string in this box. You may
click to navigate to the database and paste the database path and name automatically to this box. You may also
click create an ODBC connection string to the data source and paste the string automatically to this box. If a
login name and password are required to connect to the database, a dialog box is displayed and the information
you enter is saved in the configuration of the PlanetPress Database action task.
l Table/Query: Select the table or query containing the information you need as your input data.
l Range group
l All: Select this option use all the records included in the database.
l Records: Select this option use only some of the records in the database. Indicate the range by entering the
number of the first record followed by a dash and the number of the last record. To use records 50 to 75, for
example, enter 50-75. Note that this option is intended mostly for testing purposes, since in real life scenarios,
you typically want to use all the records stored in a database.
l Emulation group:Use options from this group to customize the data file generated by the PlanetPress Database
action task.
l Output file emulation: Select the emulation corresponding to the type of output file you want the Plan-
etPress Database action task to generate.
l CR-LF replacement: If you want CR-LF (Carriage Return-Line Feed) characters within the data file to be
replaced by another character, use this box to indicate which character to use. You may select the replacement
character from the list or type your own.
l Emulation options group:Options from this group change based on the selected output file emulation.
l PlanetPress Database Emulation:If you selected PlanetPress Database in the Output file emulation box,
the following options are available:
l Create data pages as follows: Select the option that will be used to generate the data pages. Each
data page created using the table or query selected above (Table/Query box) can contain a single rec-
ord, a fixed number of records, or a variable number of records. To choose the last option, select one of
the When [field name] changes listed in this box.
l Sort on conditional field: Select this option if you want the table to be sorted using the field selected
in the Create data pages as follows box before the data page creation process is started.
l Maximum number of records per page: For data pages that contain multiple records (a fixed or
variable number of records), enter a maximum number of records per page in this box. Note that this
value cannot exceed 4,000.
l CSV Emulation: If you selected CSV in the Output file emulation box, the following options are available:
l Sort on field: If you want the table to be sorted before the data page creation process is started, select
the sort field from this box.
l Text delimiter: Select the text delimiter to be used in the generated file.
l Field separator: Select the field separator to be used in the generated file.
l Add a header record with field names: Select this option if you want the generated file to have a
header record (a record that includes the field names only).
l Fixed Length Columns Emulation:If you selected Fixed length columns in the Output file emulation box,
the following options are available: