Community mailing list archives

community@mail.odoo.com

Re: import "complex" ods files

by
richard achatz
- 10/02/2015 10:11:29
Have you tried https://github.com/djfm/ods2csv ?
i've tested it some time ago and it looks fine.

Am 2. Oktober 2015 15:52:47 MESZ, schrieb Fabien MORIN <fabien.morin@tempo-consulting.fr>:
Hi all,

I'm trying to import an ods document into an odoo module. As I read, it is 
quit simple to convert it to csv and import the csv file. That's working for 
the simple case.

What I don't know is how to import an ods file which contains many sheets (400 
in my case) each sheet representing an object and each line in the sheet 
representing a sub-object. (the columns represent the properties of each sub-
object).

Converting such an ods file to csv with libreoffice give me an advertisement 
claiming that only the active sheet will be converted (so I have to do it 
manually 400 times). Is there another way to import such file ?
A solution could be to accept ods in addition to csv files for odoo import, 
this would avoid converting task for people working with ods and make possible 
to import multi-sheets files. Does something like that already exists ?

-- 
Fabien MORIN
TeMPO Consulting
20, avenue de la Paix
67000 Strasbourg
France

http://www.tempo-consulting.fr
Tel   : +33 3 88 56 82 17
Fax   : +33 9 70 63 35 46 

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


--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.

Email sent using Axigen Free Mail Server:
http://www.axigen.com/mail-server/free