Student Export with API

Learn how to sync student data using an API connection.

What's Included in this Article?

• See this Help Article for steps to create connection in Sync Service
• Permissions
• Configure Export
• Field Mapping
• Send a Test Record
• Assign the Connection to a School(s)

Important Note: Exporting student data is only available for organizations who are using Enroll's Registration module.

Permissions

Admins with "Sync Service Full Access" permission have the ability to configure the API connection and mapping for imports and exports.

In addition, only admins with access to "Edit Registrations" + "View Registrations" will be able to perform the sync export.

Configure Export

Navigate to Settings > Sync Service > Sync Service Login. On your API connection card, click "Configure Mapping".

In the left sidebar, click Export Student Mapping to display the Configure and Field Mapping screen options.

On the Configure tab, input values for the Registration Examples and Student Examples. Having examples of real student data will assist when mapping fields and transforming data.

• Registration Example = Registration Form ID
  • The Registration Form ID is located within an individual student's registration. The ID is the last set of numbers at the end of the URL. Copy and paste the numbers into the Registration Example field on the Configure tab.
• Student Example = Student's SIS ID or SchoolMint ID
  • The Student's ID (SIS ID or SchoolMint ID) is located within an individual student's registration under the name for you to copy and paste into the Student Example field on the Configure tab.

On the Configure tab, click Save and navigate to the Field Mapping tab.

Field Mapping

Expand each section to review the fields available to be included in your sync. Fields are grouped into sections based on data records/tables.

Moving left to right across the columns, map the the Enroll field to the SIS field for the data you want to send to your SIS. Descriptions of each column are below.

• From SchoolMint Enroll Field: Use the dropdown menu to scroll field names or begin typing the field name and select the SchoolMint field where this data is stored in Enroll.
• Mapping Type: Choose how you want the data to be handled coming out of Enroll. Each field is required to have a mapping type selected. Mapping Type options:

Do Not Map: Use this option for fields you do not want included in your export.

Direct: Data will be sent to your SIS exactly as it is captured in your form.

Match Codes: Send a specific code for each answer rather than how the data was collected in the form (ex: Female > F)

Transformation: Reformat the data collected in the form field so it will be sent to your SIS in a specific, required format. Consult this help article for sample Transformations.

• To Field: This field will populate automatically from the SIS API.
• Mapped Value: This column will display the data for your Student Examples (that you input on the Configure tab) to assist when confirming how data will be sent to the SIS.
• Overwrite (checkbox): This option is only available to be used when importing to have the system ignore "null" values in an import file. Ignore this column during your export field mapping.

Note: Consult this article for details on mapping Contact data from SchoolMint to the SIS via API.

Send a Test Record

Use the “Send Record” button to test exporting one student record. The test record is the one being displayed in the “Mapped Value” column.

Preview the data to be exported. If it looks accurate, click “OK, Continue”.

Assign the Connection to a School(s)

Navigate to Settings > Schools/Programs > Manage Schools > Edit a School > Primary tab to select the API sync connection to be assigned to the school.

You also have the option to assign the same API connection to several schools at once using the Bulk Action > Set Sync Connection option.

Sync Your Students

Once everything has been set up and tested, you are ready to begin syncing students! First, you will navigate to your Registrations module.

Next, using your Quick Filters, you will add a filter for students that have an Approved status.

Note: You can only export students with an Approved status for their registration.

Using the checkbox next to the student's registration (or using the Select All tool), select the student(s) you would like to export to your SIS.

Once you have your student(s) selected, click Bulk Actions > Sync to SIS

Finally, select Proceed with Sync to complete the export.

Once your export is completed, the student's Sync Status will be updated. You can learn more about sync statuses and troubleshooting here.