SIMS Export is an add-on module that exports applicant data in a format you can import into SIMS. After the module is enabled, set the SIMS School ID for each campus, map your fields at Settings > Import & Export > SIMS Field Map, set up SIMS Lookups, then export from a roster using Export > SIMS XML Enquiry Export or SIMS XML Application Export.
For admins at schools using the SIMS Export module.
SIMS Export is an additional module for OpenApply. To enable it for your school, contact your School Experience Manager. Once it is enabled, the OpenApply support team completes the initial configuration and schedules a training call to guide you through the steps below.
| I want to | Go to |
|---|---|
| Set School IDs for each campus | Set the SIMS School ID |
| Map OpenApply fields to SIMS | Map mandatory fields |
| Assign SIMS codes to dropdown values | Set up SIMS lookups |
| Run an export | Export SIMS data from a roster |
Set the SIMS School ID
OpenApply supports multi-campus schools, so you need to enter the SIMS School ID for each campus.
Go to Settings > School Settings > Campuses.
Select the pencil icon to edit a campus.
-
Enter the SIMS School ID for that campus and select Save Changes.
In a multi-campus export, OpenApply groups the students for each campus into a separate XML file named with that campus's School ID. The files are compressed into a single ZIP file for download.
Map mandatory fields
Go to Settings > Import & Export > SIMS Field Map.
-
Map each SIMS field to the matching OpenApply field. Make sure every mandatory field (highlighted in green) is mapped. OpenApply Support will help with this.
Test an export with basic field mapping first, before you set up custom field mapping. For help or advice on mapping your fields, submit a request.
Set up SIMS lookups
Lookups let you give a predefined OpenApply field (Dropdown Menu, Multiple Choice or Checkbox) the SIMS descriptions and codes that SIMS can read.
Go to Settings > Import & Export > SIMS Lookups.
Select Choose Lookup Field and pick the field you want to map.
For each possible value, enter the SIMS Field (description) and SIMS Field (code).
-
Select Save Changes.
Some lookup fields, such as title or prefix, need only a value rather than a description and code. For these, enter the matching SIMS Field (value) for each possible value.
Export SIMS data from a roster
You can export SIMS data for a filtered list from the Enquiries, Applicants or Students roster.
Select Filter and filter for the group you need, for example by grade, status, gender or custom fields.
Select some or all of the students.
-
Select Export, then SIMS XML Enquiry Export or SIMS XML Application Export.
-
On the export page, drag fields from Available Fields on the left to Export Fields on the right. Include all mandatory fields, marked with a green M.
Enter the export file name and select Export.
On the SIMS Export page you can also:
- edit or delete templates
- add an optional Comment to include in the export (maximum 512 characters)
- enter a Template name and select Create New Template to save the selected fields