Esteban_Child_of_the_Sun

Since the SOLUS 3.12 upgrade, you can now specify what you want SOLUS3 to install in the javascript file Capita provide with SOLUS3 for when you are doing manual installs, it could easily be adapted to work in a script. var wshShell, wshSysEnv;var fso, f1, typeLib;fso = new ActiveXObject("Scripting.FileSystemObject");typeLib = new ActiveXObject("Scriptlet.TypeLib");wshShell = WScript.CreateObject("WScript.Shell");var logFileName = WScript.Arguments(0);var agentAddress = WScript.Arguments(1);var dsAddress = WScript.Arguments(2);var keyFileName = WScript.Arguments(3);var msi32 = WScript.Arguments(4);var msi64 = WScript.Arguments(5);var msi = "";if (is64()) msi = msi64;else msi = msi32; wshShell.Run("msiexec.exe /lv* \"" + fso.BuildPath(wshShell.Environment("SYSTEM")("TEMP"), logFileName) + "\" /i \"" + wshShell.CurrentDirectory + "\\" + msi + "\" AGENTSERVICEADDRESS=\"" + agentAddress + "\" AGENTID=\"" + typeLib.Guid.toString().substring(0, 38) + "\" DEPLOYMENTSERVERADDRESS=\"" + dsAddress + "\" RSAKEYPATH=\"" + wshShell.CurrentDirectory +[color=#008000] //"\" PREDEFINEDAGENTTARGETS=\"Sims Fms Discover" +[/color] "\"", 0, true);function is64() { var shell = WScript.CreateObject("WScript.Shell"); return (wshShell.Environment("SYSTEM")("PROCESSOR_ARCHITECTURE").indexOf("64") + 1);} Edit: Can anyone tell me why, when I paste code into this forum it loses all the new lines?

pitty, it looked like it could be an interesting development

I'm not sure if it's still available, but you used to be able to generate FFT data from within SIMS. Here is an excerpt from their brochure "When it comes to raising standards, it’s important that you have accurate estimates of future student performance so you can set challenging targets for all your students.With SIMS FFT Estimates, secondary schools can generate their FFT student estimates within SIMS – with no need to import them from the FFT website. Our partnership with FFT brings a flexible approach to managing your student predictions in SIMS. It’s more accurate, there’s less chance of error from manual importing, and with the ability to make changes directly within SIMS, it’s easier for your staff to use. Plus, the new group filter allows you to only generate FFT Estimates for students taking each subject. And with everything all in one system and all your data in one place, you can ensure that everyone is on track."

That would be nice, but no, you still need to write them yourself. It is just a free command line XSLT processor you can use in scripts to manipulate XML files.

In SIMS go to "Tools | Housekeeping | Delete Unlinked Contacts" and assuming she is no-longer linked to anyone she will appear int he list. Selecting her in that focus will remove the contact element of her record. (This will not delete the student record)

I'm happy to talk about the process but our specific tracker is part of our SLA with our schools, so there would be a small charge for schools outside our SLA. Most of the charge is to cover our time helping get it up and running at each site and explaining how to maintain it. If you're interested PM me. The reporting definition is really simple, UPN Legal Surname Legal Forename Gender Date of Birth Percentage Attendance Year to date Then output as an XML file Then we use a Powershell script to run the report via Command Reporter and get the current date, then using all that information I use a free XML 2.0 processor called AltovaXML to convert the output using a custom written XSLT file in to an Assessment Manager results file with a unique filename for each week of the academic year. That way all the staff in school is one a week import the file to SIMS and accept all the defaults as all the data to uniquely match the pupils was extracted from SIMS by the report. Then I have an Assessment Manager template set up with a data review column for each week of the academic year and whatever formulas the school in question want to perform on the data. The mechanism (i.e. the scripts and XSLT files) we use for a multitude of things, from putting Proficiency in English data in an aspect so you can see it on marksheets to complex calculations like working out which pupils schools should be spending their Pupil PRemium money on (as the ticks need to be used for those that were funded)

I'd log that with your SIMS support as it shouldn't be that big. We had a school with a similar issue and it turns out there is a bug in the Discover calculations/transfer routines that causes some tables in the SIMS databases to grow very quickly. It required a site-specific patch to shrink the database and stop it growing like that again.

I ended up doing this in assessment Manager, using CommandReporter to create an XML file which I convert into a results file for easy import by staff at the school. Schools seem to like it and it's used in about 40 schools so far. Schools seem to prefer it over the Excel route as you can have it as a marksheet behind the registers and an all year group marksheet can be sliced by the plethora of groups in assessment manager without having to re-write an excel report.

that and that they have the correct teacher code for the current year and are marked to provide cover in panel 2. Other than that, check they don't have a clash with some other timetabled/alternative curriculum class at the specified times. Validate memberships can sometimes help. Other than that I'd log a call with your SIMS support as it will require more specific investigation than you'd want to do over a public forum.

Have you checked that have a valid entry in 'Manage Classroom staff' for the current academic year?

We've not had anything reported to us and we support a few schools using intouch. What have Capita said when you reported it to them?

I've found that these sort of things can sometimes be done straight after you re-start the SQL service on the server as this throws everyone and everything out of SIMS (though some log back in very quickly).

I've not come accross that, other than suggesting running validate memberships I think this is one for your SIMs support team.

I've been looking for someone to automate the import of assessment data into SIMS for years. The cheapest anyone has ever quoted me to automate the import of an assessment manager result file (i.e. an XML with all the required information about what aspect/result set to attach the results to) was £15,000 If you find anyone willing to import ad-hock pieces of data into SIMS I'd certainly be interested.

You probably need to re-apply the timetable and map it to the correct days. (SIMS.net | Tools | Academic Management | Apply timetable)

If you export the report from SIMS and rename the file extension to .zip you can extract the excel document with the macro, if you extract then open the excel document it will give you an error about not finding ReportData.txt, do into the developer tab and open the macro, step in to the macro then copy the ReportData.txt file into the same directory as your Excel file (you can find it in your 'My Dcoument\tempSimsRpt' folder and assuming your report was the last one you ran in SIMS it will contain the data in question. Then just step through the macro watching what it is doing.

I've not come across that before, what version of Excel are you using? If you take the SIMS output you can manually run the autorun macro over it and see when it is splitting the data

Sounds like you haven't applied Patch 23236 [3.62.771-3.62.771] PRB16356 - Patch to resolve all Homepage Attendance summary panel issues.

That's a reasonably simple report to write, assuming you have the Mailingpoint in SIMS set to the oldest child and have updated it this academic year (Tools | Housekeeping | General, panel 3) Create a report for students on roll, Filter it by mailing point is true Add data-items: Student Name, Contact (filtered by P1) email address, siblings year groups

There is a utility in the form of a patch on SOLUS3 that will read in an import file to update/insert/delete email addresses in bulk. Ask your SIMS support for "Import of EmailAddresses and Telephone Numbers from a CSV File" handbook and patches 20343 and 17195 (Previous patches 18029 and 17188 have been replaced with 20343) (those were the current patch numbers when I did it last year)

Redeploy will only send out the upgrade command to agents that don't have the latest version of SIMS, however, unless you've been on SOLUS 3.12 before you applied the summer upgrade you'll have to manually download it again from Capita's servers to avoid any issues. Also there is a consolidated Workstation Patch 4 coming out today. You could wait and just apply that tonight to all your machines.

Capita updated their permissions on several things in the Summer release, in Care in the reporting section was one of them (though they didn't get all fields) have you got SLT as a permission group for the user you are designing the report as?

I have found with previous versions that it doesn't like having the GUI open when it's trying to upgrade it, but it doesn't seem to be able to auto close it. Try re-deploying the GUI and then close the GUI down. I've only done 4 SOLUS 3.12 upgrades and all have done the GUI without any issues.

There is a utility in the form of a patch on SOLUS3 that will read in an import file to update/insert/delete email addresses in bulk. Ask your SIMS support for "Import of Email Addresses and TelephoneNumbers from a CSV File" handbook and patches 20343 and 17195 (Previous patches 18029 and 17188 have been replaced with 20343) (those were the current patch numbers when I did it last year)

or if you want to be a pioneer you could use 3D XPoint