How to use self.env.cr.copy_from function to save data in database - BOOKC -->

How to use self.env.cr.copy_from function to save data in database

Wednesday, October 2, 2019

In this tutorial I will show you how to save or insert data into the database table using odoo "copy_from" function. Odoo provide this "copy_from" function in "self.env.cr" (current database courser).




How to use self.env.cr.copy_from function to save data in database

What does self.env.cr.copy_from do?

The copy_from function takes almost four parameters.

  1. CSV File: Takes content that need to be stored into the database table
  2. Table Name: Name of the table, where to stores the CSV content
  3. Separator: Symbol that distinguish between columns e.g. (|,;,etc)
  4. Column: Column of the table in which CSV data to be inserted


What we are going to do?

We are going to save or insert CSV data into the table using "self.env.cr.copy_from". To do this we need to do following activity.

  1. Create table using "self.env.cr.execute"
  2. Open CSV file 
  3. Create list of column (fourth parameter of "copy_from" function)
  4. Copy CSV data into table using "self.env.cr.copy_from"
  5. Close CSV file


How to use self.env.cr.copy_from function to save data in database