Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Lucius Uta
Not really a corp
3
|
Posted - 2014.11.14 13:28:04 -
[1] - Quote
I'm using Google Sheets for my blueprints and some time ago they stopped pulling data from Eve-Central for some items, like Morphite. So for example the following formula gives #N/A Import Internal Error
=importXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=11399", "/evec_api/marketstat/type/sell/min")
Is this a known problem and is there a workaround? |
Vladdy Tepes
Alpha Squad Delta backup with Charlie Company Eternal Pretorian Alliance
1
|
Posted - 2014.11.14 18:44:19 -
[2] - Quote
I notice that google docs is not very reliable.
Go to your formula and just delete a character and put it back. If it turns all green then it will work again. |
Neugeniko
Insight Securities
45
|
Posted - 2014.11.15 06:25:42 -
[3] - Quote
Lucius Uta wrote:I'm using Google Sheets for my blueprints and some time ago they stopped pulling data from Eve-Central for some items, like Morphite. So for example the following formula gives #N/A Import Internal Error =importXML("http://api.eve-central.com/api/marketstat?usesystem=30000142&typeid=11399", "/evec_api/marketstat/type/sell/min") Is this a known problem and is there a workaround?
The importxml function in the new google sheets isn't very reliable for some websites. Try @Fuzzysteve google script custom functions instead. https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs
Also keep a eye out for @HLIBIndustry future work as more market data comes to the CREST API. https://github.com/lockefox/CriusDev/blob/master/gdoc_scripts.js
Hope this helps, Neug
Indices/Mining Simulator V2.98 UPDATED
Daily Forge Mineral Sales Summary V1.3
Neug's Prime Industrial Real Estate V1.1
|
Soldarius
Deadman W0nderland The 99 Percent
882
|
Posted - 2014.11.18 22:03:33 -
[4] - Quote
Confirmed, importXML sucks ballz. Use Steve's script.
http://youtu.be/YVkUvmDQ3HY
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4206
|
Posted - 2014.11.19 06:41:12 -
[5] - Quote
The main difference to using a script like mine is:
You load all the prices you want onto a separate sheet. Then you use vlookup to grab them as needed.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Lucius Uta
Not really a corp
3
|
Posted - 2014.11.19 11:55:14 -
[6] - Quote
I will try with FuzzySteve's function then. One question though - what is the cachebuster parameter for, what values it should have and would it be a good idea to remove it? |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4206
|
Posted - 2014.11.19 12:16:07 -
[7] - Quote
Lucius Uta wrote:I will try with FuzzySteve's function then. One question though - what is the cachebuster parameter for, what values it should have and would it be a good idea to remove it?
It's completely optional, so you can leave it out quite happily (like if you leave out the region, you get jita).
It was added on request, as someone wanted to be able to get round the caching from google. (they obey eve central's caching rules, and only pull once an hour) That value just changes the url enough that it can get new data. As long as you change it.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Lucius Uta
Not really a corp
3
|
Posted - 2014.11.19 14:24:28 -
[8] - Quote
Steve Ronuken wrote:The main difference to using a script like mine is:
You load all the prices you want onto a separate sheet. Then you use vlookup to grab them as needed.
That's why I modified your function to return single values:
function loadPriceCell(typeID,systemID,cachebuster){ if (typeof systemID == 'undefined'){ systemID=30000142; //Jita } if (typeof typeID == 'undefined'){ throw 'need typeids'; } if (typeof cachebuster == 'undefined'){ cachebuster=1; }
var url="http://api.eve-central.com/api/marketstat?cachebuster="+cachebuster+"&usesystem="+systemID+"&typeid="+typeID; var parameters = {method : "get", payload : ""}; var xmlFeed = UrlFetchApp.fetch(url, parameters).getContentText(); var xml = XmlService.parse(xmlFeed); if(xml) { var rows=xml.getRootElement().getChild("marketstat").getChildren("type"); var price = rows[0].getChild("sell").getChild("min").getValue(); } return price; }
and typing = loadPriceCell(11399) in a cell (naturally I don't memorize or copy/paste all the TypeIDs, but use vLookup) gives me minimum sell value of Morphite in Jita, hooray!
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4210
|
Posted - 2014.11.19 16:23:34 -
[9] - Quote
That's a somewhat less than friendly to eve-central option.
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Lucius Uta
Not really a corp
3
|
Posted - 2014.11.19 17:39:15 -
[10] - Quote
Steve Ronuken wrote:That's a somewhat less than friendly to eve-central option.
Is it because of cachebuster, or because there's bound to be multiple calls in my sheets? If it's the former, then I just remove that parameter (or call the function without it) and problem fixed. If it's the latter, it's going to present a spreadsheet challenge for me, since I use a separate sheet (tab) for every blueprint (which is probably not the most efficient way to run spreadsheets, but I only recently started doing this stuff). Though I just noticed that typing something like =loadPrices(B2:E2) in my sheet will fill the cells with price data for materials I need, just not the cells where I want the data to be (though that's hardly a problem) . And I still need one call for every sheet. |
|
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
4210
|
Posted - 2014.11.19 19:13:30 -
[11] - Quote
one call per sheet is nicer than one call per price. (and don't you have a consolidated list of all the materials you need?)
Woo! CSM 9!
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Lucius Uta
Not really a corp
3
|
Posted - 2014.11.19 21:44:02 -
[12] - Quote
Steve Ronuken wrote:one call per sheet is nicer than one call per price. (and don't you have a consolidated list of all the materials you need?)
I use the ingame Notepad for that
Though I could reduce the number of calls further by considering the fact that some blueprints use the same materials and by using named ranges
And thanks you for your help of course |
AlertForce
The First Foundation SOLAR FLEET
0
|
Posted - 2014.12.24 21:13:28 -
[13] - Quote
What it wants?
[img]http://c2n.me/39pjB8A.png[/img] |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |