Institution code owning the data to be imported.

Organization owning the data to be imported.

A "*" indicates that all organizations of the given institution are concerned.

Operation to be executed

INSERT : insert the row as a new contact

UPDATE : update the contact. Can be used to link criterion to contact.

UPDATEACT: update the contact and reactivate it if needed.

DELETE: Delete the contact address, communication mean.

• For authorization and criterion value. Only delete the value that specified in excel file.
• The email will be empty and contact can't be login to ticketshop anymore.
• This action is irreversible.

INVALIDATE: Applicable to contact which has no sales.

• Just mark contact as invalid with reason: ACCOUNT_DELETED.
• All other information are in tact (not removed).

ANONYMIZE: Applicable to all contacts (even if it has sales).

• All contact information is deleted. Contact name is changed in to 'XXXXXXXX'.
• Set contact as ACCOUNT_DELETED and remark contact with 'Contact anonymized'.
• The contact's sales information are in tact (not removed).
• This action is irreversible.

DROP : Should only be used for mis-import

• Drop the contact and all its information. The contact is not dropped if it is used in existing sales.
• The contact row is removed from system forever.

Note: The field CONTACT_NR is mandatory for all OPERATION that is not INSERT.

First name of the individual