2018.2

Table Of Contents
l The "Metadata Sorter" on page475 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" on page408 then uses the Rep ID field to
retrieve each sales representative's email from a specific Excel spreadsheet.
l The "Metadata Sequencer" on page474 acts like a splitter, where the separation
happens whenever the Rep ID changes. Since documents 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" on page309 is then used to generate a single PDF for each sales
representative. Because Create PDF works in conjunction with Metadata and because it
can be used in pass-through 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 concatenated data file is untouched.
l Finally, the output is done using a "Send to Folder" on page555 in this case. Obviously,
this should be a "Send Email" on page551 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.
Daily Sales Report from PDF Files
This workflow makes heavy use of both PDF Tools and Metadata, and assumes that you are
using PlanetPress Workflow version 7.3 or higher.
This single process workflow generates a daily sales report for any sales representative 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 representative in a single PDF and
then sending it to the sales representative. It does this using several specific metadata tasks as
well as a quick lookup in an external Excel spreadsheet.
Resources
l PDF-DailySalesReport-Workflow.zip
Task Breakdown
l The initial input is the "Merge PDF Files" on page268, 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.
Page 193