As I'm fiddling with charts for the reports page, I realize it might be nice to test this with data from a whole school year. I'll bet the other folks working on the reports pages would like to work with a more extensive, "real" dataset too.
It occurs to me that someone could take on building a converter that can take data from the current system (primarily the events table, but also of necessity the users table and some other stuff) and mash it around until it is in a form that can be imported into our new DB format.
Probably not too hard. Would require calculating a bunch of "elapsed" times, but not too much more?
And such a tool would actually be useful next year at whatever point v3 is ready to deploy, to take whatever has been generated to date and plop it in the new system.
As I'm fiddling with charts for the reports page, I realize it might be nice to test this with data from a whole school year. I'll bet the other folks working on the reports pages would like to work with a more extensive, "real" dataset too.
It occurs to me that someone could take on building a converter that can take data from the current system (primarily the events table, but also of necessity the users table and some other stuff) and mash it around until it is in a form that can be imported into our new DB format.
Probably not too hard. Would require calculating a bunch of "elapsed" times, but not too much more?
And such a tool would actually be useful next year at whatever point v3 is ready to deploy, to take whatever has been generated to date and plop it in the new system.