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 |
![]() |
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. |
|
|
|
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 |