Odoo Help

Welcome!

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.

3

Import multiple elements from csv

By
Lucio
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?

3

Martin

--Martin--
1978
| 5 6 8
Cornwall, Canada
--Martin--

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

Martin
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

1

Gustavo

--Gustavo--
950
| 2 1 4
Buenos Aires, Argentina
--Gustavo--

Python developer, big fan of sailing

Gustavo
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

https://pypi.python.org/pypi/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?

Lucio
on 4/19/13, 11:15 AM
1
nazarii
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

nazarii
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)

Stats

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