topic Updating connectionproperties - different schema in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/updating-connectionproperties-different-schema/m-p/322683#M14070 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>I'm using a ArcGIS Pro-document which contains about 25 layers as a template for several customers (different customers, same map-structure). I usually take a copy of the template and manually change the datasource for each layer, so it corresponds to the users database and featureclass. I'm trying to do this automatically to save some time.&nbsp; The customers databases contains the same featureclasses, and the only difference is user and database-name. I've tried using the updateConnectionProperties-function in arcpy, but it doesn't work. The code runs without any errors, but none of the datasources changes. I guess it's because the dataset-name changes depending on the customer, like this:</P><P></P><P>Customer 1 - Dataset: Muncipality0305.DBO.WaterPipe&nbsp;</P><P>Customer 2 - Dataset: Muncipality1206.DBO.WaterPipe</P><P></P><P>MuncipalityXXXX is defined by the databasename.</P><P></P><P>Does anyone have any suggestions to how I can do this?</P><P></P><P>Regards, Torbjørn</P></BODY></HTML> Fri, 26 Oct 2018 13:47:20 GMT TorbjørnDalløkken2 2018-10-26T13:47:20Z Updating connectionproperties - different schema https://community.esri.com/t5/arcgis-pro-questions/updating-connectionproperties-different-schema/m-p/322683#M14070 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>I'm using a ArcGIS Pro-document which contains about 25 layers as a template for several customers (different customers, same map-structure). I usually take a copy of the template and manually change the datasource for each layer, so it corresponds to the users database and featureclass. I'm trying to do this automatically to save some time.&nbsp; The customers databases contains the same featureclasses, and the only difference is user and database-name. I've tried using the updateConnectionProperties-function in arcpy, but it doesn't work. The code runs without any errors, but none of the datasources changes. I guess it's because the dataset-name changes depending on the customer, like this:</P><P></P><P>Customer 1 - Dataset: Muncipality0305.DBO.WaterPipe&nbsp;</P><P>Customer 2 - Dataset: Muncipality1206.DBO.WaterPipe</P><P></P><P>MuncipalityXXXX is defined by the databasename.</P><P></P><P>Does anyone have any suggestions to how I can do this?</P><P></P><P>Regards, Torbjørn</P></BODY></HTML> Fri, 26 Oct 2018 13:47:20 GMT https://community.esri.com/t5/arcgis-pro-questions/updating-connectionproperties-different-schema/m-p/322683#M14070 TorbjørnDalløkken2 2018-10-26T13:47:20Z