CSV file formating zeros when commanding pull data function

User Support Form Building
,
1

Hello. My CSV file is formatting zeros when i upload it for pulldata function in the server, i need the zeros to appear since they are part of patientID, how to resolve thisihh.xlsx (25.6 KB)

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)

3

Thank you let me try it

1 Like
4

Its now working thank you @Kal_Lam

1 Like