Field formats define how values from the Excel file are interpreted and converted during import.
Formats should be selected from the list provided by the system.
When a value is selected in the Local Field column, the system usually fills in the corresponding format automatically. The user can change the suggested format or specify a format manually if required.
The most frequently used formats are available in the Common Formats folder.
Common formats include:
| Batch by Description | Batch (description) |
| Bin Location | connected to bin location (if setting is switched on) |
| Boolean | True/ False values |
| Characteristic by Description | Characteristics |
| Date DD-MM-YYYY | date format (example - 11-02-2024) |
| Date DD.MM.YYYY | date format (example - 11.02.2024) |
| Date DD/MM/YYYY | date format (example - 11/02/2024) |
| Date MM-DD-YYYY | date format (example - 02-11-2024) |
| Date MM.DD.YYYY | date format (example - 02.11.2024) |
| Date MM/DD/YYYY | date format (example - 02/11/2024) |
| Date YYYY-MM-DD | date format (example - 2024-02-11) |
| Date YYYY.MM.DD | date format (example - 2024.02.11) |
| Date YYYY/MM | date format (example - 2024/02) |
| Date YYYY/MM/DD | date format (example - 2024/02/11) |
| Document Number | 00-00000004 |
| Enum Value | Numeric format |
| Item by SKU | SKU |
| Master Data Reference by Code | Information from connected Catalog (connection by Code of element) |
| Master Data Reference by Description | Information from connected Catalog (connection by Description of element) |
| Number | Numeric format - 19, 19.43 |
| String | Text format |
| Unit of Measure | UOM - pcs, kg, etc. |
| VAT Rate | Vat rate (with % symbol) - 5%, Out of Scope, etc. |
| World Country | Name of Country - UAE |
Note
The Fields tab controls data mapping between Excel columns and system fields.
If imported values require additional validation, calculations, object creation logic, or other specific processing, use import handlers.
But there are also formats related to specific system objects in another folders.
And if user needs to create new import template to upload data into.
For example, Employees catalog - it is necessary to use format from Employees group:
Thank you for being FirstBIT customer!