jdsa

Thanks for the suggestion but copying it to be local didn't help.

Trying to run the DBDiagnose tool but I'm getting an "Illegal characters in path" error, any ideas? Using the V4 sql file, checked the server names etc are correct...

@GrahamB Interesting question, I'd wondered this as well. Referring to the ICO again, you can apparently push back on a request for erasure if it is "excessive", either requesting a "reasonable fee" to do the erasure or just outright refusing it. But, of course, what on Earth does "excessive" mean?

https://ico.org.uk/for-organisations/guide-to-the-general-data-protection-regulation-gdpr/principles/storage-limitation/ "You must not keep personal data for longer than you need it." I would argue that the legal basis to retain the data has also been removed, unless you are using this information for a separate reason and have justified it within your privacy notice/consent forms/etc (e.g. in the overseas school visa example, I suppose).

Routines > Student > Bulk Update > Group Type: Year Group; Group: All; Data Item: Parental Consent > Search > Print It comes out as a CSV file.

If you go into Searchable Pupil Data, add in your Y8 UPNs the KS2 scaled scores will be in the download files. If you're looking at the KS2 csv, they're about halfway along. Same for Y7.

Just in case you didn't know, the formula's really simple in Excel: just use =PROPER(). If it's a report that's going to be run a lot, you could write a Macro to be included in the Report Template, but it's a bit of a faff.

The recordings are usually available after a few days here.

Old thread, but does anyone know if this can be done? I've tried to Find & Replace 'Result' into 'ResultDesc' and have looked at the 'full' code (as per this thread) to see if there's anything else that distinguishes the two fields, but I'm stumped.

Sort of... If you go to Tools > InTouch > Message Type Defaults Setup then click Search you can set up auto-forwarding for specific message types. We have it set up so that General Message replies get sent to our school admin email, and Attendance replies get sent to our Attendance Officer's school email.

Tools > Setups > Emergency Alert is where I can select which staff receive emails/texts. But we have InTouch, so if matt40k is right, you might not have this option.

There have historically been intermittent issues with various email providers. Are the email addresses from the same provider, do other emails to the same provider get through?

Just checking this is the process you're following: Add a column for Data Entry using formula, select Result Set, choose Aspect and then the Nested If-Then-Else. So for us, we have an Aspect for score, and then from that we have another Aspect with a formula that says, for example, if the score is above 110 then enter "GDS" and colour Green. This should produce a permanent colour and text.

Absolutely you can, it works how you're describing it. Put the aspect that contains the Nested If Then Else formula in your Individual Report, make sure 'Print Report with Colour' is ticked, and the colour will come through.

Is this distinction used anywhere that isn't SIMS (e.g. I'm sure the School Census doesn't distinguish between N or Null)? Just wondering how important it is to sort this out on our database.