> For the complete documentation index, see [llms.txt](https://vecnacares.gitbook.io/special-olympics-openmrs-has/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://vecnacares.gitbook.io/special-olympics-openmrs-has/release-notes/2021.06-data-migration-updates.md).

# 2021.06 Data Migration Updates

## <https://vc-jira.atlassian.net/browse/CPSO-1894>

## New

* Added de-duping logic for removing duplicates from migration data by FirstName, LastName, Gender and DOB. UNKNOWN UNKNOWN records can be added without de-duping.
* Migrated VecnaHAS-SES data to the Data Warehouse and generated a file of data not migrated based on the set migration rules <https://vecnacorp.sharepoint.com/:f:/s/VecnaCares/EiWQw9aIhwRJktZgDEhJa7QBBBCqubxXNKkc4-J3vYuBYA?e=TObNto>
* Migrated VenaHAS-Prod2 data to the Data Warehouse and generated a file of data not migrated based on the set migration rules <https://vecnacorp.sharepoint.com/:f:/s/VecnaCares/EiaJp-xqozNCh-oyhAx9xHkBVuCrCwMs6TbQtab95yGBHw?e=bbSKRo>
* Migrated VecnaHAS-Prod1 data to the Data Warehouse and generated a file of data not migrated based on the set migration rules <https://vecnacorp.sharepoint.com/:f:/s/VecnaCares/ErULdxpU68hEqgPzLiCDB4cBMiIy0cfpIVL6d8ZQ0uGxUQ?e=f0x7kP>

## Changes

* Re-migrate the first migration file(Austria data) with de-duping logic applied.&#x20;
* Updated QA Automation scripts to include the newly added de-duping logic.&#x20;
* Added form ids in the migration scripts to differentiate the same concepts used in different forms.

### OpenMRS HAS

* Added "Flag Football" to the Sports list
* Added a new concept 'Unassigned Sport' for migrating Unified Sport or Sport data from the migration files.

## Bugs

* Updated affected names migrated with wrong accent marks in the Data Warehouse

## Known Bugs

* Funfitness:Balance - Unexpected concepts are appearing in the data warehouse for Balance screenings [CPSO-2669](https://vc-jira.atlassian.net/browse/CPSO-2669)