How to create a CSV file (SIMS)
(Redirected from How to create a CSV file)
With the correct csv file we can add your pupil class lists directly into ReportAssist each year. The procedure is straighforward.
12. Click on 'Run my Report' (second option of 'I would like to'). Excel should now open with the data required. Click 'Save As' and save the file to your preferred location as a CSV (comma de-limited, MSDOS). Now import the file using the pupil wizard or email the file over to us so we can check it and import it for you.
13. If you wish to create an attendance file later in the year to add pupil attendance figures directly into each pupils report, the process is the same but choose the following fields from under attendance summary: UPN, Present AEA (or attended if AEA not available), Late (optional), Unauthorised, Total Sessions. The 'Authorised' value will be calculated from the other values.
Note: As long as you use the UPN then re-importing will be able to update existing data.
This guide is also available to download in Pdf format.