You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »


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:

  • 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:

NameType (Max Length)RequiredContent
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)
Client.
ServiceTEXT (32)
Service.
ReferenceNumberTEXT (32)
Reference Number e.g. from the foreign system.
NameTEXT (32)JaSurname.
FirstNameTEXT (32)JaFirst name.
SalutationTEXT (16)
Mr. Mrs. etc.
TitleTEXT (16)
Dr. etc.
CompanyTEXT (32)
Company.
AddressTEXT (32)
Street.
PostalCodeTEXT (10)
Post Code.
CityTEXT (32)
City.
CountryTEXT (32)
Country.
AccountOwnerTEXT (32)
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)
Email.
WebsiteTEXT (64)
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)
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


  • No labels