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.
 

Updating My Old Google Docs

First post
Author
Previous Topic Next Topic
Igraine Aumer
Sebiestor Tribe
Minmatar Republic
#1 - 2014-12-29 02:19:49 UTC
My friend who no longer plays has some Google docs that performed some basic functions with Eve Central to return market prices. However, he made them like two years ago, and when we opened them today, the ImportXML functions don't work. He's tried to correct them, but he's not even sure if what changed has to do with Eve Central, the APIs, or with Google docs.

https://docs.google.com/spreadsheet/ccc?key=0AkW_Fw9OokCMdHUxOW1IN1oxMV9tSmZselJScGVfRkE#gid=0

The specific cells that no longer work are G8:N8. Can anyone tell what's wrong with them?

(He apologizes for the convoluted way they pull the URL from existing cells. :P )
Amely Miles
Second Exile
#2 - 2014-12-29 10:19:19 UTC
i find it alot easier to get a professionally made sheet from Nolen Cadmar https://forums.eveonline.com/default.aspx?g=posts&t=295315

As I slipped my finger slowly inside her hole, I could immediately feel it getting wetter and wetter.

I took my finger back out and within seconds she was going down on me.

"I really need a new boat," I thought to myself.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2014-12-29 11:14:00 UTC
it's probably the new sheet/old sheet issue that's been cropping up of late.

I duplicated it, and updated to use an alternate method of pulling price data, which avoids importxml.

https://docs.google.com/spreadsheet/ccc?key=0As88qKwn3d59dE40VEdJVVBwOEQxMHVTYktHUGVSdUE&usp=sharing

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Igraine Aumer
Sebiestor Tribe
Minmatar Republic
#4 - 2014-12-30 00:43:26 UTC  |  Edited by: Igraine Aumer
Wow, thanks so much for the work! My friend had a last question though:

"I duplicated your updated spreadsheet back to my drive so I can continue working with it, but it's having trouble recognizing one of the functions you defined in the scripts. I can see the two functions you wrote right there in Script Editor, but the function has an error nonetheless - "Unknown Function Name LOADSYSTEMPRICES". I haven't messed with Google Docs script editor yet, is there some kind of thing I need to do to associate the script with the spreadsheet file or something?"

https://docs.google.com/spreadsheet/ccc?key=0AkW_Fw9OokCMdEFibXpua1Zxdno1cERQVVFsRWVrS2c#gid=0

Edit: "Never mind, I got it to work on yet another sheet. Also GOOD LORD this new/old spreadsheet business is worse than I thought. Thanks again for the help!"
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2014-12-30 10:29:54 UTC
That was odd. should have duplicated the code attached along with it :/

https://github.com/fuzzysteve/eve-googledocs-script/blob/master/EveCentralPrices.gs for anyone else looking for it.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Kasli Catal
Deep Core Mining Inc.
Caldari State
#6 - 2014-12-30 22:58:28 UTC
I keep getting an error for any typeID I throw in, error references line 103 the "priceIDs.forEach". Is it trying to reference some nonexistant function here or am I setting this up wrong?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2014-12-30 23:23:12 UTC
Kasli Catal wrote:
I keep getting an error for any typeID I throw in, error references line 103 the "priceIDs.forEach". Is it trying to reference some nonexistant function here or am I setting this up wrong?



It's designed to load a bunch of typeids, from an list. like A1:A28

And it loads all the information. So I recommend putting it into a separate sheet, and referring to it with vlookups.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Kasli Catal
Deep Core Mining Inc.
Caldari State
#8 - 2014-12-31 00:29:30 UTC
Ah, adding more fixed it, thanks!