Fields The individual fields for dialler contacts are documented in the import / export list below. Importing and ExportingImporting and Exporting Contacts requires a scheme -see Import Export Schemes for details. FieldsThe following fields are defined: | Name | Type (Max Length) | Required | Content |
|---|
| dtImported | DATETIME |
| Date and time of import in the format YYYY-MM-DD HH:mm:SS | | DiallerCampaignsName | TEXT (64) |
| Name of the dialer campaign. Not required during import (the dialler campaign is selected explicitly). | | UserData | TEXT (64) |
| Foreign system key or ID. | | Client | TEXT (64) |
| Client. | | Service | TEXT (64) |
| Service. | | ReferenceNumber | TEXT (64) |
| Reference Number e.g. from the foreign system. | | Name | TEXT (64) | Ja | Surname. | | FirstName | TEXT (64) | Ja | First name. | | Salutation | TEXT (16) |
| Mr. Mrs. etc. | | Title | TEXT (16) |
| Dr. etc. | | Company | TEXT (64) |
| Company. | | Address | TEXT (64) |
| Street. | | PostalCode | TEXT (10) |
| Post Code. | | City | TEXT (64) |
| City. | | Country | TEXT (64) |
| Country. | | AccountOwner | TEXT (64) |
| Account owner. | | AccountBank | TEXT (32) |
| Bank. | | AccountNationalBankCode | TEXT (10) |
| National bank code. | | AccountBIC | TEXT (11) |
| BIC. | | AccountNumber | TEXT (20) |
| Account number. | | AccountIBAN | TEXT (34) |
| IBAN. | | Amount | NUMBER |
| Amount. | | PhoneNumber1 | TEXT (32) | Ja | Telephone number 1 in E.164 format. | | PhoneNumber2 | TEXT (32) |
| Telephone number 2 in E.164 format. | | PhoneNumber3 | TEXT (32) |
| Telephone number 3 in E.164 format. | | PhoneNumber4 | TEXT (32) |
| Telephone number 4 in E.164 format. | | PhoneNumber5 | TEXT (32) |
| Telephone number 5 in E.164 format. | | PhoneNumber6 | TEXT (32) |
| Telephone number 6 in E.164 format. | | FaxNumber | TEXT (32) |
| Fax number. | | Email | TEXT (32) |
| Email. | | Website | TEXT (64) |
| Website. | | Comment | TEXT (Unlimited) |
| Comments | | ReservedUsersUID | TEXT (32) |
| UID of the agent, which has reserved this contact. | | FollowUpUsersUID | TEXT (32) |
| UID of the agent, which owns the follow up appointment or delay. | | FollowUpDateTime | DATETIME |
| Appointment or delay date and time for this contact. | | ResultCodesExportKey | TEXT (32) |
| Export key of the dialler result code. | | Done | NUMBER (Empty, 0 or 1) |
| Result code = done | | Aborted | NUMBER (Empty, 0 or 1) |
| Result code = aborted | | Appointment | NUMBER (Empty, 0 or 1) |
| Result code = appointment (in dialler) | | Delay | NUMBER (Empty, 0 or 1) |
| Result code = delayed (in dialler) | | bPhoneNumber1Invalid | NUMBER (Empty, 0 or 1) |
| Telephone number 1 is invalid (determined by dialler) | | bPhoneNumber2Invalid | NUMBER (Empty, 0 or 1) |
| Telephone number 2 is invalid (determined by dialler) | | bPhoneNumber3Invalid | NUMBER (Empty, 0 or 1) |
| Telephone number 3 is invalid (determined by dialler) | | bPhoneNumber4Invalid | NUMBER (Empty, 0 or 1) |
| Telephone number 4 is invalid (determined by dialler) | | bPhoneNumber5Invalid | NUMBER (Empty, 0 or 1) | | Telephone number 5 is invalid (determined by dialler) | | bPhoneNumber6Invalid | NUMBER (Empty, 0 or 1) |
| Telephone number 6 is invalid (determined by dialler) |
An XML example definition is provided here to illustrate the XML Import / Export Scheme definition required for dialler contacts. | Code Block |
|---|
<importExport2>
<import>
<type>CSV</type>
<encoding>UTF-8</encoding>
<delimiter>;</delimiter>
</import>
<export>
<type>CSV</type>
<encoding>UTF-8</encoding>
<bom>1</bom>
<delimiter>;</delimiter>
</export>
<fieldMappings>
<fieldMapping internalField="RandomSortOrder" externalField="Priority" externalType="INTEGER" importOnly="true"/>
<fieldMapping internalField="ReferenceNumber" externalField="RefNumber" externalType="VARCHAR"/>
<fieldMapping internalField="ExternalSystemLink" externalField="Hyperlink" externalType="VARCHAR"/>
<fieldMapping internalField="" externalField="EKCODE" externalType="VARCHAR"/>
<fieldMapping internalField="Salutation" externalField="Sal" externalType="VARCHAR"/>
<fieldMapping internalField="Name" externalField="Name" externalType="VARCHAR"/>
<fieldMapping internalField="FirstName" externalField="First" externalType="VARCHAR"/>
<fieldMapping internalField="Address" externalField="Addr" externalType="VARCHAR"/>
<fieldMapping internalField="Country" externalField="Country" externalType="VARCHAR"/>
<fieldMapping internalField="PostalCode" externalField="PostCode" externalType="VARCHAR"/>
<fieldMapping internalField="City" externalField="City" externalType="VARCHAR"/>
<fieldMapping internalField="PhoneNumber1" externalField="Tel1" externalType="TEL:49"/>
<fieldMapping internalField="PhoneNumber2" externalField="Tel2" externalType="TEL:49"/>
<fieldMapping internalField="Email" externalField="Mail" externalType="VARCHAR"/>
<fieldMapping internalField="Tag" externalField="DataIdentifier" externalType="VARCHAR"/>
<fieldMapping internalField="UserData" externalField="CustomerNumber" externalType="VARCHAR"/>
<fieldMapping internalField="dtBeginDate" externalField="StartDate" externalType="DATETIME:dd.MM.yyyy"/>
<fieldMapping internalField="dtEndDate" externalField="EndDate" externalType="DATETIME:yyyyMMdd"/>
<fieldMapping internalField="Client" externalField="ClientName" externalType="VARCHAR"/>
<fieldMapping internalField="" externalField="NotImported1" externalType="VARCHAR"/>
<fieldMapping internalField="" externalField="NotImported2" externalType="VARCHAR"/>
<fieldMapping internalField="" externalField="NotImported2" externalType="VARCHAR"/>
</fieldMappings>
</importExport2> |
| 