Sims And Google Calendar

[caffrey]

We're looking to import Student timetables into their individual GAFE calendars, I am aware that SalamanderSoft can do it but we are just initially doing a trial of a few forms also it's a bit out of budget for us.

 

Is there any other way to do it ?

[rogerdnixon]

One of our staff members made a little app to do this which we use - https://github.com/jamesgurung/timetable-calendar-generator

Works fine for us - open source.

[caffrey]

Thanks, I'll have a look

[Ditto]

This is an interesting idea. After a brief look, for progresso, I presume provided I can generate the various csv files, the open source generator can do the job.

[rogerdnixon]

Yes - as long as you can produce the required files it will work. I run a scheduled commandreporter task to update the files and sync the calendars once a week.

[timothy]

Yes - as long as you can produce the required files it will work. I run a scheduled commandreporter task to update the files and sync the calendars once a week.

 

Hi Roger,

 

I'm using James' app. Works well..

 

CommandReporter is my next step. Wondering if you've managed to automate the generation of teachers.csv? How do I go about doing the 'flip', two rows, RM second row, remove top 4 lines, insert email addresses? :-)

 

Cheers,

Tim

[rogerdnixon]

Not automated the teachers on. Use commandreporter for the students.

Just run the staff timetable report and the flip button is top left I think. You have to expand the options on the right for the other bits.

You remove the rows on the excel export.

[timothy]

I've just automated this (both students and teachers) with a sketchy python script. I'm sure it could probably be done in three lines of code, iterating through the SIMS report 1000 less times, if you actually know Python. - but it works!

 

I'm even less familiar with C#, otherwise it would have made more sense just to extend James' code...

 

https://drive.google.com/file/d/1aCCeJpoxefam0QVIhjHlrCDiStFOUSJL/view

 

I've packaged up the python version I'm using because I got different results when I ran with python 3. I'm running "python/python.exe runme.py" from the command prompt. The 'runme.py' script and the usual inputs for James' app will need some love to make them suit a different environment.

 

Tim

[keyboards]

I think Google were looking into this, there was a beta going for something to do with SIMS and Google

[Ditto]

I think Google were looking into this, there was a beta going for something to do with SIMS and Google

I haven't heard about a calendar sync from Google but I guess it's likely at some point. They have on Beta released a Gradebook sync for SIMS. See here. Would be nice to see Google work with other MIS's though.