topic Re: How to export UN schema model to Excel in ArcGIS Utility Network Questions

How to export UN schema model to Excel

DasheEbra — Mon, 26 Dec 2022 09:33:23 GMT

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?

Re: How to export UN schema model to Excel

MichaelHirschheimer — Tue, 27 Dec 2022 14:11:47 GMT

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.

Re: How to export UN schema model to Excel

DasheEbra — Wed, 28 Dec 2022 11:07:27 GMT

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

Re: How to export UN schema model to Excel

DasheEbra — Wed, 28 Dec 2022 11:26:05 GMT

>------ 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

Re: How to export UN schema model to Excel

DasheEbra — Wed, 28 Dec 2022 11:49:57 GMT

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.