How do I extract school data from Pupil Asset in readiness for moving to another MIS?
-
CTFs will need to be created in the usual manner (navigate to Admin > Export > CTF Format) to transfer pupil-specific data.
-
In addition, please ensure you run the following link to support the export process:
https://secure.pupilasset.com/exportAll.php
What level of system access is required to extract data using exportAll?
The person running the reports must have ACCESSADMIN permissions and be logged into their Pupil Asset account before clicking on the link.
When is the best time to run the exportAll link?
Please note: This link must be run after all final data has been entered.
If you need the reports to be run again at a later stage, please contact Support for assistance.
What data does the exportAll link capture?
The export all link will create exportable CSV files for all mandatory data including
- attendance
- medical information
- consents
- class groups
- FSM and SEN information
- staff information including qualifications, contracts and medical information
What data does the exportAll link NOT capture?
- Assessment data
- Sent Emails
- Sent SMS
- Historic Census return files
- Pupil Log
- Pupil Notes
- Flags
- More Able details
- Transport Details
- Awards
- Interests Hobbies and Sparks
- Custom Data Fields
- COVID tests
- Meal History
- Payment History
- Transaction History
- Files (uploaded and native)
- Provision mapping data
- Suspension/Exclusion data
- Event data
How do I export my Summative / Formative data?
Summative data can be accessed via the Results tab. Use the available filter and display options to select the data you need — please note that this must be done per subject.
Once your selection is made, you can download the data as a CSV file using the Download button (see screenshot below).
Formative data is accessed via Results > Multi Tick. Use the filter selection on the left of your screen to select your pupils. Framework and age levels are selected by clicking on the 'Display Options' button located at the top right corner of your screen. The data can then be exported using the download button.
My new provider is requesting that the data is imported in a particular style. Can the format of the data be modified?
The format of the exported data cannot be modified. However, your new provider will be able to advise you on any product-specific adjustments that may be required to be undertaken by you to ensure a successful migration.
Updated