Community mailing list archives

community@mail.odoo.com

Re: Import Error Issue on Rel 9 Enterprise editition

by
Moxylus, Aris Corpuz
- 11/24/2015 17:43:43
Hi Suhendri,

In most cases, I generate a csv file gets first, by exporting 1 record from a list view, to get the column headings.

Then I populate the file directly with Excel, then save the file as a csv file, which gets imported into Odoo.

Have not had a problem following this approach in the past. I use Excel 2013 on Windows 8.

Thanks for the feedback.

Aris


Aris Corpuz | Implementation Partner 
moxylus philippines
mobile +63 917.693.8520
aecorpuz@moxylus.com moxylus.com

On Tue, Nov 24, 2015 at 2:34 PM, Suhendri Wijaya <hok.kwang@gmail.com> wrote:

Hi Aris,


I face similar problem before when using office for mac 2011 to export the csv files then I try to use other app to export the csv files, which I use pages to do it and the problem is solved. And recently after I upgrade to office for mac 2016, exported csv is import compatible for odoo. 

So what I can recommend is try to use other app to export the csv fle if your current version of excel export not successful and make sure it is utf-8.

Best Regards,
黄福侊
Suhendri Wijaya



On Nov 25, 2015, at 05:22, Ray Carnes <ray.carnes@bistasolutions.com> wrote:

OK, there is something buggy happening.




 

I exported both attached files using Import-Compatible export, just the CODE field from the default US Chart of Accounts.




The XLS imports fine, while the CSV gives a similar error than what you posted – cutting short the name of the code column in the message:




 

Import preview failed due to: Unsupported format, or corrupt file: Expected BOF record; found '"id","co'.




 

(the column name is CODE, the export came from Odoo, it is correctly encoded as UTF8)




 

I didn’t try the Community Edition, all my work is with Enterprise! J




Ray.



 


From: Aris Corpuz [mailto:aecorpuz@moxylus.com]
Sent: Tuesday, November 24, 2015 1:28 PM
To: Community <community@mail.odoo.com>
Subject: Re: Import Error Issue on Rel 9 Enterprise editition




 

Hi Ray,



 

Have tried that too - importing the csv file with Excel not having been started.



 

I made sure Excel was not running, then imported the csv file from the Accounting -> Adviser -> Chart of Accounts list view. As soon as the file was chosen (to be imported), the error message appears.



 

That was from the Enterprise edition of Rel 9. 



 

Following the same process on the Rel 9 Community version, with Excel running, the same csv file is imported successfully. 



 

Was asked about the xlrd on our instance and I provided this screenshot.



 

ubuntu@ip-172-31-26-218:~$ python



Python 2.7.6 (default, Jun 22 2015, 17:58:13)



[GCC 4.8.2] on linux2



Type "help", "copyright", "credits" or "license" for more information.



>>> import xlrd



>>> print xlrd.__VERSION__



0.9.2



>>> exit



Use exit() or Ctrl-D (i.e. EOF) to exit



>>>

 

ubuntu@ip-172-31-26-218:~$




 

Thanks for your feedback, Ray.




 

Aris




 




 

Aris Corpuz | Implementation Partner 
moxylus philippines
mobile +63 917.693.8520
aecorpuz@moxylus.com | moxylus.com



 

On Tue, Nov 24, 2015 at 10:47 AM, Ray Carnes <ray.carnes@bistasolutions.com> wrote:


I have seen this error when the CSV file is open in an Editor that locks the file (such as Excel).


 

Be sure to close the file if it is open in other programs. 


 

You can also try Excel import/export– I’ve had that work flawlessly so far.



Ray.


 


From: Aris Corpuz [mailto:aecorpuz@moxylus.com]
Sent: Tuesday, November 24, 2015 10:03 AM
To: Community <community@mail.odoo.com>
Subject: Import Error Issue on Rel 9 Enterprise editition


 

Hi Team, 


 

We are facing an issue when trying to import data into Odoo Enterprise v.9. I used the attached install script to install Odoo. 


 

When attempting to import .csv files we get the following error: import preview failed due to: unsupported format, or corrupt file: Expected BOF record; found "id,name\r". For CSV files, the issue could be an incorrect encoding"


 

We get this error even when exporting an import compatible file out of Odoo and immediately attempting to import it without editing it. 


 

Has anyone experienced this issue before or know of a solution to fix it? We have already tried the different encoding options in the menu, and not having the file open in excel while importing. 


 

Your help would be very much appreciated. 



Thank you, 


 

 

Aris Corpuz | Implementation Partner 
moxylus philippines
mobile +63 917.693.8520
aecorpuz@moxylus.com | moxylus.com


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe



 

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

<account.account.xls><account.account.csv>

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe