Data Importer

Data Importer is a tool for uploading data into the database. It can upload :

Access Data Importer

Data Importer can be accessed in two ways:

  • From the Application Menu > Data Tools > Import Data From File
Database Data Importer
  • From the right-click table pop-up choose 'Import Data From File'
Database Data Importer

Load the Data

In the Data Loader dialog:

  1. Choose the file path and the type of character;
  2. Select the schema;
  3. Choose whether you want to import data in an existing table or create a new one.
Import data into the database
In the Settings dialog, you can match the file columns with the database columns ( if the table already exists ) or edit the column definition if the column is new.
The other settings are for:
  • The First Line is the Header - If yes, the first line data won't be imported and used for setting the initial column names.
  • Using the Edit button you can:
    • Edit the separator character - is the character separating data values inside one record. This is usually comma ',', tab \t, ; or |. We try to automatically detect this character but this may be wrong.
    • Edit the quote char - some values may be quoted to make possible including separator characters in a value field. For example, if you use quotes, "Andre,Mike" will be a single filed.
    • Edit the escape character - quote character can be used as well inside the data field, but it has to be escaped. "Andre,\"Mike" is a valid construct, the " inside is escaped.
  • Date format and locale - if the data contains dates, time, or timestamp fields, this is the date, time, or timestamp format. Hover the label tip icon to see few examples. Check in Google for 'SimpleDateFormat Tutorial' to read more. The combo box is editable, so you can edit the pattern.
Database Import Settings
If you import data into a new table, the column editing won't be applied in the database. The table will be created first when you start loading the data.

If you choose to import data into an existing table, changing the column definition will change also the column in the database ( if your model is online ).

After starting the load operation, the load errors and the line numbers will show in the Error pane.