Versi PDF atau Pembayaran Lewat Paypal/BCA/Mandiri disini:

http://shop.vitraining.co

OpenERP / Odoo provides an application programming interface using it's XML-RPC webservices. The service is ready to be accessed by any programming language that is capable on communication through XML-RPC interface. This book explain in details on how to setup, configure, and do the integration of external system into OpenERP/ Odoo.

Started with the OpenERP installation steps both for Linux and Windows, then PHP XAMPP installation for both operating systems, and the required preparation steps to take in order that the systems are ready to be integrated together.

Taking PHP as the interfacing scripting languange using it's XML-RPC library, this book explains how to create a PHP class that contains methods for login, search, read, create, delete, and update data stored on OpenERP. Then how to use that class for real life example on accessing a legacy MySQL database and importing the data into OpenERP, and managing the status of already imported data.

PHP provides a wide variety of object oriented frameworks, so this book also explain on how to use the class from inside a PHP framework, taking Yii Framework as an example.

At the end of the topics, it's explained on how to automate the integration process periodically. In Linux we utilize the cron job, and in Windows we use the Task Scheduler.

The book is live, downloadable, and purchasable from Google Play store, but you can also purchase it directly from http://vitraining.com/shop where payment can be made in local Indonesian bank.

About the writer => http://vitraining.com/akhmad-daniel-sembiring/

Table of Contents

Case Study and Objectives

Backgrounds

Objectives

Architecture and Design

The Database Structure

The Scripting Languange

OpenERP Installation on Ubuntu Linux

PostgreSQL Installation

Install the Python Modules

Download the Source Code

Extract the Source Code

Configure and Run the Server

Configure OpenERP to Run as a Service

Apache, MySQL, and PHP Installation on Linux

Installing Apache

Installing MySQL

Installing PHP

PHP Modules

See PHP on the Server

OpenERP Installation on Windows

Download the Latest Installer

Run the Installer

XAMPP Installation for Windows

Download XAMPP

Installation

Testing and Securing XAMPP

Preparations

Create a Development Database

Activate PHP Curl Module

Testing the Curl Module

Installation of XML-RPC Library

Download the XML-RPC Library

Extract the xmlrpc-2.2.tar.gz File

Project Folder Setup

The MyOpenERPLib Class

Login

Search

Read

Create

Delete

Write

Create and Add New Records of one2many Fields

Write and Add More Records of one2many Fields

Write and Change Data on the one2many Fields

Summary

Processing Sales Order Data

Create a MySQL Development Database

Common Database Connection

Importing Partners

Importing Products

Importing Sale Order and Order Lines

Executing Actions on the Server

The exec() Method

The searchAny() Method

Create the Order Confirm Script

Integrating With Yii Framework

Automating the Process

The Wrapper Script

Setup on Linux

Installing wget

Cron Job Setup

Setup on Windows

Installing wget

Task Scheduler Setup

Conclusion

References