I have two CSVs attached to numerous surveys: The first is a list of names for a select_one_from_file. The second is a list of employee names and information (e.g., email, title, etc.).
Both CSVs are linked as external content. Both CSVs need to be updated once per week.
I have two web based surveys attached to these CSVs as well. I know that the web form only uses what is in the Media folder, so I update and republish those two surveys each week. (This is not a problem - just adding in the full process).
I update the CSVs through the Portal with the new data. This is successful.
When a survey is downloaded through the mobile app, both CSVs appear to be up to date.
My problem: When a survey is downloaded through the desktop app, the select_one_from_file updates, but the pulldata CSV does not. This creates a mismatch because there are a different number of names between the two CSVs.
Any ideas?
SpoilerYes, deleting and re-downloading the survey does work on the desktop app. This is not a reasonable solution to ask 1000 people to do this once a week. Also yes, renaming the CSVs works, but that is also not a reasonable solution because of how many surveys the CSVs are attached to, and that change would also require republishing all of the surveys.