7.1

including JET 4.0.
When adding a PlanetPress Database action task, you have two options:
l You can use static properties (properties that will remain the same regardless of the data processed at runtime). This
option lets you use an Open DataBase Connectivity (ODCB) compliant data source. You can also edit the SQL statement
that assembles the database table. Note that you can import a database connection configuration that you previously
exported from PlanetPress Design (when you created a document) or from PlanetPress Suite Workflow Tools (when
you set up a sample data file for a process).
l You can use dynamic properties (properties that include variables or data available at runtime). This option lets you
create a dynamic database connection string as well as an SQL statement that changes based on the data processed by
PlanetPress Suite Workflow Tools. Note that this option will not let you test the query performed by this task before it is
performed with actual data.
PlanetPress Database action task properties are as follows:
Database Connection tab
l Database group
l Location: Enter either the path and name of the database or a database connection string in this box. You may
click to navigate to the database and paste the database path and name automatically to this box. You may also
click create an ODBC connection string to the data source and paste the string automatically to this box. 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.
l Table/Query: Select the table or query containing the information you need as your input data.
l Range group
l All: Select this option use all the records included in the database.
l Records: Select this option use only some of the records in the database. Indicate the range by entering the
number of the first record followed by a dash and the number of the last record. To use records 50 to 75, for
example, enter 50-75. Note that this option is intended mostly for testing purposes, since in real life scenarios,
you typically want to use all the records stored in a database.
l Emulation group:Use options from this group to customize the data file generated by the PlanetPress Database
action task.
l Output file emulation: Select the emulation corresponding to the type of output file you want the Plan-
etPress Database action task to generate.
l CR-LF replacement: If you want CR-LF (Carriage Return-Line Feed) characters within the data file to be
replaced by another character, use this box to indicate which character to use. You may select the replacement
character from the list or type your own.
l Emulation options group:Options from this group change based on the selected output file emulation.
l PlanetPress Database Emulation:If you selected PlanetPress Database in the Output file emulation box,
the following options are available:
l Create data pages as follows: Select the option that will be used to generate the data pages. Each
data page created using the table or query selected above (Table/Query box) can contain a single rec-
ord, 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 Maximum number of records per page: For data pages that contain multiple records (a fixed or
variable number of records), enter a maximum number of records per page in this box. Note that this
value cannot exceed 4,000.
©2010 Objectif Lune Inc - 118 -