How to define a UPLoader configuration

  1. 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).

  2. 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:
      SELECT seq_name.NEXTVAL FROM DUAL

    • Current from Sequence
      UPLoader will insert the result of
      SELECT seq_name.CURRVAL FROM DUAL

    • Const. Value
      UPLoader inserts this value in each data set.

    • Query
      Insert the result of the query.
      See Query definition =>.

  3. You may set some advanced configurations

    4. 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.

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