Novacura User Export and Import

[daniel]

Welcome to the second edition of “Free Flow Friday”! Once a month, I will try and build an application and post it here for your viewing an learning pleasures.

This application was created to ease the migration of user data from one instance to another.

Key Benefits

Export

• JSON or CSV file types supported
• For CSV, user definable delimiter
• Basic user information such as user id, name, email
• Roles
• User properties

Import

• JSON or CSV file types supported
• For CSV, user definable delimiter
• Automated creation of missing Roles and User properties
• Password generation
• Send email to new user account’s email
• Add, modify, delete user accounts
• Detailed summary of performed actions

Limitations

• Cannot export user passwords
• Cannot export user connector information

Prerequisites:

You need two connectors: File System and Flow Environment

Guide

1. Be sure you have satisfied all the prerequisites
2. Import the User Export.flow into the environment you want to export and User Import.flow into the environment you are migrating to
3. In the User Export application, change the Defaults assignment step variable “filePath” to where you want to export your JSON or CSV file to
4. I recommend exporting to JSON, but if you elect to use CSV, it will prompt you for what file delimiter you want to use
5. After exporting, launch the User Import application
6. If you used CSV, change the delimiter in Custom Defaults
7. You should also change a number of other parameters in this assignment step to match your needs like: “SendEmail” will automatically send an email to the newly created user with their new password; “EmailAddresses” is the admin(s) email(s) to send the summary of changes to; “CheckValidCsvEmails” will perform a regular expression match on inputted email addresses to verify that they are correct and fit email standards; “FileDelimeter” is used for CSV imports; and if you ever add any export fields to the User Export application, be sure to change the structure to match in the “ImportTableCSV” variable.

Screenshots

Export

Import

Download

This link is good for 365 days from the creation of this post. Download it here.

[wpuymac]

That’s great, thanks, Daniel. I also created a similar flow for our service desk where they can select a user in one environment and just copy to the other environment. So that makes it easy for just one step and one user, too.