| Pages: [1] :: one page |
|
|
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Lorcaine
   |
Posted - 2011.03.09 16:37:00 -
[1]
Edited by: Lorcaine on 09/03/2011 16:40:28
Hi everyone.
I have just started a smaller project where I try to make a program that can show the info on all POS in a corporation. I have no trouble by retrieving all the POS info, but I don't know how to convert the moonID into a moon name or something like that. Do I have to get the static information from a local database (like the static dump) or can I retrieve them directly from the api service?
Regards Lorcaine
EDIT: I'm using C# on the .NET platform.
|
Desmont McCallock
|
Posted - 2011.03.09 16:49:00 -
[2]
You need to retrieve them from SDD, table 'mapDenormalize'.
|
Lorcaine
|
Posted - 2011.03.09 17:09:00 -
[3]
So I need to download the tables for MSSQL server?
|
Matalino
|
Posted - 2011.03.09 17:16:00 -
[4]
Edited by: Matalino on 09/03/2011 17:16:34
 Originally by: Lorcaine
So I need to download the tables for MSSQL server?
That would be the easiest way. Of course, once you have downloaded the database you can export that data you use into a format that is easier to handle in your program.
|
Lorcaine
|
Posted - 2011.03.09 17:23:00 -
[5]
65,5MB is a bit of a file :/. Well if there is no other way, then it will be this.
|
Catari Taga
Centre Of Attention
Middle of Nowhere
|
Posted - 2011.03.09 18:43:00 -
[6]
Edited by: Catari Taga on 09/03/2011 18:45:49
As Matalino said, you do not need to keep everything for your program, just export itemID and itemName for all moons into a separate table of whichever format and the data will be easy to handle. Even a .csv with that data is only 10 MB in size, every binary format will be less, and because of the many repetitions it compresses well, anyway.
--
|
Lorcaine
|
Posted - 2011.03.09 22:41:00 -
[7]
I am currently looking into it. But it gives som work but I think I can manage it ^^.
|
Lutz Major
|
Posted - 2011.03.09 22:54:00 -
[8]
Originally by: Lorcaine
... or can I retrieve them directly from the api service?
https://api.eve-online.com/eve/CharacterName.xml.aspx?ids=707281926
Would safe you the hassle exporting the data dump.
But I'd suggest, that you store the returned values you requested to minimize API calls.
|
TorTorden
Amarr
|
Posted - 2011.03.09 23:52:00 -
[9]
Could possibly collect your id's, and send to the api as a comma list, and save that xml and use it for later since they are static.
Biggest problem with this is if you add more pos's on a regular basis.
------------------------------------------------
There is no such thing as good or evil.
Just an egotistic struggle for self empowerment.
------------------------------------------------ |
Lorcaine
|
Posted - 2011.03.10 08:19:00 -
[10]
If I'm retrieving the data from API service, I will save the data locally and then make a method that once a week or on demand checks for changings in amount of POS and more. But are you sure I can retrieve itemName for a moon from the moonID on Characters.xml.aspx? I have tried but it comes with an error.
|
|
|
Catari Taga
Centre Of Attention
Middle of Nowhere
|
Posted - 2011.03.10 08:39:00 -
[11]
Originally by: Lorcaine
But are you sure I can retrieve itemName for a moon from the moonID on Characters.xml.aspx? I have tried but it comes with an error.
You cannot, that call is only for owner and typeIDs. However, CCP Prism X mentioned that they are planning to introduce an API call for itemIDs eventually.
--
|
Lorcaine
|
Posted - 2011.03.10 09:07:00 -
[12]
Edited by: Lorcaine on 10/03/2011 09:14:35
Edited by: Lorcaine on 10/03/2011 09:07:18
Hmmm yeah that was what I had figured out too.
I have pulled out the convert data (itemID, itemName) and I want them into a clean database but somehow I can figure out how to select them into the clean database. I have used
INSERT INTO EPM.Moons(itemID, itemName)
SELECT itemID, itemName FROM ebs_datadump.mapDenormalize
WHERE itemName like '%Moon%'
But it doesn't work :( Any idea how I can do it smartly?`(Using SQL 2008 Express)
Edit:
I found out how it should be done. the SQL for moving the data is as follows
insert into EPM.dbo.Moons(itemID, itemName)
select itemID, itemName from ebs_DATADUMP.dbo.mapDenormalize
where itemName like '%Moon%'
|
Lutz Major
|
Posted - 2011.03.10 09:13:00 -
[13]
Originally by: Catari Taga
Originally by: Lorcaine
But are you sure I can retrieve itemName for a moon from the moonID on Characters.xml.aspx? I have tried but it comes with an error.
You cannot, that call is only for owner and typeIDs. However, CCP Prism X mentioned that they are planning to introduce an API call for itemIDs eventually.
*sigh* right, I forgot the 'future note' part 
I shouldn't post after a 23 hour baby-induced uptime *zzzzzz*
|
|
|
| |
|
| Pages: [1] :: one page |
| First page | Previous page | Next page | Last page |