Hello. We are in the process of migrating to the Utility Network for our water, stormwater, and sanitary sewer utilities. We have spun up an Enterprise 11.3 test environment and are using ArcGIS Pro 3.4.3. Following great advice from another post, we are following the SS Foundation 2.2 online workflow and adapting it to the SW Foundation 1.4. It has been moving along, but questions arise as does confusion. My colleague has been working the SS foundation, which is progressing, while I work the SW foundation with less success.
In comparing the two DataMapping.xls tables, we noticed the SS table has several additional worksheets when compared to the SW table. Missing from the SW table are the Info, Associations, Mapping Table, and Source Types worksheets. We assume this has to do with the SS foundation being newer than the SW foundation. Can these sheets be manually added and populated with stormwater related information (assuming we can figure out that information)? Or do we move along with the current SW DataMapping.xls table with the existing worksheets?
Following along in the SS Foundation online help, Data Migration Tutorial....Migrate Data.....Create Migration Workspace step, we ran the Create Migration Workspace GP tool in the SW Pro project, which failed. I recall then having to download a newer version of the toolbox from GitHub (Utility Data Management Support 3.3.3) and installed it. Ran the tool again, worked but received a warning about a missing column in the DataMapping.xls....Data Mappings work sheet, a column named Source Subtype Name. I added the column with no values in the cells, and ran the tool again, succeeded with no error message. As part of the three key outputs noted in the tutorial (modified asset package, workspace, and csv), no 'assocations.csv' file was created. I don't know what to do about the missing .csv.
Has there been an update to the stormwater foundation Data Dictionary?
Thanks for any help and advice, Jay
