Search
OpenOffice.org2GoogleDocs - export & import to Google Docs, Zoho, WebDAV
by Przemyslaw Rumik
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.
2.1.2
Report abuse here
Comments
Export to Google Docs: OpenOffice Crashes
When I try to export to Google Docs, OpenOffice crashes.
I'm using Mac OS X Version 10.6.2
Any help appreciated
Mike Stevens
As far as I know this isn't
As far as I know this isn't problem with extension but with OO.org on MacOS, here more details http://www.openoffice.org/issues/show_bug.cgi?id=92926. Strange is that from this what I know problem is visible only on OS X 10.6.2
Great Little Product - It would be nice if?
Something for the next release if it could handle sub-folders on Zoho Docs. At the moment it only appears to look in the main folder of your Zoho account when downloading/uploading.
Handling documents uploaded to GoogleDocs without conversion?
Hello,
Google Documents now can upload documents without conversion, e.g., complicated spreadsheets in Excel format that do not convert - see http://docs.google.com/support/bin/answer.py?answer=50092. However, for me this extension's (v.2.1.0) "Get list" function only lists the documents that are in GoogleDoc format, others are "invisible". Would it be possible to also list and open the unconverted documents? I am running Debian GNU/Linux "testing" and OO.org 3.1.1.
Thanks.
it depends
It depends when Google Docs List API will support it, for now only supported thing with unconverted documents is uploading such files to Google Apps Premium accounts, rest of users cannot use this feature via API.
If Google will add to API features for uploading and downloading unconverted files it will be added to OOo2GD.
Error: "Could not convert format"
When I try to upload a .doc file, I get this error after a while: "Could not convert format". Anyone knows why??
File is probably too big
I'm guessing that your file is too big to upload to Google Docs, can you try to upload it with Google Docs Upload feature?
I need this file :-)
Can you create new issue here http://code.google.com/p/ooo2gd/issues/list and attach sample file which case this problem? Or can you send me this sample file to my address which you may find here http://www.przemelek.pl/kontakt?
Cannot Upload
Suddenly, when I try to upload (a file I have uploaded many times previousls), the extension hangs and gives the error:
Cannot convert document.
Why does this happen? How can I fist it.
Works with Google for Domain to!
I didn't think this would work with Google Apps for Domains to, but it did. It would be nice if you could choose where to store the login information though. Then you could store it in an encrypted folder.
It works with Google Apps for Domain
I'm using OOo2GD with my 2 accounts in Google Apps for domains in two different domains and it works.
I'm using it with Standard Edition of Google Apps and probably with premium.
String index out of range: -1
Hi,
Ubuntu 9.10, OOO 3.1.1 (OOO310m19, build 9420), java 1.6.0.16.
Menus did not appear when first installing. Remembered an old suggestion and installed twice, both times restarted OOO. Now menus appeared, but when trying to up- or download String index out of range: -1 message is given in alert box, together with another small message somewhere right side of screen Please wait... The normal alert message goes away when clicking but the small Please wait (it is also on a task bar with a Java logo) can be closed only when closing it from taskbar.
Configuration dialog from menu opens normally.
Best regards
Kristjan Adojjaan
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
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?
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.
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.
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
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.
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.
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. "
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
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
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...
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?
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 :-(
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.
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?
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?
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.
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!
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.
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.
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
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.
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.
File must have an extension
Because Google libraries uses extension to recognize type of file, file MUST HAVE extension.
but by default imported file
but by default imported file save without extension
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.
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
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
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.
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.
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.
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.
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)
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
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?
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
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
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 ;-)]