What you'll learn

Techniques to import external data into Odoo fast
Using XMLRPC Standard
Using Direct SQL
Using Stored Procedure PL/PGSQL
Automating the Import Process
Filtering Record to Import

Requirements

Odoo Addon Fundamental
Odoo XMLRPC Fundamental
Python Language
SQL Fundamental

Description

Do you have Odoo implementation cases to regularly import a huge amount of data from external data source like MS SQL, Oracle, MySQL, etc? I meant, very huge, like million of invoices or journal entries record per day ?

Using the common standard way, the Odoo's XMLRPC and ORM, this process can take hours, if not timeout, while we are taking a few cups of coffee as Odoo suggests :)

This course explains in detail about techniques to improve the data import performance, starting from data source query, processing in Python, and processing in Odoo Database (PostgreSQL) to achieve a drastic performance increase, that was previously taking more than 10 hours to only seconds! Yes, seconds.. how can it be ? Is that possible ?

YES

And we have implemented this technique in many implementation cases where Odoo's default mechanism is no more capable to handle that million of records per day!

Enjoy !

Who this course is for:

Odoo Developer
Odoo Consultant
Odoo Implementor
Odoo Official Partner