Pulldata is not working on KoboCollect (Android)

[Victorpaisano25]

Yes, I have it in that format

[Kal_Lam]

Did it still not work with that format?

[Victorpaisano25]

No, friend

[Kal_Lam]

If not, would you mind sharing your XLSForm and the updated and fixed CSV file again with the community? The community should be able to help you out.

[Victorpaisano25]

Sure,
PDPesaje.csv (311.6 KB)
pdkobo.xlsx (13.0 KB)
Thanks

[Kal_Lam]

@Victorpaisano25, you are with the same CSV structure:

Change your CSV structure as shown in the image below:

[Victorpaisano25]

How do I do that

[Kal_Lam]

Maybe you will need to do some Excel search for this.

[Victorpaisano25]

it looks normal to me

[Victorpaisano25]

I already converted it and it still doesn’t work

[Victorpaisano25]

I have changed a bit the XLSform and the csv file
PDPesaje.csv (311.6 KB)
Xlform de Pesaje.xlsx (13.2 KB)
works in Kobotoolbox but not in Kobocollect

[Kal_Lam]

@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:

Step 2:

Select the column that contains the data.

Step 3:

Select Text to Columns data tool from the Data Tab.

Step 4:

By default, you will see Delimited being selected. Now press Next.

Step 5:

Select Semicolon and press Next.

In some cases, you may also need to select Tab along with the Semicolon if the data has line breaks in it.

Step 6:

Now you will see General being selected. You could simply press Finish.

Step 7:

You should now get a dialogue box as shown in the image below. Simply press OK.

Step 8:

Your CSV is now as shown in the following structure:

Reference CSV File that has been fixed:

PDPesaje.csv (312.5 KB)

[Victorpaisano25]

Thanks but it still doesn’t work

[Kal_Lam]

@Victorpaisano25, could you share with the community a screenshot of what is not working now?

[Victorpaisano25]

Yes,

Works in webform but not in Kobocollect(Android)

[Victorpaisano25]

https://ee.humanitarianresponse.info/x/KAvZOdVZ

[adamvy]

I’ll be waiting for the diagnosis of the situation. Thanks for the support!

[unionfuturocorp]

Hola @Victorpaisano25 veo que hablas español.
Ya tuve este problema y logre solucionarlo; después de algunos meses.
Este error lo presentan principalmente los usuarios de Excel en español.

Y es muy simple de solucionar, lo único que tienes que hacer es Abrir tu archivo .CSV usando el bloc de notas y reemplazar y lo único que debes hacer es reemplazar el punto y coma “;” por simplemente la coma “,”. pulsas reemplazar todo. Luego darle guardar como eliges .CSV y eso es todo.

Esto sucede por como Excel en español interpreta los archivos CSV.

PDPesaje.csv (309.5 KB)

[Kal_Lam]

@unionfuturocorp,

[Bakary]

Bonjour @Kal_Lam

J’ai aussi le même souci. Ca fonctionne avec la version en ligne et pas avec les tablettes.
Je vous met en joint le fichier csv et la formule xlsform.

bz.csv (5.6 KB)

Merci d’avance pour votre appui !