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.
 

StationID List

First post
Author
Previous Topic Next Topic
Grasor
Ministry of War
Amarr Empire
#1 - 2016-09-30 22:39:09 UTC
Hey all,

I'm writing a program in VBA to assist me with market orders and planning. Since it's in VBA, it's easy to use a familiar "database" tool such as Excel (yes I know Access is better for this but I can do everything in Excel).

What I'm having trouble finding is all the Eve online number to human readable name. I found the TypeID list by chance, but things like StationID and others continue to elude me.

I understand Fuzzworks is a good source, but I don't understand the naming conventions on Steve's Download page or how to convert the files to something I know how to use.

Anyone have a bead on either up-to-date *.csv versions of this data or how to convert Steve's data so I can coerce it into that format?

Thanks,
G

Who did who in the what now?
Blacksmoke16
Imperial Academy
#2 - 2016-09-30 22:49:51 UTC
Grasor
Ministry of War
Amarr Empire
#3 - 2016-10-01 02:01:06 UTC
Thanks Blacksmoke I'll put that to good use. Think you could teach me to fish though? Where did that originate from?

-G

Who did who in the what now?
Blacksmoke16
Imperial Academy
#4 - 2016-10-01 02:02:02 UTC
EVE SDE. From fuzz's MySQL conversion.
Grasor
Ministry of War
Amarr Empire
#5 - 2016-10-01 15:12:09 UTC
That's what I suspected. Now I just need to know how to retrieve and convert that data for myself. I have Microsoft Access, which I believe can connect a MySQL database if I know the address. Is that something that's accessible? Perhaps you could share how you are doing it?

Thanks and have a great weekend.

-G

Who did who in the what now?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2016-10-01 16:54:53 UTC  |  Edited by: Steve Ronuken
https://www.fuzzwork.co.uk/dump/latest/ has all the tables from the SDE in CSV format.

items are in invTypes

Stations are in staStations

The bz2 on the end is an indication that it's a compressed file (specifically bzip2 compression) 7zip will open those files fine, and you can decompress them.

If you want _everything_ and don't want to deal with mysql or postgres, the sqlite version is probably what you want. https://www.fuzzwork.co.uk/dump/sqlite-latest.sqlite.bz2

You can get an odbc driver for sqlite, which allows you to open up the DB in anything which supports odbc. There are also things like https://github.com/govert/SQLiteForExcel for working directly



The conversions are generally updated on the day of release of the main SDE (I don't think I've missed one yet.)



In other news, I _highly_ recommend xlwings, for embedding python into excel. Because VBA is a total PITA to work in, when you have json endpoints. I have a fanfest presentation on it. https://www.youtube.com/watch?v=T4osYwR61Ak

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter