Live MIS data in Google Spreadsheets
I've managed to get live (ish) SIMS data imported into Google spreadsheets (and hence appengine and any other service).
What I've done so far is:
Create a report in SIMS.
Have commandreporter export that data to a csv on the SIMS server, scheduled every 120 minutes.
Install the Google Secure Data Connector.
Have the Secure Data connector pick up the SIMS report
used the function =importData("https://192.168.1.123/SIMSExport.csv")
and hey presto it populates a spreadsheet with several hundred student details. I can then share the data with teachers.
I know there is massive potential to have live spreadsheets as well as a development platform - I just need some ideas as to what to do with the data.
It would be trivial to pull out anything in SIMS, so an email app would be good but I've never coded in appengine before, so spreadsheets would probably be a starting point.