Help

GuildRosterDump

Guild Login to Add Favorites
  • 1 Like
  • World of Warcraft
  • 1,621 Downloads
  • Supports: 4.0.6
  • 1 Average Daily Downloads
  • Comments
  • Created 10/13/2009 2:49:59 PM
  • Updated 2/26/2011 2:47:59 PM
  • 12 Favorites
  • Project Site
  • License: Apache License version 2.0
  • Release Type: Release
  • Newest File: v4.0.1-Release
or

About GuildRosterDump

Overview

In patch 3.2.2 Blizzard removed the /saveguildroster function for security reasons. So if you have a large guild, or just want to keep a backup of your guild info, you will have no way of tracking your guild info or backing it up to off-realm storage.

This addon introduces a new slash command, /gdump, which addresses this need. When invoked it will pop up an edit box containing the guild roster info in tab-delimited (CSV) format for easy copy-paste into Excel or some other tool. It is very lightweight and uses almost no memory or saved variable space.

The format of the CSV data is as follows:

Name – Rank – Level – Class – Zone – Note – OfficerNote – LastOnline – Status

One record per line, TAB delimited. A header row is included. Just select, copy and paste into Excel.

Bugs and Suggestions

Please post any bugs and suggestions on the CurseForge project page. Thanks!

tag v4.0.1-Release
2041d4b9f5991febb4fd5a5b9c2912cfe77afa58
PProvost <peter@provost.org>
2011-02-26 13:47:30 -0700

Tagging v4.0.1-Release

--------------------

PProvost:
    - Update to README
    - Updated TOC and changed delimiter to TAB
    - Typo in toc file
    - Added rankindex for numerincal sorting in excel. Changed month/day/hour formatting to %02d
    - Updated toc to patch 3.3
    - Update to readme
    - Another update to readme
    - Update to readme
    - Minor tweaks before first beta
    - Minor frame tweaking for usability
    - Forgot to rename in toc file too
    - Renamed files to new project name
    - Tuned the logic. Much more efficient now.
    - Ditched bogus commas in the lastOnline part of the CSV
    - Rewrote to stop using savedvars. Still having issues with the GuildRoster() throttling.
    - Removed vim temp files. BOO!
    - Initial version using saved vars

Comments

  • #5
    Hey Quaiche,

    I have 5 operational guilds, and this is a UBAR program! Thanks so very much! You have saved me TONS of work from when I do officers meetings to let everyone know stats!
    I only have one request - I do programming myself, and so I know that this would not be a major implementation, just maybe a little time to incorperate...I think. Is there any way possible that you could add 2 columns, which would be Profession and current level? This gives me a way to track who is doing what and how they are progressing. Also, I have my guild vaults set up to be mats only, so that it helps those leveling and having available mats to make whatever is needed. This tool would also raise a "red flag" in the event, for instance, I see a tailor drawing out a lot of metal.
    At any rate, really do appreciate it, and am going to pass the word around to my friends who have guilds as well.
    Thanks much!
  • #3
    Hey, first of all. Great and easy to use addon. I'm wondering though, how can I change the way you present the info? If possible I would like it to have it presented so I can directly import the info to my SQL database.
    The format SQL uses is:
    INSERT INTO `Roster` (`Name`, `Rank`, `Level`, `Class`, `Zone`, `Note`) VALUES
    (Player1, '0', '80', 'Paladin', 'Neverland', 'Need more cake'),
    (Player2, '1', '83', 'Warrior', 'Over there', 'Cakeless'),
    (Player3, '2', '85', 'Druid', 'Somwhere', 'Another note');

    Is there maybe a way I can maybe edit your files for my use? Seeing as there probably is few people who wants this I wouldn't go as far as to request it as a feature :P
  • #4
    Never mind that, I reprogrammed my uploads script to handle it. Now what I do wonder about, is it any way to remove the first line? The one that says Class, Name, and so forth. Or else I have to delete it each time, there is nothing wrong with that, hardly takes time. But it would be nice to know how ^^
  • #2
    I use your add on all the time, it is easy, and saves me so much time. It would be amazing if I could dump the guild professions by member into Excel. Is there any way to do this?

    Thanks again it is a must for all Guild Masters
  • #1
    So glad this is available! When I hit Paste in Excel, I selected the Text Import Wizard to set the delimiter to semicolons and it worked great!!! I like that even with full 500 members filled, it only takes a few seconds to grab the data!
    It dumps the data in whatever order your guild list is currently arranged (which column, default is rank) so set that up beforehand if you want it specific.
    Thanks so much!
  • To post a comment, please login or register a new account.
Learn how to disable ads
Learn how to disable ads
Login to Curse

Don't have an account? Create One.

Get an epic experience with Curse Premium
  • Faster Addon Downloads
  • Premium-Only Beta Giveaways
  • Ad-Free Curse.com Experience
  • Premium Curse Client
  • and many More Features
  • Learn More »

Minecraft 3D Print Giveaway

Enter Now!