Science & Industry

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 am not sure if I am allowed to post links, but one such example of where you can open up the files (in excel) or open office that have the material reqs for every item in the game.

https://www.fuzzwork.co.uk/dump/sde-20161213-TRANQUILITY/

the files that concerns what you want are industryActivityMaterials
and invTypes

The industryActivityMaterials will list out by BPO number the required item and quantity of said item to produce item.
The invTypes will let you cross reference BPO number to find out what it is.
example BPO 693 is Tempest Blueprint.

I would import these two (partially) into google sheets or excel so that you can automate the lookup.

In google sheets below gives you an example for max buy tritanium @ jita. This should be enough for you to develop your own spreadsheet etc if that is what your end goal is.

=importXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=34","/evec_api/marketstat/type/buy/max")

in excel you can write own module to import XML. I will be kind enough to provide what I use for mine. Then simply type in excel =ImportXML to have similar function to google sheet.

Public Function ImportXML(xmlUrl As String, xmlPath As String) As Double

Dim xmlHttp
Dim ndoutput
ndoutput = ""
Set xmlHttp = CreateObject("Microsoft.XMLHTTP")
Call xmlHttp.Open("GET", xmlUrl, False)
Call xmlHttp.send

Dim xmlDoc
Set xmlDoc = CreateObject("Microsoft.XMLDOM")
xmlDoc.async = "false"
xmlDoc.LoadXML xmlHttp.responsetext
xmlDoc.setProperty "SelectionLanguage", "XPath"

Set ndoutput = xmlDoc.DocumentElement.SelectSingleNode(xmlPath)
ImportXML = ndoutput.Text

End Function