Zum Hauptinhalt gehen

CSV oder SQL-Datenbanken als Adressbuch-Quelle für phonebridge® CONTACTS einrichten

  • Aktualisiert

Ablauf

Adressbuch-Quelle "CSV"

phonebridge® holt regelmäßig eine CSV-Datei laut unserer Vorlage von Ihrem HTTP(S)-Webserver ab. Sie definieren dazu eine URL auf einem beliebigen Server samt Zugangsdaten.

 

Adressbuch-Quelle "SQL"

  1. Sie erstellen ein individuelles Script in einer Programmiersprache Ihrer Wahl (z.B. Java, Python, Bash,...), welches Ihre SQL-Datenquelle in Ihrem Netzwerk liest und als CSV-Datei speichert.
  2. Danach lädt Ihr Script die erstellte CSV-Datei automatisch auf einen FTP- bzw. Webserver Ihrer Wahl hoch.
  3. Sie erstellen einen phonebridge® CONTACTS Connector, der automatisch und regelmäßig Ihre CSV-Datei von Ihrem Webserver abholt, einliest und als Telefonbuch bereitstellt (per phonebridge® LDAP Server oder direktem Sync in Ihre Telefonanlage).

 

CSV-Datei

Die CSV-Datei ist laut phonebridge® CSV-Vorlage zu erstellen.  

 

CSV-Vorlage

Eine CSV-Beispieldatei finden Sie hier: sample.csv 

 

CSV Felder

  • internal_id* //contact ID on source side

  • display_name* //contact display name

  • family_name* // family name

  • given_name* // given name

  • middle_name // middle name

  • birthday // birthday date in format yyyy-MM-dd

  • nickname //nicknametype:nickname. Nick name types:

    • DEFAULT

    • MAIDEN_NAME

    • INITIALS

    • OTHER_NAME

  • honorific_prefix // The honorific prefixes, such as Mrs. or Dr.

  • honorific_suffix // The honorific suffixes, such as Jr.

  • gender // gender

  • address // client address. Is multiline escaped value. Eeach subvalue of address is starting from one reserved keyword followed by : character. Reserved keywords:

    • type: address type HOME, WORK or OTHER

    • po_box: The P.O. box of the address.

    • street: The street address.

    • extended: The extended address of the address; for example, the apartment number.

    • city: The city of the address.

    • region: The region of the address; for example, the state or province.

    • postal_code: The postal code of the address.

    • country: The country of the address.

    • country_code: The ISO 3166-1 alpha-2 country code of the address.

      The combination with reserved keyword and followed : symbol (i.e. country:) should not be used in address subvalue body.

  • phone // phonetype:+12345678987.

    • Phone types: HOME, WORK, MOBILE, HOME_FAX, WORK_FAX, OTHER_FAX, PAGER, WORK_MOBILE, WORK_PAGER, MAIN, OTHER, WORK_2, CALLBACK, CAR, WORK_MAIN, HOME_2, ISDN, PRIMARY_PHONE, ASSISTANT

  • email // emailtype:tester@junit.org.

    • Email types: HOME, WORK, OTHER

  • url // urltype:http://contacturl

    • URL types: HOME, WORK, BLOG, PROFILE, HOME_PAGE, FTP, OTHER

  • organization // client organization. Is multiline escaped value. Eeach subvalue of organization is starting from one reserved keyword followed by : character. Reserved keywords:

    • name: // The name of the organization.

    • type: // The type of the organization SCHOOL, UNIVERSITY, WORK, GOVERNMENTAL, NON_PROFIT, OTHER

    • department: // The contact's department at the organization.

    • title: // The contact's job title at the organization.

    • job_description: // The contact's job description at the organization.

    • start_date: // The start date when the contact joined the organization. Date format is yyyy-MM-dd

    • end_date: // The end date when the contact left the organization. Date format is yyyy-MM-dd

    • current: // True if the organization is the contact's current organization; false if the organization is a past organization.

    • location: // The location of the organization office the contact works at.

      The combination with reserved keyword and followed : symbol (i.e. location:) should not be used in organization subvalue body.

  • occupation

*required field

 

CSV Dateistruktur

  • Base specification for given CSV format is https://tools.ietf.org/html/rfc4180.

  • Document should have standard CSV format. Each field value is the string and should be escaped by quota " if contains any special characters according of CSV standard. If the string already contains the character ", it should be escaped as "".

  • Space and special characters "(),:;<>@[\] or line breaks are allowed with restrictions (they are only allowed inside a quoted string, as described in the paragraph below, and in addition, a backslash or double-quote must be preceded by a backslash);

  • First line of document is the header line and should contains the column names. The header line is mandatory. The order of columns is not important and is defined by header line.

  • Following columns "address, organization, phone, email, url" can be multiple presented.

  • The separator character can be anything allowed by CSV specification. The separator from header row will used then as separator for value rows.

 

Felder

URL

Die URL zu Ihrer CSV-Datei. Beispiele:

  • http://download.phonebridge.io/test/sample.csv
  • https://download.phonebridge.io/test/sample.csv
  • http://download.phonebridge.io:8080/test/sample.csv

Username

Der Benutzername für HTTP Basic Auth.

 

Password

Das für Basic Auth zu übermittelnde Passwort.

Verwandte Beiträge