2022.1

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:
l Comma Separated Values or Excel (CSV/XLSX/XLS),
l Microsoft Access
l PDF, PS, PCL or AFP
l Text
l XML
l JSON
3. Click Next.
4. Click the Browse button and open the file you want to work with.
5. Click Finish.
After opening the file, you have to make settings for the input data (see "Data source settings"
on page249) to make sure that the source data is parsed correctly and divided into logical units
of data the way you want. Then you can start building the data extraction workflow.
Note
l Also select XML if you want a JSON file to be converted to and treated like XML. If
there is no root element in the JSON it will be added and each object without a
named parent element is called an 'item'.
Note that in addition to being valid, the JSON should follow naming rules for XML
elements. For example, "adress_line_1:" is a valid key name in JSON, but it cannot
be converted to a valid element name in XML because the colon is reserved for
namespaces. For XML naming rules and best naming practices, see: XML elements
on W3Schools.
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 by the
Connect Server. To allow for this, the default Connect Server and (if it is secured)
an authenticated user must be configured via the Preferences (see "Connect
Servers preferences" on page914).
Note that when used in a production environment (e.g. a Connect Workflow
Page 224