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.
 

Question about Quering Recipies

First post
Author
Kosomot
Player Vs Ore
Miners Of Independence
#1 - 2017-02-13 16:44:06 UTC
Hi Everyone;

I'm just looking for a little bit of guidance on if something can be done vs how to do it.

I'm working on spreadsheet for myself, and it's based on Planetary Interaction.

I'm wondering if it's possible to query one of othe API Structures to deliever the required materials for a Processor Recipe.

For example:

I would like to querey Transmitter and the output would be.

x amount of plasmoids
x amount of chiral strucutures

we know these things i'm just wondering if it is something that can be called dymanically from either aPI or static dump.

I hope I am making sense.

Thanks for your help in advance.

I am a miner, mission runner, and explorer...

or as EVE Online would have it...

A Carebear!!

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2017-02-13 18:24:33 UTC
The SDE has the recipes in it.

planetSchematics for the schematics
planetSchematicsTypeMap for the details of what goes in and what comes out
invTypes to take the typeids in TypeMap to names.

planetSchematicsPinMap for what schematic goes into which facility

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Kosomot
Player Vs Ore
Miners Of Independence
#3 - 2017-02-13 18:32:32 UTC
Thanks Steve;

So I'm looking at all that now, and it looks like it's all YAML data now.

Am i lookingat the wrong data set, maybe there is a SQL dump i'm missing.

Hmm..


Thanks for the help.

I am a miner, mission runner, and explorer...

or as EVE Online would have it...

A Carebear!!

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2017-02-13 19:12:09 UTC
Kosomot wrote:
Thanks Steve;

So I'm looking at all that now, and it looks like it's all YAML data now.

Am i lookingat the wrong data set, maybe there is a SQL dump i'm missing.

Hmm..


Thanks for the help.




If you check my site, there are sql conversions :D

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter

Kosomot
Player Vs Ore
Miners Of Independence
#5 - 2017-02-13 19:51:39 UTC
Ah ok, i will allow this ruthless self promotion only because i love your site and use the industry tools often

Keep up the great work Steve, and i do appreciate your help.

and FYI, you have my vote :)




I am a miner, mission runner, and explorer...

or as EVE Online would have it...

A Carebear!!

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2017-02-13 20:52:56 UTC
<3

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter