7.6

PlanetPress Database action tasks require version 2.5 or higher of the Microsoft Data Access Components (MDAC),
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.
Input
Any data file. The data file will be discarded by the task.
Processing
Aconnection to the selected database is made, the data is retrieved, and an output in the selected emulation format is gen-
erated.
Output
The result of the query is output in the selected data format. The current emulation is changed to the selected format. Meta-
data and jobinfos are not modified in any way.
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.