Guild Roster Tools Info:
Use /grt to open the Guild Roster Export Tool in game.
GuildRosterTools will export to C:/Users/<yourcomputer>/AppData/Roaming/NCSOFT/Wildstar/AddonSaveData/<randomlookingletters>/<server name>/<character name>/GuildRosterTools_0_Char.XML
Guild Roster Tools will only auto-export regularly while you are logged in, and this is triggered by events affecting your guild's roster (people logging in, logging out, opening the guild roster, etc.). You can manually override the auto export by opening using the slash command /guildtools and clicking the Export Roster button.
IMPORTANT: The data export client has been released, but if you're not comfortable installing and running command prompt commands with Administrator privileges, you may want to wait for the official "easy install" release.
If you don't want to use the installer, then you will find up-to-date xml data with a filepath similar to this one, where terms in < > are variables unique to your computer and game client: C:/Users/<your computer username>/AppData/Roaming/NCSOFT/Wildstar/AddonSaveData/<randomlookingletters>/<server name>/<character name>/GuildRosterTools_0_Char.XML
If you are running the export client:
You will have a .csv file created in C:\WildStar Rosters\ that contains your most current roster export. This file is created automatically by the client monitor service any time your addon save file is updated (when you reloadui, log out, or exit game). The files will be named in a way that you shouldn't have problems with overwriting accidentally by other characters (since your various characters might be in different guilds).
Other Required Libraries/Tools Info:
For those that are brave, smart, or fearless, here is the xml to csv conversion tool that we made to bring the data in. You can use the .csv with normal csv programs.
We are finalizing our code for a guild management template using GoogleDocs, and it will do everything for you except convert and upload your rosters. Pay attention to this space as we move forward to full release.
UPDATES: (newest listed first)
06/09/14:
- Added a fix for the rare instances of reported errors of returning Circle members instead of Guild Members (as intended).
05/24/14:
- Changed command to /grt to invoke the manual export window at the request of a user.
- Changed the manual export information text to provide better information where to start looking for exported data.
- Added raw data field for "Days Offline". This field is a decimal-based field, and is intended for use with spreadsheet programs to calculate offline times.
- Added player level field as requested by a current user.
- Fixed variable name that was causing an error.
05/08/14:
- Removed library reference for methods no longer supported by Carbine.
For those that are running the export client and want nice HTML exports.....i have created a powershell script that takes the export csv from the client and converts it to an easily readable HTML page (including class colors).
The only requirement is to edit the Guild Roster Tools lua file and remove the export of player notes.
The reason is that player notes can mess up the csv layout due to them accepting characters such as "," and ";" etc.
When removing the player note field from the export, all is well and my script makes nice HTML pages.
Let me know if someone is interested and i can upload a copy tonight including the edited lua.
Example of a HTML export:
http://s8.postimg.org/av54fmgl1/Capture.jpg
Ps. this addon has a bug where it exports the circle (when you join one) instead of your guild...not sure why it does this?
Bug returned that reports circle members instead of guild members.
It's strange, anyway to force an export? I've logged into the game 3 times since yesterday, I've even used /grt and clicked the export now button, it says it's exported, but if I go look at the date in my addonsavedata in appdata, it hasn't updated the file since yesterday.
It usually saves when you reloadui or log out. Are you running any addons that interact with the guild window (such as the addon to only show online friends)? Open the xml file in notepad or a text editor and delete everything between <Document> and </Document> tags (I use Eclipse to edit with, but you could use other things).
Start the game, use /grt and do a manual export, then /reloadui. If you use Eclipse, and leave the xml open when you reloadui, Eclipse will prompt you to update your code because it changed.
I just followed this process, and it loaded perfectly for me.
If it doesn't work for you, let me know.
How about a clear statement about what this addon is supposed to do?
This addon saves a table of your guild roster in the addon saved data folder for each character you have.
You can use the converter client we made to convert the xml to .csv so it opens easier in Excel or Google Spreadsheets. Or, you can convert it yourself.
how is nTimeLastExported formatted so I can translate it in Excel? IE: my last export was 1403197443
epoch/POSIX/UNIX time
The number of seconds since Jan 1st, 1970.
http://www.epochconverter.com/
Divide the number by 86,400 and then add 25,569 (the number value for the 0 point for epoch time, which is 01/01/1970 at midnight). Format that as a date (or date & time) in Excel, and it should be accurate. I'm showing that your time was at 5pm.
Sorry, I posted that right after I posted the first one, then left work lol, when I hopped online at work this morning it posted LOL. Yeah I figured it out after pulling my head out.
Darn, for some reason mine's not exporting, I don't have a C:\WildStar Rosters folder. Wonder if I have some sort of conflict or something.
Are you using the monitor service(GTAS:Monitor)? If so, there is an error log in the folder you extracted it to. Please send me the error log via PM, and I'll forward it to the Monitor app author and we'll look at it to see what's going on. If you're not using the monitor service app, then you won't have that file, you'll only have the xml in your addon save data folder.
No, not to my knowledge. I do run a lot of addons though. Thanks for letting me know it is in %appdata% too! Works for me.
I'm a bit confused as to where these are supposed to end up with regards to the conversion tool. It puts them in the character name folders under addonsavedata/randomalphabetname/server but the service for the converter seems to be watching the addonsavedata folder. Am I missing something?
Nope. The .csv file created by the monitor services is saved to C:\WildStar Rosters\ . The file that is saved by the addon is found in addonsavedata/semi-randomalphabetname/server/character/GuildRosterTools_0_Char.xml. That's the file that the monitor service is watching. When that file changes (when you reloadui, log out, or exit game), then the monitor automatically creates a new version of the .csv file.
Did I describe that well enough?
I'm going to change the description a bit to be more clear about what happens if you're running the monitor.
Hmm that is where I expected it to monitor. I will try going through the steps again.
So where I extract the monitor files does not matter, I would need to run the install command in the folder I put the monitor files in. Does it matter where I run the start command (file path wise)?
The monitor is an auto-restart service, so once installed, it should always run. I've had it stop once, and it restarted on reboot (it actually restarted fine, but failed to find the monitored filepath).
The monitored file is found automatically based on how WildStar saves addon data. The only thing you have to do is read the readme for first-time install and starting service and you're done. Doesn't matter where you install, saves to C:\WildStar Rosters\ regardless.
Check the folder you unzipped the monitor client to for the log, and PM me the error log text if it's not working.
I love you. That is all.
Why, thanks, I love you, too.
Quick fix:
Change GuildRosterTools.lua lines 250-251 from:
end
return tGuild
to:
end
tGuild = GuildLib.GetGuilds()[1]
return tGuild
Edit made by Addon Author: This "fix" may or may not cause problems. I have written in a fix that accounts for this user's report, and it won't break your addon's function. (sorry for editing your comment, I didn't want people adding these lines without reading my comments below).