Skip to content

This project was created for purpose of primary school (in czech rep.) to allow school to simply copy files (templates) located at Google Drive + multi-file edit Google Sheets to invoke same changes over several documents. Automation of labour.

License

Tatranskymedved/GoogleSchoolProjectManager

Repository files navigation

GoogleSchoolProjectManager

This project was created for purpose of primary school (in czech rep.) to allow school to simply copy files (templates) located at Google Drive + multi-file edit Google Sheets to invoke same changes over several documents. Automation of labour.


Features supported

  • Multi-language
  • Downloading list of files/folders from drive
  • Copying file into several files with different names & same content
  • Updating existing Google Sheets document with data/format
  • Metro style

Useful links


Build

  1. Create/use Google APIs' account and add OAuth 2.0 authentication. Get credentials.json from it and save it to GoogleSchoolProjectManager\GoogleSchoolProjectManager.Lib\ folder.
  2. Build it via Visual Studio 2019 (or other applicable version)

Usage Limits

There are existing limits to use Google's API if you are using free account. As of now (11th Jun 2021):

  • 500 requests per 100 seconds per project
  • 100 requests per 100 seconds per user

For more details please visit Google's official webpage with up-to-date values.


App screenshots

Overview once list of folders/files received appScreenshot_Overview

Prepared for copying a template into multiple files appScreenshot_copyTemplate

Prepared for updating existing Google Sheets appScreenshot_copyTemplate


License

Copyright © Jan Urbanec and contributors.

GoogleSchoolProjectManager is provided as-is under the MIT license. For more information see LICENSE.


Libs used

  • Google APIs Nugets (Drive, Sheets, Docs)
  • Newtonsoft.JSON
  • Ninject
  • MahApps.Metro
  • ControlzEx
  • Microsoft.Xaml.Behaviors.Wpf

About

This project was created for purpose of primary school (in czech rep.) to allow school to simply copy files (templates) located at Google Drive + multi-file edit Google Sheets to invoke same changes over several documents. Automation of labour.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages