# Uploading an XLSForm to ODK central

**URL:** <https://forum.getodk.org/t/uploading-an-xlsform-to-odk-central/35333>\
**Category:** Support\
**Tags:** odk-central\
**Created:** [October 9, 2021, 3:24pm UTC](https://forum.getodk.org/t/uploading-an-xlsform-to-odk-central/35333 "2021-10-09T15:24:21Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![R-abukoura](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/r-abukoura/32/16522_2.png) [@R-abukoura](https://forum.getodk.org/u/R-abukoura)\
**Post date:** [October 9, 2021, 3:24pm UTC](https://forum.getodk.org/t/uploading-an-xlsform-to-odk-central/35333/1 "2021-10-09T15:24:21Z")

</div>

Hi,

I have created an xls form that I want to upload for testing. However, I keep getting this error Error:

The XLSForm could not be converted: ODK Validate Errors:

> > XForm is invalid. See above for the errors.  
> > : Cycle detected in form's relevant and calculation logic!  
> > The following nodes are likely involved in the loop:  
> > ${date\_of\_death\_know\_other\_ombadda}  
> > ${death\_year\_know\_other\_ombadda}  
> > ${name\_know\_other\_ombadda}  
> > ${agemem\_know\_other\_ombadda}  
> > ${knowdate\_know\_other\_ombadda}  
> > ${know\_other\_ombadda}  
> > ${sexmem\_know\_other\_ombadda}  
> > ${address\_of\_know\_other\_ombadda}

The following files failed validation:  
${Mort-Fol-Pilot}.xml

Result: Invalid

I am not sure how to solve this error and I would appreciate your help.

Many thanks

---

<div class="post-metadata">

**Author:** ![danbjoseph](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/danbjoseph/32/21901_2.png) [@danbjoseph](https://forum.getodk.org/u/danbjoseph)\
**Post date:** [October 11, 2021, 1:23pm UTC](https://forum.getodk.org/t/uploading-an-xlsform-to-odk-central/35333/2 "2021-10-11T13:23:08Z")

</div>

Welcome to the ODK forum, @R-abukoura! We're glad you're here. When you get a chance, please [introduce yourself on this forum thread](https://forum.getodk.org/t/-/6671). I'd also encourage you to add a picture as your avatar because it helps build community!

Are you able to post your XLSForm file here? It will help someone troubleshoot the problem.

---

<div class="post-metadata">

**Author:** ![Clement](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/clement/32/16090_2.png) [@Clement](https://forum.getodk.org/u/Clement)\
**Post date:** [October 12, 2021, 12:52am UTC](https://forum.getodk.org/t/uploading-an-xlsform-to-odk-central/35333/3 "2021-10-12T00:52:30Z")

</div>

Can you share your XLSForm?  
What may be happening is in the 'relevant' expressions for the fields (date\_of\_death\_know\_other\_ombadda, death\_year\_know\_other\_ombadda, name\_know\_other\_ombadda, etc) you may have made reference to the same fields.

---

<div class="post-metadata">

**Author:** ![R-abukoura](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/r-abukoura/32/16522_2.png) [@R-abukoura](https://forum.getodk.org/u/R-abukoura)\
**Post date:** [October 18, 2021, 11:54am UTC](https://forum.getodk.org/t/uploading-an-xlsform-to-odk-central/35333/4 "2021-10-18T11:54:29Z")

</div>

Hi Clement,

Thank you for responding.

I have managed to solve the issue a few days after and like you said I had made references within the same fields.

---

<div class="post-metadata">

**Author:** ![danbjoseph](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/danbjoseph/32/21901_2.png) [@danbjoseph](https://forum.getodk.org/u/danbjoseph)\
**Post date:** [November 7, 2021, 10:12pm UTC](https://forum.getodk.org/t/uploading-an-xlsform-to-odk-central/35333/5 "2021-11-07T22:12:58Z")

</div>

Split this topic on November 7, 2021, 10:12pm UTC

A post was split to a new topic: [Error when uploading XLSForm](https://forum.getodk.org/t/error-when-uploading-xlsform/35678)

---

<div class="post-metadata">

**Author:** ![PP\_mgrgov](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/pp_mgrgov/32/27932_2.png) [@PP\_mgrgov](https://forum.getodk.org/u/PP_mgrgov)\
**Post date:** [December 11, 2024, 8:35am UTC](https://forum.getodk.org/t/uploading-an-xlsform-to-odk-central/35333/6 "2024-12-11T08:35:17Z")

</div>

[PHC DGA 11-12.xlsx](https://forum.getodk.org/uploads/short-url/2fVTFAqydbDSqiz7NU3Osrl5SLm.xlsx) (165.6 KB)  
I am also facing a similar issue. On submission for validation showing "Cycle detected in form's relevant and calculation logic! ". I don't know what is wrong in my form. Kindly help

---

<div class="post-metadata">

**Author:** ![LN](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ln/32/1605_2.png) [@LN](https://forum.getodk.org/u/LN)\
**Post date:** [December 12, 2024, 7:00pm UTC](https://forum.getodk.org/t/uploading-an-xlsform-to-odk-central/35333/7 "2024-12-12T19:00:58Z")

</div>

I haven't looked at the form in detail but I believe the issue is with `patient_pnc` and `que_pnc`. You can't calculate `que_pnc` based on `patient_pnc` and then use it in the relevance and repeat\_count settings for `patient_pnc`. I've confirmed that the form converts without error if I change the relevance and count for `patient_pnc` to use `pat_avl_pnc`. You may want to start a new thread describing what you're trying to do so we can find a good way to address the need.

To figure this out, I started by converting the form directly in Central and saw a huge list of fields involved in the cycle. That didn't feel right to me so I put the form in a test so I could debug it. I was able to identify a smaller number of fields more likely to be involved in the cycle. I believe there is a problem with how fields involved in cycles are being reported and will dig deeper into that.

Welcome, @PP_mgrgov, it's nice to see you here and thanks so much for introducing yourself. Consider sharing some of your work in the [Showcase](https://forum.getodk.org/c/showcase/10) at some point. I'd be very interested in learning more about how you manage very large forms. Are you managing XLSForms by hand? Do you have a system for managing versions? For verifying forms as they get updated?

---

<div class="post-metadata">

**Author:** ![PP\_mgrgov](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/pp_mgrgov/32/27932_2.png) [@PP\_mgrgov](https://forum.getodk.org/u/PP_mgrgov)\
**Post date:** [December 20, 2024, 6:26am UTC](https://forum.getodk.org/t/uploading-an-xlsform-to-odk-central/35333/8 "2024-12-20T06:26:36Z")

</div>

Thank you so much for pointing that out! I was aware that there is some mistake in that begin\_repeat (que\_pnc) section but didn't realise it is affecting the whole form logic!. The form is validated after I corrected that part!

Currently, I am handling the forms manually. It is tedious, definitely. My team has built a conditional formatting for handling the different versions of the form online. So the version gets updated, as per the date last change was made. To validate, I download and submit to enketo. Currently, I have no other way to handle it. But would like to know if there a way to manage it more efficiently. Also, since the form is huge, there are many labels and question numbers. Even if one question is removed or added, whole numbering needs to be edited every single time. It will be great if there can be a tool which will make this task easier. or if the question number can be in a separate column altogether, so that it can be cleaned up at the end.
