...
| Field code | Field type | Mandatory | Description | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| TELEPHONE | Text 15 | Landline phone number. Following formats will be recognized. These examples assume country FR (country of the address, or by default the country of the institution). The initial << + >> sign will be recognized as well as 00. The country prefix can be forced if it entered in parenthesis at the beginning. All other non digit signs are ignored. The national prefix (0 for CH, FR, 1 for US, 9 for ES, etc. see COUNTRY table) will be automatically removed in the database if present in the input number. Examples
| |||||||||||||||||||||||||||||||||
| FAX | Text 15 | Fax number. Same rules as for PHONE. | |||||||||||||||||||||||||||||||||
| CELLPHONE | Text 15 | Mobile phone. Same rules as for PHONE. | |||||||||||||||||||||||||||||||||
| EMAIL1 | Text 250 | Will be used as username for ticket shop login. If email does already exist in the database, the email is imported for the contact but can't be used to login. There no possibility to import a list of passwords. Each new contact will need to request a password change (click on Have you forgotten your password ?) The email validated by regular expression: ^[0-9a-z+\$_-]+(\.[0-9a-z+\$_-]+)*@[0-9a-z+_-]+(\.[0-9a-z+_-]+)+$ | |||||||||||||||||||||||||||||||||
| EMAIL2 | Text 250 | Alternative email address. Cannot be used for login. | |||||||||||||||||||||||||||||||||
| EMAIL3 | Text 250 | Alternative email address. Cannot be used for login. |
...