Latest Contributions by JordanMiller4

I've searched the forums but I can't find any python examples to change field order for layers in the ArcGIS Desktop 10.6 Table of Contents. Is there another way to automate this process? ... View more

We created a form in survey123 and we'd like to use that form on our IPhones. In relation to the form, we'd like to link it to a feature service where data from certain fields are sent to the object. Would it be possible for Survey123 to create an object on the map and reference only certain fields back to the object? Most of the fields on the form will not have an associated field to the feature service but we'd still like to capture the information. ... View more

I am trying to use the Try Except statement and I was wondering if I set it up correctly because I get an error when I run the script. I'm not sure if the error is due to the try Except or bad scripting on my part. The script checks for a connection to NEO_1. If the connection exists then it checks all the versions name. This is where I seem to get an error. Since the user already exists the break should stop the script before prompting an error? Empty Workspace Cache Done Connections Exists: NEO_1 Searching for User Credentials.. Windows Credentials: EGAS\jnmiller Checking SDE for existing Credentials.. Executing: CreateVersion "Database Connections\NEO_1.sde" sde.DEFAULT jnmiller PROTECTED Start Time: Wed Feb 21 11:38:41 2018 ERROR 001148: Cannot create a version with the specified name. Version already exists [jnmiller][STATE_ID = 99689] Failed to execute (CreateVersion). Failed at Wed Feb 21 11:38:42 2018 (Elapsed Time: 0.72 seconds)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ # Name: SDE_CreateVersion # Description: Creates a new SDE version import arcpy, time, smtplib, os from arcpy import env arcpy.env.overwriteOutput = True arcpy.env.workspace = "Database Connections/NEO_1.sde"  connection = arcpy.env.workspace # Set local variables sdeConnection = "Database Connections\NEO_1.sde" parentVersion = "sde.DEFAULT" versionName = os.environ.get( "USERNAME" ) fullPath = os.path.join("Windows Credentials: EGAS", versionName) userVersion = os.path.join("Version Currently Exists: ",versionName) createVersion = os.path.join("Version Created: ",versionName) # Clear Workspace Cache print("Empty Workspace Cache") arcpy.ClearWorkspaceCache_management()  print("Done") # Database Connection: NEO_1 = True   if arcpy.Exists(connection):       versionFound = False     try:         for version in arcpy.da.ListVersions(sdeConnection):             if version.name.split(".")[0] == versionName:                 print(userVersion)                 versionFound = True                 break         # Execute CreateVersion         if not versionFound:             arcpy.CreateVersion_management(sdeConnection, parentVersion, versionName, "PROTECTED")             print(createVersion)     except arcpy.ExecuteError:         print(arcpy.GetMessages()) # Database Connection: NEO_1 = False        if not arcpy.Exists(connection):     print("Creating Database Connection: NEO_1")     arcpy.CreateDatabaseConnection_management(out_folder_path="Database Connections",                                               out_name="NEO_1.sde",                                               database_platform="SQL_SERVER",                                               instance="lan-svr-sql",                                               account_authentication="OPERATING_SYSTEM_AUTH",                                               database="NEO_1",                                               version_type="TRANSACTIONAL",                                               version="sde.DEFAULT")     arcpy.env.workspace = r"Database Connections\NEO_1.sde"     if arcpy.Exists(connection):         versionFound = False         try:             for version in arcpy.da.ListVersions(sdeConnection):                 if version.name.split(".")[0] == versionName:                     print(existingVersion)                     versionFound = True                     break                 #Execute CreateVersion                 if not versionFound:                     arcpy.CreateVersion_management(sdeConnection, parentVersion, versionName, "PROTECTED")                     print(createVersion)                             except arcpy.ExecuteError:             print(arcpy.GetMessages()) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I don't understand how fields w/ Date data types could possibly generate a time.. " ,7:00" time at the end. See the img below. We're using the Portal dashboard. How do I prevent a time from showing? ... View more

I am trying to figure out the best way to create web maps with editing capabilities for our operators out in the field. Similar to a QA/QC type of situation. From what I've read and tried the only way to allow our operators editing access is by creating a version called [Operators] and publishing it with full editing capabilities. Please correct me if there is a better way to do it. And the other thing is the reconcile / post maintenance script we have. The script does a full compression every 2 weeks. Essentially it's deleting all the versions. If it's deleting the version [Operator] does that mean the web map will not work? Does anyone happen to know a workflow that will be useful? Software: ArcGIS Enterprise 10.6 Portal 10.6 ArcMap 10.5   import arcpy, time, smtplib, os deleteVersions = True arcpy.env.overwriteOutput = True reconcileLog = r'C:\temp\Weekly_Reconcile_Log\Reconcile_Log.txt' # set the workspace arcpy.env.workspace = 'C:\Users\jnmiller\AppData\Roaming\ESRI\Desktop10.5\ArcCatalog\SDE.sde' # Set a variable for the workspace adminConn = arcpy.env.workspace # Block new connections to the database. print("The database is no longer accepting connections") arcpy.AcceptConnections(adminConn, False) # Wait 15 minutes #time.sleep(900) # Disconnect all users from the database. print("Disconnecting all users") arcpy.DisconnectUser(adminConn, "ALL") # Get a list of versions to pass into the ReconcileVersions tool. print("Getting list of all versions") versionList = arcpy.ListVersions(adminConn) for version in versionList:     if 'default' in version.lower():         if 'dbo' in version.lower():             defaultVersion = 'dbo.DEFAULT'         elif 'sde' in version.lower():             defaultVersion = 'sde.DEFAULT' # Execute the ReconcileVersions tool. print("Reconciling/posting/deleting all versions") if deleteVersions:     try:         arcpy.ReconcileVersions_management(adminConn, "ALL_VERSIONS", defaultVersion, versionList, "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_EDIT_VERSION", "POST", "DELETE_VERSION", reconcileLog)     except:         reconcileMessage = "Reconcile failed:  " + arcpy.GetMessages() + ".  Check reconcilelog.txt file in the " + str(reconcileLog)         arcpy.AddWarning(reconcileMessage)         pass else:     try:         arcpy.ReconcileVersions_management(adminConn, "ALL_VERSIONS", defaultVersion, versionList, "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_EDIT_VERSION", "POST", "KEEP_VERSION", reconcileLog)     except:         reconcileMessage = "Reconcile failed:  " + arcpy.GetMessages() + ".  Check reconcilelog.txt file in the " + str(reconcileLog)         arcpy.AddWarning(reconcileMessage)         pass print("Completed Reconcile & Post") # Run the compress tool. print("Running compress") arcpy.Compress_management(adminConn) print("Compress Completed") # Allow the database to begin accepting connections again print("Allow users to connect to the database again") arcpy.AcceptConnections(adminConn, True) print("Starting Rebuild Indexes") # Get a list of all the datasets the user has access to. # First, get all the stand alone tables, feature classes and rasters. dataList = arcpy.ListTables() + arcpy.ListFeatureClasses() + arcpy.ListRasters() # Next, for feature datasets get all of the datasets and featureclasses # from the list and add them to the master list. for dataset in arcpy.ListDatasets("", "Feature"):     arcpy.env.workspace = os.path.join(adminConn,dataset)     dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets() # Get the user name for the workspace userName = arcpy.Describe(adminConn).connectionProperties.user.lower() # remove any datasets that are not owned by the connected user. userDataList = [ds for ds in dataList if ds.lower().find(".%s." % userName) > -1] # Execute rebuild indexes # Note: to use the "SYSTEM" option the workspace user must be an administrator. arcpy.RebuildIndexes_management(adminConn, "SYSTEM", userDataList, "ALL") print('Rebuild Complete') # Update statistics on the system tables print("Updating statistics on the system tables") # Execute analyze datasets # Note: to use the "SYSTEM" option the workspace user must be an administrator. arcpy.AnalyzeDatasets_management(adminConn, "SYSTEM", userDataList, "ANALYZE_BASE","ANALYZE_DELTA","ANALYZE_ARCHIVE") print("Analyze Complete") print("Finished.") ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

We have a Reconcile/Post routine that runs once a week on our enterprise geodatabase. When the script runs and finishes the editing performance is painful. The features load very quickly outside of editing but when we begin editing the performance drop 200%.  import arcpy, time, smtplib, os deleteVersions = True reconcileLog = r'C:\temp\Reconcile_Log.txt' # set the workspace arcpy.env.workspace = 'Database Connections/SDE.sde' # Set a variable for the workspace adminConn = arcpy.env.workspace # Block new connections to the database. print("The database is no longer accepting connections") arcpy.AcceptConnections(adminConn, False) # Wait 15 minutes #time.sleep(900) # Disconnect all users from the database. print("Disconnecting all users") arcpy.DisconnectUser(adminConn, "ALL") # Get a list of versions to pass into the ReconcileVersions tool. print("Getting list of all versions") versionList = arcpy.ListVersions(adminConn) for version in versionList:     if 'default' in version.lower():         if 'dbo' in version.lower():             defaultVersion = 'dbo.DEFAULT'         elif 'sde' in version.lower():             defaultVersion = 'sde.DEFAULT' # Execute the ReconcileVersions tool. print("Reconciling/posting/deleting all versions") if deleteVersions:     try:         arcpy.ReconcileVersions_management(adminConn, "ALL_VERSIONS", defaultVersion, versionList, "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_EDIT_VERSION", "POST", "DELETE_VERSION", reconcileLog)     except:         reconcileMessage = "Reconcile failed:  " + arcpy.GetMessages() + ".  Check reconcilelog.txt file in the " + str(reconcileLog)         arcpy.AddWarning(reconcileMessage)         pass else:     try:         arcpy.ReconcileVersions_management(adminConn, "ALL_VERSIONS", defaultVersion, versionList, "LOCK_ACQUIRED", "NO_ABORT", "BY_OBJECT", "FAVOR_EDIT_VERSION", "POST", "KEEP_VERSION", reconcileLog)     except:         reconcileMessage = "Reconcile failed:  " + arcpy.GetMessages() + ".  Check reconcilelog.txt file in the " + str(reconcileLog)         arcpy.AddWarning(reconcileMessage)         pass print("Completed Reconcile & Post") # Run the compress tool. print("Running compress") arcpy.Compress_management(adminConn) print("Compress Completed") # Allow the database to begin accepting connections again print("Allow users to connect to the database again") arcpy.AcceptConnections(adminConn, True) print("Starting Rebuild Indexes") # Get a list of all the datasets the user has access to. # First, get all the stand alone tables, feature classes and rasters. dataList = arcpy.ListTables() + arcpy.ListFeatureClasses() + arcpy.ListRasters() # Next, for feature datasets get all of the datasets and featureclasses # from the list and add them to the master list. for dataset in arcpy.ListDatasets("", "Feature"):     arcpy.env.workspace = os.path.join(adminConn,dataset)     dataList += arcpy.ListFeatureClasses() + arcpy.ListDatasets() # Get the user name for the workspace userName = arcpy.Describe(adminConn).connectionProperties.user.lower() # remove any datasets that are not owned by the connected user. userDataList = [ds for ds in dataList if ds.lower().find(".%s." % userName) > -1] # Execute rebuild indexes # Note: to use the "SYSTEM" option the workspace user must be an administrator. arcpy.RebuildIndexes_management(adminConn, "SYSTEM", userDataList, "ALL") print('Rebuild Complete') # Update statistics on the system tables print("Updating statistics on the system tables") # Execute analyze datasets # Note: to use the "SYSTEM" option the workspace user must be an administrator. arcpy.AnalyzeDatasets_management(adminConn, "SYSTEM", userDataList, "ANALYZE_BASE","ANALYZE_DELTA","ANALYZE_ARCHIVE") print("Analyze Complete") print("Finished.") ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Mapping Software: Version 10.6 ArcGIS Server Portal for ArcGIS Two ArcGIS Web Adaptors SQL Server 2012 Operating System Windows Server 2012 R2 ... View more