open All Channels
seplocked EVE Information Portal
blankseplocked New Blog, Garthagk with more API information and a Surprise!
This thread is older than 90 days and has been locked due to inactivity.

Pages: [1] 2

Author Topic

CCP kieron

Posted - 2007.07.12 16:47:00 - [1]

Revelations II was released a short time ago and a part of the release was the deployment of the API Project. The community has been asking for more information on the Project, as well as a refreshed data dump with updated Revelations II information. Garthagk has heard and complied.

While not a lengthy blog, it still provides much of the information the community has been asking for and also gives a shout out to some EVE players who have contributed their efforts to the betterment of the community. Third Party Development (and a new data dump!)

Echoes of Space
Posted - 2007.07.12 16:55:00 - [2]

Edited by: Jameroz on 12/07/2007 16:57:43
Finally we get the new data dump! YAY! Very Happy

BTW. the unofficial mysql link wasn't working.

The Forsakened Few
Green Alliance
Posted - 2007.07.12 16:56:00 - [3]

Woot! And I wanna hear about what's planned!

Otherworld Enterprises
Otherworld Empire
Posted - 2007.07.12 16:58:00 - [4]

api api api dump dump dump Laughing

Imminent Darkness
Fluff Bites
Posted - 2007.07.12 17:29:00 - [5]

very nice blog m8

Ars ex Discordia
Posted - 2007.07.12 17:55:00 - [6]

i get a 404 error when I attempt to download the unofficial mySQL data dump

Posted - 2007.07.12 17:56:00 - [7]

For the technically interested, #eve-dev on is always a nice place to step by ;)

Distant Thunder
Perihelion Alliance
Posted - 2007.07.12 18:02:00 - [8]


CCP Garthagk

Posted - 2007.07.12 18:38:00 - [9]

The MySQL dump link works now. My bad. Cool

Emily Spankratchet
Posted - 2007.07.12 19:49:00 - [10]

MS SQL and MySQL? You're spoiling us. Many, many thanks to the unnamed converter to MySQL. I've done it myself for previous dumps and it's a pain in the bum.

Omega Wing
Snatch Victory
Posted - 2007.07.12 20:39:00 - [11]

This API stuff looks tres cool, G. Imma actually use a skill trainer now.

Posted - 2007.07.12 21:01:00 - [12]

Oooooo been waiting for this, I was actually wondering about it this morning. Thankyou! Very Happy

Tiberyya Za
Bellum Aeternus
Imperial 0rder
Posted - 2007.07.12 21:18:00 - [13]

So how do I get the bz2 file into my MySQL 5 database?

Morsus Mihi
Posted - 2007.07.12 21:24:00 - [14]

t20`s rehabilitation, eh? ;)

Btw. thanks for the sql-dump. hope to see some updated stuff soon in evemon or the like. :)

Lord Zuku
Ministry of War
Posted - 2007.07.12 21:28:00 - [15]

Originally by: Tiberyya Za
So how do I get the bz2 file into my MySQL 5 database?

You uncompress the file before importing into the DB.

Spoon Thumb
Khanid Provincial Vanguard
Vanguard Imperium
Posted - 2007.07.12 23:01:00 - [16]

So, when we gonna see missions created by players or a ship design competition.

Also thanks, this I'm sure will coem in useful :)

Posted - 2007.07.12 23:44:00 - [17]

MySQL import worked fine...

I converted that to an Access-mdb (a2k)..but have no webspace so if some1 have around 55mb free lemme know

Thx for the export...

Corsairs Inc.
The Spire Collective
Posted - 2007.07.13 02:09:00 - [18]

Originally by: Mirida
For the technically interested, #eve-dev on is always a nice place to step by ;)

going to check that in the next week end !

Data Xport rule da EvE !

Brad Stone
Posted - 2007.07.13 06:44:00 - [19]

Edited by: Brad Stone on 13/07/2007 06:46:38
Garhagk has been great at supporting us 3rd party devs recently. He's always willing to listen to our suggestions and answer questions, and even fix the occasional ermmm "unintended feature" in the api. He also gave us early sight of a betatest version of the dump.

In a nutshell, with this increased level of support from Garthagk and other CCP staff, the future of 3rd party tools is very very bright indeed.

Some more links for the 3rd party devs:

#eve-dev on - THE place to be for anyone interested in developing tools a new fully featured wiki for devs (includes a contributon or two from Garthagk) This is very much in it's infancy - help us to build it up. You can see there some of the stuff coming along that's being done with the api's including exi's astoundingly impressive influnece map (which I have as my wallpaper now!)

Split Infinity
Posted - 2007.07.13 07:50:00 - [20]

kieron! I want your children! :-D

You made me the happiest guy in the world. I alreadly looked into the API a while ago and it looked nice enough. :-)

Originally by: Mirida
For the technically interested, #eve-dev on is always a nice place to step by ;)

Wouldn't it be better to be on Freenode? That's the most developer oriented IRC server that I know of. I mean... It's actually against the rules to have channels there not related to projects or products. Just a thought... (Oh, and I'm gonna be wherever that channel may be anyway)

LUX Uls Xystus
Posted - 2007.07.13 11:22:00 - [21]


The offical API discussion thread is much overloaded with people asking for help with there implementations. So I just ask here.

Will there be an afterRefId option to get data after a known Id?

I think his this would be very helpful. It would speed up the process of downloading the data fom the EVE-server.

Actually I do:

1 getXMLData
2 looking for the last refid in XML
3 if I already have it in my database -> Exit; else Step 1

With afterRefId I could do it this way:

1 getXMLData with last refId from my database
2 if I get less than 1000 rows -> Exit; else Step 1

So in the best case (0 new datasets) there will be a huge speed up.
In the worst case (more than new 1000 datasets) there will be no speed up on the first set of data. But on the last...

Thank you for reading.

Matroos Cantina
Izanagi Alliance
Posted - 2007.07.13 17:05:00 - [22]

I updated an script which convert dumped mssql files to MS SQL Express 2005 Transact-SQL.

what this script do is:
- insert 'use rev2;' at first.
- convert 'true' to '1', 'false' to '0'
- delete 'COMMIT;'
- insert 'GO' for every 40000 lines
- convert UNKOWN to INTEGER, DATE to datetime

Raquel Smith
Posted - 2007.07.14 11:39:00 - [23]

Any interest in a Postgres (8.0) formatted dump?

Posted - 2007.07.14 22:24:00 - [24]

Here is an Access 2000 Version of the dump:
Access-mdb 55mb

Thx to Kaldira for hosting it

Stellar Tide
Posted - 2007.07.15 01:58:00 - [25]

Edited by: Tessen on 15/07/2007 02:00:37

Unless two alliance use it, MC logo is twiced in logos file :

icon09_01.png and icon33_04.png are the same.

Posted - 2007.07.16 09:30:00 - [26]

nice :)
we waiting half year for this ..........

Azia Burgi
Science and Trade Institute
Posted - 2007.07.16 11:49:00 - [27]

Originally by: Andrahkon
Here is an Access 2000 Version of the dump:
Access-mdb 55mb

Thx to Kaldira for hosting it

Thanks for the Access version!

CCP kieron

Posted - 2007.07.16 16:22:00 - [28]

Originally by: J'ahra
kieron! I want your children! :-D

My wife might have issue with that and to be honest I did little more than make the announcement. Garthagk did the lion's share of the work, he deserves the credit (and offers).

I am willing, however, to preview pictures and forward worthy candidates to Garthagk so he can continue his efforts on the API project uninterrupted. WinkLaughing

Neko Sornan
eXceed Inc.
Posted - 2007.07.16 19:43:00 - [29]

Where can I find the icon name -> alliance information for the supplied alliance icons?

Posted - 2007.07.17 10:54:00 - [30]

Hi, I'd like to know why CCP went with a custom API system instead of for example SOAP or XML-RPC? Both would have provided very easy access to the data for any languages.

I do understand that it is possible now with XML, yet the WSDL feature of SOAP allow someone to convert URL into straight functions which remove a lot of issues and also returns object instead of having to parse and figure out XML.

Oh well... wish you could offer both soon, hate to do the dirty work.

Pages: [1] 2

This thread is older than 90 days and has been locked due to inactivity.


The new forums are live

Please adjust your bookmarks to

These forums are archived and read-only