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.
 

API to access ships stats and blueprint information?
Author
Previous Topic Next Topic
Strot Harn
Deep Core Mining Inc.
Caldari State
#1 - 2014-02-20 18:23:05 UTC
Is there an API that can be queried to import information to excel about ship stats, module properties, blueprint material requirements, etc?

The only website I know that warehouses this information is games.chruker.dk

However, I never know how up to date that information is (or where they get it). I'd like to query a CCP database if possible for this information, since theirs has the most up-to-date information.
Rob Crowley
State War Academy
#2 - 2014-02-20 19:01:23 UTC
This kind of info is in the SDE a.k.a. toolkit: http://community.eveonline.com/community/fansites/toolkit/

So while you can't query a CCP DB, you can put this in your own DB.
Strot Harn
Deep Core Mining Inc.
Caldari State
#3 - 2014-02-21 18:57:08 UTC

Rob Crowley wrote:
This kind of info is in the SDE a.k.a. toolkit: http://community.eveonline.com/community/fansites/toolkit/

So while you can't query a CCP DB, you can put this in your own DB.



Ok. I've been pwnd. That DB file has been gang ganking me for two days now.

How do I get that data into excel? Or access from excel. I do not possess a computer science degree, nor am I familiar with database files/clients/servers.

I've installed MySQL server, opened it ... tried linking the file dingus to the sumpthin'-sumpthin' hook-up and have no idea if I did or not.

Installed MySQL for Excel, but don't know what to hook up to what. It doesn't even ask where the file is.

Clearly, I don't know what I'm doing.
Rob Crowley
State War Academy
#4 - 2014-02-21 20:21:16 UTC
Strot Harn wrote:
Ok. I've been pwnd. That DB file has been gang ganking me for two days now.

I've installed MySQL server

That's the problem right here, the CCP dump is MSSQL, not MySQL. Those are similar, but not the same. Either you get MSSQL Server which is linked on the SDE website or, if you want to keep MySQL, you could use Steve's SDE conversions.
Strot Harn
Deep Core Mining Inc.
Caldari State
#5 - 2014-02-21 22:13:30 UTC
Oh. What?

Will have to try again later when i have some time.

And thanks for the push in the right direction.