Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Demonicus
HootySpoon
0
|
Posted - 2013.12.15 00:45:00 -
[1] - Quote
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
Hurricane Research
44
|
Posted - 2013.12.15 10:33:00 -
[2] - Quote
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
0
|
Posted - 2013.12.15 17:52:00 -
[3] - Quote
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
0
|
Posted - 2013.12.17 03:56:00 -
[4] - Quote
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
Blue Republic RvB - BLUE Republic
91
|
Posted - 2013.12.18 04:48:00 -
[5] - Quote
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. |
Wafflehead
Hurricane Research
47
|
Posted - 2013.12.18 19:52:00 -
[6] - Quote
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 |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |