+ Post New Thread
Results 1 to 8 of 8
Home Access Plus+ Thread, Importing Bookings from SIMS in Projects:; Hey, i'm just muddling my way through a HAP+ install (v6.4) and i must say it is looking awesome. I'm ...
  1. #1
    mattgrimley's Avatar
    Join Date
    Jun 2011
    Location
    Bedfordshire
    Posts
    316
    Thank Post
    35
    Thanked 21 Times in 19 Posts
    Blog Entries
    1
    Rep Power
    10

    Question Importing Bookings from SIMS

    Hey, i'm just muddling my way through a HAP+ install (v6.4) and i must say it is looking awesome.

    I'm struggling a little bit at working out how to import room booking data from SIMS.
    What specific data format must the export be and should the room names in HAP match the "Code" or the "Name" from SIMS??

    Any advice would be greatly received!

    Thanks again for this software, it's looking great!

    Matt

  2. #2
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,520
    Thank Post
    37
    Thanked 501 Times in 432 Posts
    Rep Power
    113
    At the moment it is best to use the admin panel and manually add the timetabled lessons in. The SIMS import button would need to be done each week, or every so often.

    SIMS needs to export a CSV

    room (as set in HAP+'s config), ?, ?, subject, teachers email, lesson year, date:lessonnumber

    I think. I wrote it from someone elses SIMS CSV export, it it prob doesn't even work anymore.

  3. #3
    mattgrimley's Avatar
    Join Date
    Jun 2011
    Location
    Bedfordshire
    Posts
    316
    Thank Post
    35
    Thanked 21 Times in 19 Posts
    Blog Entries
    1
    Rep Power
    10
    ahh, i see.

    I thought it might import the "static bookings" area (i.e. week/day/period) rather than date/period.

    I have tried populating the StaticBookings.xml file manually using a cleaned up bunch of data from SIMS, but it doesnt seem to like my data 100%. A couple of entries for week 2 in one room show in the staticbookings list and don't appear to have errors, but do not show in the timetable.

    I'll have another play on Monday to see if i can get something more consistent and informative
    I'd love to shift our ICT bookings onto HAP if i can - they are the bain of my life!

    Thanks very much for the quick reply!

    Matt

  4. #4
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,292
    Thank Post
    614
    Thanked 161 Times in 146 Posts
    Blog Entries
    78
    Rep Power
    83
    I had this working a while ago, but Ive moved schools since - and Im digging around! Will hunt out the format I used - as Im going to need it again!

  5. #5
    mattgrimley's Avatar
    Join Date
    Jun 2011
    Location
    Bedfordshire
    Posts
    316
    Thank Post
    35
    Thanked 21 Times in 19 Posts
    Blog Entries
    1
    Rep Power
    10
    Well, i made a bit of progress. It turns out the data exports from SIMS were a bit odd. Manually sorting the XML file works consistently.
    If you have any thoughts on the report to extract the data, I'd love to hear them. I got an assortment of odd data exports when i was playing and unfortunately our SIMS support is via our LEA who weren't able to help...

    Either way, even if i have to add the data manually, we are likely to use the booking system here. The end-user experience is tremendous

  6. #6
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,292
    Thank Post
    614
    Thanked 161 Times in 146 Posts
    Blog Entries
    78
    Rep Power
    83
    Plus one here for the Bookings bit as well. The additions of the extra features recently (templated emails, calendar reminders [been there a while], multiple admins [thanks for that @nickbro ])make it an all round winner :-)
    Last edited by TheScarfedOne; 29th June 2011 at 01:12 PM. Reason: failing to type properly!

  7. #7
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,520
    Thank Post
    37
    Thanked 501 Times in 432 Posts
    Rep Power
    113
    The SIMS import option will be rewritten when our Dept Head finally puts the timetable into SIMS. Once I can get my hands on what SIMS can/cannot output I can write the code to parse it.

    There may even be a new feature in HAP+ which will show your timetable, based on the SIMS info

  8. #8
    mattgrimley's Avatar
    Join Date
    Jun 2011
    Location
    Bedfordshire
    Posts
    316
    Thank Post
    35
    Thanked 21 Times in 19 Posts
    Blog Entries
    1
    Rep Power
    10
    the report found in this thread exports the timetables in a really nice format:
    SIMS to MRBS: Script Available

    It exports to a csv file in the following format:

    Room, Day Name, Period, Class Name, Staff Code, Subject Code, Students.

    with a row for each unique lesson.

    For us with a 5 period day and a 10 day cycle, this yields (up to) 50 rows per room. I.E. This is not date specific, but the actual timetable for the rooms (perfect for the staticbooking.xml file).

    The Sims Report was written by "McTedo" in the thread linked above.
    With a little bit of modding, i can turn this into a nice set of "staticbookings"

  9. Thanks to mattgrimley from:

    TheScarfedOne (4th August 2011)

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Importing Email Addresses into Sims.NET
    By Geoff in forum MIS Systems
    Replies: 49
    Last Post: 27th September 2012, 02:07 PM
  2. MRBS - Import .CSV isn't importing my room bookings
    By princessbucki in forum How do you do....it?
    Replies: 0
    Last Post: 26th August 2010, 11:28 AM
  3. Importing new aspect data into SIMS
    By MattMitchell in forum MIS Systems
    Replies: 1
    Last Post: 21st May 2009, 08:30 PM
  4. Importing into SIMS Attendance
    By Jonsi in forum MIS Systems
    Replies: 12
    Last Post: 7th November 2007, 10:18 AM
  5. Importing Users into Moodle from SIMS
    By Ric_ in forum Virtual Learning Platforms
    Replies: 16
    Last Post: 23rd January 2007, 08:34 AM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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