topic Importing CSV — Is there a GP tool that correctly interprets values when setting field data types? in ArcGIS Pro Questions

Importing CSV — Is there a GP tool that correctly interprets values when setting field data types?

Bud — Fri, 25 Oct 2024 10:22:52 GMT

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB

I'm trying to import a CSV into an enterprise geodatabase: Catalog > right-click a .SDE connection > Import > Table > Table to Table GP tool

Unfortunately, Table to Table is doing a poor job of interpreting the values when setting the field data types in the new table.

For example, in a number field in the CSV, the first value is 0, and subsequent values have decimal places like 1.234. The new table's data type is automatically set to an integer due to the 0, so when loading the data, the decimal places in the other numbers are getting truncated (or rounded?) to integers, which is incorrect.

Is there a different tool that does a better job?

Re: Importing CSV — Is there a GP tool that correctly interprets values when setting field data types?

Bud — Fri, 25 Oct 2024 10:23:51 GMT

It looks like Table to Geodatabase might be doing a better job at interpreting the values when setting field types.

The numbers are interpreted as doubles; a double field is created, not an integer, which is correct. The numbers with decimal places are loaded into the new table without issue.

Re: Importing Table — Is there a GP tool that correctly interprets values when setting field data types?

BarryNorthey — Fri, 25 Oct 2024 01:41:14 GMT

This link might be relevant.