search

DAMPLAB / damplab-aquarium

The Aquarium Lab Operating System
http://www.aquarium.bio/
Other
2 stars 0 forks source link

Google API Connection Issue #3

Open rychen58 opened 4 years ago

rychen58 commented 4 years ago

Summary & Context

Three Aquarium protocol, Order Primer, Send to Sequencing, and Weekly Inventory Check, are linked with individual pages of a Google Sheet (https://docs.google.com/spreadsheets/d/12FhpjhvToSC50i9cJ8rU5ygyUr-AfS4Bhe57VQ2bqNg/edit?ts=5dd4a088#gid=1605864681), so primer orders, sequencing orders, and supplies/reagents orders will be automatically updated in the Google Sheet once the protocol is completed. However, since the update of Aquarium, that connection has been broken.

Expected Behavior

Once Order Primer protocol has completed the information for Order #, # of Samples, Total Values, Date Ordered, Ordered by, and Project will be automatically updated on the page, IDT_PO, of the Google Sheet. The same thing happens for Send to Sequencing and Weekly Inventory Check protocol, the related information would automatically be updated on the Quintara_PO and Expenses_LCP pages of the Google Sheet.

Current Behavior

No information is updated in the pages of the Google Sheet after the completion of the protocols.

Possible Solution

Update Google API Client and Key Info

Steps to Reproduce

  1. Run and complete either one of the three protocols listed above.
  2. Open Google Sheet, and check the corresponding page of the Sheet to see new info updated.

Environment

Chrome

bjkeller commented 4 years ago

This interface requires adding a dependency to Aquarium, and I may have removed it when I did the merge. You may be able to restore it by adding the google_drive gem back into your Gemfile and rebuilding Aquarium.