Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.20 07:40:00 -
[1]
hey everyone
im working on a sheet that can monitor your POS fuel. When i import the API information then i get ex tower ID, system ID and moon ID, but they are all number. Does anyone have a link to a site where i can get the system names linked to the ID? or knows how to import it in a nother way so you get system names too?
Thanks ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Lumy
Minmatar eXceed Inc.
|
Posted - 2008.12.20 08:16:00 -
[2]
You're going to need CCP database dump. You can find conversion to various types here. Look for table "mapsolarsystems".
Hope that helps.
Joomla! in EVE - IGB compatible CMS. |
Dragonaire
Caldari Corax.
|
Posted - 2008.12.20 08:26:00 -
[3]
You have to use the static data dump that CCP puts out or one of the conversion that you can find a link to at Eve-Dev under Resources. If you also need to do outposts/conquerable stations you'll need to get their names from the Eve API also which you can find info on at the same location. You'll need to use one or more of the DB tables and/or the other API info to do the 'Numbers to names' part as I call it.
You might also check out one of the several other application that others have already made like POS Tracker which is now testing it's third generation. -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API. |
Macdeth
Ephemeral Misgivings
|
Posted - 2008.12.20 09:05:00 -
[4]
Aside from the database exports, it probably wouldn't be too tremendously rude to look them up using http://api.eve-online.com/eve/CharacterName.xml.aspx?IDs=######,######,###### if you stored the results permanently in your own database and checked the db first before sending any queries to the API.
I started from the DB dumps but wound up adding code to do this to my API-consuming programs when Black Rise was added without a corresponding DB release for quite some time.
(Despite being called 'CharacterName', you can look up any ID on this page.)
|
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.21 12:19:00 -
[5]
Thanks alot guys for the help, its just what i needed ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Dedaf
Gallente United Brothers Of Eve Arcane Alliance
|
Posted - 2008.12.21 20:15:00 -
[6]
Edited by: Dedaf on 21/12/2008 20:21:54 hmm i rally think there is a bug in the API string for the convert of ID to Names. http://api.eve-online.com/eve/CharacterName.xml.aspx?IDs= Now i have tryed to do the very same setup with a few other strings like convert name to ID, and that works as it should.
It works fine if i enter the ID manuel, but it cant use reference field like all the other APIs
this doesn't work: IDsID = ("Data!$AB$67") Feed = "http://api.eve-online.com/eve/CharacterName.xml.aspx?IDs=" + IDsID
But this works: NameID = ("Data!$ab$68") Feed = "http://api.eve-online.com/eve/CharacterID.xml.aspx?Names=" + NameID
can anyone eles confirm this? or maybe explain how i need to do it or what im doing wrong. ------- Ore & Ice Mining T1 & Capital & Rig Production POS Fueling and Reaction Minerals to Ore calculator |
Ambo
State Protectorate
|
Posted - 2008.12.21 22:10:00 -
[7]
Is that VBA Excel code or somthing?
If so then it sounds like it's more an issue with VBA and Excel than anything else. I've not touched VBA in ages (thank God ) so fraid I can't help you out directly.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |