You can add an existing database of users (for example, accounts on an e-mail server) to your M-Business Server user database. If you are using NT domain integration, you cannot import or export user information through the M-Business Server Administrator Console.
To import user data from another database, you must first output the user information in your existing database to a comma-separated values (CSV) file. When you specify the data elements to export, include the following three elements in this order:
User Name – a single-field identifier for the user, usually the one that is entered together with a password when the user is prompted for a user name and password when logging in. This often is referred to as a user ID.
First Name – the user’s first name, if first name and last name are stored in separate fields; the full user name if there is only one user name field.
Last Name – the user’s last name, if first name and last name are stored in separate fields; nothing if there is only one user name field. In the resulting CSV file, the first name entry should be followed by a comma and a linefeed or carriage return.
Log in to M-Business Server as admin.
In the Navigation Panel, choose Users » Export Users.
Use Browse to locate your formatted CSV file.
Click Next Step.
Up to 10 lines from your CSV file are displayed below the three headings, User Name, First Name, and Last Name.
Examine the data shown to verify it is being interpreted correctly.
If the data looks correct, but the first line contains column headings for the data below, check Ignore the first line of the file.
When you are ready to import your CSV file, click Add.
A message is displayed confirming the successful addition of the users or, if an error occurs during the import process, advises where it occurred.
Check for failed imports.
Any user records that failed to import are displayed. The most common cause of entries failing to import are:
The number of licensed users is exceeded.
The user name already exists in the M-Business Server SQL Anywhere database.
There is an illegal character somewhere in the information for the user.
Add these users to the M-Business Server database by importing another, corrected CSV file or by adding them manually.
The imported users now exist in the M-Business Server database, but they have null passwords. Users logging in for the first time are not required to enter a password and must use Settings » Change Password in the Navigation Panel to set up their own passwords. Advise your users of this requirement.
| Send feedback about this page using email. | Copyright © 2008, iAnywhere Solutions, Inc. |