EVE Technology Lab

I'm a fairly newbie programmer and have been recently working on a program that pulls wallet journal data from the XML API. Thus far (with a fair amount of trial and error) I've been able to get it to do pretty much everything I want it to, but I've run into a particular typeID that I can't find a reference for anywhere.

I'm coding in Python 2.7, and using the evelink library as a wrapper to the API (much thanks to evelink's author(s) btw, I didn't want to have to teach myself XML as well), and when having it pull the wallet journal for a given character, one of the fields is a typeID for the characters on either side of the transaction. In the XML it appears to be "owner1TypeID" & "owner2TypeID". I've searched everywhere I can think of, and only found a couple of passing references to this field, and nothing with a list of what the various TypeID's associate to.

Google found this thread from nearly 2 years ago, which refers to this page on the wiki that no longer exists. Also in that thread is a reference that all of the TypeID's are contained in the SDE.

So working on the premise that info in the SDE may well be useful to a later iteration of my program or potentially a different project above and beyond my current conundrum, I downloaded it and attempted to look through it. Unfortunately, my practical experience with databases is even more limited.

I opened up the YAML files in Notepad++, and while I can see how they would be useful for a number of projects, there's little if any reference to what the TypeID's actually associate to. I found a program that would let me view SQLite databases, but that file appears to only be universe data, celestials and whatnot. I know almost nothing about SQL, and so accessing the MSSQL database included in the SDE isn't something I've been able to figure out yet, and before I spend any more time on it I figured I'd ask if it even has what I'm looking for.

Tips and advice would be greatly appreciated.

https://www.fuzzwork.co.uk/dump/ may be of use.

https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2 specifically (7zip will uncompress it. It's an sqlite database)

The SDE that CCP provides comes in 3 parts, the universe data in sqlite, the yaml files, and the rest in an sql server backup. This is less than useful for many people, so I convert it into other formats.

Also, https://www.fuzzwork.co.uk/dump/latest/invTypes.xls.bz2 may be useful, as it's an extract of the invTypes table, into an excel sheet (there are encoded linebreaks, so not csv)

invTypes is the table with the basic data about all the types in eve, by typeid.