Import emails into SIMS

[cjacksonuk]

At a school I support I am looking for a solution to import email addresses into SIMS. Is there some kind of script or something that would allow me to match records and update the data.

 

Reason, School has purchased a new Library system called Oliver. They said for users to be able to sign in to Oliver - Wonde sync needs to pass the email address to Oliver.

Issue is that email addresses of students are not stored in SIMS - so it'll be a massive job of updating that info and keeping it up to date for new users etc.

 

So I come around to the idea that scripting something to update the fields in SIMS could work. I dont believe LGfL are capable of 2 way sync for this purpose.

 

Any ideas or help appreciated. Thanks .

 

Background

- LGFL School

- SIMS MIS

[enbiggen]

Hi,

 

For the importing (but not maintaining) you may find KB0023989 useful: "How to Bulk Import Email Addresses and Phone Numbers", which uses Routines->Data In->Pupil Data->Import from Spreadsheet to import a CSV in SIMS. The link to the KB on ESS's support site is: https://customer.support-ess.com/csm?id=kb_article_view&sys_kb_id=0b86edac1b5b2010fe688551f54bcb10

 

Thanks.

[howartp]

The first answer to this, though overkill for this specific query, is to use Salamander: https://www.salamandersoft.co.uk/

 

That will populate and maintain your student's email addresses, and lots lots more besides.

 

The second answer is SIMS | Routines | Data In | Pupil Data | Import from Spreadsheet, which is probably the answer you want.

[Boredguy]

Using the built in Import from Spreadsheet routine will do you fine.

The CSV file can contain as many fields as required but as a minimum for import, the file must contain:

Surname and Forename; or

UPN; or

Admission Number

Telephone Number (a column should be created for each type, e.g. home, work, mobile)

Email Address (a column should be created for each type, e.g. home, work).

Each data field must be created as an individual column. When creating a pupil/student's email addresses and/or telephone numbers import file, the Admission No. and UPN must be included in the spreadsheet to enable successful matching.

 

Our admission staff know the format for all new e-mail accounts we create for students (since its including their SIMS admission number) so once the student is enrolled they update the Student's E-Mail record to have their school e-mail address as the Main Work account which Wonde and Groupcall export for the different third party services we use it with.

Edited July 5, 2022 by Boredguy

[cjacksonuk]

awesome - thanks everyone - so at least its possible. ...and with that I can have the admin team try to keep things up to date.

 

shame I cant Powershell the periodic updates ;-)

[mavhc]

you can output stuff with commandreporter.exe but is there a way to import stuff programmatically without paying for API access?

[ITGuyNW]

If SIMS already has parental email addresses, how do you deal with those?

 

Export all data from SIMS to csv, move those email addresses to a work column then have the pupils email addresses as their primary/main address?

[Boredguy]

We make sure when we get CTF's from the primary schools we don't import those details into the student record, but record them properly under the People - Contacts section

[mavhc]

If SIMS already has parental email addresses, how do you deal with those?

 

Export all data from SIMS to csv, move those email addresses to a work column then have the pupils email addresses as their primary/main address?

 

Aren't the parent email addresses under the parent's contact and just show up in the pupil's view via that?

[David44]

you can output stuff with commandreporter.exe but is there a way to import stuff programmatically without paying for API access?

 

Did I imagine it or did Wonde's API use to be free for schools?

 

I can't see any reference to that on their site now so maybe I made it up.

[LeMarchand]

Did I imagine it or did Wonde's API use to be free for schools?

 

I can't see any reference to that on their site now so maybe I made it up.

 

I thought it used to be too. Figured they made their money by selling on details/analytics if/when it wasn't properly locked down.

[ITGuyNW]

Aren't the parent email addresses under the parent's contact and just show up in the pupil's view via that?

 

As far as I can see, email addresses only have one section under student details > 4. Telephone and Email addresses

 

The family section does not have any email address field, so they are in the section mentioned above.

[ITGuyNW]

As far as I can see, email addresses only have one section under student details > 4. Telephone and Email addresses

 

The family section does not have any email address field, so they are in the section mentioned above.

 

Just found this which cleared it up for me

 

Import Email and Telephone Data - YouTube