Saturday, 16 September 2017

Odoo 10: Link external url to menu


Hi, following code can be used to link menu to external url:

<record id="external_link" model="ir.actions.act_url">
        <field name="name">Odoobiz</field>
        <field name="type">ir.actions.act_url</field>
        <field name="target">new</field>
        <field name="url">http://blog.odoobiz.com</field>
</record>

<menuitem action="external_link" name="Odoobiz" id="menu_odoobiz_link" parent="website_blog.menu_website_blog_root"/>

This code will create Odoobiz menu under Blog menu and link it to http://blog.odoobiz.com. This will open link in new tab. If you want to open it in same tab itself. Please use -

<field name="target">self</field>

Thanks!!!!!!!! Enjoy Programming!! :)


Friday, 15 September 2017

PostgreSQL: Scheduler to take db backup every two hours



Hi, Today we are going to write a scheduler to take PostgreSQL db dump every two hours in ubuntu OS.

1. Create a folder called backup in your home directory where we are going to store all the dump files.

2. Because it's cron script so can provide password at runtime, we are going to store required details in ~/.pgpass file in following format

hostname:port:database:username:password


localhost:5432:mydb:user1:test123

don't forget to change it's permission to 0600 (chmod 0600 ~/.pgpass)

Note: You can change localhost with Server IP if you have

3. Create a file to write script for db backup. Let's create it in home directory itself and call it db_backup.sh

Add following command to the file.

pg_dump -d mydb -h localhost -p 5432 -U user1 -w  | gzip > /home/ubuntu/backup/$(date +%Y-%m-%d-%H:%m:%s).psql.gz

It will save the dump file with date and time as name. e.g 2017-09-16-07:09:1505546517.psql.gz

Don't forget to make db_backup.sh file executable (chmod +x db_backup.sh)

4. Now it's the time to set scheduler:



crontab -e

It will open scheduler file. Add following line at the end of file

1 */2 * * * /home/ubuntu/db_backup.sh

To know how these parameters work please visit https://crontab.guru/every-2-hours

That's it.

Now backup will be taken every two hours and backup file will be stored in ~/backup folder.


Thanks!!!! Enjoy Programming!! :)


Wednesday, 6 September 2017

Odoo10: Automatically Update Currency Exchange Rates



Hi, we have developed a module to automatically update currency exchange rates with respect to your company's base currency. This module can be used with any of the following API:

OANDA EXCHANGE RATE API

CURRENCYLAYER EXCHANGE RATE API 

FOREX CURRENCY CONVERSION API

You can buy this module directly from us or from apps.odoo.com using following url:

https://www.odoo.com/apps/modules/10.0/odoobiz_exchange_rates/


Thanks!!!! Enjoy Programming!! :)

Odoo10: Invoice Report with Bank Details



Hi, we have developed a module which will help companies to add bank details on invoice. You can download the same from apps.odoo.com

https://www.odoo.com/apps/modules/10.0/odoobiz_invoice_report/


Thanks!!!! Enjoy Programming :)

Odoo 10 Backend Themes



Hi, we have developed some free backend themes to help community and individual people who don't like default theme from odoo

You can download these themes from following links and make changes as per your personal and business needs:

https://www.odoo.com/apps/themes/browse?search=odoobiz

https://www.odoo.com/apps/themes/10.0/estate_backend_theme/

https://www.odoo.com/apps/themes/10.0/sarahah_backend_theme/

https://www.odoo.com/apps/themes/10.0/poil_backend_theme/

Thanks!!! Enjoy Programming :)

Nginx: Cannot allocate memory