SMBs

Connect LibreOffice with your Google Docs account by using OOo2gd

If you use LibreOffice and Google Docs, you can merge the two by using the OOo2gd extension. You can also use OOo2gd to import/export to Zoho and export with WebDAV.
Although working in the cloud with Google Docs is an efficient way to manage documents on multiple machines and to collaborate, sometimes you need to work with a document when you're not connected to the cloud or to the network. In those instances, the ability to work with a document on a local drive and then sync it with Google Docs later is handy. You can do just that with the LibreOffice extension OOo2gd, which makes it easy for anyone who has a Google Docs account to export or import a document to and from LibreOffice. (Note: Even though OOo2gd hasn't been worked on since June 2011, the extension still works like a champ.)

With OOo2gd installed, you can:

  • Export to Google Docs
  • Import from Google Docs
  • Export to Zoho
  • Import from Zoho
  • Export with WebDAV

The Ooo2gd extension will run on any platform and requires Java (version 5 or higher) to be installed on the machine. For the purpose of this post, I will use a platform independent take, but for those using Linux, you might need a little help installing Java. I'll illustrate how to install Java on the Ubuntu 12.10 desktop. For the purpose of this post, I will focus on exporting/importing with Google Docs.

Installing Java

  1. Open a terminal window.
  2. Add the repository with the command sudo add-apt-repository ppa:webupd8team/java.
  3. Update apt with the command sudo apt-get update.
  4. Install Java with the command sudo apt-get install oracle-java7-installer.

Installing OOo2gd

With Java installed, you can now use the extension. Let's install that piece with the following steps.

  1. Download the latest version of the OOo2gd extension.
  2. Open LibreOffice.
  3. Go to Tools | Extension Manager and click the Add button (Figure A).
  4. Navigate to where the extension was saved and select the ooo2gd-XXX.oxt file (XXX is the release number) and click Open.
  5. Close the Extension Manager.
  6. Restart LibreOffice.

You are ready to start using the extension.

Figure A

The extension is already installed. (Click the image to enlarge.)

Using OOo2gd

If you click the File menu in LibreOffice, you will see a new menu entry: Google Docs & Zoho. Within that menu, you can choose to Export or Import to or from your Google Docs account. There is also a toolbar associated with this extension. If the toolbar (Figure B) doesn't open with LibreOffice, you can bring it up by clicking View | Toolbars | Add-On 3. Figure B

The toolbar could use a better, more obvious name. (Click the image to enlarge.)

From left to right, the buttons on the Add-On 3 toolbar are:

  • Export to Google Docs
  • Import from Google Docs
  • Export to Zoho
  • Import from Zoho
  • Export with WebDAV

Exporting to Google Docs

In order to export a document to your Google Docs account, you must first save the document on your local drive. Once that is complete, you can export the file by following these steps.

  1. Go to File | Google Docs & Zoho | Export to Google Docs (or click the Export button on the toolbar).
  2. Fill out the authentication information for your Google Docs account (Figure C).
  3. Change the file name if necessary.
  4. Select Auto-update if you want the file to automatically update (a persistent connection is required).
  5. Select Convert To Google Docs Format if necessary.
  6. Click OK.

The document should immediately sync with your Google Docs account.

Figure C

If you have OOo2gd remember your password, that password will be stored on your local device. (Click the image to enlarge.)

Importing from Google Docs

This process is not so much syncing your Google Docs but gaining access to the files you have saved on Google Docs. Before you do this, you should configure where the extension downloads files. I suggest creating a GDOCS folder within your ~/Documents directory and set the download folder to that. To configure this, go to File | Google Docs & Zoho | Configure. In the configuration window, click the Browse button associated with Downloaded Files Saved To and navigate to where you want to save the Google Docs files.

To Export files, follow these steps:

  1. Go to File | Google Docs & Zoho | Import From Google Docs.
  2. Enter your Google Docs credentials (Figure D).
  3. Click Get List.
  4. Select the file you want to open from the list.
  5. Click either Open or Download.
Figure D

It is also possible to open the file from within a web browser. (Click the image to enlarge.)

You now have the ability to export and import to and from your Google Docs account from within LibreOffice. Give this handy little extension a try and see if it doesn't work to help make LibreOffice work within the cloud.

About

Jack Wallen is an award-winning writer for TechRepublic and Linux.com. He’s an avid promoter of open source and the voice of The Android Expert. For more news about Jack Wallen, visit his website getjackd.net.

5 comments
bestbenwade
bestbenwade

Hi all,


I realize that this is NOT an answer forum, and I'm NOT looking for an answer - although I wouldn't mind finding one ;-). I'm just letting others know about the problem I'm having. When I try to install OOo2gd (including earlier versions - I tried several earlier versions too, in case it was a version specific problem) I get "java.lang.reflect.InvocationTargetException" during install, and of course the app doesn't work. Java runtime is installed and enabled. Sounds like a great idea though!

Java 7

LibreOffice 4.1.4.2

OOo2gd (various versions)

james.knott
james.knott

Curious, it works with both LibraOffice and OpenOffice on Windows, but only LibreOffice on Linux. With OO on Linux, when attempting to connect to Google Docs, it throws up an "Problem: Could not initialize NSS" error. Java is installed and enabled everywhere.

aflynnhpg
aflynnhpg

After installing Java make sure you configure LibreOffice to use the JRE under Tools>Options>Java. Also on Ubuntu/Mint make sure you install libreoffice-java-common or you will get a java.lang error.

hometoy
hometoy

This is definitely not as seamless or smooth as Microsoft Office and SkyDrive (both program and the web interface) but does provide a means to open the Google documents in a local, non-browser application. I think it would be so much better if this were incorporated into Google Drive's synchronization client, and not be limited to just Libre-/OpenOffice. Then that would give Microsoft's Office/SkyDrive a run for the money!