+ Post New Thread
Results 1 to 6 of 6
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 ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,631
    Thank Post
    514
    Thanked 2,442 Times in 1,890 Posts
    Blog Entries
    24
    Rep Power
    831

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

  2. #2

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,377
    Thank Post
    368
    Thanked 637 Times in 519 Posts
    Rep Power
    158
    Have you got Third Party access in SIMS? I know that gives you extra fields.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,631
    Thank Post
    514
    Thanked 2,442 Times in 1,890 Posts
    Blog Entries
    24
    Rep Power
    831
    Quote Originally Posted by matt40k View Post
    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.

  4. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,447
    Thank Post
    1,438
    Thanked 1,168 Times in 797 Posts
    Rep Power
    707
    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.

  5. Thanks to LosOjos from:

    localzuk (19th October 2010)

  6. #5

    Join Date
    Feb 2006
    Location
    Dorset/Hants
    Posts
    87
    Thank Post
    2
    Thanked 13 Times in 10 Posts
    Rep Power
    20
    Quote Originally Posted by localzuk View Post
    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

  7. #6

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,631
    Thank Post
    514
    Thanked 2,442 Times in 1,890 Posts
    Blog Entries
    24
    Rep Power
    831
    Quote Originally Posted by LosOjos View Post
    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!

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] PHP and commandreporter.exe
    By Tim158 in forum MIS Systems
    Replies: 8
    Last Post: 12th June 2012, 03:34 PM
  2. SIMS ID Interface / CommandReporter Example
    By LosOjos in forum MIS Systems
    Replies: 10
    Last Post: 7th June 2010, 01:51 PM
  3. CommandReporter List Parameters
    By Willzzz in forum MIS Systems
    Replies: 0
    Last Post: 15th October 2008, 12:31 PM
  4. CommandReporter Reports
    By kerlj001 in forum MIS Systems
    Replies: 5
    Last Post: 29th September 2008, 10:47 PM
  5. CommandReporter - History of Changes?
    By DaveS in forum MIS Systems
    Replies: 5
    Last Post: 27th February 2008, 11:44 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •