topic Re: Address Data Management Solution Data Dictionary in ArcGIS Solutions Questions https://community.esri.com/t5/arcgis-solutions-questions/address-data-management-solution-data-dictionary/m-p/726874#M762 <HTML><HEAD></HEAD><BODY><P>It's fairly easy to get an html table into excel; once there you can save it to what ever you want: I prefer csv which I perform a table to table upon to get it into a fgdb table.&nbsp; I do this so I can map my current data schema(s) to the ESRI field names and vice-versa.</P><P></P><OL><LI>Open the solutions html data dictionary in your favorite browser</LI><LI>Copy the url</LI><LI>Open Excel</LI><LI>Click on the Data heading in the top ribbon</LI><LI>In the Get Data Group, select&nbsp;From Web</LI><LI>Paste the url into the subsequent dialog window</LI><LI></LI></OL><P>After that, you will be presented with several choices (like 65) of table names with the naming convention of Table ##.&nbsp; Scroll through the list until you see the one you want, and click the Load button at the bottom of the Navigator window. It automagically displays as an excel worksheet and you can then save as you like...</P><P></P><P><IMG alt="" class="jive-emoji image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/489457_htmlTocsv.gif" /></P></BODY></HTML> Tue, 21 Apr 2020 19:06:56 GMT JoeBorgione 2020-04-21T19:06:56Z Address Data Management Solution Data Dictionary https://community.esri.com/t5/arcgis-solutions-questions/address-data-management-solution-data-dictionary/m-p/726873#M761 <HTML><HEAD></HEAD><BODY><P>Is the html data dictionary that ships with the solution available in excel, csv or esri gdb table format?</P><P></P><P><A href="https://community.esri.com/migrated-users/52415">Chris Fox</A>‌</P><P><A href="https://community.esri.com/migrated-users/346162">Hayley Miller</A>‌</P></BODY></HTML> Tue, 21 Apr 2020 18:02:07 GMT https://community.esri.com/t5/arcgis-solutions-questions/address-data-management-solution-data-dictionary/m-p/726873#M761 JoeBorgione 2020-04-21T18:02:07Z Re: Address Data Management Solution Data Dictionary https://community.esri.com/t5/arcgis-solutions-questions/address-data-management-solution-data-dictionary/m-p/726874#M762 <HTML><HEAD></HEAD><BODY><P>It's fairly easy to get an html table into excel; once there you can save it to what ever you want: I prefer csv which I perform a table to table upon to get it into a fgdb table.&nbsp; I do this so I can map my current data schema(s) to the ESRI field names and vice-versa.</P><P></P><OL><LI>Open the solutions html data dictionary in your favorite browser</LI><LI>Copy the url</LI><LI>Open Excel</LI><LI>Click on the Data heading in the top ribbon</LI><LI>In the Get Data Group, select&nbsp;From Web</LI><LI>Paste the url into the subsequent dialog window</LI><LI></LI></OL><P>After that, you will be presented with several choices (like 65) of table names with the naming convention of Table ##.&nbsp; Scroll through the list until you see the one you want, and click the Load button at the bottom of the Navigator window. It automagically displays as an excel worksheet and you can then save as you like...</P><P></P><P><IMG alt="" class="jive-emoji image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/489457_htmlTocsv.gif" /></P></BODY></HTML> Tue, 21 Apr 2020 19:06:56 GMT https://community.esri.com/t5/arcgis-solutions-questions/address-data-management-solution-data-dictionary/m-p/726874#M762 JoeBorgione 2020-04-21T19:06:56Z