[sims] Sims export of contacts email and student years

[nicholab]

For on roll students I want to know if it would be possible to export all primary contacts out of sims and year groups that their children are in. Then I would like this to then reference the oldest child's name.

 

So I end up with

 

Oldest child's name: email of p1: year1 year4 year10

[Esteban_Child_of_the_Sun]

That's a reasonably simple report to write, assuming you have the Mailingpoint in SIMS set to the oldest child and have updated it this academic year (Tools | Housekeeping | General, panel 3)

Create a report for students on roll,

Filter it by mailing point is true

Add data-items: Student Name, Contact (filtered by P1) email address, siblings year groups