I was quite bored to not be able to extract information from the in-game BeanCounter addon from Auctioneer Suite. With some VBA and regular expressions I succeeded to gather what I needed.
This excel file requires Office 2007/2010 and macros to be allowed. Browse to your BeanCounter.lua and click Run button. (For versions 1.3 and lower: when the file opens hit Alt+F8 to run the macro named ReadFile...)
It will ask for your full path to your BeanCounter.lua (default c:\program files\World of warcraft\Wtf\xxxxxxx\bloodfeather\saved variables\beancounter.lua) wait a few minutes, and you should have all the successful and failed auctions on two separate sheets.
I mainly created it for my personal usage, but if you want anything (and I have time for it) let me know!
If you want to share of your revenues from AH, you can donate here
NOTICE: I've just realized this works with Office 2010 as well
v1.4.1 Fixes:
- Updated the parsing algorithm to work with latest BeanCounter data, my tests were OK, let me know if you have any problems.
- Removed MS Dialog control class reference, which caused problems for some users.
v1.3.1 Fixes:
- Increased the transaction limit from 100.000 to 500.000, since I hit it yesterday :)
- Removed the Alt+F8 functionality, just click the Run button.
v1.3 Changes:
- Changed the way the BeanCounter filename is entered, now one can either paste into a cell on the main sheet or click a button to browse to the file (which enters the path into the cell) Thanks to Akrostychon for his small filedialog code
- Added a new optional selection which allows to disable new currency formatting if a user so desires (Again thanks to Akrostychon for the excek cell format)
v1.2 Fixes:
- Changed the code a bit, so it works regardless where the itemids data block appears in the lua file...
v1.1 Changes:
- Added 1 new sheet, called MyBids
- Changed regular expressions a bit to make sure unicode characters are matched even if in character name (this time for real I hope!)
v1.0 Changes:
- Added 3 toggle options to the main sheet, allowing some of the sheets to be ignored to gain speed
- Added a simple toggle to the main sheet, when set to yes, it autofilters the sheets upon finishing file reading
- Changed the reading code and reading speed increased around 3 times. Now it takes approx. 1 minute to read a 100000 transaction .lua (on a Core i7 920 machine)
For earlier changes, see the change log