Loader

How to Export table data with the Binary loader

 

What to do:

Manager Information
Please note that you must be logged in to your Agile application as a user with manager privileges to use the loader!
Click to open the table loader utility.
  The load data mask is displayed.
 
Click to insert a new loader object.
In the Name of load object field enter a name for the load object, e.g. TESTITEM. In the Load file field enter the loader file name test_item.bin .
To save the entries click .
 

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 always 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 the default already exists and you want to deactivate the dialog, simply change the settings to any other value than true ( e.g. "truu" or "false"). In this case the dialog will pop up once you have clicked into the Load file field. If you answer with "Yes", the cursor will jump to the next field and the table sublist will be filled with the table names of the loader file. If you answer with "No", the cursor will jump to the next field and the sublists will remain empty!

In the Tablename column enter all the tables you want to export data from.
 
Please note that if you didn't enter any table name the loader will complain. You have to enter table names in the Tablename column as otherwise no export can be performed!
Click to save the table names entered.
Click the export tables button on the Load Data mask to export the data of the tables specified.
  The result of the table data export will be displayed in the Messages field.
  Example:

Exporting records of table: T_MASTER_HIS
Exporting 2126 records of table: T_MASTER_HIS
Exporting records of table: BVB_ARTIKEL
Exporting 686 records of table: BVB_ARTIKEL
Exporting records of table: BVB_ARTMEH
Exporting 585 records of table: BVB_ARTMEH
Exporting records of table: T_CHG_OPR_DAT
Exporting 1989 records of table: T_CHG_OPR_DAT
Exporting records of table: T_MASTER_DAT
Exporting 704 records of table: T_MASTER_DAT
When working with the DTV Client the tables and records that are being processed are displayed as follows:
 

Please note that the numbers in the graphic above should be the same as in the Message field! Here the numbers are just example data!
  For a more detailed look at the exported table data check the loader file test_item.bin.