Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi everyone,
What do I need to do to open it clearly on excel? And after that, how to import this new list with many products added?
I cannot add my CSV file here but I can send it in PM if needed.
Thank you!
Just open excel (or any other option like LibreOffice Calc) and go to File/Open and select your .csv file
A wizard will be launched where you will be able to select the desired separators for rows/columns and that is it, the program will do all the work.
I use " as text delimiter, ; as separator and 'UTF-8' as encoding.
You can also select in a previous that will see every column and select the type of it (e.g. date, text).
This works for me using LibreOffice Calc, it might be suitable for you to, but maybe you have to change a few details, but the overall picture looks the same.
After that, to save the file again as a .csv to import into OpernERP, just go to 'File/Save as...' and select .csv where it says file format (or something like that, the place where you can choose the extension of the file).
Hope it is the same with Excel (or at least that you can figure it out from this tips)!
Dear Lucio, thank you for your quick answer. I'm a little further...
But when I validate import on openERP (utf-8) , (Semicolon) , (") I have this red line "incorrect padding"
Ok, great! Can you please add some of the csv to your question to see where the problem can be coming from? (Obfuscate the data if you want! )
You are using ' / ' (slash) as separator, not ' ; ' (semicolon).
Sorry but I need to use (comma) as separator when I import on openerp. If I use semicolon I only have one column "A single column was found in the file, this often means the file separator is incorrect "
Dear Lucio, thank you for your quick answer. I'm a little further...
But when I validate import on openERP (utf-8) , (Semicolon) , (") I have this red line "incorrect padding"
Ok, I see and seems right but the csv line that you copy-pasted here is using ' / ' as separator, not comma, maybe it is a bug on the openERP exporting tool or something.
Also, in the preview in the, where you can set the type of each column, you are getting the correct view as it is. What happens if you change 'Virgule' for another thing (like 'point-virgule' for example)?
Maybe because I am still on the trial version? I've inserted more images...
OK it works !
I followed your steps and used openoffice and I can Import/Export everything :-D (i'm very happy)
You can mark it as answered then :D
Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!
Rekisteröidy
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
