Odoo Help


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


Import multiple elements from csv

on 4/12/13, 10:07 AM 1,750 views

Hello all,

I am trying to use the feature of OpenERP that allow us to import data from .csv. I manage to do it manually, but now I want to be able to call the massive importation of elements from, let's say, a button.

Is there a way to call the importer of csv from code?

Thanks in advance!

What I Want is the following:

When you click in 'Importar' (spanish for import) in the button of the screen in the first image, you are redirected to the screen in the second image:

Import Button :

First Screen

Massive import :

Second Screen

Is there a way to bypass the action and call the second screen directly from a client action like a button press?



| 5 6 8
Cornwall, Canada

Analysing, designing, coding and mentoring since 1975. Kilobytes to terabytes. Punch cards to punchy sites. My OpenERP video series: http://www.youtube.com/playlist?list=PLq7op4J183lX44ZlXPiHxUpRvmmRDtxye My Google Speadsheets --> OpenERP Data Pump project: http://martinhbramwell.github.io/GData_OpenERP_Data_Pump My email (with spaces removed) : mhb . warehouseman @ gmail . com

On 4/12/13, 9:21 PM

I have been working on a tool to connect Google Spreadsheets to OpenERP's XMLRPC port. For standard jobs (like creating databases, installing modules, loading data, etc.) you only need to define what you want to do in a Google Spreadsheet. No Python or XMLRPC knowledge required.

The project is available for download from here (alpha stage still, mind you) : Google to OpenERP Data Pump

I'd be most grateful to anyone who would like to fool around with it and complain about all the stuff that's missing or poorly tested.

I have designed it so that it should be very, very easy to extend with any special functionality you might need; pull requests delightedly reviewed, of course. The downside is -- not much in the way of protections -- the code is probably way more open than a true "plugin" architecture should be. The upside is : it's only a few hundred lines of pretty obvious code. I've tried to document well too.

I hope to add a tutorial video about the pump to this channel sometime next week



| 2 1 4
Buenos Aires, Argentina

Python developer, big fan of sailing

On 4/12/13, 6:38 PM

Yes you could call the importer from code, but it is going to be easier to write a Python script that imports the data into the different objects. You might consider using a library like OERPLib


it will make your job of importing data into multiple classes much easier

Thanks for your response! I already made a script, but additionally I need to do what I post in my question. You claim it is possible to call the screen of the importer directly from client action different than clicking in the "Import" button. Could you tell me how?

on 4/19/13, 11:15 AM
On 4/16/13, 7:24 PM

There is already module, that will import csv data using detailed configuration: ea_import. Hope it helps.

I expected to see a link to the module here :-(

Daniel Reis
on 4/19/13, 11:40 AM

enjoy https://github.com/enapps/ea_import

on 4/19/13, 12:38 PM

Your Answer

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!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

0 follower(s)


Asked: 4/12/13, 10:07 AM
Seen: 1750 times
Last updated: 3/16/15, 8:10 AM