Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Tricks to Import Huge Amount of Data Into Odoo in Seconds

person icon Akhmad Daniel Sembiring

4.3

Tricks to Import Huge Amount of Data Into Odoo in Seconds

Regularly import million of external records FAST!

updated on icon Updated on Apr, 2024

language icon Language - English

person icon Akhmad Daniel Sembiring

English [CC]

category icon Odoo,PostgreSQL,Development,Database Design & Development

Lectures -44

Duration -3 hours

4.3

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

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

Using the common standard way, 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, which 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 millions of records per day!

Enjoy!

Who this course is for:

  • Odoo Developer
  • Odoo Consultant
  • Odoo Implementor
  • Odoo Official Partner

Goals

What will you learn in this course:

  • 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

Prerequisites

What are the prerequisites for this course?

  • Odoo Addon Fundamental
  • Odoo XMLRPC Fundamental
  • Python Language
  • SQL Fundamental
Tricks to Import Huge Amount of Data Into Odoo in Seconds

Curriculum

Check out the detailed breakdown of what’s inside the course

Introduction
8 Lectures
  • play icon Introduction 00:43 00:43
  • play icon Download Resources
  • play icon Background 03:15 03:15
  • play icon Case Study 02:38 02:38
  • play icon Restore Sample Database 03:38 03:38
  • play icon Datasource Analysis 02:02 02:02
  • play icon Datasource Mapping 02:10 02:10
  • play icon Initial Specification 00:50 00:50
Method 1: PHP Middleman
7 Lectures
Tutorialspoint
Method 2: Direct SQL
13 Lectures
Tutorialspoint
Method 3: Stored Procedure
9 Lectures
Tutorialspoint
Filtering Record
2 Lectures
Tutorialspoint
Update or Create Record
2 Lectures
Tutorialspoint
Automating the Process
2 Lectures
Tutorialspoint
Conclusion
1 Lectures
Tutorialspoint

Instructor Details

Akhmad Daniel Sembiring

Akhmad Daniel Sembiring

e


Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515