Checking the file format
This option allows to perform several checks on the structure of your file.
When you select Check the file format, the import dialog box appears.
- Click Browse.
- Select the file to import.
The size of the file must not exceed 1kb.
The file format is CSV and its name must respect the rule defined in the chapter Generating a payment file. Example: 20161229.91335531.PAY.REQ.T.01
- Click Check.
If the file is properly structured, the following message appears.
If the file is structured incorrectly, a report appears indicating the detected error and the line that contains it.
The tables below present the different types of errors related to structure.
- File format error
Error message Description The specified file size exceeds the maximum authorized size The size of the file must not exceed 1kb. It is recommended to create the file using programs such as Notepad, Notepad++, etc. Name of the erroneous file Your file does not respect the naming convention as described in the chapter Generating a payment file
- Errors in the Header record line
Error message Description Expected header type (record code 00) The first line of the file corresponds to the header record and must start with 00 Badly placed header (should be on the 1st line) Invalid number of columns The header record must include 8 columns. PAY not present in the header (null) The field n°2 of the header record must be populated with PAY Incorrect header version (null) The field n°3 must be populated with 01 Incorrect shop identification (null) The Shop ID must contain 8 digits Incorrect environment (null) Two possible values: TEST or PRODUCTION Only transactions in TEST mode are possible You cannot submit a payment file in PRODUCTION mode. Incorrect creation date or time
The date lust have the yyyyMMdd format.
The time lust have the HHmmSS format.
Execution date not empty This field must not be populated. It must remain empty. Header does not match filename The header and the filename must contain the same values of:
- the shop ID,
- the environment,
- the creation date.
- Errors in the Detail record line
Error message Description Bad sequence number (field 2) Must start with 1.
Given that the format (n..6) of the sequence contains 6 digits, it is safer to number the sequences 000001, 000002, etc. to avoid errors.
Invalid number of columns Each detail record must include 16 columns.
- Errors in the Trailer record line
Error message Description No trailer (record code 01) The last line of the file must contain the trailer and start with 01. Invalid number of columns The trailer record must include 2 columns. Bad record number Must be equal to the exact number of transmitted detail records. When the detail record contains:
- One record line, the value is 1.
- Two record lines, the value is 2.
- Three record lines, the value is 3.
- Other technical errors
Error message Description Unknown line type None of the lines appearing before the trailer record of the file must be empty. All lines must start with 00, 01 or 02. Data after end of file No lines (empty or not) must be present after the trailer record.