The Mosaic Student Data Importer is a utility which converts Mosaic student import data to a format which allows the student data to be successfully imported into MSA Client.
Running the converter utility helps to protect data integrity.
Before moving forward through any step, be sure to thoroughly read and understand all prompts, messages, and warnings to the best of your ability.
Support approval is required to Convert all Student SIS Keys to use Mosaic Student Number
The system is designed to protect clients against any mass changes that seem suspicious in order to protect the integrity of the system.
When running a student data import in MSA Client, the client will receive a warning message if the import results in changing, adding, or inactivating 10% or more of the total students already in the database. The client may confirm the changes and continue with the update process.
If the import results in adding 20% or more of the total students already in the database, an authorization request must be completed and released by an authorized HSS Support representative. The proper procedure is to submit a request case with comments to Support prior to making changes. This will allow a Support representative to schedule a time resulting in the least impact on your staff and their daily operations.
For the Mosaic Student Data Importer, a support representative with Admin-level access will need to be engaged prior to making changes.
All suspicious requests should be spot-checked to ensure data integrity is maintained.
Ensure the District is selected in System Settings
Before using the Mosaic Student Data Importer, make sure the District is properly selected within System Settings.
- From the Admin & Maintenance tab, select System Settings.
- Click the ellipsis button to find and select the correct District from the list.
Setup the Mosaic Student Import
- From the Admin & Maintenance tab, select Miscellaneous Setup.
- Select Student Importers.
- Click Add to add a new Student Importer. Choose Mosaic Hosted. Then, click Ok.
- Enter a name for your Mosaic Student Import. Select additional Import preferences.
- Select Configure.
- Enter the Remote Filename for your Student Import file. Click Ok.
- Click Ok on the Setup Student Importer window.
Run the Convert to Mosaic Student Data Importer Utility
The Mosaic Student Data Importer is a utility which converts Mosaic student import data to a format which allows the student data to be successfully imported into MSA Client. It is used to properly identify each student in your import file so that running the import doesn't create duplicate students or change the wrong student information.
Run this converter before you run the Mosaic Student Data Import.
The conversion utility should only be run once.
- From the Utilities tab, select Advanced.
- Select Convert to Mosaic Student Data Importer.
Select Yes to proceed past the warning.
Read the warning in its entirety.
- Select Submit Request to gain Authorization to run the Mosaic Student Importer.
- Enter the reason for your request in the comments window. Then, click Ok.
- Wait for approval from Support. Once approved, the converter utility will run automatically in the background.
Run the Mosaic Student Import
Running a Mosaic Student Data Import has the potential to create many errors. It is advised that you investigate and troubleshoot any issues with the file and with the import results. Do not accept any results which are not intentional.
- From the Admin & Maintenance tab, select Student Importers.
- Select the Mosaic Student you previously created.
Select Run Now.
Analyze the import results.
Select the Show Change Types checkboxes to filter the different types of change happening in the file.Pay attention to which fields are being changed in the import and why.
Carefully look over the results of the import to ensure that all changes are intentional and correct.
- If you accept the import as successful, select Ok to save the changes.
If you do NOT want to accept the import (it is suspicious), select Cancel to ensure these changes are not saved.