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.
 

GoogleDocs: Multiple Lookups with one call
Author
Previous Topic Next Topic
Xedam Praxis
Repo.
#1 - 2013-05-16 06:00:06 UTC
Trying to create a database for wormhole systems, but GoogleDocs limits =ImportXML to 50 per document, so I want to import @shipKills, @podKills and @factionkills all in one cell (or multiple cells if I can comma delimit within the formula).


Right now I have this:

=ImportXML("https://api.eveonline.com/map/Kills.xml.aspx", "sum(//row[@solarsystemid=30004507]/@factionkills)")

That returns ONE value, I want it to return all THREE in the same query.

HALP?!

“The word of a gentleman is as good as his bond; and sometimes better.”

  • Charles Dickens
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2013-05-16 10:16:20 UTC
https://docs.google.com/spreadsheet/ccc?key=0As88qKwn3d59dFZCeS1JblR3VlFLNkpPSnpMTTZZc2c&usp=sharing


=ImportXML("https://api.eveonline.com/map/Kills.xml.aspx", "sum(//row[@solarsystemid=30003504]/@factionkills|//row[@solarsystemid=30003504]/@shipkills|//row[@solarsystemid=30003504]/@podkills)")


It's a little ugly, admittedly. There probably is a way to neaten up the xpath, to just grab multiple attributes of the same node, rather than grabbing three separate node attributes (that happen to be from the same node)


Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Xedam Praxis
Repo.
#3 - 2013-05-16 16:23:09 UTC
I believe this solution adds all the values together. I need the values to be separated in order to split them up. So the call would return something like "6,40,2" in one cell.

Is this possible?

“The word of a gentleman is as good as his bond; and sometimes better.”

  • Charles Dickens
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2013-05-16 16:35:06 UTC
Xedam Praxis wrote:
I believe this solution adds all the values together. I need the values to be separated in order to split them up. So the call would return something like "6,40,2" in one cell.

Is this possible?



Should be possible with a 'continue'. There's one in that spreadsheet. I'm not sure, but I don't think it counts as another importxml call

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Xedam Praxis
Repo.
#5 - 2013-05-16 19:50:26 UTC
Yea, I got a =CONTINUE to work, thanks for your help, Steve.

Now, next question is, is there a list of Solar System IDs with their corresponding J-numbers. I found http://eve-marketdata.com/developers/solarsystems.php, but this only K-Space Ugh.

Thanks!

“The word of a gentleman is as good as his bond; and sometimes better.”

  • Charles Dickens
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2013-05-16 23:05:55 UTC
Xedam Praxis wrote:
Yea, I got a =CONTINUE to work, thanks for your help, Steve.

Now, next question is, is there a list of Solar System IDs with their corresponding J-numbers. I found http://eve-marketdata.com/developers/solarsystems.php, but this only K-Space Ugh.

Thanks!



take a look at http://www.fuzzwork.co.uk/dump/retribution-1.1-84566/mapSolarSystems.xls.bz2 (use 7zip to unzip it, if you don't have something to take care of it)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter