7.0
Table Of Contents
- Other Documentation
- Understanding PlanetPress Suite Workflow Tools
- Key Concepts
- PlanetPress Suite Workflow Tools
- The Origins of PlanetPress Watch
- The Nature of PlanetPress Suite Workflow Tools
- Configurations and Processes
- More on PlanetPress Suite Workflow Tools and How They Work
- The Configuration and its Processes
- Tasks
- More on PlanetPress Suite Services
- PlanetPress Design and PlanetPress Workflow Tools
- Data
- Data File and Job File
- Job File Names and Output File Names
- Error Handling Tools
- PlanetPress Suite Workflow Tools and Printing
- The PlanetPress Suite Workflow
- Date and Time Format
- Microsoft Outlook, Outlook Express® and MAPI
- Key Concepts
- The PlanetPress Suite Workflow Tools Configuration Program
- Key Concepts
- Detailed Directions
- Start the PlanetPress Suite Workflow Tool Configuration Program
- Choose the Account to be Used by your PlanetPress Suite Workflow Tool
- Control Access to the Locally Installed Services
- Exit the PlanetPress Suite Workflow Tool Configuration Program
- Create a New Configuration
- Open a PlanetPress Suite Configuration File
- Reopen a Configuration File
- Add a PlanetPress Suite Process
- Import Processes from Another Configuration File
- Save a Configuration
- Use Online Help
- Rename Objects in the Configuration Components Area
- Expand and Collapse Categories and Groups in the Configuration Components Area
- Cut, Copy and Paste Objects in the Configuration Components Area
- Reorder Objects in the Configuration Components Area
- Group and Ungroup Objects in the Configuration Components Area
- Delete Objects and Groups from the Configuration Components Area
- Undo a Command
- Redo a Command
- View Document Properties
- Edit Properties in the Object Inspector
- Select a Process
- Resize Rows and Columns of the PlanetPress Suite Process Area
- Zoom In or Out within the PlanetPress Suite Process Area
- Highlight a Task or Branch
- Resize the Program Window Areas
- Show or Hide Areas of the Program Window
- Dock and Undock Areas of the Program Window
- Combine and Attach Areas
- Configurations, Processes and Tasks
- Configuration Management
- Opening and Importing Configurations and Processes
- Users and Configurations
- Anatomy of a Process
- Configurations, Processes and Flowcharts
- Design Versus Debug Mode
- Tasks as Plugins
- Task Properties Dialog Boxes
- Variable Properties
- Standard Variables
- Job Information Elements and Job Info Variables
- Custom Variables
- Selecting Documents in Tasks
- Sending Job Info Variables to Output Devices
- Working with Tasks in the PlanetPress Process Area
- Adding Branches
- Detailed Directions
- Adding Tasks
- Editing Tasks or Branches
- Adding Comments
- Replacing Tasks, Conditions, Branches or Comments
- Removing Tasks and Branches
- Cutting and Pasting, or Copying and Pasting Tasks and Branches
- Moving Tasks, Branches and Comments Using Drag-and-Drop
- Duplicating Tasks, Branches and Comments Using Drag-and-Drop
- Copying and Pasting Properties between Task, Conditions or Comments
- Disabling and Enabling Tasks and Branches
- Data in PlanetPress Watch
- Input Tasks
- Detailed Directions
- Email Input Task Properties
- Folder Listing Input Task Properties
- Folder Capture Input Task Properties
- FTP Input Task Properties
- HTTP Client Input Task Properties
- HTTP Server Input Task Properties
- Create File Input Task Properties
- LPD Input Task Properties
- Serial Input Task Properties
- Telnet Input Task Properties
- WinQueue Input Task Properties
- Detailed Directions
- Output Tasks
- PlanetPress Fax
- PlanetPress Image
- Action Tasks
- Detailed Directions
- Advanced Search and Replace Action Task Properties
- Database Action Task Properties
- PrintForm Action Task Properties
- PrintShop Mail Action Task Properties
- Rename Action Task Property
- Run Script Action Task Properties
- Search and Replace Action Task Properties
- Send Images to Printer Action Task Properties
- Send to Folder Action Task Properties
- Set Variables Action Task Properties
- Standard Filter Action Task Properties
- Translator Action Task Properties
- Windows Print Converter Action Task Properties
- Create Metadata Action Task Properties
- Create PDF Action Task Properties
- In-Stream Splitter Action Task Properties
- Load External File Action Properties
- PDF Splitter Action Task Properties
- Send to Process Action Task Properties
- Emulated Data Splitter Action Task Properties
- XML Splitter Action Task Properties
- Database Splitter Action Task Properties
- Generic Splitter Action Task Properties
- Add Document Action Properties
- Add/Remove Text Action Properties
- Change Emulation Action Task Properties
- Create VDX Action Task Properties
- Decompress Action Task Properties
- Digital Imaging Action Task Properties
- Digital Signature Action Task Properties
- Download to Printer Action Task Properties
- External Program Action Task Properties
- Loop Action Task Properties
- Open XSLT Action Task Properties
- Detailed Directions
- Using Conditions
- Using Scripts
- Printer Queues and Documents
- Detailed Directions
- LPR Output Printer Queue Properties
- Windows Output Printer Queue Properties
- FTP Output Printer Queue Properties
- Send to Folder Printer Queue Properties
- Printer Queue Advanced Properties
- Import Documents
- Import PrintShop Mail Documents
- Add Resident Documents in the Configuration Components Area
- Associate Documents and PlanetPress Watch Printer Queues
- Print a Test Page
- Manually Update Documents
- Detailed Directions
- Scheduling PlanetPress Watch Processes
- Advanced Configurations and Options
- Key Concepts
- Service Options Versus Properties
- Languages
- Detailed Directions
- Delete Images From Your Virtual Drive
- Editor Options
- LPR Output User Options
- Network Ports Settings
- Change Languages
- Change your User Options
- Change your Script Editor or XSLT Editor User Options
- General User Options
- Object Inspector User Options
- Configuration Components Area User Options
- Default Configuration User Options
- Notification Messages User Options
- Sample Data User Options
- Logging User Options
- Network User Options
- HTTP Server Input User Options
- LPD Input User Options
- Serial Input Service User Options
- Telnet Input User Options
- FTP Output Service User Options
- Error Handling
- Debugging PlanetPress Watch Processes
- Sending and Running a Configuration
• All before occurrence: All occurrences of the search string will be replaced until the specified number of
occurrences has been reached. Specifying 5 occurrences, for instance, means that the four first
occurrences will be replaced.
Replace with: Enter the string that must be used as the replacement sting when a match is found. This is
also a variable property box.
Related topics:a
• Search and Replace Action Task Properties
10.1.2 Database Action Task Properties
PlanetPress Database action tasks retrieve data from various databases to use as input data. The data
received by the task may be kept as is or converted to the CSV, Fixed Length Columns or XML format.
PlanetPress Database action tasks are not input tasks as such, since they cannot be used as the initial input of
a process. Bear in mind that a task that draws in secondary input data replaces any previous data.
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:
• 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 Watch/Server (when you set up a sample data file for a
process).
• 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 Watch/Server. 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
Database group
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.
Table/Query: Select the table or query containing the information you need as your input data.
Range group
All: Select this option use all the records included in the database.
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.
Emulation group
Action Tasks - Detailed Directions
Objectif Lune Inc. © 2009 161