Odoo Help


How to import record with ID that I passed in CSV file

Jagdish Panchal
on 8/30/13, 2:02 AM 1,693 views


I want import data using CSV file in res_partner table, i create CSV file like

id, name 1001, jnp

But record created with other ID, i want created record with ID that i passed in CSV is it possible..



Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 8/31/13, 2:38 AM

You can create your own External ID's for the system. This is exactly the reason the External ID field was created.

Map the field ontaining the ID you'd like to use to External_ID.

OpenERP will first check to see if a record with the same External ID exists. If it does, your import will be used to update a record. If it does not, your import will be used to create a record.

Refer to the documentation, and the help on the form where you import, for more direction.


use the csv data like this : id, name -> res_patner_01 , ABCD

on 12/19/13, 2:49 AM
On 8/30/13, 4:56 AM

No you cannot create your own ids for the system. You have to let the system create them it is actually safer that way. You can always export the data created to retrieve the ids afterwards. Leave the id column blank and OpenERP will assign ids to each line as needed

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 8/30/13, 2:02 AM
Seen: 1693 times
Last updated: 3/16/15, 8:10 AM