Skip to Content
This question has been flagged
crmbackup
1 Odpoveď
3954 Zobrazenia
Avatar
Alejandro Perez Cosio

Dear all,

I would like to backup all my customers from odoo but just customers (name, company, tags, phone, mobile, street, etc..).

I tried to use the export tool but I don't get the company field nor creation_date, etc.. 

I think I will use postgres from the command line to do this task table by table, but before I would like to ask if you don't know any tool better than export from odoo to do something like this..

Thank you and regards!

Avatar
Zrušiť
Avatar
Michael Thomas
Best Answer

It is strange that you didn't get the company field. When I go and use the csv export I see all the fields, including company and "Created on". If there are any fields that you can't see, changing the export type to "import-compatible export" should fix your problem. Make sure that you are exporting from a view of the customers, and not some other view (ie. your in the products view).

You definitely shouldn't have to use PostgreSQL and do a bunch of joins to get your data. Try going to customers, selecting all and going to export again.

Avatar
Zrušiť
Alejandro Perez Cosio
Autor

"Export all data" worked for me, there is also the parent which points the company.. Thank you Michael!

Related Posts Replies Zobrazenia Aktivita
Comment activer notification pour odoo CRM
crm
Avatar
Avatar
Avatar
2
aug 25
643
CRM - Create autoresponse if new lead was created via Mail
crm
Avatar
Avatar
2
máj 25
1539
Database backup error: Postgres subprocess ('/usr/bin/pg_dump', '--no-owner', '--file=/tmp/tmpAa0O5Q/dump.sql', u'ahlain_db01') error 1 Solved
backup
Avatar
Avatar
Avatar
Avatar
Avatar
9
júl 25
65370
Get Map View in Odoo CRM based on lead address instead of contact address
crm
Avatar
Avatar
1
apr 25
1473
CRM management
crm
Avatar
0
mar 25
1476