8.5

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 Data encoding: Select the encoding used in the generated XML file. By default, this option
is set to the default encoding of the computer used to create or edit the configuration. You
may choose any encoding listed in the drop-down list or enter your own.
l Maximum records per page: Select this option if you want to limit the number of records
per page. This option is only available if you indicated that you wanted each data page to
contain several records in the Create data pages as follows box.
l XMLfor PrintShop Mail:This emulation is specifically for use with merging your data with a
PrintShop Mail document, using the PrintShop Mail task (see PrintShop Mail). No options are
offered, as this format is static and should not be modified.
l Alternate syntax: Select to prevent automatically enclosing the names of any database tables and
fields that appear in the SQL query in square brackets when it exits the Advanced SQL Statement
dialog box. The alternate syntax may be required for some database types.
l Edit SQL: Click to create and test an advanced SQL query.
l Import Config: If you previously created and exported a PlanetPress Workflow Database Connection
configuration, click this button to import it. This saves you the trouble of configuring the connection
every time.
l Client-side Cursor:When this option is enabled, the complete result set is downloaded before
processing starts, and changing records is done by PlanetPress Workflow. This is generally faster for
queries returning a small number of results ; otherwise the start of the record processing can be
delayed since the whole record set must be downloaded.
Note
MySQL, using ODBC 5.0, must be set to use a client-side cursor.
Microsoft Access will always work better when using a Server-Side cursor.
l Include password in config: Select to save an encrypted version of the database password (if any)
within the exported configuration.
l
Export Config: Click to export the currently displayed properties of the PlanetPress Workflow action
task. The exported configuration can then be reused on other PlanetPress Workflow workstations.