Notes on uniqueness when exporting user data In logical import DataView assigns new ident numbers in the target system. The precondition for that is the uniqueness of the table data in the loader file. DataView assures this by automatically detecting key fields during export and marking them with a (*) symbol. Because the binary loader file is not editable, it is now important to assure uniqueness of table data before exporting. Please observe the following notes: Master tables Relation tables n:m Relation tables 1:n to the zero entity Type tables |
|
Selection criteria You can limit data export by specifying selection criteria. The binary loader offers essentially extended selection criteria. You can specify limitations not only regarding owner-user/group or date of creation/update, but also regarding any internal system fields or application-specific attribute fields. In the list you choose selection fields and enter the desired search terms for each field. Search terms for several fields are AND-combined and the conventions for search terms correspond to those of the -> standard function Query. Depending on the tables to be exported, the choice box at the field fieldname offers all fields available for defining selection criteria. This results in different opportunities to limit export to certain data: DataView system fields global (C_VERSION ... C_ACC_OGW) DataView system fields for each individual table (TABLE NAME.C_VERSION
... TABLE NAME.C_ACC_OGW) Application-specific attribute fields (TABLE NAME.COLUMN NAME) Joins for each individual table (TABLE NAME-<JOIN) Links for each individual table (TABLENAME-<CONS) |
|
![]() |
Attention! Tables containing a BLOB field can not be exported as dependent tables with the binary loader (link via "TABLE NAME<JOIN" or "TABLE NAME-<CONST"). Currently this behavior cannot be changed! |
Automatic pre-assignment of fields When exporting table fields you can automatically assign pre-defined values to table fields now. In the list you select fields and enter the required pre-assigned texts. Depending on the tables to be exported the choice box at the field fieldname offers the following fields: DataView system fields global (C_VERSION ... C_ACC_OGW) DataView system fields for each individual table (TABLE NAME.C_VERSION
... TABLE NAME.C_ACC_OGW) Application-specific attribute fields (TABLE NAME.COLUMN NAME) |
|
![]() |
The pre-assignment of date fields must be done using the database date format YYYY-MM-DD HH:MM:SS. |
You can define an automatic pre-assignment of fields for export, depending on whether the loader files already contain the pre-assignment |