> 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/2020.06-warehouse-migration-upgrade.md).

# 2020.06 Warehouse/Migration Upgrade

## New Feature

* Improved the performance of the data migration scripts to run faster; from 4 hours to 1 hour completion runtime of data upload for the POC MDE file. 

## Changes

### Data Migration

* Updated data migration scripts to save data with more than one answer(multiple responses to coded concepts).
* Added the skipped/missing  record (JOHAN E HOLM) from WWG March 2017 MDE POC migration
* Updated the migration scripts to save names with special characters.
* Added fix to the migration scripts to only migrate data to mapped concepts.
* Corrected data that was mapped to the wrong concepts.
* Updated the data migration scripts to handle the migration of data containing pipes '|' per set migration rules.
* Updated the data migration scripts to migrate data 'Trope' in MDE as 'Strabismus' during migration to the data warehouse.
* Updated Data Migration scripts to migrate NR/C entries.
* Updated the migration scripts to capture data for newly added concepts from POC migration(

  WWG March 2017 MDE)
* Generated log file of WWG March 2017 MDE/Austria data that was not migrated. Access log file [here](https://vecnacorp.sharepoint.com/:x:/r/sites/VecnaCares/_layouts/15/Doc.aspx?sourcedoc=%7BD3BA835A-C21B-4859-8A41-B28F23DDEEDD%7D\&file=Data_not_found_details_v3.0.xlsx\&action=default\&mobileredirect=true)

## Bug Fixes

### Data Warehouse

* Added the 902 grouping concept observation records missing in the fact\_obs table in the data warehouse from SO-EU-Africa server.
* Updated the event data for the 5 records person\_keys(3225, 146, 1914,43,142) in fact\_obs.

## Known Issues

### Data Migration 

* Migration of second MDE file (In Progress)