Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
J J
Corporation Danmark Goonswarm Federation
0
|
Posted - 2016.06.11 16:14:14 -
[1] - Quote
Warning Noob question
I am trying to make a script in Google spreadsheet That Can pull all npc and conqure stations, i have been looking at fuzzy but the station list i find there and on neo eve dev...
So the thing i want to hear if there is any one that Can point me to a Way to get this list as xml, or csv, or a script in Google that Can pull this informations.
|
Blacksmoke16
Resilience.
14
|
Posted - 2016.06.11 16:58:05 -
[2] - Quote
Player own station: https://api.eveonline.com/eve/ConquerableStationList.xml.aspx
NPC Stations are in the SDE
EDIT: I exported the NPC stations: eve-services.net/Files/npcStations.csv |
J J
Corporation Danmark Goonswarm Federation
0
|
Posted - 2016.06.11 23:04:56 -
[3] - Quote
Hi
Thanks for the super work, BUT
This https://api.eveonline.com/eve/ConquerableStationList.xml.aspx is missing the region ID, or is there an way to calculate it from the z,y,x coordinates, or is there an easyer way then using Dotlan to get the region, b/c i would like to put this 2 list together in my tool.
|
Blacksmoke16
Resilience.
14
|
Posted - 2016.06.12 02:57:30 -
[4] - Quote
You can use the SDE to lookup region name based on solarSystemID. How to do that depends on what language your using and how you have your stuff set up. |
J J
Corporation Danmark Goonswarm Federation
0
|
Posted - 2016.06.12 10:52:20 -
[5] - Quote
There you got me with my pants down
I am not programming my self, no clue, but is using Fuzzy links and guids in google spreadsheet, so i have no idea to how to get the info from SDE. |
Blacksmoke16
Resilience.
14
|
Posted - 2016.06.12 14:45:07 -
[6] - Quote
In that case...lookup vLookup https://support.google.com/docs/answer/3093318?hl=en
Then took the liberty of exporting the systems and regions
http://eve-services.net/Files/systemsRegions.csv
Im not sure what you need so shooting from the hip here. Can import the outpost api using importxml on google sheets, then use vlookup to get system and region names. Need anything else maybe convo/mail me. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
6027
|
Posted - 2016.06.12 18:31:42 -
[7] - Quote
https://github.com/fuzzysteve/eve-googledocs-script/blob/master/OutpostLoader.gs will load all the outposts. There's an example sheet linked in the comments.
It's not the fastest of functions, unfortunately, but that's because it's quite a large list of outposts. (and google doesn't give you a lot of power for these)
It's _possible_ to extend it with the region ids as well, but you need to have mapSolarSystems and mapRegions (or use the file blacksmoke16 provided) to then do the lookups to region names.
Woo! CSM XI!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
J J
Corporation Danmark Goonswarm Federation
0
|
Posted - 2016.06.16 19:28:37 -
[8] - Quote
Hi Guys
Sorry for my late answer, have been working a lot.
Many thanks to you both for the suggestions and help |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |