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.
 

XML or Google Sheet to get materials needed for each BP

First post
Author
Previous Topic Next Topic
agil2
MotherJuice Lovers Inc
#1 - 2016-12-29 15:26:58 UTC
Sorry, i've also posted this post in another section....

Hi

I'm looking for an up to date XML file (or an access to api simple to use in Google Sheet) to know which material is needed to produce one unit of a product regarding its BP.

Today, i've a file containing this

Osprey Blueprint 686 8 20416 8 1 Datacore - Nanite Engineering
Osprey Blueprint 686 8 25887 8 1 Datacore - Caldari Starship Engineering
Osprey Blueprint 686 1 34 544444 1 Tritanium
Osprey Blueprint 686 1 35 130000 1 Pyerite
Osprey Blueprint 686 1 36 31111 1 Mexallon
Osprey Blueprint 686 1 37 8778 1 Isogen
Osprey Blueprint 686 1 38 1556 1 Nocxium
Osprey Blueprint 686 1 39 444 1 Zydrine
Osprey Blueprint 686 1 40 89 1 Megacyte

Zhere the 2nd colum = the ID of the BP, 3rd = the type or item needed (8 for datacore for research, 1 for minerals), 4th = Quantities, 5th, i dont know, and last one = Name

Thank you very much

Agil
I like biscuits
Biscuits Industrial Inc.
#2 - 2017-01-01 06:51:20 UTC
If i remember this correctly, i believe it's all stated inside of a yml file that CCP provides use from THIS SITE also, if you want it to be in mysql compatiable. i persoinally use a site from Fuzzworks THIS LINK i hope this could possibly help. :)
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2017-01-01 18:07:01 UTC
https://www.fuzzwork.co.uk/dump/latest/ has the most up to date conversion of the SDE from CCP.

industryActivityMaterials is the one you want to know what's needed for each run.
industryActivityProducts is what you want to know what each run produces
industryActivity for how long they take
invTypes to convert the IDs into names.


The fifth number is the activity ID. 1 is manufacturing. 8 is invention.(same as the 3rd)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
I like biscuits
Biscuits Industrial Inc.
#4 - 2017-01-02 06:39:09 UTC
Steve Ronuken wrote:
https://www.fuzzwork.co.uk/dump/latest/ has the most up to date conversion of the SDE from CCP.

industryActivityMaterials is the one you want to know what's needed for each run.
industryActivityProducts is what you want to know what each run produces
industryActivity for how long they take
invTypes to convert the IDs into names.


The fifth number is the activity ID. 1 is manufacturing. 8 is invention.(same as the 3rd)



Basically what Fuzzy said, it's his site and it basically IS the latest. when ever CCP updates the data, he converts them and i get my site running under 1 day of CCP update THANKS to Fuzzy.