Export and Import Munis Roles and Users

• How do you Export Roles from and Import Roles into Enterprise ERP?
• Created roles in one database and need to move them into another without manual entry

• Security & User Administration
• Enterprise ERP

• Site created roles in the wrong Enterprise ERP database and needs to move them into the correct environment 
• Site is moving Enterprise ERP versions and needs to test before the entire database is copied over
• Site deleted a role and needs to copy it from another environment

• The Export Role Data program allows you to export role-based security control records from a database. Using the Import Role Data program, you can import the control records into another database.
• IMPORTANT! Backup the target Enterprise ERP Database or export the Roles/Users of the target environment before attempting the steps below!

Export Role Data

1. Log into source environment
2. From the Enterprise ERP menu, navigate to System Administration > Security > Export Role Data
3. Click Define
4. In the Export directory field, enter the full path where the program is to store the export file on the source environment's application server
   1. OnPrem Example: D:\musys\muntest\export_test
   2. SaaS Example: D:\musys\mun1234test\export_1234test
5. Choose desired Export Type
   1. All - export all role permission types
   2. Custom - enable custom export options for roles and users at bottom of the screen
6. Click Accept
7. Click Export
8. When complete, click OK

Move Exported Files

Move/copy the exported files from the source environment's export directory to the target environment's import directory. SaaS hosted sites, please reach out to TSM SaaS Support to have the files moved.

• roassign.unl
• rousratt.unl
• rousrmst.unl
• rodtlmnu.unl
• rodtlmod.unl
• rodtlper.unl
• rodtlrng.unl
• rolemast.unl

Import Role Data  

1. Ensure a backup of the target database has been taken before proceeding
2. Log into target environment
3. From the Enterprise ERP menu, navigate to System Administration > Security > Import Role Data
4. Click Define
5. In the Import directory field, enter the full path of the location where the import file is stored on the target environment's application server
   1. OnPrem Example: D:\musys\muntrain\import_train\
   2. SaaS Example: D:\musys\mun1234train\import_1234train\
6. Complete the import option fields as desired
7. Click Accept
8. Click Import
9. On RBAC Import pop-up, click Yes
10. When complete, click OK

• SaaS hosted clients: Prod and Non-Prods are hosted on different servers. TSM SaaS can assist with moving the files out of the EXPORT Dir and into the IMPORT Dir for the environment needing the import.   
• This is typically done with implementation or in coordination with deployment during server or version upgrades
• Process required when refreshing database is not an option to copy roles from one database to another