1.8

Table Of Contents
you may have to enter a password).
4.
Click Finish.
l From the File menu
1.
Click the File menu and select New.
2.
Click the Data mapping Configuration drop-down and select Files and then the
file type (Comma Separated Values or Excel (CSV/XLSX/XLS), MS-Access,
PDF/VT, Text or XML).
3.
Click Next.
4.
Click the Browse button and open the file you want to work with.
5.
Click Finish.
Note
l Excel files saved in "Strict Open XML" format are not supported yet.
l PCL and PostScript (PS) files are automatically converted to PDF format. When
used in a production environment (a Connect Workflow process) this may influence
the processing speed, depending on the available processing power.
After opening the file, you have to make settings for the input data (see "Data source settings"
on page115). Then you can start building the data extraction workflow.
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.
Page 103