OpenOffice.org2GoogleDocs - export & import to Google Docs, Zoho, WebDAV


	OpenOffice.org2GoogleDocs - export & import to Google Docs, Zoho, WebDAV by Przemyslaw Rumik (26 votes) Export, Update and Import your documents to and from Google Docs, Zoho and WebDAV servers. With OOo2GD you may export to Google Docs, Zoho and WebDAV servers: * Documents: ODT, SXW, DOC, RTF without modification, other known to OO.org after conversion to ODT * Spreadsheets: ODS, XLS, CSV without modification, other known to OO.org after conversion to ODS * Presentations: PPT, PPS without modification, other known to OO.org after conversion to PPT For Google Docs you may export, update and import all your documents, spreadsheets and presentations, for Zoho you may export documents, spreadsheets and presentations, and import documents and spreadsheets, to WebDAV you may export what you are able to open in OO.org :-) Needs Java 5+ to work. Project Page Operating System: System Independent Official release: 1.8.2 Date: 2009-Oct-25 Size: 2.12 MB View all releases License: opensource \| Read license Source code: Browse source code Further product information: Screenshots \| Product details Provider: Przemyslaw Rumik Report abuse here 186120 downloads initiated 843 downloads this week

Comments

Thu, 10/01/2009 - 19:06 — gcorbin_51

Using Zoho with Yahoo Login

I log into Zoho using the Yahoo account option.
Is there a way to get this to work with this extension?
Thanks

Tue, 10/27/2009 - 08:37 — riyanjason

OpenOffice is already a complete desktop office suite that is at par in terms of features with the proprietary Microsoft Office. However, its functionality can still be improved by utilizing useful extensions that are easily available.

Like in Firefox, OpenOffice will let you install or remove extensions without difficulty with the use of an Extension Manager.

Now if you are ready to try out some handy OpenOffice extensions, here are those that I highly recommend:

1. Writer's Tools
This is definitely one of my favorite extensions. Fully loaded with useful utilities, Writer's Tools is truly a must-have for professional and even for non-professional writers. Some of its impressive features are:Multi-format Backup tool for cheap web hosting that saves the currently opened Writer document in the Word, RTF, and TXT formats.

* Email Backup tool can be used to quickly send a backup copy of the currently opened document to a specified email address.

* Lookup Tool lets you look up the currently selected word in several online references, including Cambridge Dictionaries, WordNet, and Google Define.

* Post to Microblog tool can be used to send messages to the Identi.ca and Twitter microblogging services.

Fri, 10/02/2009 - 10:00 — przemelek

It works with Zoho

I tested it moment ago and it works. I used my Zoho account and was able to download files.
Can you be more descriptive? ;-) Maybe you can go to http://code.google.com/p/ooo2gd/issues/list and create Issue?

Fri, 09/25/2009 - 08:21 — adojaan

1.7.2 no menu, no toolbar in OO 3.1.1 under Ubuntu

Haven't used for a while. Now tried again: 1.4.2 gave "problem: null" while trying to upload and empty error while trying to get list from gDocs.

Therefore I tried to install 1.7.2. Installation went without errors but menu and toolbar did not appear. Tried to install twice, remove and install, disable and enable, restart OO, etc. Nothing helped. I use OO 3.1.1 (OOO310m19, build 9420). Xubuntu 9.04.

I tried to install earlier versions, too, but 170 and 171 does not appear either. 160 appears in menu and toolbar, but the errors are the same as with 1.4.2 I mentioned above.

Fri, 08/14/2009 - 14:15 — drashok

solved + general query

Dear Przemyslaw,
I reinstalled google doc extension and it is working seamlessly.
Thanks.
Dr. Ashok Koparday
PS
I do not know if this is the right place, I wish to know where I can find extension that does
'summary' the way it is done Microsoft Office.

Fri, 08/14/2009 - 12:53 — drashok

upload error: no object DCH for MIME type application/atom+xm

Dear Przemyslaw,

An extremely satisfactory extension after updating to Open Office 3.1
fails in uploading. The message is:

message
Problem: no object DCH for MIME type application/atom+xml

Kindly let me know how I rectify this.

Regards,
Dr. Ashok Koparday

Fri, 05/29/2009 - 12:05 — luigi.massa

Bug - Ubuntu 9.05 (Jaunty) - Open Office 3.0.1

Hi,
when I install extension, I view this error messages:
(com......CannotRegisterImplementationException){ { Message = '', Context = (com.sun.star.uno.XInterface) @0 } }

I use Java stantard (not open), release1.6.0_13

Thanks
Luigi.

Thu, 08/13/2009 - 07:12 — carlops

Exact same issue

Exact same issue here, both with OpenJRE and with Sun JRE.

Using OOo 3.1 from MEPIS repos. Will try if it also occurs with official OOo debs, but that means I would lose my KDE integration.

Thu, 08/13/2009 - 12:37 — przemelek

Try this

http://code.google.com/p/ooo2gd/wiki/KnownIssues and issue #6
"Install the package which named "openoffice.org" from the repo, then OOo2gd will be installed properly. "

Fri, 04/03/2009 - 19:10 — dnns

Upload problem

I installed Openoffice 3.0.1 on my windows xp and am using Java 6 update 13. I can download files from google docs, but always get "bad request" while attempting to upload any files. Any idea what I did wrong? Here is the error log:

com.google.gdata.util.InvalidEntryException: Bad Request

Mon, 03/09/2009 - 16:45 — thedp

Installation issues on Leopard, OOO 3.1

Every time I try to install this extension I get a load of error codes of which I think "Unsupported class version error" is the most meaningful.

Can anybody help me?

TheDP

Thu, 10/08/2009 - 09:26 — martinhardy

My problem get resloved.

I was facing same problem but it get fixed: What i just installed the package "openoffice.org", after that i just installed OOo2gd; it is installed properly and working fine with me; there is a mere change of your operating system compatibility, as one of my friend working for a cheap web hosting provider was sharing the same issue with me, but after re-installation of operating system, this issue get fixed, do try to give it a shot it may for your as well. OOo2gd is pretty much helpful and time saving tool.

Tue, 03/10/2009 - 00:40 — przemelek

OOo2GD needs Java 6

On Mac OS OO.org is 32 bit application, Java 6 is 64 bit application. Because of this OO.org uses Java 5 to run extensions... and Java 5 doesn't understand Java 6 classes and produces "Unsupported class version error".
2 hours ago I created test version [still not published, but send only to some testers] of OOo2GD in Java 5, and it works [with some problems] on Mac OS. More details and screens available on one of my blogs http://eng-przemelek.blogspot.com/2009/03/openofficeorg2googledocs-and-a...

Fri, 01/16/2009 - 07:57 — adojaan

Does not appear in menu

Hi, tried to install current version for OO 3.0.1 (OOO30m14 build 9376) having Java 1.6.0_10 (Ubuntu 8.10) but the shortcuts do not appear in menu. Any ideas?

Sat, 01/17/2009 - 20:00 — przemelek

Try again

I assume that you restarted OO.org.
Sometimes under Linux you may need to install extension twice. I don't know why, but sometimes first installation doesn't work :-(

Wed, 02/25/2009 - 15:55 — LudoA

no menu

I have the same problem. I followed your instructions and installed it again, OO asked me if I wanted to replace the current version, I said yes, restarted OO and it didn't work.

Then I removed the extension, restarted OO, installed the extension again, restarted OO, and the menus still don't appear. This is with OO 3.0.1 on Windows, latest oo2gdocs extension.

Wed, 02/25/2009 - 15:58 — LudoA

menu / toolbar

Never mind, apparently there's no menu anymore. I was looking for the old menu, but it seems like there's only a toolbar now, that's why I missed it.
Or is there supposed to be a menu anyway?

Wed, 02/25/2009 - 16:13 — LudoA

no menu

Ok I feel like I'm spamming this comment thread now...

Anyway, I just read the "known issues" (http://code.google.com/p/ooo2gd/wiki/KnownIssues), where it says that:
"After installation of version 0.5+ of AddOn on some non-Windows systems it is possible that "Google Docs" menu isn't visible. To resolve this problem please open Extensions Manager (Menu Tools -> Extension Manger) and Disable and after this Enable AddOn. Next restart OpenOffice.org. Everything should works well."

So apparently there should still be a menu. I disabled/enabled it & restarted, but that didn't help either. Also, the issue says it's for "non-Windows systems", but I'm using XP.

What can I do?

Wed, 02/25/2009 - 16:27 — przemelek

Which Menu?

You are talking about File -> Google Docs & Zoho menu?
It should be visible, only system where I had problems with this menu was Linux, on Windows and Solaris it worked.
If I will find some OO.org in version 3.01 I will check it on Windows :-) As I remember I tested it on 3.0 on Solaris.

Mon, 01/26/2009 - 12:06 — adojaan

it helped

Hi, I installed it again, actually, now I installed version 1.4.2 and it appeared in my Ubuntu OOO3 after restarting ooo. Thanks!

Mon, 01/12/2009 - 06:35 — grokinn

save folder by default

i have windowsxp sp2 and openoffice org 2.3
then I import document from google dosc and change it in openoffice, by default this document save in temporary directory with too long address (i.e. D:\Documents and Settings\mylongname\Local Settings\Temp) and if I try export this changed documet to google docs I get error "String index out of range: -25" because address location of document too long. If I save this documen in another location (i.e. D:\) it export perfectly.

Mon, 01/12/2009 - 09:16 — przemelek

Probably old version

I know that this bug existed, but it was long time ago. Version 1.4.1. should be free from this bug.

Mon, 01/12/2009 - 11:25 — grokinn

hmm... I use exactly version

hmm... I use exactly version 1.4.1 that I downloaded today from http://ooo2gd.googlecode.com/files/gdocs-1.4.1.oxt

Sat, 01/17/2009 - 19:58 — przemelek

Cannot reproduce

I tried to reproduce this problem with file C:\Documents and Settings\rmkverylongnameoffolder_i_hope_it_will_help_to_make_problem_rmkverylongnameoffolder_i_hope_it_will_help_to_make_problem_rmkverylongnameoffolder_i_hope_it_will_help_to_make_problem\Local Settings\Temp\CV - EN.odt and I was able to upload this file.
May you share with more details?
I'm interested in name of file, and if it is possible with full path to this file.

Sun, 01/18/2009 - 11:58 — grokinn

i tried reproduce this

i tried reproduce this problem on windows vista sp1+OOo 3.0.0 and get another error: "Problem: no enum const class com.google.gdate.date.docs.DocumentList.Entry$MediaType.testfilename" This file on C:\Users\grokinn\AppData\Local\Temp but it's name testfilename without ".odt", if I save as "testfilename.odt" on C:\Users\grokinn\AppData\Local\Temp this file upload normally.

I will try reproduce this on my windows xp and OOo 2.4 tomorrow.

Sun, 01/18/2009 - 12:01 — przemelek

File must have an extension

Because Google libraries uses extension to recognize type of file, file MUST HAVE extension.

Sun, 01/18/2009 - 12:30 — grokinn

but by default imported file

but by default imported file save without extension

Sun, 01/18/2009 - 12:37 — przemelek

It depends ;-)

Probably because of this that most of my files in Google Docs was created by OOo2GD most of them had proper extensions, but you are right that OOo2GD may makes problems when it download files without extensions.
I think I will add option to add file extensions during download.

Mon, 01/12/2009 - 11:53 — przemelek

Strange

I will look on it again and try to reproduce this problem.
In the future I will prefer reporting of problems here: http://code.google.com/p/ooo2gd/issues/list

Sat, 10/25/2008 - 15:10 — andresmh

Fails on OO3 on Ubuntu 8.10

Nothing happens when going to File > Google Docs & Zoho > Configuration
or any other menu of Google Docs & Zoho

When I go to Tools > Options > OpenOffice.org > Java
Version 1.6.0_10 of is selected

I have OpenOffice 3.0.0
1:3.0.0-2ubuntu1 (/var/lib/apt/lists/ppa.launchpad.net_openoffice-pkgs_ubuntu_dists_intrepid_main_binary-i386_Packages)
Description File: /var/lib/apt/lists/ppa.launchpad.net_openoffice-pkgs_ubuntu_dists_intrepid_main_binary-i386_Packages

Mon, 10/20/2008 - 14:57 — alfonsator

Preferences not shown in Mac OS X 10.5 Leopard

Hi,
I'm trying to use gdocs 1.2.3 with OO 3.0.0 on Mac OS X 10.5 Leopard with Java SE 1.6.0_07 (Intel). When you go to "Archive -> Google docs & Zoho -> Configuration", nothing happens. None of the buttons in the toolbar seems to work neither. Any idea?

Thanks.

Mon, 10/20/2008 - 15:11 — przemelek

Did OOo 3.0 use Java 6?

In OpenOffice.org go to Tools -> Options -> Java and check if it points on this Java SE 1.6.0_07.

Wed, 10/22/2008 - 07:57 — sarbogast

Same issue here... even with Java 6

I had the same issue here, so I added Java 6 as a Java environment, restarted OpenOffice and it doesn't work either.

Wed, 10/22/2008 - 13:39 — przemelek

It looks that Apple Java isn't identical with Sun Java

I don't have Mac, I don't want to have one, so till somebody don't find where is a problem I cannot help.

Thu, 10/30/2008 - 09:43 — hrabeX

JAVA's debug in console

JAVA's debug in console says:
30.10.08 10:37:45 [0x0-0x94094].org.openoffice.script[1531] Exception in thread "Thread-101" java.lang.NoClassDefFoundError: javax/swing/GroupLayout$Group
30.10.08 10:37:45 [0x0-0x94094].org.openoffice.script[1531] at org.openoffice.gdocs.GDocs$1.run(GDocs.java:181)
30.10.08 10:37:45 [0x0-0x94094].org.openoffice.script[1531] at java.lang.Thread.run(Thread.java:613)
30.10.08 10:38:31 [0x0-0x94094].org.openoffice.script[1531] Exception in thread "Thread-103" java.lang.NoClassDefFoundError: java/util/ResourceBundle$Control
30.10.08 10:38:31 [0x0-0x94094].org.openoffice.script[1531] at org.openoffice.gdocs.GDocs$2.run(GDocs.java:225)

Thu, 10/30/2008 - 09:57 — przemelek

You don't use Java 6.

It looks that your Java cannot find some basic classes [those which should be shipped with Java], and from this what I can see it looks that those are classes added to Java 6.0.
My diagnosis is: your OpenOffice.org doesn't use Java 6.
Please change used Java to Java 6. Please use #3 from http://code.google.com/p/ooo2gd/wiki/KnownIssues

Wed, 12/10/2008 - 15:39 — dfaulkner

Think I'm using Java 6, still doesn't work

I've read the wiki page, and I've selected Java 1.6, but still nothing works.

I've installed the Java for MacOS 10.5 Update 1

In OOo's Java options, I can see JRE 1.6.0_07 available. I've selected it. Still nothing works.

What am I missing?

Mon, 11/03/2008 - 22:06 — mvreijn

Two questions about this

Hi guys.

This is one great idea for an extension. Does not work for me yet, I have OOo 3 on Linux, with jre 1.6.0_b7.
I have two questions in order to troubleshoot further:

- I have two JVMs in my openoffice, 1.5 and 1.6, with the 1.6 release selected. Should I have only one?
- I see people mentioning the debug console, how do I get to that?

Thanks a lot,

Mark

Sat, 09/13/2008 - 11:12 — aolinto

Upload but not download ODS/XLS from GoogleDocs

Hi,

I'm using Oo 2.4.1, with Java (JRE) 1.0.6_06, running on Ubuntu 8.04.
I can upload and download text documents (odt) to/from GoogleDocs but I can only upload spreadsheets documents (ods).
Both text and spreadsheets docs are listed in "Document Title" but for ods and xls files "Open" and "Open Via Browser" buttons are disabled.
Also, I uploaded a spreadsheet but when I opened it on browser (Firefox 3.0.1) I saw that the graphics (plots) were lost.
Am I doing something wrong? Thanks for any help. All the best.

Antonio

Sat, 09/13/2008 - 11:48 — przemelek

It's normal

Downloading spreadsheets from Google Docs isn't supported by Google Docs [they also don't support downloading of documents and presentations, but it's possible to workaround this problem], and because of this AddOn cannot do it [technically to download spreadsheets AddOn would need to pretend browser what may break Google Terms Of Service, so I decided don't try it.]
Google Docs and Zoho may do some harmful things to stored documents. They need to convert documents from it's original format to some theirs format, and again during export to client they need to make conversion from theirs inside format to requested format. It looks that some parts of documents may be lost in this process.
Documents stored on WebDAV servers are always identical as those send to server [assuming no one changed them in the meantime ;-)]

Sun, 09/14/2008 - 04:19 — aolinto

Thanks Przemyslaw

Thanks Przemyslaw for your explanation and congratulations for you work.

Best regards,

Antônio

Sun, 09/07/2008 - 20:28 — fixerdave

Ubuntu on PPC can't run Sun-jre6? Am I right? Any workarounds?

I'm really keen on this extension but I can't get it to load. I think I've tracked it down to it requiring Sun's jre6, which I don't have installed. I tried installing that, but there's no bin for my PPC processor. Am I right on this conclusion or am I wandering down the wrong path?

Yes, I know that I'm in an obscure group, running Ubuntu Linux on an old Mac Mini, but this is the first thing I've found that won't work because of it. Well, it won't do flash either, but I really don't care about that.

Any ideas for a work-around or a redirection to the right path would be appreciated.

David...

Wed, 09/10/2008 - 03:12 — jamesstansell

Java for Ubuntu PPC

Hi Dave,

Have you checked out openjdk6-jre? I'm not sure if it's available for ppc, but if not for 8.04 then it might be for 8.10.

These sites have links to more technical information, if you are so inclined:

http://openjdk.java.net/

http://icedtea.classpath.org/wiki/Main_Page

Does your Mini have enough resources to run an x86 emulator, such as Qemu? That might be another alternative.

Regards,

-james.

Sun, 09/07/2008 - 19:39 — embeal

Configuration trouble

Configuration option will not launch on my MacBook Pro running m5 (RC 1).

Sat, 09/06/2008 - 03:31 — rileydog

links to developer site about webdav

Hi,
i was looking around and saw this:
http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Appendix...

might help you solve the issue.

Thanks,
Wayne Glover

Wed, 09/03/2008 - 00:18 — rileydog

webDAV Issues

First, thanks for adding webDAV. You may remember that I was the requested the addition. It's been helpful to me.

1) just a reminder to anyone using this that webDAV can't work with spaces in the file name. webDAV uses HTTP commands (PUT, in this case) and spaces are not allowed. I tried this and the file was never uploaded. Looking at the error log on my server helped me learn this.

2) even when the files not uploaded (for example, item (1) ), you still get the 'file upload' success box. not sure why.

any comments would be appreciated.

Wayne Glover

Wed, 09/03/2008 - 09:05 — przemelek

Will be fixed ;-)

1) true
2) true - and I still don't know why

I hope I will fix it next version.

Fri, 09/05/2008 - 20:02 — rileydog

Can external configurations be used by your prograam

Hi, i have an external XML file that has information that duplicates some of the configuration needed for webdav. specifically, full URL, username and password.

On startup of webdav function, would your program be able to bring in this xml file, read it (knowing of course the element names it was looking for). and use this data.

the reason i want this is i only want config data in one location. i want to avoid errors.

i know this would not be an easy change and i would look to hire a programmer to make it happen. i thought you'd be the best person to know if it can be done.

thanks
Wayne Glover

Tue, 09/02/2008 - 16:37 — mcsmith68

can't get it to work.

i problem error when trying to upload to google and zoho says successful, but then can't find it in account. Any suggestions of what to do differently.

thanks,

Thu, 06/12/2008 - 18:26 — rjs

problem on OS X 10.5.3

I have installed beta 3 on a Leopard 10.5.3 system, with the latest version of the extension. I am using the Apple java 1.5.0_13. I have enable/disabled the extension, can see it but if I hit configure (or anything else), nothing happens, I don't get a dialog box for google.

Extensions

Tags

Documentation

Comments