MIS Systems Thread, Commandreporter and staff timetables. in Technical; I've currently got a small problem trying to export simple staff timetable data.
Ideally, I'd like to be able to ...
19th October 2010, 08:56 AM #1
Commandreporter and staff timetables.
I've currently got a small problem trying to export simple staff timetable data.
Ideally, I'd like to be able to pull out a list which contains
Staff ID, Class ID, Period number, Subject ID
However, there doesn't seem to be a way to do this using the old style SIMS.net reports.
The only way I can get the data is via the new Timetable reports, which is fine except for the problem that I can't do this via commandreporter.exe, and then if I'm doing this manually via SIMS.net, I can only get the data I want in a highly formatted excel file.
So, does anyone know of a method of extracting this information via commandreporter, and then, in a simple xml format?
(Note, I have cross-posted this to the Supportnet forums).
19th October 2010, 09:37 AM #2
Have you got Third Party access in SIMS? I know that gives you extra fields.
19th October 2010, 09:39 AM #3
Yes, there simply aren't any timetable related details in the standard reporting section of SIMS.net. It is all in the new style reports, or back in Nova. Neither of which can be used via commendreporter.
Originally Posted by matt40k
19th October 2010, 09:43 AM #4
Is this the kind of thing you're looking for?
Staff Timetable Export.zip
BTW, file contained in the zip is a standard SIMS RptDef file
Last edited by LosOjos; 19th October 2010 at 10:08 AM.
Thanks to LosOjos from:
localzuk (19th October 2010)
19th October 2010, 10:01 AM #5
- Rep Power
I do this to populate a web based timetable viewer we have. I think (can't check ATM) the report needs to ask for the classes the teacher teaches, the the periods for the classes (or maybe classes, teachers, periods).
Originally Posted by localzuk
19th October 2010, 10:11 AM #6
That looks perfect. Much obliged!
Originally Posted by LosOjos
By Tim158 in forum MIS Systems
Last Post: 12th June 2012, 03:34 PM
By LosOjos in forum MIS Systems
Last Post: 7th June 2010, 01:51 PM
By Willzzz in forum MIS Systems
Last Post: 15th October 2008, 12:31 PM
By kerlj001 in forum MIS Systems
Last Post: 29th September 2008, 10:47 PM
By DaveS in forum MIS Systems
Last Post: 27th February 2008, 11:44 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)