The service account's private key will be downloaded to your computer. Once the service account is created, click Edit > Add key > Create new key > JSON.Give it any name, and skip both "Grant access" steps. You do not need to add any scopes on the next screen. Select "Internal" and set the app name to "Timetable Calendar Generator". The tool may use up to 1000 API requests per user when it is first run. Depending on the size of your school, you may also need to apply for a raised quota. Create a new project on the Google Cloud Platform console.If you are using the -google flag to directly sync timetables to Google Calendar, your domain administrator will need to create a free service account key: You may be able to do this with a VLOOKUP formula. Replace staff names in the left-hand column with their email addresses.When the spreadsheet opens, delete rows 1-4 which contain the header.Back at the top-left of the screen, click "Export".Click and drag "Class#" to the top half, and "RM" to the lower half. In the middle of the pane, there is a split box.At the bottom of the Cell Settings pane, set "Number of Rows" to 2. ![]() On the far right of the screen, click the button for "Show/Hide Cell Settings".Teacher names should appear going down the page. If needed, click the "Flip" button in the top-left corner.Click Reports -> Timetables -> All Staff Timetable.This file can be created in a spreadsheet app.Įmail, 1Mon:1, 1Mon:2, 1Mon:3, , 10B/Ar1, 13A/Ar1, 9A/Ar1. Non-teaching days such as weekends and holidays should be excluded. List each teaching day in the school year, in yyyy-MM-dd format, followed by a week indicator (i.e. The copyFromPeriod option can be used to clone another lesson in the same day, for example to create an extended tutor period. Overriding or renaming a lesson to a blank string ( "") will prevent a calendar event from being created at that time. Make sure a fallback entry (with no filters) is always provided. If you specify multiple timings for the same period, then when creating each event the app will use the first entry matching any days and yearGroups filters. whole-school tutorials or early finishes) for study leave or a staggered start of term) Daily timings, which can be customised for specific days and/or yearGroups.Run commands in the format: dotnet makecal.dll -csv.Download and extract the xplat ZIP package from our Releases page.NET 7 runtime installed (on the download page, look for the latest ".NET Runtime 7.0.x" heading in the right-hand column). makecal -microsoft to directly sync timetables to Microsoft 365 calendars.makecal -google to directly sync timetables to Google Workspace calendars.makecal -ical to generate iCalendar (.ics) files.makecal -csv to generate comma-separated (.csv) calendar files.Open a command line and run one of the following commands:.In the "inputs" directory, add the input files defined below.Download the latest win-圆4 ZIP package from our Releases page and extract the contents. ![]() It can create calendar files in comma-separated (.csv) or iCal (.ics) format, or sync directly to Google Workspace or Microsoft 365 calendars. ClickUp: a free remedy for Google Sheets headachesĬlickUp is the ultimate productivity platform allowing teams to manage projects, collaborate smarter, and bring all work under one tool.This is a cross-platform command line tool for bulk generating student and teacher timetables. And you have free Google Sheets alternatives! The best free software? I’m so glad you asked. In hindsight, modern calendar software is a time-saving necessity.
0 Comments
Leave a Reply. |