Tricks to Import Huge Amount of Data Into Odoo in Seconds

Tricks to Import Huge Amount of Data Into Odoo in Seconds, available at $44.99, has an average rating of 4.55, with 44 lectures, based on 46 reviews, and has 382 subscribers.

You will learn about 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 This course is ideal for individuals who are Odoo Developer or Odoo Consultant or Odoo Implementor or Odoo Official Partner It is particularly useful for Odoo Developer or Odoo Consultant or Odoo Implementor or Odoo Official Partner.

Enroll now: Tricks to Import Huge Amount of Data Into Odoo in Seconds

Summary

Title: Tricks to Import Huge Amount of Data Into Odoo in Seconds

Price: $44.99

Average Rating: 4.55

Number of Lectures: 44

Number of Published Lectures: 44

Number of Curriculum Items: 44

Number of Published Curriculum Objects: 44

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

Odoo Developer

Odoo Consultant

Odoo Implementor

Odoo Official Partner

Target Audiences

Odoo Developer

Odoo Consultant

Odoo Implementor

Odoo Official Partner

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 !

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Download Resources

Lecture 3: Background

Lecture 4: Case Study

Lecture 5: Restore Sample Database

Lecture 6: Datasource Analysis

Lecture 7: Datasource Mapping

Lecture 8: Initial Specification

Chapter 2: Method 1: PHP Middleman

Lecture 1: PHP Middleman Explanation

Lecture 2: Download Ripcord Library

Lecture 3: PHP Script Main Logic

Lecture 4: Pull Employee Data

Lecture 5: Push to Odoo

Lecture 6: Test and Run

Lecture 7: Method 1 Result

Chapter 3: Method 2: Direct SQL

Lecture 1: Direct SQL Explanation

Lecture 2: Install MySQL Connector for Python

Lecture 3: Create Addon

Lecture 4: Create Wizard Model

Lecture 5: Create Wizard View

Lecture 6: Test and Install Addon

Lecture 7: The Import Logic

Lecture 8: Establish MySQL Connection

Lecture 9: Pull Department Data

Lecture 10: Push Department to Odoo

Lecture 11: Pull Employee Data

Lecture 12: Push Employee to Odoo

Lecture 13: Method 2 Result

Chapter 4: Method 3: Stored Procedure

Lecture 1: Store Procedure Explanation

Lecture 2: Modify Create Department Method

Lecture 3: Import Department Stored Function

Lecture 4: Import Department Stored Function Part 2

Lecture 5: Modify Create Employee Method

Lecture 6: Create Employee Stored Function

Lecture 7: Test the Create Employee Stored Function

Lecture 8: Integrate, Upgrade Addon and Run

Lecture 9: Method 3 Test Result

Chapter 5: Filtering Record

Lecture 1: The last_update Field

Lecture 2: Troubleshoot and Testing

Chapter 6: Update or Create Record

Lecture 1: Create Update Feature

Lecture 2: Testing the Update Feature

Chapter 7: Automating the Process

Lecture 1: Create Cron Scheduler

Lecture 2: Test the Cron Scheduler

Chapter 8: Conclusion

Lecture 1: Final Conclusion

Instructors

Akhmad Daniel Sembiring
15+ Years of Programming Experience

Rating Distribution

1 stars: 0 votes

2 stars: 2 votes

3 stars: 6 votes

4 stars: 13 votes

5 stars: 25 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!