www.numberspeaks.com

BLOG

App / Coding / Odoo / OpenERP

Odoo dashboard mobile

Odoo dashboard is a simple app that displays predefined widgets set on Odoo server, this app requires an additional module available on Odoo store. – Create, rename, delete, reorder and reload dashboards.– Add, remove, reorder and reload widgets from dashboard.– Fast loading, data is retrieved by the server and cached. Odoo Dashboard Widgets – WidgetXVsY: displays 2 numbers, difference and variation is calculated.– WidgetLastX: it could be used to displays x last months orders / invoices, etc…– WidgetSingleX: displays a relevant numbers Odoo server module Odoo dashboard Remote database access Connect to remote databases (MSSQL, local postgreSQL, MySQL not implemented yet) …

Linux
Coding / Linux / Odoo / OpenERP

Odoo 9 Linux bash backup script

Bash backup odoo script is available on GitHub for Odoo 8 and 11. This bash script will help you to backup Odoo database, set a password on the backup file and remove files older than 7 days. You’ll need curl and 7zip linux package to make it work. This example is backing up od11-01 and od11-02 databases. It’s not really optimized with the double compression. BACKUP_DIR=/opt/backup ODOO_DATABASES="od11-01 od11-02" ADMIN_PASSWORD="ODOO_DATABASE_MANAGER_PASSORD" FILE_PASSWORD="ZIP_FILE_PASSWORD" TIMESTAMP=`date +%Y-%m-%d_%H-%M-%S` for DB in ${ODOO_DATABASES} do # create a backup curl -X POST \ -F "master_pwd=${ADMIN_PASSWORD}" \ -F "name=${DB}" \ -F "backup_format=zip" \ -o ${BACKUP_DIR}/${DB}/${DB}.${TIMESTAMP}.zip \ http://localhost:8069/web/database/backup 7z a …

Coding / Linux / Odoo / OpenERP

Protect Odoo 11 database backup with a password

Database auto-backup backup process crashes with a database size > 200 MB and Odoo worker enabled. The module “Database auto-backup” will help you to backup Odoo database on your local disk or remotely on a FTP server through ftp our sftp protocol, however it doesn’t give us the possibility to secure a bit more the backup file generated, therefore I added 2 additional options (Enable password and password) to be able to protect by a password the compressed file by using directly Linux 7z command line and recompressing a 2nd time the file, we should use dump file instead of …

App / Coding

Remote Mac computer from iPhone

CM – Remote Mac computers remote controller for macOS 13 Ventura and newer Control your Mac effortlessly from iPhone and iPad ApplicationsLaunch, exit and maximize program. SystemAdjust the volume, lock, put your Mac to sleep, restart from iPhone, iPad Installation of the macOS Agent is necessary. You can find the link below. CM – Remote works exclusively when both Mac and iOS devices are connected to the same network. Download Mobile App Mac computer Agent: CM Agent Latest version: 1.31 Designed to work with macOS version 13 Ventura and newer. Latest version: 1.34 macOS agent archive1.2 – Download1.3 – Download1.31 – Download

Odoo / OpenERP

SQL query in Odoo

    Sql query in Odoo model @api.multi def get_all_so(self, name=None): sql = "select * from sale_order where name like ‘%s%’ order by name desc;" % name self.env.cr.execute(sql) res_all = self.env.cr.fetchall() #fetchall() will return an array of dictionaries return res_all @api.multi def get_so(self, name=None): sql = "select * from sale_order where name like ‘%s’ order by name desc;" % name self.env.cr.execute(sql) #fetchone() will return the first element found as dictionary res_one = self.env.cr.fetchone() return res_one print(self.get_all_so(name=’SO2018′)) [{‘name’:’SO2018001′,’partner_id’:’Customer 1′,…},{‘name’:’SO2018002′,’partner_id’:’Customer 2′, …}] print(self.get_so(name=’SO2018001′)) {‘name’:’SO2018001′,’partner_id’:’Customer 1′,…}

zimbra
Zimbra 8.6

DKIM Zimbra 8.6

DKIM is an email authentication method designed to detect email spoofing, for more detail : Wiki DKIM, i’m describing in this post how to enable it with Zimbra. Make sure your DKIM has been enabled in your mail server. su – zimbra /opt/zimbra/libexec/zmdkimkeyutil -a -d domain.com 148ERADC-FCE5-11E6-AF44-005A1B26B745._domainkey IN TXT ( "v=DKIM1; k=rsa; " "p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDg2uVLIssdfsfgu62+c7n0sxugzm8Lpr4A7o7veL4kIeifat2hD53P2KKQTV978HxBTQKrEFByLbG0WZuNracNJU9L5NOKtmYnE7ksxF9ODMKqFK+ltsmM9qkVxbU3xQOVdufDlV2Zk8Ya0WMkYWzKgWIwIDAQAB" ) ; —– DKIM key 148ERADC-FCE5-11E6-AF44-005A1B26B745 for domain.com Add DNS TXT record: 148ERADC-FCE5-11E6-AF44-005A1B26B745._domainkey IN TXT v=DKIM1; k=rsa;p=MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDg2uVLIssdfsfgu62+c7n0sxugzm8Lpr4A7o7veL4kIeifat2hD53P2KKQTV978HxBTQKrEFByLbG0WZuNracNJU9L5NOKtmYnE7ksxF9ODMKqFK+ltsmM9qkVxbU3xQOVdufDlV2Zk8Ya0WMkYWzKgWIwIDAQAB Test DKIM signature by sending email using this website: http://dkimvalidator.com/

More