How to define a dbUPLoader configuration

Select all columns in which you want to import data

First select a table in the left list. In the right list you can mark the available columns. Press the 'ADD' button to choose the column(s) for import. If you want to import data in several tables, repeat this step.

After you have selected the columns, you see an overview in the right top section. Use one of the 'Clear' buttons to remove column(s).

Selected Columns

Mark the selected columns one after another and choose the data source

Select one of the radiobuttons to define the data source.

  • From File

    Select the column in the source file.

  • From Parameter

    Select the index of a parameter. See parameter definition.

  • Next from Sequence

    UPLoader will insert the result of:

  • Current from Sequence

    UPLoader will insert the result of

  • Const. Value

    UPLoader inserts this value in each data set.

  • Query

    Insert the result of the query. See Query definition.


You may set some advanced configurations

  • Separator

    This section doesn't matter if you import MS-Excel files. In case of text files you can select the separator. Default is tabulator.

  • Save order

    If you want to import data in more than one table, define the order of insert statements.

  • Date syntax

    Define your date syntax. UPLoader will detect DATE columns and define a statement like below:

    INSERT INTO mytable (myDateColumn) VALUES ( TO_DATE('FileValue', 'dateSyntax' ))
  • Column title

    Here can define the column titles for the 'File Preview'. This section has no effect to the upload process. With help of this you can check that your source files are conform to the configuration.

  • Advanced

    Skip rows: In case the first row of your source file is a header you can skip this row.

  • Log Errors:

    0 - UPLoader cancel process immediately if an error arises. -1 - UPLoader skips errors und creates a log file. x>0 - UPLoader stops process after a certain number of errors.


Column headers

With help of the last panel within the settings section, you can define the headers within the file preview panel. This enables the end user to check if his source file is in the right format.


! If errors arised, UPLoader always sends rollback at the end of file !