...
The generic file format is described in Generic file format (Extended). This documents describes all available import fields.
In general:
- Field with empty data mean "I don't want to do anything with the field".
- Field with data will be imported.
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: Application 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. Application to contact that imported and has no modified since then.
|
...
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| CONTACT_NR | Text 20 | Yes if OPERATION is not INSERT | 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. |
| ROLE | Enum | Role of the contact when it is created. If the field is left empty, RELAY will be used when Individual and structure data are given. PUBLIC when only individual or structure data is given. | |
| TITLE | Text 20200 | Data will be imported if value is defined. If value is empty, it will be taken interpolated from other field. | |
| LETTER SALUTATION | Text 20200 | ||
| ADDRESS SALUTATION | Text 20200 | ||
| FUNCTION | Text 201000 | ||
| REMARK | Text 2000 |
Individual
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| FIRSTNAME | Text 100 | First name of the individual | |
| LASTNAME | Text 100 | Last name of the individual | |
| BIRTHDATE | Date | Birth date | |
| PREFERRED LANGUAGE | Text 2Code | Filled with country code | |
| PHOTO PATH | Text 2000 |
Structure
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| STRUCTURE NAME | Text 100 | Data will be truncate if length > 100. | |
| ADDRESS NAME 1 | Text 38 | Taken from structure name if not defined (first 38 characters) | |
| ADDRESS NAME 2 | Text 38 | Taken from structure name if not defined (next 38 characters). | |
| STRUCTURE CODE | Text 8Code | Must be predefined in system | |
| COMMUNITY TYPE | Code | Must be predefined in system | |
| ADMIN NUMBER | Code | ||
| NB EMPLOYEES | Number | ||
| WEBSITE | Text 2000 |
Address
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| ADDRESS TYPE | Text 3 | 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. | |
| LINE 1 | Text 100 | TBD with max length | Anything. Customer responsible for correct data. |
| LINE 2 | Text 100 | ||
| LINE 3 | Text 100 | ||
| ZIPCODE | Text 10 | ||
| TOWN | Text 20 | ||
| TOWN COMPLEMENT | Text 20 | ||
| COUNTRY | Text 2Code | Country code (TBD: table mapping for referenced) |
...
| Field code | Field type | Mandatory | Description | ||||
|---|---|---|---|---|---|---|---|
| PHONE 1 | Text 13 | Landline phone number.TBD: phone format. | |||||
| PHONE 2 | Text 13 | Landline phone number. TBD: phone format. | |||||
| PHONE 3 | Text 13 | Landline phone number.TBD: phone format. | |||||
| FAX | Text 10 | ||||||
| CELLPHONE | Text 13 | Mobile phone | |||||
For fields above:
| |||||||
| EMAIL 1 | Text 50 | Will be used as username for ticket shop login. If data email is already existed, the email is imported but can't be used to login. The email validation are different from systems. It won't be imported if validation failed (standard email format will be ok, don't worry). | |||||
| EMAIL 2 | Text 50 | ||||||
| EMAIL 3 | Text 50 | ||||||
Authorization
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| CNIL_O | Boolean | TDB: mean? | |
| PARTNER | Boolean | ||
| CNIL_T | Boolean | ||
| SMS_MMS | Boolean | ||
| LETTER | Boolean | ||
| PHONE | Boolean | ||
| Boolean |
...