...
A contact can be Individual or Structure so for Contact creation case: At least FIRSTNAME, LASTNAME or STRUCT_NAME must have data.
| Note |
|---|
- If first name/ last name is filled and structure name is blank → Individual will be created. (1)
- If structure name is filled and first name + last name is blank → Structure will be created. (2)
- If structure name and first name/ last name are filled → Structure + Relay will be created. (3)
- Address applies to both structure and relay.
- Communication mean (Phone/ Email...) information on contact applies to both relay and structure.
- Authorization only applies to relay.
- Contact criterion: Depends on contact type. If contact type is Structure, then applies to Structure only. If contact type is Both/ Individual, then applies to Relay only.
Comparing 2 records which have the official name filled (can be (2) or (3)), based on structure information (official_name, address_name1, address_name2) + Address information (line1, line2, line3, zipcode, town, town_complement, country) → Decide if the same structure or different structures.
If relay has different address with structure, create a new data file with the operation "UPDATE" in order to update the address for relay.
Same rule with Communication mean (Phone/ Email...)
|
In case you want to associate a contact to a criteria or structure type. Follow these links: Define criteria's for the contacts and Define type of structure to create the records.
Examples
Contact import template full.xlsx
structure types template.xls
contact criteria import template.xls
Global fields
| Field code | Field type | Mandatory | Description |
|---|
| INSTITUTION | Text 15 | Yes | Institution code owning the data to be imported. |
| ORGANIZATION | Text 8 | 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 | Enum | Yes | 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.
CONFIG: Configuration line for admin numbers and criteria. - If the codes are defined on this row, then the fields can contain only the value instead of the CodeValue.
- The configuration remains valid until a new configuration line
- Initially, no codes are defined, forcing the CodeValue format.
|
...