Spring clean of 'Other Schools' panel in SIMS

[Lizs84]

Hi, I am trying to use this down time to 'spring clean' our database before entering our new admissions next month. My predecessor wasn't particularly tech-savvy and pretty much just bumbled along for 17 years. As you can imagine, the information is all over the place.

 

As part of my clean up operation, I have run the System Diagnostics, gradually worked through the errors and am down to my final few. One of the errors is on Check 22 which checks for duplicate schools. The error reads;

"Duplicates detected in the 'Other Schools' table. The records could be merged (via the DBDIAGNOSE script and patch of KB99196): User fixable."

 

I am familiar with the 'Other Schools' panel and there are many duplicates and some very odd entries made by my predecessor. I can easily edit entries but I cannot find a way of deleting entries (for example one school is in the panel 5 times with slightly different addresses and there is an entry that simply says 'Australia' - I would like to clean these up).

 

I don't know how to go about running the DBDIAGNOSE script or downloaded the patch (KB99196) - is this something I need to do? Or should I do this manually?

 

Thanks in advance for the help!

Edited April 8, 2020 by Lizs84

[Simcfc73]

You need to contact support to get them to send you the KB file, then you run the Diagnose on the SIMS server which will produce the report.

 

This is one of my jobs too, I did run it a few months ago and tidied a fair few up.

 

Its a shame SIMS don't use a Database to lookup the schools so they are all tidy.

[Lizs84]

Thank you, I have contacted the local support but no reply yet. Do you know if there is a way of manually deleting entries?