Pulldata is not working on KoboCollect (Android)

Hello friend, thank you very much. The pool data function works in the kobotoolsbox version but not in the kobocollect version. I am going to attach the xlsform that I am using and the CSV file.
PDPesaje.csv (311.6 KB)
pdkobo.xlsx (13.0 KB)

@Victorpaisano25, when looking at your CSV file I could see that it’s in a format that is not supported by the system.

You will need to change the CSV format as shown in the image below:

Yes, it is, can you verify it?

Did you change the format of your CSV file as outlied in above? If yes, and still not working please feel free to reach us back.


Yes, I have it in that format

Did it still not work with that format?

No, friend

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.

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

@Victorpaisano25, you are with the same CSV structure:

Change your CSV structure as shown in the image below:

How do I do that

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

it looks normal to me

I already converted it and it still doesn’t work

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

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

Image 4

Step 5:

Select Semicolon and press Next.

Image 5_1

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

Image 5_2

Step 6:

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

Image 6

Step 7:

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

Image 7

Step 8:

Your CSV is now as shown in the following structure:

Reference CSV File that has been fixed:

PDPesaje.csv (312.5 KB)

Thanks but it still doesn’t work

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

Yes,

Works in webform but not in Kobocollect(Android)

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