Odoo Help

Welcome!

This community 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.

0

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

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

Hi,

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..

Thansk

1
kaynis
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

1

Ray Carnes

--Ray Carnes--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

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. 

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.

https://doc.openerp.com/book/8/8_20_Config/8_20_Config_import_export/#importing-csv-data-to-openerp

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

Jasad
on 12/19/13, 2:49 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)

Stats

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