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

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

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?

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.

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

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

That will have to be a new forum question.

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

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

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

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

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

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

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