grive sync error, possibly google API shift

Question

I have a table where I enter the qualification times manually Name and Timer. It calulates the Final Time automatically, but I want it to sort the Final Time and Name in the right side from the fastest to the slowest, as in the second image. I tried using VLOOKUP and INDEX, but didn't manage to get it. I need help finding the right formulas to Cells I$ and J$. I hope to get a answer from here.

Hope to get it like following:

Solution 1

Yes, Grive is using the defunct Documents List API. As of around 9AM PST we stopped serving these API requests. This is why the Grive client is receiving '400 Bad Request' responses.

Looking at the project, it appears to be unmaintained for almost a year and definitely hasn't been updated (here & here) to the new API that was released in 2012 when Documents List was officially deprecated.

Solution 2

A good alternative might be drive which is written in go and has quite a lot features.

To install follow these instructions:

1. Install needed packages

   sudo apt-get install golang git mercurial
   

2. Create a path for go packages in your home directory

   mkdir $HOME/go $HOME/go/bin
   

3. Add these paths to the appropriate environment variables by editing the file .profile in your home directory. So add these lines at the and of that file:

   if [ -d "$HOME/go" ] ; then
       export GOPATH="$HOME/go"
   fi
   
   if [ -d "$HOME/go/bin" ] ; then
       PATH="$HOME/go/bin:$PATH"
   fi
   

4. Log off and log on to let the changes take effect.

5. Download and install drive from latest source

   go get -u github.com/odeke-em/drive/cmd/drive
   

6. Read https://github.com/odeke-em/drive/#usage

   Basic usage:

   • drive init <folder> initializes <folder> for syncing with your Google Drive.
   • If yo do drive pull in your initialized folder, it will download all changes from Google Drive. At the first time maybe you have to do this more times to download everything.
   • drive push uploads local changes.
   • drive pull <fileOrPath> or drive push <fileOrPath> does the corresponding action only for <fileOrPath>.
   • There are many more options to use, so read the manual.

Solution 3

A fork of grive has been made that works again (not by me, just found it)

https://github.com/vitalif/grive2

Easy replacement

mkdir grive 
cd grive/
git clone https://github.com/vitalif/grive2.git
cd grive2/
mkdir build 
cd build 
cmake ..
make -j4
sudo make install

Now grive works fine for me.

Solution 4

A solution similar to grive is jdrivesync. You can download a copy on its github page.

To run jdrivesync follow these steps:

1. Install Java
2. Download jdrivesync
3. Run it with java -jar jdrivesync-0.2.2-jar-with-dependencies.jar -l "/home/directory-to-sync"

Solution 5

Ubuntu 14.04 grive package has just upgraded to Grive2 version 0.4.0-1. I had the same problem as you before the upgrade but I tried syncing this morning with the upgrade and it works.

For instructions on how to easily install grive2 0.4.0-1 in Ubuntu 14.04 and grive2 in all other currently supported versions of Ubuntu see this answer. It should be noted that the command sudo apt-get install grive in the linked answer is correct because after adding the PPA it will indeed install grive2 that works instead of the old not upgraded version of grive that doesn't work anymore.

View more solutions

Comments

[LeoAnth]

Any suggestions for how to get Google Drive syncing with Ubuntu 14.04 now that grive is out of the picture? I have found 2 alternatives, Insync and jdrivesync but insync is paid, and jdrivesync looks to be heavily in beta. Did I miss any others?

[Dan McGrath]

Perhaps Insync? insynchq.com/downloads

[Wilf]

It might just be possible to use the official windowz client under wine (though it is annoying enough under windows)

[LeoAnth]

I am giving the Insync client a go, and it is working perfectly and although it is paid, it is a one time payment and very reasonable.

[KGIII]

A link can, and probably will, expire over time. If you could explain why the link is important and what the pertinent information is then it may, indeed, make for a quality answer.

[Koppis]

Thanks. If someone else finds this too, remember to check (probably because location?) formulas are used. For me I have to use a semicolon rather than a comma in the functions.