India

ZestyBeanz Technologies Pvt Ltd Thejaswini, Technopark Thiruvananthapuram,
India – 695581
Phone: +91 471 4063254
Fax : +91 471 2700171

   .

ZestyBeanz Technologies Pvt Ltd, 2987, Manikkath Cross Road, Ravipuram, Kochi, India - 682016, Phone: +91 484 4063254

  UAE

ZestyBeanz Technologies FZE, P.O Box 53261, HFZA, Sharjah, Phone: +971-56-2708993​

  Germany​

ZestyBeanz Technologies UG Fürther Str. 27 90429 Nürnberg Phone: +49-911-28707070

OpenERP development environment in Windows using Eclipse.

Contact Form


fahad's picture

OpenERP development environment in Windows using Eclipse.

 In this blog we will go through some steps required in setting up OpenERP for customization under eclipse in windows.
Before going into the details, let me remind every one that Linux distros preferably ubuntu is the best platform to do developments in OpenERP. This may be useful to only those insit development to be done in Windows.

Versions Used:

        OpenERP        -      6.0.3
        Postgresql       -      9.0.4 
        Eclipse            -       3.7 (Indigo) 

  1)Download eclipse sdk(Indigo,latest version) and unzip it 
               http://www.eclipse.org/downloads/download.php?file=/eclipse/downloads/drops/R-3.7-201106131736/eclipse-SDK-3.7-win32.zip

   2)To run eclipse a java based application requires java jre to be installed.Download and install from 
                 http://www.oracle.com/technetwork/java/javase/downloads/index-jdk5-jsp-142662.html
 
        After installation, we need to add the jre bin path into system environment variable PATH.In my case jre bin
         was at 'C:\Program Files\Java\jre1.5.0_22\bin'.similarily add the jre bin path of your installation.
          (My computers-->properties-->Advanced System Setting-->Environment Variable-->PATH)

   3)Download the zip file from here which contains python interpretor and other python packages needed by OpenERP.
       Extract and run the batch file 1 which installs python and  its associated libraries.we need to add following path
       to system environment variable PATH before running the batch file 2 since it requires python as windows
       command to run python scripts to install some more python packages.
(;C:\Python25;C:\Python25\Scripts;C:\Python25\bin;C:\Python25\libs;C:\Python25\Lib\site-packages;C:\Python25\include;C:\Python25\DLLs)
         
         Zip files conatins packages downloaded from the following links
                a)http://bazaar.launchpad.net/~openerp/openerp/win-installer-trunk/files/head%3A/dependencies/
 
               b)http://pyyaml.org/download/pyyaml/PyYAML-3.09.win32-py2.5.exe
 
               c)http://ftp.edgewall.com/pub/babel/Babel-0.9.4.tar.gz
 
               d)http://download.cherrypy.org/cherrypy/3.1.2/CherryPy-3.1.2.tar.gz
 
               e)http://pypi.python.org/packages/source/s/simplejson/simplejson-2.0.9.tar.gz
 
               f)http://pypi.python.org/packages/source/F/FormEncode/FormEncode-1.2.2.tar.gz

    4)Install PyDev plugin in eclipse
              a)help -> Install New Software.
              b)In Install dialog box, Click Add.
              c)Give name ‘pydev’ and type the path. i.e. http://pydev.org/updates.
              d)click ok.
              e)select pydev checkbox and follow the steps by clicking finish

     5)Adding python in eclipse can be done by
             a)window -> Preferences
             b)In Preferences dialog box expand pydev from left side tree
             c)click on Interpreter-Python
             d)click new on right side of python Interpreters
             e)locate the python.exe in the installed path e.g. C:\Python25\python.exe via Browse button and also
                give the name to this interpreter(Python25)
             f)click ok then again ok

      6)Download and unzip tarballs for OpenERP 6.0.3 server, Client and Web-client using the following paths.
         Unzip all these packages to separate folders on same path like Client, Server, Webclient folders in
         C:\OpenERP path.
                  a)http://www.openerp.com/download/stable/source/openerp-server-6.0.3.tar.gz
 
                 b)http://www.openerp.com/download/stable/source/openerp-client-6.0.3.tar.gz
 
                 c)http://www.openerp.com/download/stable/source/openerp-web-6.0.3.tar.gz

       7)Now we need to create PyDev projects in Eclipse for each of three projects i.e. Server, Client, and Webclient.
          we can name the PyDev project as for eg:OpenERPClient, OpenERPServer and OpenERPWebClient and
          for each we have to uncheck the option Use Default and browse for the path where we have unzipped each of 
          packages(C:\OpenERP).we have to choose project type as Python and its grammar version as 2.5 and
          Interpreter as Python 2.5.

       8)Download  and Install postgresql.
             a)http://www.enterprisedb.com/products-services-training/pgdownload#windows
             b)It will prompt for password and port number during installation process .If already postgresql older version
                is runnning on your machine then enter port 5433 else enter 5432.
             c)Create a new postgres user , start-->all programs-->postgresql 9.0-->pgadmin3
             d)servers-->postgresql 9.0 right click on connect and enter password when prompted
             e)mouse over login role right click new login role and enter role name(eg. 'openpg') and password
                (eg. 'openpgpwd') and in the second tab role privileges above check all boxes(Superuser,Can Create....)

        9)Now need to create configuration file for openerp-server with following options and copy conf file  to the bin
          folder located in the path where we’ve unzipped server’s source code e.g. C:\OpenERP\server\bin

  1. [options]
  2. without_demo = False
  3. smtp_port = 25
  4. db_password = openpgpwd           (password you had given for the new role created in postgresql)
  5. xmlrpcs_interface = 
  6. syslog = False
  7. logrotate = True
  8. xmlrpcs_port = 8071               (change port here if already allinone setup has been installed,say 8061)
  9. test_report_directory = False
  10. list_db = True
  11. timezone = False
  12. xmlrpc_interface = 
  13. test_file = False
  14. cache_timeout = 100000
  15. smtp_password = False
  16. secure_pkey_file = server.pkey
  17. xmlrpc_port = 8069                (change port here if already allinone setup has been installed,say 8059)
  18. log_level = info
  19. xmlrpc = True
  20. test_disable = False
  21. admin_passwd = admin
  22. assert_exit_level = error
  23. smtp_server = localhost
  24. static_http_url_prefix = None
  25. test_commit = False
  26. xmlrpcs = True
  27. demo = {}
  28. login_message = False
  29. import_partial = 
  30. pidfile = None
  31. db_maxconn = 64
  32. stop_after_init = True
  33. osv_memory_count_limit = False
  34. reportgz = False
  35. osv_memory_age_limit = 1.0
  36. netrpc_port = 8070                 (change port here if already allinone setup has been installed,say 8060)
  37. db_port =5432                      (change port value as given by you at the time of postgresql-9.0 installation)
  38. db_name = False
  39. debug_mode = False
  40. netrpc = True
  41. secure_cert_file = server.cert
  42. csv_internal_sep = ,
  43. pg_path = None
  44. static_http_enable = False
  45. translate_modules = ['all']
  46. smtp_ssl = False
  47. root_path = C:\OpenERP\server      (change root_path to where you have extracted OpenERP Server)
  48. netrpc_interface = 
  49. smtp_user = False
  50. db_user = openpg                   (new login role you have created in postgresql)
  51. db_host =localhost
  52. email_from = False
  53. addons_path = C:\OpenERP\server\bin\addons  (change addons_path to addons directory present in root_path )      
  54. static_http_document_root = None

      10)In Eclipse package explorer, open the list of Server -> open Bin -> Right Click on openerp-server.py 
        Mouse Over ‘Run As’ -> Select ‘Python Run. In the same manner you can run openerp-client and openerp-web.

    Note : 
        a)IF no other installation of OpenERP are there you can use the default values for netrpc,xmlrpc and xmlrpcs
        b)IF you have changed the netrpc port value then you should also change value of 'openerp.server.port' to 
           corresponding netrpc port value in  web/doc/openerp-web.cfg.
         c)Similarily when trying to connect server with openerp-client also need to change netrpc-port to same.
         

Khin's picture

I installed OpenERP7

I installed OpenERP7 (Allinone),Python25, Eclipse(Indigo) in Window XP. Now I want to customize some feature in existing module (hr_payroll).I can't debug OpenERP in Eclipse. I didn't find this file (openerp-server.py) in my location(C:\Program Files\OpenERP 7.0-20130613-231107\Server\server\..). In Eclipse, I didn't see server folder in browse (Eclipse -> Run -> Debug Configurations -> Python Run -> Double click -> Browse). Can you help me this problem? Thank you very much.

Anonymous's picture

I want to design forms in my

I want to design forms in my project . How can I be able to do this ?

Please help

Titus's picture

I have followed the steps to

I have followed the steps to have openERP on my machine. When I run opeerp-server.py I get this output:

[2013-04-17 15:09:27,352][?] INFO:server:OpenERP version - 6.0.4
[2013-04-17 15:09:27,352][?] INFO:server:addons_path - C:\OpenERP\Server\bin\addons
[2013-04-17 15:09:27,352][?] INFO:server:database hostname - localhost
[2013-04-17 15:09:27,352][?] INFO:server:database port - 5432
[2013-04-17 15:09:27,352][?] INFO:server:database user - Titus
[2013-04-17 15:09:27,352][?] INFO:server:initialising distributed objects services
[2013-04-17 15:09:27,634][?] INFO:web-services:starting HTTP service at 0.0.0.0 port 8069
[2013-04-17 15:09:27,635][?] INFO:web-services:starting HTTPS service at 0.0.0.0 port 8071
[2013-04-17 15:09:27,635][?] INFO:web-services:Registered XML-RPC over HTTP
[2013-04-17 15:09:27,638][?] INFO:web-services:starting NET-RPC service at 0.0.0.0 port 8070
[2013-04-17 15:09:27,638][?] INFO:server:Starting 3 services
[2013-04-17 15:09:27,640][?] INFO:server:OpenERP server is running, waiting for connections...

When I run the openerpclient I get errors as follows

Traceback (most recent call last):
File "C:\OpenERP\Client\bin\openerp-client.py", line 62, in
import gtk
File "C:\Python25\Lib\site-packages\gtk-2.0\gtk\__init__.py", line 38, in
import gobject as _gobject
File "C:\Python25\Lib\site-packages\gtk-2.0\gobject\__init__.py", line 30, in
from gobject.constants import *
File "C:\Python25\Lib\site-packages\gtk-2.0\gobject\constants.py", line 22, in
from _gobject import type_from_name
ImportError: DLL load failed: The specified module could not be found.

Kindly help

pfe2013's picture

hi, I want to install

hi, I want to install Openerp-server (6.0.3) on windows with source. i have already download all python packages; but when I execute

Code: python setup.py install

I have this error:

File "C:\serveur\openerp-server-6.0.3\setup.py", line 269, in
z = zipfile.ZipFile(zipfile_path, 'a')
File "C:\Python25\lib\zipfile.py", line 339, in __init__
self.fp = open(file, modeDict[mode])
IOError: [Errno 2] No such file or directory: 'dist\\library.zip'

PFE's picture

Hi After setting up the

Hi
After setting up the development environment on Windows,
when I come to execute openerp-server.py:
error:

[2013-03-04 11:10:10,776][?] INFO:server:OpenERP version - 6.0.3
[2013-03-04 11:10:10,776][?] INFO:server:addons_path - C:\openerp-server-6.0.3\bin\addons
[2013-03-04 11:10:10,776][?] INFO:server:database hostname - localhost
[2013-03-04 11:10:10,776][?] INFO:server:database port - 5432
[2013-03-04 11:10:10,776][?] INFO:server:database user - Hamdi
[2013-03-04 11:10:10,776][?] INFO:server:initialising distributed objects services
Traceback (most recent call last):
File "C:\openerp-server-6.0.3\bin\openerp-server.py", line 94, in
import report
File "C:\openerp-server-6.0.3\bin\report\__init__.py", line 22, in
import interface
File "C:\openerp-server-6.0.3\bin\report\interface.py", line 32, in
import render
File "C:\openerp-server-6.0.3\bin\report\render\__init__.py", line 22, in
from simple import simple
File "C:\openerp-server-6.0.3\bin\report\render\simple.py", line 27, in
from reportlab.platypus import SimpleDocTemplate, Paragraph, Spacer, Table
ImportError: No module named reportlab.platypus

thanks

pfe2013's picture

hi, I want to install

hi, I want to install Openerp-server (6.0.3) on windows with source. i have already download all python packages; but when I execute
Code: python setup.py install

I have this error: Code:

Traceback (most recent call last):
File "C:\serveur\openerp-server-6.0.3\setup.py", line 269, in
z = zipfile.ZipFile(zipfile_path, 'a')
File "C:\Python25\lib\zipfile.py", line 339, in __init__
self.fp = open(file, modeDict[mode])
IOError: [Errno 2] No such file or directory: 'dist\\library.zip'

thanks

Rami's picture

Hi Fahad, Thanks for the

Hi Fahad,

Thanks for the great article .. I need your help to get the server and the client running without eclipse on windows.
What would be the command to do that.

Thanks,
Rami

fahad's picture

Hi Rami, 1)Use commanfd line

Hi Rami,

1)Use commanfd line and cd to directory of the server.
2)Openerp Server could be started using python openerp-server.py

 

Anonymous's picture

I follow the steps, when i

I follow the steps, when i lunch a debug i have a problems :
I dont understand why i have this problem :'( :
Traceback (most recent call last):
File "C:\Users\slim.slim-PC\Desktop\eclipse\plugins\org.python.pydev_2.6.0.2012062818\pysrc\pydevd.py", line 1392, in
debugger.run(setup['file'], None, None)
File "C:\Users\slim.slim-PC\Desktop\eclipse\plugins\org.python.pydev_2.6.0.2012062818\pysrc\pydevd.py", line 1085, in run
pydev_imports.execfile(file, globals, locals) #execute the script
File "C:\OpenErp\openerp-server-6.0.3\bin\openerp-server.py", line 112, in
service.http_server.init_servers()
File "C:\OpenErp\openerp-server-6.0.3\bin\service\http_server.py", line 233, in init_servers
int(tools.config.get('xmlrpc_port', 8069)))
ValueError: invalid literal for int() with base 10: '8069 (change port here if already allinone setup has been installed,say 8059)'

help me please :'(

fahad's picture

Please remove the round

Please remove the round brackets and their contents, which was meant only for understanding.