Odoo Help


google models Configuration

Colin Bacon
on 4/8/13, 2:06 PM 4,180 views

Has anyone managed to get the Google Docs Templates and setup got the integration working between OpenERP 7.0 and Google drive?

I've setup the google docs URL as described in the instructions:

/settings/Google Docs configuration/Models configuration

  • for a text document with url like
    https://docs.google.com/a/openerp.com/document/d/123456789/edit, the ID is document:123456789 for a spreadsheet document with url like
    https://docs.google.com/a/openerp.com/spreadsheet/ccc?key=123456789#gid=0, the ID is spreadsheet:123456789 for

  • a presentation (slide show) document with url like
    https://docs.google.com/a/openerp.com/presentation/d/123456789/edit#slide=id.p, the ID is presentation:123456789

  • for a drawing document with url like https://docs.google.com/a/openerp.com/drawings/d/123456789/edit, the ID is drawings:123456789

I've tried various google accounts and URL patterns, but I just keep getting the error message

Google Docs Error! Your resource id is not correct. You can find the id in the google docs URL.

Any ideas would be useful

Regards Colin

Have you been able to solve this?

on 4/12/13, 9:09 AM



| 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/8/13, 8:49 PM

Hi Colin,

I had set aside today to have a look at that module for my own needs, so I have dug into your problem quite a bit...

To answer your question, Has anyone managed to get the Google Docs Templates and setup got the integration working between OpenERP 7.0 and Google drive?

Yes, I have had it working both with a private Spreadsheet I created myself, and a "Public on the Web" spreadsheet that I created from another account. After playing around with it, I'd have to say I trust the module about as far as I can spit during a root canal job.

Some things I noticed in my own experiments:

  • if I have no Google Document specified at all in Google Docs Configuration -> Model configuration it'd generate a new blank word-processing document. That's valid, I suppose.
  • I couldn't get it to work on a person Partner -- it threw a hysterical alert

    Integrity Error
    The operation cannot be completed, probably due to the following:
     - deletion: you may be trying to delete a record while other records still reference it
     - creation/update: a mandatory field is not correctly set
  • it did work with a company Partner, but it tried to open a new browser tab with the URL http://erp.not4publication.com:8069/undefined which of course threw an HTTP error "404 Not Found".

I see from your bug report last January 17, that this has been a problem for you for a long time. My configuration is somewhat similar to yours, except the last item:

OpenERP Server Ubuntu 12.04.
OpenERP version Version 7.0-20130305-002149
Browser: Chrome running on *Ubuntu 12.04*
Using google apps ***NOT*** as a business account

It seems possible that the module expects to use a different URL than those of Google business accounts. May I suggest you try again with a simple personal Google account like mine (as specified in Settings -> Users -> Users -> 'Your user' -> Synchronization of course.) Also, probably, you should do it on an entirely fresh database -- yours may simply have gone nuts from too many compounded previous errors.

The fact that it works differently with Persons and Companies, suggests to me that you should test it on several different models: Partner, CRM Leads/Opps, etc.

Got to check this well. Will do once I am in position to check and verify. Thanks.

Serpent Consulting Services Pvt. Ltd.
on 4/9/13, 9:52 AM

It'd be nice to know if this was any help.

on 4/11/13, 12:20 AM

About This Community

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


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 4/8/13, 2:06 PM
Seen: 4180 times
Last updated: 3/16/15, 8:10 AM