Institution code owning the data to be imported.

Yes

Default: *

Organization owning the data to be imported.

A « * » indicates that all organizations of the given institution are concerned. This is the default value.

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, these fields will be interpolated from the TITLE field, according to the language of the individual.

Ex: if TITLE = 'MR'

→ ADDR_SALUTATION = 'Dear Sir'

→ LETTER_SALUTATION = 'Mr'.

First name

Preferred language.

Use the 2 lettre ISO code. Examples: en, fr, es, it, ...

Official name of the structure. The name will be truncated if it is too long.

Name of the structure for the adresse

If it is empty, it is taken from the official name

The type of the structure. The code must be defined as described in 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