i am trying to pull data from a CVS file named
StdBazGP22_1
I put the this command in the calculation column
pulldata(‘StdBazGP22_1’, ‘ClusterID’, ‘ID’, ${IDNumber})
Where
StdBazGP22_1’ = CVS file
ClusterID = the variable I want to pull
ID= the keywariable
IDNumber= the name of the question variable in the XLS form
Expected behavior = pulls the variable from the CVS file
I get this error:
CSV column heading “” cannot be turned into a valid XML element
There are no spaces or special characters in the column heading. I even eliminated all other variables except the two mentioned above.
Still will not work.
@timotuck , could you also share the CSV file with the community? The community should also be able to help you identify the issue if it’s related to the same.
So this means no one uses pulldata?
Well, I see that either no one is interested in this topic or no one can solve it. Might be of interest to know that I ran it on Ona.io and it works fine.
Kal_Lam
September 16, 2022, 12:08pm
6
@timotuck , I see that there should be syntax issues in your XLSForm. These are the issues I found:
Variable names missing (highlighted in yellow).
Wrong use of label:language
. Should be label::language
Here is the working XLSForm and the CSV file I tested at my end.
XLSForm:
StD_Surv_8_16_22_pULL.xlsx (94.4 KB)
CSV File:
StdBazGP22_1.csv (9.0 KB)
Maybe going through this document should also be helpful for you to understand how to create your survey form in the XLSForm.
FYR: Form working in Enketo