Import Users from File statement

Creates new users based on the information in the comma-separated values (CSV) file that you specify. The information in the CSV file must match the syntax used in the Create User command.

IMPORT USERS FROM FILE "csv_file_name";

where:

FILE "csv_file_name" is the location and name of the CSV file containing the users to be imported, of type string.

Example

IMPORT USERS FROM FILE "C:/Users.csv";

CSV file requirements

The first row of the CSV file must contain, at a minimum, the required keywords as noted in the syntax of the Create User command. Include all the keywords that you will supply for each user and separate the keywords by a comma. Each row after the first row represents one user to import. In these rows, supply the information (which corresponds to the keywords in the first row), and separate the values with a comma. If you are adding a user to multiple groups using the Parents keyword, place brackets around each group name and do not add commas between the group names.

An example set of rows in a CSV file is provided below. Importing a file containing this information creates two users.

NAME,FULLNAME,PASSWORD,CHANGEPWD,ALLOWCHANGEPWD,PARENTS
cbecker,Cornelius 
 Becker,pwd123,TRUE,TRUE,[Managers][MicroStrategy Web Analyst][MicroStrategy 
 Web Reporter]
 baoter,Barbara 
 Aoter,pwd456,TRUE,TRUE,[Managers]