BusinessObjects Enterprise Administrator's Guide

Using text files with the Import Wizard

The Import Wizard can import any of the following from text files:

• Users
• Groups
• Profiles
• Data source credentials

A combination of users, groups and profiles can be in one file, but data source credential must be in a separate text file.

Text file format

All text import file data must be in the comma-separated value (CSV) file format. For specific details on what each field represents, see Importing users, groups and profiles and Importing data source credentials. The CSV format stipulates the following:

• The comma (,) is the default separator.
• The default delimiter is double quotes (").
• The fields that contain a separator must begin and end with a delimiter.

  For example, if you wanted the value Smith, John in a field, you would enter "Smith, John".

• The fields that contain a delimiter, must begin and end with a delimiter and use two delimiters where one is required.

  For example, if you wanted the value "quotes", you would enter """quotes""", if your delimiter was double quotes. If your delimiter was a single quote ('), and you wanted the value dog's, you would enter 'dog''s'.

Note:    The default delimiter and the default separator can be changed on the "Select options for file import" dialog box.