How to Import Bulk Users or Groups in TIBCO Nimbus

How to Import Bulk Users or Groups in TIBCO Nimbus

book

Article ID: KB0072176

calendar_today

Updated On:

Products Versions
TIBCO Nimbus Applicable to all versions

Description

How to Import Bulk Users or Groups in TIBCO Nimbus?

Issue/Introduction

This article will help to import bulk users or Groups in the Nimbus system.

Environment

Test and Production

Resolution

Users or Groups can be imported from a CSV file. So you can prepare the CSV file by using the below format. Please test this on the Test environment before proceeding ahead with Production.

The format For User's CSV:
Last Name,First Name,Groups,Email,Account Name,Password,Account Type,Preferred Server,Change Module,Action Module,Reports To,Job Title,Comment,URL Substitution,Landing Page (name),Street Address,City,State/Province,Zip/Post Code,Country,Mobile Phone,Work Phone,System Roles

User's Import CSV example:
Jones,Jack,Technical;Project Management;UK,jjones@email.com,Jack.Jones,******,Contributor,http:// <Server>/TIBCO Nimbus/CtrlWebISAPI.dll,True,False,True,John Doe,Engineer,Works from home,Storyboards,1 Hollywood Drive,Los Angeles,California,123456,United States of America,1234567890,9876543210,Statement Set Manager

The format for Group's CSV:
Group Name,Group Description,Parent Group 1;Parent Group 2;Parent Group n,Use LDAP,LDAP DN,LDAP Server

Group's Import CSV example: 
Group A,Group A Description,,Yes,Group1DN,LDAPServer1 
Group B,Group B Description,Group A,Yes,Group2DN,LDAPServer1

Import Rules · ​​​​​
  1. Important: If any of the fields in the CSV file are left blank and you choose to update existing user information from the import file, any information that already exists for those blank fields will be removed in the user's account.
  2. The group's field is optional in the User's CSV. If used, one or more groups can be defined and separated by semi-colons and the user will become a member of those groups. If the group does not exist then the group will be created. ·
  3. The preferred server field is the user's preferred server URL, as defined in the ServerURL.npdta file (set in the Details tab of users' account details). Either the full URL can be specified, or an integer value. This value is case-insensitive and if no match is found then the default preferred server will be used.
  4. The first line in the CSV file is ignored as it will be assumed that this contains column header information.
  5. A log file (GroupImport.log) is created in the root of the Process Repository, listing the results of the import. 
  6. Distinguished names must be unique in Group's CSV.
Please follow the below steps to import the CSV file.
1. From the Tools menu choose Users and then User Accounts.
2. From the File menu choose Import User Accounts From CSV / Import User Groups from CSV.
3. Click Browse to locate the CSV file.
4. Choose one of the following options: ·
"Ignore / Skip existing users" will not update user accounts that already exist in the system.
Allow passwords to be reset/changed for existing user accounts
"Ignore/Skip existing groups" will not upload or modify any user groups that already exist in the system.
"Overwrite existing groups on import" will update any duplicate groups in the system from the information in
5. Click Ok

Additional Information

Import Users 
Import Groups
Users/Gropus CSV Format
Format