MILADY/CIMA Grade Import Tool Support Guide

Creation date: 10/9/2026 2:42 PM Updated: 10/9/2026 3:06 PM cima import milady

Milady Grade Import Tool SOP

Use this SOP to configure and utilize the Milady Grade Import Tool. Initial setup is required before grades can be imported.

Important:

Before grades can be imported:
• OnlineSMART Test Definitions must contain a Milady Grade ID
• Student Profiles must contain a Milady ID

Initial setup only needs to be completed once.

Part 1 - Initial Setup

Configure Test Definitions
Log into the Milady/CIMA system. Navigate to Reports → My Reports. Select + Custom Report. Enter the following: Name: SMART Test Definitions Description: SMART Test Definitions Library: School Report On: Assessments Save the report. Open the Columns section. Select: LMS ID Category Course Name Title Run the report. Open Definitions → Tests in OnlineSMART. Locate the matching Test Definition. Enter the LMS ID value into the Milady Grade ID field. Save the Test Definition.
Configure Student IDs
Navigate to Reports → My Reports. Select + Custom Report. Enter the following: Name: SMART Students Description: SMART Students Library: School Report On: Users Save the report. Open the Columns section. Select: LMS ID Last Name First Name Run the report. Open the student's Academics tab in OnlineSMART. Enter the LMS ID value into the Milady ID field. Save the student profile.

Configure Test Definitions

Log into the Milady/CIMA system.
Navigate to Reports → My Reports.
Select + Custom Report.
Enter the following:

Name: SMART Test Definitions
Description: SMART Test Definitions
Library: School
Report On: Assessments

Save the report.
Open the Columns section.
Select:

LMS ID
Category
Course Name
Title

Run the report.

Open Definitions → Tests in OnlineSMART.
Locate the matching Test Definition.
Enter the LMS ID value into the Milady Grade ID field.
Save the Test Definition.

Configure Student IDs

Navigate to Reports → My Reports.
Select + Custom Report.
Enter the following:

Name: SMART Students
Description: SMART Students
Library: School
Report On: Users

Save the report.
Open the Columns section.
Select:

LMS ID
Last Name
First Name

Run the report.

Open the student's Academics tab in OnlineSMART.
Enter the LMS ID value into the Milady ID field.
Save the student profile.

Part 2 - Grade Imports

Create Grade Import Report
Navigate to Reports → My Reports. Select + Custom Report. Enter the following: Name: SMART All Grade Import Description: SMART All Grade Import Library: School Report On: Assessments Open the Columns section. Add the required Assessment and Learner Submission fields. Configure the required Filters. Configure the required Organize settings. Under Assessments, Set Grading → Normal Under Learner Submissions → Graded at, Select User Prompt checkbox and set value to Date Range Under Learner Submissions → Graded at, Set value to "Has Value" Move the items available to match the image below and Rename: Assessment LMS ID → TestID Learner Submission LMS ID → StudentID Configure the required Sort settings. Under Learner Submissions, set LMS ID/StudentID → Ascending Under Assessments, set LMS ID/AssessmentID → Ascending Under Learner Submissions, set Score → Descending Run the report. Export the report file.
Import Grades into OnlineSMART
Open the Milady Grade Import Tool. Select the exported report file. Upload the file. Review the results. Verify grades imported successfully. Review any skipped or duplicate entries.