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.
 

Help!, My Spreadsheet Gets N/A And Infinite Loading
Author
Previous Topic Next Topic
Hiro Kaichi
Garoun Investment Bank
Gallente Federation
#1 - 2015-03-03 16:27:18 UTC
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
#2 - 2015-03-03 17:26:55 UTC
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
Garoun Investment Bank
Gallente Federation
#3 - 2015-03-03 18:05:00 UTC
How do I use the script? sorry im quite new to this :(
Hel O'Ween
Men On A Mission
#4 - 2015-03-04 17:54:46 UTC
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
#5 - 2015-03-10 02:12:45 UTC
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
Caldari Provisions
Caldari State
#6 - 2015-03-12 16:24:38 UTC  |  Edited by: Nolen Cadmar
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