We are working on importing data from the CSV file below into OpenMRS where each line is an encounter:
|Phone||Follow up date||Type of Care||Follow Up Type||ART Number||EID Number|
|25677000001||2018-03-14T21:59:21.050552+03:00||ART & ANC||SMS Message||ART-FEMALE-1|
I am looking for for guidance on the following:
- Mapping of the data in columns to concepts.
- Phone and Followup date are okay since each has one value per obs
- Type of Care - may have one or two or more coded values. Is there any other choice other than IF-Else statements
- The last 2 columns are identifiers - ART Number, EID Number is it possible to search across 3 different identifiers at the same time?
This file may contain anywhere from one to 100 encounter records.