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.
 

Corp Assets -> Google Docs (50 limit arggh)
Author
Previous Topic Next Topic
Demonicus
HootySpoon
#1 - 2013-12-15 00:45:23 UTC  |  Edited by: Demonicus
Hello guys,

I've been happily working away on my invention/production spreadsheets which help me manage inventory levels of materials and shopping lists in Jita. All was going well until I hit the 50 importXML limit. This problem understandably only appeared after my invention/production passed about ten unique items. I understand this is not a new problem and there has been a lot of discussion on these forums so far. After searching though I still haven't found a workable solution - I'm hoping you will have new ideas.

A little background on my spreadsheets. I have been making use of two types of call:

One to get specific inventory items:

Quote:
=ImportXML($B$3; "sum(//row[@locationid="&$B$2&"]/rowset/row[@typeid="&$B9&"]/@quantity)")


And one to get market prices:

Quote:
=ImportXML("http://eve-marketdata.com/api/item_prices_jita.xml?type_ids="&JOIN(",",$B9:$B36), "/eve/price")


The obvious difference is that the eve-marketdata API allows me to pull down a batch of item types in one call, where the eve api does not.

I'm looking for a way to more efficiently pull assets into my Google spreadsheet. I'm hoping that I can:

  • avoid the use of a database or php script to transform and serve an eve-marketplace like xml
  • still use google docs so I can collaborate with corpmates
  • perhaps find a way to use xpath to dump all assets onto a page in the spreadsheet that I can run vlookups on


Thanks for your help!
Wafflehead
Garoun Investment Bank
Gallente Federation
#2 - 2013-12-15 10:33:31 UTC
I don't quite understand why you would be hitting the limit?.

You do a single ImportXML and then use the =CONTINUE to fill the entire contents of your assets.

Then you need to build the URL to pull the item ids, not a ImportXML for each item.
Demonicus
HootySpoon
#3 - 2013-12-15 17:52:49 UTC
Wafflehead wrote:
I don't quite understand why you would be hitting the limit?.

You do a single ImportXML and then use the =CONTINUE to fill the entire contents of your assets.

Then you need to build the URL to pull the item ids, not a ImportXML for each item.


Yes with the eve-market api I can do a single import using a range of typeids but with the eve api I can't figure out how to do this and don't actually think it is possible. If you know how I'd be keen to hear.
Demonicus
HootySpoon
#4 - 2013-12-17 03:56:00 UTC
Maybe I need to ask the question in another way.

How do you keep track of inventory levels and material requirements? Not for one item, but dozens of tech 2 items and in the future ships.
Caerfinon
Caldari Provisions
Caldari State
#5 - 2013-12-18 04:48:36 UTC
Demonicus wrote:
Maybe I need to ask the question in another way.

How do you keep track of inventory levels and material requirements? Not for one item, but dozens of tech 2 items and in the future ships.



I use jEveAssets to track inventory and use the stockpile tool to create lists of items and their locations for things I plan to build.
It grabs pricing from eve-central based on preferences you set.

Cheers C.

@Caerfinon - Twitter
Wafflehead
Garoun Investment Bank
Gallente Federation
#6 - 2013-12-18 19:52:30 UTC
Demonicus wrote:
Maybe I need to ask the question in another way.

How do you keep track of inventory levels and material requirements? Not for one item, but dozens of tech 2 items and in the future ships.



You would need to create some custom script to do this properly.

This is an OLD script that use to work:
https://gist.github.com/kriberg/abcae71b80213ae36b8f