Databases

Odoo Serial Number Tracking Possibilities - Quick Overview

Hi All,

Today I am planning to go through a quick overview on Odoo Serial Number Tracking Possibilities

* We can set Track serial number on products

* Then for each purchase order related Incoming you can add the related serial number for it

Openerp Integration with Joomla Online Admission portal

Joomla is widely used for portals and business websites due to its flexibility and control.
We have created a joomla “component” for online admission which could easily customized to a portal. Forms and fields can be created dynamically without any coding knowledge. This component take cares of all admission procedures including payment.
The task is to synchronise the data in Joomla with OpenERP, this was accomplished by the “connector” written in php which acts as a server for the XML-RPC calls.

Creating Sql Triggers

Introduction

Triggers are sql procedures that are executed on some events like insert, update or delete in a table or view. We can associate sql procedures with trigger so that we can have details like what data did  change during the triggering event. The data can be availed in some other tables if required. I would share you the basuc sql queries to create  and drop a trigger.