That's pretty slick. My apologies to you for never listening in the past.
I "massaged" groups.xsl and created a users.xsl which will do similar extraction for user entries. I also created a trio of batch files to help make running this a little easier.
Unzip xml2csv.zip into the folder where your Unitrunker.xml (or other xml files if you have done an export as per the info page Rick linked to) is located.
You can run (from a command prompt)
xml2csv-grp filename (without the .xml extension) to extract group data to
filename-groups.csv;
xml2csv-usr filename (again, no .xml extension) to extract user data to
filename-users.csv; or
xml2csv filename to extract both at once to the respective filenames listed above. The XSL files I included will give slightly more descriptive column headings and wrap the alpha fields (tag, label, etc) and the color value in quotes, since Excel sometimes spazzes out on those with CSV files if they're not enquoted. Both XSL files have been tested on an exported system from my Unitrunker.xml, which contains over 200 groups and 9000+ users.
The one thing that the batch files crap out on is if your exported system name has a space in it. For example
xml2csv APCO P25BEE00-123 will break with an error from the msxsl.exe program (which, btw, I didn't include in the zip, get it from the link Rick supplies on his page). The above filename is what Unitrunker will give you if you export system BEE00-123. Just rename it to something that doesn't have a space in it and you'll be fine. (I tried the usual command prompt tricks of putting the filename in quotes, but msxsl still didn't like it for some reason.)
I'd need to spend a lot more time with the tutorial to figure out how to extract, say, sites and channels/frequencies, or for example to convert flags like "logon" in the user data to human-readable values, and my brain isn't switched on enough right now to go poring through that tutorial. Hope this works well enough for you for now though.
exporting user ids in unitrunker
Linear Mode
