Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Hiro Kaichi
The Folkvangr Project
0
|
Posted - 2015.03.03 16:27:18 -
[1] - Quote
Sorry if this is in the wrong section but i'm new to the forms so please forgive me :D. But my spreadsheet was working for a while but now only it half works and I get N/A and it will say loading indefinitely, here is the link to the spreadsheet.
https://docs.google.com/spreadsheets/d/1KyTS-EJm-61Z5fLHYFewyvEz2GMUspJv5fZbMe_FG-s/edit?usp=sharing
Thanks :D |
Hel O'Ween
Men On A Mission
108
|
Posted - 2015.03.03 17:26:55 -
[2] - Quote
Search this forum for "importXML" and you'll see that this is the problem. I've never used Google Docs myself, but I know that Steve has some scripts for Google Docs up in his repository: https://github.com/fuzzysteve/eve-googledocs-script
EVEWalletAware - an offline wallet manager.
|
Hiro Kaichi
The Folkvangr Project
0
|
Posted - 2015.03.03 18:05:00 -
[3] - Quote
How do I use the script? sorry im quite new to this :( |
Hel O'Ween
Men On A Mission
109
|
Posted - 2015.03.04 17:54:46 -
[4] - Quote
Have a look at https://docs.google.com/spreadsheets/d/1f9-4cb4Tx64Do-xmHhELSwZGahZ2mTTkV7mKDBRPrrY/edit#gid=2053415911
This seems to be a demo that Steve has put together, as noted in https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs
If you can't figure it out from there yourself, I can't help you any further as I've -as already mentioned, have never used Google Docs in my life (nor Excel, btw).
EVEWalletAware - an offline wallet manager.
|
Lemkor Gengod
Stacmon Production and Trade Institue
0
|
Posted - 2015.03.10 02:12:45 -
[5] - Quote
The problem is that you are trying to make too many calls at once. Google sheets doesn't like lots of importXML commands.
Don't worry, there is a work around. You can simply lookup lots of typeID's at once
=importxml((concatenate(Math!B3&Join("&typeid=",C2:C14),Math!C3)),"//sell/min")
Syntax may be off a little bit as I haven't done it for a looooong time, but I'm sure you get the gist.
You just need it in the first cell and all the cells under will fill automatically
|
Nolen Cadmar
Black Thorne Corporation Black Thorne Alliance
230
|
Posted - 2015.03.12 16:24:38 -
[6] - Quote
Lemkor Gengod wrote:The problem is that you are trying to make too many calls at once. Google sheets doesn't like lots of importXML commands.
Don't worry, there is a work around. You can simply lookup lots of typeID's at once
=importxml((concatenate(Math!B3&Join("&typeid=",C2:C14),Math!C3)),"//sell/min")
Syntax may be off a little bit as I haven't done it for a looooong time, but I'm sure you get the gist.
You just need it in the first cell and all the cells under will fill automatically
The actual problem is that Eve-Central data does not load reliably into GDocs. This has been the case since around xmas 2014. The easiest solution is to use the script created by Steve Ronuken (link in Hel O'Ween's post above). It's pretty simple to modify his script if you don't want ALL data being imported.
Nolen's Spreadsheet Guru Services
Pre-made spreadsheets available covering market, manufacturing and more!
Custom requests welcome!
Sheet Screenshots
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |