Sv translation |
---|
|
Fields The individual fields for dialler contacts are documented in the import / export list below. Importing and ExportingImporting and Exporting Contacts requires a scheme -see Import Export Schemes for details. FieldsThe following fields are defined: Name | Type (Max Length) | Required | Content |
---|
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. | 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. | 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) | 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) |
An XML example definition is provided here to illustrate the XML Import / Export Scheme definition required for dialler contacts. Code Block |
---|
<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> |
|
Sv translation |
---|
|
Hinweis Warning |
---|
|
title | Überholt ab Release 3.19 |
---|
|
Dieses Import / Export Format wird ab release 3.19 nicht mehr weiterentwickelt, und bietet keine Zugriffsmöglichkeiten auf neue Felder
und Einstellungen. Anstattdessen sollte Import Export Schemes verwendet werden.Felder
Die individuellen Felder pro Dialer Kontakt werden in der Tabelle unten beschrieben.
Konventionen
Der Import / Export Format für Dialer Kontakte ist CSV. Die CSV Dateien müssen folgende Konventionen einhalten:
- CSV Format
- Jede Zeile beinhaltet ein Datensatz
- Felder im Datensatz werden durch Semikolon (vorzüglicherweise) getrennt
- Werte in Text und Datumsfelder werden mit Hochkomma (") angegeben
- Nur numerische Felder dürfen ohne Hochkomma (") angegeben werden
Felder
Importieren und Exportieren
Das Importieren und Exportieren benötigt ein Schema - siehe Import Export Schemes.
Felder
Folgende Felder sind definiert:
Name | Typ (Max Länge) | Änderungen ab Release 3.19 | Pflicht | Inhalt | DiallerContact | TEXT (Fest) | Ja | Fest, muss den Wert "DiallerContact" enhalten. |
---|
dtImported | DATETIME |
| Datum und Uhrzeit des Imports im Format YYYY-MM-DD HH:mm:SS |
DiallerCampaignsName | TEXT (64) |
| Name der Dialler Kampagne. Wird beim Importieren nicht genutzt, da hier die Kampagne explizit angewählt wird, kann beim Importieren leer gelassen werden. |
UserData | TEXT (64) |
| Fremdsystemschlüssel oder ID. |
Client | TEXT (32) | TEXT (64) |
| Bezeichnung Mandant. |
Service | TEXT (32) | TEXT (64) |
| Bezeichnung Dienst oder Betrieb. |
ReferenceNumber | TEXT (32) | TEXT (64) |
| Referenznummer für das Fremdsystem. |
Name | TEXT (32) | TEXT (64) | Ja | Nachname. |
FirstName | TEXT (32) | TEXT (64) | Ja | Vorname. |
Salutation | TEXT (16) |
| Anrede. |
Title | TEXT (16) |
| Titel. |
CompanyTEXT (32) | TEXT (64) |
| Firma. |
AddressTEXT (32) | TEXT (64) |
| Straße. |
PostalCode | TEXT (10) |
| PLZ. |
CityTEXT (32) | TEXT (64) |
| Ort. |
Country | TEXT (32) | TEXT (64) |
| Land.AccountOwner |
Region | TEXT( | 32256) |
| Region. |
AccountOwner | TEXT (64) |
| Kontoinhaber. |
AccountBank | TEXT (32) |
| Bank. |
AccountNationalBankCode | TEXT (10) |
| BLZ. |
AccountBIC | TEXT (11) |
| BIC. |
AccountNumber | TEXT (20) |
| Kontonummer. |
AccountIBAN | TEXT (34) |
| IBAN. |
Amount | ZAHL |
| Betrag. |
PhoneNumber1 | TEXT (32) | Ja | Telefonnummer 1 in E.164 Format. |
PhoneNumber2 | TEXT (32) |
| Telefonnummer 2 in E.164 Format. |
PhoneNumber3 | TEXT (32) |
| Telefonnummer 3 in E.164 Format. |
PhoneNumber4 | TEXT (32) |
| Telefonnummer 4 in E.164 Format. |
PhoneNumber5 | TEXT (32) |
| Telefonnummer 5 in E.164 Format. |
PhoneNumber6 | TEXT (32) |
| Telefonnummer 6 in E.164 Format. |
FaxNumber | TEXT (32) |
| Faxnummer. |
Email | TEXT (32) | TEXT (256) |
| E-Mail. |
Website | TEXT (64) | TEXT (Unbegrenzt) |
| Webseite. |
Comment | TEXT (Unbegrenzt) |
| Kommentar. |
ReservedUsersUID | TEXT (32) |
| UID des Agenten, der dieser Datensatz zugeordnet ist. |
FollowUpUsersUID | TEXT (32) |
| UID des Agenten, der einen Termin auf diesen Datensatz zugeordnet ist. |
FollowUpDateTime | DATETIME |
| Termin oder Verzögerungstermin für diesen Kontakt. |
ResultCodesExportKey | TEXT (32) |
| Export-Key des Result-Codes im Dialer. |
Done | ZAHL (Leer, 0 oder 1) |
| Result Code = erledigt. |
Aborted | ZAHL (Leer, 0 oder 1) |
| Result Code = abgebrochen. |
Appointment | ZAHL (Leer, 0 oder 1) |
| Result Code = termin (im Dialer). |
Delay | ZAHL (Leer, 0 oder 1) |
| Result Code = verzögert. |
bPhoneNumber1Invalid | ZAHL (Leer, 0 oder 1) |
| Telefonnummer 1 ist ungültig (durch Dialler-Versuch ermittelt) |
bPhoneNumber2Invalid | ZAHL (Leer, 0 oder 1) |
| Telefonnummer 2 ist ungültig (durch Dialler-Versuch ermittelt) |
bPhoneNumber3Invalid | ZAHL (Leer, 0 oder 1) |
| Telefonnummer 3 ist ungültig (durch Dialler-Versuch ermittelt) |
bPhoneNumber4Invalid | ZAHL (Leer, 0 oder 1) |
| Telefonnummer 4 ist ungültig (durch Dialler-Versuch ermittelt) |
bPhoneNumber5Invalid | ZAHL (Leer, 0 oder 1) |
| Telefonnummer 5 ist ungültig (durch Dialler-Versuch ermittelt) |
bPhoneNumber6Invalid | ZAHL (Leer, 0 oder 1) |
| Telefonnummer 6 ist ungültig (durch Dialler-Versuch ermittelt) |
Code Block |
---|
|
"DiallerContact";"2017-07-16 07:28:44";"Unterkampagne 1";"123123122";"Mandant";"Dienst";"Referenznummer";"Nachname";"Vorname";"Anrede";"Titel";"Firma";"Straße";"PLZ";"Ort";"Land";"Kontoinhaber";"Bank";"BLZ";"BIC";"Kontonummer";"IBAN";Betrag;"49199111111";"49199222222";"49199222222";"49199444444";"49199555555";"49199666666";"Fax";"E-Mail";"Webseite";"Kommentar";"agent1";"agent1";"2017-07-17 10:00:00";"TERMIN";;;1;0;0;0;0;0;0 |