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

Update data by import via .csv files?

By
bakulnet
on 3/24/13, 10:45 PM 4,930 views

Is there a way to update customer data by import via .csv files? I have problems with it, as long as i know import .csv only create new data instance, not update.

1

Davide Corio

--Davide Corio--
1822
| 4 3 7
Bricherasio, Italy
--Davide Corio--

Odoo Evangelist and Consultant

Davide Corio
On 3/25/13, 7:07 AM

You have to specify the "id" column (postgresql or xml internal id) for openerp to update existing data instead of creating new record.

Try to export the list of customers, including the ID column. Then you have a CSV you can use to update records by reimporting the same file (previously updated but keeping the ID column untouched)

thanks for your little clue, I'll do it

bakulnet
on 4/19/13, 9:58 AM

Tried. Difficult to use. Starting to feel annoy. Tried to import client's details, don't seems to have import function. Tried to import invoices, "No matching record found for name 'XXX' in field 'xxx' at row x. Get all possible values. Tried to import products, same thing. What's wrong????!!!

sales
on 5/16/13, 6:42 AM

Thanks, solved

bakulnet
on 5/17/13, 9:22 AM

It works when I updated a char field, but when I try to update a many2one Field it does not change anything, I tried with the id, external id and name of that many2one field without success.

Felipe
on 2/13/14, 6:44 PM

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

1 follower(s)

Stats

Asked: 3/24/13, 10:45 PM
Seen: 4930 times
Last updated: 3/16/15, 8:10 AM