The Ed-Fi Data Comparison screen is used to compare data stored in Focus with the corresponding records currently published to the Ed-Fi Operational Data Store (ODS). The comparison highlights matching data, mismatched values, records that exist only in Focus, and records that exist only in Ed-Fi, making it easier to identify synchronization issues. The tool also displays key publishing information, including the last attempted publish, last successful publish, last verification, and request method when available. For records with discrepancies, users can initiate a Sync with Ed-Fi action to republish the selected data, helping streamline validation and troubleshooting of Ed-Fi integrations.
The school year from which to pull data is set in the "Ed-Fi Data Comparison" scheduled job.
1. In the Setup menu, click Ed-Fi Data Comparison.
2. Optionally, select the Resource and enter a Focus UUID. Leave blank to return all records.
3. Click Load.
The report displays the Resource, UUID, Ed-Fi UUID, Method, Last Attempted, Last Success, Last Verified, and Error for each record.
4. Click Compare to view the data comparison in a pop-up window.
The pop-up window displays the Field, Focus (Last Sent) value, and the Ed-Fi (Last Verified) value. Records are color coded for easy identification. Refer to the colors in the legend. The legend also includes the number of records for Match, Mismatch, Focus Only, and Ed-Fi Only.
5. Click Sync with Ed-Fi to resend the Ed-Fi logs.
