EVE Technology Lab

I'm so tired about having to find everything by guess in the SDE …
Is there something that presents the links between the tables ?
I need to which minerals
- can spawn in HS belts
- can spawn in HS anomalies

So far
- I look in fsd/categoryIDs.yaml to get the id of the category with english name | description equal to "Asteroid"
- I get all groupID from fsd/groupIDs.yaml for which the categoryID is matching.
- I get ALL the types ids from fsd/typeIDs.yaml whith a group corresponding.

How can I guess after that if that type is minable from eg HS asteroid belt ?
eg Compressed Arkonor's ID is 28367 ; I can't find a "typeID: 28367" in dgmTypeEffects.yaml and attributes linked in dgmTypeAttributes.yaml refer to the skills required.

grep "typeID: 28367" */*.yaml
bsd/dgmTypeAttributes.yaml:    typeID: 28367
bsd/dgmTypeAttributes.yaml:    typeID: 28367
bsd/invTypeMaterials.yaml:    typeID: 28367
bsd/invTypeMaterials.yaml:    typeID: 28367
bsd/invTypeMaterials.yaml:    typeID: 28367
fsd/blueprints.yaml:                typeID: 28367

invTypeMaterials says what materal I can extract from ore, blueprints describe the production in industry.

blueprints.yaml says "Compressed Arkonor" is a product of "Compressed Arkonor Blueprint" (ORLY ?)

dgmTypeAttributes.yaml gives two attributes :

-   attributeID: 790
    typeID: 28367
    valueInt: 12180
-   attributeID: 182
    typeID: 28367
    valueInt: 3386

looking the attributeIDs in dgmAttributeTypes.yaml:

-   attributeID: 790
    attributeName: reprocessingSkillType
-   attributeID: 182
    attributeName: requiredSkill1

None of them seems to be relate to spawning and now I am in a dead-end.

So far I found I can hardcode the groups which can spawn in HS, in HS anoms, in LS, in LS anoms. But in that case I may as well hardcode the asteroids - and their corresponding volumes.

The code I'm trying right now ( getting the ore isk/m3 with the variants) is at
https://github.com/guiguilechat/EveOnline/blob/master/Database/src/test/java/fr/guiguilechat/eveonline/database/ShowJitaOrePrice.java

Unfortunately, blacksmoke16 is correct.

There's some things which exist only in the game logic, rather than in the SDE. And that's unlikely to change (as it'd be a total PITA for CCP to keep up to date)

I'd suggest you may wish to use a conversion of the SDE, rather than the yaml files. I have mysql, postgres and sqlite versions on my site.


The volume of the ore is in invTypes. Along with the portionSize, which is how many units you need to be able to reprocess.

What were the errors?

For ore, you can check invTypeMaterials where only refinable ore/modules are. Missions ore are not listed here (because you can't refine them), so it allows you to exclude them easily.

This is not a bug per se. You have to coalesce both columns to get the real value, regardless of the intent.


Legacy issue. Can't be helped.

Typos actually must be properly reported through usual channels, once you've confirmed them existent in game.

Some typeIDs are present in the blueprint.yaml but not in the typeIDs.yaml:

34188, 34189, 37262, 37263, 37264, 37009, 37265, 37010, 37266, 37267, 37013, 37017, 37018, 37019, 37276, 37277, 37278, 37279, 35875, 35876, 37286, 35879, 35883, 35884, 35885, 35887, 37439, 37440, 37059, 37830, 37831, 37070, 37200, 37201, 37841, 37842, 3924, 37082, 37362, 37363, 35956, 37236, 37237, 37238, 37239, 37240, 37241, 37242, 37243, 35964, 37244, 37245, 37247


is there an elegant solution to know what is last sde version ? I can download https://developers.eveonline.com/resource/resources and regexp the url but it seems kinda weird.
This error comes from last 2017-03-30 version (was also present before I think)


Some of those typeIDs are related to clone grade. The corresponding clone grades are "published: false" but the blueprints do not have this information. I did not check every missing typeID

Not 100% how this works, Steve can confirm, but could you use https://www.fuzzwork.co.uk/dump/ and then store and compare the md5 value from like mysql-latest.tar.bz2.md5. If they are the same then SDE is at the latest version, else it is not.

All the information is directly available from the devs. It's in the yaml file.

All I'm doing is shifting it into a different format(s), because yaml isn't particularly useful for some of the purposes for which it's being used. (It is great as a data exchange format.)

Before it was yaml, it was an sql server backup file. Which was a total pita to use in anything else.

1. https://www.fuzzwork.co.uk/dump/ and get the latest XXXX md5 (mysql, sqlite, whatever), so you have a link with "latest", you don't care about specific version, and you can do it "brainless", it'll always work.

2. https://developers.eveonline.com/resource/resources as there are no "latest" using yaml SDE, you have to give the link manually, so either you know when to give it, or you'll have to dl it, then check something (md5 checksum or something that does the same might be what you want) and decide what to do.

As a result:
1. depends on a third party dev, but don't dl unnecessary stuff
2. always dl but only check to use it or not.