topic Re: Active Flag sheet now showing in Data Reference table during data loading in ArcGIS Utility Network Questions

Active Flag sheet now showing in Data Reference table during data loading

TristanBest — Thu, 16 Apr 2026 21:02:54 GMT

Hello, I am going through the process of setting up a utility network following the load data into a utility network instructions (https://learn.arcgis.com/en/projects/load-data-into-a-utility-network/#begin-simple-data-mappings)

After I create the migration workspace using my own local data, I do not get the ACTIVE FLAG sheet in the 'mapping workbooks' created in the DataReference table.

However whenever I first went through this process using the dummy data, the ACTIVE FLAG sheet populated. So, I'm not sure where I went wrong when doing it using my local data.

Any ideas why this could have happened?

Re: Active Flag sheet now showing in Data Reference table during data loading

gis_KIWI4 — Thu, 16 Apr 2026 21:33:28 GMT

@TristanBest - Don't think there is anything necessarily wrong here.
You are seeing the ACTIVEFLAG when you use the provided dataset because it is a field in that dataset.
You own local data might have that field called something else. You can use that field for mapping to the Lifecycle status following the same steps in the tutorial.

Re: Active Flag sheet now showing in Data Reference table during data loading

RobertKrisher — Fri, 17 Apr 2026 05:48:51 GMT

@gis_KIWI4 is correct. The data reference/mapping sheets generated by the tools are unique to your data. The tables, fields, and domains are based on your data, not the local government model used in the tutorial.

Re: Active Flag sheet now showing in Data Reference table during data loading

TristanBest — Fri, 17 Apr 2026 14:54:24 GMT

Ah I see, so I will need to create my own sheet in my mapping workbooks for setting the LookupSheet,Keys,Value,Etc for mapping the domain values for field expression conversions.

Re: Active Flag sheet now showing in Data Reference table during data loading

RobertKrisher — Sat, 18 Apr 2026 03:58:00 GMT

@TristanBest The tool will create the sheet based on your current model, and your job is to fill out the lookupsheet, keys, etc to show the tools how to translate your current data model to the target data model.

Re: Active Flag sheet now showing in Data Reference table during data loading

TristanBest — Mon, 20 Apr 2026 18:55:55 GMT

Hmm, I've tried a couple of times now but when I create the data reference table, the supporting mapping workbooks do not create the sheets. Not sure what I'm missing to cause this.

Re: Active Flag sheet now showing in Data Reference table during data loading

RobertKrisher — Mon, 20 Apr 2026 20:46:40 GMT

@TristanBest what Worksheets or Workbooks are you expecting to see that aren't being created? The additional tabs (worksheets) in each workbook (file) are based on the domains in your source data. If your source data doesn't have any domains, then you won't get any by default. If you need to do translation you can always use the global mapping sheet, or create your own worksheets from scratch to do the translation.

Re: Active Flag sheet now showing in Data Reference table during data loading

TristanBest — Mon, 20 Apr 2026 21:12:31 GMT

Robert, that sounds like my problem. I had created a testing geodatabase and copied my water data into it. I didn't think about the domain values not coming over as well. Thanks for the the help!

Re: Active Flag sheet now showing in Data Reference table during data loading

RobertKrisher — Mon, 20 Apr 2026 21:16:16 GMT

@TristanBest if you use copy/paste or the copy geoprocessing tool to copy your data into the file geodatabase it will preserve your subtypes and domains.