Skip to main content

A massively scalable document source comparator, using Google Spreadsheets API + Python.

Project description

Roseingrave

Massively scalable musical source comparator.

See the documentation for detailed documentation.

Installation

Install the package through pip (recommended to do in a virtual environment):

$ python3 -m pip install roseingrave

The package will be added as a top-level command:

$ roseingrave --help

Create a folder to store all your input/output files. In this folder, place your OAuth credentials file (see Credentials) and all required and optional input files.

See the documentation for customizing filepaths and the expected input file formats.

Credentials

The package interacts with Google Sheets through the gspread package. You can enable an OAuth Client to create, access, and edit spreadsheets with your email.

To enable the OAuth Client, follow these steps:

  1. Go to the Google Developers Console.
  2. Log in with the email account you want to use with the OAuth Client. All created spreadsheets will be owned by this account in Google Drive.
  3. Create a new project.
  4. Go to the API Library.
  5. In the search bar, search for "Google Drive API", select it, and enable it.
  6. Go back to the API library. In the search bar, search for "Google Sheets API", select it, and enable it.
  7. Go to the OAuth Consent Screen tab.
  8. If prompted, select "External" for the User Type.
  9. On the "App Information" page, enter an app name. Select your email address for the support email. Scroll down to the bottom and enter your email address for the developer contact information. Click "Save and Continue".
  10. On the "Scopes" page, click "Save and Continue".
  11. On the "Test Users" page, add your email address as a user. Click "Save and Continue".
  12. On the summary page, scroll to the bottom and click "Back to Dashboard".
  13. Go to the Credentials tab.
  14. At the top of the page, select "+ Create credentials" > "OAuth client ID".
  15. For the application type, select "Desktop app". Name your credentials. Click "Create". Click "Ok" at the popup.
  16. In the table labeled "OAuth 2.0 Client IDs", locate the credentials you just created. Click the download button at the end of the row.
  17. Rename the file to credentials.json and place it in the root directory of where you'll be running the commands. (You can customize this in the settings file).

If you've never authorized the app or if your authorization has expired, you'll be given a link in the console for you to visit in order to refresh or create an authorization token. Go to the url, select your email, click "Continue", allow access to your Drive files and Sheets spreadsheets, and click "Continue". This should authenticate you, and the command should continue running.

Once the authorization is successful, the authorized_user.json file will be created in the same directory as "credentials".

Basic Usage

Create the piece definitions and volunteer definitions files as explained in the documentation. If desired, create the settings file and/or the template file. Save all the files in the proper locations as defined by the default settings file or by your own settings file.

Based on your definition files, create the volunteer spreadsheets:

$ roseingrave create_sheet

After volunteers have filled out their spreadsheets, export the data:

$ roseingrave volunteer_summary

Extract the data for each piece:

$ roseingrave piece_summary

Compile all the piece data into the summary file:

$ roseingrave compile_pieces

Create the summary spreadsheet with the data from the summary file:

$ roseingrave import_summary

Fill out the summary columns as appropriate, then export the summary spreadsheet into the summary file:

$ roseingrave export_summary

See the commands documentation for all commands and their arguments and options.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

roseingrave-1.1.0.tar.gz (35.8 kB view details)

Uploaded Source

Built Distribution

roseingrave-1.1.0-py3-none-any.whl (45.2 kB view details)

Uploaded Python 3

File details

Details for the file roseingrave-1.1.0.tar.gz.

File metadata

  • Download URL: roseingrave-1.1.0.tar.gz
  • Upload date:
  • Size: 35.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.3.1 CPython/3.10.2 Darwin/22.4.0

File hashes

Hashes for roseingrave-1.1.0.tar.gz
Algorithm Hash digest
SHA256 ff350ac16f439f761be37933c24bd1ff2b12d45415a766697e4c022163a998c7
MD5 91bd62063eaef3a2a1e52bf253ae3d0d
BLAKE2b-256 040051a98160e110293f5f49be310bd26c625bdf38dacf3b02361482d4be9085

See more details on using hashes here.

File details

Details for the file roseingrave-1.1.0-py3-none-any.whl.

File metadata

  • Download URL: roseingrave-1.1.0-py3-none-any.whl
  • Upload date:
  • Size: 45.2 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: poetry/1.3.1 CPython/3.10.2 Darwin/22.4.0

File hashes

Hashes for roseingrave-1.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 ddd4cdd396965f26e6745af64ef1aed65b3ab4c0df745a9650160ad508f866b2
MD5 90679ba8cddffe1091ac08e96be88473
BLAKE2b-256 ddbcb1061e9f8188acb82f3ba68e2450a2583093f7b094ad3e09fb127692fdc0

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page