.csv data from pulldata not displayed on Android app

[dast]

Hi, In a form using pulldata data from the csv file is displayed properly in the browser while testing the form. Once the form is deployed the data from csv are not displayed in KoboCollect nor ODK Collect apps but properly displayed in Enketo. See attached .xls and .csv.

Thank for any help.

On Android

Choosing code:

Name not displayed

On Enkto

inventaire_de_base_polygone_nacp_test.xls (29.5 KB)
technicien.csv (474 Bytes)

[dast]

Hello all, I have the same issue. Has anybody a solution?

[Kal_Lam]

@Welcome back to the community, @dast! Here is the issue with your CSV file format …

This post discussed previously should help you solve your issue:

Pulldata is not working on KoboCollect (Android)

@Victorpaisano25, you should be able to achieve the desired format by following the instructions as outlined in the steps shared below: Step 1: Open the CSV file. You should see your CSV file in the following structure: [Image 1] Step 2: Select the column that contains the data. [Image 2] Step 3: Select Text to Columns data tool from the Data Tab. [Image 3] Step 4: By default, you will see Delimited being selected. Now press Next. [Image 4] Step 5: Select Semicolon and press Nex…

[dast]

Thank you Kal_Lam, this resolved the issue. Although for some reason I could not replicate the result in Excel when following the steps. I opened the file in Numbers (MacOS), saved it as UTF-8 csv and it worked.

[Kal_Lam]

@dast,