Loader

How to Import table data with the Binary loader

 

What to do:

Please note that you must be logged in to your Agile application as a user with manager privileges to use the loader!

Please note that prior to any user data import, the repository data (entity, table, field ...) must exist. Also it must be checked if the tables and fields have been created on the database. This is an assential prerequesite for any data import as otherwise the loader won't be able to identify the type of data to be imported!
  With the binary loader you can import table data in both internal and external mode.

 

Importing table data in internal mode

Click to open the table loader utility.

Search for the loader file test_item.bin.

 

If the loader file already exists, a dialog pops up asking you if you want to keep the query definitions of the loader file or not.

 
  • If you choose no (you don't want to keep the query definitions), nothing happens. This is usually the answer if you want to export data and just want to use the same loader file (The file will be overwritten!).

  • If you choose yes (you want to keep the query definitions), the query definition of the loader file is added to the sub widgets. This is usually the answer if you want to import data. In case you have already exported data and realize you miss something, this would be the right choice as well, because all possible existing entries in the subwidgets remain untouched.
  Please note that it is possible to permanently suppress the appearance of the dialog. To do so, you need to create the default LOA-REA-ALWAYS with type s and value true.
Once this default exists and the value is set to true, the dialog is suppressed and the loader file is read for import. If you click into the Load file field and press the tab, the cursor will jump to the next field and the table sublist is filled with the table names of the loader file.
If necessary, enter additional query values in the respective fields.

Click the import/update button to update the already existing table data.
 

The result of the import/update operation will be displayed in the updates column as depicted below.

 
 

Importing table data in external mode

Open the command line/shell and enter the following parameters:

  UNIX:
  dtv_ora <application_name> <dtv_user> -c LOAD "DTVLoad test_item.bin test_item.log"

  Windows:
  dtv_ora_vc8 <application_name> <dtv_user> -c LOAD "DTVLoad test_item.bin test_item.log"
 

The output parameter is always a logfile. In case it is not set in the command line, the results of the data import will be displayed on the screen as follows:

Load file test_item.bin

Importing records into table: T_MASTER_HIS: O
Importing 1 records into table: T_MASTER_HIS: U
Importing 5records into table: T_MASTER_HIS: I