2022.1

Note
The ExtraData field that appears as the first field in each record and in each detail table is
automatically added to the Data Model by the DataMapper. It offers the possibility to add
extra data to existing data records in a Workflow process.
The ExtraData field can be used in a template just like any other data field (see "Variable
Data" on page846). When it contains a JSON string, this value can be read with a script
using JSON.parse().
Note
When generating output with just a data mapping configuration, the template is merged
with the complete sample data file that is part of the data mapping configuration. The
output is not limited to the number of records shown in the Data Model pane (which is
one of the settings in the DataMapper).
Adding data from a data file
1. Click File, select Add Data and then click From file data source. Browse to the location
of the file and select it.
The Designer can open the following types of data files:
l Tabular files: CSV files (.csv, .txt) and Excel files (.xls, .xlsx)
Note
Excel files saved in "Strict Open XML" format are not supported yet.
l Microsoft Access Database (.mdb, .accddb)
l JSON files (JSON)
l XML files (.XML)
l PDF/VT files
2. Review the options presented, to ensure that the data will be interpreted correctly. The
options available depend on the type of data file (see below).
Page 836