Community mailing list archives

Re: import "complex" ods files

Cristian Salamea
- 10/02/2015 11:48:23

On Fri, Oct 2, 2015 at 8:52 AM, Fabien MORIN <> wrote:
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-

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 ?

Importing data in openerp is basically in plain formats (CSV) and AFAIK only read one sheet, you must put all data in first sheet and import w/o problems.

If you have N sheets for several objects, you must have N files.

Fabien MORIN
TeMPO Consulting
20, avenue de la Paix
67000 Strasbourg
Tel   : +33 3 88 56 82 17
Fax   : +33 9 70 63 35 46 

Post to:

Cristian Salamea on
Cristian Salamea