Hello.
Looking for good acual industryActivityMaterials data sheet in xls
I found in archives of this forum something, but there isn’t a lot of items ID
you mean like https://www.fuzzwork.co.uk/dump/latest/industryActivityMaterials.csv.bz2 ?
(unzip with 7zip or winzip)
The official SDE doesn’t have the data in this form. It’s an artefact created by my conversion 
(the official is blueprints.yaml. which is nice and all, but not great for use in many situations)
1 Like
Yes Yes ! It is 
You are doing cool things !
Hey Steve, can you help me with this problem ?
How to get and convert that yaml in xls or google sheets ?
There is a lot of converters (maybe they working bad)
But i dno’t understans how yo downloads yaml from eve
blueprints.yaml
And this Industry Activities Table (MSSQL)
PS
Sry Maybe my questions is stupid, but i am playing 2 weeks, and my navigating it this problem is bad…Thanks
I’d just suggest you use the CSV I provide.
unless you’re having a problem with it?
The Problem is that a lot of Item IDs are not in this csv.
For example Hobgoblin I ID is 2454. And It is no in your csv.
That’s because it’s all keyed on the blueprint ID, not what you’re making. (industryActivityProducts for that)
1 Like
No, conversely 
industryActivityProducts - Blueprints ID, Products ID, and how much blueprints can make products.
industryActivityMaterials - Item ID of blueprints, materialTypeID - Minerals, quantityof materials need for blueprint.
I needed industryActivityMaterials, keyed on Item ID (ready product ID) instead of blueprint ID.
So with it i can write in cell number of ready (finished product) Item ID and know how much materials i need for that.
But i understand, that i can use blueprint ID instead of Item ID in industryActivityMaterials 
Anyway Thank you !
The problem is solved ! It’s all working.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.