Difference between revisions of "ProDon:Client importation module"

From Logilys
Jump to: navigation, search
 
(27 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{Header_ProDon|22|4.5|Louis-Sébastien Garneau|Jessy Fontaine|2010/05/26}}  
+
{{Header_TOC}}<br>
  
 
== List of client fields  ==
 
== List of client fields  ==
Line 5: Line 5:
 
{| width="100%" cellspacing="1" cellpadding="1" border="1" class="wikitable sortable"
 
{| width="100%" cellspacing="1" cellpadding="1" border="1" class="wikitable sortable"
 
|-
 
|-
! scope="col" | Full Label
+
! scope="col" | Full Label  
 
! scope="col" | Abbreviation 1  
 
! scope="col" | Abbreviation 1  
 
! scope="col" | Abbreviation 2  
 
! scope="col" | Abbreviation 2  
Line 12: Line 12:
 
! width="90" scope="col" | Specific Properties
 
! width="90" scope="col" | Specific Properties
 
|-
 
|-
| CliAddress
+
| CliAddress  
 
| CliAdr<br>  
 
| CliAdr<br>  
 
| <br>  
 
| <br>  
Line 48: Line 48:
 
|-
 
|-
 
| CliAdrBranch<br>  
 
| CliAdrBranch<br>  
| CliAdrBranch<br>  
+
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 69: Line 69:
 
|-
 
|-
 
| CliTitle<br>  
 
| CliTitle<br>  
| CliTitle<br>  
+
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 82: Line 82:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| CliCodeCategory<br>  
+
| CliCategoryCode<br>  
 
| CliCat<br>  
 
| CliCat<br>  
 
| <br>  
 
| <br>  
Line 125: Line 125:
 
|-
 
|-
 
| CliEmail<br>  
 
| CliEmail<br>  
| CliE-Mail<br>  
+
| <br>  
| CliEmail<br>  
+
| <br>  
 
| <br>  
 
| <br>  
 
| style="text-align: center;" | 100<br>  
 
| style="text-align: center;" | 100<br>  
Line 176: Line 176:
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| '''N''' or '''F''' = No (Empty = No)<br>'''Y''' or '''T''' = Yes<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" | [[#4clients|4]]<br>
 
| align="center" | [[#4clients|4]]<br>
Line 230: Line 230:
 
|-
 
|-
 
| CliFirstName<br>  
 
| CliFirstName<br>  
| CliPre<br>  
+
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 250: Line 250:
 
| align="center" | [[#5clients|5]]<br>
 
| align="center" | [[#5clients|5]]<br>
 
|-
 
|-
| CliRecdAnnual<br>  
+
| CliAnnualReceipt<br>  
| CliRecdA<br>  
+
| CliAReceipt<br>  
 
| <br>  
 
| <br>  
 
| '''N''' or '''F''' = No ('''Empty ''' = No)<br>'''Y''' or '''T''' = Yes<br>  
 
| '''N''' or '''F''' = No ('''Empty ''' = No)<br>'''Y''' or '''T''' = Yes<br>  
Line 257: Line 257:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| CliRecdStatus<br>  
+
| CliReceiptStatus<br>  
| CliRecdS<br>  
+
| CliReceiptS<br>  
 
| <br>  
 
| <br>  
| '''N''' = Never a receipt for this client<br>'''Empty''' = No
+
| '''N''' = Never a receipt for this client<br>'''Empty''' = No  
 
| style="text-align: center;" | 1<br>  
 
| style="text-align: center;" | 1<br>  
 
| align="center" | <br>
 
| align="center" | <br>
Line 271: Line 271:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| CliSolicitorCode<br>  
+
| CliCanvasserCode<br>  
| CliSolCode<br>  
+
| CliCanvCode<br>  
 
| <br>  
 
| <br>  
 
| Existing solicitor '''Code '''<br>  
 
| Existing solicitor '''Code '''<br>  
Line 278: Line 278:
 
| align="center" | [[#6clients|6]]<br>
 
| align="center" | [[#6clients|6]]<br>
 
|-
 
|-
| CliSolicitorName<br>  
+
| CliCanvasserName<br>  
| CliSolName<br>  
+
| CliCanvName<br>  
 
| <br>  
 
| <br>  
 
| '''Firstname Lastname '''of an existing solicitor.<br>'''Note:''' The use of this field is not recommended.<br>A known issue can arise if there are multiple identical existing solicitors.<br>  
 
| '''Firstname Lastname '''of an existing solicitor.<br>'''Note:''' The use of this field is not recommended.<br>A known issue can arise if there are multiple identical existing solicitors.<br>  
Line 285: Line 285:
 
| align="center" | [[#6clients|6]]<br>
 
| align="center" | [[#6clients|6]]<br>
 
|-
 
|-
| CliIsASolicitor<br>  
+
| CliIsACanvasser<br>  
| CliIsASol<br>  
+
| CliIsACanv<br>  
 
| <br>  
 
| <br>  
 
| '''N''' or '''F''' = No ('''Empty''' = No)<br>'''Y''' or '''T''' = Yes<br>  
 
| '''N''' or '''F''' = No ('''Empty''' = No)<br>'''Y''' or '''T''' = Yes<br>  
Line 292: Line 292:
 
| align="center" | [[#7clients|7]]<br>
 
| align="center" | [[#7clients|7]]<br>
 
|-
 
|-
| CliSolicitorCodePerso<br>  
+
| CliCanvasserCodePerso<br>  
| CliSolCodePerso<br>  
+
| CliCanvPersoCode<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 299: Line 299:
 
| align="center" | [[#7clients|7]]<br>
 
| align="center" | [[#7clients|7]]<br>
 
|-
 
|-
| CliSolicitorActiveSince<br>  
+
| CliCanvasserActiveSince<br>  
| CliSolDateActive<br>  
+
| CliCanvDateActive<br>  
 
| <br>  
 
| <br>  
 
| '''Date'''<br>  
 
| '''Date'''<br>  
Line 306: Line 306:
 
| align="center" | [[#2clients|2]], [[#7clients|7]]<br>
 
| align="center" | [[#2clients|2]], [[#7clients|7]]<br>
 
|-
 
|-
| CliSolicitorInactive<br>  
+
| CliCanvasserInactive<br>  
| CliSolInactive<br>
+
|  
 +
CliCanvInactive
 +
 
 
| <br>  
 
| <br>  
 
| '''N''' or '''F''' = No ('''Empty''' = No)<br>'''Y''' or '''T''' = Yes<br>  
 
| '''N''' or '''F''' = No ('''Empty''' = No)<br>'''Y''' or '''T''' = Yes<br>  
Line 313: Line 315:
 
| align="center" | [[#7clients|7]]<br>
 
| align="center" | [[#7clients|7]]<br>
 
|-
 
|-
| CliSolicitorInactiveSince<br>  
+
| CliCanvasserInactiveSince<br>  
| CliSolDateInactive<br>  
+
| CliCanvDateInactive<br>  
 
| <br>  
 
| <br>  
 
| '''Date'''<br>  
 
| '''Date'''<br>  
Line 321: Line 323:
 
|-
 
|-
 
| CliPager<br>  
 
| CliPager<br>  
| CliPager<br>  
+
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 328: Line 330:
 
|-
 
|-
 
| CliFax<br>  
 
| CliFax<br>  
| CliFax<br>  
+
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 343: Line 345:
 
| CliPhoneOfficeExt<br>  
 
| CliPhoneOfficeExt<br>  
 
| CliOffExt<br>  
 
| CliOffExt<br>  
| <br>  
+
| CliOffp<br>  
 
| <br>  
 
| <br>  
 
| style="text-align: center;" | 10<br>  
 
| style="text-align: center;" | 10<br>  
Line 362: Line 364:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| CliTitle<br>  
+
| CliJobTitle<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 390: Line 392:
 
| align="center" | [[#8clients|8]]<br>
 
| align="center" | [[#8clients|8]]<br>
 
|-
 
|-
| MailActSource<br>  
+
| MailActOrigin<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
| Existing '''source'''<br>  
+
| Existing <span style="font-weight: bold;">origin</span><br>  
 
| style="text-align: center;" | 100<br>  
 
| style="text-align: center;" | 100<br>  
 
| align="center" | [[#10clients|10]]<br>
 
| align="center" | [[#10clients|10]]<br>
 
|-
 
|-
| MailActivityCode<br>  
+
| MailCodeActivity<br>
 +
| MailActivity<br>  
 
| MailAct<br>  
 
| MailAct<br>  
| MailActivity<br>
 
 
| Existing activity '''Code'''<br>  
 
| Existing activity '''Code'''<br>  
 
| style="text-align: center;" | 15<br>  
 
| style="text-align: center;" | 15<br>  
 
| align="center" | [[#etoileclients|[*]]], [[#9clients|9]]<br>
 
| align="center" | [[#etoileclients|[*]]], [[#9clients|9]]<br>
 
|-
 
|-
| MailOccasionCode<br>
+
| MailCodeOccasion<br>  
| MailOcc<br>  
 
 
| MailOccasion<br>  
 
| MailOccasion<br>  
 +
| MailOcca<br>
 
| Existing occasion '''Code'''<br>  
 
| Existing occasion '''Code'''<br>  
 
| style="text-align: center;" | 15<br>  
 
| style="text-align: center;" | 15<br>  
 
| align="center" | [[#etoileclients|[*]]]<br>
 
| align="center" | [[#etoileclients|[*]]]<br>
 
|-
 
|-
| MailRegDate<br>  
+
| MailDateReg<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 418: Line 420:
 
| align="center" | [[#2clients|2]]<br>
 
| align="center" | [[#2clients|2]]<br>
 
|-
 
|-
| MailActDesc<br>  
+
| MailDescActivity<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| style="text-align: center;" | 100<br>  
 
| style="text-align: center;" | 100<br>  
| align="center" | [[#9clients|9]]<br>
+
| align="center" | [[#9clients|9]],[[#10clients|10]]<br>
 
|-
 
|-
| MailOccasionDesc<br>  
+
| MailDescOccasion<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| style="text-align: center;" | 100<br>  
 
| style="text-align: center;" | 100<br>  
| align="center" | <br>
+
| align="center" | [[#10clients|10]]<br>
 
|-
 
|-
 
| MailResponse<br>  
 
| MailResponse<br>  
| MailResp<br>  
+
| MailRes<br>  
 
| <br>  
 
| <br>  
 
| Existing solicitation '''response'''<br>  
 
| Existing solicitation '''response'''<br>  
Line 450: Line 452:
 
'''{{Anchor|3|3clients}}'''&nbsp;: The mass mailing exclusion date is always the current date.  
 
'''{{Anchor|3|3clients}}'''&nbsp;: The mass mailing exclusion date is always the current date.  
  
'''{{Anchor|4|4clients}}'''&nbsp;: 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.  
+
'''{{Anchor|4|4clients}}'''&nbsp;: 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 "Y" or "T" in the CliDeceased column.  
  
 
'''{{Anchor|5|5clients}}'''&nbsp;: This value will be processed only if the client is excluded from mass mailing.  
 
'''{{Anchor|5|5clients}}'''&nbsp;: This value will be processed only if the client is excluded from mass mailing.  
  
'''{{Anchor|6|6clients}}'''&nbsp;: Enables you to define the solicitor assigned to the client. Be careful to not confuse with&nbsp;'''7'''.  
+
'''{{Anchor|6|6clients}}'''&nbsp;: Enables you to define the canvasser assigned to the client. Be careful to not confuse with&nbsp;'''7'''.  
  
'''{{Anchor|7|7clients}}'''&nbsp;: Enables you to specify the information of a client that is a solicitor. Be careful to not confuse with&nbsp;'''6'''.  
+
'''{{Anchor|7|7clients}}'''&nbsp;: Enables you to specify the information of a client that is a canvasser. Be careful to not confuse with&nbsp;'''6'''.  
  
'''{{Anchor|8|8clients}}'''&nbsp;: 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.
+
'''{{Anchor|8|8clients}}'''&nbsp;: 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 CliPeople.  
  
 
{| width="635" cellspacing="1" cellpadding="1" border="1" class="wikitable"
 
{| width="635" cellspacing="1" cellpadding="1" border="1" class="wikitable"
Line 464: Line 466:
 
|-
 
|-
 
! 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: CliPeople_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 CliPeople 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: CliPeople_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 or occasion" option is selected. The use of more than one origin or description for a given activity or occasion 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 527:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConPrenom<br>  
+
| ConFirstName<br>  
 
| ConPre<br>  
 
| ConPre<br>  
 
| <br>  
 
| <br>  
Line 532: Line 534:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTéléphoneRésidence
+
| ConPhoneHome
| ConRés
+
| ConHome
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 539: Line 541:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTéléphoneBureau
+
| ConPhoneOffice
| ConBur
+
| ConOff
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 546: Line 548:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTéléphoneBureauPoste
+
| ConPhoneOfficeExt
| ConBurPoste
+
| ConOffExt
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 553: Line 555:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTélécopieur
 
 
| ConFax  
 
| ConFax  
 +
|
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 560: Line 562:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTéléphoneCellulaire
+
| ConPhoneCell
 
| ConCell  
 
| ConCell  
 
| <br>  
 
| <br>  
Line 567: Line 569:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTéléavertisseur
+
| ConPager
| ConPaget
+
|  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 574: Line 576:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConCourriel
 
| 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>  
Line 588: Line 590:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConDateNaissance
+
| ConDateBirth
| ConNais
+
| ConBirth
 
| <br>  
 
| <br>  
 
| '''Date'''<br>  
 
| '''Date'''<br>  
Line 595: Line 597:
 
| align="center" | [[#2con|2]]<br>
 
| align="center" | [[#2con|2]]<br>
 
|-
 
|-
| ConAppellation
+
| ConTitle
 
| ConApp  
 
| ConApp  
 
| <br>  
 
| <br>  
Line 602: Line 604:
 
| align="center" | <br>
 
| align="center" | <br>
 
|-
 
|-
| ConTitre
+
| ConJobTitle
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 609: Line 611:
 
| 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 625:
 
| 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>  
+
| ConDateStart<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 658: Line 660:
 
| align="center" | [[#2con|2]]<br>
 
| align="center" | [[#2con|2]]<br>
 
|-
 
|-
| ConDateFin<br>  
+
| ConDateEnd<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 666: Line 668:
 
|}
 
|}
  
'''{{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>  
+
| ClientNo2<br>  
| NoCli2<br>  
+
| CliNo2<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;'''('''Empty''' = 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>  
+
| LinkDateStart<br>  
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 746: Line 748:
 
| align="center" | [[#1lien|1]]<br>
 
| align="center" | [[#1lien|1]]<br>
 
|-
 
|-
| LienDateFin
+
| LinkDateEnd
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 753: Line 755:
 
| align="center" | [[#1lien|1]]
 
| align="center" | [[#1lien|1]]
 
|-
 
|-
| LienNote
+
| LinkNote
 
| <br>  
 
| <br>  
 
| <br>  
 
| <br>  
Line 761: Line 763:
 
|}
 
|}
  
'''{{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}}

Latest revision as of 16:15, 24 May 2016

Client importation module


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



100
1
CliCedex



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

CliTitle



50

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

CliCategoryCode
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



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



100

CliProvince
CliProv
CliPro

25

CliReasonExclusion
CliReason


100
5
CliAnnualReceipt
CliAReceipt

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

CliReceiptStatus
CliReceiptS

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

CliWebsite
CliWeb


100

CliCanvasserCode
CliCanvCode

Existing solicitor Code
15
6
CliCanvasserName
CliCanvName

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
CliIsACanvasser
CliIsACanv

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


25
7
CliCanvasserActiveSince
CliCanvDateActive

Date
10
2, 7
CliCanvasserInactive

CliCanvInactive


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

Date
10
2, 7
CliPager



25

CliFax



25

CliPhoneOffice
CliOff


25

CliPhoneOfficeExt
CliOffExt
CliOffp

10

CliPhoneCell
CliCell


25

CliPhoneHome
CliRes


25

CliJobTitle



150

CliCity



50

CliCharacteristicLabel


Variable
Variable
8
CliCustomLabel


Variable
Variable
8
MailActOrigin


Existing origin
100
10
MailCodeActivity
MailActivity
MailAct
Existing activity Code
15
[*], 9
MailCodeOccasion
MailOccasion
MailOcca
Existing occasion Code
15
[*]
MailDateReg


Date
10
2
MailDescActivity



100
9,10
MailDescOccasion



100
10
MailResponse
MailRes

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 "Y" or "T" 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 canvasser assigned to the client. Be careful to not confuse with 7.

7 : Enables you to specify the information of a client that is a canvasser. 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 CliPeople.

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: CliPeople_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 CliPeople 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: CliPeople_note-1.


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

10 : Useful only if the "Create non-existent activities or occasion" option is selected. The use of more than one origin or description for a given activity or occasion 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

25
ConPhoneCell ConCell

25
ConPager

25
ConEmail
100
ConWebsite ConWeb

100
ConDateBirth ConBirth
Date
10 2
ConTitle ConApp

50
ConJobTitle


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

ConDateStart


Date
10
2
ConDateEnd


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 ClientNo2
CliNo2
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 (Empty = Link)
C = Contact
1

LinkDateStart


Date
10
1
LinkDateEnd

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