I want to import excel file in openerp how to ?
I have binary field where I have save excel file. now button click I want to import data from excel to field which in my form view.
I need to parse excel and convert to dict then will do write.
but any good feature with in openerp?
You can define on_cnange method, what would process uploaded file.
<field name="excelfile" on_change="on_file_load(excelfile)"/>
You need to write parsing method in your *.py file
def on_file_load(self, cr, uid, ids, excelfile, context=None): #do_something
In this case file would be parsed before you save object.
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!