...
PupilID | FirstName | LastName | ContactID | PhoneNumber | MobileNumber | Priority | EmailAddress |
D891212999295 | James | McCaffrey | 11061 | 01234 567890 | 07700 900000 | 2 | jmaccaffrey@example.co.uk |
D891293923212 | Aimee | Grange | 11566 | 01234 567891 | 07700 900001 | 3 | aimee@example.co.uk |
D891293923212 | Joan | Scattered | 11567 | 01234 567892 | 07700 900008 | 4 | joanscattered@example.co.uk |
H891212923225 | James | McCaffrey | 11061 | 01234 567890 | 07700 900000 | 2 | jmaccaffrey@example.co.uk |
L891293924228 | Lorraine | Doctor | 11845 | 01234 567894 | 07700 900007 | 1 | lorrainedoctor@example.com |
L891293924228 | Neil | Doctor | 11846 | 01234 567898 | 07700 900004 | 1 | neil@example.com |
R832351122229 | Lorraine | Doctor | 11845 | 01234 567894 | 07700 900007 | 1 | lorrainedoctor@example.com |
R832351122229 | Neil | Doctor | 11846 | 01234 567898 | 07700 900009 | 1 | neil@example.com |
X891212923226 | James | McCaffrey | 11061 | 01234 567890 | 07700 900000 | 2 | jmaccaffrey@example.co.uk |
Carefully review the data spreadsheet to ensure that you have the expected contact data. , especially consider the following:
- Ensure the ID field matches the Pupil ID in SCO.
- All other details relate to the
...
- Parent.
- Don't worry if your mobile numbers have spaces or have lost the leading 0 - we will fix that on import.
- It is possible to
...
- filter Priority 1 contacts only, or Priority 1 and 2 contacts only if required (carry out a Filter in Excel and delete unwanted records).
Save the data in csv format:
...