topic Re: Why isn't "XY table to Point" working? in ArcGIS Pro Questions

Why isn't "XY table to Point" working?

AnthonyPodesto — Mon, 17 Aug 2020 21:33:54 GMT

It runs through the process without creating an error and completes "successfully". However, it does not create a new feature class and doesn't add anything to my map. Nothing is different than what I normally do, I don't think.

Any insight is much appreciated.

Re: Why isn't "XY table to Point" working?

DanPatterson — Mon, 17 Aug 2020 22:22:31 GMT

confusing, geo1 image has projected coordinates in the longitude and latitude columns, what did you specify for coordinate systems for both?

Perhaps you could clarify

Re: Why isn't "XY table to Point" working?

AnthonyPodesto — Mon, 17 Aug 2020 22:32:07 GMT

I use NAD 83 State Plane California

Re: Why isn't "XY table to Point" working?

DanPatterson — Mon, 17 Aug 2020 22:37:31 GMT

don't know about state plane, but X is longitude and Y is latitude so check that you selected the correct columns in your file

Re: Why isn't "XY table to Point" working?

DrewFlater — Tue, 18 Aug 2020 06:34:54 GMT

Dan Patterson‌ is right, you need to use the default selection for the fields, longitude should be the X field and latitude the Y field. I did some quick data entry for the first and last record in your pictured table, with the settings that match your pictured XY Table To Points execution and it displayed both points in central CA. This is using ArcGIS Pro 2.6.

Re: Why isn't "XY table to Point" working?

AnthonyPodesto — Tue, 18 Aug 2020 14:32:47 GMT

Thanks for the replies.

I did exactly as you had done Drew and still no results. Didn't even create the feature class.

Re: Why isn't "XY table to Point" working?

DanPatterson — Tue, 18 Aug 2020 14:40:26 GMT

Anthony, when you say it didn't create a featureclass... do you mean you navigated to the geodatabase in catalog where you saved it and it wasn't there (refresh the gdb to make sure) Also, in the project backstage, do you have the checkbox checked to add results to the display by default?

Re: Why isn't "XY table to Point" working?

AnthonyPodesto — Tue, 18 Aug 2020 14:44:42 GMT

Yessir, the add results option is checked and I have gone to my database in the catalog pane and refreshed multiple times, without any luck. It began happening yesterday with Pro version 2.5.1, so I updated to version 2.6. Clearly wasn't the problem.

Re: Why isn't "XY table to Point" working?

DanPatterson — Tue, 18 Aug 2020 14:54:49 GMT

Don't know what to suggest since Drew got it working by entering coordinates himself.

Either something is amiss with the real csv file or you have bigger problems. I would suggest exporting a few records of the table to a new file and trying it in a new map/project/after a reboot/on a different day/prior to calling Tech Support

Good luck

Re: Why isn't "XY table to Point" working?

AnthonyPodesto — Tue, 18 Aug 2020 14:59:17 GMT

Ok, I'll go back to the beginning, maybe something was corrupt from CAD. Thanks for the help!

Re: Why isn't "XY table to Point" working?

MervynLotter — Tue, 18 Aug 2020 18:34:43 GMT

A bit of a long shot, but can you look at the Environments tab and can you check the Extent setting.

Re: Why isn't "XY table to Point" working?

AnthonyPodesto — Tue, 18 Aug 2020 18:43:07 GMT

Re: Why isn't "XY table to Point" working?

MervynLotter — Tue, 18 Aug 2020 19:04:07 GMT

Thanks, then there is also an option to set the default Environment settings under the Analysis tab, can you check that the Extent was not set there. I have had this bite me before.

Re: Why isn't "XY table to Point" working?

PaulSweeney3 — Tue, 18 Aug 2020 19:29:22 GMT

I had this issue accessing files remotely via vpn. When I move the file in question to my desktop it worked.

Re: Why isn't "XY table to Point" working?

AnthonyPodesto — Tue, 18 Aug 2020 19:39:48 GMT

I AM using remote desktop, however everything is hosted on the same machine at the office. I have a tech call with ESRI in the morning, I'll post the results on here. Thanks everyone

Re: Why isn't "XY table to Point" working?

AmitGajurel — Mon, 15 Feb 2021 07:42:05 GMT

@AnthonyPodesto Were you able to find a solution? I am having the same issue. I was perfectly able to do this on 2.6 but when I update to 2.7, I got the same issue you mentioned. The tools says successful but nothing shows up in the gdb.

Re: Why isn't "XY table to Point" working?

DanHadley — Fri, 02 Apr 2021 15:31:26 GMT

@AnthonyPodestoI am also wondering if you were able to find a solution. I am having the exact same issue and am also working at 2.7. The tool runs and says successful, but nothing shows up in the gdb. I've refreshed, restarted, used multiple projections, all with the same result. Any help would be much appreciated

Re: Why isn't "XY table to Point" working?

Nunottx — Tue, 20 Apr 2021 11:04:02 GMT

in my case everything worked well untill i installed the update patch 2.7.3, now i have same problem, XY Table to Point gives us a sucessfull while dont create the shapefile neither the layer for it.

i tested in local drive, network drive and default location, nothing. the file isent created.

the file i have per default that was working is ArcGISPro_26_175036.exe, this one was working.

gonna un-install everything to see if fixes it.

FIXED:

uninstall the one not working, 2.7.3 , installed ArcGISPro_26_175036.exe and updated to 2.7.3, now is working.

Re: Why isn't "XY table to Point" working?

RandyKreuziger1 — Tue, 10 May 2022 00:05:30 GMT

@AnthonyPodesto did you ever get this issue resolved? I'm having the same thing happen on 3 out of 6 ArcGIS Pro installations. The Display XY Data tool generates a point feature class in the default gdb on 3 of this system but not the other 3. In each case I using the same file. I stripped the file down to one record with a sitenumber and x and y, that's it.

Re: Why isn't "XY table to Point" working?

AnthonyPodesto — Tue, 10 May 2022 13:25:38 GMT

Hey Randy,

I went back through my correspondence with ESRI and added most of what we went through. There was nothing that they had me check that actually made a difference in the tool working. Frustrated, I tried randomly the next day and it worked. I can't even begin to tell you what the issue was. Sorry.

--------------- Original Message ---------------
From: Esri Customer Care [customercare@esri.com]
Sent: 8/19/2020 5:14 PM
To: apodesto@ssjid.com
Subject: Esri Case #02617439 - XY Table To Point - Not Working

Hello Anthony,

Thank you for your time and patience over the call today. Following is a brief of what we discussed over the phone and performed over the screen share, in an attempt to troubleshoot and resolve the issue:

You showed me how you would right click the csv file in the contents to Display XY. We put in the required parameters for the XY Table to Point tool that came up. The tool ran successfully, however, the data could not be found in the geodatabase and the data was also not added to the map.

Further, we tried putting the output to a newly created geodatabase, however, the issue was still persistent.

We tried changing the coordinate system in the tool, but that too did not make a difference.

Next, we set the output to a file location, however, no shapefile was created.

You shared with me your csv file and I was able to get the points displayed on ArcGIS Pro 2.6 at my end.

Additionally, I shared with you an excel file but the issue was still persistent. We tried getting the tool to work for the excel and the csv in a new project as well, however, that did not resolve our issue.

We tried the same workflow in ArcMap and that worked as expected.

We performed a repair of the application, but the issue still persisted.

Later, we made use of the Make XY Event Layer Tool and we were able to get the data displayed. As discussed, the output layer created is temporary and you would have to export it, to save it on your machine. Here is the link to this tool documentation for your future reference: https://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-xy-event-layer.htm

It would be great if you could please try logging onto your machine which has ArcGIS Pro with a different user profile and then check, if you still see the same issue. Please let me know of the findings at your end.

If you have any other queries, you can reach me by either replying to this email or call me on 888-377-4575 citing the case #02617439 and I will be more than happy to assist you. Our standard support hours are from 5 AM to 5 PM Pacific Time, Monday through Friday.

Have a nice day ahead!

Regards,
Delpha
Esri Support Services
https://my.esri.com/#/support/cases/02617439
+1 (888) 377-4575 (USA)
+1 (909) 793-3774 (Outside the USA)
https://support.esri.com/en/

THE SCIENCE OF WHERE™