Fields
The individual fields for dialler contacts are documented in the import / export list below.
Importing and Exporting
Importing and Exporting Contacts requires a scheme -see Import Export Schemes for details.
Fields
The 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. | ||
| 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) |
Example Scheme
An XML example definition is provided here to illustrate the XML Import / Export Scheme definition required for dialler contacts.
<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>