topic Re: xy table to point doesn't work in ArcGIS Pro Questions

xy table to point doesn't work

RichardMarountas — Fri, 07 Feb 2020 18:42:30 GMT

After running the most recent update (2.5) I've had a couple of issues, such as taking a long time to load and save. The biggest problem seems to be that data I was able to plot with lat longs only yesterday. Same table, same type of data, and I now get the error below:

Running script XY Table To Point...

Failed script XY Table To Point...

Traceback (most recent call last):   File "c:\program files\arcgis\pro\Resources\ArcToolbox\Scripts\XYTableToPoint.py", line 183, in <module>     xy_table_to_points(in_table, output_fc, x_field, y_field, z_field, coordinate_system)   File "c:\program files\arcgis\pro\Resources\ArcToolbox\Scripts\XYTableToPoint.py", line 120, in xy_table_to_points     table_empty = arcpy.management.CreateTable(r"memory", "table_empty_{}".format(ts), in_table)   File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 19745, in CreateTable     raise e   File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 19742, in CreateTable     retval = convertArcObjectToPythonObject(gp.CreateTable_management(*gp_fixargs((out_path, out_name, template, config_keyword), True)))   File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 511, in <lambda>     return lambda *args: val(*gp_fixargs(args, True)) arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.ERROR 000732: Template Table Name: Dataset deaths$ does not exist or is not supported Failed to execute (CreateTable).

Failed to execute (XYTableToPoint).

Any help greatly appreciated.

Re: xy table to point doesn't work

KoryKramer — Fri, 07 Feb 2020 18:45:49 GMT

This should be asked in the ArcGIS Pro‌ space.

Re: xy table to point doesn't work

AmandaKochanek — Wed, 12 Feb 2020 20:35:05 GMT

Richard, I had the same experience. I had a coworker who had not yet updated send me a copy of their file from: C:\Program Files\ArcGIS\Pro\Resources\ArcToolBox\Scripts\XYTableToPoint.py

It then worked again....

Re: xy table to point doesn't work

RichardMarountas — Thu, 13 Feb 2020 14:32:46 GMT

Thanks Amanda…that worked perfectly!

From: Amanda Kochanek <geonet@esri.com>

Sent: Wednesday, February 12, 2020 3:36 PM

To: Richard Marountas <rmarountas@schd.org>

Subject: Re: - Re: xy table to point doesn't work

GeoNet, The Esri Community | GIS and Geospatial Professional Community

<https://community.esri.com/?et=watches.email.thread>

Re: xy table to point doesn't work

reply from Amanda Kochanek

<https://community.esri.com/people/kochanek?et=watches.email.thread> in *ArcGIS

Pro* - View the full discussion

<https://community.esri.com/message/908391-re-xy-table-to-point-doesnt-work?commentID=908391&et=watches.email.thread#comment-908391>

Re: xy table to point doesn't work

KoryKramer — Tue, 18 Feb 2020 14:07:29 GMT

Richard Marountas‌ and Amanda Kochanek‌ if you are able to share examples of tables that fail with the Pro 2.5 XY Table to Point tool, could you please send them to kkramer@esri.com? There were changes made at 2.5, so if there are tables that will cause the tool to fail, we'd be very interested in investigating those. Thank you in advance!

FYI Drew Flater‌

Re: xy table to point doesn't work

RichardMarountas — Tue, 18 Feb 2020 15:12:12 GMT

Hi Kory,

Unfortunately the table contains person-level data and is confidential. I

was using a Microsoft Excel table, which I had not had any problems with

previously. I turned it into a dbase file because I was on a deadline,

which did work, but obviously wasn’t a long-term solution. Thankfully

Amanda Kochanek’s solution did work. Hope this helps…

Rich

From: Kory Kramer <geonet@esri.com>

Sent: Tuesday, February 18, 2020 9:08 AM

To: Richard Marountas <rmarountas@schd.org>

Subject: Re: - Re: xy table to point doesn't work

GeoNet, The Esri Community | GIS and Geospatial Professional Community

<https://community.esri.com/?et=watches.email.thread>

Re: xy table to point doesn't work

reply from Kory Kramer

<https://community.esri.com/people/KKramer-esristaff?et=watches.email.thread>

in ArcGIS Pro - View the full discussion

<https://community.esri.com/message/909582-re-xy-table-to-point-doesnt-work?commentID=909582&et=watches.email.thread#comment-909582>

Re: xy table to point doesn't work

DrewFlater — Tue, 18 Feb 2020 16:01:20 GMT

Hi Richard Marountas, I understand the confidentiality of your data. We do have automated tests for XY Table To Point using both XLXS and XLS data, and those test cases are passing in 2.5 so we're obviously missing some different column format or data contents.

If you copy the header row PLUS the first data row into a new XLSX then use that as input, does the tool still fail? If so, can you replace the values with non-personally identifiable data and send that copy to us?

If this error is widespread we want to understand and fix the problem in a patch so users can take advantage of the new 2.5 version of the tool.

Re: xy table to point doesn't work

DrewFlater — Tue, 18 Feb 2020 21:49:49 GMT

Hi Amanda Kochanek‌, since Richard cannot share his data due to confidentiality, I'm hoping you might be able to share the data where you experienced the failure with XY Table To Points, or perhaps follow the steps I gave Richard:

If you copy the header row PLUS the first data row into a new XLSX then use that as input, does the tool still fail? If so, can you replace the values with non-personally identifiable data and send that copy to us?
If this error is widespread we want to understand and fix the problem in a patch so users can take advantage of the new 2.5 version of the tool.

Re: xy table to point doesn't work

marjorie_jerez — Fri, 20 Mar 2020 02:27:40 GMT

Kory Kramer‌ Are you still looking for tables that make the XY Table to Point to fail? I'm running ArcGIS Pro 2.5 and currently running into the same error but different message and it deletes the table after the tool fails and replaces it with an xml file.

Traceback (most recent call last):
File "c:\program files\arcgis\pro\Resources\ArcToolbox\Scripts\XYTableToPoint.py", line 183, in <module>
xy_table_to_points(in_table, output_fc, x_field, y_field, z_field, coordinate_system)
File "c:\program files\arcgis\pro\Resources\ArcToolbox\Scripts\XYTableToPoint.py", line 121, in xy_table_to_points
arcpy.Merge_management([points_empty, table_empty], output_fc)
File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 5619, in Merge
raise e
File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\management.py", line 5616, in Merge
retval = convertArcObjectToPythonObject(gp.Merge_management(*gp_fixargs((inputs, output, field_mappings, add_source), True)))
File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 511, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 999999: Something unexpected caused the tool to fail. Contact Esri Technical Support (http://esriurl.com/support) to Report a Bug, and refer to the error help for potential solutions or workarounds.
Failed to execute (Merge).
Failed to execute (XYTableToPoint).

Re: xy table to point doesn't work

KoryKramer — Fri, 20 Mar 2020 13:04:56 GMT

Hi Marjorie Jerez‌! Yes, please send the table that is failing to kkramer@esri.com.

I'll get it to the team to investigate.

Thanks again!

Re: xy table to point doesn't work

PhilCrossley1 — Sat, 13 Nov 2021 19:03:17 GMT

I'm having the same problem: a new feature class is generated but no point records included in the feature class. If I run the tool with the same csv table within Pro (v. 2.8) it works perfectly; but if I try to run the tool within an arcpy script, it generates an 'invalid geometry' error. Am attaching the test csv file that fails..Will greatly appreciate any help!

This is my script:

import arcpy
from arcpy import env
env.workspace = r"E:\advAppScripting\testing\hawaii"
env.overwriteOutput = True
infile = r"E:\advAppScripting\testing\hawaii\testpoints3.csv"

try:
    arcpy.CreateFileGDB_management(r"E:\advAppScripting\testing\hawaii", "testing")
    # had originaly tried to just create a .shp file, but after it failed, changed to creating a featureclass
    # hence the need to create a new gdb first
    arcpy.XYTableToPoint_management(infile, r"E:\advAppScripting\testing\hawaii\testing.gdb\myNEWpoints",
                                    "EASTING",   "NORTHING")
    # the tool help claims you can specify the spatial ref. as a tool parameter, but when I do, script fails with
    # 'not a field' error meesage, so switched to definine projection as a separate step
    arcpy.DefineProjection_management(r"E:\advAppScripting\testing\hawaii\testing.gdb\myNEWpoints",
                                      arcpy.SpatialReference(26904))
    # this script creates a new gdb and a new feature class with the correct spatail ref. BUT no points are included
    # and a 'invalid geometry error is generated

Re: xy table to point doesn't work

salah_aj — Wed, 12 Jul 2023 16:20:43 GMT

Any updates about this error? I am also getting an error message as below

Traceback (most recent call last):
File "c:\program files\arcgis\pro\Resources\ArcToolbox\scripts\XYTableToPoint.py", line 276, in <module>
", ".join(empty_out_bounds)))
File "c:\program files\arcgis\pro\Resources\ArcToolbox\scripts\XYTableToPoint.py", line 262, in xy_table_to_points
arcpy.AddIDMessage("WARNING", 1086, str(e).split("[")[1][:-1])
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 4693, in CopyFeatures
raise e
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 4690, in CopyFeatures
retval = convertArcObjectToPythonObject(gp.CopyFeatures_management(*gp_fixargs((in_features, out_feature_class, config_keyword, spatial_grid_1, spatial_grid_2, spatial_grid_3), True)))
File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda>
return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: ERROR 000210: Cannot create output C:\Brown\pop exposure\GIS\SSLS1.shp
Failed to execute (CopyFeatures).

Failed script XY Table To Point...
Failed to execute (XYTableToPoint).