Odoo Help

Welcome!

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

1

Why cant I import any CSV data into OpenERP V7?

By
Dean Stickells
on 7/30/13, 12:23 PM 3,389 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;

"id","name","notification_email_send"
"__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.

Bista Solutions US, 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
1
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!

0
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.

0

Ray Carnes

--Ray Carnes--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

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. 

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"

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

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