topic Re: XYTableToPoint Error When Trying to Append Data in Python Questions

XYTableToPoint Error When Trying to Append Data

GRmapper — Mon, 14 Feb 2022 14:32:50 GMT

Hello.

Every day I get a feed of the previous days data which I format into a .csv which I then want to update in a geodatabase. This is a multi scipt process that works very well until I get to the appending into the geodatabase. What is very strange up until a weel ago it worked perfectly. Now I get a Failed To Execute (XYTableToPoint) message.

I apologize for the heavily redacted script (top of image) and log (bottom of image).

I'm interested to see if anyone sees a glaring issue particularly as it worked a week ago, the .py file data hasn't changed, when I open the geodatabase the layer is there and the fields it says aren't in the table are in the table.

I'm very sure I'm actualling looking at the correct file unless a temp file is getting produced.

All the best,

Re: XYTableToPoint Error When Trying to Append Data

HuubZwart — Mon, 14 Feb 2022 17:14:05 GMT

Are you sure your CSV is still (formatted in) the same (way)? It looks like the field you are expecting lat/long in does not excist in the table... Default (system) separator still the same?

Re: XYTableToPoint Error When Trying to Append Data

GRmapper — Mon, 14 Feb 2022 21:24:22 GMT

Thank you for the reply.

That's what I would have thought as well but the csv ( I've attached it) has the seemingly correct field names in it. By default system separator you mean like a comma, etc? Not sure about that.

I'm still searching.

Thanks,

Re: XYTableToPoint Error When Trying to Append Data

HuubZwart — Tue, 15 Feb 2022 11:32:59 GMT

It looks like the ArcGIS csv parser doesn't like the asterisks in your csv, when I remove them it does load correctly