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: Applicable to all contacts.

• 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. Applicable to contact that imported and has no modified since then.

• Drop the contact and all its information.
• The contact is not dropped if it is used in existing sales.

Contact number. If your contact numbers have leading zeros, they must also be given.

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

Data will be imported if value is defined.

If value is empty, it will be interpolated from TITLE.

Ex: TITLE = 'MR' --> ADDR_SALUTATION = 'Dear Sir', LETTER_SALUTATION = 'Mr'.

First name of the individual

Language code

Ex: en, fr, es, it...

Structure name

Data will be truncate if length > 100.

Must be predefined in system

See reference page Structure type definition

M: Main address

S: Shipment address

B: Billing address

Ex: M or B or S or MB or MBS, etc...

Leave empty --> that address use for 3 types.

Landline phone number. Follow standard format and international format.

Phone number is followed country code where customer located. That information is stored in institution data.

Example:

• Customer is placed in Switzerland (CH).
• The data in excel is: 01 40 15 80 00, 0169395090, (33)0134806517...

Result:

• They're all in valid format and imported.
• The first 2 are recognized as Swiss phone number.
• But the last one is stored as France phone number.

Mobile phone

Ex: 06 88 48 87 10, (33)0677744594...

Will be used as username for ticket shop login.

If email is already existed, the email is imported but can't be used to login.

The email validated by regular expression: ^[0-9a-z+\$_-]+(\.[0-9a-z+\$_-]+)*@[0-9a-z+_-]+(\.[0-9a-z+_-]+)+$

Accept communication from institution

Formula: CritCode=CritValue1|CritValue2|CritValue3

Special case: If we use CONFIG row which mean:

• CONFIG contains CritCode.
• Contact row contains CritValue1|CritValue2|CritValue3.

Must be predefined in Contact criteria definition