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.
 

How to pull personal assets
Author
Previous Topic Next Topic
Full Metal Jackie
Center for Advanced Studies
Gallente Federation
#1 - 2013-07-31 12:15:56 UTC  |  Edited by: Full Metal Jackie
o/

I'm working in Googledocs and I'm wanting to use importXML to pull the quantity of a few specific items in one specific location. Naturally I went to Google to see if someone was working on something similar and there was! I've tried referencing this: http://eve-search.com/thread/194732-1#11 but I'm not having any luck as its returning to me as a value of 0... The item is in Jita 4-4 in a station container in my inventory, but will that have any added effect?

Here is exactly what it looks like:

=ImportXML("https://api.eveonline.com/char/AssetList.xml.aspx?vcode=52yDxAC0VbzztL8ULRWMI66gOSvQlS3YS1CxahGCRwjse9RmvtQicjCLEjVaPRVo&keyid=2432885", "sum(//row[@locationid=30000142 and @typeid=34 ]/@quantity)")

My goal is to be able to essentially manage my assets like a warehouse. What I want to do is be able to plug in my blueprints with their material requirements and have it check against how much I have in my inventory.

Thanks in advance for the help!
Fubar
Eagle Eye Inc.
#2 - 2013-07-31 18:59:19 UTC
You need to specify the container ID in importXML.

For example...

=ImportXML("https://api.eveonline.com/char/AssetList.xml.aspx?vcode=52yDxAC0VbzztL8ULRWMI66gOSvQlS3YS1CxahGCRwjse9RmvtQicjCLEjVaPRVo&keyid=2432885","sum((//row[@locationid=60003760 and @itemid=1011469699603]/rowset/row[@typeid=18]/@quantity))")

The above finds the quantity of Plagioclase in one of your Station Warehouse Containers.

I found the containerID using jEveAssets 2.6.1

Hope this helps...
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2013-07-31 21:37:46 UTC
While it's not googledocs, jeveassets is easily capable of managing your assets api.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter