Versions Compared

Key

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

...

Field codeField typeMandatoryDescription
TELEPHONEText 15 

Landline phone number. Follow standard format and international format.

Phone number is followed country code where customer located. That information is stored in institution data.

Example:

  • Customer is placed in Switzerland (CH).
  • The data in excel is: 01 40 15 80 00, 0169395090, (33)0134806517...

Result:

  • They're all in valid format and imported.
  • The first 2 are recognized as Swiss phone number.
  • But the last one is stored as France phone number.
FAXText 15  
CELLPHONEText 15 

Mobile phone

Ex: 06 88 48 87 10, (33)0677744594...

EMAIL1Text 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 system to system. It won't be imported if validation failed (standard email format will be ok, don't worry).validated by regular expression: ^[0-9a-z+\$_-]+(\.[0-9a-z+\$_-]+)*@[0-9a-z+_-]+(\.[0-9a-z+_-]+)+$

EMAIL2Text 250  
EMAIL3Text 250  

...