Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
3 Răspunsuri
3818 Vizualizări

I have 5000 locations on Odoo.
I would like to update an individual field from all these locations (from a CSV file)
All other fields/data from the locations will remain the exact same, but there is one specific field within each location that must be changed.

Whenever I try to import the CSV File, even though all the names, parent fields match, odoo just creates duplicate locations from the import,
Instead of updating the existing locations with the updated fields :(

I have already ticked the option "Allow matching with subfields" but it did not work.
I also couldn't find any other option that seemed to work for this

Imagine profil
Abandonează
Cel mai bun răspuns

Have you including the external id, with your fields in the CSV file?

Imagine profil
Abandonează
Cel mai bun răspuns

Hello Jaime Matos,

You only need the field you want to update and external id for update the record. Without having external id, Odoo will create new record. 

Please check below screen-shot and steps,



You may follow below steps in order to update field for locations.

  • Select locations for which you want to update the field, select field you want to update
  • Export it using Actions menu, make sure you enabled the option "I want to update data (import-compatible export)"
  • Make changes in the field you want to update
  • Import the file 

Thanks & Regards,



CandidRoot Solutions Pvt. Ltd.

Mobile: (+91) 8849036209
Email: info@candidroot.com
Skype: live:candidroot
Web: https://www.candidroot.com
Address: 1229-1230, Iconic Shyamal, Near Shyamal Cross Road, Ahmedabad, Gujarat 380015
    


Imagine profil
Abandonează
Cel mai bun răspuns

You have to use external id of the location rather than location name while importing. 

Ideally, you only need 2 columns in the excel which you are importing. One is the external id and other is the field which you want to update. 

Imagine profil
Abandonează