Usage > Imports / exports > Single line files conversion 

Important

Refer to the Importing single line files documentation which describes this function in detail. Click the link that applies to your Sage X3 solution:


Use this function to simplify the format of files submitted for import.

The Single line files conversion function (AIFIMPGENFIC) will convert a single-line comma-separated values (CSV) file format to a CSV file format with multiple lines. Multi-line CSV files are compatible with Sage X3 imports.

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, enter a backslash followed by three 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 a backslash followed by three numbers representing the ASCII code of the character with decimal bases.

The commonly used separators are:

  • The line feed character (\010), which corresponds to the end of the line in Unix text files
  • The combination of the two carriage return and line feed characters (\013\010), which 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 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 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, Chinese characters.
  • UCS-2 corresponds to Microsoft's standard format where characters are systematically stored on two 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'.

Close

 

Error messages

The only error messages are the generic ones.

Tables used

SEEREFERTTO Refer to documentation Implementation