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

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

Science & Industry

 
  • Topic is locked indefinitely.
 

Google docs and corp assets

First post
Author
Previous Topic Next Topic
Faith Cassidy
Sebiestor Tribe
Minmatar Republic
#1 - 2015-01-18 15:43:41 UTC
Trying to use http://wiki.eve-id.net/APIv2_Corp_AssetList_XML to pull a corp asset list so i can use it to determine how many minerals i need to buy compared to how many i already have.

My issue is it has multiple rowsets, so how do i go about pulling all of them as it seems to just want to pull the first one with importxml
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2015-01-18 17:51:14 UTC
importxml is not good, the moment you have an at all complicated xml structure, and want to pull multiple results.

https://forums.eveonline.com/default.aspx?g=posts&m=2750367 is an alternate way of doing it. (I'm not sure if it works with the new version, due to changes in the xml handling. relatively simple to update to the new one though. If it doesn't work for you, yell, and I'll see about getting an updated version worked up)

It loads all assets into a single sheet, which you can then use vlookups and similar functions on.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Faith Cassidy
Sebiestor Tribe
Minmatar Republic
#3 - 2015-01-20 03:48:04 UTC  |  Edited by: Faith Cassidy
throws an error for this line

var stationRange = SpreadsheetApp.getActiveSpreadsheet().getRangeByName("stationData");


edit nvm...

got it working