Odoo

2010年8月15日 (日) 14:56的版本

Tiny ERP 已更名为 Open ERP

The Open Object server, all addons and the application client (GTK) are released under GPL V3.0.

The OpenERP web client is distributed under the “OpenERP Public License” v1.1

Tiny ERP 简介

Tiny ERP 是一款开源的ERP/CRM系统。

它使用Python语言开发，数据库采用开源的PostgreSQL，系统以GNU GPL开源协议发布。

系统提供较灵活的模块架构，常用模块包括：采购管理，销售管理，库存管理，财务管理，货品管理，营销管理，客户关系管理，生产管理，人事管理，服务支持等等。用户可以直接从模块库中选择安装适用模块，或进行模块卸载，升级的管理操作。

客户端用户界面是基于GTK的，同时支持Linux和Windows平台。目前还有开发中的基于TurboGears的eTiny Web客户端,在后续版本会放弃TurboGears，采用性能更高的CherryPy3。

Open ERP 很有创新的项目是 Open Object, 它是一个基于 Python 的企业应用快速开发框架, 这可能是Open ERP最吸引人和最大的亮点 ;)

服务端的 Web Services 设计, 使其支持 SOAP, XML-RPC, NET-RPC , 这样未来能更好的支持 SOA 体系结构。

invoice and a shipping order

服务端工作流引擎的提供使其未来对BPM的支持有更多的期待.

看来 Open ERP 未来会朝 SOA + BPM 大踏步迈进, Open ERP + SOA + BPM = Agility Business

Architecture

Architecture

• OpenERP is a Client/Server system that works over a IP Network.
• OpenERP programming language is Python.

OpenERP 3.0.3 Physical Objects Model

• OpenERP uses Object-Oriented technologies.
• OpenERP records its data with a PostgreSQL relational database.
• OpenERP business objects are modeled with an Object Relational Mapping (ORM) system.
• OpenERP uses GTK for the (client) Human Machine Interface (HMI).
• OpenERP uses ReportLab for report generation in (PDF).
• OpenERP uses XML for several purpose: describing data, view, reports, data transport (XML-RPC)

功能模块

• 客户关系管理(CRM)
• 商业智能(BI)
• 报表引擎
• 事务及请求跟踪
• 财务管理
• 人事管理
• 产品管理
• 库存管理
• 采购管理
• 销售管理
• 生产管理
• 项目管理
• 营销管理
• 电子商务集成
• 工作流引擎
• 与OpenOffice和Microsoft Office的集成

更多 Modules http://openerp.com/component/option,com_mtree/Itemid,111/

Magento

Magento与OpenERP的集成模块

synchronises product catalog and sale orders between OpenERP and the Magento e-commerce platform

http://code.google.com/p/magento-openerp-smile-synchro/

OpenShop

OpenShop与Open ERP的集成

MVC

In Open ERP, we can apply this model-view-controller semantic with

• model : The PostgreSQL tables.
• view : views are defined in XML files in Open ERP.
• controller : The objects of Open ERP.

Install

PostgreSQL

OpenERP Windows分发包包含了PostgreSQL 8.3 数据库引擎.

账户信息: openpg/openpgpwd

CentOS

Open ERP running on Centos 5

psycopg 取得 psycopg http://www.initd.org/pub/software/psycopg/psycopg-1.1.21.tar.gz

$ ./configure –with-postgres-includes = /usr/include/pgsql/server 

checking PostgreSQL version... configure: error: missing PostgreSQL headers

vi cursor.c
removing #if definitions in two places (they where checking for postgres8 ) 
$ make 
$ make install

or psycopg2, Use psycopg2, openerp缺省只认psycopg不认psycopg2

$ cd /usr/src/ 
$ wget http://www.initd.org/pub/software/psycopg/psycopg2-latest.tar.gz 
$ tar -xzvf psycopg2-latest.tar.gz 
$ rm -rf psycopg2-latest.tar.gz 
$ cd psycopg2 
$ python setup.py install

可能需要:

cp -a /usr/local/lib/python2.5/site-packages/psycopg2 /usr/local/lib/python2.5/site-packages/psycopg
wget ftp://xmlsoft.org/libxml2/python/libxml2-python-2.5.0.tar.gz
cd libxml2-python-2.5.0
python setup.py install
updatedb 
locate tinyerp
系统安装到 /usr/local/lib/python2.5/site-packages/tinyerp-server
cd bin
./tinyerp-server.py
or ./tinyerp-server

可能需要：

wget http://downloads.egenix.com/python/egenix-mx-base-3.1.0.tar.gz
python setup.py install

More Detail: http://openerp.com/wiki/index.php/InstallationManual/Installation_Linux/ServerInstallCentOS

Installation Of Open ERP Client, Server And Open ERP eTiny Server On CentOS 5.2

Debian

Install TinyERP 4.2 Server on Debian 4.0

Gentoo

Gentoo2008.0下安装TinyERP 4.2.2 Server手记

Windows

Add a user

 C:\Program Files\PostgreSQL\8.3\bin>createuser.exe --createdb --username postgres --no-createrole --pwprompt openuser

创建数据库: openerp

First time run with demo data

C:\Program Files\OpenERP Server\server\openerp-server.exe -d openerp -r openuser -w openuser
--db_host=localhost --logfile="C:\Program Files\OpenERP Server\openerp-server.log"
--db_port=5432 -s  --stop-after-init --init=all

运行客户端: admin/admin demo/demo http://doc.openerp.com/install/windows/index.html

Business Intelligence

Open ERP BI

The cube will use:

Drill Down on a Member

• SQLAlchemy for all database communications
• XML-RPC for his external interfaces
• PyParser for MDX parsing

more detial: http://doc.openerp.com/bi/index.html

OpenOffice

OpenOffice.org reports internal process

• OpenOffice.org reports

Community

Open ERP Community Process

• Code Contribution

Code Contribution

• Bug Tracker

Bug Tracker

• Discuss Efficiently

Discuss Efficiently

• Documentations

Documentations

• Translations

Translations

Module

The structure of a module should be like this:

   /module/

       /__init__.py 
       /__terp__.py 
       /module.py 
       /module_other.py 
       /module_view.xml 
       /module_wizard.xml 
       /module_report.xml 
       /module_data.xml 
       /module_demo.xml 
       /wizard/ 
       /__init__.py 
       /wizard_name.py 

   /report/

       /__init__.py 
       /report_name.sxw 
       /report_name.rml 
       /report_name.py

常用模块:

• CRM & SRM
• Sales
• Business Intelligence Better decisions make better business!
• Business Process Management
• Reporting
• Accounting and Financial
• Asterisk VOIP
• E-Commerce
• Human Resources
• Manufacturing Resource Planning
• Product
• Project Management
• Stock Management
• Dashboard
• C2C
• Health Management
• Hotel Management
• Magento
• Portal
• Purchase Management
• Document Management
• Point Of Sale
• Subscription Control

.......

more modules: http://doc.openerp.com/modindex.html

modules download: http://www.openerp.com/download/modules/

Cluster

./balance 8070 serveur_1:8069 serveur_2:8069

http://www.inlab.de/balance.html

Security

openerp-server.conf

secure_pkey_file = server.pkey // RSA PRIVATE KEY
secure_cert_file = server.cert

OpenSSL

OpenSSL.crypto
OpenSSL.rand
OpenSSL.SSL

Projects

• CentERP

中文化

• http://wiki.shine-it.net
• OpenERP 软件的中国社区贡献模块集合

Links

• http://www.openerp.com
• OpenERP On Demand http://www.odoo.com/
• http://www.openobject.com/
• http://www.ohloh.net/projects/4314
• https://launchpad.net/openerp
• http://tinyforge.org/
• http://wiki.shine-it.net 中文文档
• http://sourceforge.net/projects/tinyerp
• http://docs.huihoo.com/openerp/
• http://download.huihoo.com/openerp/
• http://openerp.fav.im/