Select to view content in your preferred language

How to export UN schema model to Excel

995
4
Jump to solution
12-26-2022 01:33 AM
DasheEbra
Frequent Contributor

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?

0 Kudos
1 Solution

Accepted Solutions
MichaelHirschheimer
Esri Contributor

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.

View solution in original post

4 Replies
MichaelHirschheimer
Esri Contributor

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

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

 

0 Kudos
DasheEbra
Frequent Contributor

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

0 Kudos
DasheEbra
Frequent Contributor

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.

0 Kudos