CSV file formating zeros when commanding pull data function

User Support Form Building
,
2

@douglascharivanda, have you tried using the matching variable as question type that holds and compares the patient id as text question type? Maybe you could do it as outlined in the image shared below:

In the survey tab of your xlsform:

Image 1

CSV file:

Image 2
Image 2811×192 6.71 KB

Note: You could keep the 0 in the CSV cell as '02000001 like you do in XLS. Then you will need to upload them to the system. Don’t worry even if the 0 does not get displayed in your CSV file later. It should still work.

Data entry screen as seen in Enketo:

Image 3
Image 3719×796 20.4 KB

Reference xlsform:

pulldata.xlsx (10.4 KB)

Reference csv file:

ihh.csv (428 Bytes)