topic CCTV Manager Null Fields in Water Utilities Questions https://community.esri.com/t5/water-utilities-questions/cctv-manager-null-fields/m-p/367793#M764 <HTML><HEAD></HEAD><BODY><P>I'm trying to use our CCTV data with the CCTV Manager.&nbsp; It works however the televised mains layer produces NULL values for all the existing fields, including most importantly Flow.&nbsp; I've tried using both "U" and "Upstream".&nbsp; I know I could easily join the data to the original tale based on inspection but seems like this should work.&nbsp; Any suggestions or anyone else experience this?&nbsp; We are using a custom schema.&nbsp; ArcGIS Pro 2.2.1.</P></BODY></HTML> Fri, 05 Oct 2018 19:10:30 GMT KrystalPhaneuf2 2018-10-05T19:10:30Z CCTV Manager Null Fields https://community.esri.com/t5/water-utilities-questions/cctv-manager-null-fields/m-p/367793#M764 <HTML><HEAD></HEAD><BODY><P>I'm trying to use our CCTV data with the CCTV Manager.&nbsp; It works however the televised mains layer produces NULL values for all the existing fields, including most importantly Flow.&nbsp; I've tried using both "U" and "Upstream".&nbsp; I know I could easily join the data to the original tale based on inspection but seems like this should work.&nbsp; Any suggestions or anyone else experience this?&nbsp; We are using a custom schema.&nbsp; ArcGIS Pro 2.2.1.</P></BODY></HTML> Fri, 05 Oct 2018 19:10:30 GMT https://community.esri.com/t5/water-utilities-questions/cctv-manager-null-fields/m-p/367793#M764 KrystalPhaneuf2 2018-10-05T19:10:30Z Re: CCTV Manager Null Fields https://community.esri.com/t5/water-utilities-questions/cctv-manager-null-fields/m-p/367794#M765 <HTML><HEAD></HEAD><BODY><P>Answered my own question.&nbsp; Looks like the tool takes text or numeric field types for Inspection ID, however in the process it converts it to numeric and I'm guessing when it tried to join the tables it refused.&nbsp; I changed the Inspection ID to numeric from text and the process worked and all fields appeared correctly.&nbsp; Going to add a suggestion that ESRI create documentation for best field formats when using their solutions.</P></BODY></HTML> Fri, 05 Oct 2018 20:37:39 GMT https://community.esri.com/t5/water-utilities-questions/cctv-manager-null-fields/m-p/367794#M765 KrystalPhaneuf2 2018-10-05T20:37:39Z