7.1
Table Of Contents
- Copyright Information
- Table of Contents
- Overview
- Getting Started
- Understanding PlanetPress Suite Workflow Tools
- The Nature of PlanetPress Suite Workflow Tools
- The Three Flavors of the PlanetPress Suite Workflow Tools
- Terms and Definitions
- About Configurations
- About Processes
- About Subprocesses
- About Tasks
- About Branches and Conditions
- About Data
- About Data Selections
- About Data Emulation
- About Related Programs and Services
- About Documents
- About Printing
- The PlanetPress Suite Workflow Tools Configuration Program
- Start the PlanetPress Suite Workflow Tools Configuration Program
- The PlanetPress Suite Button
- Create a New Configuration
- Open a PlanetPress Suite Configuration File
- Saving and Sending a Configuration
- Save your Configuration
- Send your Configuration
- Import Processes from Another Configuration File
- Import Documents
- Import PrintShop Mail Documents
- Change the Interface Language
- Exit the PlanetPress Suite Workflow Tools Configuration Program
- The Quick Access Toolbar
- The PlanetPress Suite Ribbon
- The Configuration Components Pane
- Using the Clipboard and Drag & Drop
- Add a PlanetPress Suite Process
- Activate or Deactivate a Process
- Access Process Properties
- View Document Properties
- Convert a Branch to a Subprocess
- Add Resident Documents in the Configuration Components Pane
- Associate Documents and PlanetPress Watch Printer Queues
- Rename Objects in the Configuration Components Pane
- Reorder Objects in the Configuration Components Pane
- Grouping Configuration Components
- Expand and Collapse Categories and Groups in the Configuration Components Pane
- Delete Objects and Groups from the Configuration Components Pane
- The Process Area
- Zoom In or Out within Process Area
- Adding Tasks
- Adding Branches
- Edit a Task
- Replacing Tasks, Conditions or Branches
- Remove Tasks or Branches
- Task Properties Dialog
- Cutting, Copying and Pasting Tasks and Branches
- Moving a Task or Branch Using Drag-and-Drop
- Ignoring Tasks and Branches
- Resize Rows and Columns of the Process Area
- Selecting Documents in Tasks
- Highlight a Task or Branch
- Undo a Command
- Redo a Command
- The Plug-in Bar
- The Object Inspector Pane
- The Debug Information Pane
- The Message Area Pane
- Customizing the Program Window
- Preferences
- General User Options
- Object Inspector User Options
- Configuration Components Pane User Options
- Default Configuration User Options
- Notification Messages Preferences
- Sample Data User Options
- Network User Options
- Logging User Options
- Messenger User Options
- HTTP Server Input User Options
- LPD Input Preferences
- Serial Input Service User Options
- Telnet Input User Options
- PlanetPress Fax User Options
- FTP Output Service User Options
- PlanetPress Image User Options
- LPR Output User Options
- PrintShop Web Connect Service User Options
- Editor Options
- Advanced SQL Statement dialog
- PlanetPress Suite Access Manager
- Add or Delete Document Instances
- Virtual Drive Manager
- Working With Variables
- Data in PlanetPress Suite Workflow Tools
- Task Properties Reference
- Input Tasks
- Initial and Secondary Input Tasks
- Create File Input Task Properties
- Folder Capture Input Task Properties
- Folder Listing Input Task Properties
- Concatenate PDF Files Input Task Properties
- Email Input Task Properties
- Error Bin Input Task Properties
- FTP Input Task Properties
- HTTP Client Input Task Properties
- WinQueue Input Task Properties
- HTTP Server Input Task Properties
- LPD Input Task Properties
- Serial Input Task Properties
- PrintShop Web Connect Input Task Properties
- Telnet Input Task Properties
- SOAP Input Task Properties
- Action Tasks
- Add Document Action Properties
- Add/Remove Text Action Properties
- Search and Replace Action Task Properties
- Advanced Search and Replace Action Task Properties
- Create PDF Action Task Properties
- Digital Action Task Properties
- Decompress Action Task Properties
- Change Emulation Action Task Properties
- External Program Action Task Properties
- Download to Printer Action Task Properties
- Load External File Action Properties
- Rename Action Task Property
- Set Job Infos and Variables Action Task Properties
- Windows Print Converter Action Task Properties
- Standard Filter Action Task Properties
- Translator Action Task Properties
- PlanetPress Database Action Task Properties
- XSLT Editor Action Task Properties
- Send Images to Printer Action Task Properties
- Send to Folder Action Task Properties
- Run Script Action Task Properties
- Microsoft® Word® To PDF Action Task Properties
- Create MRDX Action Task Properties
- PrintShop Mail Action Task Properties
- Process Logic Tasks
- Branch Properties
- Comment Properties
- Conditions
- File Name Condition Properties
- File Size Condition Properties
- SNMP Condition Properties
- Text Condition Properties
- Time of Day Condition
- Splitters
- About Using Emulations with Splitters
- Database Splitter Action Task Properties
- Emulated Data Splitter Action Task Properties
- In-Stream Splitter Action Task Properties
- PDF Splitter Action Task Properties
- XML Splitter Action Task Properties
- Generic Splitter Action Task Properties
- Loop Action Task Properties
- Send to Process Task Properties
- Metadata Tasks
- Barcode Scan Action Task Properties
- Create Metadata Action Task Properties
- Embed/Extract PlanetPress Suite Metadata
- Lookup in Microsoft® Excel® Documents Action Task Properties
- Metadata Fields Management Task Properties
- Metadata Filter Action Task Properties
- Metadata Level Creation Action Task Properties
- Metadata Sequencer Action Task Properties
- Metadata Sorter Task Properties
- Metadata-Based N-Up Task Properties
- Rule Interface
- Output Tasks
- Delete Output Task Properties
- FTP Output Task Properties
- Laserfiche Repository Output Task Properties
- Printer Queue Output Task Properties
- Print Using a Windows Driver Output Task Properties
- SOAP Client Task Properties
- Send Email Output Task Properties
- Send to Folder Output Task Properties
- About PlanetPress Fax
- PlanetPress Fax Output Task Properties
- About PlanetPress Image
- PlanetPress Image Output Task Properties
- Overview of the PDF/A and PDF/X Standards
- Variable Properties
- Unknown Tasks
- Masks
- Input Tasks
- Printer Queues and Documents
- PlanetPress Suite Workflow Tools Printer Queues
- Printer Queue Advanced Properties
- Windows Output Printer Queue Properties
- LPR Output Printer Queue Properties
- FTP Output Printer Queue Properties
- Send to Folder Printer Queue Properties
- PlanetPress Suite Workflow Tools and PlanetPress Design Documents
- Variable Content Document File Formats: PTZ, PTK and PS
- PlanetPress Suite Workflow Tools and Printshop Mail Documents
- Load Balancing
- Location of Documents and Resources
- Debugging PlanetPress Suite Processes
- Error Handling
- Using Scripts
- Index
l Excel group
l Excel workbook:The full path and filename of a Microsoft® Excel® workbook (.xls or .xslx file). You can use
the Browse button on the right to browse to the file on your computer.
l Excel worksheet:The name of the worksheet you want to use. Once a workbook is open, this drop-down will
automatically list all the available worksheets.
l Refresh button:If you have modified the original Microsoft® Excel® workbook to add a sheet, click this but-
ton to refresh the list of worksheets.
l Metadata group
l Lookup Field:The name of the metadata field on the Datapage level that will be used to determine which row
should be returned. For example this could be a customer ID, if that IDis in your Microsoft® Excel® worksheet.
l Lookup Column:The name of the column in the Microsoft® Excel® worksheet that corresponds to the con-
tents of the Lookup Field.
l Action:What to do with the resulting data from the Microsoft® Excel® worksheet. This can be:
l Add Field:Creates a new field with the data. This may cause multiple fields to be created.
l Replace field value:Replaces any existing field with the new content. Only the last result will be dis-
played. If the field does not exist, it will create it.
l Append field value:Ads the data to the existing field within the same one. No "separator"is added. If
the field does not exist, it will create it.
l Result Field:The metadata field name in which the result should be stored. This field will appear in the Datap-
age level of the metadata.
l Result Column:The name of the column where the information you want to retrieve is located. For example,
this could be a client email or full name.
l
Button:Ads a new lookup line. You can have as many lines as you want. The lines will be executed in order
from top to bottom, so you can rely on a previous line to bring additional information.
l
Button:Removes the currently selected (highlighted) line.
l
Button:Moves the currently selected line up one place.
l
Button:Moves the currently selected line down one place.
l Search option group
l Match case:Will force the lookup column names to be in exactly the same case as the Lookup column name.
This means if you type in "CustomerID"in the lookup column and the actual column is named "customerid", it
would not return any result.
On Error Tab
The On Error Tab is common to all tasks. Details can be found on "Task Properties Dialog" (page 51).
Use Cases
Use Case 1: Send Personalized Emails with Promotional Document Attached
A PlanetPress Design document takes as input a PDF file as the input data file, and reproduces it exactly as it enters. The doc-
ument also contains a custom data selection set to hold an email address.The data selection's value is given by a Metadata
Field called'Email'.The value of this Emailmetadata field isa region from the sample data file representing the customer
number. At production time, the Lookup in Microsoft® Excel® Documents Action task will replace the value of this metadata
field with the corresponding customer email.
Use Case 2: Translate a list of line items descriptions into a given language
A PlanetPress Design documenttakes as input a transactional PDF file, and reproduces it exactly as it enters. Metadata fields
called ItemDesc are created, one for each line item description, at the datapage level. Each ItemDesc metadata field is given
the value of a line item description as found on a region of the current data page. The line item descriptions appearing on the
resulting page produced by the design tool are custom data selections whose valuecome fromthe
©2010 Objectif Lune Inc - 149 -










