Esteban_Child_of_the_Sun

From what I've read here, you only need the free version (SIMS ID Lite) to get OneNote writeback so it may be that the Microsoft Teams Grade Sync follows along similar lines.

What version of Excel are you using? Do you have a custom template (if so does it have a custom macro in)? How many results are in the preview and how many make it to the Excel report? Does it also happen if you select different date ranges?

Yes it is. It's been a while since I've done one but I think all you need to do is run the SOLUS3DeploymentServerUIInstaller_x64.msi associated with the version of S3 you are using on the new workstation and point it to the server during the setup process. Once done you should see it in SOLUS under Settings | SOLUS3 (Show SOLUS3 targets)

We have several schools using the Teacher App and they are all working. This may be related to a similar post about TLS, have you enabled TLS1.2 in SSM as it may be that Capita has finally turned off TLS1.0 on their end?

Our LA advised schools that they had to move to TLS1.2 as Capita ONE was stopping supporting TLS 1.0 a couple of upgrades ago. I'd query with the LA why they haven't enabled the option for TLS 1.2.

SIMS 2018 Autumn release is version 7.184, capita increased the second number by 2 every upgrade (once a term) so the next upgrade will be 7.186. If you want historical versions, then -6 to get the same term but a year ago. E.g. Autumn 2017 was 7.178

run this PowerShell script as a domain user who has SSO into SIMS Import-Module *Sql* $sqlQuery = "SELECT * FROM [sIMS].[sims].[alt_message] where subject = 'Assistance Urgently Required'" Invoke-Sqlcmd -Query $sqlQuery -ServerInstance “SIMS-01\SIMS2016” -Database “SIMS" | Export-Csv D:\SIMS_Share\sims\Reports\EmergancyAlerts.csv

We don't have any schools that are using SIMS Options Online in anger but a few of our schools did trial it with a few students/staff to see how it worked. It is the students that are invited and need to choose their options. When our schools were doing it (last academic year) there was no parental involvement option and I haven't looked at it since as neither of the schools trialing it wanted to use it for real yet as they felt there were still too many unfinished parts to the product. Edit: looks like Capita listened to feedback on that one

Assuming you are doing it in SIMS you can get them like this

If I remember correctly, the SQL21012 installation media has a repair option, I'd suggest starting there. After that do a database integrity check (DBCC checkdb) through SQL Management Studio

We use TeamViewer to create ad hoc VPNs to remote servers for the purpose of running SIMS locally with a modified connect.ini allowing for school selection. Something like that could work (Other VPN options would work equally well)

I helped write a tool many years ago that does exactly what you are trying to do and we use it regularly for the schools we support. Unfortunately, Rochdale Council holds the copyright and I don't have the authority to distribute it. If you are interested you can PM me and I can make inquiries about letting others outside Rochdale LA use it.

Look at the Performance Analysis handbook in your SIMS's Documentation center (on the SIMS homepage) Analysis grids can do that quickly and easily.

Bear in mind that if you do that some graphs/analysis will no longer be accessible to you (some of that could potentially be mitigated by using the same grade set). E.g. some of the Discover graphs that show all 3 strands over time on the same graph, or some of the analysis grids that show all 3 together, etc.

There are a lot of subtleties and nuances to Assessment Manager. The starting point for any conversation around this is, What output/analysis do you want from the system? This will determine what method to implement

Some of our schools do this and feed the total Achievement points into assessment manager using a set of scripts we developed so they can mark off the spends in a Marksheet.

It wouldn't be automatic, but yes that would be reasonably simple to set up.

Have you asked Learning Ladders if they would add your requirements as a feature?

Learning Ladders is one that does this https://www.capita-sims.co.uk/products-and-services/learning-ladders

We get this occasionally at some of our schools. If you are sure they aren't in SIMS associated to an active or inactive user, then it will most likely be referring to a remnant of their account in the SQL database. You'll need to delete the user _ from both \Databases\\Security\Users and from \Security\Users in SQL Management Studio.

AS the Patch is very simple You could just schedule it in SQL Management Studio https://itknowledgeexchange.techtarget.com/itanswers/how-to-schedule-sql-query-to-run-in-microsoft-sql-server/ (just remember to schedule it to do a backup first). However, Capita would still probably complain about you executing their own code outside of DBUpgrade. You can run DBUpgrade from the commandline with the /? parameter to get the command line options for scheduling it as a task.

if you open IE on the affected machine, and browse to this reply and click this link (mailto:[email protected]), does the default mail client open up without any prompts or errors?

Error creating windows handle is saying that Capita's code to clean up memory allocation in SIMS isn't perfect and doing some tasks in SIMS leaves residual memory allocated every time you do the action. Capita does work every few years to reduce the amount of memory some tasks leave allocated and I'm guessing they haven't had time to do this optimisation for their new code in editing staff records. You'll have to log it with Capita to address as there is nothing you can do to fix it. All you can do is close SIMS every once in a while to clear the memory leak.

The text of the error message is usually far more informative than the error code as Capita only have KB articles for a handful of error codes in use.

Out of curiosity, I've just looked at 3 of our high school's SIMS databases and in all of them the asm_result_tpa_delete table is empty. Do you use any other Capita products other than the core SIMS (as ours don't?)