topic Re: Basic table of county data won't load?! in ArcGIS for Office Questions

Basic table of county data won't load?!

TracySchloss — Thu, 18 Jul 2019 21:04:18 GMT

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!!!!!!

Re: Basic table of county data won't load?!

ShannonChavez — Fri, 19 Jul 2019 17:47:07 GMT

Good Morning Tracy,

I am sorry to hear about your pain points. Let me attempt to answer your questions and assist below:

Question 1: What am I missing?! This is really plain data!

Potential Answer: I copy/pasted a sample of the data you provided into a workbook and made the data into a table. I was able to add the data successfully using the following parameters:

- Table 1 is the excel data

- I selected the drop-down arrow for Location types and selected 'more location types' to find County Subdivisions

- Styling by County

Question 2: I'm not getting any errors, just something that doesn't load. Are errors being logged somewhere I can lookup?

Potential Answer: I believe this lack of error or not loading has to do with the way the add-in is trying to read the data. Can you attempt my workflow (above) ?

Question 3: (Not all that related to this question) Why are the prompts for updating the version of the add-in so inconsistent?

Potential Answer: I am not sure what your existing workflow is on this part, however, I would say the easiest way is to uninstall Map for Office and reinstall the latest version from here - Download

I'd like to know what the intended workflow is using this data and/or what is the ideal way to add this data (ex. using County or Counts or another variable)? This may help paint a clearer picture so we can determine the best way to proceed.

I look forward to a response.

Have a great weekend!

Best,

Shannon | Product Engineer

Re: Basic table of county data won't load?!

TracySchloss — Fri, 19 Jul 2019 21:11:11 GMT

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.

Re: Basic table of county data won't load?!

Anonymous User — Tue, 23 Jul 2019 14:09:50 GMT

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.

Re: Basic table of county data won't load?!

ShannonChavez — Tue, 23 Jul 2019 18:19:07 GMT

Hi Tracy, did you happen to get my business card at the UC? If so, can you call? This way we can dive in a little more.

Re: Basic table of county data won't load?!

ShannonChavez — Tue, 23 Jul 2019 18:20:21 GMT

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?

-SC

Re: Basic table of county data won't load?!

TracySchloss — Tue, 23 Jul 2019 19:49:02 GMT

I realized that when I updated my add-in from 4.0 to 5.0, I had downloaded and installed the 64 bit version, when I needed the 32 bit. I remedied that by uninstalling the add-in and installing the correct version. I thought, "Surely that must be it!" But no.

I am still not able to create a basic shaded county map from a simple Excel spreadsheet. I tried a 2nd table that came from a completely different source, thinking the first one was corrupt somehow. Still no luck. This 2nd table also had a column for city name, which gave me another for generating some sort of layer on my map. I was able to successfully map US cities as a set of graduated circle symbols.

My county column is called County. I added a field for State.

I have tried using Cell Range as my input and I've tried creating a table out of that same range.

In an older version of the add-in, creating a table helped instead of using cell ranges, but for this version, still nothing. I've actually used this add-in a few different times successfully in the past, but it's been a while. I have a different computer, running Windows 10 now, which would be a difference.

Re: Basic table of county data won't load?!

Anonymous User — Tue, 23 Jul 2019 20:34:38 GMT

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!

Re: Basic table of county data won't load?!

TracySchloss — Tue, 23 Jul 2019 20:41:16 GMT

Ethan, I went the other way, as you see, from 64-bit to 32-bit and neither worked. I'm starting to think it just doesn't work! I had a co-worker start completely from scratch, no prior history with previous versions of the add-in. He hasn't been able to get it to work either.

Re: Basic table of county data won't load?!

Anonymous User — Tue, 23 Jul 2019 20:45:43 GMT

Good to know, that is what I did as well, started with a fresh spreadsheet and install. Hopefully they can find a fix!

Re: Basic table of county data won't load?!

TracySchloss — Tue, 23 Jul 2019 20:56:38 GMT

I've started digging around in my Control Panel > Event Viewer too, which I'm not that savvy with interpreting. I get similar errors to Ethan

An error occurred:

Object reference not set to an instance of an object.

System.NullReferenceException: Object reference not set to an instance of an object.

...... and so on

and spotted one that sounds like a permission error:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID

{D63B10C5-BB46-4990-A94F-E40B9D520160}

and APPID

{9CA88EE3-ACB7-47C8-AFC4-AB702511C276}

to the user (suppressed my ID here) SID (S-1-5-21-3219648850-738124763-203175933-125472) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.

Now, I don't have administrative privileges with my account, but I shouldn't have to for this sort of work. I went back to the requirements page, and I see there is one version of Office 2016 that is known to have problems:

Caution:

*With Microsoft Office 2016 version 16.0.6326.1010, ArcGIS Maps for Office backstage controls do not function as designed. All other Microsoft Office 2016 versions are supported.

I checked, and this is not the version we have, which is 16.0.4849.1000

Re: Basic table of county data won't load?!

Anonymous User — Mon, 29 Jul 2019 14:19:32 GMT

Hey Shannon, any idea on this? If it would be easier, I can submit a case through tech support. Thanks!

Re: Basic table of county data won't load?!

TracySchloss — Mon, 29 Jul 2019 14:40:16 GMT

I didn't think to pick one up - sorry! Is it first initial.lastname@esri.com?

My email is in my profile, if you want to email me instead.

Re: Basic table of county data won't load?!

ShannonChavez — Mon, 29 Jul 2019 17:22:34 GMT

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.

Re: Basic table of county data won't load?!

TracySchloss — Tue, 30 Jul 2019 14:07:05 GMT

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.