Re: Lead Service Line Inventory - DLT

CharlesRemmers — Thu, 02 Feb 2023 17:09:44 GMT

Using the path to Feature Service layers just errors out. Text below

Create Data Loading Workspace
=====================
Parameters

Source to Target Mapping https://services3.arcgis.com/iQAkxbE5rgLj88rC/arcgis/rest/services/ServiceLine_8faf8e2669884865966cf42c2237e26e/FeatureServer/0 https://services3.arcgis.com/iQAkxbE5rgLj88rC/arcgis/rest/services/ServiceLine_2a04662c01d2456faa95e40f67f572ff/FeatureServer/0
Output Folder C:\Temp\LSL
Calculate Feature Count Statistics true
Data Loading Workspace
Predictive Field Matching Options MATCH_FIELDS
Predefined Mapping in_memory\main.dlt_template
Create Matches by Subtype true
=====================
Messages

Start Time: Thursday, February 2, 2023 11:01:55 AM
ArcGIS Pro 3.0.3.36057
dltsolutions 3.0.2
A python error occurred.
EXCEPTION
Traceback (most recent call last):
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\site-packages\dltsolutions\esri\gptools.py", line 125, in wrapper
return func(*args, **kwargs)
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\site-packages\dltsolutions\esri\gptools.py", line 370, in run
gen.main()
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\site-packages\dltsolutions\logic\workbook.py", line 952, in main
self.book.save(output_file)
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\site-packages\openpyxl\workbook\workbook.py", line 407, in save
save_workbook(self, filename)
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\site-packages\openpyxl\writer\excel.py", line 291, in save_workbook
archive = ZipFile(filename, 'w', ZIP_DEFLATED, allowZip64=True)
File "C:\Users\cremmers\AppData\Local\ESRI\conda\envs\arcgispro-py3-clone-2\Lib\zipfile.py", line 1246, in __init__
self.fp = io.open(file, filemode)
OSError: [Errno 22] Invalid argument: 'C:\\Temp\\LSL\\DataLoadingWorkspace\\DataMapping\\Points\\Utility Side | Customer Side-ServiceLine.xlsx'
Failed to execute (CreateDataLoadingWorkspace).
Failed at Thursday, February 2, 2023 11:01:57 AM (Elapsed Time: 2.17 seconds)

Re: Lead Service Line Inventory - DLT

TedHoward2 — Thu, 02 Feb 2023 17:57:16 GMT

Interesting you have an illegal character in your source layer name "Utility Side | Customer Side". If you can remove the vertical bar than tool should work fine.

https://doc.arcgis.com/en/arcgis-online/manage-data/manage-hosted-feature-layers.htm#ESRI_SECTION1_C8FBC73B2DB44EF09AB7DE27328A4794

I've logged an issue to address this in a future release.

topic Re: Lead Service Line Inventory - DLT in Data Loading Tools Questions

Re: Lead Service Line Inventory - DLT

Re: Lead Service Line Inventory - DLT