Exporting Data from SIMS

Exporting Data from SIMS

This article gives step by step instructions for SIMS schools using our Report Definitions to extract their Student Information, Teaching Sets and Exam Results.

Importing the Report Definitions

To download the SIMS report definitions, click on the links below. These can also be found in Connect in the Prepare Data step of the Add Year Group Wizard. 

  1. SIMS KS5 Report Definition
  2. SIMS KS4 Report Definition


This will then download to your downloads folder, or to an alternative automatic downloads folder. All our report definitions are included within this bundle, so you only need to import the definitions once for each Key Stage. 

Once you have downloaded the SIMS report files, you will need to import them into SIMS. You do not need to open the files – simply import the .RptDef file into SIMS.

Open SIMS and go to Reports > Import and then navigate to the SIMS report you downloaded. The import screen in shown below. Click Import, and close when finished.

mceclip0.png

 

Running the Reports

To run the reports in SIMS, go to Reports > Run > Focus > Student and scroll to the reports you just imported. Sorting the Updated column may help you to find the most recent imports.

Report definitions that we offer:

  1. For Student Data, you will need the Alps Connect Data – KS4/KS5 Student Details report definition
  2. For Teaching Data, you will need the Alps Connect Data – KS4/KS5 Teaching Sets report definition
  3. For Results Data, you will need the Alps Connect Data – KS4/KS5 Exam Results report definition.

When you double click to run these reports, the screen below will appear:

mceclip1.png

Select the Supply Effective Date (the date the report will use to pull data from), or tick the box to Bypass Effective Date (Use Today). Ensure you tick the appropriate year for your year group import and click OK. 

These report definitions should produce Excel files. Within Excel click Enable Content and save the files locally.

Adding Extra Data – Student Information

At this point you can add additional data to your import files, particularly the student information, where you can include any pre-calculated prior attainment scores, and any custom columns you wish to use in Connect. Custom columns are not validated and can be used to define filters specific to your school, such as attendance bands or feeder schools.

Running your Exam Results Report Definition

Within SIMS, run your Alps Connect Data – KS5 Exam Results report definition. For summer 2025 exam results you will need to adjust the effective date to the 31/05/2025 to pick up your on-roll students for the 2023/24 Academic Year. You then need to choose the Year Groups you wish to extract data for. We recommend extracting data by Key Stage, as you will have to import your KS4 and KS5 data separately into Connect Data at a later stage. Click Okay, and the report will run, producing an Excel file containing your student's exam results.

Save this file locally, and open the file. Check the exam seasons that have been extracted – you may need to delete previous seasons from your file, such as GCSE results for Year 13 students. It is not necessary to import their GCSE results, you should delete all extra results from the file, so that only the results you wish to produce analysis for are left.

After checking your file, you can import this into Connect Data using + Add Exam Results in the quick actions toolbar in Connect Data.


    • Related Articles

    • Changing MIS Systems

      If your school or college is migrating to a new MIS system, you do not need to do anything in Alps Connect. Please be aware though that if you are using your MIS Student ID as the Student ID within Alps, this will likely change when migrating to a ...

    • What do I need to do in Alps if my school are migrating to a new MIS?

      If your school is migrating to a new MIS, then the only thing you need to do in Alps is to make sure that you can still use the same Student ID's moving forward for the same students: If you are moving from SIMS to another MIS, then you will no ...

    • Exporting Data out of iSAMS

      We now have custom iSAMS reports you can use to extract your data from the MIS, into the required format for Connect. You can find the reports and the guide to import them on the iSAMS Help Centre. For the Student Data and Teaching Data reports ...

    • Excel Templates for Connect Uploads

      To prepare your MIS data ready for upload into Connect, we have required formats. If you are a SIMs, Arbor or iSAMS school, we have custom report definitions you can use to extract your data into the required formats. If you use an alternative MIS, ...

    • Alps MIS Integration - MIS' supported by Xporter

      Here is a full list of all of the MIS' that are supported by Xporter: SIMS SIMS8 Arbor Bromcom iSAMS CMIS Progresso RM G2 Engage ScholarPack PupilAsset SchoolBase PASS SchoolPod Xporter do not support individual school developments due to the bespoke ...