topic Re: csv properties not refreshing in Data Management Questions https://community.esri.com/t5/data-management-questions/csv-properties-not-refreshing/m-p/468471#M26708 <HTML><HEAD></HEAD><BODY><P>ArcGIS seems to keep some metadata in memory. If you rename the file, it should recognize the current data format.</P></BODY></HTML> Mon, 08 Feb 2016 18:19:50 GMT XanderBakker 2016-02-08T18:19:50Z csv properties not refreshing https://community.esri.com/t5/data-management-questions/csv-properties-not-refreshing/m-p/468470#M26707 <HTML><HEAD></HEAD><BODY><P>My csv has the following columns when I open it in a spreadsheet program: address, lat, lon, latold, lonold, sold, city, postal.code, add1, add2, internal.listing.id, X, Y. </P><P></P><P>When I add the csv to ArcMap and open the table, I have: address, lat, lon, latold, lonold, add2, sold, city, postal.code, postal.code, internal.listing.id, new.lattitude, new.longitude, geo.lat, geo.lon, internal.listing.id.</P><P></P><P>The list of column names in the table that opens in ArcMap is how the csv was arranged when I first loaded the csv into ArcMap. I have edited the csv a couple of times to reflect what's in my first sentence here. The column names that are showing in current table in ArcMap are wrong and they don't even match the data. For example, the data in the second "postal.code" column in the table actually appears as add1 data in my csv.</P><P></P><P>I've removed the csv from ArcMap several times and added it again. I copied the sheet to a different directory and deleted it via ArcCatalog and then added a new copy and the ArcMap table still isn't correctly displaying the table as it's currently configured in the spreadsheet. The csv's name has remained constant, but I don't see why that should be causing trouble. What is going on?</P></BODY></HTML> Mon, 08 Feb 2016 18:09:56 GMT https://community.esri.com/t5/data-management-questions/csv-properties-not-refreshing/m-p/468470#M26707 johnpolo 2016-02-08T18:09:56Z Re: csv properties not refreshing https://community.esri.com/t5/data-management-questions/csv-properties-not-refreshing/m-p/468471#M26708 <HTML><HEAD></HEAD><BODY><P>ArcGIS seems to keep some metadata in memory. If you rename the file, it should recognize the current data format.</P></BODY></HTML> Mon, 08 Feb 2016 18:19:50 GMT https://community.esri.com/t5/data-management-questions/csv-properties-not-refreshing/m-p/468471#M26708 XanderBakker 2016-02-08T18:19:50Z Re: csv properties not refreshing https://community.esri.com/t5/data-management-questions/csv-properties-not-refreshing/m-p/468472#M26709 <HTML><HEAD></HEAD><BODY><P>Thank you, Xander. </P></BODY></HTML> Mon, 08 Feb 2016 19:40:22 GMT https://community.esri.com/t5/data-management-questions/csv-properties-not-refreshing/m-p/468472#M26709 johnpolo 2016-02-08T19:40:22Z