These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Is there a way to get blueprint bill of materials from CREST?

First post
Author
Previous Topic Next Topic
Droidster
Center for Advanced Studies
Gallente Federation
#1 - 2016-03-19 16:12:49 UTC
Is there a way to get the bill of materials for a type and the number produced using CREST (or the static downloads)?

The BOM has a list of the component types and how many are needed to produce a certain quantity of the resultant output.
Canenald
Dreddit
Test Alliance Please Ignore
#2 - 2016-03-19 16:27:58 UTC
Don't know about CREST, but the static data has it. Check out the industryActivityProducts and industryActivityMaterials tables. They link blueprints, products and materials from invTypes table.
Diego DelTorros
Dire Wolf Armoury
#3 - 2016-03-20 14:49:08 UTC  |  Edited by: Diego DelTorros
Please don't be harsh with me if I didn't understand it correctly, but if by "bill" you mean the total cost for materials on a given blueprint you can check out my resource - http://eve-trader.net which does exactly how I interpreted your request - it calculates the total (production) cost for a certain blueprint.

Afaik you can't get it from CREST, you need to query some 3rd party resource, like http://eve-central.com for it (this is what I do in my application).

http://eve-trader.net - small web application for industrialist. Calculate your profits on blueprints in real time.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2016-03-20 19:19:07 UTC
CREST does not contain the BOM

You can get it from CCP directly, in the form of the blueprints.yaml file in the SDE.

If that's not of use, then you can get the data from conversions on the SDE. I provide it in industryActivityMaterials and industryActivityProducts (there are other industry tables, but those are the two big ones.)

https://www.fuzzwork.co.uk/dump/latest/ for the individual tables (mysql sql format and csv ) or
https://www.fuzzwork.co.uk/dump/mysql-latest.tar.bz2
https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2
https://www.fuzzwork.co.uk/dump/postgres-latest.dmp.bz2
https://www.fuzzwork.co.uk/dump/yc118-3-117575/YC118-3-117575.bak.bz2 (this one is MS SQL)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter