New EBook: Advanced PHP and OpenERP (Odoo) 7 Interfacing: Using PHP XML-RPC Library
How to push MySQL database using PHP XML-RPC to OpenERP (Odoo) server’s web service.
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.
After the data is being imported successfully, in many cases we need to execute further actions necessary for the data, like confirming, posting, validating, etc. The book also explain how to execute server actions using object method and workflow actions.
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://shop.vitraining.com 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
Architecture and Design
The Database Structure
The Scripting Languange
OpenERP Installation on Ubuntu Linux
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
See PHP on the Server
OpenERP Installation on Windows
Download the Latest Installer
Run the Installer
XAMPP Installation for Windows
Testing and Securing XAMPP
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
Create and Add New Records of one2many Fields
Write and Add More Records of one2many Fields
Write and Change Data on the one2many Fields
Processing Sales Order Data
Create a MySQL Development Database
Common Database Connection
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
Cron Job Setup
Setup on Windows
Task Scheduler Setup