Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Update data by import via .csv files?

import csv update

4 Vastaukset

33268 Näkymät

bakulnet

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.

Davide Corio

Paras vastaus

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)

bakulnet

Tekijä

thanks for your little clue, I'll do it

sales

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

bakulnet

Tekijä

Thanks, solved

Felipe

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.

M M Shahriar Amin

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

Haresh Kansara

https://youtu.be/6htDhwSNeb0

Maroua ROMDHANE

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

Wimpy

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

TidyWay

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

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
Disable automatic follow when importing res.partner csv import csv	3 kesäk. 20	5066
Enable/disable import rights? import csv	1 marrask. 18	10525
'utf8' codec can't decode byte error when importing a list of products as a CSV file Ratkaistu import csv	11 helmik. 17	65210
Import contacts through CSV Ratkaistu import csv	2 maalisk. 15	12309
Don't import csv file import xml csv update noupdate	2 marrask. 15	7540

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!