CSV Upload: Support for multi select obs, Add more for concept and section.

Tags: #<Tag:0x00007f7913448200> #<Tag:0x00007f7913448138>

There is no support to migrate multi-select observations, Add more for a concept and Add more for section in Bahmni encounter CSV upload.

Proposed Approach:

  • Use of Single Column and values are separated by configurable character(s).

  • Enclose the entire value in special characters like [], {} etc to identify the column as multi select concept/ Add more concept in a section / concept in Add more for a section.

Eg:

Multi-select for concept

     Assume that delimiter for Multi-select for concept = $

     Column Value => [CodedValue1$CodedValue2$CodedValue3]

Add more for a concept in a section

    Assume that delimiter for Add more for concept = %

    Column Value => [Value1%Value2%Value3]

Add more for a section

   Assume that delimiter for Add more for section = ^

Sample 1:

Weight => [Weight1^Weight2^Weight3]

Height => [Height1^Height2^Height3]

Sample 2:

Weight => [Weight1^^Weight3]

Height => [Height1^Height2^]

Weight => [60^70^80^]

Height => [160^170^^180]

Add more for a concept inside Add more section

Heart Rate = [[100%101%102]^[103%104]^105]

Cardiovascular disease = [TRUE^FALSE^Unknown]

CC: @angshuonline @vmalini @pratibhasagar @vinisha @shivarachakonda

Related talk thread: CSV Upload: No support to migrate multi-select obs in encounter csv upload

Comments from @angshuonline in PAT call - Overloading the Value column as above seems error prone, especially for human editing. For programmatic creation of CSV this might be ok, and in that case, probably better to introduce different columns to hold such values.