Sleuth CSV Import

To import your school data into Sleuth we recommend using our Sleuth Importer tool.  However, if you are using an unsupported school MIS system, or you do not have a school MIS system, then you can import your staff and student data via a CSV file.

In your School MIS System run a report to extract the following columns for each section below or just create 2 spreadsheets with the data in. We have created a staff and student report for SIMS you can import and run. Please Note: These SIMS reports do not include the extra fields for the MySleuth module username, password and email.

Include only the onroll staff and students in your data. If you already have any staff or students in Sleuth then any not present in the lists you produce will be marked offroll but their data will remain in Sleuth, effectively archived, and you can search and report on it if required. No data gets deleted if they are not present in the latest student or staff lists.

Once you have the data correct, save it in Excel or as two CSV files and email these files to [email protected] for us to upload them to Sleuth.  For security, you should encrypt the files either by using an Excel password or using a zip program such as 7-zip (www.7-zip.org).  Call us with the password.

Student Data

Column title Mandatory Data Type Description
studentid Yes Alphanumeric A unique consistent identifier for each of your students
studentupn Alphanumeric The students UPN identifier
firstname Yes Alpha The first name of the student
middlename Alpha All the middle names for the student
lastname Yes Alpha The surname of the student
gender Yes Male or Female The students gender
tutorgroup Yes Alphanumeric Tutorgroup identifier
yeargroup Yes Alphanumeric Yeargroup identifier
primarycontactname Alphanumeric The name of the primary carer for this student
primarytelephone Alphanumeric The telephone number of the primary carer for this student
studentgroup Alphanumeric The house group for the student
statementofsen Alphanumeric SEN Code SEN information for student
incare 1 (for looked after child) or 0 If the student has status looked after child
freeschoolmeals 1 (for free school meals) or 0 If the student has free school meals
line1 Alphanumeric The first line of the students address
line2 Alphanumeric The second line of the students address
line3 Alphanumeric The third line of the students address
line4 Alphanumeric The fourth line of the students address
postcode Alphanumeric The postcode or zip code
username Alphanumeric The students username to login to Sleuth if you have the MySleuth module
password Alphanumeric The students password for use with the MySleuth module. They can change this at a later date if desired
email Alphanumeric The students email address

Staff Data

Column title Mandatory Data Type Description
staffid Yes Alphanumeric A unique consistent identifier for each of your staff.
staffcode Alphanumeric A short code for the member of staff
firstname Yes Alpha The first name of the staff member
lastname Yes Alpha The surname of the staff member
gender Yes Male/Female The staff member’s gender
ethnicity Alphanumeric The ethnicity code of the staff member as defined in Sleuth
email Alphanumeric The email of the staff member

 

* Please note that if you have already imported data from an MIS then you need to make sure the studentid and staffid match those that were used for the previous import to ensure that staff and students are not duplicated. This maybe an ID that you have assigned previously or if you have used the Sleuth Importer tool in the past then it could be the MIS ID field.

 

Sleuth is a School Software Company Product
© 2019 School Software Company