Item database project (for all these spreadsheets) - Page 4

Stirius · 08/07/07, 4:08 AM

Sry, i haven't updated this project for a while, because I'm pretty happy with lootzor.com - World of Warcraft search and rate items - profile your wow character.

The urls on allakhazam have changed indeed.

If there is still demand for my solution, I try to update it in a few days.

Lurchington · 08/08/07, 11:33 PM

I actually picked this up the other day as something to do while on business travel. Didn't realize there were any further developments since the original post and hadn't seen anyone else's effort til I was ready to post.

Took a quickish but very dirty attempt in python.

run it in the directory with all your XML tooltip files, and you'll get an output.csv file that has each unique field as a column header.

Several sacrifices were made for simplicity, but if I was still maintaining my hunterlist, I'd be able to easily use the output in conjuction with my spreadsheet's sort/filter tools.

rename to .py extension

edit: as far as I can tell, this depends on having something similar to the individual .xml file per tooltip that disquette originally provided

Stigg · 08/16/07, 12:52 PM

Disregard this if this isn't any use to you, but this may have value (if allakhazam links are really dead)

http://www.wowhead.com/?search=nordrassil&xml

http://www.wowhead.com/?item=29356&xml

• Rezarel · 08/16/07, 1:18 PM

Originally Posted by Bury

I can't seem to get dl.bat to work well, getting a bunch of 404 errors when trying to access http://wow.allakhazam.com/dyn/items/inameXX.html

Did Allakhazam change its URLs by any chance?

I think the URLs just changed from inameXX.html to iXX.html

Stirius · 08/16/07, 6:06 PM

Originally Posted by Rezarel

I think the URLs just changed from inameXX.html to iXX.html

Correct. I changed the links and it seems to work (only the .bat file included):
filefront download-link

SeanDamnit · 08/17/07, 12:40 PM

Hey Stirius, you taking requests for this? Is it possible to include socket colors, socket bonus, and the item's source (what boss drops it, vendor, tailoring, etc)?

Thanks!

ImARestoDruid · 08/17/07, 2:03 PM

I've actually written a smart parser that will dynamically setup all pulls (you don't have to worry about number of circumstances). I'll have it finished this weekend, all that's left to do in it, is write the data to database / external file. I'm using PERL for the entire project, but I'm more than willing to share any code / ideas.

Vontre · 08/17/07, 6:51 PM

Originally Posted by Disquette

I appreciate the code very much, but i get an error when trying to use it. i'm using Win2k (with updated 1.1 .Net framework). Here's a screenshot of the error:

Also, if it helps, I've attached my stats.txt file (i didn't change any of the others)

I'm having the same issue, except the posted solution doesn't help.

I'm definitely interested in using this to keep my spreadsheet item database up to date.

Edit: Nevermind I fiddled with it until it worked.

Bury · 08/17/07, 8:26 PM

Any chance you can post your complete folder for The Stupider Persons Amongst Us?

ps: you're in skarzog's guild haha

Vontre · 08/22/07, 6:06 PM

I successfully used this project for my spreadsheet item selector, I consider it an extremely valuable tool. Thank you.

Stirius · 08/22/07, 6:42 PM

Originally Posted by Bury

Any chance you can post your complete folder for The Stupider Persons Amongst Us?

ps: you're in skarzog's guild haha

Here you are:
Version 3 - nothing new, only the fixed .txt-file and the new dl.bat:
ExtractItemv3

sp00n · 08/23/07, 6:24 AM

Originally Posted by Aadar

What I would also like is to be able to extract the text of the Socket Bonus into a column, is there a way of achieving this?

e.g. For the line "Socket Bonus: +3 Spell Crit Rating "

I would like "+3 Spell Crit Rating" written into a column.

Also knowing whether it is a green, blue, purple would be useful by reference to or and so on.

I tried to do the same thing, but unsuccessfully.
Then I looked into the source code and the line is basically skipped and only used to get the name of the item.
I would try to change the code, but unfortunately I don't have anything to compile for .NET. I assume it's only possible with VisualBasic or alike and there are no free tools to compile?

Heavenfall · 08/28/07, 7:00 AM

The socket bonus can be worked around using 1 parse line for each interesting socket bonus.

• Slake · 08/28/07, 10:57 AM

As part of the framework for a character profiler, I wrote a program to pull data from the Armory and parse it, then write it out to a custom XML format. I ran a full crawl the other day, so I should have an items.xml and sets.xml file covering most items.

I realize XML isn't the easiest thing to work with compared to a flat text file, but it's possible to write a translator to whatever flat format you want; I might include this in the data-handling tool whenever I get around to it. If anyone is interested in the two xml files let me know and I'll put them up somewhere.

mook06 · 10/27/07, 7:21 AM

wow, just stumbled across this, awesome work

anyone figured out how to parse weapon dps / dmg / speed?

Slake: If you wouldnt mind, im interested in your files