...
- Field with empty data mean "ignore this field".
- Put value '=' will remove the current value in system.
- Field with data will be imported.
In case you want to assicate associate a contact to a criteria or structure type. You need to following Follow these links: Contact criteria definition and Structure type definition to create the records.
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. Can be used to link criterion to contact. UPDATEACT: update the contact and reactivate it if needed. DELETE: Applicable to all contacts.
INVALIDATE: Applicable to contact which has no sales.
ANONYMIZE: Applicable to all contacts (even if it has sales).
DROP : Should only be used for mis-import. Applicable to contact that imported and has no modified since then.
|
...
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| PHONE | Text 15 | Landline phone number. Follow standard format and international format. Ex: 01 40 15 80 00, 0169395090, (33)0134806517,... | |
| FAX | Text 15 | ||
| CELLPHONE | Text 15 | Mobile phone Ex: 06 88 48 87 10, (33)0677744594... | |
| EMAIL 1 | Text 250 | 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 validation are different from systemssystem to system. It won't be imported if validation failed (standard email format will be ok, don't worry). | |
| EMAIL 2 | Text 250 | ||
| EMAIL 3 | Text 250 |
...