Importing Data to Datatable from CSV File

Data can be imported to datatables from CSV files using the Workspace screen. Import is done as follows:

On the left side projects hierarchy, select the project where the target datatable is located.
Open the Datatables tab.
Select the datatable where to import data.
Click the Import button.
Select the CSV file to be imported, adjust data type and conversion settings if needed, and click Start import.

Import Settings

The data import dialog has the following settings:

Select CSV file: Button to select the CSV file. You can use this button to change the CSV file if you want to change the file.
Column separator: Column separator character used by the CSV file. The column separator is automatically detected when the file is selected. In some cases, the automatic detection does not find the correct column separator, and this selection allows to change the column separator. If you want to use space as a column separator, select <space>, or if you want to use tabulator, select <tab>. Note that when changing the column separator, all column specific settings in the table are reset.
Skip errors: Allows to continue the import when encountering errors and import null values in place of cells where the conversion could not be made. If error skipping is not in use, the import will stop to the first encountered error. The data conversions are checked before importing actual data to the datatables, so data conversion errors will not lead to partially done imported.
Character encoding: Character encoding used by the CSV file. Most text files use UTF-8 encoding which is the default. If some of the characters in the CSV file look incorrect in the table preview, try to change other character encoding to find the correct one. Note that there is no automatic detection of the character encoding. Note also that changing the character encoding will reset all column specific settings