Google Docs cannot save to alfresco

[bopolissimus]

Hi All,

<ul>
  <li>Linux (Ubuntu Precise, Ubuntu Quantal, Linux Mint Nadia)</li>
  <li>alfresco-community-4.2.b linux installer</li>
  <li>Tested with browser hitting port 8080 and with apache reverse proxy sitting in front of alfresco.</li>
  <li>All alfrescos are not directly accessible from the internet, only from the LAN.</li>
</ul>

I have an alfresco 4.2.b instance which previously worked perfectly with Google Docs.  Recently I tested google docs again and, while the document will open in Google Docs, when I click on "Save to Alfresco", the save fails with "Failed to save Google Doc to Alfresco."

I thought it might be a problem with just that instance (installed WAR files into distribution tomcat), so I installed 4.2.b from scratch into separate virtual machines using the bundled installer.  Even with this fresh install however, saving in Google Docs fails the same way.

I've since tried on other alfresco installations (4.2.b, 4.2.c) and I get the same error in all of them. 

My client machines are Linux (tested with chrome and firefox).  In case it was a problem with my client, I tested on various other linux clients (some pristine virtual machines) and on a Windows 7 machine too.  Same error.

In case it was possibly due to the google account I was using, I switched to another free account.  That failed similarly.

Has anyone else seen this? How would I debug this?  I have
tomcat/shared/classes/alfresco/extension/custom-log4j.properties

and have uncommented:

log4j.logger.org.alfresco.repo.googledocs=debug

but I still see nothing in the debug logs.

Thanks in advance for any pointers.

Gerald

[dm_nypl]

I just installed 4.2c on Ubuntu 12.10 and am having the same problem. Does anyone know if this has been fixed?

Thanks,

Don

[jottley]

Hi All,

As mentioned above you can track the initial fix for this in GOOGLEDOCS-214.  Google changed a parameter name in the export URL used by their Document List API – without notification to the developer community.  We are pushing out the fix in 2.0.3 of the integration.  We are also working on moving away from the Document List API  to the Drive API as part of the 2.1 release (no scheduled release date as Google continues to make API/UI changes on us.) I'm not sure when a packaged version of the AMPs will be available for community but you'll be able to at least pull and build from source.  I'll post to this post when we have merged and test those changes for community. 

Currently, you are also seeing in a browser JS Console the following error (or something similar): "Load denied by X-Frame-Options: https://docs.google.com/e/share?id=1H3xQXKNOjaH7CVtpZp-8zKv00ISmHcAQ4z5T… does not permit cross-origin framing."  This is an unrelated issue.  Google has modified how the share button is presented in their UI and at present have no intention of fixing it.  As part of 2.1 we are looking at our options for providing a work around.

[delfin]

will be enough change docId to docID in export URL and recompile ?

[jottley]

@delfin  There were also a couple of regressions introduced by the platform that had to be corrected/noted before the release could occur.

[jottley]

All you can download the community fix for this issue (and a few others) at http://wiki.alfresco.com/wiki/Community_file_list_4.2.c#GoogleDocs_integration.  The fix for cloud is in the queue for deployment.

[delfin]

jottley> Can u give me any hint how fix it in googledocs v1.0? I guess that install googledocs v2 in alfresco 4.0.d isn't good idea.

[jottley]

There will be a similar fix for 1.0 coming, but because it is part of core it would need a full release.  If you want to fix it yourself, the change requires modifying the 'docId' parameter used in the export url to 'id'. 

Hint:
Look at GoogleDocsServiceImpl's getGoogleDocContent(NodeRef nodeRef) method

[delfin]

I found same documentation from google where was docID. No mention about doc. It was reason why i changed docId only to docID. With doc it works perfectly. Thank you.

[cyberjus]

I applied the 2.0.3-23 amps to my 4.2.c installation and reloaded the wars, but I am getting the same "failed to save" error. 

[jottley]

@cyberjus:
Can you post debug logs from this?  log4j.logger.org.alfresco.integrations.google.docs=debug added to your log4j.properties files