This article is also available in:

Importing equipment

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

For equipment, the update can be carried out on the basis of 3 fields:

The most accurate way to update existing equipment, because the id is always unique. You find the id in the export of the equipment.

The equipment is looked up on the basis of the name.

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.

Updated on: 09/09/2026

Was this article helpful?

Thank you!