EVE Technology Lab

good day o/

i need a data dump of all modules and their manufacturing prices. ideally this includes everything, even the stuff that you can't build anymore. one of my big manufacturing spreadsheets is way out of date, and i want to start using it again. gdocs is my product destination of choice, but excel is obviously fine as well.

here's the headers i need.

productID
materialID
prod time
portion size
volume
(unpackaged size? is this an option as well? not important if not)
productName
NeededMaterialName
quantityofMaterials
damage per job
recycle
meta
blueprint id
blueprint name

i'd expect to see a one-dimensional list that has lines that look like this:

http://i.imgur.com/CRlgORx.jpg

i can't offer a ton of isk for this, but let me know how long it took and i'll recompense appropriately.

thanks for your time.

I would offer my services, but to compile a list of ALL items along with all that data would take me a very long time. Not sure if there's an easy way to just pull all that data from a dump of some kind. I don't do server dumps currently. Will be looking into it in the future though. Good luck. If anyone knows how to do a dump like this, I'd be interested in speaking with them about learning :(

i can't pull this stuff at work, and my time available to game at home is precious (my kid just turned 1!). not to mention that i never learned how to do it, and i'm totally fine paying someone else for being good at this stuff. lastly, as a guy who sells spreads for an (eve) living, i like my own stuff and would prefer to use it.

nolen, yeah, there's a way to do it with one query, i think. i'm basically just waiting until steve ronuken comes in and barfs data on me that he pulled in ten minutes =)

Depending on how lazy I'm feeling I might throw this out later. How much are you paying me to not feel lazy? :D

More appropriate post for the EVE Technology Lab

tau, you're totally right. just derped on the forum screen i guess.

fubar, i can't access that document, unfortunately. i'll get you an email address that you can attach it to, give me a second.

i'll update if/when i hear from fubar.

http://www.fuzzwork.co.uk/resources/materialsfull.zip

Not quite all you want, but other bits can be grabbed from invBlueprintTypes and invTypes, with a vlookup.


select invTypeMaterials.typeid,materialtypeid,it1.typename productname,it2.typename materialname,quantity,1 damageperjob,0 recycle,metagroupname meta,blueprinttypeid,it3.typeid blueprintname,'basic' materialtype
from
invTypeMaterials
join invTypes it1 on invTypeMaterials.typeid=it1.typeid
join invTypes it2 on invTypeMaterials.materialtypeid=it2.typeid
join invBlueprintTypes on invBlueprintTypes.producttypeid=invTypeMaterials.typeid
join invTypes it3 on invBlueprintTypes.blueprinttypeid=it3.typeid
join invMetaTypes on invMetaTypes.typeID=it1.typeid
join invMetaGroups on invMetaGroups.metaGroupID=invMetaTypes.metaGroupID;


select it1.typeid,ramTypeRequirements.requiredtypeid,it1.typename productname,it2.typename materialname,quantity,1 damageperjob,0 recycle,metagroupname meta,blueprinttypeid,it3.typeid blueprintname,'basic' materialtype from
ramTypeRequirements join invBlueprintTypes on ramTypeRequirements.typeid=invBlueprintTypes.blueprinttypeid
join invTypes it1 on invBlueprintTypes.producttypeid=it1.typeid
join invTypes it2 on ramTypeRequirements.requiredtypeid=it2.typeid
join invTypes it3 on invBlueprintTypes.blueprinttypeid=it3.typeid
join invMetaTypes on invMetaTypes.typeID=it1.typeid
join invMetaGroups on invMetaGroups.metaGroupID=invMetaTypes.metaGroupID
join invGroups on invGroups.groupid=it1.groupid
where activityid=1 and categoryid!=16;

I have all this data in Access for IPH working files so it was relatively easy to pull, but you really should look into getting it for yourself in the future through either Steve's conversions or your own program. Because every time they have a patch and change something, you'll have to update it. Not to mention that I'm not sure I got everything you wanted and going back and forth to get something like this is time consuming to get it the way you want. Plus you'll be confident the data is correct.

https://docs.google.com/spreadsheet/ccc?key=0AukAV6sUNfRndDhMOFVkdTktLW91RDUzQ2pvNUVkNmc&usp=sharing

This thread has been moved to EVE Technology Lab.

I believe there are one mistake

select it1.typeid,ramTypeRequirements.requiredtypeid,it1.typename productname,it2.typename materialname,quantity,1 damageperjob,0 recycle,metagroupname meta,blueprinttypeid,it3.typeid blueprintname,'basic' materialtype from
ramTypeRequirements join invBlueprintTypes on ramTypeRequirements.typeid=invBlueprintTypes.blueprinttypeid
join invTypes it1 on invBlueprintTypes.producttypeid=it1.typeid
join invTypes it2 on ramTypeRequirements.requiredtypeid=it2.typeid
join invTypes it3 on invBlueprintTypes.blueprinttypeid=it3.typeid
join invMetaTypes on invMetaTypes.typeID=it1.typeid
join invMetaGroups on invMetaGroups.metaGroupID=invMetaTypes.metaGroupID
join invGroups on invGroups.groupid=it2.groupid <--- it1 is not correct for me It2 is correct if you would like to delete the skill
where activityid=1 and categoryid!=16;