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

Question

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

kaynis · Answer

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

Ray Carnes · Answer

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/

Powiązane posty	Odpowiedzi	Widoki
Disable automatic follow when importing res.partner csv import csv	3 cze 20	4073
Enable/disable import rights? import csv	1 lis 18	9536
'utf8' codec can't decode byte error when importing a list of products as a CSV file Rozwiązane import csv	11 lut 17	63881
Import contacts through CSV Rozwiązane import csv	2 mar 15	11022
Import csv file with related field other than id, external id, name import csv importing data from excel file	4 lis 24	11424

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!