Community mailing list archives
Re: import "complex" ods filesby
On Fri, Oct 2, 2015 at 8:52 AM, Fabien MORIN <email@example.com> 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- 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 ?
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 France http://www.tempo-consulting.fr Tel : +33 3 88 56 82 17 Fax : +33 9 70 63 35 46