Spring 2019 Incomplete Address Diagnostic Script

Re the Spring 2019 CTF Issue, Keystone have applied a patch from CAPITA to fix this issue, onto every school that has had the Spring upgrade, so going forward this will not be an issue, you may want to check your data however by downloading and using the DBDiagnose script attached to this article, if you need help running this please let us know.

The issue before the patch was applied to your system was as follows:

If a school imports a CTF into the SIMS Spring 2019 release that contains a person with an incomplete address that is missing all of the following:

• house name or number
• apartment number
• Postcode

The incomplete address details will be inserted into any learner contacts being added by the CTF file who have no address record.  In other words, incorrect partial data would be inserted into all blank addresses against new contact records.

Also incomplete address details will be inserted into SIMS where a learner contact already exists in SIMS and the same learner contact is present in the CTF, and neither have an address record.  In other words, incorrect partial data would be inserted into a blank address against an existing contact record.

“Street Name”, “Locality”, “Town” and “Region” information (i.e. partial address) would be transferred in both instances.