The IDs on the external data import file need to be either the pupil's UPN or MIS ID that is listed in Pupil Management.  It is possible to get a list of pupils for a specific year or class group and their corresponding IDs by downloading a template.  Using the template ensures that all pupils have their correct ID when uploading the external data.