Skip to Content

Import-export format "Standard" for Batch and serial numbers

1576  Batch - Serial number

Here's a description of the predefined "Standard" import and export format for the Batch and serial number file.

The import/export file is in text format, with a tab mark between fields and a line feed between records. The character table can be UTF-8, Windows or macOS.

To import data into the software, the most common method is to prepare the file to be imported with a spreadsheet program such as Microsoft Excel or LibreOffice Calc, which make it easy to define the order of fields by moving columns. To this end, the first column in the table below contains the letter of the column in which the field is to appear.

The order of fields is predefined:

Column Field Remark
A Item code The corresponding item record must exist in the database and the item must be traceable (if these two conditions are not met, an error is signalled in the import log).
B Batch/serial number Obligatory value
C Label

On export, if the field is empty, it is replaced by the long label in the base language of the data file.
D Manufacturer  
E Origin  
F Date of manufacture  
G Due date  
H End date for sale  
I Expiry date  
J Description

On export, any line feed is replaced by the Ω character. On import, the Ω character is replaced by a line feed.
K Remarks

On export, any line feed is replaced by the Ω character. On import, the Ω character is replaced by a line feed.

Remarks

When a master record already exists with the item code and batch/series number, it is updated. When there are duplicates, the record is not imported, and the error is indicated in the import log.

Leading and trailing spaces in the item code and batch/series number are automatically deleted during import.

The length of the item code is limited to 24 characters, the length of the batch/series number is limited to 60 characters. Values that are too long are not imported (errors reported in the import log).

Dates must be in DD.MM.YYYY format.

The lists of values listed for the Manufacturer and Origin fields are updated when new values are imported.

This import-export format is available from Business version 7.0.

 
Import-export format "Standard" for Batch and serial numbers