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:
-
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"
-
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
-
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
-
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
-
Mandatory for Encounter/ProgramEncounter data
- Date of visit
- Observations made during visit
Updated over 2 years ago