Set the SIMS Import Types
Useful Information
There are various imports that can be automated, depending on your school's requirements and the modules you are licensed for
Set the SIMS Import Types
Ensure you have first completed the section Set the Pupil and Staff IDs
Review the Import types below to see which ones are relevant to your school, then:
In SCO, click on the Configuration tab
Click on Import from external system
Click on Import configuration
Change CSV file to SIMS Dynamic Link for the required Import types
Note that Import type 'Pupil' should always be selected
Import type | Fields from SIMS | Notes |
---|---|---|
Pupil* | Surname, Forename, Date of birth, Pupil ID, Address, Registration Group, Year Group, Free School Meal Eligibility, Dietary Needs, Parental Salutation, Gender, Pupil Premium Eligibility | Before importing this data, ensure you have first completed the section Set the Pupil and Staff IDs |
Staff* | Surname, Forename, Class (if marked as a Teacher in SIMS) | Before importing this data, ensure you have first completed the section Set the Pupil and Staff IDs |
Trip |
| Functionality not available with the Dynamic Link to SIMS.net |
Cohort | All of the Pupil fields above plus Subject (e.g. Geography) and Cohort (e.g. Set8A) | Importing Cohorts may impact the performance of the SCO system considerably due to the large amount of data imported. Do not select this option unless you know you require to import cohorts |
Attendance (Absence) | PupilID, Attendance Code, Session. See also | Can be used to import absences for absence mail merge Can be used to import absences for DM and ED registers |
Account balance |
| Functionality not available with the Dynamic Link to SIMS.net |
Photo |
| Photos will show on the Income tab when a pupil is selected and in the Classroom Edition. This option is for use with the SIMS link only and for schools using the SCO Classroom Edition - see Import Pupil Photos using the Dynamic Link to SIMS |
Pupil contacts | Pupil ID, Contact’s First Name Contact’s Last Name, Contact ID, Contact’s Phone Number, Contact’s Mobile Number, Contact’s Priority, Contact’s Email Address | Only select this option if you are licensed for the Communications module Before importing this data, ensure you have first completed the section Set the Pupil and Staff IDs. A Pupil import should be carried out prior to the Pupil contact import |
Staff contacts | Staff ID, Preferred Forename, Preferred Surname, Main Home Telephone, Main Mobile Number, Email Address | Only select this option if you are licensed for the Communications module Before importing this data, ensure you have first completed the section Set the Pupil and Staff IDs. A Staff import should be carried out prior to the Staff contact import |
Leavers | PupilID, Leaving date | See section Delete Pupils using the Wonde or SIMS MIS Link |
*Recommended Import Types
Other Useful Links
Contact our Customer Support Team
support@tucasi.com | 02380 016 564
Copyright Tucasi Ltd 2004 - 2023