Seating Plans - Is This Smart?
1) Export department tracking sheet in the form of a SIMS marksheet with student details and seat number into MySQL
2) Connect to MySQL with a spreadsheet or custom application to automatically generate seating plans?
Is this secure and a good idea or a terrible road to go down? And how simple would it be to run? I'd love to do something like this so SIMS automatically puts the data into an external database that runs parallel to SIMS each night so I can connect to it with more advanced systems then manually exporting and altering spreadsheets. :confused: