Skip to Content
This question has been flagged
crmbackup
1 Reply
3852 Views
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
Discard
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
Discard
Alejandro Perez Cosio
Author

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

Related Posts Replies Views Activity
CRM - Create autoresponse if new lead was created via Mail
crm
Avatar
Avatar
2
May 25
1250
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
Jul 25
64673
Get Map View in Odoo CRM based on lead address instead of contact address
crm
Avatar
Avatar
1
Apr 25
1147
CRM management
crm
Avatar
0
Mar 25
1327
Feature request - Assign multiple teams to a stage in the pipeline
crm
Avatar
0
Mar 25
1200