Import Users

Important Notes:

Importing users into the database should be handled by a knowledgeable and skilled staff member. Please carefully read the instructions below.

The required format for import is a file containing tab separated fields with each record terminated by a newline character (\n). Any line containing a newline character (\n) within any field will cause the import to be terminated on that record.

  1. Below is the format that is required by SPT for import. If UserPassword is left blank, it will default to UserName. Users should be instructed to change their password after they login.
  2. The fields must be in the following order:
    • UserName (required)
    • UserPassword
    • Email (required)
    • Website
    • RealName (required)
    • Address1
    • Address2
    • City
    • State
    • Country
    • Zipcode
    • ActiveUI (eg, default, Horizons, etc.)
    • DefaultBrowsingField (eg, Classification, GEM, etc.)
    • UserAccessPrivilege (eg, System Administrator, Classification Administrator, etc)
  3. There should be one line for each User Access Privilege assigned to the user. The UserName field must be filled in, but the other fields may be left blank, provided the tabs characters remain.
  4. Password encryption should NOT be used if the inport file is from another site (this preserves the original password values). Password encryption should be used if the file is hand genenerated, and the password in the import file is not encrypted. Use the "Browse..." button below to locate your local file for import. Initiate import by clicking on the "Begin Import" button. Your file will be uploaded to the server and the user accounts imported.

Password Encryption: Don't Encrypt Password Encrypt Password
File Name: