Latest Contributions by ZacharySutherby

Hello @ClintBoaz1,  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.  Thank you,  Zach ... View more

Hello @maplover,  The public status of the defect has been marked as implemented. Please feel free to reach out to Esri Technical Support and they will be able to assist with confirming the defect resolution.  Thank you,  Zach ... View more

Hello @KellyArmstrong,    If you navigate to the item details page of the feature service your survey is pointing to. At the bottom of the page there is a URL link, if you click the "view" button it will open the REST endpoint of the feature service in a new tab. On the page that it opens towards the top there will be a Layers section. Does the name of the layer with ID 0 match "table_name".  If not you will need to update the value you have in the form_id column of the settings worksheet in the XLSForm to match the name of the layer from the REST endpoint.  Thank you,  Zach ... View more

Hello @PrachiPatel,  Unfortunately Survey123 doesn't have an out of the box ABS function available, but there is a workaround. Please check out Ismael's comment on another post that discusses the workaround.  For the INT function, Survey123 has support for an int() function, please check out the XLSForm Formulas documentation for more information.  Thank you,  Zach ... View more

Hello @Lexicon1950,  Assuming you want your survey to only submit to the related table this Esri Support KB article will help you configure your survey to only point to the related table instead of the feature service.  Thank you,  Zach ... View more

Hello @Anonymous User,  To troubleshoot the issue would I be able to obtain a copy of the XLSForm & any CSV's used in the pulldata() function. Please feel free to pass them along to ZSutherby@esri.com and I'll be happy to look into it.  Thank you, Zach ... View more

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.  Thank you,  Zach ... View more

Hello @ClintBoaz1,  The Survey123 team has been working on updating the script to use Python 3 and the ArcGIS API for Python as that is the supported replacement for the arcrest module.  I have a copy of the updated script in another Esri Community comment that is intended to replace this script.  We are working on creating a central hub and documentation for a number of Python scripts the Survey123 has, but unfortunately isn't live just yet. Once that hub goes live we'll be updating the existing blog posts with the updated resources.  The updated script attached to the other Esri Community comment takes 6 variables. They are:  portalURL - The URL for your ArcGIS organization (in your case: https://gdrcnw.maps.arcgis.com) username - Your ArcGIS organization username (ex. gisadmin) password - You ArcGIS organization password (ex. gisadmin1) itemID - The item ID for the ArcGIS Survey123 form item in your ArcGIS organization (in your case: c2c2ab0e33aa4b518c4233bbed870c20) updated_files - The updated file name containing the extension (in your case: SiteInventory_SQLTableDownloadTest.csv) source_loc - Folder directory where the updated file is located (in your case //nwshfp01/arcgis/data/workingmapdocs/clint/forjarrod/output/)   The script will need to be run either in Jupyter notebook which ships by default with ArcGIS Pro, or can be run directly in ArcGIS Online if you have notebooks enabled for your account.  Thank you,  Zach ... View more

Hello @Anonymous User, Thank you for passing along the XLSForm! I have tested and was able to reproduce the same behavior on my end. There's a couple of things going on, but ultimately is a defect on our end. What's happening is after saving the survey as a draft the fist time, on the back end only the questions where data was recorded is stored. The issue is after saving the survey in the drafts for the second time all the questions are then stored on the back end and the ones that aren't answered have a "null" value associated with them. Since the choice lists are 0 based when the survey is opened back up the Field App is mistaking those "null" values as "0" and selecting the choices.  The workaround that worked on my end was to switch the choice lists from 0 based to 1 based (ex. 1:No, 2:Yes, 3:N/A). The issue (other than needing to update the form logic with the updated choices) is it looks like the survey was created based on a feature service pointing to an Enterprise Geodatabase feature class. After republishing the survey the domains in the Enterprise Geodatabase feature class will also need to be updated to reflect these changes.  We have an internal issue for the defect logged on our end but unfortunately it doesn't look like an official Esri Support BUG has been logged for the behavior just yet. I would suggest creating a ticket with Esri Technical Support to have the defect logged which will make it easier to track the status of the issue.  Thank you,  Zach ... View more

Hello @JoseVidal,  Thank you for passing along the XLSForms! I've tested on my end and I am not able to reproduce the same behavior:    The first thing that comes to mind is maybe when the original TestCalculation survey was published the option to Create coded value domains from choices may not have been selected.  In ArcGIS Online if you navigate to the Item Details page for the hosted feature service your surveys are pointing to > select the Data tab > Fields > select the Rating field > Does that field have a list of domain values?    Thank you,  Zach ... View more

Hello @Arnaud_Brival,  Thank you for passing along the XLSForm and CSV! In taking a look at the CSV there are duplicate column headers, column O and column AA both have the header "Training". I changed column O to "Deep_Water_Training" (for example), resaved the CSV, and it looked like the pulldata() function was working on my end.  Thank you,  Zach ... View more

Hello @danbecker,  It looks like the app link for Field Maps is https://fieldmaps.arcgis.app. Please use this link for reference regarding the Field Maps documentation for app links: https://doc.arcgis.com/en/field-maps/ios/help/deploy-your-map.htm I'll create an issue in our documentation repo now to add the Field Maps link to our documentation.  Thank you,  Zach ... View more

Hello @KerryKang,  You don't need to do step 3 in the workflow above. I would actually advise against doing step 3, just as Lee was seeing in the other Esri Community post 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.   If you removed the linked CSV from the media folder and republish the survey do you see the same behavior?  Thank you,  Zach ... View more

Hello @Ali_Hussein_Awad,  Based on the error message it seems like the feature service was shared as reference and not copied to the ArcGIS Online environment.  What's likely happening is Survey123 is passing along your ArcGIS Online token to the service, but since it's likely still referencing your ArcGIS Enterprise service the ArcGIS Enterprise organization is rejecting the ArcGIS Online token.  One way to confirm is from the item details page for the ArcGIS Online item if you scroll to the bottom of the page there will be a REST URL. If you select that REST URL does the URL point to ArcGIS Online or your ArcGIS Enterprise Organization?    If you share the feature service as a copy and it creates a new hosted feature service in ArcGIS Online that should work, or if you need it to point to the feature service from your ArcGIS Enterprise Organization I would suggest not sharing it through the collaboration but adding it as an item to your ArcGIS Online organization and storing the credentials.  Thank you,  Zach   ... View more