Versions Compared

Old Version 36

changes.mady.by.user Tatiana Bieliakova

Saved on

compared with

New Version 37

changes.mady.by.user Tatiana Bieliakova

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

This guide explains how to import contacts and users from external databases / servers into a Wildix PBX.

WMS Version: 5.0X / 4.0X

Updated: March May 2022

Permalink: https://confluence.wildix.com/x/pQU8AQ

...

  • LDAP
  • Active Directory (+users sign-on)
  • Lotus Domino (+users sign-on)
  • MySQL
  • MSSQL
  • Hana DB
  • Office 365
  • Google 
  • Exchange Server 2010-2013 (supports only import of contacts)
  • Infusionsoft (import of contacts)
  • Zoho (import of users)
  • CSV file
  • Outlook (read the chapter Outlook Import)

...

“ID” and “Name” are required fields, since they are used as unique identifier of the contact / user.


3 - Remove existing contacts which are not received from the backend: if enabled, during the next sync, existing contacts which are no longer present in the database are deleted.

...

Note

Note: It is also possible to enable connection to MSSQL instance.

Requirement: SQL Server browser must be running on MSSQL host. Please check the Microsoft documentation for detailed information on SQL browser.

Backend settings:

  • Hostname: specify MSSQL instance in the form of ip_adress_of_SQL_server\instance_name. For example, 10.100.1.231\wildixdb
  • Port: there is no need to specify the port when connecting to MSSQL instance. By default MSSQL itself listens on TCP port number 1433, but for instances the TCP port is dynamically configured
  • User and Password: enter the credentials to access to MSSQL Server
  • Database name: the name of database to be imported
  • Timeout: specify connection timeout

Map

  • Check off the field that can be imported from MSSQL instance

Filter

  • Use the field to create a special select query if needed

Hana DB

Note

Note: The support starts from WMS5.04.20220506.5.

Backend settings:

  • Backend: select Hana DB
  • Hostname: IP address or domain name of remote server
  • Port: specify the port (30015 – default for Hana DB)
  • User: user with the rights to access to the server
  • Password: password of user to access to the server
  • Database name: name of the remote database
  • Timeout: connection timeout

Map supported fields:

  • Сheck off only those fields that can be imported from the remote database

Click Save and Import.


Office 365

Backend settings:

...