Box Odoo Integration
by faOtools https://faotools.com/apps/19.0/box-odoo-integration-19-0-box-odoo-1108$ 565.26
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Community Apps Dependencies | Show |
| Lines of code | 10508 |
| Technical Name |
box_odoo |
| License | See License tab |
| Website | https://faotools.com/apps/17.0/box-odoo-integration-17-0-box-odoo-1115 |
| Versions | 17.0 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
Discuss (mail)
|
| Community Apps Dependencies | Show |
| Lines of code | 10508 |
| Technical Name |
box_odoo |
| License | See License tab |
| Website | https://faotools.com/apps/17.0/box-odoo-integration-17-0-box-odoo-1115 |
| Versions | 17.0 18.0 19.0 |
This is the tool to integrate Box features with Odoo folders and files. The app automatically stores Odoo attachments and directories in Box and provides instant access to them through Box web links.
Automatic folders' structure
Decide which Odoo document types should have their own folders trees and synchronize those to Box
Automatic regular sync
Rely on auto-synchronization between Odoo and Box based on scheduled jobs. No manual interaction is required
Bilateral sync
Odoo sends attachments to Box and retrieves files from there. Binary content is kept in clouds, while Odoo provides direct access to synced items
Cloud synchronization history
Control Box 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, download, upload, and move files
Attachment box
Organize files of any Odoo object in a set of subfolders. Instantly access folders and files in the attachment box and in Box
How synchronization works
Automatic two-sided sync
- Configure sync for one or multiple Box accounts
- Integration is based on scheduled jobs and is fully automatized. The app regularly checks changes in Odoo and Box and runs sync operations
- Synchronization is bilateral. Updates in Odoo are reflected in Box (direct sync); changes in Box modify Odoo folders and attachments (backward sync)
- Cloud connection with Box might be reset. In this way, the app assumes getting all items back to Odoo (reverse sync)
Queue-based synchronization
- Once in 15 minutes, the app examines updates in Odoo and Box to prepare a synchronization queue
- Folders' checks follow the First-In-First-Out (FIFO) principle. Directories that have not been examined for the longest are processed first
- If the app faces sync failures, it will retry operations afterward. Sync queue processing is not stopped by non-blocking failures
Odoo attachments for Box: direct sync
- Direct sync prepares the folders' hierarchy and uploads Odoo attachments to Box
- Folder and file renames or moves keep stable Box IDs, so synced Odoo records stay linked to the same cloud item
- Uploaded attachments become URL records in Odoo, while binary content is stored in Box
Box files and folders for Odoo: backward sync
- Backward sync checks whether files or subfolders are added to Box folders. If so, the app creates URL attachments/subdirectories inside linked Odoo directories
- Updates in Box are reflected in Odoo, including moves and renames based on stable Box item IDs
- In case of conflicts, direct sync changes are in general considered more important than backward updates
Box URLs
Box provides internal web links for files and folders, for example links of the type https://app.box.com/file/[ID] and https://app.box.com/folder/[ID]. Such links are stable, but only Box users with access rights to the related item can open them.
By default, the connector uses those internal Box links. It is the safest and fastest option, since the synchronization does not have to create shared links for every synced item.
If shared links are enabled, Odoo will try to generate Box shared URLs for files and folders. Be cautious with this option: although the links are hardly known by external users, they might become available as a result of some user actions. Besides, shared link generation is slower and might make the synchronization process longer.
The tool depends on the external library 'box_sdk_gen'. Install this library for your Odoo server through the command:
pip3 install boxsdk- Turn on the option 'Box Sync' (cloud Storage > Configuration > Configuration). The optional add-on Box Odoo Integration is required
- Create or open a Box developer account and go to the Box Developer Console: https://app.box.com/developers/console
- Create a Custom App and choose OAuth 2.0 (Authorization Code Grant) as the authentication method
- Add the redirect URI as [YOURODOOSITENAME]/box_token (e.g. https://faotools.com/box_token). A valid SSL certificate (https) is required
- Grant the app access to read and write files and folders. Avoid assigning unrelated permissions
- Go to Odoo Cloud Storage > Configuration > Cloud Clients and press 'Create'
- As a reference, introduce any name which would be clear to all users
- As a Cloud client, choose 'Box'
- As a Root folder name, enter a title that will be used as the parent Box directory for all synced folders. For example, 'Odoo' or 'OdooERP'
- Copy Box Client ID to the field 'Client ID'
- Copy Box Client Secret to the field 'Client Secret'
- Insert previously generated redirect URL
- Press 'Confirm'. Odoo redirects you to the Box login page. Check in the system, agree with all conditions, and grant all permissions asked
- After login, Box redirects you back to Odoo. Box - 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 Box account
- Await the sync scheduled job to be started. For testing purposes only: trigger integration manually from Cloud Storage > Configuration > Configuration > the button 'Launch sync'.
Create a new Box developer app
Copy Box OAuth credentials
Configure the Box cloud client in Odoo
Grant Odoo access to Box
The app assumes that the binary content of attachments is kept in Cloud Client instead of the Odoo server. So, such attachments in Odoo become of the URL type, and you may any time access them either from the attachments box or from the Cloud Client.
After the setup, no manual actions are required, as the synchronization is fully automatic. Just decide which Odoo document types should be synced and set up a related model to sync for each of those (Customers, Sale or Purchase Orders, Tasks, Projects, etc.).
Yes, you can. To that goal, prepare a rule for each, and then those apply filters: for example by type of a project.
Try to make filters self-exclusive in order a document can be definitely assigned. For instance, 'customer but not supplier', 'supplier but not customer'. Otherwise, a specific document folder would jump from one model to another.
No. We have strong reasons to avoid real time sync:
Performance issues. In case a sync is real time, each file upload will result in the loading screen.
Conflict issues. If 2 users simultaneously change an item, it might lead to unresolved situations. In case of regular jobs we can fix it afterwards, while in case of real time we would need to save it as some queue, and it will be even more misleading for users.
Functionality issues. In particular, renaming and restructuring of items. In the backward sync the tool strictly relies upon directories' logic, and during each sync 100% of items are checked. In case it is done after each update, it will be thousands of requests per second. If not: changes would be lost.
You may assign your name for models' directories (sale orders, opportunities, suppliers, etc.) for any document type.
For objects' folders (SO-001, John Smith, etc.), the tool relies upon the Odoo method to construct a display name for this document type. However, you can change that by defining the name expression. The exact syntax for Odoo email templates is used.
No, starting from version 15, you should not change scheduled jobs. They are optimized to run every 15 minutes to guarantee the most stable and quick connection.
Ensure that your Odoo server timeouts are set for at least 15 minutes (900 seconds).
If you need to stop sync for a while, do that on a particular cloud client form.
Yes, starting from version 15, you can set up multiple connections. In this way, it is possible to sync some folders to one cloud client and others - to another.
Take into account that it is not any way possible to sync the same folder for a few cloud storages simultaneously.
Yes, depending on your cloud client configuration.
Starting from version 15, the app might be used stand-alone to structure attachments in folders and to provide a file manager interface.
However, if your goal is to establish a connection with one of its cloud clients, you would need at least one optional client-related app to be installed.
When a folder rule changes, the list of folders also changes. So, if a folder no longer matches the conditions of the folder rules - it is removed. If the files have been synced, the reversed sync returns them to Odoo and deletes them from the Cloud Client.
If a document's object doesn't match the conditions of a folder rule, then its folder will not be created. However, if it matches the conditions later, the related folder will be generated.
Manage Box files from Odoo File Manager
View Odoo files and folders in Box
Access Box files from an Odoo records
Browse Odoo subfolders in Box
View the Odoo root folder in Box
Odoo demonstration databases (live previews)
For this app, we might provide a free personalized demo database.
To demand such a database, press the button "Live Preview" on the top of this page or copy the link https://faotools.com/s/6uw0s1
You do not need a phone number or credit card to contact us. You should only pass 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 can apply any tests and check assumptions for about two weeks.
Bug reporting
If you encounter bugs or inconsistent behavior, do not hesitate to contact us. We guarantee to provide fixes within 60 days of purchase and are intensely interested in improving our tools even after this period.
To send us a bug report, press the "Website" link at the top of this page and push the button "Bug Report" (the tab Support). Alternatively, copy the link https://faotools.com/s/aekeg0
You do not need a phone number or credit card to contact us. You should only pass a short email sign-up, which does not take more than 30 seconds.
Please include as many details as possible in your request: 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 feedback. If your requirements are of public use and might be efficiently implemented, the team will include those in our to-do list.
Such a to-do list is processed regularly 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.
To share ideas, press the "Website" link at the top of this page and push the button "Share Features Ideas" (the tab Support). Alternatively, copy the link https://faotools.com/s/7g529s
You do not need a phone number or credit card to contact us. You should only pass a short email sign-up, which does not take more than 30 seconds.
Questions and misc issues
Feel free to contact us with any other concerns, doubts, or questions: press the "Website" link at the top of this page and push the button "Raise Question" (the tab Support). Alternatively, copy the link https://faotools.com/s/251v5o
You do not need a phone number or credit card to contact us. You should only pass a short email sign-up, which does not take more than 30 seconds.
About the team
faOtools (faotools.com, former odootools.com) is the developers and business analysts team that helps you extend Odoo's potential. Since 2012, we have communicated with end users for whom the software became the primary business tool. As a result, we are proud of the dozens of successful apps that have been developed. We are open to new ideas and challenges to create the best Odoo tools for business needs worldwide.
You may like the tools
The tool to build a deep and structured knowledge base for internal and external use. Knowledge System. KMS. Wiki-like revisions.
The tool to manage your Odoo from your favorite AI chats through MCP. Claude. Any MCP-supporting AI.
198
The tool to set up KPI targets and control their fulfillment by periods. KPI dashboards. Dashboard designer. KPI charts
The tool for time-based service management from booking appointments to sales and reviews
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
398
The tool to automatically synchronize Odoo attachments with OneDrive files in both ways
487
The tool to automatically synchronize Odoo attachments with Google Drive files in both ways
487
The tool to automatically synchronize Odoo attachments with ownCloud/Nextcloud files in both ways
487Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module