ArcPRO 3.2 fieldmap issue

AndrewSwenson

I'm appending a csv file to a table.  In the field map some fields are coming back with the following identifier: fieldname[0:7999]

Not finding meaning. 

Not sure if it's related, but the append is stopping after 31,809 rows; the csv file has some 97,000 rows.  A previous run imported about 65,000 rows.  Any idea where to look?

 

Dale_Honeycutt

The [0:7999] refers to the number of characters in a Text field.  It means that characters zero (the first character) through 7999 (actually 8000 because it's zero-based) will be used.  You can actually edit that in the field map control, inputting your own range.

See https://pro.arcgis.com/en/pro-app/latest/help/analysis/geoprocessing/basics/field-map.htm

I suspect there's something wrong with your csv file such as extra commas, weird characters (such as CR/LF), or some other nonsense that's causing Append to act weird.  So, first, you can check that your csv file is good by using one of the many csv file checkers on the web.  I haven't used them personally, but I work with small csv files that I can (usually) visually inspect.

When I work with csv files, I typically open the .csv with Excel, save it as an Excel file (and do a quick visual inspection), then use the Excel To Table tool to create a geodatabase table.  If you go through this procedure, you may well discover the issue -- either in creating/saving the Excel file, or importing it into a geodatabase.  The Append tool has been battle tested over the years so I'd be surprised if its a software problem and not a data problem.