7.4

Table Of Contents
Examples
l Daily Sales Report from PDF Files
Daily Sales Report from PDF Files
This workflow makes heavy use of both PDFTools and Metadata, and assume that you are using PlanetPress Office or Plan-
etPress Production version 7.3 or higher.
This single process workflow generates a daily sales report for any sales rep inside of a company which made at least one
sale. It does this by capturing the invoices generated within a specific day, putting all the invoices for each sales rep in a single
PDFand then sending it to the sales rep.It does this using several specific metadata tasks as well as a quick lookup in an exter-
nal Excel spreadsheet.
Resources
l PDF-DailySalesReport-Workflow.zip
Task Breakdown
l The initial input is the Merge PDF Files, which retrieves and merges all the PDFfiles inside of the specified folder. Once
a single PDFis created, the task also optimizes the PDF(to avoid duplicating images and font definitions for each
page)as well as generates a basic Metadata structure containing a single document with one Data Page per captured
PDF.
l The Metadata Level Creation creates the Document level of the metadata by placing each PDFdata file in its own Doc-
ument level. It does this by detecting when the Address in the document changes.
l Then, the Metadata Fields Management adds a few fields at the Document level in order to properly tag each document
with the appropriate information, in this case the CustomerID, Country and Rep ID. These fields are identical to ones
that would have been added in PlanetPress Design, and are used for the following metadata tasks.
l The Metadata Filter follows by removing any invoice that is not in the US. Note that the Metadata filter is an
*inclusive*filter, meaning that the filter includes the parts of the metadata where the result of the filter is true, and
filters out anything else.
l The Metadata Sorter then re-orders the metadata documents by Rep ID, so that all of the invoices for any particular
sales representative are all together.
l Lookup in Microsoft® Excel® Documents then uses the Rep IDfield to retrieve each sales rep's email from a specific
Excel spreadsheet.
l The Metadata Sequencer acts like a splitter, where the separation happens whenever the Rep ID changes. Since doc-
uments are sorted with that field, each sequence can contain one or more document, but they will all be for the same
Rep ID.
l Create PDF is then used to generate a single PDFfor each sales rep. Because Create PDFworks in conjunction with
Metadata and because it can be used in passthrough mode, in this instance it will only take the relevant PDFpages from
the original data file in order to create a single PDF file. Other than the extraction of these pages, the original con-
catenated data file is untouched.
l Finally, the output is done using a Send to Folder in this case. Obviously, this should be a Send Email output, but since
we don't want to spam anyone, instead we place the PDFin a folder with the rep id's email as a folder name.
Special Workflow Types