Versions Compared

Old Version 35

changes.mady.by.user Alwin DIEPERINK

Saved on

compared with

New Version 36

changes.mady.by.user Alwin DIEPERINK

Saved on

Key

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

...

Field codeField typeMandatoryDescription
CONTACT_NRText 20Yes 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.

ROLEEnum 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.
TITLEText 200 

Data will be imported if value is defined.

LETTER_SALUTATIONText 200 

If value is empty, these fields will be interpolated from the TITLE field, according to the language of the individual.

Ex: if TITLE = 'MR'

→ ADDR_SALUTATION = 'Dear Sir'

→ LETTER_SALUTATION = 'Mr'.

ADDR_SALUTATIONText 200 
FUNCTIONText  
REMARKText  

Free remark.

Adding two pipes « || » at the beginning will add the text to an existing remark instead of overwriting it.

Individual

Field codeField typeMandatoryDescription
FIRSTNAMEText 100 

First name

LASTNAMEText 100 Last name
BIRTHDATEDate Birth date
PREF_LANGCode 

Preferred language.

Use the 2 lettre ISO code. Examples: en, fr, es, it, ...

...

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 Anything. Customer responsible for correct data

Address lines.






LINE2Text 100 
LINE3Text 100 
ZIPCODEText 10 
TOWNText 20 
TOWN_COMPLEMENTText 20 
COUNTRYCode 

Country code

Ex

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.

Communication means

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.

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 phoneEx: 06 88 48 87 10, (33)0677744594... Same rules as for PHONE.

EMAIL1Text 250 

Will be used as username for ticket shop login.

If email is does already existedexist, the email is imported but can't be used to login.

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.

Authorization

Field codeField typeMandatoryDescription
AUTH_CNIL_OBoolean 

Accept communication communications from institution

AUTH_PARTNERBoolean Accept communication communications from one partnerpartners
AUTH_CNIL_TBoolean Accepts Accept transmission of elec. electronic coordinates to third parties
AUTH_SMS_MMSBoolean Accept sms/mms SMS or MMS from institution
AUTH_LETTERBoolean Accept letter from institution
AUTH_PHONEBoolean Accept phone from institution
AUTH_EMAILBoolean Accept email from institution

...

Field codeField typeMandatoryDescription
CRIT01CodeValue 

Formula: CritCode=CritValue1|CritValue2|CritValue3

Special case: If we use CONFIG row which mean:

  • CONFIG contains CritCode.
  • Contact row contains CritValue1|CritValue2|CritValue3.

Must be predefined in Contact criteria definitionThe code must be created as described in Contact criteria definition.

  • Several values can be given. They need to be separated by pipes.
  • On the CONFIG row, the user can define the default code.

Examples:

Field valueComment
PREFCOL=RedThe preferred color is Red only
PREFCOL=Red|GreenThe preferred color is Red and Green
Red|GreenPREFCOL must have been defined in a CONFIG row
...  
CRIT50CodeValue