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.

1

Can I transfer data from/to a Google Spreadsheet and Odoo?

By
Diogenes Ojeda
on 6/21/14, 10:10 AM 1,765 views

Hello everyone:

My primary concern is whether I can feed data into a google spreadsheet from openerp and vice versa.

But I find no documentation.

I found this: http://martinhbramwell.github.io/GData_OpenERP_Data_Pump/

I do not know if there really taught how to do what I want.

If anyone has more documentation to appreciate the share.

thanks

Do you want to move data back and forth with Python or are you ok with CSV files?

Martin
on 6/21/14, 2:08 PM

Hello, thanks. Do not know what you mean exactly. What I want is to work locally in OPENPERP and then updating a list or spreadsheet of Google Drive with these data, and vice versa. I have seen out there that can, but does not explain how. Or is it not possible? thanks

Diogenes Ojeda
on 6/24/14, 8:33 AM

Have you attempted to export Odoo data from a module, (your customers, for example), to a CSV file, then import the CSV into a Google spreadsheet? Have you tried to reimport a CSV file back into Odoo?

Martin
on 6/24/14, 8:48 AM

Hello, no. But from what I see, that would involve several manual steps, and I think there should be a script that allows Google to update the server directly Odoo. O do not know if I've seen you around on the internet is another thing that requires advanced development.

Diogenes Ojeda
on 6/24/14, 9:23 AM

Have a look at this : http://www.slideshare.net/openobject/advanced-reporting-with-google-spreadsheets-integration-antoine-huvelle-open-erp

Martin
on 6/24/14, 10:16 AM

Hello, I think the module mentioned in the link is the same. https://www.odoo.com/apps/6.0/report_gdata/ Or at least do the same. The problem is that will not let me install it: He says: lient Traceback (most recent call last): File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\web\http.py", line 204, in dispatch File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\web\controllers\main.py", line 1132, in call_button File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\web\controllers\main.py", line 1120, in _call_kw File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\web\session.py", line 42, in proxy File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\web\session.py", line 30, in proxy_method File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\web\session.py", line 103, in send Server Traceback (most recent call last): File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\web\session.py", line 89, in send File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\netsvc.py", line 296, in dispatch_rpc File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\service\web_services.py", line 626, in dispatch File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\osv\osv.py", line 190, in execute_kw File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\osv\osv.py", line 132, in wrapper File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\osv\osv.py", line 199, in execute File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\osv\osv.py", line 187, in execute_cr File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\base\module\module.py", line 426, in button_immediate_install File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\base\module\module.py", line 477, in _button_immediate_function File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\pooler.py", line 39, in restart_pool File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\modules\registry.py", line 233, in new File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\modules\loading.py", line 354, in load_modules File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\modules\loading.py", line 256, in load_marked_modules File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\modules\loading.py", line 159, in load_module_graph File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\modules\module.py", line 405, in load_openerp_module File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\.\openerp\modules\module.py", line 133, in load_module File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\report_gdata\__init__.py", line 18, in File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\report_gdata\report_gdata.py", line 23, in File "C:\Program Files\OpenERP 7.0-20140525-231206\Server\server\openerp\addons\report_gdata\google\connection.py", line 17, in ImportError: No module named service

Diogenes Ojeda
on 6/24/14, 11:20 AM

That will have to be a new forum question.

Martin
on 6/24/14, 11:48 AM

Hello, Thank you. You see, I have been able to install the script in Google Drive. I get a new menu called OpenERP. The point is that I do not understand, if you play the complete script code. Because the menu contains the following options: Insert Field Selection Settings. In Settings asks me a web address. What should I put there, assuming that I want to connect to the local server Odoo on my computer? thanks

Diogenes Ojeda
on 6/24/14, 12:02 PM

Your Odoo server has to be fully accessible over the Internet from Google's servers. Is it?

Martin
on 6/24/14, 1:13 PM

Hello, Actually I have no idea what you're saying. So I am researching the topic, I know that if NOEL remotely access Odoo local server, I ask my ISP a dedicated IP and install and configure the server for this access: What I understood is that with Google this is not necessary, since from the script could access my server on my computer Odoo. Or I need a dedicated IP? thanks

Diogenes Ojeda
on 6/24/14, 3:53 PM

Can a computer outside your local network access your Odoo server? If not, then Google cannot see it either.

Martin
on 6/24/14, 5:21 PM

Hello, no, no external equipment (ie anywhere on the internet), you can access my server, since I do not have dedicated IP service that allows me to set up this access. So what we must assume is that both access the server externally or from a sheet of Google I have to allow this IP to connect to the server (on port 8069 or other)? So anyway I make such a configuration. thanks

Diogenes Ojeda
on 6/24/14, 5:30 PM

I use http://iwstack.com/. Great service. Best price anywhere.

Martin
on 6/24/14, 5:41 PM

Hello, thanks. I think I understand things better now: I definitely need to have access via WEB Odoo my server. It is payment for a service like the one you suggest, or you have it at my house and through a dedicated IP can access it from the Internet. But I lean more to the latter option, as I would have faster access to maintenance. As for what to Google, if I Odoo or accessible from an IP so I do not see the need to integrate with Google Spreadsheet, unless one of these spreadsheets have designed some very specific format for a client. If you still see I'm wrong rectifiques thank me in a comment, if not, I really appreciate all your time and I can say that my doubts are clear now. greetings :)

Diogenes Ojeda
on 6/26/14, 8:11 AM

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

2 follower(s)

Stats

Asked: 6/21/14, 10:10 AM
Seen: 1765 times
Last updated: 3/16/15, 8:10 AM