Calculate fields when importing table

Bud — Mon, 28 Oct 2024 14:57:26 GMT

ArcGIS Pro 2.9.5; Oracle 18c 10.7.1 EGDB:

When importing a .CSV into an enterprise geodatabase as a standalone table:

There are dates stored as text like this in the CSV (8 fields):

Nov 7, 2023, 9:55 AM
Sep 23, 2022, 1:11 PM
May 9, 2023, 6:56 AM

As part of the import process (Table to Geodatabase), I want to translate the text to true date values so that they can be loaded into date fields in the EGDB table. I want to do this in a single tool. For example, in Table to Geodatabase, there would be a list of fields, and I'd load a field calculator script, arcade expression, or SQL field expression into each field that needs to be translated.

Otherwise, it is unnecessarily cumbersome to load data into a table if the data needs to be translated first.

idea Calculate fields when importing table in ArcGIS Pro Ideas

Calculate fields when importing table