Replicator for VW Cross

Please follow the general instructions for setting up a replicator on the Replicator Wizard page.

Procedure for Adding a Replicator

  1. Select the type of data source
    Select the database type "VW Cross".
  2. Data source settings:
    • Select the directory from which to import.
    • Specify the client number.
    • If "Continue replication on data errors" is selected, the line numbers of lines with errors are written to the VWCrossReplicator_<timestamp>.txt file in the log directory. Otherwise, replication will be aborted in case of data errors.
  3. Configure links to contact URL
  4. Datasource location settings
  5. Schedule replication plan
  6. Defining additional applications to be started
  7. Assigning a name for the new replicator

The VW Cross Replicator imports all initial as well as delta files with the following specifications:

Property Value
File format: UTF-8
BOM (Byte-Order-Mark) "0xEFBBBF" optional
Header with field label present ; field label fix after Feldzuordung
Separator "|"
Fields in quotes no
Comment sign none
Initial file name pattern cti_<Mandant>_<1 character>_<13 characters>_<32 characters>.csv
Delta file name pattern cti_<Mandant>_delta.csv
*Client: 5-digit client or company number


Notes:

  • Unlike other replicators, the field mapping is fixed.
  • Initial files are always imported first, then the delta files.
  • Initial files are renamed after successful import by appending "-<timestamp>.done" and thus are not replicated again.
  • If neither an initial nor a delta file is found in the replication directory, replication reports an error.


Field mapping:

CSV MetaDirectory LDAP-field
gptnr Primärschlüssel entryID
Displayname
(automatically generated)
displayName
name2 Given Name givenName
name1 Surname
(if gptyp_bez="Person")
sn
titel Position title
name1 Unternehmen
(if gptyp_bez="Firma")
company
Department department
Raum physicalDeliveryOfficeName
strasse Straße streetAddress
plz PLZ postalCode
ort Ort l
Bundesland st
intpostkz Land c
Straße privat privateAddressStreet
PLZ privat privateAddressPostalCode
Ort privat privateAddressCity
Bundesland privat privateAddressState
Land privat privateAddressCountry
Straße weitere otherAddressStreet
PLZ weitere otherAddressPostalCode
Ort weitere otherAddressCity
Bundesland weitere otherAddressState
Land weitere otherAddressCountry
E-Mail mail
E-Mail 2 mail2
E-Mail 3 mail3
SIP Adresse sipAddress
Web site url
telefonnr1 Tel. Geschäftlich telephoneNumber
telefonnr2 Tel. Geschäftlich 2 otherTelephone
telefonnr3 Tel. Unternehmen telephoneNumberCompanyMain
Tel. Assistent telephoneAssistant
Tel. Privat homephone
Tel. Privat 2 otherHomePhone
Tel. Primär telephonePrimary
Tel. Mobil mobile
Tel. Mobil 2 telephoneCar
Tel. Radio telephoneRadio
Tel. Pager pager
Tel. Rückruf telephoneCallback
Tel. ISDN telephoneISDN
Tel. TTYTTD telephoneTTYTTD
Fax gesch. facsimileTelephoneNumber
Fax priv. otherFacsimileTelephoneNumber
Kundennr customerid
Daten zum Öffnen des Kontaktes directOpenContact
Bemerkung info
gebdatum> Benutzer 0 custom0
Benutzer 1 custom1
gpbetrieb> Benutzer 2 custom2
gp_wuensch_vk> Benutzer 3 custom3
gp_wuensch_kdb Benutzer 4 custom4
letzte_kdb Benutzer 5 custom5
amtkennz1 Benutzer 6 custom6
amtkennz2 Benutzer 7 custom7
amtkennz3 Benutzer 8 custom8
modbezeichnung1 Benutzer 9 custom9
Bild jpegPhoto
Bildpfad imagePath
modbezeichnung2 Benutzer 10 custom10
modbezeichnung3 Benutzer 11 custom11
huautermin1 Benutzer 12 custom12
huautermin2 Benutzer 13 custom13
huautermin3 Benutzer 14 custom14
Benutzer 15 custom15
Benutzer 16 custom16
Benutzer 17 custom17
Benutzer 18 custom18
loesch_kz Benutzer 19 custom19

Version MetaDirectory_5.0