+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, Timetable report - data format, not printable in Technical; I'm trying to create a report in SIMS.net which outputs the following information: Teacher Class Period Day of Week Week ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,162
    Thank Post
    522
    Thanked 2,554 Times in 1,982 Posts
    Blog Entries
    24
    Rep Power
    879

    Timetable report - data format, not printable

    I'm trying to create a report in SIMS.net which outputs the following information:

    Teacher
    Class
    Period
    Day of Week
    Week Cycle

    So, in other words, I want a giant text file output which lists the timetables for the staff, so I can use the data in a program.

    However, when I try to deal with 'timetable details' I get a bunch of information but no way to link the resulting classes to which period they take place in etc...

    Any clues as to which focuses I should be using?
    Last edited by localzuk; 26th July 2010 at 11:55 AM.

  2. #2
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    55
    Have you tried the new Timetable Reports that the Summer Release has given us?
    You can 'print' a full staff timetable and then export it!
    As with NT4 Reports the format of this report is editable.

  3. #3

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,162
    Thank Post
    522
    Thanked 2,554 Times in 1,982 Posts
    Blog Entries
    24
    Rep Power
    879
    Ah, we only got the Summer release last week, so not really looked at new stuff yet.

    Looking at it now, it doesn't provide the export data in any meaningful manner. ie. it sticks the formatted timetable into a file - eg an excel file or an html file. Or, if I choose, an XML data file. If I export as HTML, the HTML is very poorly formatted - instead of using a single 'table' element, there are loads of them - making parsing that file very difficult. If I export as Excel, the data is again formatted oddly, making parsing of the file very difficult.

    It does look like you can provide an XSLT file to format things how you want, but then there is zero information on the XML schema to work with to create one.

    I just want a list really.
    Last edited by localzuk; 26th July 2010 at 12:31 PM.

  4. #4
    Sarconia's Avatar
    Join Date
    Mar 2010
    Location
    London
    Posts
    315
    Thank Post
    15
    Thanked 34 Times in 31 Posts
    Rep Power
    16
    Hmm... this seems to be similar to what you want...

    I created a report based on the Period (it's under the school focus in the report design).

    I then added the fields:

    Period
    Day Name
    TimeTableModel (this seems to pick up the cycle)
    Lessons (Sub Report)
    Class Name of the class
    Class teacher of the class

    It did give me a really long list... I hope it helps.

  5. #5

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,162
    Thank Post
    522
    Thanked 2,554 Times in 1,982 Posts
    Blog Entries
    24
    Rep Power
    879
    Thanks for the info Sarconia. Doesn't seem to work for me. I just get The Period (Fri 8 etc...) Day Name (Fri) a TimeTableModel (Model 1/Model 2) and then 2 blank columns.

    I've tried setting the effective date to the past (during term time), the future (during term time) and today. Zilch.

  6. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,817
    Thank Post
    731
    Thanked 1,447 Times in 1,200 Posts
    Rep Power
    361
    Quote Originally Posted by localzuk View Post
    Ah, we only got the Summer release last week, so not really looked at new stuff yet.

    Looking at it now, it doesn't provide the export data in any meaningful manner. ie. it sticks the formatted timetable into a file - eg an excel file or an html file. Or, if I choose, an XML data file. If I export as HTML, the HTML is very poorly formatted - instead of using a single 'table' element, there are loads of them - making parsing that file very difficult. If I export as Excel, the data is again formatted oddly, making parsing of the file very difficult.

    It does look like you can provide an XSLT file to format things how you want, but then there is zero information on the XML schema to work with to create one.

    I just want a list really.
    If you can output to XML, that's enough info to build a makeshift XSL. I've started playing with these, but it requires something as a start point. I've been doing it for registration reports to alter the output of days from mon-fri to sat-wed it's a bit of a head against wall.

    sarconia's report sounds the easiest thing, if you can get it to work. is the timetable applied for the next year...?

  7. #7

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,162
    Thank Post
    522
    Thanked 2,554 Times in 1,982 Posts
    Blog Entries
    24
    Rep Power
    879
    The timetable has been applied, yet the report still returns empty fields.

    I've decided to go down the 'figure out the excel sheet' route, as it is in a repeating pattern, so programmatically grabbing data from it won't be that hard, plus the instructions for creating a correctly formatted report for importing into my program will be simpler using just built in functionality, rather than needing extra .xlst files etc... Just wish I could automate it now.

  8. #8
    Martin_W's Avatar
    Join Date
    Aug 2010
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Hey Localzuk,

    can you explain how you use the xls files to get to the output you want?
    I have reformatted data using Excel before. Maybe it is not so hard to automate what you are doing.

  9. #9

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,162
    Thank Post
    522
    Thanked 2,554 Times in 1,982 Posts
    Blog Entries
    24
    Rep Power
    879
    Quote Originally Posted by Martin_W View Post
    Hey Localzuk,

    can you explain how you use the xls files to get to the output you want?
    I have reformatted data using Excel before. Maybe it is not so hard to automate what you are doing.
    I've managed to process it using c sharp now thanks. I'll post some details on my blog at some point!

  10. #10
    Martin_W's Avatar
    Join Date
    Aug 2010
    Posts
    7
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Ok, that's a nice solution too (although it would have been nice if SIMS itself would output format the data in a nice way, but hey



SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 22
    Last Post: 17th August 2010, 06:38 PM
  2. [solved] Missing data in SIMS.net Report
    By MrLudwig in forum MIS Systems
    Replies: 3
    Last Post: 27th November 2009, 09:43 AM
  3. Custom date format in SIMS Report
    By pod in forum MIS Systems
    Replies: 6
    Last Post: 2nd November 2009, 01:37 PM
  4. Report Design for MySql Data
    By danIT in forum General Chat
    Replies: 2
    Last Post: 18th June 2008, 09:02 PM
  5. Replies: 1
    Last Post: 25th September 2007, 08:34 PM

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
  •