I am following the method by @CuartaOportunidad_Local_IVC posted on the Updating the media folder of a Survey123 Form item blog.
see direct link here
shutil.make_archive(r'temp' + 'filename', 'zip', r'surveyfolder')
path = r'zippedsurvey'
surveyitemID = "itemid"
surveytoupdate = my_gis.content.get(surveyitemID)
surveytoupdate.update(data = path, item_properties={'type' : 'Form', 'title': 'filename', 'tags' : []})
thank you!others have this issueSurvey123 Update Through Python - GeoNet, The Esri CommunityUpdating a Form using python - GeoNet, The Esri Community
Hello @LeeIrminger1,
We are in the process more formally presenting python scripts and will be updating that Esri Community blog post shortly.
In the meantime we have updated the Update Media Folder script to use the ArcGIS API for Python.
I have attached a zip file that contains a Jupyter notebook and .py file that use the updated workflow.
I have just tested the same workflow using the script in the zip file attached and I was not able to reproduce the same behavior.
If you test updating the CSV using the script in the zip file is the same behavior observed?
Thank you,
Zach
Hi @ZacharySutherby
Thank you for the response and sharing the script! The script works like a charm except I only see the updated data in the Survey123 Desktop app and not in the browser. I ultimately need this in a dashboard so the browser functionality is important to me.
My XLSForm has 12 questions, four are select_one_from_file and there are three .csvs that those select from. Those three csvs are being updated using this new script and I see the changes when I download the zip from AGOL. The Desktop app sees and can download the update. It's like the browser version does not see that the files have been updated. I've cleared cache and all browsing data in two browsers, Edge and Chrome. Is there a way to trigger the browser-based Survey123 to look for updated media files?
Thank you!
I replied about an hour ago but the post has disappeared. Thank you for the response and sharing the script! The script works well, but I am seeing the same issue. The ArcGIS Survey123 Desktop application can download and see the updated data but the web-based Survey123 form does not. Is that expected?
To confirm was the CSV present in the Media folder upon initial publishing, or is the CSV hosted in ArcGIS Online and linked to the survey using the workflow outlined in this EAC documentation?
If the CSV is only present in the Media folder and not linked to the survey I would not expect this behavior as I did not see the behavior when I had tested on my end. If the CSV is linked to the survey there may be something different going on.
If the CSV is only present in the Media folder the Survey123 website should be making a request for item and pulling from the response of that request.
If you navigate to:
https://www.arcgis.com/sharing/rest/content/items/<FormID>/info/media/<CSVName.csv?token=<accessToken>
Does this download the most recent version of the CSV?
If you capture the web traffic when loading the web form you will also see that same request in the web traffic. Is the response of that request the updated choices or the old choices?
The CSV was present in the Media folder upon initial publishing.
When I navigated to the URL it did not show the most recent version, it shows the original version. Interesting!
The request in the web traffic also leads to the old choices in the csv file.
Thank you for looking into this!
Hi @ZacharySutherby,
If the original list is what pulls up from the rest url and when the web form is loaded but the field app can see and download the updated survey with the new csv data, does that mean there is something incorrect with the formatting CSVs that is causing this? I have the CSVs exported from a pandas dataframe using python. That is how the original CSVs were created and placed in the media folder as well.
Apologies for the delay in reaching out! I wouldn't expect it to be something with the CSV formatting but it could very well be a formatting issue. To remedy that resaving the CSV's using UTF-8 may help if it is a formatting issue.
I know you had mentioned that the CSV was present in the media folder upon publishing, just to confirm the CSV isn't also hosted in your organization and linked to the survey correct?
If I could obtain a copy of the XLSForm and CSV's I can do some testing on my end and see if I can reproduce the behavior. Feel free to send them to ZSutherby@esri.com if they are not able to be passed through the thread.
I'm experiencing the same issue as the original poster. I have the exact same setup, using select_one_from_file and pulldata() that reference a linked content CSV and the web form does not update to reflect the latest updates to the CSV file on ArcGIS Enterprise. When I inspect the form loading in the web, I can see it's grabbing the CSV from the media folder, which is old and out of date, and not referencing the linked content CSV.
Here is a screenshot of how the web form is still trying to pull from the Media folder even though there are no files there and I am using Linked Content.
Hello @MichaelBrown4,
What we determined happened was when the survey was originally published the linked CSV was included in the media folder.
What was happening was the update media folder script was working with a separate CSV than the linked one and when the script extracted the ArcGIS Online Form Items media folder it added the current timestamp the script was running to the file modify time.
Since there was an older version of the linked CSV in the ArcGIS Online Form Items media folder the field app thought it was working with the most recent version due to the time stamp, although it was using an older version.
The suggested workflow was to removed the linked CSV from the media folder in Connect and republish the survey. That way the field app can handle resolving the timestamp differences with the linked CSV, and the timestamps for the content in the Form Item's Media folder would be independent from the linked CSV.
Thanks Zach, I've tried removing from the Media folder and re-publishing, but still finding that the Linked Content CSV is not being respected and not being used for the choice list values. The Field App is working correctly actually, it's the Web Form that is not working right, it continues to reference the Media folder CSV and not use the Linked Content CSV.
If you use the script I had provided in the first comment on the post and only run the first 5 code cells (which will be up to and including the cell that extracts the zip file) in the unzipped folder that is created is the original CSV still in the media folder?
Hey Zach,
Thanks for pointing me in the right direction. I am trying to run the script in a Jupyter notebook but keep getting the following error message
Any help would be appreciated, Thanks!
Hello @ClintBoaz1,
In the path specified for the `download_folder` variable, if you navigate to that path is there a zip file with the same name as your survey in that location?
If not please double check the ID specified for the `itemID` variable is the item ID for your survey form item.
For example:
You can also insert print statements in code block 4 to print the `itm` and `savedZip` variables which will show what item in your Organization will be downloaded, and where that item was downloaded to.
Hey Zachary,
I was able to get the script to run however I ran into some odd behavior. I am using connect and the mobile application. The first time I ran the script without error it seemed to work as expected however after making additional changes to the update file the changes were not reflected in connect or the mobile application. Connect and the mobile application continue to return the value from the first time I ran the script despite the new values showing the csv file in the media folder. After reading through previous comments I realized I still had the survey linked to a copy of the csv file in AGOL. I removed the link and tried running the script again but now get this error:
What seems really strange to me is now that I have removed the link, connect and the mobile application continue to return the values from the first successful run even with those values being changed in the csv file in the media folder. Additionally, every time I open the form in connect I now get a message saying the XLS form has been modified asking if I want to update the survey even though no changes were made to the form. If I select yes it loads and then returns to the same box asking if I want to update the form in a loop until I select no.
Any help appreciated
The script is failing on passing along the size of the survey properties to the .update method. If you replace the surveyProp variable from the first parameter of the .update method and replace it with an empty dictionary {}. That should resolve the error message.
Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
