GeorgeVince

Or, find a replace all "." with an empty string to get rid all full stops.

Ah, nice one. Seems to make sense. It's difficult keeping up with all these changes! Why can't think be simple?!

How will progress 8 scores be worked out without a fine point score?

Hi, Could anyone point me in the right direction for working out KS2 Fine Point Scores from KS2 test marks? I've used the conversion tables that were on this site previously: HGfL: Teaching & Learning: Assessment: Attainment Data - but they've all been removed. Managed to locate conversion templates for 2011-2015, but cannot find a 2016 conversion template in SIMS. Does anyone know how to convert our new Year 7's scores into a KS2 FPS? Thanks!

What was the issue just out of interest?

A really rough and ready method, no error handling as I have no idea how to do it in VBA! Public Sub renamePhotos(pathName As String) Dim objApp As New Word.Application Dim oTempWd As Word.Document Set oTempWd = objApp.Documents.Open(pathName) Dim fso As Scripting.FileSystemObject Dim strToSaveAs As String 'Obtain the direct path name, without the filename directPathName = Left(pathName, InStrRev(pathName, "\")) strToSaveAs = directPathName & "WarboardPhotos.html" Set fso = CreateObject("Scripting.Filesystemobject") If fso.FileExists(strToSaveAs) Then MsgBox "File exists" Else 'Save the SIMS export as a HTML file, this produces a HTML file and a folder named xxx_files where the images are kept oTempWd.SaveAs directPathName & "WarboardPhotos.html", FileFormat:= _ wdFormatHTML, LockComments:=False, Password:="", AddToRecentFiles:=True, _ WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _ SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _ False 'Navigate to the xxx_files folder and find the jpg files Dim StrFile As String StrFile = Dir(directPathName & "WarboardPhotos_files\*jpg*") Dim upnNumber As String Dim ctr As Integer ctr = 1 'Loop through the files Do While Len(StrFile) > 0 ctr = ctr + 1 'Obtain the UPN number from the original file, located in the 2nd column upnNumber = oTempWd.Tables(1).Cell(ctr, 2).Range.Text 'Rename file If StrFile <> upnNumber Then Name directPathName & "WarboardPhotos_files\" & StrFile As directPathName & "WarboardPhotos_files\" & Left(upnNumber, 13) & ".jpg" End If ' Next file loop with Dir function StrFile = Dir Loop MsgBox ("Photos Renamed") oTempWd.Close objApp.Quit End If End Sub

Good Afternoon All, Firstly let me explain the situation I'm in. I'm responsible for generating reports for pupils in the school and this involves checking all teachers have entered data into aspects. My line manager insisted that each Marksheet had to be checked manually and could not be automated, this meant opening up and checking every single student in every single marksheet had data inputted... wow. This was NOT a fun activity. I insisted there must be a more efficient way to achieve this, and came up with the solution of using the Missing Marks Report in SIMS. (Reports -> Assessment -> Missing Marks Report). Unfortunately it duplicated results for every Supervisor of the marksheets, a simple problem that could be fixed by pulling data from SIMS on each main supervisor and using a vlookup to match the template with the correct supervisor. Data exported to a pivot table and can be used to dig through data. Wayhay! The Process of checking reports done in 10 minutes instead of 2 days!! I'm looking for a way to automate the process using CommandRreporter and a report definition. Does anyone have a report definition or an idea how I could emulate the missing marks report using the report designer?

Good Morning, We use SISRA here and it's a really powerful analysis tool, I can't speak about 4MATRIX because I've not personally used it. SISRA allows subject coordinators to almost effortlessly analyse individual students or headline figures (whether they use it is another matter...). The only downside is ensuring data is up to date in SISRA as it can sometimes be a headache maintaining SIMS and SISRA in unison, a change in grade in SIMS means you must also manually change the grade in SISRA. I don't know if 4MATRIX syncs with SIMS somehow or the importing of data is also done manually. You're right - SISRA is web based, however, personally I use it to export data and generate my own reports and graphs using Excel. SISRA also provide great web support, I took my role on at the beginning of the year having never worked at a school before and they were always more than happy to help with any queries I had with the software.

Wow, missed out a slash in one of the report parameters....... you can tell it's been a long week!

Should do! Just created a batch file after and it worked, still no sign of the report output though? CommandReporter.exe /user:username /password:pword /report:"GV Tutor Email" output: "C:\testOutput.xml" echo > c:\test.xml echo 123>> test.xml pause

Hi, I'm trying to get a report to run using the CommandReporter, my bat file contains the following: CommandReporter.exe /user:username /password:password /report:"GV Tutor Email" output: "C:\testOutput.xml" pause The command line reports I'm logged in, the report is found and run but I cannot see any output? Am I missing a trick or should some privileges be set to generate output?

@PhilNeal Thanks, I think I can achieve all I need to with scheduled tasks and the CommandReporter.

Been digging around, think this is what I'm trying to get at: http://www.edugeek.net/forums/mis-systems/66215-sims-net-reporting.html#post593543

Ah, I see. I'm straight out of University and landed a role as a Data Analyst at a School and I've been looking at ways the school can use data to improve performance. I've got the impression a lot of the data seems to be locked away in SIMS so was trying to automate the process of extracting and manipulating it. The best I can currently do is pull off reports with macro enabled workbooks to generate dashboards, but none of the can be done automatically. A member of staff has to run the report manually via SIMS. Am I barking up the wrong tree trying to find a different way outside of the SIMS GUI to extract data?

An idea that's been thrown around here is some sort of system to automate email correspondence to parents when a Student has a behavior or achievement logged against them. Of course this could be done with the advanced reporting system using an excel macro enabled template, however it would require someone to manually run the report each day. Could the Command Reporter be configured to pull this data automatically at the close of play each day?