2020.2

Saving a data mapping configuration
A data mapping configuration file has the extension .OL-datamapper. The file contains the
settings, the extraction workflow ('Steps'), the Data Model and the imported Data Samples
(excluding database source files such as mySQL, oracle, etc).
To save a data mapping configuration:
l
In the "Menus" on page297, click on File > Save, or click on Save As to save a copy of a
data mapping configuration under a different name.
l
In the "Toolbar" on page369, click the Save button.
If the data mapping configuration has not been saved before, you have to browse to the location
where the data mapping configuration should be saved and type a name, then click Save.
Using the wizard for CSV and Excel files
The DataMapper wizard for CSV and Excel files helps you create a data mapping configuration
for such files. The wizard automatically detects delimiters and extracts all data in one extraction
step.
The wizard interprets each line in the file as a record. If your data file contains transactional
data, you will probably want more lines to go in one record and put the transactional data in
detail tables.
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198).
There are two ways to open a CSV file or Excel file with a wizard: from the Welcome screen or
from the File menu.
l
From the Welcome screen
1.
Open the PlanetPress Connect Welcome page by clicking the icon at the top
right, or select the Help menu and then Welcome.
2.
Click New DataMapper Configuration.
3.
From the Using a wizard pane, select CSV/XLSX/XLS.
Page 203