Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field codeField typeMandatoryDescription
ADDR_TYPEText 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.

LINE1Text 100

Address lines.






LINE2Text 100
LINE3Text 100
ZIPCODEText 10
TOWNText 20
TOWN_COMPLEMENTText 20
COUNTRYCode

Country code using the ISO codes

Example: FR, ES, EN, GB (and not UK), ...

Full name of the country can also be given. They should be written exactly (spaces,hyphens, ...) as they are defined in SecuTix.

By default, the country of the institution is used.

DEPARTMENTCode
TODO: list List of departments to can be provided by SecuTix (internal doc)

Communication means

Field codeField typeMandatoryDescription
TELEPHONEText 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.

Examples

Input countryInput numberStored asRemark
FR01 40 15 80 0033 / 0140158000
FR1 40 15 80 0033 / 0140158000The leading 0 has been added for France
FR0041 21 613 21 1133 / 041216132111Country prefix (41 but looking for 33) could not be recognized
CH

0041 21 613 21 11

+41 21 613 21 11

41 / 0216132111Country prefix could be recognized
FR(41)021613211141 / 0216132111This format allows to force the country code.
FR01 SVP 77 77017777




:

FAXText 15
Fax number. Same rules as for PHONE.
CELLPHONEText 15

Mobile phone. Same rules as for PHONE.

EMAIL1Text 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+_-]+)+$

EMAIL2Text 250

Alternative email address. Cannot be used for login.

EMAIL3Text 250
Alternative email address. Cannot be used for login.

...