Odoo Help


Why cant I import any CSV data into OpenERP V7?

Dean Stickells
on 7/30/13, 12:23 PM 4,418 views

I would like to import some live data into OpenERP in order to properly evaluate it for our small business, I have built a local Ubuntu 12.04.2 LTS server with OpenERP Version 7.0-20130729-231030 but am having problems importing any CSV data into any area of OpenERP.

Initially, I tried to import some customers using the native import function as follows;

  1. Tick the Allow users to import from CSV file box within Settings > General Settings
  2. Select the Sales tab and select customers
  3. Create a dummy customer with the fields that I wish to import populated
  4. Switch to list view, select the dummy customer and select Export from the More menu that appears.
  5. Leave the default options of Import-Compatible Export and CSVformat, select all of the fields that I (ultimately) wish to import and click Export To File.
  6. Copy and paste the data into I want into the exported CSV using LibreOffice (as suggested in another post to prevent problems that Excel may introduce).
  7. Click the Import link (next to the Create button)
  8. Use the dropdown boxes to select the appropriate field for each detected column (I was surprised that the fields were not automatically detected given that they were exported by OpernERP in the first place and another post which suggests that OpernERP V6 has that ability).
  9. Click the Import button

Despite numerous attempts with varying fields, each time I get the same error You must configure at least one field to import despite configuring numerous if not all fields.

Even when limiting the import to just the bare basic customer name, I got the same error message. Another article suggested that one should export the fields that appear blue in the export list as they are mandatory... (even though Receive Messages by Email seems a strange field to be mandatory) and ended up with this file;

"__export__.res_partner_17","Customer One","Incoming Emails and Discussions"

Once again it failed so, I tried to import the file that was output without touching it (I did delete the dummy record first) and again I get the same error message.

I have repeated most of this with the projects list and users list to no avail.

Thanks in advance!

"I got the same error", "I get the same message" - can you share the text of the error - the message will tell others on the forum what is happening and how to fix it.

Ray Carnes
on 7/30/13, 5:11 PM

Thanks Ray - not quite sure how I managed to delete the middle section of the post and not even notice :-/

Dean Stickells
on 7/30/13, 5:39 PM
Dean Stickells
On 7/30/13, 6:27 PM

Aha.... the cause of my woes is Internet ExplorerV9 (I can't comment on other versions as yet).

Whilst trying to upload an image to this post and getting very strange behaviour (It appears to attach but leaves an invalid link) I decided to try Chrome which popped up warning that I didnt have enough Karma.

This made me wonder and sure enough, when trying the import from Chrome, it works absolutely prefectly - even to the point of automatically detecting the field names (which IE failed to show).

My only concern is - what other areas of OpenERP may not be IE compatible? That really could be a showstopper for us as we have a number of Government approved web-apps that are only warranted to run on IE and we wouldnt want to have multiple browsers. I would be very grateful for comments from any other issues resulting from IE?

I cant believe how many hours I have wasted on this issue thanks to good old Microsoft! - I hope that this at least serves to help other people - thanks to those who commented!

Oscar Cascante F
On 7/30/13, 12:43 PM

Hello, you might give more information about how are you trying to do the import. I use pgadmin3 to import csv data to manyu tables in my openerp test database.


Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 7/30/13, 6:11 PM

I was able to import the file you shared into today's build of OpenERP:

image description

image description

The contents of the file I used:

"id","name","notification_email_send"(CARRIAGE RETURN)(LINEFEED)
"__export__.res_partner_17","Customer One","Incoming Emails and Discussions"

About This Community

This platform 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.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 7/30/13, 12:23 PM
Seen: 4418 times
Last updated: 4/22/15, 4:08 PM