7.3

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" (page 181)). 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.
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).
l Parse normally: Select to interpret any backslashes included in the database connection string as back-
slashes. If this option is not selected, any backslash that is not doubled will be disregarded.
l Database connection string: Enter a variable connection string in this box. To do this you may begin by
clicking to create an ODBC connection string to the data source and paste the string automatically to this box.
Note that 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. Another option,
if a database connection string (not a database path and name) was already entered in the Database Connection
tab, is ti simply copy and paste it to this box. Bear in mind that if the Parse normally option is not selected, any
backslashes included in the connection string that is not doubled will be disregarded. Once your connection
string is displayed in this box, you can edit it by adding variables or data selections.
l SQL statement: Enter your SQL statement. Remember that you may use variables and data selections in
your statement.
On Error Tab
The On Error Tab is common to all tasks. Details can be found on "Task Properties Dialog" (page 54).
Rename
Rename action tasks are used to rename the job files they receive. Note that you can see how each file is renamed via the
Object Inspector when stepping through a process in Debug mode.
Rename action task property is as follows:
General tab
l New file name: Enter the job file’s new name. In this variable property box, you may enter static characters, var-
iables, job information elements, data selections, or any combination of these.
On Error Tab
©2010 Objectif Lune Inc - 134 -