ConventionsThe 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 (")
FieldsThe following fields are defined: Name | Type (Max Length) | 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) | | Client. | Service | TEXT (32) | | Service. | Name | TEXT (32) | Ja | Surname. | FirstName | TEXT (32) | Ja | First name. | Salutation | TEXT (16) | | Mr. Mrs. etc. | Title | TEXT (16) | | Dr. etc. | Company | TEXT (32) | | Company. | Address | TEXT (32) | | Street. | PostalCode | TEXT (10) | | Post Code. | City | TEXT (32) | | City. | Country | TEXT (32) | | Country. | AccountOwner | TEXT (32) | | 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. | 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) |
"DiallerContact";"2017-07-16 07:28:44";"Sub-Campaign";"123123122";"Client";"Service";"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; |
|