Tricks to Import Huge Amount of Data Into Odoo in Seconds

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