Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


...

borderColor#2c9fba
bgColor#ffffff
titleColor#ffffff
titleBGColor#2c9fba
titleOverview

...

Overview

MSA Client has an advanced utility that will convert existing student data in preparation for using the Mosaic Student Data Importer

...

. 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. Running the file converter utility helps to protect data integrity and should only be used when discontinuing the use of one student data importer and starting to use the Mosaic Student Data Importer.

This importer should only be used for Mosaic Student Data Imports.

Warning

Before moving forward through any step, be sure to thoroughly read and understand all prompts, messages, and warnings to the best of your ability.

Note

Support approval is required to Convert all Student SIS Keys to use Mosaic Student Number

Info

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.

  1. From the Admin & Maintenance tab, select System Settings.

  2. Click the ellipsis button to find and select the correct District from the list.

    Image Modified

...

...

Setup the Mosaic Student Import

  1. From the Admin & Maintenance tab, select Miscellaneous Setup.

  2. Select Student Importers.

  3. Click Add to add a new Student Importer. Choose Mosaic Hosted. Then, click Ok.

    Image Modified
  4. Enter a name for your Mosaic Student Import. Select additional Import preferences.

  5. Select Configure.

    Image Modified
  6. Enter the Remote Filename for your Student Import file. Click Ok.

    Image Modified
  7. Click Ok on the Setup Student Importer window.

Return to Top

...

Run the

...

Mosaic Student Data Importer File Conversion Utility

Info

The Mosaic Student Data Importer File Conversion Utility is a utility which file that converts Mosaic student import data to a format which that 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.

Warning

Run this converter before converter before you run the Mosaic Student Data Import ONLY if you have previously imported student data into MSA Client from any non-Mosaic importer.

The conversion utility should only be run once.

  1. From the Utilities tab, select Advanced.

  2. Select Convert to Mosaic Student Data Importer.

  3. Select Yes to proceed past the warning.

    Warning

     Read the warning in its entirety.

    Image Modified
  4. Select Submit Request to gain Authorization to run the Mosaic Student Importer File Conversion Utility.

    Image Modified
  5. Enter the reason for your request in the comments window. Then, click Ok.

    Image Modified
  6. Wait for approval from Support. Once approved, the

    converter

    conversion utility will run automatically in the background.

    Image Removed

...

  1. Image Added

...

Run the Mosaic Student Import

Info

The system is designed to protect you 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, you 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. You 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. Proper procedure 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.

  1. From the Admin & Maintenance tab, select Student Importers.

  2. Select the Mosaic Student you previously created.

  3. Select Run Now.
    Image Modified

  4. Analyze the import results.

    1. Select the Show Change Types checkboxes to filter the different types of change happening in the file.

    2. Click the

      plus (plus) sign

      plus sign to expand the details of the changes for each record.

    3. Verify the student information is correct and/or not blank (e.g. A student's last name is not changing to an address, etc)

    4. If any of the change numbers seem incorrect, click Cancel.

      NoteIf

       If you have a large

      school

      School District, only the first 10,000 rows will be displayed.
      Image Modified

      Warning

      Carefully look over the results of the import to ensure that all changes are intentional and correct.

      Pay

      (warning) Pay attention to which fields are being changed in the import and why.

  5. 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.
    Image Modified

  6. The system may find a massive amount of changes suspicious. If you have spot-checked the changes and agree to commit the changes, click Yes.

    Note

    Note: See details at the beginning of this section for what is considered suspicious and what requires higher-level authorization in order to commit changes.

  7. If higher-level authorization is necessary, the following window will appear. Follow the instructions from your Support representative. Once approval has been granted, the Authorization Required window will disappear and the changes will complete.

    1. Submit Request - Requires a comment entry on why changes are being requested. This allows accurate tracking of why changes are being made and who is requesting the changes.

    2. Manual Approval - If you are connected to a Support representative, they may prompt you to click this button and enter an authorization code. 

      Image Modified

...