Latest Contributions by PaulLeBlanc1

You would just run the tool in the lowest version of Pro that you want to support (presumably 3.1.x).

https://doc.arcgis.com/en/arcgis-solutions/latest/tool-reference/utility-network-package/upgrade-asset-package.htm This will add any missing fields to the asset package tables (A, B, C, etc).

‎07-01-2024

If you disable parallel processing in environment variables, does it still give the same error?

‎06-27-2024

The issue is with the requests library. conda updated this package during the installation of untools (despite untools not even using it). You need requests >=2.30.0,<2.32.0 I was able to reproduce this and confirmed that downgrading to requests 2.31.0 resolved it.

‎06-11-2024

Open a python command prompt and run the following, which will install the next release of untools 3.3.x conda install solutionsdev/label/pro3.3::untools

‎06-07-2024

This issue requires all 4 of these very specific settings: A configuration table that is removing all relationship classes. Database sequences. An attribute rule referencing a standalone table. Applying the asset package schema only. I'll get this fixed in the next patch releases of untools 3.1/3.3. I can provide a release candidate with this fix -- which version of Pro would you prefer?

‎06-06-2024

@IvanDImitrovI am not aware of any issues in this area. This is valid arcade. FeatureSetByName($datastore, 'LineTypeLib', ['*'], false) If there isn't a table called LineTypeLib then the runtime error is expected.

‎05-14-2024

If you want to apply an asset package to a v6 UN, you must be using ArcGIS Pro 3.0 - 3.2 (ideally Pro 3.1).

‎05-13-2024

untools 3.1.1.1 is uploaded here and can be used like so. This is a RC build, so caveat emptor, not supported, etc. Please reach out to pleblanc at esri dot com (or direct message me here) with any issues/questions. import untools import arcpy # Override precision and scale for all float fields. untools.common.settings.SINGLE_PRECISION_SCALE = (6, 1) untools.common.settings.DOUBLE_PRECISION_SCALE = None # The default. arcpy.pt.AssetPackageToUtilityNetwork(...) To install, open a python command prompt and run conda install solutionsdev/label/pro3.1::untools

‎05-10-2024

It wouldn't be a default; you would have to opt in because we don't want to break backwards compatibility. It's been this way for 6 (!) years and you are the first I'm aware of that is raising this. 😄 Still ironing it out, but it would be something like this. If you left off that line, or set it = None, it would be the current behavior. import untools import arcpy # Override precision and scale for all float fields. untools.common.settings.SINGLE_PRECISION_SCALE = (6, 1) arcpy.pt.AssetPackageToUtilityNetwork(...) Yes, we would likely do this on Pro 3.1/3.3 only because those are Network Management Release versions.

‎05-10-2024

Few questions: Do you want all your floats in all tables to have the same scale/precision? Do you want all your doubles in all tables to have the same scale/precision? If yes, then supporting this would be quite straightforward and you could have a RC version of untools by Monday morning that would solve this. I've been toying around with this approach and it works nicely. If no, and you want certain fields to be numeric(x,y) and others to be numeric(a,b) then it would take longer (due to priorities and such) but would provide a nice level of granularity.

‎05-10-2024

The code above was to show that despite telling the system to create a FLOAT, it created a DOUBLE (implicit upcast). There is a very specific edge case where apply AP does explicitly upcast a FLOAT to a DOUBLE (i.e., it creates the field as a DOUBLE to begin with). You get a runtime warning informing you about this. If you create a FLOAT field and don't specific scale/precision, then you get a DOUBLE. Tested with the same software as above, so you'll see this behavior even after you upgrade your client. Edit: Apply AP has been creating FLOAT fields with the following payload since ~Pro 2.1. Scale/Precision are both 0 because that is how they are stored in FGDB. <AddField> <field_name>f_05_03</field_name> <field_type>FLOAT</field_type> <field_precision>0</field_precision> <field_scale>0</field_scale> <field_length>4</field_length> <field_alias>f_05_03</field_alias> <field_is_nullable>True</field_is_nullable> <field_is_required>False</field_is_required> </AddField>

‎05-10-2024

I'm testing with Pro 3.3 and SQL Server 16.0.4120.1 (what I have handy). import arcpy fields = [] for p in range(1, 10): for s in range(1, p): fields.append( dict( field_name=f"f_{p:02}_{s:02}", field_type="FLOAT", field_alias=f"Precision: {p}, Scale: {s}", field_precision=p, field_scale=s, ) ) for f in fields: arcpy.AddField_management( r'<my table>', **f ) print(arcpy.GetMessages()) The fields are created as numeric(p, s), but ArcGIS treats any precision >6 as a DOUBLE:

‎05-09-2024

File geodatabases don't support scale or precision (https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-field.htm) so round-tripping is problematic unless we stored the desired scale/precision in a side table and read from that during field creation. What DBMS are you targeting? untools is not explicitly upcasting the field, so I'd need to dig further to understand where that is happening.

‎05-07-2024

The 3.3 release of untools contains the fixes from untools 3.2.0. For more information, see the 3.2 release notes. Tool reference Installing untools untools 3.3.1 - July 2024 Apply Asset Package Support for Utility Network 6 & 7 Expose options (untools.common.settings) for custom precision/scale on single/double fields Resolved issue where standalone tables would not be created in the target workspace Stage Utility Network & Asset Package to Geodatabase Add new parameter to choose the Utility Network version to create (6 or 7) untools 3.3.0 - May 2024 Add support for Utility Network version 7 Big Integer network attributes Flow Direction network attribute Apply Asset Package Expose extent environment variable (in Asset Package to Geodatabase) Skip tiers whose valid controllers are completely removed by D_Configurations table Add support for terminal paths when there are 5 or more terminals Skip feature classes removed by D_Configurations table Support Data Reviewer attribute rules across tables Improve support for Date network attributes Validate contingent values on tables without subtypes Upgrade Asset Package Assign missing asset package domains to existing fields Miscellaneous Cleanup locks from arcpy cursors Remove extraneous console logger

Online Status	Offline
Date Last Visited	Tuesday

My Ideas

Latest Contributions by PaulLeBlanc1

Re: Apply Asset Package Error

Re: Apply Asset Package Error

Re: ERROR 000732: Target Dataset: Dataset

Re: Install untools breaks arcgis.gis connexion

Re: Asset Package to Geodatabase failed to find LineTypeLib table

Re: Asset Package to Geodatabase failed to find LineTypeLib table

Re: Utility Network Package toolbox 3.3 release notes

Re: Apply Asset Package on UnTools/Pro 3.3 requires UN vesrion 7 - is there a way how to run on Version 6?

Re: Apply Asset Package: float changes to double in enterprise geodatabase

Re: Apply Asset Package: float changes to double in enterprise geodatabase

Re: Apply Asset Package: float changes to double in enterprise geodatabase

Re: Apply Asset Package: float changes to double in enterprise geodatabase

Re: Apply Asset Package: float changes to double in enterprise geodatabase

Re: Apply Asset Package: float changes to double in enterprise geodatabase

Utility Network Package toolbox 3.3 release notes

Re: Apply Asset Package Error

Re: Install untools breaks arcgis.gis connexion

Re: Asset Package to Geodatabase failed to find Li...

Re: Apply Asset Package: Failed to execute (AssetP...

Re: Asset Package to Geodatabase failed to find Li...