Integration with Google Drive or Dropbox

[marcosmenendez]

Is there a feature to integrate Google Drive or Dropbox files with Open Atrium, so when attaching files into a document, you can refer to the original one in the cloud storage system?

Have a look for instance at https://drupal.org/project/Droogle Not sure if depreciated

[josereyero]

Giving a try to OG Drive, it seems it works and integrates pretty well with OA, https://www.drupal.org/project/og_drive

It needs a Google drive (gmail) account for each Group (Space). Each user needs also to set up its own google account on the group settings -so group's google docs are shared with the user account, otherwise they will only be able to see the document title, not the content.)

@marcos, I would need at least two dedicated google accounts (is @thegooddata.org possible) to set it up on PRE, you can post me the credentials

[marcosmenendez]

Sent by email

[josereyero]

Some progress and issues with this one:

1. Created all the apps/keys/etc for PRE and PROD, added to google docs: TGD - PRIVATE - Google Drive - API Keys
2. Done a quick deployment to PRE, and enabled the "og drive" module
3. Got some errors when trying to configure google drive, these ones seem to be related to nginx/Drupal configuration.

[Stuck at this point, may need some help with nginx set up, postponing for now, maybe for next release?]

Anyway, for the record, this is the error I got:

• At the last step, when getting the authorization from the google server: "Message: Error authenticating the app for : Missing parameters : state = , code ="
• This seems related to our ngingx configuration not passing the variable $_SERVER['REDIRECT_QUERY_STRING'] to php, thus to Drupal, may be related to "clean URLs"

References:

• Nginx + Drupal, http://wiki.nginx.org/Drupal
• How to configure NGINX + PHP-FPM + Drupal 7.0, https://www.drupal.org/node/1030854
• Clean URLs with NGINX, https://www.drupal.org/node/976392
• Drupal Groups: Nginx, https://groups.drupal.org/nginx

So postponing for now, if the person who did the nginx + Drupal set up can help great, otherwise I'll give it a try, though I'll need to get started with nginx configuration first.....

[josereyero]

Postponing for next release (re-tagging).

[josereyero]

After looking into this one again, it will be easier just fixing the module and posting the patch to their queue. So back to active, I'll be taking care of this.

[josereyero]

Fixed the module (Patch committed and posted here https://www.drupal.org/node/2306555#comment-9066165)

Enabled drive in PRE for Data and Corporate groups, uploaded some example docs, it seems to work See example:

• Group's drive, https://collaborate-pre.thegooddata.org/node/127/og-drive-content
• Group's drive settings, https://collaborate-pre.thegooddata.org/node/127/og-drive-settings

Usage Notes:

• All this module does is uploading / creating docs and sharing them with all the users in the group that still need to have their own google account (and be logged in) in order to access / edit the document.
• On the group's drive page, users may set up a google account to be used for doc sharing instead of the user email.
• "Document" objects are not created automatically, but they can be created manually with the right link to the uploaded doc.
• Each group has a google account associated (data@thegooddata.org, etc..). Any other document belonging to these accounts will be also shared automatically, though not instantly, need to click on the "Refresh" button of the group's folder.

Deployment notes:

• WARNING: Google accounts will be the same in PROD, so we may need to clean up testing docs before deployment.
• Needs manual configuration to set up a drive for each group and follow the authorization process
• Check permissions: Administer group drives settings (for admins), Change own drive account email address (all registered users)
• Tab "Google drive" configured manually too (this part of the configuration is not yet automated through "features").

TO DO:

• (Maybe?) Better integration with the OA Documents feature, so documents are created automatically when uploading google docs

[josereyero]

Done prod deployment.

TODO: Integrate OA Docs & Google Drive docs:

• Create a new OA Doc for each Google Drive doc
• Add "Upload document to Google Drive" option when creating OA Doc

[josereyero]

Done with the new OA Doc for each Google Drive Doc. However, I've had to keep the "Google Drive" tab because uploading files is not such a straight workflow, user's google drive account needs to be checked / edited first.

So when uploading new Google Drive files through the "Google Drive" tab, a new document is created. Added title and description fields in the tab for that purpose. Then if the document is deleted, the google doc is deleted too.

This should be working in PRE.

Devel / Deployment notes:

• I've had to add a new module for this (TGD Drive) to properly wrap/replace some of the Drive features. Enable Manually.
• Documents for existing files are created on module install.

This can be deployed if working, though still to do:

• Handle Full documents re-sync, when an administrator clicks on the "Synchronize" option.

[josereyero]

This first part has been deployed to PRODUCTION.

[josereyero]

TODO (From Skype meeting):

• Add main menu option, into '+' (Create Google Doc)
• Get back the "Create google doc" option, integrate with Documents
• Update Synchronize option.

[josereyero]

Done a half rework of this feature:

• All the issues above
• Added a TgdDriveServiceClass to override some methods and not sending emails to all users when syncing docs.

This has been deployed to PRE, for testing.

[josereyero]

Deployed to PROD