nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

aprx.updateConnectionProperties() no hace nada.

AnibalMmartinez

El siguiente ejemplo que esta en la ayuda, no funciona para nada no pincha , no cambia nada.

import arcpy

aprx = arcpy.mp.ArcGISProject(r'C:\Projects\YosemiteNP\Yosemite.aprx')

aprx.updateConnectionProperties(None, r'C:\Projects\YosemiteNP\DBConnections\Server.sde')

aprx.saveACopy(r"C:\Projects\YosemiteNP\YosemiteNew.aprx")

¿Alguna idea?, tengo un monton de APRX, que apuntan a la GEODATABASE de desarrollo, y debo cambiar la conexion para pasar a TESTING o PRODUCCION.

Anibal Martinez

Find more posts tagged with

Accepted answers

AnibalMmartinez

Funciona, hasta el primer ejemplo

import arcpy
aprx = arcpy.mp.ArcGISProject(r'D:\Repo\VRed\main\project\Scripts\Publicar\MiniTest.aprx')
result=aprx.updateConnectionProperties(r'D:\Repo\VRed\main\project\Conexiones\SDE@MUGISD.sde', r'D:\Repo\VRed\main\project\Conexiones\SDE@MUGIST.sde',False,False,True)
print(result)
aprx.saveACopy(r"D:\Repo\VRed\main\project\Scripts\Publicar\MiniTestNew.aprx")

Cambia perfecto la conexion en el APRX, sin esos 3 parametros no funciona. No me puse a ver cual de los 3 es el responsable.

Gracias @TonyAlmeida , gracias @DanPatterson , por la ayuda, y espero les sirva a muchos, porque veo que hay mucha gente buscando solución a este tema.

All comments

AnibalMmartinez

Hola Tony, mil gracias por el aporte, hice un pequeño cambio para que no pinche, y mas abajo la salida, ¿se te ocurre que puede estar pasando?

import arcpy
import os

# Set your paths
project_path = r"D:\Repo\VRed\main\project\Scripts\Publicar\MiniTest.aprx" # Or full path to your APRX file
project_path_new=r"D:\Repo\VRed\main\project\Scripts\Publicar\MiniTestNew.aprx"
old_gdb = r"D:\Repo\VRed\main\project\Conexiones\SDE@MUGISD.sde"
new_gdb = r"D:\Repo\VRed\main\project\Conexiones\SDE@GISTECOD.sde"

# Open the ArcGIS project
aprx = arcpy.mp.ArcGISProject(project_path)
nroLys=0

# Iterate through each map in the project
for m in aprx.listMaps():
for l in m.listLayers():
nroLys=nroLys+1
print("layers nro=" + str(nroLys))
if l.supports("CONNECTIONPROPERTIES"):
try:
# Get the current connection properties
conProp = l.connectionProperties
print("conProp=" + str(conProp))
#comente la linea siguiente porque daba "Error with layer SDE.VIS_FC_EQ_HFC_LINEQ_V: 'database'"
#print(f"Layer: {l.name}, Current Database: {conProp['connection_info']['database']}")

# Check if the layer is connected to the old geodatabase
if conProp and 'connection_info' in conProp:
current_database = conProp['connection_info'].get('database', '')
if current_database.lower() == old_gdb.lower():
print(f"Updating connection for layer: {l.name}")

# Update the database path to the new geodatabase
conProp['connection_info']['database'] = new_gdb

# Apply the updated connection properties
l.updateConnectionProperties(l.connectionProperties, conProp)
else:
print(f"Layer {l.name} is not using the old GDB. Skipping...")
except Exception as e:
print(f"Error with layer {l.name}: {str(e)}")

# Save the updated project
aprx.saveACopy(project_path_new)
print("Update complete.")

SALIDA:

C:\Users\u194934>"C:\Program Files\ArcGIS\Pro\bin\Python\Scripts\propy.bat" \Repo\VRed\main\project\Scripts\Publicar\CS2.py
layers nro=1
conProp={'dataset': 'SDE.VIS_FC_EQ_HFC_LINEQ_V', 'workspace_factory': 'SDE', 'connection_info': {'authentication_mode': 'DBMS', 'dbclient': 'oracle', 'db_connection_properties': '192.168.244.71:1529/MUGISD', 'password': '<*********>', 'instance': 'sde:oracle$192.168.244.71:1529/MUGISD', 'server': '192.168.244.71', 'user': 'SDE', 'version': 'SDE.DEFAULT'}}
Layer SDE.VIS_FC_EQ_HFC_LINEQ_V is not using the old GDB. Skipping...
Update complete.

Tonyalmeida

I tested the code I posted and it does work. Here is redefined code that will print out layers current connections to help.

import arcpy
import os

# Set your paths
project_path = "CURRENT"  # Or full path to your APRX file
old_gdb = r"C:\Temp\BuildingPermit.gdb"
new_gdb = r"C:\Temp\BPTest.gdb"

# Open the ArcGIS project
aprx = arcpy.mp.ArcGISProject(project_path)

# Iterate through each map in the project
for m in aprx.listMaps():
    for l in m.listLayers():
        if l.supports("CONNECTIONPROPERTIES"):
            try:
                # Get the current connection properties
                conProp = l.connectionProperties
                print(f"Layer: {l.name}, Current Database: {conProp['connection_info']['database']}")

                # Check if the layer is connected to the old geodatabase
                if conProp and 'connection_info' in conProp:
                    current_database = conProp['connection_info'].get('database', '')
                    if current_database.lower() == old_gdb.lower():
                        print(f"Updating connection for layer: {l.name}")
                        
                        # Update the database path to the new geodatabase
                        conProp['connection_info']['database'] = new_gdb
                        
                        # Apply the updated connection properties
                        l.updateConnectionProperties(l.connectionProperties, conProp)
                    else:
                        print(f"Layer {l.name} is not using the old GDB. Skipping...")
            except Exception as e:
                print(f"Error with layer {l.name}: {str(e)}")

# Save the updated project
aprx.saveACopy(r"C:\Temp\Project_Updated.aprx")
print("Update complete.")

AnibalMmartinez

Gracias Dan, las conexiones también creadas por script pyhton y por las dudas utilizadas con ArcGIS Pro, para verificar. La versión actual de ArcGIS Pro es 3.1.6 y ArcGIS Server 11.1.

Es muy frustrante, en 10.9.1 los sctipts funcionaban, luego de migrar y adaptarlos, nada.

He levantado un ticket al distribuidor local, ojala ellos encuentren algo.

Saludos,

Anibal

danretired

From your example, which is also in the help files, there is this line....

If no matches are found when you replace the current_connection_info parameter with the new_connection_info parameter in the updateConnectionProperties function, your script may complete, but nothing will be updated.

Updating and fixing data sources—ArcGIS Pro | Documentation

Perhaps you need to check with your data sources to see if they exist since it suggests that it won't update anything, and, there is no mention of it throwing an error message either.

AnibalMmartinez

import arcpy

aprx = arcpy.mp.ArcGISProject(r'C:\Projects\YosemiteNP\Yosemite.aprx')

aprx.updateConnectionProperties(r'C:\Projects\YosemiteNP\DBConnections\Server.sde', r'C:\Projects\YosemiteNP\DBConnections\NewServer.sde')

aprx.saveACopy(r"C:\Projects\YosemiteNP\YosemiteNew.aprx")

Tony, Hice la prueba, y No hace nada.

Tonyalmeida

Intenta agregar ambas conexiones al SDE, la antigua y la nueva.

import arcpy

aprx = arcpy.mp.ArcGISProject(r"C:\Temp\Project.aprx")

old_conn = r"xyz\xyz\DEV.sde"
new_conn = r"xyz\xyz\PROD.sde"

# Conexiones al SDE, la antigua y la nueva
aprx.updateConnectionProperties(old_conn, new_conn)

aprx.saveACopy(r"C:\Temp\Project.aprx")

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.