- So i've inserted several products with as much as details possible.
- After that, I've selected the fields I was interested in and exported in CSV files (because excel don't work for me).
- Now I have a CSV file with , ; / ;; etc..
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.
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.
" 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)!
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
|Asked: 3/21/13, 8:22 AM|
|Seen: 1799 times|
|Last updated: 3/16/15, 8:10 AM|