How to export UN schema model to Excel

[DasheEbra]

dears as we know that Utility Network schema has a lot of features, asset group, asset domains, categories, etc. Is there a way to export all or a specific part of the schema to excel?

[MichaelHirschheimer · Accepted solution]

Hi @DasheEbra 

Look at the blog for the Utility Network properties extractor 

The source code for this Pro 2.9 SDK Add-in is available on Esri GitHub and it extracts Utility Network properties to CSV files.

[DasheEbra]

Thanks a lot @MichaelHirschheimer it looks very useful add-in, but I cannot comply it on VS. I am not expert in developing or working with VS, so I just downloaded VS 2017 Enterprise then I open the UN add-in with VS and click on UtilityNetworkPropertiesExtractor.sln and click on Build. But I got the following error:

>------ Build started: Project: UtilityNetworkPropertiesExtractor, Configuration: Debug|Any CPU ------
C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(1179,5): error MSB3644: The reference assemblies for framework ".NETFramework,Version=v4.8" were not found. To resolve this, install the SDK or Targeting Pack for this framework version or retarget your application to a version of the framework for which you have the SDK or Targeting Pack installed. Note that assemblies will be resolved from the Global Assembly Cache (GAC) and will be used in place of reference assemblies. Therefore your assembly may not be correctly targeted for the framework you intend.

Build failed.

---

---

My environment as follow:
ArcGIS Pro 2.9.2
Enterprise 10.9.1
Enterprise UN Gdb (PostgreSQL)
Windows 10 Pro
.Net Framework 4.8.09037

[DasheEbra]

Thanks a lot @MichaelHirschheimer it looks very useful add-in, but I cannot comply it on VS. I am not expert in developing or working with VS, so I just downloaded VS 2017 Enterprise then I open the UN add-in with VS and click on UtilityNetworkPropertiesExtractor.sln and click on Build. But I got the following error:

>------ Build started: Project: UtilityNetworkPropertiesExtractor, Configuration: Debug|Any CPU ------
C:\Program Files (x86)\Microsoft Visual Studio\2017\Enterprise\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(1179,5): error MSB3644: The reference assemblies for framework ".NETFramework,Version=v4.8" were not found. To resolve this, install the SDK or Targeting Pack for this framework version or retarget your application to a version of the framework for which you have the SDK or Targeting Pack installed. Note that assemblies will be resolved from the Global Assembly Cache (GAC) and will be used in place of reference assemblies. Therefore your assembly may not be correctly targeted for the framework you intend.

Build failed.

My environment as follow:
ArcGIS Pro 2.9.2
Enterprise 10.9.1
Enterprise UN Gdb (PostgreSQL)
Windows 10 Pro
.Net Framework 4.8.09037

[DasheEbra]

Thanks @MichaelHirschheimer, I had some issue for deploying this Add-In. But it solved after changed the Target framework inside VS from 4.6 to 4.8.1.