Usage > Imports / exports > Linked imports 

This function is used to integrate the database data from the ASCII files according to the structures described by a group of import/export templates identified by a sequence code.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

Entry screen

Presentation

The screen that opens is used to enter the parameters related to the requested import. This done, the import sequence procedure is launched.

When it is complete, a window opens that displays a log file containing a summary of the operation (in principle, there is a line by file, with a message such as NNN lines imported and one line when the transfer of the file to the final directory when a temporary directory is used). In case of error, an error box will open before the display of the log file.

Close

 

Fields

The following fields are present on this tab :

Block number 1

  • Sequence code (field CODE)

This is the code defining both the list of templates to be used and the file path to be considered during the import/export operation. This file path cannot be modified, it is defined in each import/export template, either in the form of an absolute file path or in the form of a relative file path (in this case, it will be looked for in the directories defined in the import/export parameters).

Block number 2

  • Test mode (field TEST)

If this check box is activated, only the decoding of the files will be carried out, but not the integration of the data in the database.

The parameters entered, the import sequence is launched with two cases possible :

  • or it has only been launched in text mode. In this case, a window opens, displaying the first record (or group of records) to be read in the first file, When the key is used, the read takes place and the next group of data is read ; the use of the key is used to pass to the next file, the display stops when all the files have been viewed.
  • or it has been launched to real mode. In this case, the data is integrated in the database and when the import sequence is complete, a window opens to allow the viewing of the log file for the operation.

Close

 

Batch task

This function can be executed in batch mode, but no dedicated standard task is delivered to execute it.

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation