Latest Contributions by JohnTownsend

Agreed that this would be useful functionality. Please vote up my idea. https://community.esri.com/ideas/18156  ... View more

I too have been experiencing the same issues as Michael August  I had this problem at one point with windows 7.  It had not been a problem for some time.  I've updated the MSDBE to 2016 and am on Windows 10 now and the problem has returned.  This happens often, when opening and expanding an excel workbook in catalog view, adding excel table to map, and now even running XY Table to Point on a table that was imported into a geodatabase is also throwing the error.  I have numerous errors recorded in the event viewer that look similar to this: Any solutions that have worked Kory Kramer‌? ... View more

Thank you for this clarification Richard. I too have been struggling with the outer join dilemma.  Have you created an idea at all for this to suggest providing more support for join types?  I have datasets set up to be built as relational geodatabases, but the query functionality that I have used within Arc has its limitiations.  I have been able to get creative using query tables, table views, and in memory joins, however, in-memory joins cause certain processes to fail such as packaging maps.   The suggested solution by many is to export the features into a new feature class, which completely violates the whole concept of having a relational database in the first place.  I'll continue to experiment with this concept, but from what I can tell,  there is limited functionality with data queries. ... View more

Pro doesn't correctly load Excel tables if they don't contain any number fields. It treats the header row as a data record, as described below. This means I have to insert fake data into my Excel files or import them into a geodatabase, or some other workaround. Since I am often the only GIS user on projects that share a lot of Excel files, this is very inefficient, and simply frustrating. I agree this is pretty maddening.  I currently have no issues with ArcMap displaying field headings from excel.  In the case of invalid field names, It handles it for you and if you import/export data into a geodatabase it adds "_" or replaces invalid field name characters, or replaces a null value to create a valid field name. Using the same data in ArcPro doesn't read or import/export correctly.  I have to go into excel and modify field names in order for it to display correctly and be usable.  This is a step backward from ArcMap and I hope it is dealt with soon.  I am guessing many GIS users are like me and receive good, bad, and ugly excel files from non-gis users or other data sources on a regular basis and just want to get the data into GIS as quickly as possible.  I prefer be able to deal with cleaning the data up in a single program, rather to have to use some combination of validating and formatting data and fields in excel, using arcmap to process data, just to finally have it be usable in Pro. I love using Pro, but its all these little bits and pieces that missed the boat during the migration that can make some of the simplest workflows extremely frustrating. ... View more

Pro doesn't correctly load Excel tables if they don't contain any number fields. It treats the header row as a data record, as described below. This means I have to insert fake data into my Excel files or import them into a geodatabase, or some other workaround. Since I am often the only GIS user on projects that share a lot of Excel files, this is very inefficient, and simply frustrating. I agree this is pretty maddening.  I currently have no issues with ArcMap displaying field headings from excel.  In the case of invalid field names, It handles it for you and if you import/export data into a geodatabase it adds "_" or replaces invalid field name characters, or replaces a null value to create a valid field name. Using the same data in ArcPro doesn't read or import/export correctly.  I have to go into excel and modify field names in order for it to display correctly and be usable.  This is a step backward from ArcMap and I hope it is dealt with soon.  I am guessing many GIS users are like me and receive good, bad, and ugly excel files from non-gis users or other data sources on a regular basis and just want to get the data into GIS as quickly as possible.  I prefer be able to deal with cleaning the data up in a single program, rather to have to use some combination of validating and formatting data and fields in excel, using arcmap to process data, just to finally have it be usable in Pro. I love using Pro, but its all these little bits and pieces that missed the boat during the migration that can make some of the simplest workflows extremely frustrating. ... View more

This is an important feature and I hope it gets implemented soon.  In my case, I have a layer on top that is editable.  There are other supporting layers that have useful information for a user to reference but not the information I would like to display by default.  As it stands, each time we want to make an edit on the top layer they must navigate through the popups to find the editable layer.  This is a frustrating and inefficient way of doing things.  The alternative is to disable the popup or turn off the layer manually.  Not an ideal solution.  This seems like a pretty essential option to have control over how data is displayed and interacted with.  ... View more

While I agree that the functionality exists in ArcPro, I find it very cumbersome to have to switch to the "list by selection" tab to achieve this.  I use this function regularly and when working with many layers in a map, being able to quickly right click in the TOC ("Drawing Order" of Contents Pane) to change the selectable layer is preferable rather than having to go another tab.  This at least doubles the amount of time and mouse clicks it takes to perform the same function. I think the "list by selection" pane  can be useful for other tasks such as setting the final selectable layers in a map before publishing to web. For editing data and general feature selection, I wish they add this functionality back to the TOC ("Drawing Order" of Contents Pane).  I'm not sure about others but in my daily work, I rarely wish to have more than 1 or 2 layers selectable at a time and like to be able to switch between selectable layers often. Update: I've added this as an idea so if you feel the same way please vote this up: https://community.esri.com/ideas/14787  ... View more

Has there been any update to this? It is 2017. I too am trying to open a file (pdf) stored on AGOL through a hypelink url within a web app.  From what I can see is there is two options. Hyperlink to the item information page.  This requires the user then to click again to open the file. Unfortunately, the URL expires quickly after the file is opened so using the URL to try to open the document directly results in error (as discussed by yeoanny venetsanos). Use external storage outside of AGOL and use hyperlinks to the file locations. It sure would be nice to be able to directly link to content published within an organization.  For now I'm going to have to default to using option number 2 though this seems a bit silly being the fact that all the other functionality is there within AGOL other than directly opening the file. ... View more

Thanks Kirsten, This works on my end too.  Glad there is a work around. ... View more

I have this issue as well.  I am currently experimenting with creating a static map in Arc Pro.  I've been able to figure out how to do most everything that I would do in ArcMap. However when getting to the point of placing annotation I came across this.  When editing the annotation, the leader appears to stay with the feature until you save the anno.  Then it moves. ... View more

There is a script will extract attachments to files: http://support.esri.com/em/knowledgebase/techarticles/detail/41763 Thanks.  That is exactly what I needed. ... View more

Update*  After further testing, this problem only occurred at my work computer.  When I accessed my AGOL account from a different machine, i was able to open the attachments fine.  This must be an issue with my computer not recognizing the attachment without the file extension as a .jpg.  In this instance, I am using iOS on an ipad air.  Here is what I have discovered: When I collect an attachment in collector from ipad when online, it names the attachment Photo1.jpg, Photo2.jpg, etc. When I do the same in offline mode the attachment is named Photo 1, Photo 2, etc.  with no file extension When I collect on my android device it names it consistently both online and offline but with a completely different naming schema something like MapName_169_0_ArcGISApp_110990398400934.jpg. This brings up the issue that depending on which device and what mode you are collecting attachments, the result will be different file naming schemas and in the case of the offline ipad, a file without an extension.  I would imagine that my work computer is not the only one out there that will have difficulty recognizing a file without an extension.  I do not see any way that I can define the name of the attachments which would alleviate this problem.  I had posted a question about pulling attachments out of the application on a different post.  If I have attachments for 500 features and each has a photo called Photo1.jpg, this could cause some headaches. It would be nice to know if others are seeing this same behavior on their mobile devices. ... View more