Fields
The individual fields for dialler contacts are documented in the import / export list below.
Notes
Deprecated from Release 3.19
This scheme is legacy and is no longer supported. You should use Import Export Schemes instead.
Conventions
The import / export format for dialler contacts is CSV. The CSV files must adhere to the following conventions:
- CSV format
- Every line contains one record
- Fields in each record are separated by a semicolon (recommended)
- Values in text and date / time fields are surrounded by quotation marks (")
- Only numeric field values can be specified without quotation marks (")
Fields
The following fields are defined:
Name | Type (Max Length) | Changes from Release 3.19 | Required | Content |
---|---|---|---|---|
DiallerContact | TEXT (Fixed) | Ja | Fixed, must contain "DiallerContact". | |
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 (32) | TEXT (64) | Client. | |
Service | TEXT (32) | TEXT (64) | Service. | |
ReferenceNumber | TEXT (32) | TEXT (64) | Reference Number e.g. from the foreign system. | |
Name | TEXT (32) | TEXT (64) | Ja | Surname. |
FirstName | TEXT (32) | TEXT (64) | Ja | First name. |
Salutation | TEXT (16) | Mr. Mrs. etc. | ||
Title | TEXT (16) | Dr. etc. | ||
Company | TEXT (32) | TEXT (64) | Company. | |
Address | TEXT (32) | TEXT (64) | Street. | |
PostalCode | TEXT (10) | Post Code. | ||
City | TEXT (32) | TEXT (64) | City. | |
Country | TEXT (32) | TEXT (64) | Country. | |
AccountOwner | TEXT (32) | TEXT (64) | Account ewner. | |
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) | TEXT (256) | Email. | ||
Website | TEXT (64) | TEXT (Unlimited) | 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 Record
"DiallerContact";"2017-07-16 07:28:44";"Sub-Campaign";"123123122";"Client";"Service";"ReferenceNumber";"Name";"FirstName";"Salutation";"Title";"Company";"Address";"PostalCode";"City";"Country";"AccountOwner";"AccountBank";"AccountNationalBankCode";"AccountBIC";"AccountNumber";"AccountIBAN";Amount;"49199111111";"49199222222";"49199333333";"49199444444";"49199555555";"49199666666";"Fax";"E-Mail";"Website";"Comments";"agent1";"agent1";"2017-07-17 10:00:00";"APPT";;;1;0;0;0;0;0;0