Creating a .csv file containing user account information
The .csv file that contains the list of users to be imported into the OpenID Connect namespace must be properly formatted for the import to be successful.
The .csv file must use these formats:
- UTF-8 character encoding
- Windows CRLF for line breaks
The first row in the file is the header. This row must contain the email
column,
and can contain the following, optional columns: defaultName
,
businessPhone
, faxPhone
, givenName
,
homePhone
, mobilePhone
, pagerPhone
,
postalAddress
, surname
, userName
.
All other rows in the file contain values corresponding to the columns specified in the first row.
Here is an example of a .csv file with two users:
- Row 1:
email,defaultName,givenName,surname
- Row 2:
Andy.Bergin@ca.ibm.com,Andy Bergin,Andy,Bergin
- Row 3:
Kirsten.Vaughan@ca.ibm.com,Kirsten Vaughan,Kirsten,Vaughan
You can add all your users to one .csv file, or you can create multiple files with fewer names in each file.
After the file is imported, the defaultName
for the user is set in the following
way:
- If
defaultName
is specified in the .csv file, the name is used. - If
defaultName
is not specified in the .csv file, butgivenName
andsurname
are specified, the default name is set asgivenName surname
. - If
defaultName
,givenName
, andsurname
are not specified, theemail
is used as the default name.
Multiple users can have the same first and last names. To avoid potential conflicts, specify a
different defaultName
for the users, or do not specify surname
and
givenName
for them. You can also modify the surname
by adding a
unique character or number to it, such as Simpson1 or
Simpson2.