[SIMS] Commandreporter and staff timetables.

[localzuk]

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).

[matt40k]

Have you got Third Party access in SIMS? I know that gives you extra fields.

[localzuk]

Have you got Third Party access in SIMS? I know that gives you extra fields.

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.

[LosOjos]

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

[TimH]

Ideally, I'd like to be able to pull out a list which contains

Staff ID, Class ID, Period number, Subject ID

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).

tim

[localzuk]

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

That looks perfect. Much obliged!