Priya_Shah

If you have the SQL password and can login to SQL Server Management Studio, copy and paste the script below as a New Query and Execute, which will shrink the LDF file. Please note that in some instances '361001_log' may be 'sims_log' use sims go alter database sims set recovery simple; go dbcc shrinkfile('361001_log', 1); go alter database sims set recovery full; go

Hi All, Thanks for your replies, it turned out the ISO I was using was dodgy. After a clean uninstall and reinstall of Office, all issues were fixed...

Hi All, I've had an issue when running/creating Word List & Mail Merge reports in SIMS. I have tried everything google suggests (i.e. uninstall old version of Office, check the registry, run repairs etc) and still can't fix it.... can anyone help? Thanks in advance Priya

Hi all, Another update from Capita regarding the latest patch, the item's that Capita are referring to are changes to Exclusions in the Spring Census: Method to be used for implementing the changes Database patch to deal with items 1 to 4 above. Fileset 1403 to deal with items 5 to 9 above. We believe that it is important to deliver the database patch and the fileset at about the same time to avoid incompatibility and the confusion and help desk cases this would generate. Timetable for implementing the changes We expect to complete the creation and testing of the database patch during w/b 16/12/2019. If the DfE provides us with their revised validation and summary report files at the start of next week then we will also expect to be able to complete creation of Fileset 1403 during w/b 16/12/2019.

Hi All, Not sure if you've heard, but there is another patch due soon! "The DfE's very late changes to the exclusions aspects of their specification are relevant here, which means that the above is only completely achieved in the software after the application of a database patch and series 1400 fileset (to be provided ASAP)." They haven't provided an ETA for the patch, but are waiting for the DfE to confirm changes before creating/releasing the patch. Priya

Hi all, Any/All New FMS accounts created this Autumn, have lost access to specific reports within the Software. e.g. FMS Trial Balance Report By I&E I have a call logged with Capita, and I assume they are working on a fix, but this has now affected 6 schools. The only workaround we can provide for the users to use old accounts created before the Summer Upgrade, which as we know, sharing logins is a no no! Has anyone else had issues with New FMS accounts this Autumn? Have you found a fix? Thanks Priya

sorry for the late reply Matt, it's a busy week! The Schools are currently only on google for email, so the link you sent is the answer! Though we do have a school who want to be fully google, they are keeping a windows server and a few PC's + RDS, for now, just so they can continue using SIMS. (I don't think they will be sticking with SIMS for too long though, as they want to move away from microsoft all together) Finally, I think to answer my own question, without asking schools to spend money on a license, the solution will be to store the dashboard in a read-only folder on a shared drive! Thank you Edugeek Community, can always count on you lot!

Thanks for all your suggestions, I agree £1.70 per user is peanuts in the grand scheme of things, but as an SSU I don't like the idea of asking school's to fork out more money! One more question, if a school is on google mail, how easy is it for them to set up a Microsoft Education account, in order to buy the cheap licenses. Thanks

Hi All, Does anyone know if it is possible to make a Power Bi Desktop file (.pbix) read-only? I am trying to build a dashboard, but don't want users accidentally dragging, dropping or deleting anything. I know it is possible when using the licenced version, but I will be sharing the actual file and not publishing to web. Google is sending round in circles! Any help would be appreciated. Priya

Hi, You can also resolve this by using move address. When you enter the new (same address), you will see a prompt asking if you want to move all people linked at the address, deselect those that do not live together.

Hi You can export a list to html via System Manager, provided you have System Manager permissions. Go to Focus | System Manager | Manage Users Change the Role drop-down to Any Click Search (binoculars) Then Print

Hi I had the same issue last week. The fix is to uninstall and reinstall the Solus3 Deployment Server UI and Service. Priya

Hi Andrew, The patch is usually run alongside Patch 20647. Patch 22573 will re-index all the tables in the SIMS database and patch 20647 will update the SIMS databases internal statistics table. Hope that helps Priya

Hi, The following from ICO should point you in the right direction: https://ico.org.uk/for-organisations/education/

There is an alternative method which I prefer using and can be used while users are still logged in. Open and login to SQL Management Studio, use the following for the query (depending on the names of your DB's) and Execute. use Discover go alter database Discover set recovery simple; go dbcc shrinkfile('discover_log', 1); go alter database Discover set recovery full; go use sims go alter database sims set recovery simple; go dbcc shrinkfile('361001_log', 1); go alter database sims set recovery full; go use fms go alter database fms set recovery simple; go dbcc shrinkfile('ccsfms_log', 1); go alter database fms set recovery full; go