Export

• Template to use (field MODELE)

Corresponds to the implemented import-export template.

• Chrono management (field CHRONO)

If this checkbox is activated, the export is only carried out on the records modified since the last export. The operating principle of this export mode is the following:

• an adonix counter (numerical variable common at a given moment to all the workstations of a folder, stored in the database, with the name [C]EXPORT), serves as a time basis (it is incremented each time an export with event management is launched).
• the current value of the counter [C]EXPORT) is picked up in the records of the database when a creation or an update is carried out. This mechanism applies to all the tables used to perform a chronological export (all the database tables and transaction headers include this field: this represents nearly half the tables in the database). The corresponding field is called EXPNUM.
• during the chronological export, the current value of the EXPORT counter is stored in the import/export template, then it is incremented and are exported only those records in the database with an EXPNUM field value smaller than or equal to the EXPORT field value before incrementation, and strictly bigger than the last value previously stored in the template.

When an export with event management is carried out, it is possible to use the # meta-character in the name of the file to be exported; this character is then replaced by the current value of the EXPORT counter formatted over 4 characters. Thus, the file name donnees#.asc will be replaced by donnees00001.asc, donnees00023.asc, etc., based on the counter value.

Of course, the EXPNUM field must exist in the table linked to the exported object for this type of import to exist. If it exists, it is automatically entered by object management, therefore it can be used for exports of this type.

The current value of the [C]EXPORT counter can be modified in the import-export parameters.

• field TYPEXP

• Data file (field VOLFIL)

• Field (field BNOM)

This field defines the name of the field for which a range can be entered.

• Start (field BDEB)

Used to enter lower and upper ranges on a group of fields of the template, in order to limit the data to be exported. If this range is not assigned, no filtering is carried out on the field concerned.

• End (field BFIN)

• Tables (field FICHIER)

The tables used in the import/export template are listed here to enable the filtering of the exported data.

• Selection criterion (field CRITERE)

Used to define additional criteria to filter the data to be exported for the table concerned, in the form of logical expressions that must be checked and that can use the table fields.