Updating existing odk xlsform

I require to add required column as "Yes", required_message as "Mandatory" for all my existing questions on the ODK xls questionnaire xls form. I wanted to reupload the same form with version change instead of uploading as a new form. Whether it is possible?
ODK collect, Android. ODK Aggregate server.
I tried adding condition in required column and changed the version and tried uploading but it throws error saying "same form already exist".
Please let me know about this and how to reupload it with the same database table with data.

Thanks in advance for your kind help!

Karthik

Hi Karthik,

Changing the required and required_message fields should be possible by updating the form, indeed.

However, if I remember correctly, ODK Aggregate used alphanumerical version sorting instead of numerical version sorting. Therefore, it would recognize 10 to be lower than 9 (because the first digit 1 is lower than 9). Maybe this is causing you an issue?

For Aggregate, I would recommend starting off with a high number and then increase it. E.g. 10001, 10002, 10003, etc. instead of 1, 2, 3, ...

Best

Hi vlehn,
Thanks for your reply.
I was going through my questionnaire form and noticed in one place I have changed one of the question type fields from "select_one" to "select_multiple" along with changing the required and required_message fields. I think this is where I was facing the problem and it was showing me the "Form already Exists" error. Let me try to not change the field type and only make the required field change and upload.
Version sorting is not a problem for me, I have used versions in order of 01,02, etc.

Thanks,
Karthik

I have just added "yes" for the required field and required_message as "Mandatory" for many questions and updated the version to "04" and didn't touch any of the other fields and tried uploading but still, it gives me a "Conflict" error, screenshot attached. Can you please help out to resolve this issue please.

Thanks,
Karthik

Hi,

I noticed one thing that my earlier form "required" fields were empty I haven't mentioned "no" but it considers blank as "no". Now I'm adding "required" as "yes", does this cause the issue? and I'm unable to upload the questionnaire with version update??

It would be a great help if someone provide me a solution to make fields mandatory with disturbing existing data of the table. It will be very hard to consolidate the data if I need to publish a new questionnaire form only for making fields Mandatory.

Kindly help! I have to do this change immediately.

Thanks,
Karthik

It should be doable. Are you sure you add a form with biger version number? What was the previous version?

Hi,
I did it, it was a little tricky. I noticed one thing that my earlier form "required" fields were empty I haven't mentioned "no" but it considers blank as "no". Now I'm adding "required" as "yes", does this cause the issue? and I'm unable to upload the questionnaire with version update??

So I tried checking these, I first added "no" for all blank fields and uploaded this version form then I changed all "no" to "yes" then uploaded this version, it was started working.

Thanks,