[SIMS] Attendance REport by Half Term

[TonyM19]

Hi

 

I am looking to create a marksheet that includes a coulmn for attendances between two dates (typically half terms). I have a very roundabout method that involves Excel and Import Data but I'm looking to streamline the whole process

 

Does anybody have a neat way of doing this within SIMs that doesn't need me to export/import data from Excel?

 

Cheers

Edited December 5, 2017 by TonyM19

[Esteban_Child_of_the_Sun]

I wrote a Powershell/XSLT script some time ago for our schools that runs nightly and puts any data from the SIMS reporting engine processed any way they want it, into an assessment aspect. I've managed to automate everything except the final import, but I've made that as simple as possible where all someone has to do is 'Routines | Data In | Assessment | Import' then leave everything as the defaults clicking next several times, then select all and finish. It took a while to develop but I'm sure you could reproduce it.