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