Importing Excel data

📘

Introduction

Read https://avni.readme.io/v2.0/docs/structure-import-metadata-excel-excel

Note: dates get parsed incorrectly sometimes while converting from CSV to XLSX in Google Sheets (Eg. 12-01-2018 (dd-mm-yyyy) gets parsed as 01/12/2018) which may not be easy to spot. One solution is to download the CSV file and convert to XLSX in LibreOffice.

Template of an ideal migration file:

Archived for now, read the Introduction:

1. Records are rejected when:

   • any of the mandatory fields are missing (see 3 & 4)
   • address doesn't match with address levels in DB
   • Dates are in invalid format
   • Gender is not exactly "Male"/"Female"

2. Changes to be made to the input files:

   • Add Individual UUID (always)
   • Add Enrolment UUID
   • Sometimes headers have to be modified to merge multiple columns into one field

3. Mandatory fields for Individual registration:

   • Name of person
   • Gender (strictly as "Male"/"Female")
   • Village name / Address (that matches address levels in DB/ catchments.json)
   • Date of Birth
   • If Date of Birth not available, Age of person in months or years (eg. "3 years", "6 months", "30 Years" etc.)
   • Registration Date

4. Mandatory fields for ProgramEnrolment-related data:

   • Unique identifier of person as per old records (or something to map this data to an Individual)
   • Program Name (which program should person be enrolled in?)
   • Date of Enrolment into the program

5. Mandatory for Encounter/ProgramEncounter data

   • Date of visit
   • Observations made during visit