Register
Welcome to the Stormspire.net WoW Gold Forums!

Greetings, guest! Welcome to Stormspire.net, your #1 resource for WoW and Diablo 3 Gold, Professions, and everything in between!


Enjoy what the site offers? Consider Premium Membership if you wish to get the most out of the site. Premium Membership benefits include the acclaimed Goblineer's World of Warcraft Gold Guide, private forum access, a complimentary high-quality avatar, and much more!


If this is your first visit, make sure to check out the Stormspire.net Survival Guide for a quick site orientation. You may also register to unlock all standard forum features, and to get rid of these lovely ads!


We proudly host the Official forums for TradeSkillMaster, The Undermine Journal, and WoWuction.

Page 1 of 5 123 ... Last
Results 1 to 10 of 50
  1. #1
    US-Trollbane-A
    Entrepreneur
    Ayeron's Avatar
    Posts
    16
    Reputation
    7
    Tagged in
    4 Posts
    Add to this user's reputation

    [Tool] Accounting saved variables -> CSV conversion tool

    I wrote a ruby library to convert the accounting datafile to something useful out-of-game. The code is available on github.

    Since I imagine most people don't want to bother installing ruby/gems/writing a script to convert their data, I threw up a web frontend (edit: I've updated the link; this is now for the app on goblinengineering, since I'm not maintaining mine. Mad props to goblinengineering!). Saved variables go in, CSV comes out - never a miscommunication!

    A few things to be aware of:

    1. I don't do any sorting on the data, so don't expect the transactions to be in chronological order. You'll have to use your own CPU time to do that, sorry!
    2. There are two price fields - one is the copper value (the whole value is in copper) and the other is a (more useful) decimal field representing gold - copper is rounded to the nearest silver in this field.
    3. I'm not sure how well the web tool is going to scale with massive datafiles. I have ~10k records in mine and that's what I tested with. Please let me know if you start experiencing timeouts.
    4. All of your realm/factions should be handled.


    Please let me know if you have any problems, suggestions, or (even better!) patches. And I hope this is an appropriate place to post this - sorry if it isn't.
    Last edited by Ayeron; August 10th, 2012 at 09:53 AM.

  2. #2
    Sapy on US-Tichondrius(H)
    TSM Lead Developer
    Sapu94's Avatar
    Posts
    5,454
    Reputation
    270
    Blog Entries
    21
    Tagged in
    1593 Posts
    Add to this user's reputation


    Follow me and TSM on Twitter for important updates, news, and giveaways!
    TSM Website | TSM Chat Channel (IRC) | Donate | TSM FAQ

    "A good programmer is someone who always looks both ways before crossing a one-way street." ~Doug Linder

  3. #3
    EU
    Ethereal Contributor
    Nilaus's Avatar
    Posts
    586
    Reputation
    24
    Blog Entries
    6
    Tagged in
    288 Posts
    Add to this user's reputation
    @Ayeron That is awesome! +rep I was asking for this on IRC the other day so I could analyse my data in Excel.

  4. #4
    Wind Trader Emeritus
    Sinshroud's Avatar
    Posts
    2,603
    Reputation
    243
    Tagged in
    1018 Posts
    Add to this user's reputation
    Good contribution to the forums mate. +rep
    If someone makes a helpful post or useful thread, be sure to let them know by giving +reputation. Spread the love!

    If you are new to gold making, or want to expand your markets for greater profits, then consider becoming an Ethereal Contributor to gain access to additional guidance on gold making, as well as our private dedicated help and support forum.

    >> WoW Account Maximum Security Guide <<

  5. #5
    Diablo 3
    Wind Trader
    Reverb's Avatar
    Posts
    919
    Reputation
    102
    Tagged in
    304 Posts
    Add to this user's reputation
    I have been waiting on someone to make something similar to the techniques made for the mysales addon, and someone did. This sounds great. +rep

  6. #6
    US-Trollbane-A
    Entrepreneur
    Ayeron's Avatar
    Posts
    16
    Reputation
    7
    Tagged in
    4 Posts
    Add to this user's reputation
    I updated the tool to include the item ID in the CSV. I wanted it so I could VLOOKUP the item categories on and make this here pie chart:



    The category sheet is linked on the accounting page for your convenience. Eventually I may merge that info right in with the CSV.

    So yeah. Has anyone been using this? Any feature requests...? Bugs? Has it been working?
    <Lifebloom Services> - your source for overpriced crap and barely-functioning software!

  7. #7
    Entrepreneur
    zynga's Avatar
    Posts
    5
    Reputation
    0
    Tagged in
    1 Posts
    Add to this user's reputation
    It throws an error for me
    [h=We're sorry, but something went wrong.]1[/h]We've been notified about this issue and we'll take a look at it shortly.



    [Lua] accounting - Pastebin.com Thats my Accounting.lua

  8. #8
    Entrepreneur
    zmaniacz's Avatar
    Posts
    13
    Reputation
    0
    Tagged in
    3 Posts
    Add to this user's reputation
    Just submitted a patch on github that fixes the tool to parse mine and zynga's file correctly. Given the lack of response here, I'll probably and set up a similar web tool since I find this to be a pretty valuable resource.

  9. #9
    Sapy on US-Tichondrius(H)
    TSM Lead Developer
    Sapu94's Avatar
    Posts
    5,454
    Reputation
    270
    Blog Entries
    21
    Tagged in
    1593 Posts
    Add to this user's reputation
    Quote Originally Posted by zmaniacz View Post
    Just submitted a patch on github that fixes the tool to parse mine and zynga's file correctly. Given the lack of response here, I'll probably and set up a similar web tool since I find this to be a pretty valuable resource.
    Let me know if you do and I'll replace the link to this one with yours.


    Follow me and TSM on Twitter for important updates, news, and giveaways!
    TSM Website | TSM Chat Channel (IRC) | Donate | TSM FAQ

    "A good programmer is someone who always looks both ways before crossing a one-way street." ~Doug Linder

  10. #10
    Entrepreneur
    Aniailthor's Avatar
    Posts
    11
    Reputation
    0
    Tagged in
    2 Posts
    Add to this user's reputation
    I was wondering if there had been any further update to this? I keep getting the same error as Zynga when trying to use the web front end that was linked in the OP.

 

 
Page 1 of 5 123 ... Last

Similar Threads

  1. Synchronization of addon saved variables
    By tomatpasser in forum Archive (Addons and Macros)
    Replies: 14
    Last Post: April 15th, 2011, 06:03 PM
  2. Replies: 0
    Last Post: April 13th, 2011, 12:55 PM
  3. Inks from glyphs in tool tips?
    By Sidieon in forum Archive (Professions)
    Replies: 2
    Last Post: February 4th, 2011, 09:33 AM