hello
i am having this issue with my form
please let me know what to do
i ran the online validator (ODK - XLSForm Online v2.x ) i got: Error: Duplicate column header: Date
the other forms i have are not facing any issue and the online validator gets the same error.
please do let me know of the solution.
Thanks.
samiya
Kal_Lam
September 20, 2022, 4:17pm
3
@skasmani , when do you get this error message? Is it when you try to collect data through the webform or when you try to edit a submission?
Kal_Lam:
to edit a submission?
It is when i try to edit a submission
Kal_Lam
September 21, 2022, 7:22am
5
@skasmani , which server are you using? Is this an issue with only a single submission or is it an issue with multiple submissions?
wroos
September 21, 2022, 12:02pm
6
Your Excel form seems to have two columns with the same (KoBo) name in one of the sheets. Can you check and correct this, please.
kobo has been hosted on our own server
the issue is with multiple submission
@Kal_Lam
the other forms with the same columns which are working well dont bring up any errors @wroos
wroos
September 22, 2022, 11:14am
9
I think, there is definitely a duplicate problem in column names of this form version. Can you check all column names in all sheets, please.
i deleted the duplicate column; it is still bringing the same error
wroos
September 22, 2022, 2:13pm
11
Did you re-check with the validator and re-deploy after the delete?
As long as the validator shows duplicate error, there are probably duplicate in column names. Would you mind to review again in all sheets.
If you still cannot find it, you may share an extract or screenshot of yor form with all column headers (all sheets).
Kal_Lam
October 10, 2022, 1:31am
12
@skasmani , @wroos we have a GitHub issue ready that should solve this issue:
kobotoolbox:feature/nlp
← kobotoolbox:3996-different-root-names
opened 07:51PM - 20 Sep 22 UTC
## Checklist
1. [x] If you've added code that should be tested, add tests
2.… [ ] If you've changed APIs, update (or create!) the documentation
3. [x] Ensure the tests pass
4. [x] Make sure that your code lints and that you've followed [our coding style](https://github.com/kobotoolbox/kpi/blob/master/CONTRIBUTING.md)
5. [x] Write a description of your work suitable for publishing on [our forum](https://community.kobotoolbox.org/tag/release-notes)
6. [x] Mention any related issues in this repository (as #ISSUE) and in other repositories (as kobotoolbox/other#ISSUE)
7. [ ] Open an issue in the [docs](https://github.com/kobotoolbox/docs/issues/new) if there are UI/UX changes
## Description
Always regenerate (and update the root of the `<instance>` node) of the XML of the form when editing a submission to match the submission root name.
## Related issues
Closes #3996