Odoo Help

1

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

By
marwen
on 10/19/14, 9:38 AM 1,286 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--
2395
| 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 

About This Community

This platform 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.

Register

Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)

Stats

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