Converting Munis Role export file to CSV

Client needs full export of roles and user changed to CSV for Excel use

• Munis
• Roles
• Excel

The export role data application can only export to UNL file type

1. Follow this article to export the role data. Export and Import Munis Roles and Users
2. Find the exported file in the target directory
   1. This can likely be found in the export directory
3. Right click on the file and select Open in Notepad or Open in Notepad++
4. Next you will need to replace all pipe characters ( | ) from the file with a comma character (,)
   1. In the file highlight the pipe character and press CTRL + H:
      1. Find what: This should show |
      2. Replace with: Type in a comma (,)
   2. Click Replace all
      1. This will replace all pipe characters with a comma character now
5. Save the file as a .csv file type:
   1. Ex. rousratt.csv
6. Open this new .csv file in Excel and you should now be able to view the data in the Excel document

Please create a case with TSM Support for further assistance in the Support Portal.