16. Import data

This tool is used to import data from a file into a table. Import from XLSX, XML and CSV files is supported.

_images/import_example.png

Fig. 16.1 Example of filling in fields for import

Data import parmeters:

  • Import from the connection - Allows to select the database as source.

  • Data file - Path to data source file. Import from XLSX, XML and CSV files is supported.

  • Blob file - Path to source file with blobs (with .lob extension).

  • Target connection - Database the import will be performed to.

  • Target table - Table the import will be performed to.

  • Separator - Type of data separator in CSV files.

  • Page number - For XLSX files allows to select the page of excel-file to import data from.

  • First row - Row starting from which data will be imported.

  • Last row - The row after which data import will be stopped. Rows that do not fall in the range between the first and last imported row will be ignored.

  • Commit step - The number of records after which the transaction will be commited and data will be saved in the table.

  • Erase table before import - Defines if target table should be cleared of data that was in it before import.

  • Source column - Column name from which data should be imported. The Correlate button automatically assigns the imported columns to the target columns by their names.

  • Properties - Import BLOB as a file or as text.