Survey123 Form required to be deleted and re downloaded again to push updates

[PaulSweeney3]

Hi All for the past few months we have noticed a recurring trend where updates to forms are not being automatically updated on devices , the user is being forced to delete the form and re download it completely to register the changes. I have noticed it is affecting the following functionality for definite and I suspect it ha affected other functionality 

1. CSV Linked content csv not updating until the form is deleted and downloaded despite the notification showing the csv being downloaded 
2. CSV in the media folder same as above
3. Select multiple list where values have been updated , the list is duplicated and the original values maintained with the new values appended to the dropdown 

This is on android devices running the most recent version of the app. I have rasied  the ticket with support re the linked content  but after numerous emails and even screen shares they told me it was expected behavior and they could not raise a bug or provide a solution so they closed the case. Has anyone else being having  this issue? 

[Anonymous User]

Hi @PaulSweeney3,

Are you able to share your XLSForm (xlsx file and any files in media folder) so we can try and reproduce the issue?

It sounds as though the SQLite database on the device is not being updated to reflect the new choice list values, even though the linked content CSV is being checked for and downloaded. Can you provide those external linked CSV files also. There could be something in the data or some other cause stopping the update.

Regards,

Phil.

[PaulSweeney3]

Hi  

Thanks for the response I cannot share the CSV as it is a complete list of our employees names. But I did note that one of the columns is Called Name and according to this info here "NAME" is a reserved word could that be the issue? 

for the duplication of Select one/multiple lists do reserved words affect the Names and Labels in the choices sheet as well ? if they are used in a label for example  this was my original list 

ELECTRICITY_Controls	1	<br>Implement the 5 Golden Rules</b>
ELECTRICITY_Controls	2	<br>Maintain Close Proximity Zone</b>
ELECTRICITY_Controls	3	<br>Implement Relevant Procedures</b>
ELECTRICITY_Controls	4	<br>Adjacent Live Network</b>
ELECTRICITY_Controls	5	<br>Instruments Tested and in Date</b>
ELECTRICITY_Controls	6	<br>Comply with the Electricity Safety Rules (ESB  SIRO  NIE  SSE etc.)</b>
ELECTRICITY_Controls	7	<br>Apparatus correctly identified to all crew members what is live and what is dead</b>
ELECTRICITY_Controls	8	<br>Utility drawing available</b>
ELECTRICITY_Controls	9	<br>MESCs  Job Aids  COPs  (SIRO  ESB etc.)</b>

I updated it to this

ELECTRICITY_Controls	ec1	<br>Implement the 5 Golden Rules</b>
ELECTRICITY_Controls	ec2	<br>Maintain Close Proximity Zone</b>
ELECTRICITY_Controls	ec3	<br>Implement Relevant Procedures</b>
ELECTRICITY_Controls	ec4	<br>Adjacent Live Network</b>
ELECTRICITY_Controls	ec5	<br>Instruments Tested and in Date</b>
ELECTRICITY_Controls	ec6	<br>Comply with the Electricity Safety Rules (ESB  SIRO  NIE  SSE etc.)</b>
ELECTRICITY_Controls	ec7	<br>Apparatus correctly identified to all crew members what is live and what is dead</b>
ELECTRICITY_Controls	ec8	<br>Utility drawing available</b>
ELECTRICITY_Controls	ec9	<br>MESCs  Job Aids  COPs  (SIRO  ESB etc.)</b>

and i ended up with this in the survey123 form a complete list with both sets of labels and names 

ELECTRICITY_Controls	1	<br>Implement the 5 Golden Rules</b>
ELECTRICITY_Controls	2	<br>Maintain Close Proximity Zone</b>
ELECTRICITY_Controls	3	<br>Implement Relevant Procedures</b>
ELECTRICITY_Controls	4	<br>Adjacent Live Network</b>
ELECTRICITY_Controls	5	<br>Instruments Tested and in Date</b>
ELECTRICITY_Controls	6	<br>Comply with the Electricity Safety Rules (ESB  SIRO  NIE  SSE etc.)</b>
ELECTRICITY_Controls	7	<br>Apparatus correctly identified to all crew members what is live and what is dead</b>
ELECTRICITY_Controls	8	<br>Utility drawing available</b>
ELECTRICITY_Controls	9	<br>MESCs  Job Aids  COPs  (SIRO  ESB etc.)</b>

ELECTRICITY_Controls	ec1	<br>Implement the 5 Golden Rules</b>
ELECTRICITY_Controls	ec2	<br>Maintain Close Proximity Zone</b>
ELECTRICITY_Controls	ec3	<br>Implement Relevant Procedures</b>
ELECTRICITY_Controls	ec4	<br>Adjacent Live Network</b>
ELECTRICITY_Controls	ec5	<br>Instruments Tested and in Date</b>
ELECTRICITY_Controls	ec6	<br>Comply with the Electricity Safety Rules (ESB  SIRO  NIE  SSE etc.)</b>
ELECTRICITY_Controls	ec7	<br>Apparatus correctly identified to all crew members what is live and what is dead</b>
ELECTRICITY_Controls	ec8	<br>Utility drawing available</b>
ELECTRICITY_Controls	ec9	<br>MESCs  Job Aids  COPs  (SIRO  ESB etc.)</b>

[Anonymous User]

Hi @PaulSweeney3,

Reserved keywords are not allowed in the NAME column, but are allowed in the LABEL column in both the survey and choices sheet.

Regards,

Phil.