This question has been flagged
3 Replies
7379 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!

Avatar
Discard

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

Author

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

Author Best Answer

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!

Avatar
Discard
Best Answer

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.

Avatar
Discard
Best Answer

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"
Avatar
Discard