Html |
---|
<div id="fb-root"></div> <script>(function(d, s, id) { var js, fjs = d.getElementsByTagName(s)[0]; if (d.getElementById(id)) return; js = d.createElement(s); js.id = id; js.src = 'https://connect.facebook.net/en_US/sdk.js#xfbml=1&version=v2.11'; fjs.parentNode.insertBefore(js, fjs); }(document, 'script', 'facebook-jssdk'));</script> |
...
Html |
---|
<div class="lang-box-pdf"> <div> <div class="google-lang"> <div id="google_translate_element"> </div> <script type="text/javascript"> function googleTranslateElementInit() { new google.translate.TranslateElement({pageLanguage: 'en', includedLanguages: 'de,es,fr,it,nl', autoDisplay: false}, 'google_translate_element'); } </script> <script type="text/javascript" src="//translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script> </div> <div class="pdf-button"> <a href="https://confluence.wildix.com/spaces/flyingpdf/pdfpageexport.action?pageId=20710821" alt="Convert to .pdf" title="Convert to .pdf"><img src="https://confluence.wildix.com/download/attachments/14549012/pdf-button-download-wildix-documentation.png"></a> </div> </div> </div> |
Info |
---|
The Guide provides information about ways to implement import of This guide explains how to import contacts and users from external databases / servers into a Wildix PBX. WMS Version: 3.87 Updated: February 2018 Permalink: https://confluence.wildix.com/x/pQU8AQ |
Table of Contents |
---|
General info
For import of users:
- Go to WMS -> Users
- Click Import (the option is available only for admin user)
...
- Go to WMS -> Users -> Phonebooks
- Select an existing phonebook or click + to add a new Phonebook
- Click Import
1 Note that in case of WMS network, each PBX has its own Phonebooks, which must be imported separetely
1 - Backend settings: settings for the synchronization of Collaboration PBX phonebooks with an external database / server.
...
- LDAP
- Active Directory (+users sign-on)
- Lotus Domino (+users sign-on)
- MySQL
- MSSQL
- Office 365
- Exchange Server 2010-2013 (supports only import of contacts)
- CSV file
- Outlook (read the chapter Import of Contacts and Users - Admin Guide - English)
2 - Map: in this section you can set up parameters for the correct association of the Collaboration Phonebook fields to the ones of the external database. Leave the checkboxes of only those fields which can be imported from the external database.
...
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 will be are deleted.
4 - Erase existing value if empty value is received: if enabled, during the next sync, fields which are empty, will be are deleted.
5 - Filter (available for LDAP, AD, Lotus Domino, MySQL/ MSSQL): this section allows you to create a special select queryhere you can write a special SQL Select statement.
6 - Scheduled job: settings of the synchronization (if disabled, the sync must be done manually each time). Set the period for performing the sync (1/ 2/ 6/ 12/ 24 hours) and enter the email of a user who will receive notifications each time the scheduled job is done:
...
10 - Cancel button: close the window without saving parameters
LDAP
Backend settings:
- Backend: select LDAP
- Hostname: IP address or domain name of remote server
- Port: specify the port (389 by default)
- 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=wildixad,dc=local)
...
In this example only those users whose category is “person” or “user” and whose status is “not disabled” from the “Map” section will be imported.
Active Directory
Backend settings:
- Backend: select AD
- Hostname: IP address or domain name of remote server
- Port: specify the port (389 by default)
- 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)
- Sign-on (import of users): enable the option to allow sign-on with AD credentials for imported users
- 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
...
In this example only those users whose category is “person” or “user” and whose status is “not disabled” from the “Map” section will be imported:
Lotus Domino
Backend settings:
- Backend: select Lotus Domino
- Port: port for connection to the server
- Hostname: IP address or domain name of remote server
- User: user with the rights to access to the server
- Password: password of user to access to the server
- Sign-on (import of users): enable the option to allow sign-on with Lotus Domino credentials for imported users
- 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
...
- Full Name: cn
- Login: userPrincipalName
- Extension: ipPhone
- Fax: facsimileTelephoneNumber
- Office: telephoneNumber
- Email: mail
- Mobile: mobile
- Language: preferredLanguage
Department: ou
WEB password: userPassword
SIP password: wuserPasswordSip
MySQL / MSSQL
Backend settings:
- Backend: select the backend (MySQL or MSSQL)
- Hostname: IP address or domain name of remote server
- Port: specify the port (3306 – default for MySQL / 1433 – default for MSSQL)
- 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
...
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
|
Office 365
Backend settings:
- Backend: select Office 365
...
Click Available fields to see a drop-down list with all available fields which can be imported.
Map supported fields:
- businessPhones
- displayName
- givenName
- jobTitle
- mobilePhone
- officeLocation
- preferredLanguage
- surname
- userPrincipalName
- department
...
In this way all values present in the "E-mail" field of the remote server/ database will be imported into the "E-mail" field of Collaboration Phonebook.
Backend settings:
- Backend: select Google
...
Click Available fields to see a drop-down list with all available fields which can be imported.
Map:
- Check off only those fields that can be imported from Google contacts
...
In this way all values present in the "Address" field of the remote server/ database will be imported into the "Address" field of Collaboration Phonebook.
Exchange Server
Backend settings:
- Backend: select ExchangeServer
- Hostname: IP address or domain name of remote server
- User: user with the rights to access to the server
- Password: password of user to access to the server
...
Click Available fields to see a drop-down list with all available fields which can be imported.
Map:
- Check off only those fields that can be imported from Exchange Server
...
In this way all values present in the "Address" field of the remote server/ database will be imported into the "Address" field of Collaboration Phonebook.
CSV
Backend settings:
- Backend: select CSV
...
The values in the file should be separated by coma (,) and enclosed into the quotation marks (“). You can download a sample CSV file by clicking Download sample CSV when importing contacts in WMS -> Devices -> Phonebooks.
Outlook Import
Import of Outlook contacts cannot be done via WMS.
...