Backup ODOO [Local, Remote, Drive, Dropbox, Amazon S3]
by Hilar AK https://www.linkedin.com/in/hilar-ak/$ 29.16
Availability |
Odoo Online
Odoo.sh
On Premise
|
Odoo Apps Dependencies |
Discuss (mail)
|
Lines of code | 1508 |
Technical Name |
auto_backup_odoo |
License | OPL-1 |
Website | https://www.linkedin.com/in/hilar-ak/ |
Versions | 10.0 12.0 11.0 8.0 9.0 14.0 15.0 16.0 17.0 13.0 |
BACKUP
ODOO DATABASES & FILESTORE
Available Odoo Backup DB/Filestore
Modes:
- Local
- Remote Server
- Google Drive
- Dropbox
- Amazon S3
Module For backup ODOO databases and
automating the backup process of ODOO.
- Multiple Backup Modes
- Filestore Backup
- Backup ODOO Databases in specified path
- Detailed Message Log
- Backup Status Information and History
- User can select the format to dump, either custom archive, plain text SQL or tar archive
- Archive Backup Process
- Repeat Missed Backup Process
- Backup to Amazon S3
Features
- Dump ODOO Database in specified format
- Zip filestore in a specified location
- Output a custom archive suitable for input into pg_restore. This is the most flexible format in that it allows the reordering of loading data as well as to object definitions. This format is also compressed by default. Here we user gzip ie, test.gz, We also recommend you to select Custom, because Using the custom format you can restore single objects from a backup.
- Output a plain-text SQL script file (the default). The plain text format is useful for very small databases with a minimal number of objects but other than that, it should be avoided.
- Output a tar archive suitable for input into pg_restore. Using this archive format allows reordering and/or exclusion of database objects at the time the database is restored. It is also possible to limit which data is reloaded at restore time. we use tar with gzip
- Backup Filestore
- Multiple backup modes at sametime
- ODOO Backup to Amazon S3
- ODOO Backup to Google Drive
- ODOO Backup tp Dropbox
- ODOO Backup to remote server
Tech
Odoo Auto Backup Module uses
- PYTHON - Models
- XML - Views
- HTML - UI
- Twitter Bootstrap - UI
- backbone.js - Views
- jQuery
- PSQL - DB
External
Dependencies
- PYSFTP
pip install pysftp
- Dropbox
pip install dropbox
- Progress Meter
pip install tqdm
- Boto3
pip install boto3
- Botocore
pip install botocore
Installation
Install the odoo13 and Auto Backup
module.
After installation you can configure backup under general settings. If you are using the google
drive mode,
then msust enable the google integration under general settings and update the google drive
refresh
token.
CHANGELOGS
Date: 07/12/2020
- Performance Improvement
- Session Upload Trace For Dropbox Files > 150 mb
- Full Metadata Track In Message Logs
- Fix Dropbox Tar files upload
- Progress Meter In Logs
Date: 22/11/2020
- Amazon S3 Database Backup
- Amazon S3 Filestore Backup
Todos
- Backup Dashboard
Author
Hilar AK
Git
Repository
Hilar AK
Configurations
Cron Job To Enable Automatic Backup
New Record
Records
Backup Modes
Local
Remote
Google Drive
Dropbox
Amazon S3
Installation Guide: Python Packages with pip and Virtual Environments
Installing Python Packages with pip
Python packages can be easily installed using pip, the package installer for Python. Follow the steps below to install packages using pip:
- Open your command-line interface (e.g., Terminal, Command Prompt).
- Check if pip is installed by running the following command: bash
#!/bin/bash $ pip --version
If pip is not installed, you can install it by following the official documentation athttps://pip.pypa.io/en/stable/installing/.
To install a package, use the following command:
$ pip install package\_name
Replace package_name with the name of the package you want to install.
Example: To install the pysftp, dropbox, tqdm, simplejson package, run:
$ pip install pysftp dropbox tqdm simplejson
You can install multiple packages by listing them with spaces:
$ pip install package1 package2 package3
To install a specific version of a package, use the following command:
$ pip install package\_name==version\_number
Replace version_number with the desired version of the package.
Example: To install version 2.2.0 of the numpy package, run:
$ pip install numpy==2.2.0
- If you don’t specify a version, pip will install the latest version available.
Installing Packages within a Virtual Environment
Using a virtual environment is a recommended practice to manage Python packages for specific projects. Follow the steps below to install packages within a virtual environment:
- Create a new virtual environment by running the following command:
$ python -m venv env\_name
Replace env_name with the desired name for your virtual environment.
Activate the virtual environment:
- On Windows:
$ .\env\_name\Scripts\activate
On macOS and Linux:
$ source env_name/bin/activate
Once the virtual environment is activated, use pip to install packages as described in the previous section. The packages will be installed within the virtual environment and won't interfere with other Python installations.
To deactivate the virtual environment, simply run the following command:
$ deactivate
- This will return you to your regular command-line environment.
Using virtual environments helps maintain clean and isolated environments for different projects, ensuring package dependencies are managed effectively.
Odoo 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
Report comment
Any abuse of this reporting system will be penalizedissues fixed
Hilar connected with me and sorted out all the issues.
The Auto back up makes life very easy and is worth it .
Thank you Hilar.
Re: issues fixed
You are always welcome and happy to support you always.
Hello,
T
he only option which is working for me is google drive .but when I want to restore the database from odoo interface I've got this error message.Database restore error: "There is no item named 'dump.sql' in the archive"
when I verify the zipped folder I don't find dump.sql and manifest.json
for the other backup options: I've got those error message when configuring them: connexion failed
Re:
This is related to the configuration and also the database user. please connect me so I can support you.
Thanks
Great plugin
Set your backup easly to everywhere. Keep notify about backup.
Best way to save your time and never loose any data
Thanks Hilar, keep going
Re: Great plugin
You are always welcome
Gregorutti SA
. It's my pleasure to work with you.
Thanks!
This plugin is P.E.R.F.E.C.T
Re: Thanks!
Enjoy! :)
Thank you
Thank you and your efforts, although all the words of thanks do not fulfill even a small part of your right, in appreciation of your permanent and continuous giving, and I wish you to go towards the best, and I wish you more continuous creativity.
Re: Thank you
You are always welcome.
No backup able to take except filestore which don't require.
Hi Hilar,
Can you help me to do the correct setup? I've done setup as per your guideline in screen but not able to take zip file for google drive and dropbox. For drop box showing a backup like filestore which is not desired for us to take backup. Pls help to sort out this issue.
Re: No backup able to take except filestore which don't require.
Daer Abdus, You are trying to use the V16 application in V14. The database role must be configured correctly in Odoo conf. The same must be input in the backup config.
Hilar,
Need assistance to either remove the program entirely or to get it functional.
My data base is now unstable with errors as it will not uninstall completely.
Kindly assist.
disappointed!
I'm only getting the file store to download. Its been over 30 days since i Bought this and i still can not get support to get the dump.sql and manifest.json backed up.
Still waiting for support..
Despite my numerous emails for assistance to get this app to work i have not gotten any reply for over a month.
Still only getting the filestore only.
disappointed!
I'm only getting the file store to download. Its been over 30 days since i Bought this and i still can not get support to get the dump.sql and manifest.json backed up.
disappointed!
I'm only getting the file store to download.
Its been over 30 days since i Bought this and i still can not get support to get the dump.sql and manifest.json backed up.
hi, does it work in Windows environments?
Re:
yes. You need to make sure the Environment variables are set properly for Odoo and PSQL can be accessible outside
Hello
We have followed your recommendations to the letter by activating odoo env with these commands:
sudo apt-get install python-virtualenv
virtualenv --python=python3.6 venv
Then we installed the ODOO Backup module dependencies [Local, Remote, Drive, Dropbox, Amazon S3].
But unfortunately we still can't install the modules you sold us.
Do you have a solution to our need?
Re:
I didn't recommend to install python env. Please connect me in gmail.
hilarak@gmail.com
Unable to install module "auto_backup_odoo" because an external dependency is not met: Python library not installed: pysftp
Hello
We just bought the module Backup Odoo [Local, remote,Drive, Dropbox ) for odoo 14 to make a back up for our database. When we try to install the module we got this message error : Unable to install module "auto_backup_odoo" because an external dependency is not met: Python library not installed: pysftp
The thing we have installed all the dependies succesfully.
Dependencies
pip install pysftp
pip install dropbox
pip install tqdm
pip install boto3
pip install botocore**Wan
Can you help us to find a solution ?
Re: Unable to install module "auto_backup_odoo" because an external dependency is not met: Python library not installed: pysftp
Possibly you installed dependencies outside of odoo env. You must activate env first then install.
Second chance is after installation maybe you forget to restart the server
Congrats!! Access to Onedrive?
Hi Hilar AK,
First of all CONGRATS for your module!! It works awesome!!
Do you plan Onedrive support in the near future? As you know, they offer 1TB accounts within their Microsoft 365, so this space could be used for a lot of Odoo backups! Let us know your plans on this please!!
Thanks!
Re: Congrats!! Access to Onedrive?
Backup support for one drive will release soon.
bonjour
Jai Achter le module mais j'ai rien reçu le lien de téléchargement !
Backup file 8Gb support?
I already have one backup module but its unable to upload google drive. Giving error Memory Error because my backup file is 8gb ? Is this module solve that issue ?
Re: Backup file 8Gb support?
Yes, you can try. Memory time out need good server specifications
thank you so much.
a good and rapid service.
the team helped me solving a small technical problem very quickly and friendly.
special thanks to Mr Hilar.
Re:
Welcome. We are happy to give the support.
It for enterprise or community ?
Re: It for enterprise or community ?
Both are supported and tested.
Works on odoo.sh?
Re:
Sorry, No Access to database user and operations in odoo.sh
Hi there! The app is working fine backing up to Google Drive. We're having an issue backing up to SFTP. SFTP connection works fine as we can connect to it using Filezilla. SFTP server is a WD EX4100. Connection fails when we Test connection from the Configure Backup option in Odoo. Any fix for this issue?
Re:
You can contact me at hilarak@gmail.com
Odoo.SH
Does it works in Odoo.SH??
Re: Odoo.SH
Since we don't have access to do DB operations in sh and my module can't work.
Saved time
Thanks for this plugin.
Easy to set, saved time and always get a daily backup
Keep notify with Odoo Mobile App