Latest Contributions by JayLarsen

‎04-21-2023

Great article. Covers the exact thing! Surprised to see it so recent...I've been wondering about this for years. Thanks! 😁

‎04-21-2023

Thanks for this. So, normally the anchor would be the center of the x by y pixel bounding box? To "cheat" it into where you want to be, add blank space to the bottom so that the new bounding box anchor point is where you want it? I've wondered about this for years...didn't know the proper term to ask! Thanks!

‎04-21-2023

Yes, this area doesn't get a lot of discussion! You are correct, in my experience. You MUST put the image file somewhere convenient in your AGOL content, and then share just those symbol items to the whole world.

‎04-18-2023

Thanks! I can't believe I was just lucky for all of these years.

‎04-13-2023

I use the JOIN command quite a bit to add data to ZIP layers. So, I do a JOIN on the ZIP field. Does JOIN convert types to match? E.g. if I JOIN on ZIP that is integer and the other layer ZIP is a string (as it should be) will the JOIN work? I got this question from a colleague and I simply don't know. I haven't run into it. The Living Atlas ZIP layer the ZIP filed as a string, and I usually type mine as string when upload data. Has anybody done this experiment? Is there a known spec on the JOIN command, e.g. would integer = 2 match a float = 2? I'd love to see a doc or answer to this, just in case... Thank You.

‎04-04-2023

Sadly, this just seems to be something that happens from time to time. Often doing the same thing from different browser, or from home vs work net randomly works or not works. I haven't had a recurrence of this in a long while--I hope it stays away permanently!!! If you look at the whole thread, sometimes ESRI knows they had a spot problem, and fix it. I've had this problem on fancy "hard" analyses and stuff as generic as making a drive-time plot. It's weird. Good luck!

‎03-14-2023

Actually I did d/l the A4Excel on my home setup: work does not allow appsource!!! But it was pretty cool, it worked with my private "home" Office365 auth, and this was on my Mac!!! Blew my mind. I will experiment more...but my biggest problem is what do at work for my users and myself. Thanks!

‎03-14-2023

Thanks! I'll try ASAP!

‎03-08-2023

I was using my old machine with the old Excel plugin v2020.1.2 as it has a easy workflow we use quite a lot. Everything works and renders, but I could not upload the map or layer? Is something broken somewhere? Did they turn off this product as the new M365 plug is out? (Which breaks our vital workflow...)

‎03-08-2023

Actually, the "turning it into a pivot table" thing is critical problem. We often make large custom tables, with ZIP the first column, and the name of a location the rest of the columns. That way with one table upload, we can do a style for each column--huge timesaver. The nonsense pivot table destroys this ability. Is there a way to avoid making the pivot table--as there used to be before the AppSource and 2022.1? The alternative workflow is load the excel file table up to AGOL, make it service, put it in a map, then do a JOIN with ZIP layer. But this is a lot more typing and fussing than it used to be, and quite time-consuming. Any other ideas?

‎02-23-2023

I figured out the workflow myself. It actually makes sense, but is way different than the old way. This plugin version has a drop-down menu for location type, so select "Geography". Then select 2022 ZIP Codes. This defaults weirdly to USA_Country, so change it back to USA_ZIP_Code. Then select the next drop-down selector for "ZIP Code" which is the field in the geography layer to bind to the ZIP column in your excel data. Weirdly, it forces you to turn it into a pivot table, and then select the column to style by. So, I can use it. But turning it into a pivot table clobbers the labels, which is not great. If I can get using the Office365 version, I hope it is better? Or at least as good? So, I don't have to try and make a support case with ESRI! But if anybody has more knowledge or comments, please reply as I'd love to get them.

‎02-23-2023

No worries. I figured it out myself. I was confused because the NEW workflow makes sense and involves no hidden weird features--unlike the old one. Wow, that Excel plugin really had a lot of features added for 2022.1. Too bad it's already DOA for the Office365 version--which I hope I can get working at some point. Thanks! Good luck!

‎02-23-2023

Hi! Saw this answer and wondered if you know the workflow for a ZIP choropleth map using just the Excel plugin from ArcGIS for Office v2022.1?

‎02-23-2023

Hello. We have a very important workflow we do all the time in the previous versions of the ArcGIS for Office plugins. I finally had to get a new computer, and installed foung out we CANNOT use the new "Office 365" version of the Excel plugin, so we have to use the legacy 2022.1 version. This version does not seem to support our workflow for making quick choropleth maps from ZIP data. Previously, we could add a new "location type" in the old plugin, and select the ESRI ZIP shapes from the browser, and then select that new location type and make the map. There seems to be no way to add to location types in the new 2022.1 plugin? Am I missing something? Anybody know the workflow now? If we can authorization to run the Office365 version, does it support the workflow I mentioned? (Yes, I know I can go into AGOL, upload a table of my ZIP data, and then do a JOIN to the ZIP outlines, but this is very time-consuming and inconvenient for my users.) Any help?

‎08-10-2022

OH....in that case, do you have the rights to extract data? It is a specific right that must be granted on layers, etc.

Online Status	Offline
Date Last Visited	‎07-07-2025 05:52 PM

My Ideas

Latest Contributions by JayLarsen

Re: Map viewer: possible to specify anchor for uploaded feature symbol?

Re: Map viewer: possible to specify anchor for uploaded feature symbol?

Re: Custom Symbols for AGOL

Re: AGOL JOIN command: do match field data types have to match?

AGOL JOIN command: do match field data types have to match?

Re: analysis not completing

Re: make choropleth ZIP map in Excel plugin v2022.1

Re: Is old Excel plugin 2020.1.2 broken now?

Is old Excel plugin 2020.1.2 broken now?

Re: make choropleth ZIP map in Excel plugin v2022.1

Re: make choropleth ZIP map in Excel plugin v2022.1

Re: Can't create a choropleth map - just get the points - why?

Re: Can't create a choropleth map - just get the points - why?

make choropleth ZIP map in Excel plugin v2022.1

Re: Unnamed "error" after every attempt to use "analyze" in ArcGIS Online

USA Traffic Counts

Re: USA Traffic Counts

Re: Hosted Feature Layer Error: There was an error...

creating new hosted feature from existing is weird...

Re: City Code