Ce document en français.
The use of this software subjects you to our Terms Of Use and Data Protection Policy.
dDriveOOo is part of a Suite of LibreOffice and/or OpenOffice extensions allowing to offer you innovative services in these office suites.
This extension allows you to work in LibreOffice on your Dropbox files, even while offline.
It uses Dropbox API to synchronize your remote Dropbox files with the help of a local HsqlDB 2.7.2 database.
This extension is seen by LibreOffice as a Content Provider responding to the URL: vnd-dropbox://*
.
Being free software I encourage you:
In short, to participate in the development of this extension. Because it is together that we can make Free Software smarter.
The dDriveOOo extension uses the OAuth2OOo extension to work.
It must therefore meet the requirement of the OAuth2OOo extension.
The dDriveOOo extension uses the jdbcDriverOOo extension to work.
It must therefore meet the requirement of the jdbcDriverOOo extension.
Additionally, dDriveOOo requires the jdbcDriverOOo extension to be configured to provide com.sun.star.sdb
as the API level, which is the default configuration.
It seems important that the file was not renamed when it was downloaded.
If necessary, rename it before installing it.
Install OAuth2OOo.oxt extension
You must first install this extension, if it is not already installed.
Install jdbcDriverOOo.oxt extension
You must install this extension, if it is not already installed.
Install dDriveOOo.oxt extension
Restart LibreOffice after installation.
Be careful, restarting LibreOffice may not be enough.
soffice
and using the key combination Ctrl + C
if after stopping LibreOffice, the terminal is not active (no command prompt).Open your Dropbox files:
In File -> Open enter in the first drop-down list:
or
And validate not by the Open button but by the Enter key.
If you don’t give your_email@your_provider, you will be asked for…
Anonymous Urls allow you to remain anonymous (your account does not appear in the Url) while named Urls allow you to access several accounts simultaneously.
After authorizing the OAuth2OOo application to access your Dropbox files, your Dropbox files should appear!!! normally
In order to be able to keep using system dialog windows for opening and saving files in LibreOffice, it is now possible to create custom menus for the commands: Open Remote and Save Remote.
In the Menu tab of the Tools -> Customize window, select Macros in Category to access the two macros: OpenRemote
and SaveRemote
under: My Macros -> dDriveOOo.
You will first need to add the OpenRemote
macro to one of the menus with the Scope set to LibreOffice, then you will need to open the applications (Writer, Calc, Draw…) possibly using a new document, and add the OpenRemote
and SaveRemote
macros with the Scope set to the application you want to add the menus to.
The OpenRemote
macro supports any type of Scope, while the SaveRemote
macro should only be assigned to application-type scopes because it requires a document to already be open in LibreOffice.
This only needs to be done once for LibreOffice and each application, and unfortunately I haven’t found anything simpler yet.
Normally, the extension is created with Eclipse for Java and LOEclipse. To work around Eclipse, I modified LOEclipse to allow the extension to be created with Apache Ant.
To create the dDriveOOo extension with the help of Apache Ant, you need to:
source/dDriveOOo/
build.properties
so that the office.install.dir
and sdk.dir
properties point to the folders where LibreOffice and its SDK were installed, respectively.ant
dist/
LibreOffice 7.3.7.2 - Lubuntu 22.04 - Python version 3.10.12
LibreOffice 7.5.4.2(x86) - Windows 10 - Python version 3.8.16 (under Lubuntu 22.04 / VirtualBox 6.1.38)
LibreOffice 7.4.3.2(x64) - Windows 10(x64) - Python version 3.8.15 (under Lubuntu 22.04 / VirtualBox 6.1.38)
LibreOffice 24.8.0.3 (x86_64) - Windows 10(x64) - Python version 3.9.19 (under Lubuntu 22.04 / VirtualBox 6.1.38)
Does not work with OpenOffice see bug 128569. Having no solution, I encourage you to install LibreOffice.
I encourage you in case of problem
to create an issue
I will try to solve it
Integration and use of the new Hsqldb v2.5.1 system versioning.
Writing of a new Replicator interface, launched in the background (python Thread) responsible for:
Perform the necessary procedures when creating a new user (initial Pull).
Carry out pulls regularly (every ten minutes) in order to synchronize any external changes (Pull all changes).
Replicate on demand all changes to the hsqldb 2.5.1 database using system versioning (Push all changes).
Writing of a new DataBase interface, responsible for making all calls to the database.
Setting up a cache on the Identifiers, see method: _getUser(), allowing access to a Content (file or folder) without access to the database for subsequent calls.
Management of duplicate file/folder names by SQL Views: Child, Twin, Uri, and Title generating unique names if duplicates names exist.
Although this functionality is only needed for gDriveOOo, it is implemented globally…
Many other fix…
Using new scheme: vnd-dropbox:// as claimed by draft-king-vnd-urlscheme-03.txt
Creation of a Provider able to respond to the two types of Urls supported (named and anonymous).
Regular expressions (regex), declared in the UCB configuration file, are now used by OpenOffice/LibreOffice to send URLs to the appropriate ContentProvider.
Use of the new UNO struct DateTimeWithTimezone provided by the extension jdbcDriverOOo since its version 0.0.4.
Although this struct already exists in LibreOffice, its creation was necessary in order to remain compatible with OpenOffice (see Enhancement Request 128560).
The presence or absence of a trailing slash in the Url is now supported.
Implementation of the management of shared files.
The name of the shared folder can be defined before any connection in: Tools -> Options -> Internet -> dDriveOOo -> Handle shared documents in folder:
Many other fix…
The absence or obsolescence of the OAuth2OOo and/or jdbcDriverOOo extensions necessary for the proper functioning of dDriveOOo now displays an error message.
Many other things…
pip install requirements.txt
https://prrvchr.github.io/OAuth2OOo/source/OAuth2OOo/registration/OAuth2Redirect
) is now used.files.content.read
scope to OAuth2 rights required by Dropbox API to allow file uploads.rdb
file format produced by the unoidl-write
compilation utility. idl
files have been updated to support both available compilation tools: idlc and unoidl-write.com.sun.star.sdb
as API level.OpenRemote
and SaveRemote
to create custom menus and be able to keep the system dialog window for opening and saving files in LibreOffice. To make it easier to create these custom menus, the section How to customize LibreOffice menus has been added to the documentation.Add new language for internationalization…
Anything welcome…