Importing User Details from DB_General 1

 Administrators
 Basic

You can import User details from other Database (DB), such as MS SQL.

To import User details from DB:

  1. Select Admin > Basic > Users > Import > DB Import.
  2. On the DB IMPORT page, click ADD NEW on the ACTIONS panel. Type in the required details. For more information about fields on the DB IMPORT page, see Field Description.
  3. Click SUBMIT.

    DB IMPORT page
    Figure:  DB IMPORT page

Field Description

The following table describes the fields on the DB IMPORT page:

Field

Description

DETAILS

SQL Server Name

Specify the SQL Server Name.

Database Name

Specify the database Name of the specified SQL server.

Login

Specify the login name to access the specified SQL database server.

Password

Type in the password.

Confirm Password

Re-enter the password for confirmation.

SQL Query

Write the SQL query to import user details from the other database to Summit database.

icon

Click this icon to validate the specified SQL statement and to display in the Destination Column field values.

Sl no.

Displays the serial number for the source columns fields.

Source Column

Displays the standard fields from SUMMIT.

Required

Displays if the source is mandatory. If Yes, it indicates the source field is mandatory.

Destination Columns

Lists the validated destination column data to map to the Source column. Select any one option from the list.

ACTIONS

This section explains all the icons displayed on the ACTIONS panel of the DB IMPORT page. 

SHOW LIST

Click SHOW LIST to display the LIST table showing details of the imported DB.


Figure:  DB IMPORT page: List of imported DBs

Note:

When the imported DB details are displayed under the LIST table, the ADD NEW action is displayed on the ACTIONS panel. Click ADD NEW to import data from a DB as described in this topic.

References