This article is also available in:

Importing work orders

For the import of the work orders you can use 3 tabs in the Excel. 'timetickets' contains the general information of the work order. With 'timetickethours' you can pass on the hours achieved. Finally there is 'timeticketlines', which lets you import the materials of the work order.

Make sure you also read the general information about data import in Robaws.

Work orders

Column titles

Column title	Field in Robaws
NR	Number of the work order
TITLE	Title
DATE	Date
PROJECTNR	Project number, has to be the same as the 'NR' column on the projects tab
CLIENTNR	Customer number, has to be the same as the 'NR' column on the clients tab
CLIENTNAME	Customer name, has to be the same as the 'NAME' column on the clients tab
STATUS	Status
CLIENTREF	Customer reference
REMARKS	Remarks
ENDCLIENTNR	Endcustomer number, has to be the same as the 'NR' column on the clients tab
ENDCLIENTNAME	Endcustomer name, has to be the same as the 'NAME' column on the clients tab
SALESORDERNR	Order number

Work order hours

You enter the work order hours on the 'timetickethours' tab. The 'NR' column is always mandatory because it is what makes the link with the work order.

Column titles

Column title	Field in Robaws
NR	Number of the work order, has to be the same as the 'NR' column on the timetickets tab.
EMPLOYEENAME	Name of the employee, this has to be the unique first name of the employee.
HOUR_CODE	Item number of the hour code. This is the 'item nr.' field on the item of the hour code.
DESCRIPTION	Description
PAUSE	Pause
HOURS	total hours worked (enter as a decimal number)
COSTPRICE	Cost price
PRICE	Price
STARTHOUR	Start time
ENDHOUR	End time
EMPLOYEEID	ID of the employee
HOUR_TYPE	Hour type
ACTIVITY	Activity
BILLABLE_HOURS	Billable hours

Hours are entered with the HH:MM notation as text in the Excel. For example 7:30

Work order materials

The 'NR' column is always mandatory because it is what makes the link with the work order.

Column titles

Column title	Field in Robaws
NR	Number of the work order, has to be the same as the 'NR' column on the timetickets tab
AMOUNT	Quantity
UNITTYPE	Unit
LINE_TYPE	Line type - You have to enter a specific value for this. (see below)
PRICE	Price
COSTPRICE	Cost price
BTWTYPE	VAT tariff
DESCRIPTION	Description
EXTRADESCRIPTION	Extra description
CHAPTER	Post number
ACTIVITY	Activity
PROJECTNR	Project number, has to be the same as the 'NR' column on the projects tab
ARTICLENR	Item number, has to be the same as the 'NR' column on the articles tab
AGREEMENTTYPE	Type (SOG, FH, ... )
MATERIALNR	Serialnumber of the equipment
INSTALLATIONNR	Serialnumber of the installation

VAT tariffs are entered as a text, not as a percentage, for example: 21, 6, none, shifted, ..For the activities, Robaws looks for a match in the database. If an exact match is found, it is linked to the item. If not, a new item is created that is linked to the item straight away. Please note, the search is case sensitive!

Line type

Line: P
Title: H
Total: T
Quantity: A
Check: C
Variant: V
Text: Tx
Chapters: H1, H2, H3, H4, ...

Updated on: 09/09/2026

Was this article helpful?

Thank you!