Page tree

Versions Compared

Key

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

...

In case you want to associate a contact to a criteria or structure type. Follow these links: Contact criteria definition and Structure type definition Define criteria’s for the contacts and Define type of structure to create the records.

Examples

...

Field codeField typeMandatoryDescription
OFFICIAL_NAMEText 100 

Official name of the structure. The name will be truncated if it is too long.

ADDRESS_NAME1Text 38 

Name of the structure for the adresse

If it is empty, it is taken from the official name

 If it is too long, it is truncated.
ADDRESS_NAME2Text 38 
STRUCT_TYPECode 

The type of the structure. The code must be defined as described in Structure Define type definitionof structure

COMMUNITY_TYPECode The code of the community type. If it is left empty, then the structure isn't member of any community.
ADMIN_NUMBERCodeValue 

Administrative number, for example a SIRET number. Only one number can be given here, but subsequent updates of the contact may help adding several numbers.

  • On the CONFIG row, the user can define the default code.

Example

Field valueComment
SIRET=404 833 048 00022The SIRET number is 404 833 048 00022
404 833 048 00022SIRET must have been defined in a CONFIG row
NB_EMPLOYEESNumber  
WEB_SITEText 2000 URL to the structure's website. It must contain the http:// prefix.

...

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.

...

Field codeField typeMandatoryDescription
CRIT01CodeValue 

The code must be created as described in Contact criteria definition Define criteria’s for the contacts.

  • 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