Table Import Form (ASCII Loader)

The table import form is used to import table data from a loader file (ASCII file) into existing database tables. Different load modes can be selected.

Attention! The ASCII Loader does not import loader files, which were produced with the Binary Loader.


Fields and Functions

Import file name name of the loader file to be imported
Import load mode import load mode to control the import process

Import File Name

Name of the loader file to be imported

type, entry string, entry required
max. no. of characters 20
selection tool no
multilingual field no

Only the name of an existing loader file can be specified. The default name is export.dat. The directory path is selected in the filepicker widget.

Import Load Mode

Import load mode to control the import process

type, entry radio-buttons, entry required

Import modes:

U -> Update
Replaces all records in the master table of the target systems, whose key-field entries correspond (all fields marked with the index symbol (*) in the loader file). Records in relation- and type tables are only replaced by DataView if the corresponding parent and child elements exist in the master table.

I -> Insert
Loads all records of the loader file in addition to existing records in the target table. If the target table already contains records with defined key field entries (all fields marked with the index symbol (*) in the loader file), these and their linked records are not imported.

O -> Overwrite (combination of U and I)
Loads all records of the loader file in addition to existing records in the target table. If the target table already contains records with defined key field entries (all fields marked with the index symbol (*) in the loader file), these will be overwritten by records of the loader file.

R -> Replace
First, deletes all records in the target table specified in the export process, which correspond to the selection conditions for owner, group, date of creation and date of last update. Then DataView loads all records of the loader file in addition to existing records in the target table. If the target table already contains records with defined key field entries (all fields marked with the index symbol (*) in the loader file), these and their linked records are not imported.