Hi All
Is there a way when exporting all users and have the security roles alphabetized horizontally within the csv file?
Hi, I'm not aware if this option is available, if somebody knows would be nice.On the mean time I guess that you could try to work it on excel. Perhaps creating a Macro that could help you doing something like:- Copy the roles.- Transpose vertically- Order By- Transpose back to Horizontally- Copy back to original source.Good luck.Paulo
A better solution is to use the IFS API or SCIM and bring in all records into a local DB - MSSQL in our case, and then do as you please since you have the golden ticket. We automate that to run daily and it works beautifully !!!
Hey there,
Another option you can do is export all of the roles and users via OS > Security > Configure > Master Data Types > Security Roles. It will only export the username(likely email) and the role name but then you can use a vlookup to pull in the other information from the IFS level export. This will give you the ability to sort the role name(s) as needed. Can always use a pivot table to adjust this too.
