I’m trying to use de pulldata function but i don’t know what is the problem with my form… Please Help

I’m trying to use de pulldata function but i don’t know what is the problem with my form… Please Help
Monitoreo PASE - Centros Educativos.xls (281,5 KB)
datospase.csv (413,3 KB)

https://community.kobotoolbox.org/t/pulldata-function-is-not-working/26857/4?u=elvira_rios

Please! Can you help me with this problem??
https://community.kobotoolbox.org/t/pulldata-function-is-not-working/26857/4?u=elvira_rios

Welcome back to the community, @elvira_rios! Would you mind saving your CSV file in UTF-8 format to see if it works? If your pre-loaded data contains non-English fonts or special characters, you will need to save it to this format. This enables your Android device to render the text correctly.

hi! Yes, I tried, but is the same. I read all the publications, but I can’t find the solution.
Monitoreo PASE - Centros Educativos PROBANDO.xls (97 KB)
datosexcel.csv (418,3 KB)

@elvira_rios, this is because you have used the variable name codigo_key in the expression but in it’s codigo in your CSV file.

Your pulldata expression:

pulldata('datosexcel','centro','codigo_key',${p1.5})

Variable name in your CSV file:

image

Fix this and this should solve your issue!

Hi!
I changed what you say but still not working
Monitoreo PASE - Centros Educativos PROBANDO.xls (97 KB)
datosexcel.csv (418,3 KB)

Hi! I’m trying o use pull data function but it doesn’t work!
Can someone help me please!
Monitoreo PASE - Centros Educativos PROBANDO.xls (97 KB)
datosexcel.csv (2,8 KB)

@elvira_rios, try this out and it should solve your issue:

survey tab as seen in your XLSForm:

choices tab as seen in your XLSForm:

image

CSV file

XSLForm:

Monitoreo PASE - Centros Educativos PROBANDO.xls (62.5 KB)

CSV File:

datosexcel.csv (2.6 KB)

Data entry screen as seen in Enketo:

THANK YOUUUUU!!! :smile: :smile: :smile: :smile:

So the problem was the orden of the column in the XLSform???
You should add this information to the help article !

THANK YOU VERY MUCH

1 Like

@elvira_rios, it was not the order. It was the labels from your CSV file that was having issues.