Skip to content

dipakyadav/crowdsource

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Crowdsource Editor with Google Sheets

The most recent javascript-only work resides in Google-OneTap.

It may be possible to duplicate some of the following server-side process using this Python 2.7 Auto Sign-in with the Credential Management API.

We're working toward a process to edit rows in a MapsForUs Google Sheet using REST/CRUD after logging into a Google account within a brower. An HTML list pulled from the sheet will allow editors to find and update directory listings, including the Georgia EPA recycling center datasets.

Here's a list displayed from a Google Sheet after logging in.

A. Clone this Repo

You'll be adding private keys, then running a local Python Flask server.
Clone from github.com/modelearth/crowdsource

B. Get your Auth IDs

Create a Google Project or use existing project IDs

C. Install the Editor

  1. Open a terminal in the local "crowdsource" folder.

  2. Install Python 3.7 if you don't have it currently.

python3 -V
  1. Within your crowdsource root directory run commands:
chmod +x setup.sh
./setup.sh
  1. Run/Server python app.
cd app
python3 app.py
  1. Go to https://127.0.0.1:5000/ to view the app.

In Safari you will see "Your connection is not private".
Click the "Advanced" button to view insecurely locally.

If successful, you will see a 'Google Login' and you'll be able to login to your Google account to see "Hi [firstname]! Logout"
This does not work in Chrome or Brave (tested on a Mac).

C. Self-Signed SSL

Even after installing locally, you will see a browser warning indicating that the certificate should not be trusted. You can proceed past this warning to view the encrypted site.

Generate a self-signed ssl with openssl - We need to document this procedure or link to an external page with steps.

Skip this step for now and use the "Advanced" button to view locally.
("Advanced" button only works on Safari. Not working on Chrome or Brave on Mac.)

Viewing at: https://127.0.0.1:5000

The following did not work yet. (This was not needed for Safari.):

Generate Self-Signed SSL Certificate

After generating, tried adding to the "System" keychain, but error continues: NET::ERR_CERT_INVALID

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published