7.5

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 same
metadata level as the Lookup Field.
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.
If storing the message or ID, if they are store in a jobinfo they will be available in any error handling process where errors are
being forwarded. In all cases, if your process continues after the error, the contents of the variables selected in this window
will be available for the rest of your process, or whenever they are overwritten.
Common Errors
Though some error messages are specific to a task in particular, others may apply to any and all tasks because they are
related more to the system than to PlanetPress itself. Some examples would be W3813, W3830, W3991, W4005. These cor-
respond to issues such as not having any space to write files, permission errors on folders or files, etc.
Comments Tab
The Comments tab, added in PlanetPress Suite 7.5, is common to all tasks. It contains a single text area (Task
comments)that lets you write comments about the task. These comments are saved when the dialog is closed with the
OKbutton, and are displayed in The Task Comments Pane.
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 Emailmetadata field isa 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