Difference between revisions of "ProDon:Client importation module"

From Logilys
Jump to: navigation, search
Line 464: Line 464:
 
|-
 
|-
 
! scope="col" | Type<br>  
 
! scope="col" | Type<br>  
! scope="col" | Valeurs possibles<br>  
+
! scope="col" | Possible Values<br>  
! scope="col" | Longeur maximale<br>
+
! scope="col" | Maximum Length<br>
 
|-
 
|-
| Numérique<br>  
+
| Numeric<br>  
| Chiffre uniquement<br>  
+
| Numbers only<br>  
 
| <br>
 
| <br>
 
|-
 
|-
| Texte<br>  
+
| Text<br>  
 
| <br>  
 
| <br>  
 
| 255<br>
 
| 255<br>
 
|-
 
|-
| Date et heure<br>  
+
| Date and time<br>  
| Format de date tel que specifié dans les options d'importation<br>  
+
| Date format as specified in import options<br>  
 
| 10<br>
 
| 10<br>
 
|-
 
|-
| Vrai/Faux<br>  
+
| True/False<br>  
| '''N''' ou '''F''' = Non ('''Vide''' = Non)<br>'''O''' ou '''V''' = Oui<br>  
+
| '''N''' or '''F''' = No ('''Empty''' = No)<br>'''Y''' or '''T''' = Yes<br>  
 
| 1<br>
 
| 1<br>
 
|-
 
|-
| Liste de choix<br>  
+
| List of options<br>  
| Si la valeur n'existe pas déjà, elle sera automatiquement ajoutée à la liste<br>  
+
| If the value does not already exist, it will be automatically added to the list.<br>  
 
| 250<br>
 
| 250<br>
 
|-
 
|-
| Liste de choix prédéfinie<br>  
+
| Predefined list of options<br>  
| Choix existant dans '''''ProDon'''''<br>  
+
| Existing selection from '''''ProDon'''''<br>  
 
| 250<br>
 
| 250<br>
 
|}
 
|}
  
Pour ajouter une note, une date de début ou de fin à une caractéristique par une importation, il faut ajouter un suffixe approprié.&nbsp;Les suffixes sont&nbsp;:&nbsp;_note, _début et _fin. Par exemple&nbsp;:&nbsp;CliDIndividus_note.&nbsp;La note peut contenir jusqu'à 255 caractères et les dates doivent correspondre au format spécifié dans les options d'importation.&nbsp;Ces informations sont ignorées si la colonne de base ne contient pas de valeurs&nbsp;(ie CliDIndividus serait vide).&nbsp;Pour pouvoir utiliser les dates de début et fin, il faut aussi que les cases correspondantes soient cochées dans la configuration de la caractéristique.  
+
To add a note, start date or end date to a characteristic by import, the appropriate suffix must be added: _note, _start or _end. Example: CliDPeople_note. The note can include up to 255 characters; dates must adhere to the format specified in the import options. This information will be ignored if the base column contains no values (e.g., if CliDPeople is empty). To use start and end dates, the corresponding boxes must be checked in the configuration of the characteristic.  
  
Si la caractéristique le permet, il est possible d'importer plusieurs valeurs en utilisant le suffixe -1, -2 à la toute fin du libellé.&nbsp;Par exemple&nbsp;:&nbsp;CliDIndividus_note-1.  
+
If supported by the characteristic, several values can be imported by adding the suffix -1, -2 to the end of any label. Example: CliDPeople_note-1.  
  
<br>'''{{Anchor|9|9clients}}'''&nbsp;: Ce champ requiert la présence du champ similaire en Occasion.  
+
<br>'''{{Anchor|9|9clients}}'''&nbsp;: This field requires the presence of a similar field under Occasion.  
  
'''{{Anchor|10|10clients}}'''&nbsp;: Utile seulement si vous utilisez l'option «&nbsp;Créer les activités inexistantes&nbsp;». Il est impossible d'avoir plus d'une provenance pour un code d'activité donné.  
+
'''{{Anchor|10|10clients}}'''&nbsp;: Useful only if the "Create non-existent activities" option is selected. The use of more than one source for a given activity code is not allowed.  
  
== Liste des champs contacts ==
+
== List of contact fields ==
  
 
{| width="100%" cellspacing="1" cellpadding="1" border="1" class="wikitable sortable"
 
{| width="100%" cellspacing="1" cellpadding="1" border="1" class="wikitable sortable"
 
|-
 
|-
! scope="col" | Libellé complet
+
! scope="col" | Full Label
! scope="col" | Abrégé 1  
+
! scope="col" | Abbreviation 1  
! scope="col" | Abrégé 2  
+
! scope="col" | Abbreviation 2  
! scope="col" | Valeurs possibles
+
! scope="col" | Possible Values
! width="75" align="center" scope="col" | Longeur maximale
+
! width="75" align="center" scope="col" | Maximum Length
! width="90" scope="col" | Particularité
+
! width="90" scope="col" | Specific Properties
 
|-
 
|-
| NoContact
+
| ContactNo
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| Numéro de contact existant<br>  
+
| Existing contact number<br>  
 
| style="text-align: center;" | 10<br>  
 
| style="text-align: center;" | 10<br>  
 
| align="center" | [[#1con|1]]<br>
 
| align="center" | [[#1con|1]]<br>
 
|-
 
|-
| ConNom<br>  
+
| ConName<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 525: Line 525:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConPrenom<br>  
+
| ConFirstName<br>  
 
| ConPre<br>  
 
| ConPre<br>  
 
| <br>  
 
| <br>  
Line 532: Line 532:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTéléphoneRésidence
+
| ConPhoneHome
| ConRés
+
| ConHome
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 539: Line 539:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTéléphoneBureau
+
| ConPhoneOffice
| ConBur
+
| ConOff
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 546: Line 546:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTéléphoneBureauPoste
+
| ConPhoneOfficeExt
| ConBurPoste
+
| ConOffExt
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 553: Line 553:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTélécopieur
+
| ConFax
| ConFax  
+
| ConFax
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 560: Line 560:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTéléphoneCellulaire
+
| ConPhoneCell
| ConCell  
+
| ConCell
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 567: Line 567:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTéléavertisseur
+
| ConPager
| ConPaget
+
| ConPager
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 574: Line 574:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConCourriel
+
| ConEmail
 
| ConE-mail  
 
| ConE-mail  
| ConEmail  
+
| ConEmail
 
| <br>  
 
| <br>  
 
| style="text-align: center;" | 100  
 
| style="text-align: center;" | 100  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConSiteInternet
+
| ConWebsite
| ConWeb  
+
| ConWeb
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 588: Line 588:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConDateNaissance
+
| ConDateBirth
| ConNais
+
| ConBirth
 
| <br>  
 
| <br>  
 
| '''Date'''<br>  
 
| '''Date'''<br>  
Line 595: Line 595:
 
| align="center" | [[#2con|2]]<br>
 
| align="center" | [[#2con|2]]<br>
 
|-
 
|-
| ConAppellation
+
| ConTitle
| ConApp  
+
| ConApp
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 602: Line 602:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTitre
+
| ConTitle
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 609: Line 609:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConGenre<br>  
+
| ConGender<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| '''M''' = Masculin<br>'''F''' = Féminin<br>'''Vide''' = Selon appellation (Monsieur = Masculin / Madame = Féminin)<br>  
+
| '''M''' = Male<br>'''F''' = Female<br>'''Empty''' = According to title (Mr. = Male / Mrs. = Female)<br>  
 
| style="text-align: center;" | 1<br>  
 
| style="text-align: center;" | 1<br>  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConCommentaires<br>  
+
| ConComments<br>  
 
| ConCom<br>  
 
| ConCom<br>  
 
| <br>  
 
| <br>  
Line 623: Line 623:
 
| align="center" | [[#pluscon|[+]]]<br>
 
| align="center" | [[#pluscon|[+]]]<br>
 
|-
 
|-
| ConOrdre<br>  
+
| ConOrder<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| Entre 1 et 10 chiffres<br>  
+
| From 1 to 10 digits<br>  
 
| style="text-align: center;" | 10<br>  
 
| style="text-align: center;" | 10<br>  
 
| align="center" | [[#3con|3]]<br>
 
| align="center" | [[#3con|3]]<br>
 
|-
 
|-
| ConOpération<br>  
+
| ConOperation<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| '''A''' = Ajouter un contact<br>'''M''' = Modifier un contact existant<br>'''D''' = Détruire un contact existant<br>  
+
| '''A''' = Add new contact<br>'''E''' = Edit existing contact<br>'''D''' = Delete existing contact<br>  
 
| style="text-align: center;" | 1<br>  
 
| style="text-align: center;" | 1<br>  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConLien<br>  
+
| ConLink<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| '''Code''' de type de lien existant<br>  
+
| Existing link type '''Code'''<br>  
 
| style="text-align: center;" | 25<br>  
 
| style="text-align: center;" | 25<br>  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConLienInverse<br>  
+
| ConLinkReverse<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| '''N''' ou '''F''' = Non ('''Vide''' = Non)<br>'''O''' ou '''V''' = Oui<br>  
+
| '''N''' or '''F''' = No ('''Empty ''' = No)<br>'''Y''' or '''T''' = Yes<br>  
 
| style="text-align: center;" | 1<br>  
 
| style="text-align: center;" | 1<br>  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConDateDebut<br>  
+
| ConStartDate<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 658: Line 658:
 
| align="center" | [[#2con|2]]<br>
 
| align="center" | [[#2con|2]]<br>
 
|-
 
|-
| ConDateFin<br>  
+
| ConEndDate<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 666: Line 666:
 
|}
 
|}
  
'''{{Anchor|[+]|pluscon}}'''&nbsp;: Si le code [+] est ajouté à la fin du libellé, l'information importée sera ajoutée à l'information déjà présente dans la base de données. Dans le cas contraire, l'information importée remplacera l'information déjà présente.  
+
'''{{Anchor|[+]|pluscon}}'''&nbsp;: If the symbol [+] is added to the end of the label, the imported data will be added to the existing information in the database. Otherwise, the imported data will replace the existing information.  
  
'''{{Anchor|1|1con}}'''&nbsp;: Champ obligatoire sauf si on ajoute un nouveau contact. En lien avec ConOpération.  
+
'''{{Anchor|1|1con}}'''&nbsp;: Required field unless you are adding new contact. Used in conjunction with ConOperation.  
  
'''{{Anchor|2|2con}}'''&nbsp;: Le format de date est dicté par le format choisi dans les options d'importation. Les caractères en trop par rapport à la longueur maximale seront ignorés.  
+
'''{{Anchor|2|2con}}'''&nbsp;: The date format is determined by the format selected in the import options. Characters that extend beyond the maximum length will be ignored.  
  
'''{{Anchor|3|3con}}'''&nbsp;: Le comportement de cette valeur est dicté par l'opération indiquée dans ConOpération.  
+
'''{{Anchor|3|3con}}'''&nbsp;: This value's behavior is determined by the operation specified in ConOperation.  
  
En destruction, l'ordre est inutile. Sinon, une procédure détermine le numéro à utiliser afin d'éviter des incohérences.  
+
When deleting, the order does not matter. Otherwise, a procedure determines the number to use to avoid inconsistencies.  
  
En modification, le contact se verra attribuer l'ordre spécifié dans la colonne. Si la colonne est vide ou inexistante, le contact gardera son ordre actuel.  
+
When editing, the contact will be assigned the order specified in the column. If the column is empty or does not exist, the contact will retain its current order.  
  
En ajout, le contact se verra attribuer l'ordre spécifié dans la colonne. Si la colonne est vide ou inexistante, le contact se verra attribuer l'ordre 0.  
+
When adding, the contact will be assigned the order specified in the column. If the column is empty or does not exist, the contact will be assigned order 0.  
  
Pour déterminer quel client obtiendra un ordre plutôt qu'un autre ayant le même numéro d'ordre, ProDon utilisera la séquence suivante&nbsp;:  
+
To determine which client will be assigned an order number when another client already has the same order number, ProDon will use the following sequence:  
  
#Les contacts ayant déjà un ordre plus grand que 0 sont attribués en premier
+
#Contacts that already have an order greater than 0 will be assigned first.
#Si deux contacts obtiennent le même numéro d'ordre, le contact le plus récent conservera son numéro d'ordre
+
#If two contacts are assigned the same order number, the most recent contact will keep the order number.
#Les contacts ayant un ordre 0 obtiendront leur ordre en dernier.
+
#Contacts whose order number is 0 will be assigned an order number last.
  
== Liste des champs liens ==
+
== List of link fields ==
  
 
{| width="100%" cellspacing="1" cellpadding="1" border="1" class="wikitable sortable"
 
{| width="100%" cellspacing="1" cellpadding="1" border="1" class="wikitable sortable"
 
|-
 
|-
! scope="col" | Libellé complet
+
! scope="col" | Full Label
! scope="col" | Abrégé 1  
+
! scope="col" | Abbreviation 1  
! scope="col" | Abrégé 2  
+
! scope="col" | Abbreviation 2  
! scope="col" | Valeurs possibles
+
! scope="col" | Possible Values
! width="75" align="center" scope="col" | Longeur maximale
+
! width="75" align="center" scope="col" | Maximum Length
! width="90" scope="col" | Particularité
+
! width="90" scope="col" | Specific Properties
 
|-
 
|-
| NUC2
+
| UCN2
 
| NoClient2<br>  
 
| NoClient2<br>  
 
| NoCli2<br>  
 
| NoCli2<br>  
| '''NUC''' existant du client à lier<br>  
+
| Existing '''UNC''' of client to be linked<br>  
 
| style="text-align: center;" | 7<br>  
 
| style="text-align: center;" | 7<br>  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| NoRéférence2<br>  
+
| ReferenceNo2<br>  
| Réf2<br>  
+
| Ref2<br>  
| NoRéf2<br>  
+
| RefNo2<br>  
| '''Numéro de référence''' existant du client à lier<br>  
+
| Existing '''reference number''' of client to be linked<br>  
 
| style="text-align: center;" | 25<br>  
 
| style="text-align: center;" | 25<br>  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| LienOpération<br>  
+
| LinkOperation<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| '''A''' = Ajouter<br>'''D''' = Détruire<br>'''I''' = Ignorer
+
| '''A''' = Add<br>'''D''' = Delete<br>'''I''' = Ignore
 
| style="text-align: center;" | 1<br>  
 
| style="text-align: center;" | 1<br>  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| Lien<br>  
+
| Link<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| '''Code''' de type de lien existant<br>  
+
| Existing link type '''Code'''<br>  
 
| style="text-align: center;" | 25<br>  
 
| style="text-align: center;" | 25<br>  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| LienInverse<br>  
+
| LinkReverse<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| '''N''' ou '''F''' = Non ('''Vide''' = Non)<br>'''O''' ou '''V''' = Oui
+
| '''N''' or '''F''' = No ('''Empty''' = No)<br>'''Y''' or '''T''' = Yes
 
| style="text-align: center;" | 1<br>  
 
| style="text-align: center;" | 1<br>  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| LienType<br>  
+
| LinkType<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| '''L''' = Lien'''&nbsp;'''('''Vide''' = Lien)<br>'''C''' = Contact  
+
| '''L''' = Link'''&nbsp;'''('''VideEmpty'' = Link)<br>'''C''' = Contact  
 
| style="text-align: center;" | 1<br>  
 
| style="text-align: center;" | 1<br>  
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| LienDateDébut<br>  
+
| LinkStartDate<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 746: Line 746:
 
| align="center" | [[#1lien|1]]<br>
 
| align="center" | [[#1lien|1]]<br>
 
|-
 
|-
| LienDateFin
+
| LinkEndDate
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 753: Line 753:
 
| align="center" | [[#1lien|1]]
 
| align="center" | [[#1lien|1]]
 
|-
 
|-
| LienNote
+
| LinkNote
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 761: Line 761:
 
|}
 
|}
  
'''{{Anchor|1|1lien}}'''&nbsp;: Le format de date est dicté par le format choisi dans les options d'importation. Les caractères en trop par rapport à la longueur maximale seront ignorés.
+
'''{{Anchor|1|1lien}}'''&nbsp;: The date format is determined by the format selected in the import options. Characters that extend beyond the maximum length will be ignored.
  
 
{{Footer_ProDon}}
 
{{Footer_ProDon}}

Revision as of 16:25, 25 October 2010

Template:Header ProDon

List of client fields

Full Label Abbreviation 1 Abbreviation 2 Possible Values Maximum Length Specific Properties
CliAddress CliAdr


150
[+]
CliAdrRoad



100
1
CliAdrPointCall
CliAdrCall


100
1
CliAdrBuilding



100
1
CliAdrComplRoad



100
1
CliAdrBranch
CliAdrBranch


100
1
CliCedex



100
1
CliAnonymous
CliAnony
CliAno
N or F = No (Empty = No)
Y or T = Yes
1

CliTitle
CliTitle


50

CliBeneficiary
CliBenef
CliBen
N or F = No (Empty = No)
Y or T = Yes
5

CliCodeCategory
CliCat

Existing category Code
255
[*], [+]
CliPostalCode
CliPC


15

CliSectorCode
CliSec
CliSector
Existing sector Code
15
[*]
CliComments
CliCom


5000
[+]
CliCompany
CliCo


100

CliCompanyCont
CliCoCont


100

CliEmail
CliE-Mail
CliEmail

100

CliDateDeath


Date
10
2
CliDateBirth
CliBirth

Date
10
2
CliDateRegistration
CliDateReg

Date
10
2
CliDeceased


N or F = No (Empty = No)
Y or T = Yes
1

CliExcludeMassMailing
CliExclude
CliExcl
N or F = No (Empty = No)
Y or T = Yes
1
3
CliGender


M = Male
F = Female
Empty = According to title (Mr. = Male / Mrs. = Female)
1

CliInactive


N or F = No (Empty = No)
Y or T = Yes
1
4
CliLanguage


Existing language Code
2

CliDoNotSuggest


N or F = No (Empty = No)
Y or T = Yes
1

CliDoNotCall


N or F = No (Empty = No)
Y or T = Yes
1

CliName



100

CliParticle
CliPart


15

CliSuffix



50

CliCountry



40

CliFirstName
CliPre


100

CliProvince
CliProv
CliPro

25

CliReasonExclusion
CliReason


100
5
CliRecdAnnual
CliRecdA

N or F = No (Empty = No)
Y or T = Yes
1

CliRecdStatus
CliRecdS

N = Never a receipt for this client
Empty = No
1

CliWebsite
CliWeb


100

CliSolicitorCode
CliSolCode

Existing solicitor Code
15
6
CliSolicitorName
CliSolName

Firstname Lastname of an existing solicitor.
Note: The use of this field is not recommended.
A known issue can arise if there are multiple identical existing solicitors.
15
6
CliIsASolicitor
CliIsASol

N or F = No (Empty = No)
Y or T = Yes
1
7
CliSolicitorCodePerso
CliSolCodePerso


25
7
CliSolicitorActiveSince
CliSolDateActive

Date
10
2, 7
CliSolicitorInactive
CliSolInactive

N or F = No (Empty = No)
Y or T = Yes
1
7
CliSolicitorInactiveSince
CliSolDateInactive

Date
10
2, 7
CliPager
CliPager


25

CliFax
CliFax


25

CliPhoneOffice
CliOff


25

CliPhoneOfficeExt
CliOffExt


10

CliPhoneCell
CliCell


25

CliPhoneHome
CliRes


25

CliTitle



150

CliCity



50

CliCharacteristicLabel


Variable
Variable
8
CliCustomLabel


Variable
Variable
8
MailActSource


Existing source
100
10
MailActivityCode
MailAct
MailActivity
Existing activity Code
15
[*], 9
MailOccasionCode
MailOcc
MailOccasion
Existing occasion Code
15
[*]
MailRegDate


Date
10
2
MailActDesc



100
9
MailOccasionDesc



100

MailResponse
MailResp

Existing solicitation response
100

[+] : If the symbol [+] is added to the end of the label, the imported data will be added to the existing information in the database. Otherwise, the imported data will replace the existing information.

[*] : If the symbol [*] is added to the end of the label, the code will be created if it does not already exist.

1 : To use this field, you must select the option "Use the address pad rather than the standard address import."

2 : The date format is determined by the format selected in the import options. Characters that extend beyond the maximum length will be ignored

3 : The mass mailing exclusion date is always the current date.

4 : If the "CliInactive" column exists, its value will always be applied. If the column does not exist, the client will be inactive if it has a date of death or if there is an "O" or "V" in the CliDeceased column.

5 : This value will be processed only if the client is excluded from mass mailing.

6 : Enables you to define the solicitor assigned to the client. Be careful to not confuse with 7.

7 : Enables you to specify the information of a client that is a solicitor. Be careful to not confuse with 6.

8 : For custom values and characteristics, it is necessary to specify the label defined in ProDon using the prefix "Cli" and only letters and/or numbers (no spaces). For example, a field named "% people" would become CliDPeople.

Variables
Type
Possible Values
Maximum Length
Numeric
Numbers only

Text

255
Date and time
Date format as specified in import options
10
True/False
N or F = No (Empty = No)
Y or T = Yes
1
List of options
If the value does not already exist, it will be automatically added to the list.
250
Predefined list of options
Existing selection from ProDon
250

To add a note, start date or end date to a characteristic by import, the appropriate suffix must be added: _note, _start or _end. Example: CliDPeople_note. The note can include up to 255 characters; dates must adhere to the format specified in the import options. This information will be ignored if the base column contains no values (e.g., if CliDPeople is empty). To use start and end dates, the corresponding boxes must be checked in the configuration of the characteristic.

If supported by the characteristic, several values can be imported by adding the suffix -1, -2 to the end of any label. Example: CliDPeople_note-1.


9 : This field requires the presence of a similar field under Occasion.

10 : Useful only if the "Create non-existent activities" option is selected. The use of more than one source for a given activity code is not allowed.

List of contact fields

Full Label Abbreviation 1 Abbreviation 2 Possible Values Maximum Length Specific Properties
ContactNo

Existing contact number
10
1
ConName



100

ConFirstName
ConPre


100

ConPhoneHome ConHome

25
ConPhoneOffice ConOff

25
ConPhoneOfficeExt ConOffExt

10
ConFax ConFax

25
ConPhoneCell ConCell

25
ConPager ConPager

25
ConEmail ConE-mail ConEmail
100
ConWebsite ConWeb

100
ConDateBirth ConBirth
Date
10 2
ConTitle ConApp

50
ConTitle


255
ConGender


M = Male
F = Female
Empty = According to title (Mr. = Male / Mrs. = Female)
1

ConComments
ConCom


5000
[+]
ConOrder


From 1 to 10 digits
10
3
ConOperation


A = Add new contact
E = Edit existing contact
D = Delete existing contact
1

ConLink


Existing link type Code
25

ConLinkReverse


N or F = No (Empty = No)
Y or T = Yes
1

ConStartDate


Date
10
2
ConEndDate


Date
10
2

[+] : If the symbol [+] is added to the end of the label, the imported data will be added to the existing information in the database. Otherwise, the imported data will replace the existing information.

1 : Required field unless you are adding new contact. Used in conjunction with ConOperation.

2 : The date format is determined by the format selected in the import options. Characters that extend beyond the maximum length will be ignored.

3 : This value's behavior is determined by the operation specified in ConOperation.

When deleting, the order does not matter. Otherwise, a procedure determines the number to use to avoid inconsistencies.

When editing, the contact will be assigned the order specified in the column. If the column is empty or does not exist, the contact will retain its current order.

When adding, the contact will be assigned the order specified in the column. If the column is empty or does not exist, the contact will be assigned order 0.

To determine which client will be assigned an order number when another client already has the same order number, ProDon will use the following sequence:

  1. Contacts that already have an order greater than 0 will be assigned first.
  2. If two contacts are assigned the same order number, the most recent contact will keep the order number.
  3. Contacts whose order number is 0 will be assigned an order number last.

List of link fields

Full Label Abbreviation 1 Abbreviation 2 Possible Values Maximum Length Specific Properties
UCN2 NoClient2
NoCli2
Existing UNC of client to be linked
7

ReferenceNo2
Ref2
RefNo2
Existing reference number of client to be linked
25

LinkOperation


A = Add
D = Delete
I = Ignore
1

Link


Existing link type Code
25

LinkReverse


N or F = No (Empty = No)
Y or T = Yes
1

LinkType


L' = Link (VideEmpty = Link)
C = Contact
1

LinkStartDate


Date
10
1
LinkEndDate

Date
10 1
LinkNote


5000

1 : The date format is determined by the format selected in the import options. Characters that extend beyond the maximum length will be ignored.


Document name: ProDon:Client importation module