Single line files conversion

Screen management

Entry screen

Presentation

Use this screen to:

Define the general structure of the file to be converted.
Specify the source for storing the files to be converted and the resulting converted files (client or server).
Launch the file conversion.

Close

Fields

The following fields are present on this tab :

Structure

Field separator (field SEPFLD)

Specify the character used as the separator between two fields.

To enter a non-printable character, it is necessary to enter the '\' symbol (backslash) followed by 3 numbers representing the ascii code of the character with decimal bases.

Record separator (field SEPREC)

Specify the separator used between two records (data groups).

To enter a non-printable character, enter the '\' symbol (backslash) followed by 3 numbers representing the ascii code of the character with decimal bases.

The commonly used separator is:

the line feed character (\010), that corresponds to the end of the line in Unix text files,
the combination of the two characters carriage return, line feed (\013\010)n that corresponds to the end of the line in Windows text files.

File format (field CODDBA)

Enter the format of the characters used in the file:

ASCII

This is the standard format where a character is equivalent to a byte in the file. This type of format is used to deal with traditional occidental characters, with different possible character sets, defined in the corresponding field.

UTF-8

This format corresponds to a Unicode format where the number of characters varies (from 1 to 4: 1 corresponding to the non-accentuated Latin character set). This format makes it possible to deal with all types of characters, for instance the Chinese characters.

UCS-2

This format corresponds to the Microsoft standard format where characters are systematically stored on 2 bytes.

Source

field TYPEXP

Select the file source:

Customer

Select the file to be converted after clicking OK.

Server

Select the file to be converted in the next field.

Data file (field VOLFIL)

Select the file to be imported from the X3 volume on the server where the file was dropped.
This field is mandatory and can only be accessed if you select Server as the source for storing the files.

Destination

Data file (field NOMGEN)

This field is not available for entry. It displays the location and name of the file generated after conversion.

The file is located on the same volume as the source file.
The file name is the same as the source file but ends with the extension: .out
For example, if the source file name is 'BPS.csv', the converted target file name will be 'BPS.csv.out'.