Understanding the file formats

A CSV file is a comma-separated values file. CSV files have the file extension .csv.

CSV files are plain-text files used to save data in a tabular format. CSV files are typically spreadsheet files that can be used with most spreadsheet programs, such as Microsoft Excel or Google Spreadsheets. They can be used to import or export a high volume of data to a database.

A CSV spreadsheet contains only a single sheet. Cells, columns, rows and formulas cannot be saved in CSV spreadsheet files.

Source data file

Example

H

B

 

A

 

 

A

 

END

C

 

Supplier code

 

Address

Address line

 

Address

Address line

 

B

FR001

A

1

Nantes

A

2

New York

 

B

FR002

A

1

Paris

A

2

Barcelona

Columns B and A

The letters B and A correspond with our Source data file example above. These values will be different in different templates.
  • B indicates a new supplier.
  • A is a header column. Each column following an A column corresponds to an address value. Several addresses can be added.
    • The A value must always be defined. In our example, one or two addresses can be defined.
  • A, when different from the header, is only populated when a corresponding address exists. This value can be empty.

CSV file format: Single-line

H;B;;A;;;A;;END
C;;Supplier Code;;Address;Address line;;Address;Address line
;B;FR001;A;1;Nantes;A;2;New York
;B;FR002;A;1;Paris;A;2;Barcelona

In this file:

  • Two single lines correspond to two suppliers - FR001 and FR002.
  • Each supplier has two addresses.

The Single line files conversion function (AIFIMPGENFIC) converts the single-line file into a multi-line file that must comply with the standard supplier import.

Destination data file

Example

B

FR001

 

A

001

Nantes

A

002

New York

B

FR002

 

A

001

Paris

A

002

Barcelona

CSV file format: Multi-line

B;FR001;
A;1;Nantes;
A;2;New York;
B;FR002;
A;1;Paris;
A;2;Barcelona;

The generated destination file complies with the format of the BPS - Suppliers import template.

This example uses a simplified Supplier import template to provide a clearer understanding. This modified BPS - Suppliers template does not work. You must use the BPS - Suppliers template supplied with your system.

B

BPSUPPLIER

/

 

B

BPSUPPLIER

BPSNUM

Supplier

A

BPADDRESS

/

 

A

BPADDRESS

BPAADD

Address

A

BPADDRESS

BPAADDLIG(0)

Address line