https://community.esri.com/t5/arcgis-pro-questions/preventing-text-from-becoming-date-type-field/m-p/1075545#M42903 <P>Hi, I'm trying to prevent ArcGIS Pro from converting text (dates) to a Date type field when running arcpy.conversion.TableToTable(). The 'from' table is a csv file.</P><P>I've tried creating a FieldMappings from the csv table, and changing the relevant FieldMap outputField type, however when I apply this using replaceFieldMap the output table ends up blank (although it does apply the field as text instead of date).</P><P>My code is something like:</P><P>fms = arcpy.FieldMappings()<BR />fms.addTable(csv_file)</P><P>fm = fms.getFieldMap(fms.findFieldMapIndex("date_field"))<BR />fname = fm.outputField<BR />fname.type = "String"<BR />fm.outputField = fname<BR />fms.replaceFieldMap(fms.findFieldMapIndex("date_field"), fm)</P><P>arcpy.conversion.TableToTable(csv_file, aprxgdb, 'out_table', '', fms)</P> Mon, 05 Jul 2021 03:19:37 GMT ToyotaT18 2021-07-05T03:19:37Z https://community.esri.com/t5/arcgis-pro-questions/preventing-text-from-becoming-date-type-field/m-p/1075545#M42903 <P>Hi, I'm trying to prevent ArcGIS Pro from converting text (dates) to a Date type field when running arcpy.conversion.TableToTable(). The 'from' table is a csv file.</P><P>I've tried creating a FieldMappings from the csv table, and changing the relevant FieldMap outputField type, however when I apply this using replaceFieldMap the output table ends up blank (although it does apply the field as text instead of date).</P><P>My code is something like:</P><P>fms = arcpy.FieldMappings()<BR />fms.addTable(csv_file)</P><P>fm = fms.getFieldMap(fms.findFieldMapIndex("date_field"))<BR />fname = fm.outputField<BR />fname.type = "String"<BR />fm.outputField = fname<BR />fms.replaceFieldMap(fms.findFieldMapIndex("date_field"), fm)</P><P>arcpy.conversion.TableToTable(csv_file, aprxgdb, 'out_table', '', fms)</P> Mon, 05 Jul 2021 03:19:37 GMT https://community.esri.com/t5/arcgis-pro-questions/preventing-text-from-becoming-date-type-field/m-p/1075545#M42903 ToyotaT18 2021-07-05T03:19:37Z