Importing and exporting users
Who is this article for?
Administrators responsible for managing users in Ideagen Hub.
Admin Console access is required.
You can bulk import users into Ideagen Hub using a CSV file.
This article outlines the key considerations, formatting requirements, and step-by-step process to ensure a smooth and successful import.
1. Considerations
Before you begin, review the following:
- Encoding - Your CSV file must be saved using UTF-8 encoding.
- Headers - The first row of your CSV must contain the column headers exactly as specified in the CSV column description table.
- Delimiter - Each column must be separated by a comma.
Tip
If you're using Microsoft Excel to edit your CSV file, double-check the export settings to ensure it uses commas as delimiters (not semicolons or tabs).
- Organization specific - Each CSV file is specific to a single organization represented by the subdomain of your Hub sign in URL e.g. https://exampleorg.us01.ideagenhub.com, where exampleorg is the subdomain. Do not include users from multiple subdomains in one file.
- Email case sensitive - For customers provisioned prior to Hub Release 5.2.0 (15th December 2025) that uses an email-based sign in and for users using Authentication Type: Internal, the email address you import into Hub is case sensitive. This means that person@example.com is not the same as Person@example.com. Ensure that email address used for sign-in matches what you have imported into Hub. This does not affect customers using Username-based sign in.
- Username - Once created this cannot be changed. Some apps require the use of email address as the username. Please consult with your account manager for further information.
-
Welcome emails
- Administrators imported as Active will be sent a welcome email immediately. To prevent this, import administrators with an Inactive status, and make them active once you are ready for them to sign in.
- By default, users who are not administrators will not be sent a welcome email. This is to allow administrators control over onboarding communications for the organization. This setting can be updated for each organization.
2. Updating a CSV file
2.1. Columns
Refer to the below table for a full breakdown of required and optional fields, valid formats, and examples.
| Item | Description | Valid values |
|---|---|---|
| AuthenticationType | User's authentication type. Defaults to Internal if left blank. |
|
| Username |
User-friendly unique identifier. Required and cannot be empty or null. This value can only be added or removed, not edited. Following Release 5.2, username is used as the sign in identifier. |
Prior to Release 5.2.0
Following Release 5.2.0
|
|
Used as the contact address to send email notifications from Hub. Also used for Ideagen Luminate. Required and cannot be empty or null. Prior to Release 5.2, email is used as the sign in identifier. If the email is updated, you will need to sign in using the updated email. Following Release 5.2, changes to the email address will not affect sign in to Hub, but will result in a new account being created for Luminate Community, Help, and Support. |
||
| FirstName | User’s first name. Required and cannot be empty or null. |
|
| LastName | User’s last name. Required and cannot be empty or null. |
|
| Status | User’s status. Defaults to Active if left blank. |
|
| Roles | User’s role(s) in Ideagen Hub. Defaults to User if left blank. |
|
| JobTitle | User’s job title. Can be blank. Max length is 250 characters. | |
| MobileNumber | User’s mobile number. Can be blank. |
|
| PreferredLanguage | User’s preferred language. Defaults to en-gb if blank. Currently, this is the only language supported. |
|
| TimeZone | User’s preferred time zone. Defaults to Europe/London if left blank. |
|
| Protected | Indicates whether the user is protected from deletion. Defaults to TRUE. |
|
| ProductInstances |
Indicates the apps instances that the user should be assigned to. Note: This setting only applies to Hub. Timeline for apps to integrate varies.
|
Following Release 6.0.0:
For more information, consult Configuring default app instances for your organization – Help | Ideagen Luminate |
| (application code:custom attribute name) | Reserved for system configuration. Multiple columns available per application. Modifications require coordination with support to ensure integration compatibility. |
|
Not sure how to build your own file?
You can find a template and an example import file in the Attachments section to help you put one together.You can also log in to Ideagen Hub, Admin Console, User Management and export the current Users List. This will provide you with a complete list of all the columns used for the Import CSV.
Do not change usernames of existing users in the file
It's currently not possible to change a user's username in Ideagen Hub. If you attempt to change an existing user's username via the CSV file:
- The original user will remain in the application.
- A new user will be created in both Hub and the application.
This results in:
- Two active users in Hub.
- One existing active user in the application.
- One new active user in the application.
Any data previously owned by the original user will remain associated with that original account.
3. Exporting a CSV file
If you already have users in your system, we recommend exporting your existing user list and using that CSV file as a basis for your import.
To export the file:
- Open the Admin Console.
- Go to User Management.
- Click Export.
4. Importing a CSV file
Once you've created or updated your CSV file, you have to import it for the changes to be reflected in Hub.
To import the file:
- Open the Admin Console.
- Browse to User Management.
- Click Import.
- Click New Import.
-
Upload your CSV file by selecting it or dragging it into the window.
The system will automatically validate the file to ensure:- All required headers are present
- Data is formatted correctly
If any issues are found, the import will be stopped and a list of errors will be returned for correction.
- Once validated, the CSV file is parsed.
During this step:- New users will be added.
- Existing users will be updated with the new details.
- Review the summary screen that shows the number of records imported successfully.
- Click Close to complete the process.
Attachments