Versions Compared

Old Version 7

changes.mady.by.user Ksenia Babych

Saved on

compared with

New Version 8

changes.mady.by.user Ksenia Babych

Saved on

Key

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

...


...



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>

...

Info

The Guide provides information about ways to implement import of contacts and users from external databases/ servers.

WMS Version: 3.87

Updated: February 2018

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

Table of Contents

General info

...

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

Map:

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

...

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:

  • 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

Image Added

Map

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

Filter

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

Office 365

Backend settings:

...

Click Available fields to see a drop-down list with all available fields which can be imported.

Map supported fields:

  • businessPhones
  • displayName
  • mail
  • givenName
  • jobTitle
  • mobilePhone
  • officeLocation
  • preferredLanguage
  • surname
  • userPrincipalName
  • department

...

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

...

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

...