Notes

This scheme is legacy and does not provide access to new fields and settings. You should use Import Export Schemes instead.

Fields

The individual fields for dialler contacts are documented in the import / export list below.

Conventions

The import / export format for dialler contacts is CSV. The CSV files must adhere to the following conventions:

Fields

The following fields are defined:

NameType (Max Length)Changes from Release 3.19RequiredContent
DiallerContactTEXT (Fixed)
JaFixed, must contain "DiallerContact".
dtImportedDATETIME

Date and time of import in the format YYYY-MM-DD HH:mm:SS
DiallerCampaignsNameTEXT (64)

Name of the dialer campaign. Not required during import (the dialler campaign is selected explicitly).
UserDataTEXT (64)

Foreign system key or ID.
ClientTEXT (32)TEXT (64)
Client.
ServiceTEXT (32)TEXT (64)
Service.
ReferenceNumberTEXT (32)TEXT (64)
Reference Number e.g. from the foreign system.
NameTEXT (32)TEXT (64)JaSurname.
FirstNameTEXT (32)TEXT (64)JaFirst name.
SalutationTEXT (16)

Mr. Mrs. etc.
TitleTEXT (16)

Dr. etc.
CompanyTEXT (32)TEXT (64)
Company.
AddressTEXT (32)TEXT (64)
Street.
PostalCodeTEXT (10)

Post Code.
CityTEXT (32)TEXT (64)
City.
CountryTEXT (32)TEXT (64)
Country.
AccountOwnerTEXT (32)TEXT (64)
Account ewner.
AccountBankTEXT (32)

Bank.
AccountNationalBankCodeTEXT (10)

National bank code.
AccountBICTEXT (11)

BIC.
AccountNumberTEXT (20)

Account number.
AccountIBANTEXT (34)

IBAN.
AmountNUMBER

Amount.
PhoneNumber1TEXT (32)
JaTelephone number 1 in E.164 format.
PhoneNumber2TEXT (32)

Telephone number 2 in E.164 format.
PhoneNumber3TEXT (32)

Telephone number 3 in E.164 format.
PhoneNumber4TEXT (32)

Telephone number 4 in E.164 format.
PhoneNumber5TEXT (32)

Telephone number 5 in E.164 format.
PhoneNumber6TEXT (32)

Telephone number 6 in E.164 format.
FaxNumberTEXT (32)

Fax number.
EmailTEXT (32)TEXT (256)
Email.
WebsiteTEXT (64)TEXT (Unlimited)
Website.
CommentTEXT (Unlimited)

Comments
ReservedUsersUIDTEXT (32)

UID of the agent, which has reserved this contact.
FollowUpUsersUIDTEXT (32)

UID of the agent, which owns the follow up appointment or delay.
FollowUpDateTimeDATETIME

Appointment or delay date and time for this contact.
ResultCodesExportKeyTEXT (32)

Export key of the dialler result code.
DoneNUMBER (Empty, 0 or 1)

Result code = done
AbortedNUMBER (Empty, 0 or 1)

Result code = aborted
AppointmentNUMBER (Empty, 0 or 1)

Result code = appointment (in dialler)
DelayNUMBER (Empty, 0 or 1)

Result code = delayed (in dialler)
bPhoneNumber1InvalidNUMBER (Empty, 0 or 1)

Telephone number 1 is invalid (determined by dialler)
bPhoneNumber2InvalidNUMBER (Empty, 0 or 1)

Telephone number 2 is invalid (determined by dialler)
bPhoneNumber3InvalidNUMBER (Empty, 0 or 1)

Telephone number 3 is invalid (determined by dialler)
bPhoneNumber4InvalidNUMBER (Empty, 0 or 1)

Telephone number 4 is invalid (determined by dialler)
bPhoneNumber5InvalidNUMBER (Empty, 0 or 1)
  Telephone number 5 is invalid (determined by dialler)
bPhoneNumber6InvalidNUMBER (Empty, 0 or 1)

Telephone number 6 is invalid (determined by dialler)



"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