Pulldata is not working on KoboCollect (Android)

[Kal_Lam]

Hi @gustavomsandrini,

Please use the attached xlsform. It should work now. I have made changes highlighted in yellow. Besides, please be informed that your csv file was out of format. I have changed its format and have shared with you through the personal message! Please use the same with the current xlsform and you should be able to pull your data to KoBoCollect android app!

xlsform (modified):
aBvNXH8Au8wBJZ4vmHjTJR.xls (43.5 KB)

csv file:
Please check it in your personal message! I have sent you there!

GOOD DAY!

[gustavomsandrini]

Hi @Kal_Lam,

It has worked perfectly! Thank you for all the support!

[Victorpaisano25]

Hello how are you, the same thing happens to me, can you help me please

[Kal_Lam]

Welcome to the community, @Victorpaisano25! Could you provide details to your issue so that the community should be able to understand and help you solve it?

[Victorpaisano25]

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)

[Kal_Lam]

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

[Victorpaisano25]

Yes, it is, can you verify it?

[Kal_Lam]

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.

[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)