Could you please tell me where I am making my error? I have been trying to do this for over a day now so your help will be very much appreciated!
I need to change a set of cascade select questions to choose school details by the school code using the PULLDATA function.
(I have 1,500 schools so the Cascade select will run into issues. Also, I will also need to get someone to data clease this data each month, so uploading the one data cleansed file into Media will be easier than updating the cascade select responses)
Anyway, I get this error:
FormLogicError: Could not evaluate: /model/instance[@id=“SchoolNamesimport”]/root/item[School Code = ‘’]/Province, message: The expression is not a legal expression. (line: undefined, character: undefined)
On the xls file, I call the school code the EMIS_Code, which I convert to a substring using EMISCode before attempting to Pull the province name. I use the School code in the CSV file. You can access the links below
You helped me a great deal by explaining how the following pull functionality can look up school details in a webform when the enumerator keyed in the school code. It worked very well, but now I seem to have a problem.
When I delete the old file (csv) from Media and upload the new data cleased file, I seem to be pulling data from the old file. How long does it take to update the medial files?