topic Re: Check for data already present in the target field using Data Loading Tools in Data Loading Tools Questions

Check for data already present in the target field using Data Loading Tools

SumitMishra_016 — Tue, 19 Mar 2024 12:40:15 GMT

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

Re: Check for data already present in the target field using Data Loading Tools

PatrickGCowan — Tue, 19 Mar 2024 13:29:04 GMT

1. No, it will not check for data already present. It also will not update existing records. The data loading process only appends the target.

2. Yes, Workspaces can be reused by updating data paths. You can also use the "Update Data Loading Workspace Schema" tool to update any schema changes after you update the paths (if there are any).

Re: Check for data already present in the target field using Data Loading Tools

SumitMishra_016 — Thu, 21 Mar 2024 07:13:16 GMT

Thanks for the reply @PatrickGCowan,

Can I automatically update the source paths using openpyxl and then run the "Update Data Loading Workspace Schema" tool? Or is there any other method to automatically update the paths?

Re: Check for data already present in the target field using Data Loading Tools

PatrickGCowan — Thu, 21 Mar 2024 12:13:01 GMT

The paths need to be updated in the DataReference.xlsx. You could use openpyxl to do the updates or you can manually updated them in Excel. After updating the paths, you would only need to run "Update Data Loading Workspace Schema" if there were any changes to the schema of the source and target.