[sims] Bulk removing email addresses

[synaesthesia]

Hi folks,

We're preparing for a move away from SIMS (Yay!) and as part of data cleansing, I've found out that some WONDERFUL person has incorrectly stored parental email addresses in the Student email address field, pretty much since the start of time. Bulk importing the correct email address is absolutely easy via CSV import, however I can't find any information about removing the nonsense that's already in there?

(The fun involved in exporting everything and ensuring every parent has a primary email contact and that what's in Student email isn't on it's own, manually, in excel. Deep joy!)

Is this possible?

[psydii]

Salamander can update this field, so if you have their system they might be able to help?

[synaesthesia]

Unfortunately not

[ThomL]

Our support company contacted ESS, they provided a patch that we could then use with a CSV to wipe all current student emails and replace with the details in the CSV.

 

CSV had to be called "EMAIL_PHONE.CSV" and have the headers:

person_type: S for student

surname, forename, midname: leave blank

upn_adno_ni_tt: admission number (leading zeros will be applied automatically on import, if necessary)

email_phone: email address If this exists already, it will be updated with the flags (below), otherwise created (with flags)

notes: leave blank

location: W for "work"

main: T for true

primary: T for true

USE_FOR_FEES_DOCS: leave blank

 

Patch applied was "Patch 23212 [3.62.669-3.64.999] PRB16051 - OD Bulk import Email address" this maybe out of date now with a newer version of the patch needed, we applied this patch in March 2024

Edited October 16, 2024 by ThomL

[synaesthesia]

Aha, many thanks - I've a call open with ESS so that sounds promising. Much preferable to rawdogging the database!