ACCESS to MySQL IP Submission Process Research

Proposed transition to MySQL for Q4 MozART submission instead of ACCESS. Steps include:

[x] Get consensus with INS (MozART Partners Meeting)
[x] Met with Diogo to understand implications at INS of the MySQL submission (Aug 28, 2019)
[x] Review the ACCESS and MySQL submission to check for inconsistencies
[ ] Set-up the MySQL process at CDC for receiving, reviewing, and submitting to INS the databases
[x] Ask partners to submit only one combined backup of all their health facilities
[ ] Need partners to replace AccessFilePath field with another field possibly hdd
[ ] Begin process of changing cleaning scripts to MySQL
[ ] Check if a appended submission to INS is optimal given circumstances (one compiled submission as opposed to many)
[ ] Trial run of import and reviewing at CDC of MySQL files submitted by partners

mozaude / MozART_ETL