2018.1

depending on the available processing power.
l Excel files saved in "Strict Open XML" format are not supported yet.
l Extracting data from a PDF that comes from a Windows printer queue (a PDF
converted to PostScript, converted back to PDF by an Input task in Workflow) might
not work (see the Connect Knowledge Base). The rule of thumb is: if copy-paste
from Acrobat works, so will data mapping; if not, the DataMapper won't either.
With a wizard
Data mapping wizards are available for PDF/VT, AFP, XML, CSV and database tabular files,
because these files are structured in a way that can be used to automatically set record
boundaries.
The wizard for PDF/VT and AFP files cannot extract data, only metadata. After opening such a
file with the wizard, you can build the data extraction workflow.
The other wizards use the Extract All step to extract data, but they cannot create detail tables,
so they are less suitable for files from which you want to extract transactional data.
There are two ways to open a data file with a wizard: from the Welcome screen or from the File
menu.
l
From the Welcome screen
1.
Open the PlanetPress ConnectWelcome page by clicking the icon at the top right
or select the Help menu and then Welcome.
2.
Click Create a New Configuration.
3.
From the Using a wizard pane, select the appropriate file type.
l
From the File menu
1.
In the menu, click File > New.
2.
Click the Data mapping Wizards drop-down and select the appropriate file type.
The steps to take with the wizard depend on the file type. See:
l "Using the wizard for CSV and Excel files" on page156
l "Using the wizard for databases" on page158
Page 154