.. _import_date:

Import data
==================

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

.. figure:: img/import_example.png
    
    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.


