These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Script Google spreadsheet

First post
Author
Previous Topic Next Topic
J J
The Scope
Gallente Federation
#1 - 2016-06-11 16:14:14 UTC
Warning Noob question What?


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
Imperial Academy
#2 - 2016-06-11 16:58:05 UTC  |  Edited by: Blacksmoke16
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
The Scope
Gallente Federation
#3 - 2016-06-11 23:04:56 UTC
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
Imperial Academy
#4 - 2016-06-12 02:57:30 UTC
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
The Scope
Gallente Federation
#5 - 2016-06-12 10:52:20 UTC
There you got me with my pants down Oops

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. Sad
Blacksmoke16
Imperial Academy
#6 - 2016-06-12 14:45:07 UTC
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
#7 - 2016-06-12 18:31:42 UTC
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
The Scope
Gallente Federation
#8 - 2016-06-16 19:28:37 UTC
Hi Guys

Sorry for my late answer, have been working a lot.

Many thanks to you both for the suggestions and help