I have an issue whereby I have downloaded the XLS form, made some ammendments, have attempted no upload the XLS form using the Replace Form function. However i get the following error message - Import Failed! Name: a7GQ6HmttBy9Utn4gQxkgo.xlsx ValueError: There are duplicates in the name column
I checked the xls for duplicates and I dont see any. Excel also fails to discover any duplicates.
I then re-downloaded the original XLS and without even opening it, attempted to immediately upload it using the Replace Form function and I get the exact same error message!
Can anyone please assist? Im on a really tight deadline
Hi mate, yes I understand what you are saying now. I also have a $given_name column that I havent seen before and suspect doesnt belong on my form (I dont even collect names!). I left the column in but removed any data in that column and the XLS is now uploading. Well spotted!
Thanks! I had the same issue with two different forms, also having tried downloading and immediately re-uploading the xlsform. I found that for one of the forms @Lakshmikanthlr 's solution worked (ie. there was a mysterious $given_name value lurking in the column). Thanks @Lakshmikanthlr !
For my second form, I found no $given_name values, however deleting the automatically generated version rows at the bottom of the survey worksheet allowed me to bypass the error and upload the xlsform.
The $given_name column is nothing new. It is where the KoBo system places a dublicate original name when it replaces it automatically, creating a unique name. Example “lpr” was the duplicate and is replaced automatically by lpr_001.
You should avoid to get $given_name column as it always indicates a critical duplicate issue before. Any other coding, like constraint, relvant etc. will still refernce the original name which now has changed. So, will refernce the first apoearance, which normally was not your intension for the duplicate (2nd one).
Sorry, I think automatically renaming duplicates was never a brilliant idea as this will create problems/errors on any code references on the original name.
Users should always use the Online validator https://getodk.org/xlsform/ to test their original XLSForm. The validator will show the duplicate problem (without doing renaming).
$given_name column should stay in KoBo download, please, as long as KoBo does such automatic renaming. This is the only indicator that names were changed, which may destroy the originally designed references. @Josh