Classroom Bookings

[plock]

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!

[webman]

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?

[timbo343]

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/download/bookingsystem3/index.asp

[plock]

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

 

Sorry 'webman'!

[plock]

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!

[plock]

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/download/bookingsystem3/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?

[ICTNUT]

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

[ICTNUT]

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

[plock]

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

 

As for the DatabasePath.asp, see it attached.

databasepath.txt

[plock]

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

 

Anything obvious I'm doing wrong?

mod_files.zip