Static Booking / AD issues

[7UD9]

Hi

 

I'm using version 9.0.424.1200. I'm in the process of configuring the Booking System, I've ran the SIMS report and I'm trying to import the XML into the BS CP. I'm getting the following error:

 

Sequence contains more than one matching element

 

I assume that it is related to this:

 

CAUTION: The Teacher's Name from the SIMS Export (Title Initial Surname) needs to equal the Notes/Display Name field in AD for that user, or the Notes/Display name only has one person with that surname

 

The latter bit of that is not clear, it says that it must equal the AD Display Name OR only have one person with a surname. Should that be AND? Can teachers with the same surname exist? We have several...

 

Any ideas?

[7UD9]

I've removed the records containing the duplicate surnames so now all teachers have unique surnames, I'm still getting the same error.

 

Server Error in '/' Application.
--------------------------------------------------------------------------------

Sequence contains more than one matching element 

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.InvalidOperationException: Sequence contains more than one matching element

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace: 


[invalidOperationException: Sequence contains more than one matching element]
  System.Linq.Enumerable.Single(IEnumerable`1 source, Func`2 predicate) +4134592
  HAP.Web.BookingSystem.admin.Default.importSIMS_Click(Object sender, EventArgs args) +643
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +155
  System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3804

 

-------

 

So I've been through the SIMS output (sims-bookings.xml) and found several duplicated entries, I've removed these and now the file seems to import (I assume so as I receive no error, nor a confirmation).

 

My problem now is that nothing shows on the booking form, I'm guessing I have misconfigured it but as I cannot find any documentation relating to the booking form I have nothing to confirm this. Do the Lessons need to have particular names? I really could do with some pointers here..

Edited November 7, 2013 by 7UD9

[nickbro]

You need to program the lessons and resources in the HAP Config system, setting lesson times, etc. You will then go to the Booking System CP and set the term dates. You can inspect staticbookings.xml and see what's appearing

[7UD9]

Thanks Nick, I have done that, I just don't know if I've done it right. Staticbookings.xml is completely empty.

 

 

 

Here's the bookingsystem section from HAPconfig.xml

 

 

 

I've just noticed I had named the sims-bookings.xml incorrectly, this is why I no longer received the error. Now the file is named correctly I am back to receiving the "Sequence contains more than one matching element" error.

Edited November 8, 2013 by 7UD9

[7UD9]

I got around this by entering the room bookings directly into StaticBookings.xml

[nickbro]

Good to hear, sorry if it was extra work. The import system can be very hit and miss, as I only had our timetable to work with.

[7UD9]

the output from SIMS needed a lot of editing anyway, we have a strange username convention.