Dropbox Odoo Integration v.17
The tool to automatically synchronize Odoo attachments with DropBox files in both ways
This is the tool to integrate Dropbox features with Odoo folders and files. The app automatically stores Odoo attachments and directories in Dropbox and provides instant access to them via web links.
Automatic folders' structure
Decide which Odoo document types should have their own folders trees and synchronize those to Dropbox
Automatic regular sync
Rely on auto-synchronization between Odoo and Dropbox based on scheduled jobs. No manual interaction is required
Bilateral sync
Odoo sends attachments to Dropbox and retrieves files from there. Binary content is kept in clouds, while Odoo provides direct access to synced items
Cloud synchronization history
Control Dropbox sync logs right in Odoo. Export and share those in case of any issues. Be notified of any client disconnections
File manager interface
Manage synced folders and attachments from a single Odoo view. Comfortably navigate by directories. Search and download files one by one or in batch. Upload and move attachments to folders
Attachment box
Organize files of any Odoo object in a set of subfolders. Instantly access folders and files in the attachment box and in Dropbox.
How synchronization works
Automatic two-sided sync
-
Configure sync for one or multiple Dropbox instances
-
Integration is based on scheduled jobs and is fully automatized. The app regularly checks changes in systems and runs sync operations
-
Synchronization is bilateral. Updates in Odoo are reflected in Dropbox (direct sync); changes in Dropbox modify Odoo folders and attachments (backward sync)
-
Cloud connection with Dropbox might be reset. In this way, the app assumes getting back all items back to Odoo (reverse sync)
-
Odoo folders and attachments might be re-attached to a new cloud client from Dropbox. Hence, items will be first taken back to Odoo (reverse sync) and then put will be put into the new cloud storage (direct sync)
Queue-based synchronization
-
Once in 15 minutes, the app examines updates in Odoo and Dropbox to prepare a synchronization queue
-
Folders' checks follow the First-In-First-Out (FIFO) principle. So, directories that have not been examined for the longest will be processed first
-
Once in 15 minutes, the sync queue is run by the special scheduled job. Firstly, the most important (blocking) tasks would be done
-
Control planned jobs and their fulfillment in the special Odoo logs interface (Cloud Storage > Configuration > Sync Logs). Subscribe for particular cloud clients notifications
-
If the app faces sync failures, it will re-try operations afterward. Sync queue processing would not be stopped if there are items not blocked by such failures
Odoo attachments for Dropbox: direct sync
-
Direct sync prepares the folders' hierarchy and uploads Odoo attachments for Dropbox
-
Direct sync checks whether attachments are added or deleted for synced directories. If so, they would be created or removed in Dropbox. In particular, it means that any file added to a folder-related Odoo object (e.g. Quotation), would be automatically moved to a linked cloud client
-
Direct sync makes all synced Odoo attachments change their type to a link (URL), while binary content is removed with one of the next Odoo cleaners. So, no actual files would be stored on your Odoo server
-
Direct sync checks whether a new folder is added. Disregarding whether it is done manually or automatically, the app would generate a peer directory in Dropbox
-
Direct sync checks whether there are any updates in folders. If so, such changes are reflected in Dropbox
Dropbox files and folders for Odoo: backward sync
-
Backward sync checks whether any files or subfolders are added to Dropbox folders. If so, the app would create URL attachments/subdirectories inside linked Odoo directories (and hence Odoo objects if any)
-
Backward sync checks whether there are any updates in folders or attachments. Such updates would be then reflected in Odoo
-
Backward sync checks whether any files are deleted/moved in a Dropbox document folder. If so, a linked Odoo attachment would be also unlinked or moved
-
If you deleted a Dropbox folder related to a folder rule / Odoo object, their child files would be deleted as well. Thus, Odoo would remove related attachments. The folders, however, will be recovered with a direct sync
-
In case of conflicts, direct sync changes are in general considered more important than backward updates.
Resetting or changing Dropbox: reverse sync
-
In case you decided to reset the connection with Dropbox, files would be moved back to Odoo
-
In case you decided to change the cloud client of a folder rule or a folder, files would be first taken back to Odoo, and then direct sync for a new client would be done
-
Reverse sync operations are prioritized to direct and backward sync operations
-
Not all items can be correctly reversed to Odoo due to cloud client peculiarities. For example, there are documents that may exist only in cloud storage environments. The app would try to convert such documents, but in some cases, it would require manual interactions.
Dropbox URLs
Dropbox has a specific way to generate links for existing files and folders. In particular, there are no concepts of internal or private URLs. Instead, each Dropbox item might get so-called shared URLs. Such shared links are either public or team-only. Moreover, the latter feature is available only for the Dropbox business account.
This tool relies upon shared links' mechanics. It means, that each attachment link is either public (all personal Dropbox accounts) or team-only (all business Dropbox accounts).
Sometimes it is considered to be not fully safe. Although website URLs will be hardly known by external users, there is a slight chance that they become available as a result of some user actions. Besides, sharing link generation is not super fast and might make the sync process slower. That is why the feature to switch off sharing URLs is introduced.
If checked, all Dropbox URLs in Odoo will be of the type https://www.dropbox.com/home/Odoo/[PATH]. Such links will not work in many cases. Thus, if you need to open Dropbox files/folders from Odoo, be careful with the setting 'No links to Dropbox from Odoo'.
Configuration and Installation Tips for Dropbox Odoo Integration Odoo v.17
Python dependency
The tool depends on the external library 'dropbox'. Install this library for your Odoo server through the command:
pip3 install dropbox
Configuration and log in
- Turn on the option 'Dropbox Sync' (cloud Storage > Configuration > Configuration). The optional add-on Dropbox Odoo Integration is required
- Follow the URL https://www.dropbox.com/developers/apps/create
- Choose an API as 'Scoped access'
- Choose the type of access as 'Full Dropbox'
- Select any suitable name for the app and push the button 'Create app'
- Add the redirect URI as [YOURODOOSITENAME]/dropbox_token (e.g. https://faotools.com/dropbox_token). A valid SSL certificate (https) is required
- Grant permissions to the app: 'Account Info (Read)', 'Files and folders Metadata (Write)', 'Files Content (Write)', 'Collaboration (Write)'. For team DropBox assign also 'Team Data Members', 'Members (Read)'. Make sure no other permissions are assigned.
- Submit App
- Go to Odoo Cloud Storage > Configuration > Cloud Clients press 'Create'
- As a reference, introduce any name which would be clear to all users
- As a Cloud client, choose 'Dropbox'
- As a Root folder name, enter a title that will be used as the parent Dropbox directory for all synced folders. For example, 'Odoo' or 'OdooERP'
- Copy 'App key' to the 'App key'
- Copy 'App Secret' into the field 'App secret'
- Insert previously generated redirect URL
- If you use Dropbox team drives
- Check the related box
- Set an Dropbox user email. Inside this user folder, all Odoo-related items will be created, and only after that, they will be shared with all other users. Under this user, all files and folders are created, changed, moved, and deleted
- Press 'Confirm'. Odoo redirects you to the Dropbox login page. Check in the system, agree with all conditions, and grant all permissions asked
- After login, Dropbox redirects you back to Odoo. Dropbox - Odoo synchronization is ready to be done
- Apply the newly created cloud client to folder rules and/or manual folders which should be synced to that Dropbox instance
- Await the sync scheduled job to be started. For testing purposes only: trigger integration manually from Cloud Storage > Configuration > Configuration > the button 'Launch sync'.
Watch also the configuration video
Register a new Dropbox app
Set up Dropbox App: the redirection URLs
Dropbox permissions for personal accounts
Dropbox permissions for business accounts
Set up Odoo for the Dropbox integration
Odoo demonstration databases (live previews)
For this app, we might provide a free personalized demo database.
No phone number or credit card is required to contact us: only a short email sign up which does not take more than 30 seconds.
By your request, we will prepare an individual live preview database, where you would be able to apply any tests and check assumptions for 14 days.
Bug reporting
In case you have faced any bugs or inconsistent behavior, do not hesitate to contact us. We guarantee to provide fixes within 60 days after the purchase, while even after this period we are strongly interested to improve our tools.
No phone number or credit card is required to contact us: only a short email sign up which does not take more than 30 seconds.
Please include in your request as many details as possible: screenshots, Odoo server logs, a full description of how to reproduce your problem, and so on. Usually, it takes a few business days to prepare a working plan for an issue (if a bug is confirmed) or provide you with guidelines on what should be done (otherwise).
Public features requests and module ideas (free development)
We are strongly motivated to improve our tools and would be grateful for any sort of feedback. In case your requirements are of public use and might be efficiently implemented, the team would include those in our to-do list.
Such a to-do list is processed on a regular basis and does not assume extra fees. Although we cannot promise deadlines and final design, it might be a good way to get desired features without investments and risks.
No phone number or credit card is required to contact us: only a short email sign up which does not take more than 30 seconds.
The tool to build a deep and structured knowledge base for internal and external use. Knowledge System. KMS. Wiki-like revisions.
298€The tool for time-based service management from booking appointments to sales and reviews
The tool to set up KPI targets and control their fulfillment by periods. KPI dashboards. Dashboard designer. KPI charts
198€The tool to flexibly structure Odoo attachments in folders and synchronize directories with cloud clients: Google Drive, OneDrive/SharePoint, Nextcloud/ownCloud, and Dropbox. DMS. File Manager. Document management system
245€The tool to automatically synchronize Odoo attachments with OneDrive files in both ways
394€The tool to automatically synchronize Odoo attachments with Google Drive files in both ways
394€The tool to automatically synchronize Odoo attachments with ownCloud/Nextcloud files in both ways
394€