2021.2

Table Of Contents

XML Emulation: If you selected XML in the Output file emulation box, the following

options are available:

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.

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.

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.

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.

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.

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.

Edit SQL: Click to create and test an advanced SQL query; see "Advanced SQL

Statement Dialog" on page852.

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.

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.

Page 405