topic Re: ArcGIS Pro - copy records from attribute table in sorted order in ArcGIS Pro Questions

ArcGIS Pro - copy records from attribute table in sorted order

MelissaDaniels1 — Mon, 24 Jun 2019 19:47:45 GMT

I just switched to Pro. I used to be able to sort an attribute table by a field, copy, and then paste them into Excel or wherever in the sorted order. Now when I sort an attribute table in Pro and then copy & paste, it pastes in order by OID. How to I copy & paste in Pro and maintain the order in which I sorted it?

Thanks!

Re: ArcGIS Pro - copy records from attribute table in sorted order

KoryKramer — Mon, 24 Jun 2019 21:13:09 GMT

Hmm, I'm seeing that too so I let the development team know. In the meantime, you might have to (re)sort on the desired field after the paste into Excel.

Re: ArcGIS Pro - copy records from attribute table in sorted order

MelissaDaniels1 — Mon, 24 Jun 2019 21:25:12 GMT

Thanks for getting back to me and for passing that along. I appreciate it.

Re: ArcGIS Pro - copy records from attribute table in sorted order

MichaelVolz — Tue, 25 Jun 2019 14:33:41 GMT

Can you explain the workflow you use for this action in Pro 2.3.3, as I cannot even copy selected records from the attribute table to Excel?

I ask because I can highlight rows in the attribute table in ArcMap and then right-click on the far left column to be provided with a list of choices that include Copy Selected. If I perform the same action in Pro 2.3.3 Copy Selected in not available in the right-click drop down list.

Re: ArcGIS Pro - copy records from attribute table in sorted order

KoryKramer — Tue, 25 Jun 2019 14:36:55 GMT

Re: ArcGIS Pro - copy records from attribute table in sorted order

MichaelVolz — Tue, 25 Jun 2019 15:03:24 GMT

Thanks for the tip.

Besides fixing the sorting issue, will the Copy selected records also be added back to the right-click menu as it exists in ArcMap for equivalency purposes?

Re: ArcGIS Pro - copy records from attribute table in sorted order

KoryKramer — Tue, 25 Jun 2019 15:09:09 GMT

I don't think there's any plan for that as Ctrl + Shift +C is the same shortcut in ArcMap and ArcGIS Pro.

Re: ArcGIS Pro - copy records from attribute table in sorted order

PRuss — Thu, 30 Apr 2020 18:31:59 GMT

Any word on when this really aggravating bug will be fixed? As of today, 4/30/2020 in 2.5 it is still not preserving sorts when copying into Excel... how does this type of bug even happen in the first place?

Also, when attempting to do the same sort in Excel it is not straight forward at all. Dealing with a data set right now that simply will not sort the same way as in Pro's attribute table. Never saw any issue like this in ArcMap going back to 8.3 days.

Re: ArcGIS Pro - copy records from attribute table in sorted order

KoryKramer — Thu, 30 Apr 2020 21:29:51 GMT

I'm not sure why the sort isn't preserved when pasting into Excel. I looked at the dev issue, and it shows as being fixed in 2.5.

I just tried:

This table is sorted on Fire_Name. When I copy/paste into Excel, it is the same order.

What is different about what you're seeing in 2.5? Can you provide more details and screenshots?