CSV column heading "barcode_key,layer_code" cannot be turned into a valid XML element

User Support Form Building
,
1

Hello,

I am getting an error when trying to view the ODK form after deploying: CSV column heading “barcode_key,layer_code” cannot be turned into a valid XML element. I have one external file that is used in a pulldata I suspect that something goes wrong there, but I cannot find what.

This is the form I am using
Final_form_Barcode_and_Sample_number - with CSV!.xlsx (89.7 KB)

And this is the external file
LayerCodeScan.csv (8.7 KB).

Can you help me to advance?
Thanks!

2

@Webex, i had a quick look at your CSV file and then could see this:

image
image275×797 22.4 KB

The ;; should be causing the issue. Try removing them and that should resolve your issue.

3

Thanks for your answer! It is strange that when I open the CSV file, I don’t see the ;;. When using replace function to remove the character, it does not find that character. However, after I using the concat function again to move all the columns in one column and redeploying I can use the ODK form.

1 Like