File format for contacts

The generic file format is described in ~Format: Generic for Extended import. This documents describes all available import fields.

Global fields

Field code	Field type	Mandatory	Description
INSTIT	Text 15	Yes	Institution code owning the data to be imported.
ORGANIZATION	Text 15	Yes	Organization owning the data to be imported. A "*" indicates that all organizations of the given institution are concerned.
OPERATION	Enum	Yes	Operation to be executed INSERT : insert the row as a new contact UPDATE : update the contact. The field CONTACT_NR is mandatory. DROP : drop the contact and all its information. The contact is not dropped if it is used in existing sales. The field CONTACT_NR is mandatory.
CONTACT_NR	Text 20	Yes if OPERATION is INSERT or DROP	Contact number. If your contact numbers have leading zeros, they must also be given.
ROLE	Enum		Role of the contact when it is created. If the field is left empty, RELAY will be used when Individual and structure data are given. PUBLIC when only individual or structure data is given.

Field code	Field type	Description
FIRSTNAME	Text	First name of the individual
LASTNAME	Text	Last name of the individual
BIRTHDATE	Date	Birth date