This article is also available in:

Importing subscriptions

For the import of the subscriptions, the tabs 'subscriptions' and 'subscriptionslines' are used. The connection is made on the basis of the 'NR' column. This has to be the same on both tabs so the lines are linked to the right subscription.

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

Subscriptions

Column titles

Column title	Field in Robaws
NR	Number of the subscription
DATE	Date
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
REF	Customer reference
STATUS	Status
REMARK	Remarks
NEXT	Next execution
PERIODICITY	Periodicity (see overview below)
TYPE	Type (see overview below)
DEADLINE	Deadline
ACTIVE	Active ( "Yes" or "No")

PERIODICITY

Possible values for periodicity:

Weekly
Monthly
4 Weekly
Yearly
3 months
6 months
2 Yearly
5 Yearly

TYPE

Possible values for type:

Order
Invoice

The 'NR' column on 'subscriptions' has to contain a unique value, otherwise the import is stopped.

Subscription lines

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

Column titles

Column title	Field in Robaws
NR	Number of the subscription, has to be the same as the 'NR' column on the subscriptions 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

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!