Pashers

Haha I was too slow with the news update wasn't I!

BBC news: http://www.bbc.co.uk/news/technology-13145562 From iTUNES STORE - TERMS AND CONDITIONS

Oh...I thought it was a newbee on here *sighs*

Papercut has a report on how many trees you are killing - how green you are. It might be worth displaying to staff how many trees they kill. Hmm maybe I should have a message box saying "you are about to kill 0.001th of a tree, a thousand more and you've killed one honest tree" Just a thought

I've got an idea: Create a chess engine that uses all the computers in the school :-) I'm sure there's open source ones out there like Crafty which will help start you off.

Just thought I'd do something when I was a wee little bit bored :-) Fancy doing your own?

If you are planning on using PHP and you want a single sign on look into SSPI. You'll need to add the LDAP module as well for further security. what you thinking of doing? I might be able to help and chip in at times :-)

holidaygenie but I brought my Australian tickets from there. (Whoop). But I wouldn't really advise you to use them. Try moneysupermarket?

MSSQL (Express for free)?

Could be having issues with the C:\documents and settings area. Try it with a local administrator account?

Or a lazy/quick dirty way to do it (I would not recommend this as it means duplicating yourself but if it suites your needs and makes your life easier): tblMakeAndModel tblMakeAndModel_ID (PK) tblMakeAndModel_Make (text) tblMakeAndModel_Model (text) select tblMakeAndModel_Make from tblMakeAndModel where tblMakeAndModel_Model = @variable[/Code]

Are you new at databases? I would have three tables - one for the make and model (tblMakeModel) one for the Make (tblMake) and one for the Model (tblModel): tblMakeModel: tblMakeMode_lID - auto num (pk) tblMakeMode_MakeID - num (fk) tblMakeMode_ModelID - num (fk) tblMake: tblMake_ID - auto num (pk) tblMake_Make - text tblModel: tblModel_ID - auto num (pk) tblModel_Model - text PK - Primary Key FK - Foreign key This would help save memory space and repeating your self. The SQL would look something like: select tblMake_Make from tblMake left outer join tblMakeModel tblMake_MakeID = tblMakeModel_MakelID left outer join tblModel tblModel_ModelID = tblMakeModel_ModelID where tblModel_ID = @ModelID Note that the @ModelID is the variable you want to look up. If you're not sure what the above does here it is rewritten slightly differently: select tblMake_Make from tblMake, tblMakeModel, tblModel where tblMake_MakeID = tblMakeModel_MakelID and tblModel_ModelID = tblMakeModel_ModelID and tblModel_ID = @ModelID

How would this relate to the school setup, it's got the holiday terms and all the information in SIMS, and the query I've created does exactly what I want it to do - the report you showed me didn't do exactly what I want it to do. - Matt40k You mentioned you can get it 'wrapped' up with SIMS approval and make reports. How do you go about doing this?

I've had a look at the report and I must admit I don't use SIMS at all. So I might be missing the point with the report, but when I run it it still shows them teaching on half term etc. Also it still didn't tell me if it was Mon1 or Mon2, it still came up with both and for the week. Yes I'm using the SA account to bypass it. Now I have the query I might make it so they can access it via the VLE too. so they can download it and import it etc.

It didn't have the dates assigned to the days. I've created a program now which does the following: The staff enters in their staff code. The script runs and saves a text document in the following format - Date/Day Name/Class Code/Period Start/Period End/Room/Class so the result would be: 02/02/2011, 2Tu, 7DS/Ar, 10:10, 11:10, D8, Ar, But it will display the results from today to the end of the year. They then could import it into the calendar. The teacher could then go into Outlook and import this data into the calendar.

Here's an example of what the outcome would look like: Date, Day, Subject Code, Start Time, End Time, Room, Subject 02/02/2011 00:00:00, 2We, 12B/Ma3, 10:10, 11:10, D9, Ma, Then the teaching staff can choose what fields they wish to have and import it into the outlook calendar. So for example they might just want the date and time (obviously needed), and subject code and the room. If there is a script out there which someone has already done which gets this then yes I have re-invented the wheel :-). Whereas, I got the impression that the one you showed me didn't do the date it just got the day i.e. Mon1. When I wanted 07/02/2011 - Mon1 etc.

Yes, I've managed to do the query so it retrieves the date/day/class code/non-teaching (for example if they are on call, reg, cover)/holidays/school activities. And I've tested it and imported it into the outlook calendar. Works beautifully . But just wondered if we were allowed to select from SIMS.

I did have a search around and I wanted it slightly different, I wanted it so each day had a date assigned to it (e.g. 17/01/11 was Mon1) etc. Then the staff could import it into the outlook calendar. I didn't just want each day if that makes sense.

Well I've managed to gather the timetable for the year for an individual teacher. With teaching lessons/rooms and assigned non-teaching lessons (i.e.. if they have other duties). It'll put in in a csv format so the teacher can import into outlook's calendar. Just wondered if it was OK to do this or not. Took ages to find the correct views etc.

Hey all, Just wondering what we are allowed to do in doing SQL queries on SIMS. I presume we're allowed to do select statements?!

SEN software seems to always cause me problems. I've spent three hours trying to get some software installed - Mind Reader. We have SuccessMaker as well, and I can't for the life of me work that one out

What's the worst software/program you've used? I think AOL (when I was a wee teenager) was one of the most annoying browsers I used.

Thanks Pete, that looks good to read! not sure if the 'Thanks' option is still available on here!?

2008 :-) the 7s and 8s too close together

Hi all, We've changed our network (from RM to vanilla - windows 2003/2007). We've/I've not written a disaster recovery process yet, am I right in thinking it should be a detailed document on how to recover if certain servers fail? Or for different scenarios? Do you have one if so how detailed is it? Thanks