7.4

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 Default width: This box is used to set the default width for all fields. It is set to 60 by default, but can
be set to any value between 1 and 65535. This value is applied to all the fields in the generated file. To
set different widths for each field, use the Configure Width button. Doing this disables the Default width
box.
l Configure Width: Click to set the width of each field in the generated file. The displayed Configure
Width dialog box lists all the fields in the file that will be generated and indicates their widths. To change
the indicated widths, simply click the values displayed in the Width column and enter new values. Click
OK when you are done to close the dialog box. You will then no longer be able to use the Default width
box.
l XML Emulation:If you selected XML in the Output file emulation box, the following options are available:
l Create data pages as follows: Select the option used to generate the data pages. Each data page
created using the table or query selected above (Table/Query box) can contain a single record, 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 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 Action 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 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. This is generally faster for queries returning a small number of results ; other-
wise the start of the record processing can be delayed since the whole recordset must be downloaded.
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 Suite Workflow Tools action task.
The exported configuration can then be reused on other PlanetPress Suite Workflow Tools workstations.
Dynamic SQL tab
l Use dynamic values at runtime: Select to use a dynamic database connection string and/or SQL statement at run-
time. Check this box to enable the options included in this group (this disables the corresponding options in the General
tab).