Tip - Tradeskill Recipes & Sources Spreadsheet

[alynel]

Attached spreadsheet contains data for all items as grabbed from www.eqtraders.com.

For tradeskill created items, it has the containers used (container1|container2|etc), as well as the items (item1|qty1|item2|qty2|etc), and what gets returned on failure/success. Trivial level has some bad data in there, could be fixed if it's a major issue but given the ease of getting 300 these days I figure it doesn't matter too much. I've taken a stab at the Count Towards 350 column for tailoring, but no others. If the tailoring one looks accurate, I can do the same for the other skills - please let me know.

For foraged items, it has the zones it can be foraged in. For dropped items, it has the zones and mob names. For vendor items, it has zone, vendor name, and location.

You can paste the results of /outputfile into the second sheet, and it'll update the Already Known column for you.

Happy to provide in other formats if anyone has a use in mind for it, please get in touch.

Any bad data, blame eqtraders not me :p or better yet, report a fix to them, and donate to them for taking the time to collate and host all the info!

 

[kaen01]

i dont have the excell!! why would you do that to me!

 

[alynel]

Google sheets version: https://docs.google.com/spreadsheets/d/1BsnUlrpRJyAQ6bw7Ww51_N41A0lJ48XMAFRBk75sDvc/edit?usp=sharing

 

[jb321]

Attached spreadsheet contains data for all items as grabbed from www.eqtraders.com.

For tradeskill created items, it has the containers used (container1|container2|etc), as well as the items (item1|qty1|item2|qty2|etc), and what gets returned on failure/success. Trivial level has some bad data in there, could be fixed if it's a major issue but given the ease of getting 300 these days I figure it doesn't matter too much. I've taken a stab at the Count Towards 350 column for tailoring, but no others. If the tailoring one looks accurate, I can do the same for the other skills - please let me know.

For foraged items, it has the zones it can be foraged in. For dropped items, it has the zones and mob names. For vendor items, it has zone, vendor name, and location.

You can paste the results of /outputfile into the second sheet, and it'll update the Already Known column for you.

Happy to provide in other formats if anyone has a use in mind for it, please get in touch.

Any bad data, blame eqtraders not me :p or better yet, report a fix to them, and donate to them for taking the time to collate and host all the info!

hello, was this grabbed by some ODBC from the website.. ? if so what is the ip address and DB name to connect to?

I am working to convert the TCS Tradeskill Construction Set to stop using text files and grabbing data from an exported DB or an online DB using sqlite..

Trade / Skill - Tradeskill Construction Set |Quests:GOD,TSS,POK,POR Freebie Assister

2020 ESA Winner WARNING: Please test 3.73b and report issues. OVERVIEW TSC.mac levels your tradeskills fully automated to 50+ TSC.mac will do tradeskills quests in Abyssmal Sea to get your toon fully automated to 50+ Skill or to get recipes in...

www.redguides.com

OR..what tool was used to web scrape? The goal is to be able to reference an ID..and then find all the components related to that ID recipe and associated counts, etc.. to be used for mass tradeskilling and quests.