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!!