+ Post New Thread
Results 1 to 10 of 10
Network and Classroom Management Thread, Classroom Bookings in Technical; Hello everyone, I am having a slight issue with the configuration of CRBS ( http://classroombookings.com ). Everything is installed correctly ...
  1. #1

    Join Date
    Nov 2006
    Location
    Reading, UK
    Posts
    487
    Thank Post
    30
    Thanked 14 Times in 8 Posts
    Rep Power
    19

    Classroom Bookings

    Hello everyone,

    I am having a slight issue with the configuration of CRBS (http://classroombookings.com).

    Everything is installed correctly and functioning. All I would like to do now is hand the system over to our Admin Team. They're all members of a Security Group in AD.

    I have added that group into the following configuration file (BookingSystem > ModuleSettings.asp), and this is working, they're all 'Managers'. However, I would like to make the Administration Team Manager an 'Administrator' of the system.

    I can't find the configuration file that enables me to make users an 'Administrator'. I have tried using the GUI, changed the user from Manager to Administrator but this has had no affect.

    Hopefully someone has had the same issue as me!

    I appreciate any guidance, as always!

  2. #2

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,413
    Thank Post
    642
    Thanked 964 Times in 664 Posts
    Blog Entries
    2
    Rep Power
    327

    Re: Classroom Bookings

    Hi Paul. I'm a bit confused here, as my CRBS doesn't have any links to AD/LDAP at the moment. Nor does it have a modulesettings.asp file?

  3. #3
    timbo343's Avatar
    Join Date
    Dec 2005
    Location
    Leeds/York area, North Yorkshire
    Posts
    3,096
    Thank Post
    314
    Thanked 296 Times in 206 Posts
    Rep Power
    122

    Re: Classroom Bookings

    i know that you are using webmans version of booking software but this one is in use at the mo and is working rather well and ties into AD:
    http://folders.devizes.wilts.sch.uk/...tem3/index.asp

  4. #4

    Join Date
    Nov 2006
    Location
    Reading, UK
    Posts
    487
    Thank Post
    30
    Thanked 14 Times in 8 Posts
    Rep Power
    19

    Re: Classroom Bookings

    :S I'm really sorry, I'm actually using the one you suggested http://folders.devizes.wilts.sch.uk/...tem3/index.asp. That's the one I require assistance with!

    Sorry 'webman'!

  5. #5

    Join Date
    Nov 2006
    Location
    Reading, UK
    Posts
    487
    Thank Post
    30
    Thanked 14 Times in 8 Posts
    Rep Power
    19

    Re: Classroom Bookings

    I've found the solution:

    I've found the problem in my case and have a workaround that might be useful.

    For whatever reason, Domain Admins did not appear in the GrpList variable. This meant my membership of that group was not overiding other settings.

    What I did was to create a new security group in AD that I called "Bookers". Then in Start/Settings.asp I modified the code (red) at line 615 to:

    '''''''''''''''''''''''Display if a domain admin Administrator
    if instr(1, UCASE(GrpList) ,UCASE("Bookers")) then
    ExtraGroup = 1
    End if
    Session("721155username") = User
    Session("721155displayname") = displayname
    Session("721155ExtraGroup") = ExtraGroup
    AdminPassword = 0
    StaffPassword = 0
    Now any staff that I want to give full administrator rights goes into Bookers security group.

    I have no idea why the group was not appearing properly but this works for me. I hope it helps others.


    Thanks for your input!

  6. #6

    Join Date
    Nov 2006
    Location
    Reading, UK
    Posts
    487
    Thank Post
    30
    Thanked 14 Times in 8 Posts
    Rep Power
    19

    Re: Classroom Bookings

    Sorry I don't like to bring up an old topic again, I have another issue, it's to do with changing the MS Database which is currently used to SQL. If you use http://folders.devizes.wilts.sch.uk/...tem3/index.asp you'll understand.

    Due to the on-going issue of MS Access databases crashing, I have decided to go with SQL.

    I have used the Upsizing Wizard in Access 2003 to create the SQL database. Everything is setup, the database is running on our SQL Server.

    I am having trouble linking to the database in the booking software.

    I have modified the Settings.txt file to include the password on the first line.

    I have changed the ModuleSettings.asp file to look for an SQL Database and finally I have modified the DatabasePath.asp to point to the new location, in my case being:

    D:\Program Files\Microsoft SQL Server\MSSQL\Data\

    I have put the SQL User, Server Name and Database Name. In my case being:

    SQLuser = "bookings"
    SQLserver = "JMA-SAGE01"
    SQLdatabase = "BookingSystem"

    Can anyone spot anything I'm doing wrong?

  7. #7
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62

    Re: Classroom Bookings

    Your database path is incorrect as you cannot connect to SQL in that way give me 5 mins and i'll post you the correct connect method

  8. #8
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62

    Re: Classroom Bookings

    In modulesettings.asp set DataType = 2

    now in DatabasePath.asp enter your SQL Server details and then try to access the booking system this should be ok then.

    You should not need to edit or change any other files for connecting to SQL Server

  9. #9

    Join Date
    Nov 2006
    Location
    Reading, UK
    Posts
    487
    Thank Post
    30
    Thanked 14 Times in 8 Posts
    Rep Power
    19

    Re: Classroom Bookings

    Thanks for your input, sorry I forgot to mention I had changed the DataType too 2.

    As for the DatabasePath.asp, see it attached.
    Attached Files Attached Files

  10. #10

    Join Date
    Nov 2006
    Location
    Reading, UK
    Posts
    487
    Thank Post
    30
    Thanked 14 Times in 8 Posts
    Rep Power
    19

    Re: Classroom Bookings

    Just to clarify, my modified files to setup the SQL link are attached.

    Anything obvious I'm doing wrong?
    Attached Files Attached Files

SHARE:
+ Post New Thread

Similar Threads

  1. Classroom VNC
    By adamyoung in forum Educational Software
    Replies: 27
    Last Post: 25th September 2009, 12:11 PM
  2. Classroom Webdeny
    By plexer in forum Group Project
    Replies: 7
    Last Post: 9th February 2009, 12:19 PM
  3. Classroom Monitor
    By speckytecky in forum Educational Software
    Replies: 5
    Last Post: 8th June 2008, 08:07 AM
  4. Which laptops for classroom use
    By pinemarten in forum Hardware
    Replies: 13
    Last Post: 13th November 2007, 11:55 AM
  5. PDAs in a classroom
    By MK-2 in forum Windows
    Replies: 20
    Last Post: 15th February 2007, 11:06 AM

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
  •