Latest Contributions by ZacharySutherby

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 [email protected] 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

Hello @AndrewPadilla,  Thank you for passing along the JS file and the other CSV files. I have tested on my end and they all seem to be working. Please let me know if there are any issues or errors encountered and I will be happy to take a look into them.  Thank you,  Zach ... View more

Hello @AndrewPadilla,  Thank you for reaching out! I have taken a look at our Tech Support cases and believe I have found the case you had logged.  Assuming the case I found is the correct one the issue with the Form 1 survey that was passed along is the pulldata() function was being used incorrectly. The XLSForm that was passed along has 5 values specified in the function when the function only takes 4. Please use these links for more information on the pulldata() function: https://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformformulas.htm#ESRI_SECTION1_A3C2F3566F974734B55ECECD31C6CA91 https://community.esri.com/t5/arcgis-survey123-blog/use-existing-data-in-your-survey-the-pulldata-function/ba-p/896889 I have attached the modified sample form that is working on my end.  As for the original survey that was attached to the case there was only 1 CSV file attached to the case, although it looks like the survey uses more. In the CSV file there are two columns with the same name "name", columns B and R. Once I had updated the column name for column R to Full_Name then the CSV file started working as expected.  As for the issue with the JavaScript function I did not see a JS file attached to the case, but please feel free to reach out to me directly [email protected] and I'll be happy to look into it.  We are currently working on documenting best practices when using CSV's for external choices and pulldata() functions.  Thank you,  Zach ... View more

Hello @KPyne,  Thank you for passing along the CSV file. In looking at the CSV file columns BC and BL have the same column header (p_elbows_0_75in_B) which is causing a namespace error when trying to import the table in the SQLite database.  As both columns looked the same I had removed column BL and it worked as expected. If there's data in column BL that is different renaming the column will also work.  Thank you,  Zach ... View more

Hello @ChrisMaclaurin,  Thank you for passing along the survey! I have tested on my end and I have not been able to reproduce the same behavior. I've tested on an iPhone 8+ running IOS 14.4.2 and an iPhone 12 mini running IOS 14.4.1 and I was not able to repro on either device.  I tested placing the device on airplane mode disabling the cellular and WiFi connections and the behavior did not occur.  On your device are you using a VPN to connect to an internal network? Are you using ArcGIS Online or ArcGIS Enterprise, and do you have Enterprise log in's configured with your Organization? Thank you,  Zach  ... View more

Hello @TonyDaSilva1,  Are you trying to publish to ArcGIS Online or an ArcGIS Enterprise Organization?  Thank you,  Zach ... View more