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

How convert excel file to csv file to import it in odoo ?

By
marwen
on 10/19/14, 9:38 AM 1,102 views

I need to import a invetory file that have many columns an example of a table in excel format that have many papers, to the odoo interface exactly to the configuration of inventory . and please give an tutorial to how import the csv file in the correct format without any lose od details !

0

Ludo - Neobis

--Ludo - Neobis--
2387
| 2 2 5
Hoogvliet, Netherlands
--Ludo - Neobis--

Developer

Ludo - Neobis
On 10/20/14, 5:40 AM

Well, if you can find the appriopriate object that you need the CSV import for, you can use the exporter to create "an import compatible" CSV file that already has the right columns for your import.

Just select all the columns from the list that you absolutely need in your new situation, along with the purple mandatory columns from Odoo and you should be able to import without any trouble.

0

Bole

--Bole--
2385
| 5 4 6
Zagreb | Karlovac, Croatia
--Bole--

there is only 10 kind of people the ones that understand binary ... and others

Bole
On 10/20/14, 9:41 AM

Easy way is using openoffice or libreoffice.. (free versions of m$$ excell)

Just open csv file (or create new ods file) 

edit the data ,and finaly export it via Save As (csv) menu..

Remember to edit filter settings, an turn on "Quote alltext fields"

 

Now you should have cvs ready for import.. 

Hope it helps 

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

1 follower(s)

Stats

Asked: 10/19/14, 9:38 AM
Seen: 1102 times
Last updated: 3/16/15, 8:10 AM