Help with Error: Your file should have the .xis .xlsx, .xml file extension because Ona uses XLS Forms to create forms.

[ma...@microfinance.com]

I already shared the screenshots, which contain the exact returned error message, in my initial message. Please refer to them there.

 

In any case, I did some more testing, and the problem was an empty cell in the calculation column in a type:calculate row.

 

This was confusing because the error message implies that there is some problem with the file type.

 

In any case, my issue is fixed, but you might want to see whether you want to remove the message about the file type when the issue is a blank calculation field in a calculate row.

 

Kind regards,

 

Mark Schreiner  

 

 

 

From: 'Jane from Ona' via Ona Community
Sent: Tuesday, October 19, 2021 01:58 AM
To: ona-co...@googlegroups.com
Subject: Re: [ona-community] Reference to variable created in repeat group returns value only from first iteration, not current iteration

 

This message was sent to the following 2 people: Mark, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Mark, I apologise for the inconvenience this has caused you. Please share the XLSForms that you are trying to upload so that I can test the issue from my end. Also, kindly share a screenshot of the exact returned error message. Regards, Jane See our community forum & help site for more information!

Jane from Ona

On Mon, Oct 18, 2021 at 10:12 AM, "Mark" <ma...@microfinance.com> wrote: Dear Samson: The same error as below is coming up again today. Note that I also get it when trying to upload forms that uploaded fine (with no changes) two weeks ago. The file extension is .xls. Could this again be some issue with Enketo/pxyform? Please check and let me know. Mark image001.jpg image002.jpg image003.jpg On Fri, Mar 12, 2021 at 02:02 AM, "Samson Amwata" <samson...@ona.intercom-mail.com> wrote: Hello Mark,  Apologies for the inconvenience this has caused you. After the upgrade, it seems that there is a new validation that was added where the system does not allow form title with URL characters such as / or : or . Please remove these characters only from form you downloaded from Ona and replace the one existing for the fix to be effected on the form. Let me know if this does not solve the issue. I will be happy to arrange for a call. Regards, Samson On Thu, Mar 11, 2021 at 09:11 AM, "Mark" <ma...@microfinance.com> wrote: Dear Samson: I have tested, but the problem remains. I tested with a number of forms, and they all still have the issue. Cleared cache, reloaded, tried on both Firefox and Chrome, still the issue remains. I also attempted to replace the xlsform (in case it needs to be rerun through pyxform to fix the issue), but even though the file I am uploading is .xls, I get the error message: “Invalid title value; value shouldn't match a URL. Your file should have the .xls .xlsx, .xml file extension because Ona uses XLS Forms to create forms.” So perhaps this error needs to be fixed before I can truly test. Please see three enclosed print-screens. If you have any instructions that would be helpful for someone who does not work with Ona every day beyond “test”?. What browser to use? What version of the browser? Do I need to run the form through Pyxform anew so that whatever was updated there can affect my xlsform? Kind regards, Mark image001.jpg image002.jpg image003.jpg Step-1-Specify-xls-FIle-to-Replace-Current-Form-So-As-To-Run-Through-Updated-Pyxform.pdf Step-2-xls-Form-Uploading.pdf Step-3-Ona-Throws-Error-Because-Incorrectly-Thinks-xls-file-is-URL.pdf On Thu, Mar 11, 2021 at 02:17 AM, "Samson Amwata" <samson...@ona.intercom-mail.com> wrote: Hello Mark, We have deployed the latest version of Enketo and PyXform and this has solved the issue with pulling data in a repeat group. Please test and let us know if you have further questions. Regards, Samson See our community forum & help site for more information! On Mon, Feb 22, 2021 at 06:49 AM, "Samson Amwata" <samson...@ona.intercom-mail.com> wrote: Hello Mark, Currently, Ona is using Enketo version 2.5.6. However, the issue you were facing was not really related to Enketo version but the version of PyXform we are using. Our technical team has already prepared a release that uses the latest PyXform version which is still in the testing phase on our stage environment. We will notify you once this deployed will be scheduled on before the end of the week. Regards On Sun, Feb 21, 2021 at 12:27 PM, "Mark" <ma...@microfinance.com> wrote: Has Ona updated to ODK enketo version (V2.6) yet? On Tue, Jan 12, 2021 at 03:20 AM, "Samson Amwata" <samson...@ona.intercom-mail.com> wrote: Hello Mark, I have been able to replicate the issue on our Enketo version(V2.3.11) and it works fine on ODK enketo version(V2.6). I have notified our technical team and we will work to upgrade our Enketo version to the latest version. I will notify you here one this update has been made. Regards, Samson See our community forum & help site for more information! On Mon, Jan 11, 2021 at 08:40 AM, "Mark" <ma...@microfinance.com> wrote: The original post includes the XLS form as an enclosure, as well as a series of print-screen to show how to reproduce the problem, as well as links to the operating form on ona.io (where the problem appears) and on getodk.org (where the problem does not appear). Kind regards, Mark image001.jpg image002.jpg image003.jpg On Sun, Jan 10, 2021 at 11:54 PM, "Samson Amwata" <samson...@ona.intercom-mail.com> wrote: Hello Mark, Kindly share the XLSForm with us so that we can see how you have developed your form and also test the the issue from our side. Regards, Samson On Sun, Jan 10, 2021 at 06:32 PM, "Mark" <ma...@microfinance.com> wrote: When I reference a variable created earlier within a given iteration of a repeat group, it sometimes (not always, ugg) and unexpectedly returns the value from the first iteration even on iterations after the first, when I expect it to return the value from the current iteration.   This sometimes happens when first set of iterations through the repeat group (without any backing up), and i seems to always happen when backing up through the repeat group.   I think that this is probably not a mere programming bug of mine because it happens when I run the form via enketo.on.io (https://enketo.ona.io/x/yi2LrbzH, XLSform enclosed with the relevant repeat group highlighted), but it works as expected when the same form is run through getodk.org/xlsform/ (ignoring the initial error message, see temporary link: https://enketo.getodk.org/preview?form=https://xlsform.getodk.org/downloads/cym_7xz9/ScorocsUGA003-09.xml).   I enclose a series of print-screens showing the unexepected behavior.   Any suggestions?   Mark -- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/d08f91e3-3c94-41da-ae8c-c1de636beeb7n%40googlegroups.com. ScorocsUGA003-09-Ona-Community_forum.xls Screen-Shots-Value-From-First-Repeat-Iteration-Unexpectedly-Returned-In-Later-Iterations.pdf

--
Collect, Analyze and Share Data - https://ona.io/
---
You received this message because you are subscribed to a topic in the Google Groups "Ona Community" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/ona-community/98XzEjORfrU/unsubscribe.
To unsubscribe from this group and all its topics, send an email to ona-communit...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/a130eea2-7f71b3ff-1634626683-63366200024487%40ona.intercom-mail-300.com.

[Samson from Ona]

This message was sent to the following 2 people: Mark, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Mark, Apologies for the inconvenience this has caused you. Kindly could you share the XLSForm that had blank calculation so that we can try to replicate the error from our end? Please note that when a calculation is missing we expect to have an exact error saying there is a missing calculation. Regards, Samson 

Samson from Ona

On Tue, Oct 19, 2021 at 11:10 AM, "Mark" <ma...@microfinance.com> wrote:

I already shared the screenshots, which contain the exact returned error message, in my initial message. Please refer to them there. In any case, I did some more testing, and the problem was an empty cell in the calculation column in a type:calculate row. This was confusing because the error message implies that there is some problem with the file type. In any case, my issue is fixed, but you might want to see whether you want to remove the message about the file type when the issue is a blank calculation field in a calculate row. Kind regards, Mark Schreiner From: 'Jane from Ona' via Ona Community Sent: Tuesday, October 19, 2021 01:58 AM To: ona-co...@googlegroups.com Subject: Re: [ona-community] Reference to variable created in repeat group returns value only from first iteration, not current iteration

This message was sent to the following 2 people: Mark, ona-co...@googlegroups.com. Replying to this email will notify them.

Hello Mark, I apologise for the inconvenience this has caused you. Please share the XLSForms that you are trying to upload so that I can test the issue from my end. Also, kindly share a screenshot of the exact returned error message. Regards, Jane See our community forum & help site for more information!

Jane from Ona

On Mon, Oct 18, 2021 at 10:12 AM, "Mark" <ma...@microfinance.com> wrote: Dear Samson: The same error as below is coming up again today. Note that I also get it when trying to upload forms that uploaded fine (with no changes) two weeks ago. The file extension is .xls. Could this again be some issue with Enketo/pxyform? Please check and let me know. Mark

image001.jpg image002.jpg

image003.jpg On Fri, Mar 12, 2021 at 02:02 AM, "Samson Amwata" <samson...@ona.intercom-mail.com> wrote: Hello Mark,  Apologies for the inconvenience this has caused you. After the upgrade, it seems that there is a new validation that was added where the system does not allow form title with URL characters such as / or : or . Please remove these characters only from form you downloaded from Ona and replace the one existing for the fix to be effected on the form. Let me know if this does not solve the issue. I will be happy to arrange for a call. Regards, Samson On Thu, Mar 11, 2021 at 09:11 AM, "Mark" <ma...@microfinance.com> wrote: Dear Samson: I have tested, but the problem remains. I tested with a number of forms, and they all still have the issue. Cleared cache, reloaded, tried on both Firefox and Chrome, still the issue remains. I also attempted to replace the xlsform (in case it needs to be rerun through pyxform to fix the issue), but even though the file I am uploading is .xls, I get the error message: “Invalid title value; value shouldn't match a URL. Your file should have the .xls .xlsx, .xml file extension because Ona uses XLS Forms to create forms.” So perhaps this error needs to be fixed before I can truly test. Please see three enclosed print-screens. If you have any instructions that would be helpful for someone who does not work with Ona every day beyond “test”?. What browser to use? What version of the browser? Do I need to run the form through Pyxform anew so that whatever was updated there can affect my xlsform? Kind regards, Mark

image001.jpg image002.jpg image003.jpg Step-1-Specify-xls-FIle-to-Replace-Current-Form-So-As-To-Run-Through-Updated-Pyxform.pdf Step-2-xls-Form-Uploading.pdf

image001.jpg image002.jpg

image003.jpg On Sun, Jan 10, 2021 at 11:54 PM, "Samson Amwata" <samson...@ona.intercom-mail.com> wrote: Hello Mark, Kindly share the XLSForm with us so that we can see how you have developed your form and also test the the issue from our side. Regards, Samson On Sun, Jan 10, 2021 at 06:32 PM, "Mark" <ma...@microfinance.com> wrote: When I reference a variable created earlier within a given iteration of a repeat group, it sometimes (not always, ugg) and unexpectedly returns the value from the first iteration even on iterations after the first, when I expect it to return the value from the current iteration. This sometimes happens when first set of iterations through the repeat group (without any backing up), and i seems to always happen when backing up through the repeat group. I think that this is probably not a mere programming bug of mine because it happens when I run the form via enketo.on.io (https://enketo.ona.io/x/yi2LrbzH, XLSform enclosed with the relevant repeat group highlighted), but it works as expected when the same form is run through getodk.org/xlsform/ (ignoring the initial error message, see temporary link: https://enketo.getodk.org/preview?form=https://xlsform.getodk.org/downloads/cym_7xz9/ScorocsUGA003-09.xml). I enclose a series of print-screens showing the unexepected behavior. Any suggestions? Mark -- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/d08f91e3-3c94-41da-ae8c-c1de636beeb7n%40googlegroups.com.

ScorocsUGA003-09-Ona-Community_forum.xls Screen-Shots-Value-From-First-Repeat-Iteration-Unexpectedly-Returned-In-Later-Iterations.pdf

-- Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to a topic in the Google Groups "Ona Community" group. To unsubscribe from this topic, visit https://groups.google.com/d/topic/ona-community/98XzEjORfrU/unsubscribe. To unsubscribe from this group and all its topics, send an email to ona-communit...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/a130eea2-7f71b3ff-1634626683-63366200024487%40ona.intercom-mail-300.com.

--

Collect, Analyze and Share Data - https://ona.io/ --- You received this message because you are subscribed to the Google Groups "Ona Community" group. To unsubscribe from this group and stop receiving emails from it, send an email to ona-communit...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/ona-community/027701d7c503%24bfc288d0%243f479a70%24%40microfinance.com. image001.jpg image002.jpg image003.jpg