topic Re: Add domains to TargetField (existing in target GDB) based on SourceSchema fields in Data Loading Tools Questions

Add domains to TargetField (existing in target GDB) based on SourceSchema fields

SumitMishra_016 — Mon, 18 Mar 2024 11:34:52 GMT

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

Re: Add domains to TargetField (existing in target GDB) based on SourceSchema fields

MikeMillerGIS — Mon, 18 Mar 2024 12:29:20 GMT

Not in data loading tools. They only are for the transfer of data, not schema.

Re: Add domains to TargetField (existing in target GDB) based on SourceSchema fields

SumitMishra_016 — Mon, 18 Mar 2024 12:35:29 GMT

I want data transfer only but assign domain to a field based on source field values

Re: Add domains to TargetField (existing in target GDB) based on SourceSchema fields

MikeMillerGIS — Mon, 18 Mar 2024 12:39:18 GMT

There is a new capability coming in 3.3 that will create an coded value domain from the values in the column. You could leverage that after transferring the data. At 3.2 and before, you will need to script the process.

Re: Add domains to TargetField (existing in target GDB) based on SourceSchema fields

TedHoward2 — Mon, 18 Mar 2024 18:40:44 GMT

The term "assign domain" is throwing us off I think. Do you mean load values to a target field that already has a domain? There are a couple ways to do that. As Mike mentions you could script it by writing a python expression to transfer values. You could also create your own Lookup sheet and map source field(s) values to a target value. The Source field does not have to have a domain.

Re: Add domains to TargetField (existing in target GDB) based on SourceSchema fields

SumitMishra_016 — Tue, 19 Mar 2024 06:19:27 GMT

Thanks for the reply @TedHoward2 ,

"Assign Domain" means "Domains" already exist in the target geodatabase and I have to assign on the basis of source field values. Can I use the base.py to assign domain codes to the target like the following:

def assign_domain(new_level: int, new_color: int, new_line_wt: int, new_linetype: str) -> int:

if new_level == 2 and new_color == 3 and new_line_wt == 2 and new_linetype == "Solid":

return 1

else: return 2

and call the function assign_domain(!NewLevel!, !NewColor!, !NewLineWt!, !NewLinetype!) in Expression column of TargetField

Re: Add domains to TargetField (existing in target GDB) based on SourceSchema fields

TedHoward2 — Tue, 19 Mar 2024 14:00:45 GMT

Yes that’s exactly how it works. I would suggest adding custom expressions to user.py instead of base.py. This will maintain your expressions if you ever run the Update Data Loading Workspace Schema tool.