> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://support.robaws.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Importing equipment

| Do read the [general information about data import](https://support.robaws.com/en/article/import-general-explanation-18g6g1c/) in Robaws as well.

### Column titles
| Column title | Field in Robaws |
| ---- |
| UPDATE_BY | Field that is used for the update |
| NAME | Name |
| BARCODE | Serial number |
| BRAND | Brand |
| ARTICLENR | Item number, has to be the same as the column 'NR' in the tab articles |
| SUPPLIERNR | Supplier number, has to be the same as the column 'NR' in the tab suppliers |
| SUPPLIERNAME | Supplier name, has to be the same as the column 'NAME' in the tab suppliers |
| STATUS | Status |
| PLANNINGGROUP | Planning group |
| EMPLOYEENR | Employee |
| PROJECTNR | Project number, has to be the same as the column 'NR' in the tab projects |
| CLIENTNR | Customer number, has to be the same as the column 'NR' in the tab clients |
| CLIENTNAME | Customer name, has to be the same as the column 'NAME' in the tab clients |
| OA | Subcontracting supplier number, has to be the same as the column 'NR' in the tab suppliers |
| ID | Id from the database, is used for the update. You can find it in the Excel export |
| OANAME | Name of the subcontractor |
| STREET | Street and house number |
| ZIPCODE | Postcode |
| CITY | City |
| COUNTRY | Country |
| LOCATION | Location |
| COMPANY | Company name |

### UPDATE_BY

For equipment, the update can be carried out on the basis of 3 fields:
* ID :
The most accurate way to update existing equipment, because the id is always unique. You find the id in the export of the equipment.
* NAME:
The equipment is looked up on the basis of the name.
* BARCODE
The 3rd way is on the basis of the barcode, and is only possible if you work with barcodes.

||| So in the UPDATE_BY column you fill in ID, NAME or BARCODE, and not the value of the field — you do that in the column concerned.