2018.1

After selecting the file, take a look at the preview to ensure that the file is the right one and the
encoding correctly reads the data. Click Next.
For an Excel file you can indicate whether or not the first row contains field names, and from
which sheet the data should be extracted.
For a CSV file the wizard will display the different settings it has detected, allowing you to
change them:
l
Encoding: Defines which encoding is used to read the file.
l
Separator: Defines which character separates each field in the file.
l
Comment Delimiter: Defines which character starts a comment line.
l
Text Delimiter: Defines which character surrounds text fields in the file. Separators and
comment delimiters within text are not interpreted as separator or delimiter; they are seen
as text.
l
Ignore unparseable lines: Ignores any line that does not correspond to the settings
above.
l
First row contains field names: Uses the first line of the CSV as headers, which
automatically names all extracted fields.
Verify that the data are read properly.
Finally click Finish. All data fields are automatically extracted in one extraction step.
Using the wizard for databases
The DataMapper wizard for database files helps you create a data mapping configuration for a
database file. The wizard extracts the data in one extraction step.
The wizard cannot create detail tables. If the file contains transactional data, the data mapping
configuration is best created without a wizard (see "Creating a new data mapping
configuration" on page152).
Opening a database file with a wizard
There are two ways to open an XML file with a wizard: from the Welcome screen or from the
File menu.
Page 158