ilsley_SIMS

Hi. All you need to do is go into Tools > Academic Management > Course Manager > Maintain Course and identify all the courses that are being run in your sixth form. For each course, under the Classification section, ensure that the correct QN code has been entered. If the QN does not appear in the list, then you will first need to add it manually in Tools > Academic Management > Course Manager > Update QANs and Discount Codes for Course Manager. Simply search for the QN here and then click Update in the top left corner. Once you have correctly assigned all the QN codes to each course in Course Manager, you just need to update course memberships via Tools > Academic Management > Course Manager > Update Course Memberships Doing this exercise will push through each student on each course into the learning aims area of the census, and this will (in theory) clear all your 2870 errors. If you need extra help, PM me. Thanks!

Any takers with this? Still haven't managed to get our BTEC results to show up on the broadsheet.

I'm having the exact same problem. All the other results are pulling through correctly, but the BTEC ones appear to be missing. Any help will be appreciated!

Hi. I don't put any date range filters on the report - the only filter I use is year group (i.e. Year 7). This pulls out the correct list of kids, but just renders some of them blank. Here are the report options I select: - Student - On Roll Students - Fields chosen: Legal Surname, Forename, Previous School, Date of Arrival, Leaving Date - Filters: Year 7 - Sort: None - Effective From date: 05/09/2016 It's a strange one!

Thanks for responding. When I run the report, I set the 'effective from' date to 05/09/2016, so it treats them as current Y7s. The reports works for some students - it pulls out their primary school as expected, but most of them are rendered blank. Completely confusing! As for current school - is there a 'current school' field in the list anywhere? I can't seem to see it anywhere...

Hi, I have imported CTFs for our new Y7 cohort starting in September, but I needed to now run a report that extracts their previous school (i.e. their last primary school). I have built a report that includes the 'previous school' field, but when I run it, the output is blank for most of the students (around 70% of them). I can't for the life of me why this would be the case, as I've checked each affected student record, and it definitely contains their previous schools. Does anyone know if there is a fix for this? Thanks.

Thanks! I'll give that a try.

Hi, I am trying to amend one of our BTEC gradesets, but when I try to do so, I get an error saying that the change cannot be effected as there are previous results already recorded for that gradeset. That is to say, I am simply trying to change a D* (Distinction Star) to Di*, and a D (Distinction) to Di. is there any way I can amend the gradeset so that all previous results can be updated with this amendment? Thanks!

I fixed it by placing the UDF in a separate spreadsheet on our central staff shared area. In the SIMS Excel Report Template, I then added this spreadsheet as a reference in the reference library (VBA Editor > Tools > References > Browse). I then tweaked the code in the relevant sub routine like so: Sub CreateOnSubjects() Dim lastRow As Long Sheets("Sheet1").Range("AG1").value = "Subjects On Target" With Sheets("Sheet1") lastRow = .Cells(.Rows.Count, "A").End(xlUp).Row .Range("AG2:AG" & lastRow).Formula = "='CustomFunctions.xlsm'!AOB_Cat($E2:$Z2,""O"","", "")" End With Sheets("Sheet1").Range("A1").Select End Sub So every time I run this report via SIMS now, the report template calls on the CustomFunctions.xlsm spreadsheet which contains the UDF that I wrote and works perfectly! Hope that all makes sense.

Ignore this thread... I've just figured out what was causing the problem!

I can't seem to see an Excel section... or do you mean the Office section?

Any takers?

Hi, I'm trying to reference a UDF I've built in the Range.Formula property (within VBA), but it keeps giving me the #NAME? error when I run the report from SIMS. This is how I'm trying to reference it in the VBA module: Function AOB_Cat(Category As Range, ref, joinStr As String) As String If Not IsNumeric(ref) Then ref = Chr(34) & ref & Chr(34) With Category AOB_Cat = Join(Filter(.Parent.Evaluate("if(" & .Offset(, 1).Address & _ "=" & ref & "," & .Address & ",char(2))"), Chr(2), 0), joinStr) End With End Function Sub CreateOnSubjects() Dim lastRow As Long Sheets("Sheet1").Range("AG1").value = "Subjects On Target" With Sheets("Sheet1") lastRow = .Cells(.Rows.Count, "A").End(xlUp).Row .Range("AG2:AG" & lastRow).Formula = "=AOB_Cat($E2:$Z2,""O"","", "")" End With Sheets("Sheet1").Range("A1").Select End Sub If I use the UDF directly from the cell, it works fine, but I need to be able to put the formula directly into the cell via VBA. Any ideas? Thanks!

Sorry, I forgot to reply to this thread! This was indeed the problem. Basically some students' course start dates and end/planned end dates were erroneous, so I worked through each one and amended them accordingly. We finally submitted our census yesterday (only three weeks after the deadline!!!). Thank you!

Hi, I'm getting three 2870 errors relating to three Year 12 students in our Sixth Form, but for the life of me, I can't see why I'm getting this error. They each have course start dates, end dates and planned end dates for each of their courses in Course Manager. Any ideas??? Thanks!!

I second that. It's a bit of a no-brainer for me.

Thanks! Seems like a viable workaround, so I'll give it a shot.

Hi. Is there a way of assigning a 'team' achievement to a house, i.e. not to a specific student in that house, but to the house as a whole (a team). Initially I thought to create six dummy accounts and assign them to each house, which would allow teachers to assign house 'team' achievements to those dummy accounts, but I didn't know what the ramifications of that would be. It would certainly affect our numbers on roll, but would it cause any problems for the upcoming censuses? Any advice would be appreciated! Thanks.

Thanks. I've just done that!

That makes sense, but it does beg the question as to what is to be done in such instances... I'm hoping Capita have a solution in place!

Hi. I'm trying to delete a couple of duplicate staff records that were created in error, but the 'Delete Staff' routine doesn't allow me to delete said records; I get a record summary, which contains the following: This staff has Database Data (1 record). It cannot be deleted. What does this mean? And is there any way it can be overriden? Thanks in advance.

Thanks guys. I've managed to get the data out now! I selected the 'accepted pre-admissions' option and selected the data items I needed.

Hi, I'm trying to extract some data for our new Y7 cohort, even though the new academic year is not technically active until tomorrow. I've tried designing a custom report, but I can't see an option where I can just pull data for all 'future' students (i.e. the Y7s). Any ideas anyone?? Thanks!!

See the attached screenshot. I'm not sure it's that straightforward to get termly attendance from SIMS; that is to say, there's no built-in function that allows you to pull this off as a straight merge field (beggars belief!). There is a workaround solution in place, however: http://www.edugeek.net/forums/mis-systems/136933-termly-percentage-attendance-report.html (see post number 2). Once this report is set up, you can then merge the relevant termly percentage fields to a Word document. We did this for our tutor reports this year and it worked a treat... and went down really well with teachers and SLT too. Sorry I couldn't be more help!

I've got both those options ticked, but you're right: I've assigned the ICT aspects to all students. I know what I need to do now! Thanks for all your help!