-
Refresh of Replica List
I am using the Check in and Check out methods using Replicas in a Python toolbox. When I have checked out a set of features into a file geodatabase, then I run arcpy.da.ListReplicas() on the gdb it shows nothing. If I open the geodatabase Manage Replicas tool and select Refresh, it appears. However, it still cannot be…
-
Enhancement Request to Simple Data Mapping workbook - Allow configuration of python functions before running Create Migration Workspace
How can we request an enhancement to the Simple Data Mapping workbook? Can a new worksheet be provided when the workbook is created which would allow user.py functions to be configured based on field name matches in target UN fields? See screenshot for example. In this case I would like to automatically apply my user.py…
-
Will custom functions in user.py be listed in the Expression column in Data Loading Worksheets?
When adding new functions to the user.py file, should the functions appear as a list in the Expression column, similar to how the base.py functions appear?
-
Issue with Load Data Using Workspace in ArcGIS Pro 3.4 – Shape Data Not Appending When Using Expressions
Hi All, I am experiencing an issue with the "Load Data Using Workspace" tool in ArcGIS Pro 3.4. When using an expression to assign a value to a field in the Mapping worksheet, the tool fails to append the shape data.For example, using the expression below for…
-
how use LookupDefault to write null value
Hi, I would like write null value in target db using LookupDefault cell. The target field is a LONG and the LookupSheet LookupKeys LookupValue cells has been filled. What is the value should be entered? I tried to insert null or <null> or NULL value but the following error occour like this occour: WARNING 001156: Failed on…
-
Execute Data Load - "No rows to process" message
Hello, everyone! I've been following the Load data into the ArcGIS utility network tutorial and after some days, I've encountered this issue that doesn't allow me to complete the final step. The Execute Data Load tool does not fail but finishes very quickly displaying the message "No rows to process". I have already…
-
How to enable debug mode for Data Loading Tools
Hello, I'm trying to enable debug mode for Data Loading Tools to investigate some strange behavior related to the formatting of the data mapping workbooks, but I'm not able to find a solution. I'm using ArcGIS Pro 3.2 and Data Loading Tools are now part of the standard ArcToolbox tools. In ArcGIS Pro 3.0 there was an…
-
Can the Data Loader Tools - Worksheets be used to load directly to SDE?
I have had a lot of success using the data loading worksheets to load from gdb to gdb, but I cannot find any documentation about loading from gdb to SDE using the same worksheets. Is the load to SDE via the worksheets not currently supported? If it is, does anyone have an example of the target path syntax?
-
What are the best practices for mapping in Mapping Workbooks?
Hello, Especially for smaller/small utilities – like city water companies, there is a phenomenon present, that the input feature layer contains different types of data - from structural and logical network or cross several asset groups - at once. While it could work for plain data model with just feature layers (point and…
-
Append Annotation feature class from source to target using Data Loading tools
When I am loading Annotation feature class from source to target, it is not loading correctly. Can I use "Load Data Using Workspace" for loading Annotation feature class from source to target? @Robert_LeClair @PatrickGCowan @TedHoward2 @AlixVezina
-
Check for data already present in the target field using Data Loading Tools
Hi @AlixVezina @TedHoward2, I am new to Data Loading Tools. I have following queries: * Can I check for data already present in the target field using Data Loading Tools? * Can I reuse the DataLoadingWorkspace just by updating Source column in DataReference worksheet? I am using ArcGIS Pro 3.1.2.41833 and dltsolutions 3.1.2
-
Add domains to TargetField (existing in target GDB) based on SourceSchema fields
Hi, I am new to Data Loading Tools. Can I add domains to TargetField (existing in target GDB) based on SourceSchema fields if the source does not have domains? @TedHoward2
-
Data Loading Tools is now included with ArcGIS Pro - 3.2 and Beyond
Starting with ArcGIS Pro 3.2, the Data Loading Tools are now included with ArcGIS Pro. You no longer must clone your python environment and install the tools via Anaconda. The tools are available in the Data Management Tools toolbox, under the Data Loading Tools toolset. As we moved the tools into ArcGIS Pro, we made some…
-
Execute Data Load Failing
Hello, I'm trying to use the Execute Data Load tool to migrate data into the utility network but every I run the tool I get the same error regardless of the reference workbook I use: import pyarrow.lib as _lib ImportError: DLL load failed while importing lib: The specified procedure could not be found. As far as I can tell…
-
Documentation of supported source types in DLT
I have been reading the documentation of the dlt here and also the legacy documentation here but it does not specify which data sources are valid. According to some of the videos i can deduct that Filegeodatabases are allowed. I have an use case that involves csv, xls, xlsx files. I tried to use them in the the tools but I…
-
Browse/Add Data nonresponsive
I have an issue with my Add Data/ Browse buttons in GIS. They all get non responsive when I click on them and my app gets non responsive until I push Esc button. I have uninstalled and reinstalled my app and have the last version installed now. However the issue is still there. Worth mentioning that I am connected to a vpn…
-
How does the DLT use the shape_operations.py file.... I would like to create custom shape operations?
How does the DLT use the shape_operations.py file? I would like to create custom shape operation functions in the script and apply them during the execute data load tool process.
-
DLT - Mapping questions
Hello , i am new with using DLT tool , the output of this tool provided data reference and the mapping file . But mapping file did not assign any domains , and also did not generate any new blue sheets. This file includes only mapping sheet ,source subtypes ,source schema,target subtypes and target schema . why did not…
-
Create Data Loading Workspace ERROR
Hello everyone, I have a problem importing my data. I'm using the tool called "Data loading tools" and I want to create a Data Loading Workspace (dlt). When I run the tool, the following error message appears. Does anyone have experience with this and can help? Kind regards, Maik
-
Not seeing toolbox after install
I'm having trouble installing Data Loading Tools. I'm using ArcGIS Pro 3.1.2. I followed the instructions; cloned my Python environment, ensured the cloned environment is set as default, installed the dltsolutions 3.1.2 package, and restarted ArcGIS Pro. I'm unable to find the Data Loading Toolbox or any of the tools,…
-
Issue Copying from Editor Tracking Fields
I upgraded from ArcGIS Pro 2.9 to 3.1.1 and at the same time updated dltsolutions to the 3.1.1 version in Package Manager. After the update however, some fields are not copying data over. In a Data Loading Workspace, where there are fields in the source dataset that have Editor Tracking enabled on them, and they are added…
-
Append with Transformation to AGO Slowwwwww
Is it typical for Append with Transformations to operate so slow when pushing data to a solution feature layer in AGO? Have a dataset with 2900 records, nothing out of the ordinary, that will take most of the day to upload. Upload network connection is fast, 400Mbps upload,
-
Re: Lead Service Line Inventory - DLT
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…
-
Lead Service Line Inventory - DLT
I am trying to load the data I have on service lines into the provided ServiceLine layer from the Lead Service Line Inventory solution, and when I run the data loading tool I get the error message, "An output was not created due to no matches being found in the Source to Target Mapping parameter." I've selected both the…
-
Data Loading Tools and Lead Service Line Inventory Solutions
Has anyone use DLT (Data Loading Tools) to maintain the Utility Side | Customer Side Feature Layer (Hosted) in ArcGIS Online? I used the the Append with Transformation tool one time to upload our existing utility data to populate the fields and get things started. But now I'm wondering how to maintain the Feature Layer…
