Odoo System Schedule Backup and Restore Database Setup

This module will be work internally as command line interface (for Linux only) through linux crontab to backup and restore database.

  1. Backup database
  2. Restore as database _TEST
  3. Update image (i.e., with test logo) to _TEST

Just install this module, and it should work. Setup schedule time as you need it. Note: Itself, can also be used as scheduler instead of normal scheduler in OpenERP (you will see this backup and restore as one example).

Features

  • Add, Modify, Delete schedule
  • Direct process through command line interface

Setup Procedure

Menu -> Setting/Technical/Scheduler/Crontab Configuration

Fields:

  1. Crontab Name – name of crontab

  2. Description – more information

  3. Scheduling – crontab scheduling

    3.1 Minute: 0-59

    3.2 Hour: 0-23

    3.3 Day: 1-31

    3.4 Month: 1-12

    3.5 Weekday: 0-6, where 0 = Sunday

  4. Execute Directory – OpenERP’s root path to be used for log file, Temp File, DB Backup File and etc (depends on type of program)

  5. Command – command to run the program in command line interface pattern, require full path.

  6. Active – when True, will create crontab scheduler in OS. When False will delete it.

  7. Status

    7.1 Draft

    7.2 Confirmed

    7.3 Cancelled

  8. Attach File – Additional files, to be used in process (optional)

Note: crontab scheduler will be created only when State = Confirmed and Active = True

Technical Detail

Backup Database Script:

Use script, db_backup.py (written in Python)

 db_backup.py -u -d -p

Example:

 ‘/home/buasri/workspace/ecosoft_official_addons/ecosoft-addons/crontab_config/db_backup.py’ -u openerp -d TT -p ‘/home/buasri/workspace/openerp_tt’>>’/home/buasri/workspace/openerp_tt/crontab_oe.log’

Process:

  1. Create backup database as _dbbackup-YYYY-MM-DD hh:mm:ss.dmp
  2. Create file oe_db_last_bkup.txt to be used for restoration

Restore Database Process:

Use script, db_restore.py (written in Python)

 db_restore.py -u -d -p

-i id of crontab in OpenERP, from table crontab_config -c id of Company in OpenERP, from table res_company

Example:

 ‘/home/buasri/workspace/ecosoft_official_addons/ecosoft-addons/crontab_config/db_restore.py’ -u openerp -d TT_TEST -p ‘/home/buasri/workspace/openerp_tt’>>’/home/buasri/workspace/openerp_tt/crontab_oe.log’

Process

  1. Disconnect database to be restored
  2. Delete database
  3. Create new database
  4. Restore it.
  5. Read attached logo file
  6. Resize logo file
  7. Update logo file

Odoo 企业管理系统操作手册

我尝试这个Odoo企业系统,其功能相当齐全,我打算把其<<即时通讯>>、<<项目管理>>和<<论坛(Forum)>>功能介绍给大家尝试使用,Odoo 企业管理系统操作操作手册如下,供你们參考。

测试Odoo企业系统,请登陆 ..,先选 Database = Demo,然後输入账号 = Demo 和密码 = Demo,如有时间请尝试使用,给予意见。谢谢!

操作步骤:

1. 登入 http://54.169.174.119/,选 Database = test_odoo,然後输入账号和密码 = demo

odoo-oper0 odoo-oper01

2.  即时通讯功能

步骤1:按即时通讯图像

步骤2:选择通讯的对象

步骤3:输入及发送通讯内容

注: 虽然“绿色” 标示代表有效通讯,但是不表示对方一定会看到留言和回覆,因为对方可能把浏览器关闭,或是未有注意到电脑屏幕,所以若是紧急通讯,还是用电话比较好。

odoo-oper2

3.  发放群组讯息

步骤1:按“消息”图像

步骤2:选择“Whole Company (全公司)” 或 其它群组

步骤3:输入内容後按发放

odoo-oper3

注:在此输入群组发送讯息,用户将於其Foxmail电邮和群组讯息中看到,而不是在此系统的“收件箱”中收到电邮,敬请留意。


4.  项目管理

管理项目是组织活动、计划任务、跟踪问题,记录人力资源成本的组织形式。项目可以分为内部项目(研发活动,加快销售进度),私有项目或者客户参与的项目。 内部用户以项目成员的方式参与到项目中,分享项目的活动讯息。

odoo-oper4

项目活动预备以下阶段,用户也可按合式的运作需要来修改:

致於详细的项目管理运作,请參考以下Youtube的电影教材 (暂时只有英语版本):

国内网址:   http://infotechmanagefactory.com/odoo-project-management-training-video/

国外网址:   https://www.youtube.com/watch?v=Ij8IHJCdWkg

5.  Forum论坛管理

我们可用此功能张贴问题,然後等待同事支援,提出和记录解决方法,方便日後在这论坛(Forum) 内搜索。

5.1 选 “Website”

odoo-oper5

5.2 选 “Forum”

odoo-oper6

 

5.3 输入问题或回覆问题

odoo-oper7

总结

此Odoo为市场上新推出的公司管理软件,功能强大,希望大家共同合作去研究实施,为各人的工作带来便利。

谢谢!

How to Hidden “Manage Databases” Option on Odoo Logon Screen

Because of security control purpose, it is unsafe to publish the whole database management option to public. Hence, I would suggest to change the database management screen from original screen as below Diagram 1 to Diagram 2. To achieve it, you only need to edit the “base.xml” file under …/addons/web/static/src/xml directory as below steps.

Diagram 1manage-db1

Diagram 2manage-db2

 

Step 1:

#cd /usr/lib/python2.7/site-packages/openerp-8.0_c7d8e97-py2.7.egg/openerp/addons/web/static/src/xml

Step 2:

#vi base.xml

Step 3:

Find the section of <form id =”db_create” … until  … </form>  as below and delete those content:

<form id=”db_create” name=”create_db_form” style=”display: block;”>

<div class=”oe_view_manager oe_view_manager_current”>

…..

</form>

And then find the sections of  <form id =”db_drop”… </form>, <form id =”db_restore”… </form>, and <form id =”db_change_password”… </form>, and delete all of them.

Step 4:

Find the following and delete the crossed option:

<t t-name=”DatabaseManager.menu”>

<div class=”oe_secondary_menu_section”>Database Management</div>

<ul class=”oe_secondary_submenu nav nav-pills nav-stacked”>

<li><a href=”#db_create”>Create</a></li>

<li><a href=”#db_duplicate”>Duplicate</a></li>

 <li><a href=”#db_drop”>Drop</a></li>

<li><a href=”#db_backup”>Backup</a></li>

<li><a href=”#db_restore”>Restore</a></li>

<li><a href=”#db_change_password”>Password</a></li>

</ul>

 

Hope It is Useful to You.

Odoo Project Management Training Video

Odoo项目管理 (project management) 是组织活动、计划任务、跟踪问题,记录人力资源成本的组织形式。项目可以分为内部项目(研发活动,加快销售进度),私有项目或者客户参与的项目。 内部用户以项目成员的方式参与到项目中,分享项目的活动讯息。

项目活动预备以下阶段,用户也可按合式的运作需要来修改:

odoo-project-mgt

致於详细的项目管理运作,请參考以下英文版的的 Youtube 下载电影教材:

Odoo Training Videos

OpenERP/Odoo provides many advantages to mid-sized companies. It is open source and can be downloaded for free. No strings attached. A growing community. Easy customization. In this video we look at why OpenERP / Odoo may be a good solution for your business.

Feature comparison between Odoo/OpenERP versions 6 and 7

The differences between OpenERP 6 and OpenERP 7 were staggering and dramatically improved usability of the software. This video goes over some of the major enhancements that came with OpenERP 7.

Importing data into Odoo / OpenERP using XML-RPC

One of the most common requirements for implementing a new ERP system is bringing in data from a variety of sources. This video shows how you can get data into OpenERP / Odoo with very little code. While this video demonstrates this for version 7 the XML-RPC interface remains the same for Odoo 8.
In each video on OdooClass.com we always try focus on real business examples whenever possible. Videos that help you solve real problems with Odoo.

Handling product variants in OpenERP (Odoo) version 6

While product variants is built into Odoo 8, back in version 6 adding product variants required a little more effort. This video shows how product variants could be implemented in OpenERP 6.

Security Concern on Odoo Cloud Implementation – Question & Answer

What is the backup policy of Amazon Cloud Service (or the other servers you’d use)?
We have our own backup platform. Daily backups are replicated in 3 different data centers.
Backup history is kept during 3 months for each customer: 7 daily, 4 weekly, 3 monthly.
Manual backups available on demand via customer control panel.
See also here. Read More

Script to install Odoo OpenERP under Amazon AWS Cloud Platform

How to implement a free-of-charge world-class ERP solution without any hardware investment and maintenance cost ? Here is the solution by using Odoo under Amazon Cloud Platform. Pragmatic Odoo OpenERP is a pre-configured, secured, optimized and ready to run image for running Odoo OpenERP on Amazon EC2 in a production mode. Odoo OpenERP is a very popular business suite of application which covers the most important aspects of running a business including Sales, Purchase, Accounting, Finance, HR, Inventory Management, MRP, and POS. We have created a database with necessary modules such as automatic DB backups, Audit trails, encrypted passwords, warnings and alerts, Dashboards, VAT and some of the other must modules in Odoo OpenERP to run it effectively in production.

Read More

Steps to Install odoo ver8 on Fedora20

I tried to install Odoo version 8 (an open source erp system) under Fedora 20 by using the following script, it worked well.

  • information source: http://share008.blogspot.hk/2014/11/install-odoo-openerp-on-fedora.html
Odoo is a suite of business applications, organized in 6 groups: front-end applications, sales management applications, business operations applications, marketing applications, human resources and productivity applications.
The installation of Odoo 8 on a Fedora20 should take about ten minutes if you follow the very easy steps described below.

Read More