Thank you for all your hard work on the speadsheet.

I was thinking you could pull the data out of wowhead. Not sure how happy they would be with this.
One might be able to send a url like
http://www.wowhead.com/?items=4.1&f … ub=9#0-2+1
to get the list of items, parse the data for the item names. Then use url's like
http://www.wowhead.com/?item=Conqueror\ … be&xml
to get the item info and populate the spreadsheet.

Let me know if you think this would work or need a hand with it.

I've run a quick extract of Items to add to the sheet. This is not exhaustive as I'm using wowhead and they are missing most (all) T9 raid drops while wowhead looter does it's thing.

Would appreciate anyone sparing a little time to sanity check them to make sure nothing stupid is in there or anything obvious is missing (other than T9 raid drops, ofc).

Missing Ulduar loot:
http://www.wowhead.com/?item=45537 , http://www.wowhead.com/?item=45946 , http://www.wowhead.com/?item=46034

Back
http://www.wowhead.com/?item=47095 , http://www.wowhead.com/?item=47452 , http://www.wowhead.com/?item=47089 , http://www.wowhead.com/?item=47291 , http://www.wowhead.com/?item=42077 , http://www.wowhead.com/?item=47225 , http://www.wowhead.com/?item=42076 , http://www.wowhead.com/?item=42080 , http://www.wowhead.com/?item=42079 , http://www.wowhead.com/?item=42078 , http://www.wowhead.com/?item=47501

Chest
http://www.wowhead.com/?item=47603 , http://www.wowhead.com/?item=47604 , http://www.wowhead.com/?item=47605 , http://www.wowhead.com/?item=47606 , http://www.wowhead.com/?item=47126 , http://www.wowhead.com/?item=47301 , http://www.wowhead.com/?item=47794 , http://www.wowhead.com/?item=47791 , http://www.wowhead.com/?item=47806 , http://www.wowhead.com/?item=47779 , http://www.wowhead.com/?item=47527 , http://www.wowhead.com/?item=47838 , http://www.wowhead.com/?item=47799 , http://www.wowhead.com/?item=47786

Feet
http://www.wowhead.com/?item=47097 , http://www.wowhead.com/?item=47092 , http://www.wowhead.com/?item=47293 , http://www.wowhead.com/?item=49232 , http://www.wowhead.com/?item=47321 , http://www.wowhead.com/?item=47194 , http://www.wowhead.com/?item=41904 , http://www.wowhead.com/?item=47721 , http://www.wowhead.com/?item=47873 , http://www.wowhead.com/?item=41886 , http://www.wowhead.com/?item=47560 ,

Finger
http://www.wowhead.com/?item=47732 , http://www.wowhead.com/?item=47054 , http://www.wowhead.com/?item=47327 , http://www.wowhead.com/?item=47278 , http://www.wowhead.com/?item=48957 , http://www.wowhead.com/?item=47733 , http://www.wowhead.com/?item=48999 , http://www.wowhead.com/?item=48955 , http://www.wowhead.com/?item=47200 , http://www.wowhead.com/?item=42118 , http://www.wowhead.com/?item=47512

Hands
http://www.wowhead.com/?item=47235 , http://www.wowhead.com/?item=47326 , http://www.wowhead.com/?item=47797 , http://www.wowhead.com/?item=47788 , http://www.wowhead.com/?item=47803 , http://www.wowhead.com/?item=47782 , http://www.wowhead.com/?item=47889 , http://www.wowhead.com/?item=47802 , http://www.wowhead.com/?item=47783 , http://www.wowhead.com/?item=47230 ,

Head
http://www.wowhead.com/?item=47796 , http://www.wowhead.com/?item=47789 , http://www.wowhead.com/?item=47804 , http://www.wowhead.com/?item=47778 , http://www.wowhead.com/?item=47694 , http://www.wowhead.com/?item=47695 , http://www.wowhead.com/?item=47693 , http://www.wowhead.com/?item=47692 , http://www.wowhead.com/?item=47801 , http://www.wowhead.com/?item=47784 , http://www.wowhead.com/?item=47564 ,

Held In Off-hand
http://www.wowhead.com/?item=47138 , http://www.wowhead.com/?item=47309 , http://www.wowhead.com/?item=47742 , http://www.wowhead.com/?item=47913 ,

Legs
http://www.wowhead.com/?item=47795 , http://www.wowhead.com/?item=47790 , http://www.wowhead.com/?item=47805 , http://www.wowhead.com/?item=47780 , http://www.wowhead.com/?item=47800 , http://www.wowhead.com/?item=47785 , http://www.wowhead.com/?item=47317 , http://www.wowhead.com/?item=47187 , http://www.wowhead.com/?item=48991 , http://www.wowhead.com/?item=48997 , http://www.wowhead.com/?item=47185 ,

Main Hand
http://www.wowhead.com/?item=48408 , http://www.wowhead.com/?item=48013 , http://www.wowhead.com/?item=47724 , http://www.wowhead.com/?item=47874 , http://www.wowhead.com/?item=47569 ,

Neck
http://www.wowhead.com/?item=47307 , http://www.wowhead.com/?item=47139 , http://www.wowhead.com/?item=42045 , http://www.wowhead.com/?item=42043 , http://www.wowhead.com/?item=42046 , http://www.wowhead.com/?item=47890 , http://www.wowhead.com/?item=47747 , http://www.wowhead.com/?item=42047 , http://www.wowhead.com/?item=47562 , http://www.wowhead.com/?item=47219 , http://www.wowhead.com/?item=42041 , http://www.wowhead.com/?item=47105 , http://www.wowhead.com/?item=47297 , http://www.wowhead.com/?item=47849 , http://www.wowhead.com/?item=47494 ,

One-Hand
http://www.wowhead.com/?item=47300 , http://www.wowhead.com/?item=47104 , http://www.wowhead.com/?item=47736 , http://www.wowhead.com/?item=47886 , http://www.wowhead.com/?item=48513 , http://www.wowhead.com/?item=48509 ,

Ranged
http://www.wowhead.com/?item=47856 , http://www.wowhead.com/?item=47658 ,

Shoulder
http://www.wowhead.com/?item=47793 , http://www.wowhead.com/?item=47792 , http://www.wowhead.com/?item=47716 , http://www.wowhead.com/?item=47715 , http://www.wowhead.com/?item=47807 , http://www.wowhead.com/?item=47781 , http://www.wowhead.com/?item=47798 , http://www.wowhead.com/?item=47787 , http://www.wowhead.com/?item=47714 , http://www.wowhead.com/?item=47713 , http://www.wowhead.com/?item=47226 ,

Trinket
http://www.wowhead.com/?item=42137 , http://www.wowhead.com/?item=47316 , http://www.wowhead.com/?item=47182 , http://www.wowhead.com/?item=42135 , http://www.wowhead.com/?item=42133 , http://www.wowhead.com/?item=48018 , http://www.wowhead.com/?item=47946 , http://www.wowhead.com/?item=47879 , http://www.wowhead.com/?item=47726 , http://www.wowhead.com/?item=47213 , http://www.wowhead.com/?item=48724 , http://www.wowhead.com/?item=47215 , http://www.wowhead.com/?item=47947 , http://www.wowhead.com/?item=47728 , http://www.wowhead.com/?item=47880 ,

Two-Hand
http://www.wowhead.com/?item=48414 , http://www.wowhead.com/?item=48410 , http://www.wowhead.com/?item=48521 , http://www.wowhead.com/?item=47743 , http://www.wowhead.com/?item=47892 , http://www.wowhead.com/?item=48412 , http://www.wowhead.com/?item=47815 , http://www.wowhead.com/?item=47900

Waist
http://www.wowhead.com/?item=47084 , http://www.wowhead.com/?item=47909 , http://www.wowhead.com/?item=47286 , http://www.wowhead.com/?item=47081 , http://www.wowhead.com/?item=47855 , http://www.wowhead.com/?item=41899 , http://www.wowhead.com/?item=41882 , http://www.wowhead.com/?item=47218 , http://www.wowhead.com/?item=47181 ,

Wrist
http://www.wowhead.com/?item=47203 , http://www.wowhead.com/?item=47324 , http://www.wowhead.com/?item=47585 , http://www.wowhead.com/?item=47586 , http://www.wowhead.com/?item=47587 , http://www.wowhead.com/?item=47588 , http://www.wowhead.com/?item=47306 , http://www.wowhead.com/?item=41910 , http://www.wowhead.com/?item=41894 , http://www.wowhead.com/?item=48979 , http://www.wowhead.com/?item=47173 ,

[edit] Most of the Ulduar ones I extracted were melee junk. I was running from a wowhead item search with a filter of dropping in Ulduar, guessing it might be a problem with item cashes.

Items added.
If there's something you think is missing please post here.

Unstickied as implemented

Hi.
Thanks for a great job.
I have new loot from Ulduar that is not in the 320a: http://www.wowhead.com/?item=45423
And new loot from 25 TocT: http://www.wowhead.com/?item=47053

Last edited by Peregrinus (2009-08-28 12:33:56)