This question has been flagged
1 Reply
7893 Views
configurationnotesgooglemodelstemplates
Avatar
Colin Bacon

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

Avatar
Discard
Martin

Have you been able to solve this?

Avatar
Martin
Best Answer

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.

Avatar
Discard
Serpent Consulting Services Pvt. Ltd.

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

Martin

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