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.
 

google docs feat importXML vs eve API feat typeID & locationID
Author
Previous Topic Next Topic
opati
Gilbatron Heavy Industries
#1 - 2012-04-04 05:13:17 UTC
hey guys

i want to make google docs ask for a number of items, but only for a specific station

=ImportXML(D39, "sum(//row[@typeid="&K45&"]/@quantity)")

works fine for all items of a specific kind, but i only care about those in a specific empire station and not those scattered all around 00 space

can someone help me ?
opati
Gilbatron Heavy Industries
#2 - 2012-04-04 21:29:04 UTC
bump
Scrapyard Bob
EVE University
Ivy League
#3 - 2012-04-05 00:54:14 UTC
Link a simple googledocs spreadsheet maybe?

I've never seen ImportXML() used that way.

And if you're pulling from the EMK API, then you can just use a different API URL which only lists a single station or single system.