Versions Compared

Version Old Version 21 New Version 22
Changes made by

LGN (Unlicensed)

LGN (Unlicensed)

Saved on

Key

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

...

  • Field with empty data mean "I don't want to do anything with the field".
  • Put value '=' will remove the current value in system.
  • Field with data will be imported.

...

Field codeField typeMandatoryDescription
INSTITText 15Yes

Institution code owning the data to be imported.

ORGANIZATIONText 15Yes

Organization owning the data to be imported.

A "*" indicates that all organizations of the given institution are concerned.

OPERATIONEnumYes

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: Applicable to all contacts.

  • Delete the contact address, communication mean
  • For authorization and criterion value. Only delete the value that specified in excel file.
  • The email will be empty and contact can't be login to ticketshop anymore.
  • This action is irreversible.

INVALIDATE: Applicable to contact which has no sales.

  • Just mark contact as invalid with reason: ACCOUNT_DELETED.
  • All other information are in tact (not removed).

ANONYMIZE: Applicable to all contacts (even if it has sales).

  • All contact information is deleted. Contact name is changed in to 'XXXXXXXX'.
  • Set contact as ACCOUNT_DELETED and remark contact with 'Contact anonymized'.
  • The contact's sales information are in tact (not removed).
  • This action is irreversible.

DROP : Should only be used for mis-import. Application Applicable to contact that imported and has no modified since then.

  • Drop the contact and all its information. The contact is not dropped if it is used in existing sales.
  • The contact row is removed from system forever.

...

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

If value is empty, it will be interpolated from other field.

LETTER_SALUTATIONText 200 
ADDRESS ADDR_SALUTATIONText 200 
FUNCTIONText 1000  
REMARKText 2000  

...

Field codeField typeMandatoryDescription
FIRSTNAMEText 100 

First name of the individual

LASTNAMEText 100 Last name of the individual
BIRTHDATEDate Birth datePREFERRED LANGUAGE
PREF_LANGCode Filled with country

Language code

Ex: en, fr, es, it...

PHOTO_PATHText 2000  

Structure

Field codeField typeMandatoryDescription
STRUCTURE STRUCT_NAMEText 100 

Structure name

Data will be truncate if length > 100.

ADDRESS NAME 1_NAME1Text 38 Taken from structure name if not defined (first 38 characters)
ADDRESS NAME 2_NAME2Text 38 Taken from structure name if not defined (next 38 characters).
STRUCTURE STRUC_CODECodeCodeValue 

Must be predefined in system

See reference page Structure type definition

COMMUNITY_TYPECode Must be predefined in system
ADMIN_NUMBERCode CodeValue 
NB_EMPLOYEESNumber  
WEBSITEText 2000  

...

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

LINE 1LINE1Text 100 Anything. Customer responsible for correct data.




LINE 2LINE2Text 100 
LINE 3LINE3Text 100 
ZIPCODEText 10 
TOWNText 20 
TOWN COMPLEMENT_COMPText 20 
COUNTRYCode Country code (TBD: table mapping for referenced)Ex: FR, ES, EN, GB....

Communication mean

Landline phone number.

For fields above:

  • Put value '=' will remove the current value in system.
    • Following standard format and international format.
    Field codeField typeMandatoryDescription
    PHONE 1Text 1315 

    Landline phone number.

    PHONE 2Text 13 

    Landline phone number.

    PHONE 3Text 13 

    Follow standard format and international format.

    Ex: 01 40 15 80 00, 0169395090, (33)0134806517,

    FAXText 1015  
    CELLPHONEText 1315 

    Mobile phone

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

    EMAIL 1Text 50 

    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 systems. It won't be imported if validation failed (standard email format will be ok, don't worry).

    EMAIL 2Text 50  
    EMAIL 3Text 50  

    ...

    Field codeField typeMandatoryDescription
    CNIL_OBoolean (TRUE/FALSE) 

    Accept communication from institution

    PARTNERBoolean (TRUE/FALSE) Accept communication from one partner
    CNIL_TBoolean (TRUE/FALSE) Accepts transmission of elec. coordinates to third parties
    SMS_MMSBool (TRUE/FALSE) Accept sms/mms from institution
    LETTERBoolean (TRUE/FALSE) Accept letter from institution
    PHONEBoolean (TRUE/FALSE) Accept phone from institution
    EMAILBoolean (TRUE/FALSE) Accept email from institution

    ...

    Field codeField typeMandatoryDescription
    Crit1CRIT1Text 1000CodeValue 

    Formula: CritCode=CritValue1|CritValue2|CritValue3

    Special case: If we use CONFIG row which mean:

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

    Must be predefined in Contact criteria definition

    ...  
    Crit50CRIT50Text 1000CodeValue