Use CSV Import/Export

Overview

Importing from a CSV file

Exporting to a CSV file

Overview

You can import data from a CSV file into a table or export data from a table into a CSV file in a DML Mapping Project.

Import from a CSV file

  1. To import into a table from a CSV file, open the desired table with the table editor and select the icon from the main toolbar. Alternatively, select File > Import… > Mapping Services > Table > CSV Data Importer and select the table from the project structure displayed in the wizard.
  2. Mapping Services opens the wizard to import data from a CSV file into the table.
  3. Modify the fields in the Import from CSV dialog window.
Field Contents
File The .csv file contains the data to import into the table. Only a file with the .csv extension can be selected.
Encoding The encoding of the .csv file.
Line Delimiter The line delimiter used in the .csv file. By default, the Windows-specific line delimiter is selected.
Column Delimiter The column delimiter used in the .csv file. By default, comma is selected as column identifier. The combo box shows several options, but this field is also editable, so a customized value can be typed.
String Quoted Identifier The identifier is used to indicate quotes in the .csv file. By default, the selection in the combo box is set to {none}.
Available Columns The columns in the .csv file. From this list, you can add columns to the Selected columns list on the right pane of the dialog window.
Selected Columns You can select one or multiple columns from the available columns to import into the table. You can only select columns that are already present in the table. You can add or remove columns to the selected columns list.
Sample File Columns The first few lines of the .csv file arranged by the columns defined in it. It is intended as an overview of the data of the .csv file. This field is not editable.
  1. Click Import.

The data from the .csv file is imported into the table. The data from the .csv file is appended into the table corresponding to the selected columns. If the table contains columns that were not selected in the dialog, the appended information will be empty for those columns.

Export to a CSV file

  1. To export from a table into a CSV file, open the desired table with the table editor and select the icon from the main toolbar. Alternatively, select File > Export… > Mapping Services > Table > CSV Data Exporter and select the table from the project structure displayed in the wizard.
  2. Mapping Services opens the wizard to export data from a table into a CSV file.
  3. Modify the fields in the Export to a CSV dialog window.
Field Contents
File The .csv file in which the data from the table will be exported to. Only a file with the .csv extension can be selected.
Encoding The encoding of the .csv file.
Line Delimiter The line delimiter used in the .csv file. By default, the Windows-specific line delimiter is selected.
Column Delimiter The column delimiter used in the .csv file. By default, comma is selected as column identifier. The combo box shows several options, but this field is also editable, so a customized value can be typed.
String Quoted Identifier The identifier which is used to indicate quotes in the .csv file. By default, the selection in the combo box is set to {none}.
Contains Column Names If this option is checked, the .csv file will contain the selected column names also.
Available Columns The columns in the .csv file. From this list, you can add columns to the Selected columns list on the right pane of the dialog window.
Selected Columns You can select one or multiple columns from the available columns to import into the table. You can only select columns that are already present in the table. You can add or remove columns to the selected columns list.
  1. Click Export.
  2. The data from the selected columns of the table is exported into the .csv file.

Related topics

Use Tables

Related Links