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. Note, not all fields can be imported and will be ignored if present. Name | Type (Max Length) | Import | Required | Content |
---|
ResetContact | BOOLEAN | Yes |
| If set to true, the contact will be reset if it is overwritten on importing. This resets all relevant fields in the dialler. | 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. | Region | TEXT (256) |
|
| Region. | 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> |
|