Thursday 5 March 2015

Whack-a-mole with Google Docs and Eve Central

My primary PI spreadsheet ( https://docs.google.com/spreadsheets/d/1lXM8PqU0Tn4EJJ2xRuI7uo55IrZ7MKWJidK9T_bA9L4/edit#gid=0 ) is fixed again.


In my last post about Google Docs, I inadvertently tripped a google doc limitation.




I have added caching to this spreadsheet, and temporarily disabled it in my other spreadsheets.  This should not only resolve my urlfetch issue, but also significantly speed up the loading of the spreadsheet.  It comes at a 'cost' of encouraging the data to be up to 6 hours older.

I will be rolling the changes out to the other spreadsheets soon.

I also found a github code snippet from 'Haggen', also putting together google docs based eve-central calls https://gist.github.com/haggen/461a454b200efe89f3e6

For those interested, I have raised a bug on Fuzzy Steve's github repository, https://github.com/fuzzysteve/eve-googledocs-script/issues/5

3 comments:

  1. do people use excel with the eve central api or only Google docs?
    I know I had more experience with excel and was wary having my work remotely hosted so I preferred to not use Google docs.

    I also recall finding it difficult to find information on how to use the eve central API with excel. Its been a while since I played eve but I'd happily share one of my excel sheets if people want to see how the eve central API can be used.

    ReplyDelete
  2. Anti, I know a corp member uses Excel. I am not sure how he does it. If you want to put your excel document up on a suitable site (drop box, google drive etc), I am happy for you to paste a lnk here

    ReplyDelete
  3. When I went back to one of my sheets it seems to get it to work I wrote a user defined function in excel.
    http://www.wikihow.com/Create-a-User-Defined-Function-in-Microsoft-Excel

    I needed to do this because there was no inbuilt JOIN function.

    to view the join function you need to enable developer mode, open visual basic. it is the only module called module1.

    https://drive.google.com/file/d/0B3CRHgr7lSFGQjk3NGkxLXNpdWM/view?usp=sharing

    i wasnt sure how to let you download the file from googledocs without giving you full edit rights. so if you can make it downloadable by others but not deletable perhaps change the link.

    Anti

    ReplyDelete

Posts older than 14 days are subject to moderation before being published. I do so sporadically. If you have a question regarding older posts, also evemail dotoo foo.

Blogger comments supports basic html. You can make a link 'clicky' by <a href="http://yoursite/yourpage">yoursite/yourpage</a>

While I currently accept anonymous users, please include a pseudonym. I get confused answering anonymous.

If the word verification is preventing you from adding a comment, please evemail DoToo Foo for alternative methods