Scroll export button | ||||||||
---|---|---|---|---|---|---|---|---|
|
Info |
---|
This guide explains how to import contacts and users from external databases / servers into a Wildix PBX. WMS Version: 5.0X / 6.0X Updated: May 2023April 2024 Permalink: https://wildix.atlassian.net/wiki/x/0xnOAQ |
...
- LDAP
- Active Directory (+users sign-on)
- Lotus Domino (+users sign-on)
- MySQL
- MSSQL
- Hana DB (import of contacts)
- Office 365
- Exchange Server 2010-2013 (supports only import of contacts)
- Infusionsoft (import of contacts)
- Zoho CRM / Bigin (import of users)
- CSV file
- Outlook (read the chapter Outlook contacts lookup and call generation)
...
- Backend: select AD
- Hostname: IP address or domain name of remote server
- Port: specify the port (389 by default)
- Secure connection: enable encryption during the connection
- User: user with the rights to access to the server
- Password: password of user to access to the server
- Base DN: Distinguished Name of the base depends on customer’s database structure (e.g. dc=wildix,dc=local)
Windomain (import of users): the domain name that user name is connected to and which is required for Active Directory authentication
Note Note: The Windomain field is available starting from WMS 5.04.20220425.1
In case the Windomain field is empty, the data is taken from Base DN.
Full domain (import of users): the field allows to add a custom domain
Note Note: The Full domain field is available starting from WMS 5.04.20220819.1.
Sign-on (import of users): enable the option to allow sign-on with AD credentials for imported users
Note Note: Automatic AD Single Sign-on is available. Consult Active Directory Single Sign-On for details.
- Allow only single Sign-on (import of users): enable the option to allow only single sign-on. If the option is enabled, login of users to Collaboration with WEB password is not possible
...
- Example: SELECT ${MAP} FROM `export_csv_user_10000` WHERE `type`="user"
- Example for query for import of of contacts from SAP Business One: select '' as empty, OCRD.CardCode, CardName, Name, Tel1, OCPR.Fax, Cellolar, E_mailL, Title from OCRD INNER JOIN OCPR ON OCRD.cardcode = OCPR.cardcode where cardtype = 'S' (More information on SAP B1 integration: https://www.wildix.com/sap-business-one/
In this example only those fields from the “Map” section will be imported, which are present in “export_csv_user_10000” table and only for contacts whose type is “user”.
...
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:
Map
Filter
|
...
- businessPhones
- displayName
- givenName
- jobTitle
- mobilePhone
- officeLocation
- preferredLanguage
- surname
- userPrincipalName
- department
- extensionAttribute1-15
Note |
---|
Note: The support of the field 'extensionAttribute1-15' starts from WMS 6.01.20230123.2. It allows to sync Custom attributes. The necessary attribute needs to be entered in the Extension field. |
...
Note |
---|
Import of users only. |
Read the Depending on whether you want to import users from Zoho CRM or Zoho Bigin, read the relevant document:
...
Outlook contacts lookup and call generation Anchoroutlookimport outlookimport
outlookimport | |
outlookimport |
...