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.
 

Latest SQL Dump file location and some general questions

First post
Author
Previous Topic Next Topic
FrostFire UberNuker
Deep Core Mining Inc.
Caldari State
#1 - 2017-03-24 06:07:31 UTC
Hiya,

Ive spent hours pouring over the documentation on the SDE, and all over the place I see references to the Sql Data Dump that contains static data I need in order to interpret the data in the YAML files. But I cannot find that SQL dump anywhere. It is not, as the documentation says, in the SDE file. Neither are the referenced SQLite DB files (tho I do not need the data in those).

So... first question is, where is this SQL Dump File?

Second... maybe I am looking in the wrong place, so let me explain what data I want and someone might be able to point me in the right direction. Essentially I want the information on all blueprints in the game. I assume that the Blueprints.yaml file contains that information, but of course that file is not complete. It contains IDs that need to be cross referenced somehow to find out what it produces and what the input materials are, etc. How are those lookups done without the static data dump? Can that be done via API somehow? If so I cannot find it in any of the documentation.

Any help is greatly appreciated!

Frosty
Althalus Stenory
Flying Blacksmiths
#2 - 2017-03-24 09:49:11 UTC
1. https://www.fuzzwork.co.uk/dump/

2. with the SDE conversion (see 1.) you have multiple tables that contains all the blueprints data :
- industryActivity : contains the job time, per activity, per blueprint
- industryActivityMaterials : contains the materials required for a given blueprint / activity
- industryActivityProbabilities : contains the probabilities for a given blueprint and activity (only invention now actually)
- industryActivityProducts : contains the result products for each activity and blueprints
- industryActivitySkills : contains the required skill per activity/blueprint
- industryBlueprints : contains the max run per blueprint (for bpc)

After you can link everything together to get the data you need, and with the invTypes table to get item names, etc etc.

Hope it helps :)

EsiPy - Python 2.7 / 3.3+ Swagger Client based on pyswagger for ESI
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2017-03-24 18:55:19 UTC
CCP stopped providing an SQL dump file a fair time ago, going through a couple of iterations of how it was provided, before finally getting the whole thing into yaml. Believe it or not, it made converting it to other database formats a _lot_ easier. automating the conversion was somewhat troublesome before. Now it's really easy.

The link in the post above is my conversion. https://github.com/fuzzysteve/yamlloader is how it's created.

While I don't really advertise it, I do have an api for blueprint data.

https://www.fuzzwork.co.uk/blueprint/api/blueprint.php?typeid=587

The typeid is the typeid of the product. invTypes contains a list of products.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter