UCONN Stamford Google Cloud Development Platform

Thursday, July 15, 2021

Recorded WEBEX Sessions, 7/15/2021, 4:54 PM, English, 7/15/2021, 4:54 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

7/15/2021, 4:54 PM

Webex meeting recording: UCONN Google learning classes before project
work-20210701 2106-1
Recording link:
https://uconn-cmr.webex.com/uconn-cmr/ldr.php?RCID=de8a3a268c5941e38b323a49066b880d

Webex meeting recording: UCONN Google learning classes before project
work-20210629 2103-1
Recording link:
https://uconn-cmr.webex.com/uconn-cmr/ldr.php?RCID=68528ee8c92747af8c0deb1fc63f1e2e

Webex meeting recording: UCONN Google learning classes before project
work-20210624 2115-1
Recording link:
https://uconn-cmr.webex.com/uconn-cmr/ldr.php?RCID=f8ae2847b130459ebeee535eb0752853

Weekly Status update meeting link, 7/15/2021, 10:50 AM, English, 7/15/2021, 10:50 AM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

7/15/2021, 10:50 AM

Weekly Status Update Link

https://uconn-cmr.webex.com/uconn-cmr/j.php?MTID=m5ae15524804910dfb9f70866923795ed

Password:
uconn
Host key:
981420
Agenda:
Weekly team status report out. Each team should update spreadsheet and
prepare to review progress during meeting

Tuesday, July 13, 2021

Agenda for Weekly meeting on 7/15/2021, 7/13/2021, 7:16 PM, English, 7/13/2021, 7:16 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

7/13/2021, 7:16 PM

Agenda for Weekly meeting on 7/15/2021

I need a representative from each team to attend but all are welcome to attend.

Please fill our status reports on work done so far and have questions ready.

Each team will need to provide and update as to where they are in the project.

Please don't hesitate to reach out with questions or issues.

john.iacovacci1@gmail.com

Sunday, July 11, 2021

GMAIL API, 7/12/2021, 0:54 AM, English, 7/12/2021, 0:54 AM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

7/12/2021, 0:54 AM

Gmail API

https://codelabs.developers.google.com/codelabs/intelligent-gmail-processing#0

Best way to learn is to keep trying and asking questions.

Above is another example of Gmail API

Requirement # 2, 7/11/2021, 9:21 PM, English, 7/11/2021, 9:21 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

7/11/2021, 9:21 PM

Requirement number 2
The critical to path (most important functionality) is the ability to
send communications.
It is important to achieve a level of success with this functionality
and build from that point.
A simpler version of requirement 2 can use text box and send button
and only focus on email.

Looping thru all records in the table

Email: john.iacovacci1@gmail.com
Language: es
You can leverage the code from the CRUD translate example

from flask import Flask, request, render_template, redirect, send_from_directory

from google.cloud import translate_v2 as translate
translate_client = translate.Client()
# Imports the Google Cloud client library
from google.cloud import datastore

Text box would be tinst

tinst = customer['instructions']
tlang = language field from datastore table
result = translate_client.translate(tinst, target_language=tlang)
Can get all records and put in array or develop routine to read thru all records

Need to use GMAIL API

https://developers.google.com/gmail/api/quickstart/python
Remember share project with team.

Do you best to try to get this process running.

It will require establishing oauth credentials
User Authentication with OAuth 2.0
The OAuth 2.0 specification defines a delegation protocol that is
useful for conveying authorization decisions across a network of
web-enabled applications and APIs. OAuth is used in a wide variety of
applications, including providing mechanisms for user authentication.

Communication process system
Build an app engine process to input the following fields into an HTML form

Textbox
Class
Send-button
Verification (are you sure?)
date of event
Attachment

When the send button is hit

Loop thru table to find client records that match class
If record is matched check the language field to see if it needs translation'
If language is not english
Send language and text to translate API
Check to see if delivery text or email
If text send translated (if needed) textbox to number on record
If email send translated (if needed) textbox to email on record
https://uconnstamfordslp.blogspot.com/p/app-engine-flask-html-form.html
(not complete)
Please note texting may require additional work then emailing.
For better success separate out both with small POC programs.

Saturday, July 3, 2021

Project Updates, 7/3/2021, 10:58 AM, English, 7/3/2021, 10:58 AM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

7/3/2021, 10:58 AM

Additional details
When building a new table (datastore kind) indtead custinfo use clientinfo
Key should be clientid instead of name

Properties should be added from 2 thru 6 from items below
Client Table
Client ID
Email
Cell phone
Language
Class
Preferred delivery: email, cell phone
Note language must match the the google translate language parameter
of the language you want to translate to e.g. es for spanish
Enter data for team members to test

CRUD program is built based on table above

Note: One project should be shared by team members as Project owners

Clarity for requirement 2 sent in different communication

Thursday, July 1, 2021

7/15 Status Updates Due, 7/1/2021, 7:03 PM, English, 7/1/2021, 7:04 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

7/1/2021, 7:03 PM

Next meeting 7/15 5;00PM to 6:00PM

Status updates

Pick functionality on sheet 2 and move into sheet 1 to report out

J M Wright Status Update
https://docs.google.com/spreadsheets/d/1EHbO8dcBJJvMuAkiT83g2EVEzk_DT8HmfJgYBXB7evw/edit#gid=0

AITE Status Update
https://docs.google.com/spreadsheets/d/1iTZot4CvVQWhbagJSTy9SQUIHa6eQ11SIZrqJ7KVjQ4/edit#gid=0

Stamford High Status Update
https://docs.google.com/spreadsheets/d/1njlmjERHaaLE1RPIChgSHn9A9MTcaYdkTfScII8Zkfs/edit#gid=0

Westhill/Wilton STatus Update

https://docs.google.com/spreadsheets/d/1iMAy0hipcT769SSFB4XpPHnK0BTMP-_cwT5KKUVlfao/edit#gid=0

Westhill II Status Update

https://docs.google.com/spreadsheets/d/1x-teguBoLSQxN_IxxJZECkvse-9iZeo2HHRP7xdAR_w/edit#gid=0

Westhill I Status update

https://docs.google.com/spreadsheets/d/1d4QnuTl177WoiwZBjd-euSSi0oIJEEs9BQ-kCZ7xPSI/edit#gid=0