Let me be the first to say: Congrats!

And also, thank you in advance!

~SilverVixen :)

I tried to do something like this on our Guild's website. I wrote a PHP page that would take the auctioneer data (one of the old formats) and would then save the current price of every item to the database. That was then searchable by anyone.

Of course, this has the downside of only using one person's data at a time and did not accumulate the different scans by different users. And I never updated it to the new data format.

So... what is this about sharing the code to allow us to host our own data?

You should add a link to the donation site!

try the wotlk release it has everything your looking for.

your not using the wotlk release if you don't have the refresh button. not 3715 that is old. use 3953 i think it is which has all the features your looking for. do a clean install when upgrading.

it's not on the main page because it is still a beta/preview release.

This thread reminded me to send a long over due donation. Ty and keep it up!

that was money well spent for my all time favourite addonn.....thx for all the hard work norganna :}

How do you mean it doesn't work for you, sufanek?

but forget about that, probably just some local bug :). Should i post complaints about it somewhere, where it belongs (certainly not in here)?

What about the new database content anyway?

Posted By: NorgannaQuestion: What version are you using at the moment?

Win XP Pro Build 2600.xpsp_sp2.qfe.080814-1242 (Service Pack 2). Am not sure about other two computers, but I guess, they got SP2 too. Anyway, these are far from being fresh install, with tons of soft installed, so i reckon that it's gonna be hard to trace the problem.

Posted By: NorgannaAlso, what do you want to know about the database content? It will contain all the auctions that you have ever scanned, and all the details therein, you can write reports that process this data in LUA and it will be capable of exporting the data from the reports.

Oh I see. I think the initial post was a bit confusing for me - as it speaks of database application, and then of database/website. I didn't recognize these are two distinctive things - so I'll be running own sql server with my data, and there will be some general online database as well(with paid access), where this data wil merge?

Q: Will I need current AuctioneerDB for moving data from Auctioneer to database? (If I should keep trying to run it..)

Posted By: NorgannaShould you wish, you may also use the sqlite.exe to access your on-disk database via SQL commands and export data that way as well.

Great, that's precisely what I needed.

I think this sounds very interesting. I will definately pay for the service even though I might not use the premium services. I know it can be expensive to run such server if a lot of transfers is going to take place.

A few bugs on Vista x64 (.Net 3.5 SP 1 is installed):

-The installer does not ask if I want to "run as administrator". You can right-click and select that, so its no big deal just want to mention it.

-Each time I start it says that AucDB is not installed if I want to download. No matter what I select I get an exception:

http://norganna.pastey.net/105918

Program starts up anyway.

-If I click the "Import" option in the program I get the message that the program has stopped working and it exits.

Posted By: Hirsute
Hopefully norgs wrote the program in such a way that it doesn't need escalation. If so, then it shouldn't be prompting.

It wants to install in "Program Files" per default so it needs admin rights unless you change that.

Posted By: krendar

Posted By: Hirsute
Hopefully norgs wrote the program in such a way that it doesn't need escalation. If so, then it shouldn't be prompting.

It wants to install in "Program Files" per default so it needs admin rights unless you change that.

Ah, you're right.

ok everytime i load up the auctioneerdb program it tells me i don't have the aucdb program installed and if i want to download and install it. i have done this 3 times what am i doing wrong.

ok one more question. what do the values mean in the min bid column. like i see strange dust min bid 60000 is that 60000 copper, silver, gold, some other different number completely?

hmm im pretty sure strange dust doesn't get that high.

Install ASP.NET. I got the same error and could have swore I had it installed, but didn't. Installed ASP.NET, using the link on the AuctioneerDB page, and AuctioneerDB worked....

Oh when you install the ASP.NET I got an odd "please close the install program so I can install the program" message. Really odd. Anyway, if you get that as well just click ignore and reboot and you should be set to go.

Norganna,

I must say that you are awesome, you have truly made what I think is one of the 3 best Addon suites for WOW. The other two being MobMap and Carbonite (Carbonite has a free light and paid full version of their addon). I wont link to there sites but for those that dont know about them I highly suggest you do a google search.

I currently have a yearly subscription to Carbonite and so far I feel that I have gotten more than my $$$ worth out of it. So if you were to price the Premium subscription around the same as what Carbonite charges for their addon, then I will most certainly sign up for a yearly subscription to your premium service.

Again thank you for all of your hard work on this :-)

Norganna - thanks for all of this - I just sent in a donation (albeit long overdue!)

Marth

After seeing the above errors, I went and looked ot see that Auc-DB had indeed been loading and running in game. In my SavedVariables folder, there's an Auc-Db.lua file...it's only 40KB tho, 287 lines total. Not sure if it's supposed to be that small, or if it's supposed to be a set of the auction house scan data (there were over 17k items on Stonemaul's AH this evening), or if something didn't work right :)

Hi Norganna,

Any chance for a Mac OS X client for AuctioneerDb? I realize with the virtualization software available today that I could just run Windows on an Intel Mac, but I don't yet have one.

Thanks for all your efforts, AuctioneerDb sounds very promising.

Marth,

You basically just ensure that the addon is loaded, as the statistics are formulated during the final 3 phases of scanning, the data will be added to Auc-DB.

The format is defined - http://wiki.norganna.org/Development#defined_file_formats - it should grow the more you scan the different AHes you normally visit.

Happy Sales,

Nikk

Apart from requiring .NET, are there any known issues with running AuctioneerDb in Wine?

Posted By: ElviswindApart from requiring .NET, are there any known issues with running AuctioneerDb in Wine?

I have no clue. I run (and develop it) in VMWare Fusion on my MacBook just fine if that helps.

This is the file name downloaded from the link on the db.com site:

AucDbSetup-1.0.9.4973.exe

Exactly as the link says...So dunno!

woot cant wait

Norganna,

Thanks for the response, this really helps. It will be useful to me to be able to scan the auctions, then analyze the data that is essentially on the AH "right now".

Also, sign me up for any AuctioneerDb projects you're working on (as per first post). Thanks :)

When I start the tool (newest version 1.0.9.4973) I get an Error prompt telling me that: "System.Data.SQLite, Version=1.0.60.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" or a dependencie hasn't been found. I'm running Vista Ultimate x64 SP1, .Net3.5SP1 How can I fix this?

Marth, Bladewing: I believe this is due to x64 versions of Windows Vista. I will be installing a virtual of Vista 64-bit to test before releasing the next version to make sure everything is 64-bit compatible.

My MacBook is 64-bit so I won't have that problem, but I don't believe 64-bit will work on a 32-bit host as you say.

Norganna, thanks for the info on AuctDB. It's clear that this app will be very useful.

I'm working on a few things so once all the sql queries and regexps are worked out, maybe I can get them into a report. I haven't done anything with lua so I may send a message for help!

Well, I could easily be using the wrong terminology. You can install a 64-bit OS in VirtualBox, even if the host OS is 32-bit. Whatever the correct terminology is there, is what I was trying to say.

same problem here as Blade.
Same error message and running the same OS
vista home premium 64bit

May I suggest a "minimize to tray" option?

hotshift,

**This info is not official and does not necessarily represent AuctioneerDb's original intention and/or future**

AuctioneerDb is very useful because it gathers all your Auctioneer data and creates a SQLite database, auctions.db. With this database, you can do whatever you would like, such as analyze auction data in ways the Auctioneer addon cannot. If you want more info on how to do this, look up SQL and SQLite.

Additionally, AuctioneerDb does have the ability to analyze data in the database. This is by the "Reports" feature. Right now you will see a "Search" and "Test" Report in the application but you can write your own lua scripts to perform different functions (see the reports folder in the application's directory).

Posted By: hotshifthow can i use or display the data offline? AuctioneerDB itself ? Excel ? how?

There are several ways.

You can download the sqlite.exe program to run SQL queries on the database files that AuctioneerDb creates and uses to generate your own data.
You can use the reports feature within AuctioneerDb to run prebuilt reports (at the moment, there's only 2, and they are pretty much just "Hello world" quality reports) and then optionally export the results into a file suitable for use in Excel.
You can write some of your own reports to generate data for you to use as above.
You can convince someone else to write some SQL or Reports for you to do what you would like them to do.

It's very early days at the moment, and the most important thing from my point of view is to get some data pumping around on the server and to get people using and debugging the code, and working out what the direction this project is going to take. I have a general idea, but it's not until these things start to get a momentum behind them that you really know which direction it's going to go.

Also, at the moment it's just me and my brother doing the coding for this stuff, which makes it really hard since we both have full time jobs and it tends to eat into coding time.

vaultor, it seems like you are running version 1.0.8.4962 of the client when 1.0.9.4973 exists. Have you tried if the newer version solves your problem?

Ok guys...

The 1.0.11.14544 version is up on the AuctioneerDb website.

It contains the following additional features:
Upload/Download/Update/Automated functionality is now complete.
Many more captures of potential errors and subsequent detailed logging via a log.txt file for post-mortem debugging purposes.
Resolved errors that occur on 64 bit platforms by installing correct version of SQLite dll for the destination platform.
Polished the "look" of the application.
Added minimize to tray functionality.

I'm very deeply apologetic for the massive blowout in the estimated delivery date, I hope you all weren't too disappointed with the delay and also hope you find the results worth the wait.

By the way, I'm not sure if this is really mentioned anywhere, but the URL for the website is http://AuctioneerDb.com

Dinesh: Hmm, that's very strange.

Do you have the sqlite3.exe program on you computer?

If so can you run the following commands:
C:\...\AuctioneerDb> sqlite3 auctions.db
SQLite version 3.6.6.2
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema processed
CREATE TABLE processed ( account TEXT, realm TEXT, faction TEXT, ptime INTEGER,
PRIMARY KEY (account, realm, faction));
sqlite> .quit

Tell me if you got the same results as me. Ta!

Norgs, was that aimed at me?

If so, yes:

SQLite version 3.6.10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .schema processed
CREATE TABLE processed ( account TEXT, realm TEXT, faction TEXT, ptime INTEGER,
PRIMARY KEY (account, realm, faction));
sqlite> .quit

It seems to happen at the beginning of "Processing enUS cache file"

I'm getting the same error, but this time it does actually seem to process the cache directory as the "cache" table had my data in it, whereas before it only had one row of data.

AuctioneerDB client is: http://auctioneerdb.com/dl/AucDbSetup-1.0.12.14598.exe
Auc-DB is: http://zip.norganna.org/auctioneer/Auc-Db/Auc-Db-latest.zip
AuctioneerAdvanced is: http://auctioneeraddon.com/dl/?dl=Packages52/AuctioneerSuite-5.3.4038.zip

If I look at my SavedVariables\Auc-Db.lua it's now only 146bytes and only contains a few lines, whereas before it had all the data. Should it be like that? (I have run a few quickscans on the AH).

Posted By: vaultorIf I look at my SavedVariables\Auc-Db.lua it's now only 146bytes and only contains a few lines, whereas before it had all the data. Should it be like that? (I have run a few quickscans on the AH).

Yup, got it figured out (what was wrong), 1.0.14.14669 is now uploaded to the website and should solve this problem.

Hirsute I added an option to disable the close-means-minimize functionality as well (personally I prefer close to minimize, but I added the option to turn it off)

vaultor: Have you tried scanning recently? (since you updated to the most recent version of AuctioneerDB)

No, the AucDb AddOn is setup so that it doesn't store any data unless the client is installed (so it doesn't use up space unnecessarily).

The AuctioneerDb client is supposed to create a DbStatus.lua file so that AucDb AddOn knows it's good to start storing stuff.

Obviously this isn't happening... Let me take a look (I'll see if I can fix this darn autoupdate problem while I'm there)

okay, my bad... I must have been doing something wrong. I think I wasn't letting the client update the DbStatus.lua file. I just reran the client. Check status file existed, ran an AH scan and now all good. Has imported data!

So all good! Thanks for the quick updates!

I'm Having an issue with the DB, Running 32bit vista and .net 3.5 sp1. A warning comes up when I try and start the program
Warning:
Unexpected exception caught.
Message:
Object reference not set to an instance of an object.

Then gives me an option to close the program or try to run anyway when I run it anyway, nothing works and the error continues to pop up.

here is a copy of the log file.

--- Caught warning event ---
Date = 2009-01-31 00:00:00Z
Message = Object reference not set to an instance of an object.
Method = AuctioneerDb.FormLoaded
Stack Trace:
System.NullReferenceException: Object reference not set to an instance of an object.
at AuctioneerDb.Form1.get_WowPath()
at AuctioneerDb.Form1.SetupConfig()
at AuctioneerDb.Form1.FormLoaded(Object sender, EventArgs e)
--- Caught warning event ---
Date = 2009-01-31 00:00:00Z
Message = Object reference not set to an instance of an object.
Method = AuctioneerDb.CheckUpgrade
Stack Trace:
System.NullReferenceException: Object reference not set to an instance of an object.
at AuctioneerDb.Form1.get_WowPath()
at AuctioneerDb.Form1.CheckUpgrade(String addon)
--- Caught warning event ---
Date = 2009-01-31 00:00:00Z
Message = Object reference not set to an instance of an object.
Method = AuctioneerDb.SaveStatus
Stack Trace:
System.NullReferenceException: Object reference not set to an instance of an object.
at AuctioneerDb.Form1.get_WowPath()
at AuctioneerDb.Form1.SaveStatus()
--- Caught warning event ---
Date = 2009-01-31 00:00:00Z
Message = Object reference not set to an instance of an object.
Method = AuctioneerDb.CheckUpgrade
Stack Trace:
System.NullReferenceException: Object reference not set to an instance of an object.
at AuctioneerDb.Form1.get_WowPath()
at AuctioneerDb.Form1.CheckUpgrade(String addon)
--- Caught warning event ---
Date = 2009-01-31 00:00:00Z
Message = Object reference not set to an instance of an object.
Method = AuctioneerDb.SaveStatus
Stack Trace:
System.NullReferenceException: Object reference not set to an instance of an object.
at AuctioneerDb.Form1.get_WowPath()
at AuctioneerDb.Form1.SaveStatus()

1.0.17.14904: Close minimize option now works.