+ Post New Thread
Results 1 to 10 of 10
MIS Systems Thread, SIMS to Booking System - URGENT in Technical; Hi We are looking for a way of exporting room timetables into our booking system i.e. MYSQL reads MSSQL, so ...
  1. #1
    01hanstu's Avatar
    Join Date
    Sep 2007
    Location
    Manchester
    Posts
    148
    Thank Post
    17
    Thanked 1 Time in 1 Post
    Rep Power
    0

    SIMS to Booking System - URGENT

    Hi We are looking for a way of exporting room timetables into our booking system i.e. MYSQL reads MSSQL, so that the booking information is correct.

    Or does anyone know of a booking system, thats free, and can be incoporated into SIMS??

    HELP!!!

    Stuart

  2. #2
    danrhodes's Avatar
    Join Date
    Sep 2008
    Location
    Wath Upon Dearne
    Posts
    1,513
    Thank Post
    157
    Thanked 181 Times in 150 Posts
    Rep Power
    68
    I think Meeting Room Manager integrates with SQL?? Meeting Room Manager Software, Room Scheduler | NetSimplicity

    D

  3. #3

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,433
    Thank Post
    368
    Thanked 646 Times in 528 Posts
    Rep Power
    159
    Few things out there, David Hicks will know a few of them. Just make sure they don't dip into SIMS SQL directly.

  4. #4

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,653
    Thank Post
    1,257
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    Quote Originally Posted by 01hanstu View Post
    Hi We are looking for a way of exporting room timetables into our booking system i.e. MYSQL reads MSSQL, so that the booking information is correct.
    As pointed out, you aren't supposed to interact directly with SIMS' SQL database, and there's no real need, the CommandReporter tool is just fine for dumping data out of SIMS to be read by something else. This recent thread might be some help:

    SIMs - Extract timetables in file form for use on VLE

    User Penfold_99 on these forums might be able to help you, he works for (or owns, not quite sure) SchoolsICT:

    SchoolsICT - enabling 21st century learning

    Which makes a product that can extract data from SIMS. This isn't free, but I'm sure it's very reasonably priced.

    Or does anyone know of a booking system, thats free, and can be incoporated into SIMS??
    Do you have an existing room booking system at the moment?

    --
    David Hicks

  5. #5
    01hanstu's Avatar
    Join Date
    Sep 2007
    Location
    Manchester
    Posts
    148
    Thank Post
    17
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hi Guys,

    Thanks for the replies, will have a look at a few.

    We do have our own custom room booking system, but part of the problem is that the Timetable Manager keeps changing all of the timetables and not telling me.

    As it stands we have to keep adding bookings manually (.ie. populate the timetables per day per period)

    Thanks
    Stuart

  6. #6

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,498
    Thank Post
    1,456
    Thanked 1,201 Times in 814 Posts
    Rep Power
    712
    If your comfortable with XML, use CommandReporter. All you need to do is create a report in SIMS.net that contains all the info you need, set output as XML, then run it from CommandReporter to get updated data whenever you need it, it's very quick for small reports too, particularly if you use a Paramdef file to only extract the data you need at that time rather than the whole timetable.

  7. #7
    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
    Quote Originally Posted by 01hanstu View Post
    .... but part of the problem is that the Timetable Manager keeps changing all of the timetables and not telling me ....
    As a timetabler of long standing (... very, very longstanding), I have great sympathy with the Timetabler. If your school is like ours then the Timetable changes very regularly. The changes may be major (due to Rotations) or simply the odd room change.
    It is virtually impossible to inform everybody of the changes that are made - apart from the staff that are affected (say via a Subject Selection or Individual Timetable). To do so would take a great deal of time and/or lots of paper! A general notification to all staff is probably the best that can be achieved in view of time constraints!

  8. #8

    dhicks's Avatar
    Join Date
    Aug 2005
    Location
    Knightsbridge
    Posts
    5,653
    Thank Post
    1,257
    Thanked 781 Times in 678 Posts
    Rep Power
    236
    Quote Originally Posted by Sivadam View Post
    To do so would take a great deal of time and/or lots of paper!
    Or, of course, you could have an electronic version that all staff can get to as needed. This, obviously, imples enough computers around for easy staff access.

    --
    David Hicks

  9. #9
    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
    There obviously is one.
    It is called NovaT4 at the moment .....
    ..... but this will no longer be required when the NT4 Reporting etc finds it's way into SIMS.net - some of which is arriving by COB 31/03/2010 (sheduled!).

    Personally I prefer the staff not to use this as very few understand it - especially with all the TAs, PSAs, Year Support Staff etc. etc. being on the timetable! Invariably staff look at the wrong line when trying to find something.
    Last edited by Sivadam; 5th March 2010 at 02:30 PM.

  10. #10
    01hanstu's Avatar
    Join Date
    Sep 2007
    Location
    Manchester
    Posts
    148
    Thank Post
    17
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Our current system is a custom made in-house application writen in php using a mysql database.

    If we have to change what we use, if we find a solution, i guess we can.

    I use Nova-T6 to view timetables, have tried to export to csv, but this means writing a php csv import script and we dont have time (besides the data doesnt export the way i wnted it to)

    Thanks
    Stuart

SHARE:
+ Post New Thread

Similar Threads

  1. Classroom booking System
    By Jona in forum How do you do....it?
    Replies: 220
    Last Post: 23rd June 2014, 11:27 AM
  2. Food Booking System
    By dave.81 in forum General Chat
    Replies: 6
    Last Post: 16th October 2009, 11:49 AM
  3. Hosted booking system?
    By paulh in forum Network and Classroom Management
    Replies: 7
    Last Post: 29th April 2009, 11:01 PM
  4. ICT Booking System
    By sLiDeR in forum Network and Classroom Management
    Replies: 3
    Last Post: 8th August 2007, 07:53 AM
  5. Online Booking System
    By imullings in forum Educational Software
    Replies: 2
    Last Post: 5th September 2006, 08:10 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
  •