I have a table of county data with just a few columns, name, state, count, rate, etc. I can't get this to load onto a map. It starts to load, counts up to 1% and then disappears. This data came from another staff, who I suspected copy and pasted from something that left some strange formatting. I saved to tab delimited and brought it back in. Same issue.
Question 1: What am I missing?! This is really plain data!
Question 2: I'm not getting any errors, just something that doesn't load. Are errors being logged somewhere I can look up?
Question 3: (Not all that related to this question) Why are the prompts for updating the version of the add-in so inconsistent? It prompted me earlier to update when I wasn't ready to, but now that I'm having problems, and thinking the update might help, it stopped asking me. I even rebooted, thinking I could get it to come up again. I know I can go and get the download, but that is the most user-unfriendly page to navigate and I'm a 30 year ESRI veteran!!!!!!
Solved! Go to Solution.
I placed a ticket with support and learned this has been logged as a defect: BUG-000123926:Adding data from Microsoft Excel based on counties hangs at one percent and crashes in ArcGIS Maps for Office.
This doesn't fix my problem, but it will keep me from attempting the same process steps over and over, and expecting to have different results. I have contacted my account manager in the hopes this can be elevated.
That doesn't make much sense to me, and it didn't work.
Selecting County Subdivisions, it does complete, but it only looks to be matched to county names that are unique to Missouri. The other counties that get shaded are sprinkled around the country. And if I need to do something like append "..County, Missouri" to my county names, for County Subdivisions to work, that needs to be clearly shown as a tip. Don't make me dig into the documentation for something so rudimentary.
My goal is to have this be an easy entry starting point for all the users in state government who need to just make some county shaded maps. I continue to be completely hopeful but disappointed with this platform, because for all the apparent "easy of use" there are some glaring gaps. I want to be able to recommend this to dozens of state employees, but I can't, because of issues like this.
I stopped by this area at the UC last week and we had a brief "I don't know why more people don't use this" conversation. But coming back into the office and trying just a few things, I'm reminded again, "Oh, this is why you can't recommend it to everyone, it doesn't really work as well as it should".
I'll update the software, but I'm back to thinking I can't recommend this for the general masses.
I am having this same issue. Trying to add any data from an Excel table as a layer on the map that includes County information reproduces this issue. I have a simple data table with the county name, state, and a number field. Windows event viewer has this error:
Any ideas on a solution to this would be helpful! It is a workflow we use frequently prior to the 5.x update.
Hi Ethan, welcome to the party and thank you for your feedback. Are you able to share a sample of the data you are using and confirm the version of Maps for Office you are running?
Hello Shannon, here is a screencap. I cannot give the actual data but this reproduces the error and is close to the same format as the original data I had trouble with. When I hit "add data" it flashes the layer list on the map, then does nothing. I was not able to get County subdivisions to work either (clarification: it adds to the map, just does not match correctly), not sure how to format that and it is not intuitive to users. Selecting exact match gets the same result, and field names do not seem to matter. I am using 32 bit Excel w/ ArcGIS Maps for Office v. 5.0.1, working on testing this with 64 bit as well. Thanks for your reply!
Good Morning Ethan,
Yes, please! If you and perhaps, Tracy would both submit a request to Technical support that would be great. The phone number is 1-888-377-4575. You will need to reference your customer number and call-in ID.