Select Intended Term as the Active Field: On the "Error Report" tab, find the Person Record Errors section at the top. Set the Active Field control to "Intended Term."
​

Observe the Error Values and Expected Values: With Intended Term selected, observe the "Records with Errors" table, and contrast it to the "Expected Values" table. Notice that the expected values are "GUIDs", the unique identifier for Terms in the Element451 database.

Download the Records with Errors Table: Download the "Records with Errors" table using the three-dot menu in the top right corner of the table. CSV and Excel options are available, either should work fine.
​

Open the Downloaded File in Your Spreadsheet App: In your spreadsheet app, use find and replace to select error data and replace it with the correct value. Replacing the error with the Term GUID is preferable, but replacing the error with Term code or Term name is also acceptable.
​

Save the Corrected File as a CSV: After errored data has been corrected, save the file as a .csv. This will be required when uploading to Element451.

Create an Import Task in Element451 and Upload the Correct File as the Source: On the Source tab of the Import Task, selected the corrected file from your local computer.

Map the Columns of the Corrected File: On the Mapping tab, map the Element ID column to user-elementid. Map the Intended Term column to user-education-term.
​

Set Intended Term Column Settings: In Intended Term column settings, set "interpret as" to be the value you corrected your error data to. If you found errors and replaced them with the Term GUID, set "interpret as" to "guid". If you replaced with Term code, set "interpret as" to "code."

IMPORTANT: This step is critical to fixing the data. Data errors will persist if imported data is not correctly transformed.
​
​

​

Match the Element ID Column: On the Matching tab, match entities by "Element ID". This will match imported data to the existing Person records.

Preview the Mappings: On the Preview tab, observe the right column, "Database", to verify that incoming data is being transformed properly. For Intended Term, Term GUID should be shown in the right column.
​

Import the Corrected Values and Verify: Run the Import task, then verify that Intended Term is correct on the Person Profile. The Data Hygiene dashboard will also update, but may take longer than an individual Person Profile. Please allow up to 12 hours for changes to be visible on the dashboard.

Select Application Major as the Active Field: On the "Error Report" tab, find the "Application Errors" section in the middle. Set the Active Field control to "Application Major". Set the Application Position control to "1."
​

Observe the Error Values and Expected Values: With Application Major selected, observe the "Records with Errors" table, and contrast it to the "Expected Values" table. Notice that the expected values are "GUIDs", the unique identifier for Majors in the Element451 database.

Download the Records with Errors Table: Download the "Records with Errors" table using the three-dot menu in the top right corner of the table. CSV and Excel options are available, either should work fine.
​

Open the Downloaded File in Your Spreadsheet App: In your spreadsheet app, use find and replace to select error data and replace it with the correct value. Replacing the error with the Major GUID is preferable, but replacing the error with Major code or Major name is also acceptable.
​

Save the Corrected File as a CSV: After errored data has been corrected, save the file as a .csv. This will be required when uploading to Element451.

Create an Import Task in Element451 and Upload the Correct File as the Source: On the Source tab of the Import Task, selected the corrected file from your local computer.

Map the Columns of the Corrected File: On the Mapping tab, map the Element ID column to user-elementid. Map the Application Major column to user-applications-major-*. Leave the "Position" column unmapped.
​

Set Application Term Column Settings: In Application Major column settings, set "interpret as" to be the value you corrected your error data to. If you found errors and replaced them with the Term GUID, set "interpret as" to "guid". If you replaced with Term code, set "interpret as" to "code."
​

​

Additionally, set the Position Scope of the column to the Position selected on the dashboard. In this example, we're working with Position 1.
​

IMPORTANT: This step is critical to fixing the data. Data errors will persist if imported data is not correctly transformed. New data errors may occur if Position is incorrectly configured.

Match the Element ID Column: On the Matching tab, match entities by "Element ID." This will match imported data to the existing Person records.

Preview the Mappings: On the Preview tab, observe the right column, "Database", to verify that incoming data is being transformed properly. For Application Major, Major GUID should be shown in the right column.
​

Import the Corrected Values and Verify: Run the Import task, then verify that Application Major is correct on the Person Profile. The Data Hygiene dashboard will also update, but may take longer than an individual Person Profile. Please allow up to 12 hours for changes to be visible on the dashboard.