Friday, 13 January 2012

OpenERP Complete guide for Module Development and Installation by Serpent Consulting Services

Hello Dear Reader, 

Here we represent the complete guide to let you be aware about OpenERP and know-how about module creation and installation.

For any queries regarding OpenERP Support, OpenERP Training, OpenERP Installation guides, OpenERP Offshore to be answered in detail, please refer Here.


  • OpenERP (previously known as TinyERP) is a comprehensive suit of business applications similar to SAP and Microsoft Dynamics for small and medium enterprises. It is completely cutomizable,platform-independent and an open-source system completely developed using open-source technologies like Python, Postgresql and pyGTK. It follows a modular approach called Model-View-Controler. It is developed by Belgium based software development firm called OpenERP SA. Most of it's code is released under AGPL license so there is no fees involved in use of the software. OpenERP follows a modular approach as described below.

  • What Is Module ?

Module is an independent and self-contained unit of any system. OpenERP modules are written in Python. The usage of module in OpenERP will extend the functionality of OpenERP. It uses OpenERP ORM to persist it’s data in a relational database called Postgresql. Modules are simple way to structure a complex application. One can add his own module in his OpenERP system or customize any existing module. Modules could also be known as plug-ins. Our demo module is called Student_info. This module provides an interface to collect following information about students.
  • Name
  • Age
  • Gender
  • Percentage
  • Details
  • Active

It also displays list of student information in tabular format. You can search student by name, gender and age.

Following are the standard Applications available in OpenERP.

  • CRM
  • Sales and Distribution
  • Accounting
  • Marketing
  • Human Resource
  • Purchase
  • Manufacturing
  • Project Management
  • Point of Sale
  • Warehouse Management
  • Invoicing
  • Payroll

Apart from modules given above, there are around 700+ modules available for use.

  • Following are steps to install module in OpenERP :

For sake of simplicity here we will use module name “Student_info

  • Copy your module directory into addons directory located under your Openerp directory
  • Launch an OpenERP server using following command:
python --addons=<path of your addons directory>

Here in above command file is located at <your-openerp- directory>/server/bin/ directory. You also have to supply path of addons directory which is generally located right under your openerp directory.

If you see the message like “OpenERP server is running, waiting for connections...”. you have successfully started the server, Bingo!

  • After starting server, start your either GTK client using following command:

Here in above command is located at <your-openerp- directory>/client/bin/ directory. After launching the client successfully you will see following screen.

Our database is test_demo but you have to select your own database.
Enter correct username and password and click on OK button.

  1. After clicking on button you will see following screen. Here you will see“Administration” menu item. Click on it.

  1. After selecting Administration module expand “Module” items. 

    3   Select “Update Modules List”. As your module is not a part of the certified addons yet, you will need to update the repository which is identified by the OpenERP Server.

  1. Now you can see one wizard “Update Module List”. Click on “Update”. This process will update modules

  1. After updating module you need to add new module as well as updated module. So after updating modules one wizard will open as “Update Module List”. Click on “Open Modules”.

  1. Now you can see all modules are loaded in the module list.

    7.   You can search any module by Name, Description, Dependencies or State. Here      


  1. Now you can see the filtered results containing name “student” which is showing “Not installed”. Just click “Student_info” and go to Form View or just double click on that.

  1. Now you can see all the information about Student_info containing Name, Quality Certificate, Category, Information about Author and Dependencies. For installing “Student_info” click on “Schedule for Installation”.

  1. For applying updates click on “Apply scheduled Upgrades”.

  1. Now one wizard will open to start update “Student_info”. Click on “Start update”.

  1. Now next step is to start configuration after updating module. Click “Start configuration”.

  1. Click ctrl+R to reload the Modules. Now you can see the “Student” Module is loaded in Menu. Click on that.

    14.Now expand the tree of Student Management. Click on “Student Information”.

    15.   After Clicking Student Information you can see the List View in which all the     fields of Student will be shown and records of which are shown in list .

  1. You can create a New record by clicking “New”.

  1. After clicking new record you will take to another wizard i.e. a Form View in which u can edit, create a new record and save it.

  1. After clicking that you can see that Document is saved and it is showing in centre bottom that “Document Saved”.

  1. Now you can search any record by its Name, Gender or Age. Here we have searched a “abc” name and it is showing record name containing student name “abc”.

  1. Another example of search, we have searched by “Gender” and we can see record containing Gender “Female”.

Module structure of OpenERP module :

Module structure considers the following things : 

1. OpenERP addons (openobject-addons) OpenERP business modules : 

OpenERP addons host the functional business modules of openerp covering: accounting, sales, crm, purchases, warehouse, manufacturing, project, human resources, marketing, knowledge, point-of-sale, and much more.

  • Addons contain the list of modules. 

  • The modules : 

  • When you create any module there are minimum four files required. which are given below : 


   3. (Your model file ) 
   4. filename_view.xml :
  • Views
  • Actions
  • Menu entries
  • Report
  • Wizard     
  • Now we shall see how to create a module in OpenERP: 
     Step 1:   Create the file in the new folder you have created for the module, in the   addons directory. The file must have a line to import the main  python(.py)  file you intend create for the module.Having the file in your module makes the      code a package.          
        Step 2:   Create a module description file (i.e The                              file provides a description of the  module you want to create. 
  • It essentially contains a python dictionary. 
         Step 3:  Create your python file that contains objects (Infact thats your model) .
                 This file you have to import in your file. 

    Step 4 :  Create your view.xml file . 
             This XML file is a VIEW component of MVC architecture, which is responsible                           for the GUI.

  •  They are used for many purpose : 
  • Initialization and demonstration data declaration.
2. Views declaration :
  • Views are a way to represent the objects on the client-side. 
  • They indicate to the client how to layout the data coming from the objects on the screen. 
  • There are two basic types of view(there are more, but let's focus on basic ones):
  • Form view
  • Tree view  
    List view  is simply a particular case of tree view.
            3. Report declaration : 
  • OpenERP uses a flexible and powerful reporting system.
  • Reports are generated either in PDF or HTML format.
  • Reports are designed on the principle of separation between the data layer and presentation layer. 
           4. Wizard declaration :  
  • A wizard is declared using wizard tag.        

      5. Workflow declaration. 
  • The workflow describes these interaction with graphs.
  • One or several workflows may be associated with the objects.
  • Workflows are not mendatory.
  • Screen short of the module is given below : 

  In above figure you can see the list of modules in the addons. 

The four file described above are :

Now we see content of these above file:


This file contains the import statements for importing python(.py) files.
The screenshot of this file is shown below.


This file contains the directory which gives introduction about module. In which there are various field described below.


It shows field contains the name of the module.
It shows the version of the module.
It shows author of the module.
It contains website of the author.
It is a list of modules on which this module depends.
It shows the category of the module (i.e. sales,finance,etc.)
The detailed description about the module which describe the functionality of the module.
It contains list of xml files which will get executed when the module gets installed.

It contains list of xml files which will get executed when the module goes under update mode.
It is a file same as other xml files, but this one contains the demostration data of the models created in the module.
It describes that if this module is installed by default or not.
It describes this module is installable or not.
The certificate no. Assigned by Editor, OpenERP SA.

The example of the file is shown in the screenshot below.


It contains the class which is inherits osv class by importing osv and fields class from osv file. The class contains _name which contains name of table, _columns which contains fields of table and _defaults is to give default value.

    • _name:
It define the table name of module. If (.) is used then it will be replaced by (_) in table name.
    • _columns:
It contains fields of the table. Fields contains various data type which shown below.

Data type

It stores character data. Size is necessary for this data type.
It stores the Integer value.
It store Boolean value which contains True or False.
It stores large amount of character data without defining the size.
It stores the floating(decimal) value.
It contains list of tuple to store data in list. Can be said as a combo-box.

The _columns field contains dictionary to store fields of table.

In above screenshot the _columns contains dictionary which contains various keys and values. Key describe fields of table and value describe data type, label name and constraints of the field.

Various constraints are shown below.



It is used for mandatory field. If value of required is True then it consider as mandatory field.
If value of read only is True then user can not modify in field.
If value of translate is True then the field can be translated into installed language.

    • _defaults:
It is use for give default value in table's field. The example shown in below screenshot.

The _defaults variable contains the dictionary, in above screenshot the name field contains default value “Atul” and it is Active.
The student_student() calls the parent class osv.osv's constructor.

View the XML File

There are two type of architectures
A. Client-Server Architecture
B. MVC Architecture

As per MVC architecture there are Model,View, and Controller. So this is view of
the system.
For the view of the module a file is created which is formatted as XML.
There are three categories of XML file in module.
    1) View
    • Search View
    • Tree View
    • Form View
         This portion contains presentation of your module. As per the requirement,
there are three types of view.
  • Search View:

Search View used in module to provide the search panels in form , and from those fields user can search the data. It creates a customized search panel, and is declared quite similarly to a form view, except that the view type and root element change to search instead of form.

Here, in above example Name, Gender and Age fields are provided so by using these fields user can search the particular record.

  • Tree view

Tree view is also called a list view. We can specify columns which we want to add in the list with some details of list display.

In above example we can see the Student Name, Student Age, Student Percentage , Gender and Active Status.

  • Form view

Form view is used when the User wants to Edit or Add the information. The field disposition in a form view always follows the same principle.By default, each field is preceded by a label, with its name. In above example code displays the form view of module and fields like name,age,gender etc.

2) Action :

The action defines the behavior of the system in response to the action of the users. Action portion shows an action or behaviour of module. It shows the priority of the views. By this action we will open next view.
In above code you can see that when we open the module the default view of module is form view.

    3) Menu :

In OpenERP, this element represents a menu structure as shown in the screenshot. You would be able to reach the Forms of the model only by clicking on this menu and it will trigger an action you created in (2).
We hope this guide will help you sail well in the boat of learning OpenERP Module Development.
Wish you a good luck for your module.
Malhar Vora, Bipin Rathod, Vijay Rathod, Nishant Jogi, Kalpana Hemnani, Abhishek Mehta, Atul Makwana, Hitesh Panara.
Guided by:


  1. Replies

    1. Tag: PM203A56. Let me share all of you about #5 Tips for Project Management Success,, I hope you enjoy it

      1. Plan your day using time management techniques

      As a project manager, time management skills are essential because you are dealing with a wide range of tasks that demand a quick turnaround time. Planning your day will go a long way in keeping you organized and increasing your productivity. Assist your task planning by using project management software which helps you track the work of you and your team.

      If you are not very tech savvy, a simple to-do list can also be a great organizational tool. Prioritize your most important tasks by putting them at the top of the list and less important ones at the bottom. Having a visual plan of your daily tasks helps to keep you on track and aware of time.

      Related post: Free ebook 104 secrets to become a great project manager

      2. Include stakeholders in important project conversations

      While you will have plenty of responsibilities regarding the project, don’t neglect your clients.

      Good communication is essential is keeping both parties informed of project progression, curtailing scope creep, and apprised of changing requirements. Some clients may have different expectations when it comes to communication, so make sure to establish the frequency and type of communication (like emails, phone calls, and face-to-face conversations) at the beginning of your project.

      Establishing communication expectations early helps alleviate stakeholder uncertainty about communication frequency and delivery.

      3. Regularly communicate with your team

      Daily team communication helps keep misunderstandings and unclear requirements under control. Keeping your team informed in every step of the project is essential to project management success.

      For example, a study published by Procedia Technology found that good communication skills were the cornerstone of project management. The study examined over 300 “construction project managers, architects, construction managers, engineers and quantity surveyors” and their successes and failures on various construction projects.

      4. Anticipate project setbacks

      Even the best-laid plans often go awry.

      Remember that even with a high amount of planning and attention to detail, your project may still encounter some challenges. Pay attention to complaints from stakeholders or colleagues, and other warning signs, like a missed deadline or cost overrun, that there may be a problem.

      Preventing a crisis will keep your project running smoothly, save you a lot of time, and keep you, your team, and your stakeholders confident in progressing with the project.

      Unfortunately not every complication can be avoided. Crisis management skills are essential for dealing with the unexpected. Project managers need to be flexible and pragmatic. Improvise and make sharp decisions when needed.

      Related post: 92 free project management templates

      5. Stay focused on the details

      A common problem project managers encounter is having the project aims not aligned with the organization’s objectives. A great project manager will strategize a plan for the project to lead back to the overall success of the business.

      Know your project’s scope by heart and avoid wandering outside of the project’s requirements. It’s too easy to get lost in minor details and forget what your focus is, so a well-planned project scope is essential for success.

      And final, you should use KPI to measure effectiveness of the project, here are full list: 76 project management KPIs

  2. Is Same thing for tryton available?

    1. Yes Criscoder,

      Its available over here :

      Hope it helps.

  3. Very very helpfull this tutorial! This exactly what any newbie on Openerp needs to put hand on development.
    For some online coaching do you means is it possible?

  4. "For sake of simplicity here we will use module name “Student_info”
    Copy your module directory into addons directory located under your Openerp directory"

    For all my effort, I have no clue where to find the module to copy from... any links?

  5. This comment has been removed by the author.

  6. Very good, but i dont get install the example module, when update list modules the new is not detected.

  7. thanks for the great post , i have tried with openerp7 but am getting this error while installing the module.

    OpenERP Server Error
    Client Traceback (most recent call last):
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\web\", line 195, in dispatch
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\web\controllers\", line 1082, in call_button
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\web\controllers\", line 1070, in _call_kw
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\web\", line 43, in proxy
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\web\", line 31, in proxy_method
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\web\", line 104, in send

    Server Traceback (most recent call last):
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\web\", line 90, in send
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\", line 289, in dispatch_rpc
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\service\", line 614, in dispatch
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\osv\", line 169, in execute_kw
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\osv\", line 123, in wrapper
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\osv\", line 179, in execute
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\osv\", line 166, in execute_cr
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\base\module\", line 425, in button_immediate_install
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\base\module\", line 476, in _button_immediate_function
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\", line 39, in restart_pool
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\modules\", line 214, in new
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\modules\", line 349, in load_modules
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\modules\", line 260, in load_marked_modules
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\modules\", line 163, in load_module_graph
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\modules\", line 405, in load_openerp_module
    File "C:\Program Files\OpenERP7\Server\server\.\openerp\modules\", line 133, in load_module
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\student_Management\", line 1, in
    File "C:\Program Files\OpenERP7\Server\server\openerp\addons\student_Management\", line 5
    _name = 'student.student'
    IndentationError: expected an indented block

    1. Hey,
      You have to read something about python. This error indicates taht you don't use properly indented. Generally indentes are very important in python.

  8. I'm new to OpenERP 7 and went through all modules and settings. Earlier, I created a module using blog's details and they worked also.

    But i saw that there is an option to create model, views and menus in Settings -> Technical -> User Interface -> Views. Also model under database structure.

    Is there any possibility to create a module with that options? I couldn't find any documentation for OpenERP Ver.7

  9. How to change the CSS/Theme in Sales module Help-desk / Categories table ?

  10. Thanx for your info, it's really helped

  11. Hey, thanks for the info..but I'm getting this error:

    Server Traceback (most recent call last):
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\openerp\addons\web\", line 89, in send
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\", line 292, in dispatch_rpc
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\service\", line 626, in dispatch
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\osv\", line 188, in execute_kw
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\osv\", line 131, in wrapper
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\osv\", line 197, in execute
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\osv\", line 185, in execute_cr
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\openerp\addons\base\module\", line 424, in button_immediate_install
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\openerp\addons\base\module\", line 475, in _button_immediate_function
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\", line 39, in restart_pool
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\modules\", line 218, in new
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\modules\", line 345, in load_modules
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\modules\", line 256, in load_marked_modules
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\modules\", line 186, in load_module_graph
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\modules\", line 73, in
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\modules\", line 124, in _load_data
    File "C:\Program Files\OpenERP 7.0-20130811-231021\Server\server\.\openerp\tools\", line 941, in convert_xml_import
    File "lxml.etree.pyx", line 2698, in lxml.etree.parse (src/lxml/lxml.etree.c:49590)
    File "parser.pxi", line 1513, in lxml.etree._parseDocument (src/lxml/lxml.etree.c:71423)
    File "parser.pxi", line 1543, in lxml.etree._parseFilelikeDocument (src/lxml/lxml.etree.c:71733)
    File "parser.pxi", line 1426, in lxml.etree._parseDocFromFilelike (src/lxml/lxml.etree.c:70648)
    File "parser.pxi", line 997, in lxml.etree._BaseParser._parseDocFromFilelike (src/lxml/lxml.etree.c:67944)
    File "parser.pxi", line 539, in lxml.etree._ParserContext._handleParseResultDoc (src/lxml/lxml.etree.c:63820)
    File "parser.pxi", line 625, in lxml.etree._handleParseResult (src/lxml/lxml.etree.c:64741)
    File "parser.pxi", line 565, in lxml.etree._raiseParseError (src/lxml/lxml.etree.c:64084)
    XMLSyntaxError: Attribute name redefined, line 11, column 23

    The problem, I think it's on the XML, but I can't figure out where. The full XML is here -

  12. Im new to ERP i found it very much helpfull in understanding the sturucture of module....will u plz reccomend any sites r books which ll b helpfull in accumlation of new concepts n depth...

  13. Is it all that is needed to create a module in open erp?The module described above is that of v6.Is the same module compatible with v7?

  14. My Error after doing exactly what you said is:

    Client Traceback (most recent call last):
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\openerp\addons\web\", line 204, in dispatch
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\openerp\addons\web\controllers\", line 1132, in call_button
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\openerp\addons\web\controllers\", line 1120, in _call_kw
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\openerp\addons\web\", line 42, in proxy
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\openerp\addons\web\", line 30, in proxy_method
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\openerp\addons\web\", line 103, in send

    Server Traceback (most recent call last):
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\openerp\addons\web\", line 89, in send
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\", line 296, in dispatch_rpc
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\service\", line 626, in dispatch
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\osv\", line 190, in execute_kw
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\osv\", line 132, in wrapper
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\osv\", line 199, in execute
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\osv\", line 187, in execute_cr
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\openerp\addons\base\module\", line 426, in button_immediate_install
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\openerp\addons\base\module\", line 477, in _button_immediate_function
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\", line 39, in restart_pool
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\modules\", line 233, in new
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\modules\", line 354, in load_modules
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\modules\", line 254, in load_marked_modules
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\modules\", line 102, in add_modules
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\modules\", line 344, in load_information_from_description_file
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\tools\", line 285, in safe_eval
    File "C:\Program Files (x86)\OpenERP 7.0-20140622-231040\Server\server\.\openerp\tools\", line 158, in test_expr
    File "", line 15
    SyntaxError: invalid syntax

  15. Thanks For Your valuable posting, it was very informative. Am working in Erp In India

  16. This comment has been removed by the author.

  17. I really appreciate your article.The post has excellent tips which are useful. this post is good in regards of both knowledge as well as information,So thanks to share it.

  18. Thanks for sharing this quality information with us. I really enjoyed reading. Will surely going to share this URL with my friends.
    abnehmen ohne sport


  19. You are sharing a wonderful article. It was great post. Keep more share your updates.
    dnn module development at 13 Below


  21. I like this post I really appreciate the kind of topics you post here.thank you
    Education erp software in chennai

  22. Amazing Article ! I have bookmarked this article page as i received good information from this. All the best for the upcoming articles. I will be waiting for your new articles. Thank You ! Kindly Visit Us @ Coimbatore Travels | Ooty Travels | Coimbatore Airport Taxi | Coimbatore taxi