Register
Page 1 of 3 123 Last
Results 1 to 10 of 24
  1. #1

    [Tool] Another TSM_Accounting to CSV conversion tool‏

    NOTE: Iíve updated the conversion tool to read files in the new TSM 2.0 Accounting format. The TSM App will eventually have this feature built in, but in the meantime Iíll keep updating this tool. The tool only extracts the AH transactions.

    TSMAParse is a tool to parse a TSM_Accounting saved variables file and generate a comma delimited file with the extracted transactions. You can open the resulting CSV file in Excel.

    To use the tool, extract the program to a folder and run TSMAParse.exe. The proper usage is:

    TSMAParse [inputfile] [outputfile]

    If you donít specify any parameters, TSMAParse will open a Windows form to let you enter the input and output files.

    TSMAParse.PNG

    You will find your TSM_Accounting saved variables in your World of Warcraft install folder, in the subfolder "WTF\Account\<AccountName>\SavedVariables\TradeSki llMaster_Accounting.lua"

    Each line in the output file contains the following information: Faction/Realm, Character, Buyer/Seller, Action, Item ID, Item Name, Stack Size, Quantity, Date, Time, Amount per Item. The price is in copper. For example, in the following line Chel bought 160 Elementium Ore from Mickey on May 5th, at a price of 18400 copper (1g84s00c) per ore. TSM_Accounting seems to combine multiple transactions into a single entry.

    Alliance - Medivh, Chel, Mickey, buy, 52185, Elementium Ore, 20, 160, 05/05/2012, 17:57:47, 18400

    I used Proudmoore's python script as a starting point, which in turn is a rewrite of Aeyron's ruby library. The result is a .NET Windows console application (sorry Mac users).

    The tool uses the Luainterface library for reading the saved variables file. The Luainterface project home is http://code.google.com/p/luainterface/ if you would prefer to download Lua.dll and LuaInterface.dll directly. LuaInterface has some dependencies on the VisualC++ runtime library. Itís likely that you already have the VisualC++ runtimes on your machine, but if not, the recommended way of deploying the dependencies is to install the redist from here.

    If you have any problems running TSMAParse, or have any suggestions for improvements, please let me know.

    Application:
    TSMAParse 2.0.zip - updated 19Aug2013

    Source (C#, compiled in Visual Studio 2010):
    TSMAParse_Source 2.0.zip - updated 19Aug2013
    Last edited by Chel; August 19th, 2013 at 02:57 PM. Reason: Updated TSMAParse

  2. #2

    Aaaand the Mac version ^.^

    Hi there Chel,

    I'm dabbling into mac programming, and one interesting task for a newbie like me is manage to wrap a GUI around any command line program/script, soooo, i managed to make a mac version with very simple but functional gui for your script.

    I put your script within the package to ease out the process, i just modified the input for the script, by accessing it through sys.argv[] so it could be made more pipeable to the wrapped arpund gui.

    I don't know if any further aknowledgements have to be made. And i say it for real, it's my first software offered to the public ^.^


    It's here and any feedback would be apreciated.

    PS: If any further protocol has to be fullfilled, just tell me, i really couldn't have made it without your wonderfull script that does all the hard work
    Last edited by Shadowcharly; May 11th, 2012 at 01:54 PM. Reason: Update the link Again

  3. #3
    Quote Originally Posted by Shadowcharly View Post
    Hi there Chel,

    I'm dabbling into mac programming, and one interesting task for a newbie like me is manage to wrap a GUI around any command line program/script, soooo, i managed to make a mac version with very simple but functional gui for your script.
    Hi Shadow,

    It looks like you wrapped a GUI around Proudmoore's python script, not the .NET app that I wrote. I don't have a Mac, so I can't see how your GUI works, but anything that makes life easier is a good thing in my books.

  4. #4
    Oops, misplaced the post.

    Absolutely tru, i wrapped my gui around Proudmoore's python script. Better put it there too.

  5. #5
    I updated my TSM_Accounting tool TSMAParse, mainly to add a Windows interface in addition to the CLI interface. It should also now work properly for people who are running in a language other than English. I updated the original post with the details.

  6. #6
    Nvm rtfm.....
    Last edited by xEclipse; May 6th, 2013 at 02:05 PM.

  7. #7
    One thing: The export file use a comma and a space as separator. Can you make it so it doesn't add the space? This makes it weird importing into excel as most cells has a leading space which is a pain to remove.

  8. #8
    Quote Originally Posted by Diani View Post
    One thing: The export file use a comma and a space as separator. Can you make it so it doesn't add the space? This makes it weird importing into excel as most cells has a leading space which is a pain to remove.
    I never noticed the extra space, but it is irritating. I have updated TSMAParse to get rid of the extra spaces. The links in the original post now point to the updated version.

  9. #9
    Quote Originally Posted by Chel View Post
    I never noticed the extra space, but it is irritating. I have updated TSMAParse to get rid of the extra spaces. The links in the original post now point to the updated version.
    WOW quick response! Good on ya!

  10. #10
    Bart39's Avatar
    Posts
    1,746
    Reputation
    102
    Tagged in
    541 Posts
    Add to this user's reputation
    FYI - TSM 2.0 will allow you to export accounting data to csv (possibly xls) via the desktop app
    Sic has joined #TradeSkillMaster
    sic> I love you all. TSM Has given me children.
    sic> That is all.
    Sic has left #TradeSkillMaster

    MuffinPvEHero> and I agree with Bart39

    TSM Application Developer / Assistant Addon Developer

    For information: TSM Website, TSM Addon, TSM App.
    Also Follow TSM on Twitter
    If you need help with any of the above join our Discord. It's much faster than posting

 

 

Similar Threads

  1. [Tool] Easy Importing of TUJ Notifications to TSM Dealfinding
    By quietstrm07 in forum General TradeSkillMaster Discussion
    Replies: 12
    Last Post: June 27th, 2013, 06:05 PM
  2. [Tool] Accounting saved variables -> CSV conversion tool
    By Ayeron in forum General TradeSkillMaster Discussion
    Replies: 49
    Last Post: June 7th, 2013, 01:47 PM
  3. Enchantment Crafters Tool
    By Khronnus in forum Archive (Professions)
    Replies: 2
    Last Post: January 19th, 2012, 09:03 PM
  4. Replies: 0
    Last Post: April 13th, 2011, 12:55 PM
  5. Inks from glyphs in tool tips?
    By Sidieon in forum Archive (Professions)
    Replies: 2
    Last Post: February 4th, 2011, 09:33 AM