BusinessObjects Enterprise Administrator's Guide

Importing users, groups and profiles

The Import Wizard can import users, groups and profiles from text files. Files used to import users, groups or profiles must be structured as follows:

• Each row in the text file defines 1 record.
• Each record consists of 6 fields.
• Each field must have separator between it and the next field.
• Each field, can potentially be blank except for field 1.

One single record can define either a group or a user or a group, a user and a profile. Text files must be saved in UTF-8 format.

Note:    

• The default separator is a comma but this can be changed on the Select options for file import dialog box.
• If a character in the any field of the record is the same as the character used for a separator it must be delimit. The default delimiter character is a double quote.

User record Format

Field Number	Contents of field
Field 1	Group name
Field 2	User Name
Field 3	Full name of user
Field 4	Email address of user
Field 5	Profile name for user.
Field 6	Profile value for user.

e

Note:    Profile values must be enclosed in quotes. See Text file format for information on using delimiter.

Example user record

Sales,Psanders,Paula Sanderson,psanders@Acme.com,
Manager,West Region

The previous record would create an account name or username of "psanders" in BusinessObjects Enterprise. The name Paula Sanderson, and the e-mail address of psanders@Acme.com would be associated with this account name. The username "psanders" would be member of the group "Sales". The username psanders and would be assigned the profile "Manager" with the profile value of "West Region".

Group Record Format

Field Number	Contents of field
Field 1	Group name
Field 2	Null
Field 3	Description of group.
Field 4	Field is ignored.
Field 5	Profile name for group.
Field 6	Profile value for group.

Note:    Profile values must be enclosed in quotes. See Text file format for information on using delimiter.