dhassen

lol no. I've been at Ribblesdale since October 2004 and will be very sad to leave. Like I say, great place to be.

Yes I know, like I say interesting though.

A first degree is different from a 1st class.......

I'm moving on for progression, I've got a technical role at a large University. Interesting how that's what people are interested in!

We're advertising my role because I'm moving on. Vacancies « Ribblesdale School It's a great place to work, I've loved it. The people and town are great, it's a really great school and place to work.

Hi, yea by active classes I mean classes that are currently running - not legacy ones. That view did bring in all classes from SIMS, including ancient ones that are obviosuly no longer used. I did the usual thing of managing to find my own solution before an answer was posted here though, with the following ammended view: SELECT DISTINCT p.class_name AS course, p.staff_initials AS person, 'teacher' AS role FROM sims.curr_via_classperiods AS p INNER JOIN sims.sims_base_group ON p.base_group_id = sims.sims_base_group.base_group_id WHERE (sims.sims_base_group.active_state LIKE 'A') UNION SELECT DISTINCT TOP (100) PERCENT p.class_name AS course, m.unique_pupil_no AS person, 'student' AS role FROM sims.curr_via_classperiods AS p INNER JOIN sims.stud_via_group_members AS m ON m.base_group_id = p.base_group_id INNER JOIN sims.sims_base_group AS sims_base_group_1 ON p.base_group_id = sims_base_group_1.base_group_id WHERE (sims_base_group_1.active_state LIKE 'A') Thanks for the reply anyhow.

Hi everyone, not sure if to post this here or in the MIS forum, but here goes. I've got moodle working with courses brought in from SIMS with help from SIMS and Moodle Integration I used the view they suggest, but it brings all classes ever - not just the active, currently running ones. Can anyone help me out with a view that gives the same result but only brings back active classes? I've been trawling through the SIMS views and tables but I've had no joy so far. Many thanks Dave

I want to get a feel for how other schools are doing things regarding Vista. I'm sure there have been other threads like this in the past, but I've got a slightly different slant, seeing as Windows 7 is on the horizon.... Are you using Vista? Will you be using it (ever?), considering Windows 7 is coming? We're a Secondary school with a Technology specialism, and we used to be at the 'cutting edge' of technology and we want to be again...

I'm sure it's possible but every member of SLT (all 7 of them!!) and our exams officer hates the idea of even looking at Assessment Manager. I'm a computing professional and I found it hard to use. Ah well, they're paying me more money to develop a bespoke system so I can't say no can I? P.S. on the commandReporter notes above: I had to add a line to the script to map a drive to S: drive in order for it to work when no one is logged in (users have S drive mapped auto when they log in)

Easiest way to do this is with Dreamweaver templates. Create the new page (design) as you've mentioned. Then select the entire content div (where div id="content") and as someone above said, choose Insert > Template Objects > Editable Region. Call this region content and click ok. Now change all the links etc (although you won't yet have the content pages to link to presumably) - the stuff you want to stay the same on all pages. Now save this page as a template. (File > Save As Template) Now to create all your pages just go File > New and then click on the 'Templates' tab in the dialog box, then your site on the left then your template in the middle. A preview should appear on the right. Click create and now you have your 1st page. All you can change is the content in the content editable region. Add your content, save and and repeat this step as many times as is necessary. Then you can go back to your template (should be in Templates folder in your site and have .dwt extension) and change the links to all your new pages. Then save the template, and let dreamweaver update all your other pages. Easy! Hope this helps. Frames are bad for accessibility as far as I'm aware.

I thought this might be useful for anyone trying / wanting to use CommandReporter.exe or getting data from SIMS on a regular basis: First of all you need to have a user that can create and run reports. I created a user especially for doing this and for using commandreporter. Then log into sims with the user and create the report you want to regularly export. The report needs to be saved in the My Reports bit. Then to use CommandReporter to export the report: using the command prompt navigate to the directory where CommandReporter.exe is, likey to be c:\program files\sims\ sims .net\ then use the following as your format: commandreporter /user:"username" /password:"password" /report:"reportname" /output:"c:\exportedfromsims\report.csv" /quiet Where username is the username of the user that created the report in sims etc. There are other parameters but I'm not sure how to use them / what they are used for yet. Hope this helps anyone

Ok thanks NetworkGeezer I know its a biggy but how would I go about using CommandReporter / learning how to use it? Thanks

webman: cheers for that, I was kindof thinking that's the way I'd have to go (but without knowing how of course!) And to be honest I don't really know anything about APIs or IMS (geoff) so I'll have to do a bit more research Cheers though guys

alright chill out!!! crap eh Does anyone know if you can set up a daily export routine from SIMS then?

Hi all, I'm designing a new reporting and assessment management system for our school. I want to be able to use all the pupil info that is currently held on SIMS, hopefully directly, so we don't need to regularly import data from SIMS to the new system. I've tried to (as a real 1st base) connect to a SIMS table from a asp .net page, but everytime I try to connect I get 'invalid object name' for the name of the table that I'm selecting * from. I've just chosen the table from a list, so how can it be invalid!! Can anyone help with any of this... was wondering if SIMS has things built in meaning you can't use the data unless you ARE SIMS. Thanks in advance