7.1

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:
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 Action Task Properties" (page 125)). No
options are offered, as this format is static and should not be modified.
l Alternate syntax: Select this option if your query uses an alternate syntax.
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.
©2010 Objectif Lune Inc - 119 -