exporting auction house data

[zenga]

Is there anyone who can give me more insight in how the auction house data is stored for auctioneer? If there is any addon who can do this 'better' i'd be happy with that to.

Reason why i ask is because I prefer to manipulate the data myself in a spreadsheet or within a scripting environment I'm used to: i.e. i can display the data i want in the way i want. One way or another comparing stuff ingame doesn't really work for me.

thanks
z

[Boylston]

I (briefly) looked into this myself, and the author(s) of all these addons deliberately don't provide a way to easily export the data. I don't recall the exact reasoning, other than I think it's a Blizzard requirement to not export game data so that it's usable outside of the game.

If you find some way to dump it into a CSV or excel file, I'd love to know the trick!

[dRiN]

I wrote some .net code that takes the .lua (saved tables part in WTF) from auctionator and puts it in some excel. I have made another excel where i have vlookups looking up the data from auctionator.lua exported Excel.

This gives me a snapshot of all that is on the AH but only the lowest price. This for me is more than enough to scout the best deals and where I can make the most profit at that time.

Also I have some historical feature build in that shows me the fluctuation of prices for certain items. Started doing some code to make this more readable but since I dont have a goldcap goal it doesn't matter for me.

Also on EJ there is a guy that has his Excel published and this one feeds from auctioneer. There is a regex parse in the code that you can easily copy to your preferred language. But since my code works for me and I wrote it a good while ago I didn't bother copying this regex to get the data from auctioneer instead of auctionator.

And like two years ago I wrote some webservice that used the old format of auctioneer and where I could upload my latest data. PHP Webservices with .NET client. Just for the fun. After reading over one million rows I never actually made use of this data :D.

[zenga]

the regex would save me a lot of trouble, sounds like worth it to look into that,
thanks guys/girls