topic Re: XY Table To Point Dropping Fields in Geoprocessing Questions

XY Table To Point Dropping Fields

Anonymous User — Thu, 10 Mar 2022 15:06:45 GMT

I have a table in a SQL2019 database that contains X, Y coordinate information and various attributes. Work is being done in ArcGIS Pro 2.7.3

Method 1

Right-click is used to Export -> Table to Point Feature Class is executed from the Database connection, the resulting feature class does not have all of the fields in the original Table.

Method 2

Table is added to map from the database connection and then XY Table to Point is run from the geoprocessing pane, the resulting feature class has all of the expected fields.

Any idea why these results are not the same? Happy to provide more information if told what could be useful.

Re: XY Table To Point Dropping Fields

DanPatterson — Thu, 10 Mar 2022 21:57:26 GMT

What are the field names that are being dropped? Reserved names? or do they have no apparent pattern?

Re: XY Table To Point Dropping Fields

Anonymous User — Thu, 10 Mar 2022 22:34:41 GMT

Yes. I meant to initially include this information. The highlighted 'Date' fields are dropping off using method one. They are maintained in method 2.

Re: XY Table To Point Dropping Fields

DanPatterson — Thu, 10 Mar 2022 23:56:15 GMT

Your second option, of not using the shortcut but the tool is the way to go. It appears from the script

"C:\... Your_Install_Folder ...\Resources\ArcToolBox\Scripts\XYTableToPoint.py"

That it use cursors to complete the work, so I would expect a better handling of dates and times. There are lots of threads on the web about how to handle datetime and csv outputs, many are language specific and many suggest converting to text fields first. I would skip doing workarounds and let the arctoolbox tools/scripts handle the work