Skip to Content
Menu
This question has been flagged
4 Replies
30989 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.

Avatar
Discard
Best Answer

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)

Avatar
Discard
Author

thanks for your little clue, I'll do it

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????!!!

Author

Thanks, solved

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.

I want to generate log after updating data using CSV. How can I do that ??

Best Answer

https://youtu.be/6htDhwSNeb0

Avatar
Discard

Which Odoo version please? It's possible with odoo 10?

Best Answer

Haresh Kansara : can't find external id *odoo 10

Avatar
Discard
Best Answer

Hi,

This module will help you,

https://apps.odoo.com/apps/modules/11.0/scanpet_import/

More information contact : tidyway.in@gmail.com

Thank you,

Rohan

Avatar
Discard
Related Posts Replies Views Activity
3
Jun 20
2854
1
Nov 18
8301
11
Feb 17
62113
2
Mar 15
9927
2
Nov 15
5923