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.
17th June 2011, 05:52 PM #1
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!
17th June 2011, 11:32 PM #2
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.
18th June 2011, 03:36 PM #3
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!
28th June 2011, 05:55 PM #4
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!
28th June 2011, 06:20 PM #5
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
29th June 2011, 02:09 PM #6
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 02:12 PM.
Reason: failing to type properly!
29th June 2011, 03:49 PM #7
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
11th July 2011, 02:36 PM #8
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"
Thanks to mattgrimley from:
TheScarfedOne (4th August 2011)
By Geoff in forum MIS Systems
Last Post: 27th September 2012, 03:07 PM
By princessbucki in forum How do you do....it?
Last Post: 26th August 2010, 12:28 PM
By MattMitchell in forum MIS Systems
Last Post: 21st May 2009, 09:30 PM
By Jonsi in forum MIS Systems
Last Post: 7th November 2007, 11:18 AM
By Ric_ in forum Virtual Learning Platforms
Last Post: 23rd January 2007, 09:34 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread