Latest Contributions by KatieGodding

‎09-20-2021

I used Integromat initially and I was able to create the flow that sends an email when a survey is submitted. My question is if there is a way to add a count to the email of how many total submissions there have been. I want the email recipient to be able to see how many total submissions there have been.

‎09-17-2021

Hello, I'm working with webhooks for survey123. I want to send an email when a survey is submitted. I want to include in the email the total number of survey submissions that have been made. Is there a way to do this?

‎06-28-2021

Is there a way to tell who (i.e. IP address) submitted a survey? For context, my org created a survey and there is some skepticism that multiple survey submissions were made by one person. Also, I know there's a setting to only allow one survey submission per person, but for reasons it was not used this time. Thanks!

‎04-19-2021

To follow up: Copying the data to a file geodatabase locally resolved the issue. I'm working from home over VPN and the data is hosted on my organizations servers. Have had some thoughts that it is VPN and the way Arc may be connecting to the sde data that could be throwing this error?

‎04-14-2021

So I removed the connection to our editable sde data and that seemed to resolve the issue. Any insight on why that may have been causing an issue? For context, at my organization we have multiple sde database connections. There's a 'read' one where you can only read the data and there's an 'edit' one where you can edit the data.

‎04-09-2021

import arcpy, os from arcpy import env env.workspace = r'C:\Users\goddik\Working\Summary_LMC\Workspace' #create variables for output excel files Proposed_LMCs = os.path.join(outputFolder,"Proposed_LMCs.xls") Proposed_LMCs_DML = os.path.join(outputFolder,"Proposed_LMCs_DML.xls") Existing_LMCs = os.path.join(outputFolder,"Existing_LMCs.xls") Existing_LMCs_DML = os.path.join(outputFolder,"Existing_LMCs_DML.xls") env.overwriteOutput = True # choose sde instance sde_instance = input('PROD, DEV, LOCAL? ' #connect to sde (production) if sde_instance == 'PROD': sde_edit = r'\\central\RESPLAN\GIS\Database_Connections\LF_GIS_EDIT\Production\oracle11g - dnr_sde - LF_GIS_EDIT - LFEdit15.sde' sde_read = r'\\central\RESPLAN\GIS\Database_Connections\LF_GIS_READ\Production\oracle11g - dnr_sde - LF_GIS_READ - LFCarto15.sde' #connect to sde (development) if sde_instance == 'DEV': sde_edit = r'\\central\RESPLAN\GIS\Database_Connections\LF_GIS_EDIT\Development\oracle11g - dnr_geotest - LF_GIS_EDIT - LFGIS123.sde' sde_read = r'\\central\RESPLAN\GIS\Database_Connections\LF_GIS_READ\Development\oracle11g - dnr_geotest - LF_GIS_READ - Lands2015.sde' #local copies of SDE connections for testing if sde_instance == 'LOCAL': sde_edit = r'C:\Users\goddik\Working\Summary_LMC\Development-EDIT\oracle11g_dnr_geotest_LF_GIS_EDIT_LFGIS123.sde' sde_read = r'C:\Users\goddik\Working\Summary_LMC\Development-READ\oracle11g_dnr_geotest_LF_GIS_READ_Lands2015.sde' #connect to LMC, EL, DML feature classes LMC_edit = os.path.join(sde_edit, 'X52915.LF_MP_NR44_LANDMGT_AR_VAR') # LMC edit (this has features w/o CROSSREF_SEQ_NOs not found in READ) ELs = os.path.join(sde_read, 'SDEDNR.EN_ECO_LANDSCAPE_REGN_AR_250K') DML = os.path.join(sde_read, 'X52911.LF_DNR_PROPNAME_INT_24K_SV') # make CSP EL layer arcpy.MakeFeatureLayer_management(ELs, "CSP_EL", "ECO_LANDSCAPE_NAME = 'Central Sand Plains'") # create proposed lMC layer arcpy.MakeFeatureLayer_management(LMC_edit, "LMC_proposed", "MASTER_PLAN_SEQ_NO = 6007") # create existing LMC layer arcpy.MakeFeatureLayer_management(LMC_edit, "LMC_existing", "MASTER_PLAN_SEQ_NO <> 6007") arcpy.SelectLayerByLocation_management("LMC_existing", "", "CSP_EL")

‎04-09-2021

I've had coworkers with ArcGIS Pro 2.6 try and they still get the same error on SelectLayerByLocation.

‎04-06-2021

If I copy the whole script and run it in the python window, it will fail at the SelectLayerByLocation line of code. Immediately after failing, however, if I manually copy, paste, and execute that one line of code in the python window, the SelectLayerByLocation function will work. I'm not sure why it wouldn't work at first when the whole script is run and then would immediately work when executed separately.

‎04-05-2021

I wrote a script, and when I run it, it fails at the same spot for me and my colleagues every time. Here is a screen shot of the error: The script is working with features located in a SDE environment, and given the part of the error "Underlying DBMS error [ORA-25402: transaction must roll back]" I'm thinking it has something to do with trying to access that database? Additionally, if I copy the line of code that includes the SelectLayerByLocation function and enter that into the python window manually, it works fine. I can run the rest of the script, and there are no issues. It's only when the script is run from the beginning that it fails. ArcGIS Pro 2.4.1 is being used. I'm wondering if anyone has any experience or insight with this function and errors with working with data in an SDE. I attached images of the script itself.

‎03-01-2021

Hello, Is there any way to alter a survey123 link so that the shared link is more informative/appealing? For example, this is how the link appears when shared on facebook: Is there a way to get this to be more descriptive of the actual survey and not just show this more generic information? Ideally it would show the survey thumbnail and have the title of the survey instead of the 'Account Login - ArcGIS Survey123'. Thanks,

‎10-07-2020

Thanks Jim! This worked great!

‎10-06-2020

Is there a way to compare two inputs in Survey123? For example they would input their email and then would input it again to confirm and the survey would only allow it if they were identical?

‎04-27-2020

I'm experiencing issues sharing my Survey123 surveys. In 'Collaborate' on survey123.arcgis.com I don't have the ability to access the 'Draft mode', 'Multiple submissions', 'Survey status'. And when I try and set 'Who can submit to this survey?' to 'Everyone (Public)' I hit save and it doesn't seem to save this command. I'm unsure what's going on. Anyone experience this issue as well or have any thoughts on how to make this function as expected?

‎12-03-2019

I'm trying to set the Survey status to "Closed: not accepting responses" so the message in the box shows up when people try and access the survey. I hit save and it says it saves successfully, but when I go to view the survey via it's link, I can still view it and submit a response, even when signed out of ArcGIS Online. Why won't my survey close?

‎11-20-2019

The length of the field in the feature service is 10000:

Online Status	Offline
Date Last Visited	‎12-06-2021 02:44 PM

My Ideas

Latest Contributions by KatieGodding

Re: Survey123 create/send email webhook

Survey123 create/send email webhook

Identifying Survey Submittors

Re: ERROR 999999 underlying DBMS error Failed to execute SelectLayerByLocation

Re: ERROR 999999 underlying DBMS error Failed to execute SelectLayerByLocation

Re: ERROR 999999 underlying DBMS error Failed to execute SelectLayerByLocation

Re: ERROR 999999 underlying DBMS error Failed to execute SelectLayerByLocation

Re: ERROR 999999 underlying DBMS error Failed to execute SelectLayerByLocation

ERROR 999999 underlying DBMS error Failed to execute SelectLayerByLocation

Edit Survey123 Link to look more attractive when shared

Re: Survey123 confirm email

Survey123 confirm email

Collaborate issues in Survey123

Why won't my Survey123 close when I set it to Closed and save at survey.arcgis.com?

Re: How to troubleshoot Survey123 error: "Failed to submit. String or binary data would be truncated. The statement has been terminated."

Can I embed an image within a note in Survey123?

Re: How to troubleshoot Survey123 error: "Failed t...

Collaborate issues in Survey123

Re: Survey123 confirm email

Why won't my Survey123 close when I set it to Clos...