7.1

Table Of Contents
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 IDis in your Microsoft® Excel® worksheet.
l Lookup Column:The name of the column in the Microsof Excel® worksheet that corresponds to the con-
tents of the Lookup Field.
l Action:What to do with the resulting data from the Microsof 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 Emailmetadata 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 documenttakes 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 valuecome fromthe
©2010 Objectif Lune Inc - 149 -