2019.1

Table Of Contents
Resources
l PDF-DailySalesReport-Workflow.zip
Task Breakdown
l The initial input is the "Merge PDF Files" on page271, 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" on page500 creates the Document level of the metadata
by placing each PDF data file in its own Document level. It does this by detecting when
the Address in the document changes.
l Then, the "Metadata Fields Management" on page493 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" on page498 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" on page504 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 page433 then uses the Rep ID field to
retrieve each sales rep's email from a specific Excel spreadsheet.
l The "Metadata Sequencer" on page503 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321 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
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594 in this case. Obviously,
this should be a "Send Email" on page590 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.
Page 194