GeneralDreedle

Well, we play by the rules. So, with no time to go through tender before 31st Dec we now we have to send a cancellation letter to ESS at 11 Kingsley Lodge, 13 New Cavendish Street, London W1G 9UG. Drafting it now. The ill-will that this has generated, at a time when schools are already on their knees, is difficult to express politely.

Just got this notification. Are they kidding? From the new "Customer Success Team"(!) The same bug that they introduced over a year ago is still being shipped? Or reheated in some way? Is this some sort of celebration of the introduction of GDPR by "spaffing all their customers up the wall"? We hold off every release till the last possible moment, but now they've got us. And this at the time of year when we are importing hundreds of new pupils. Absolutely incredible. They should be facing a class action now. And their decrepit cash cow "product" should be booted out of every school. Unbelievable.

Thanks for posting this timbo, didn't work for us :-( We have massive performance problems this term. Reported to SIMS 3 weeks ago and still no response. Every user finding the system really slow. So something clearly broke in one of their million "patches" at the end of summer... If there are other "patches" that clear the log file and reindex their tables I'd love to have them, but how do I get them? (When I logged the error I specifically asked about Patch 20647 and KB104766 which were referenced yonks ago in the ironically named "knowledge" base.)

LOL. Yea, obviously I'm not telling anyone to do this. Just saying the only effect a query can possibly have on a database is on performance. That one runs in milliseconds, and in space no-one can hear you query...

While researching this issue I did come up with a workaround, which anyone wanting to bulk email out reports themselves might use. I share it here for any cheapskates lacking the might of Schoolcomms (which we find useful for Attendance etc so I'll continue using). It's pretty simple, if you're used to monkeying around with SIMS reports and Excel. 1) Install Doug Robbins free Merge Add In for Word which enables you to merge attachments. See here: https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_win10-mso_2016/adding-attachments-in-mail-merge-in-word-2016/612d1278-aecd-457f-b608-fef497450d7b 2) Knock up a Pupil report in SIMS to create an excel list with the email of all Parental contacts for the pupils in a particular year (you probably have something similar already with whatever columns you would need for a mailmerge to parents). Make sure you include a column with the pupil's admission number - we need this to link to the filenames later. In Excel, manually sort on the emails and remove any parents with no email - you might also want to choose "home" over "work" if you included both as columns. You should now have one email for every parent in the file. 3) In SIMS Individual Reports Upload your reports to the document server for your year group, and also Export them to a folder, choosing "PDF" from the dropdown on the Export button. 4) In Microsoft SQL Server Management Studio run this query to get a list out of the SIMS database of all those reports you created (Just change "Year 8 Summer 2018" in both places to whatever you called it): use sims; SELECT substring( sims.dm_document_710.attachment_name, charindex('Year 8 Summer 2018',sims.dm_document_710.attachment_name)-7, 6 ) as AdmissionNo, replace(right(sims.dm_document_710.attachment_name,len(sims.dm_document_710.attachment_name) - 9),'.xml','.pdf') as PDFFile FROM sims.dm_document_710,sims.dm_document_doctype, sims.dm_document_status WHERE sims.dm_document_doctype.lookup_value_id = sims.dm_document_710.document_type_id AND sims.dm_document_status.lookup_value_id = sims.dm_document_710.document_status_id AND sims.dm_document_doctype.description = 'AM Individual Report' AND sims.dm_document_status.description = 'Public' AND sims.dm_document_710.attachment_name LIKE '%Year 8 Summer 2018%' 5) Paste the result from this query into a second page in the spreadsheet that you output from the SIMS report in step (2). Use Excel to prefix all the filenames with whatever the path is to the folder where you exported them (or modify the SQL to do this). 6) On the main page of the spreadsheet Do a vlookup on the AdmissionNo column of the SQL page. You now have a spreadsheet page with whatever columns you want in your merge message plus two crucial columns: an email address and a filename for the report. From this you you can mailmerge your attachments. 7) Create your mail message in Word, and add mailmerge fields as normal, then use the Merge with Attachments button. Doug's Add In is grumbly in only one way - initially it put up a message saying it only works with a "Letter type mail merge document". Actually that just means you need to stick at least one mailmerge field in the Word document before you click on Doug's Merge with Attachments button. (I put Forename in, as in "I enclose $Forename's Summer report". I'm sure you have many other fields you may want to use which you include in that SIMS Pupil report as normal). That is all.

Thanks for your help Schoolcomms. Having looked into this I'm happy that Schoolcomms normally sends the files as PDF. Just on that day something happened on the sending machine and the conversion failed so they went as xml. I'm going to use Schoolcomms again for Year 9 today.

Well, if I was Schoolcomms I'd convert to pdf on the fly as I grab them out of the server. But they don't, and probably this is regarded as an old fashioned way to do things so they never will. But we've used it for years and years and Schoolcomms makes it so simple: when in their emailing interface you just say "all parents of Year 10" and select the Summer report from a list of Individual Reports and off it trots... Nothing in life is that easy it seems. Doesn't explain why its gone belly up now, of course, after working for so long. I'll just have to take the butt slapping using it with the Year 8 parents next week and find a replacement (PROBABLY FOR SIMS AS WELL AS SCHOOLCOMMS!! )

Cancel my profuse thanks there. My joy has turned to tears. I'm not exporting nothing! I upload to the doc server by pushing the Upload button. No PDF option on that. Is there somewhere else you can set it to store as PDF?

... and how do we do that?

We email out Individual Reports via Schoolcomms. Have done this for years. Last week I had 20+ parents who couldn't open the report. Never had one complain before. Most were trying to open it on their phones, and most of those were iPhones, but several were android, and several were failing on grown-up devices too. Testing it, they fail on my android phone, and I have xml reports from last year and they fail for me too now, so I'm thinking this isn't one of the billion SIMS upgrades changing the file format... So that leaves me wondering: Has something changed on phone OS's so that they won't go to Microsoft links to resolve the tags in the XML? Has anyone else experienced this? Maybe they never worked, I just imagined it, and no one complained? I feel like I've entered The Twilight Zone. Also, why on earth have SIMS not moved to storing PDFs? Or, if they don't, why on earth does Schoolcomms not convert to PDF on the fly when it sends out the files? We have the next year group to send this week and if that fails as much we'll have to ditch Schoolcomms. Is the SIMS parentapp worth investing in?

What Graham said will work but it's over the line of cost/benefit, even for the 300+ we need. So dragged the xml from LRS into excel which nicely translates the xml tags into columns, pruned the garbage out, and got admin to cut and paste ULNs into SIMS for me.

I have low expectations of government websites but this sorry mess is the worst I can ever remember. Websites that fail with no error message, logins that only work when you reload the page, All files failing with LRS error codes that no one will provide documentation for, And a shocking runaround from the support providers. The LRS now smugly saying everything there is fine, its just S2S that's a basket case. After multiple support requests, phonecalls (especially like the LRS helpline where a bloke was reading out a 50 character url and telling you to bog off there), frantic repetition of effort, I have now found these XML output files which get dumped in the LRS site. But there is no way to input these. The XML is not even close to CTF format. I can manipulate it in Excel to create columns with Surname, UPN and ULN, but I don't know of any way to bulk import ULN like this (anyone?). So the two options are manually paste ULNs from this file or wait and hope that the S2S service gets fixed. But the deadline is a few days away now. Anyone have any other ideas?

Ditched SISRA a couple of years ago as it was more of an overhead to load data into it and staff were confused. Found it hard work - a sledgehammer to crack a nut. We've been happy 4Matrix users for last 2 years. It's simpler to get the stuff from SIMS into it, and it shows the headlines very clearly for management.

Just had a look: CR 1101-838092 26th January pretty much says it all and has 23 votes (now 25! :-) ) but hang on... that's 5 months ago. Of course it must be configurable, but I have parents emailing me daily asking for event details. If a teacher says "no equipment" the parents don't know if it was gym shoes or a protractor. Which is useless. So they then phone / email the school. Which makes the web access a waste of time...

Justin, we are experiencing things slowing down, reports grinding to a halt, people getting thrown off etc. I reckon it started after the spring upgrade and rebooting the server every 2 weeks or so is all that fixes it for us. Could a big fat memory leak or some dodgy processor-intensive loop have been introduced in the upgrade? (We have 8Gb database, 4Gb RAM, poorer processor than yours, the rest similar)