Installation Procedure for OpenERP

Installation procedure for Production

 
Install and configuration of database server , POSTGRESQL

Step 1: Double-click on the given deb file & install.
Step 2: Open the terminal – ctrl+alt+(t) and execute the following commands 

     
           sudo apt-get install postgresql

           sudo su postgres -c 'createuser --createdb --username postgres --no-createrole --pwprompt openerp'
         
Type  your own user password for the database role as - 'postgres'
When it ask’s 'Shall the new role be a superuser?' type – ‘Y’  

Step 3: Type 'localhost:8069' in web browser.
Step 4: Click on 'Manage Databases', type in 'admin' as master password, enter a database name, choose a language, a admin password, repeat the same and hit create.

NOTE:
1.    Download link - http://nightly.openerp.com/6.1/releases/openerp_6.1-1-1_all.deb
2.    To add your custom module
Copy your module to home folder and type the following in terminal

sudo mv your_module_name /usr/lib/pymodules/python2.7/openerp/addons/

sudo chmod 777 /usr/lib/pymodules/python2.7/openerp/addons/your_module_name

Installation procedure for development

For Server/ Pre-install steps
Step 1: Copy the 'OpenERP' folder to your Home folder.
             Open the Terminal – ctrl+alt+(t)
Step 2: Enter The following commands in the Terminal
            
             sudo apt-get update

             sudo apt-get upgrade

Now it’s ready to start the Open ERP install.

  Install the necessary python Libraries for the server

Step 1: Install dependent Python Modules.Open the terminal and                  execute the commands.

sudo apt-get install python-dateutil python-feedparser python-gdata \
python-ldap python-libxslt1 python-lxml python-mako python-openid python-psycopg2 \
python-pybabel python-pychart python-pydot python-pyparsing python-reportlab \
python-simplejson python-tz python-vatnumber python-vobject python-webdav \
python-werkzeug python-xlwt python-yaml python-zsi python-reportlab-acce python-openssl \
python-egenix-mxdatetime python-unittest2 python-mock

Installation of Postgresql

Step 1: sudo apt-get install postgresql
                sudo su postgres -c 'createuser --createdb --username postgres --no-createrole --pwprompt openerp'

Type  your own user password for the database role as - 'postgres'
When it ask’s 'Shall the new role be a superuser?' type – ‘Y’  

Step 2: cd ~/OpenERP/stable6.1/server/
                           ./openerp-server  --addons=../6.1/,../openerp-web6.1/addons
 
Step 3: Type 'localhost:8069' in web browser.
Step 4: Click on 'Manage Databases', type in 'admin' as master password, enter a database name, choose a language, a admin password,repeat the same and hit create.

Note - If you get the error 'no handler found',then go to the folder '6.1' and remove the modules 'stock' and 'mrp' from there and keep them as backup.

 

Architecture of Open ERP

Client-Server Architecture

Open ERP has separate client server components.

The server runs separately from the client. It handles the business logic  and communicates with the database application.

The client presents information to users and allow them to inter-operate with the server.Multiple client application is available.

Server and Modules:
Server part is written in Python programming language. The client communicates with server using XML-RPC interface.
Business functionality is organized into modules. A module is a folder with a pre-defined structure containing Python code and XML files. A module defines data structure, forms, reports, menus, procedures, workflows, etc... Modules are defined using a client-independent syntax. So, adding new objects, such as menus or forms, makes it available to any client.

Client Applications:

Two Client applications are : 

• A web Application which is deployed as an HTTPserverto allow users to connect using web browser. 
• Desktop application written in Python which uses GTK tool Kit(Graphics tool Kit)

DataBase:
OpenERP uses PostgreSQL as database management system.
Postgres, is an object-relational database management system (ORDBMS)
Reporting:
OpenERP also provides a reporting system with OpenOffice.org integration allowing customization of reports.
OpenOffice.org whose main components are for word processing, spreadsheets, presentations, graphics, and databases.

Overview of OpenERP

Open ERP is an open source integrated Enterprise Resource Planning(ERP) software manufactured by OpenERP s.a.

Open Source is a philosophy, that promotes free redistribution and access to an end product's design and implementation details.

Open Source software is software whose source code is published and made available to public, enabling anyone to copy , modify and redistribute the source code with out paying the fees

Examples:

7-Zip — file archiver ,Blender — 3D graphics editor ,Eclipse — development environment comprising an IDE ,GIMP — graphics editor ,Mozilla Firefox — web browser,OpenOffice.org (and the LibreOffice fork) - office suite

Programming languages:  PERL,PHP,Python, Ruby

Enterprise Resource Planning

 ERP systems integrate internal and external management information across an entire organization, embracing finance/accounting, manufacturing, sales and service, customer relationship management, etc. ERP systems automate this activity with an integrated software application. Their purpose is to facilitate the flow of information between all business functions inside the boundaries of the organization and manage the connections to outside stakeholders.

ERP systems initially focused on automating back office functions that did not directly affect customers and the general public. Front office functions such as customer relationship management (CRM) dealt directly with customers, or e–business systems such as e–commerce, e–government, e–telecom, and e–finance, or supplier relationship management (SRM) became integrated later, when the Internet simplified communicating with external parties.

Characteristics Of ERP:

• an integrated system that operates in real time (or next to real time), without relying on periodic updates 
•  A common database, which supports all applications. 
•  A consistent look and feel throughout each module. 
•  Installation of the system without elaborate application/data integration by the Information Technology (IT) department.

Finance/ Accounting : General ledger, payables, cash management, fixed assets, receivables, budgeting, consolidation

Human resources :Payroll, training, benefits, recruiting, diversity management

Manufacturing :Engineering, bill of materials, work orders, scheduling, capacity, workflow management, quality control, cost management, manufacturing process, manufacturing projects, manufacturing flow, activity based costing, product life cycle management.

Project management :Costing, billing, time and expense, performance units, activity management