| Author |
Topic |
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]
Edited by: Lorcaine on 09/03/2011 17:49:07
65,5MB is a bit of a file :/. Well if there is no other way, then it will be this.
Edited....: That's really overkill.... the database dump has a size of 347MB..... and I just thought it should be a small program xD |
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:46:55
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, 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]
|
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. |
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* |
All Channels
EVE Technology Lab
