Duplicate variable names do not create errors

Hi there !

I met a important issue. In XLSForms syntax, you can have for example a group having the same name as a variable and this is not problematic generally speaking, but Kobo sees it as problematic. This means that when you import an XLS form, duplicate names do not give you an error message, but Kobo automatically renames one of the names adding “001” to it. I understand that Kobo might have technical issues with a group and a name having the same name (although the Kobo Excel Analyser made available on the platform sees this as a prerequisite for some features, which is therefore inconsistent…), but the minimum would be to have an error message either refusing the form as there are duplicate names or else informing the user on import that his variables have been renamed. And when you submit data and export results, variable names has been modify without notice it to the user.

image
Inkedduplicatevname2_LI

I am using KOBO Humanitarian response & ODK Collect v1.22.4.

Thank you for taking this into account :slight_smile:
Chloé

Hi @chloelaborde,

Could you share the xlsform so that we could look over it. Thank you!

hey !

Sorry only saw your message today.
Here is an example form:
test.xlsx (38.1 KB)

Thank you :slight_smile:

Hi @chloelaborde,

Kindly please be informed that when a user uploads an xlsform with a typo error (say as shown in the image below, where the name laku is not unique):

image

The system automatically fixes the same as shown in the image below (where one of the duplicates is automatically renamed and then marks under original name under the $given_name column):

image

You could test the same by the following xlsform:

test_typo.xlsx (26.3 KB)

Steps to test:

  • Upload the xlsform shared in this post.
  • Deploy (you should be able to deploy in the system).
  • Download the xlsform and you should see the fix made by the system.

Have a great day!

Hi @Kal_Lam,

Thank you for this trick to check if Kobo automatically renamed duplicates. But the problem is precisely this : that KOBO renames automatically variables names.

You do not always know, or think, you gave common names so you are not going to download your XLSForm from KOBO once you upload it. The idea we had was to avoid KOBO to rename automatically by having an error message or a message saying that there were duplicates variable names in the form. It will allows the user to check his form himself and to modify it. It will avoid mistake in later analysis and data management.

I hope your will understand this request,
Chloé

2 Likes

Hi @chloelaborde
Just out of curiosity, have you tried testing your form on say ODK to see if the behaviour is replicated? Normally when you forsee that you are going to have such kind of potential errors, the most sensible approach would be to look at your form kindly. My approach would be to control for this at the excel by enabling conditional formating for duplicates on names. This enables me to flag these before I can even test the form.

In essence, knowing that the behaviour on Kobo is to rename, one should take caution to avoid uploading a form with duplicates. I would also suggest that you post this as suggestion for future development if you strongly feel that it should be incorporated as you had indicated.

Stephane

2 Likes

Hi @stephanealoo,

Thank you for your answer. Yes of course we test forms on ODK before.
Agree, I posted it as a suggestion first, in “improvement”, as it’s not really an issue. It was an idea to make KOBO more user-friendly as I am not sure all people who are going to use KOBO know this. It was not me who classified it in “user-support” and looks like I can not change the category by myself so I will post it again in suggestions.

Kind regards,
Chloé