matching up fields in different tables

Discussion created by dbissey47 on May 1, 2014
Latest reply on May 1, 2014 by rfairhur24

I am going to attempt to explain my problem, and hopefully someone out there will have some insight/solutions/work arounds.

I work for a University, and we have some utility/site people go out with their GPS and shoot points pretty often when there are new projects, construction, etc.  The data dictionary that they have created has some field names that are longer than 10 characters, so when they export to shapefiles, the fields are being cut off to only contain the allowed limit.  Once they bring in the shapefile into our existing base map, they copy and then paste the new items into the existing sde feature class, the data that is contained in the truncated fields won't copy.  So, then they have to go in and redo some of the fields that didn't copy over.  I know that fields have to match between tables in order to copy/paste data, but is there some kind of script, code, or work around that can match up these fields?  I was hoping that there is some kind of field name match.  for example, something that i could use to say that create_dat from the gps export file would equal create_date in the existing feature class.

I hope that I made some sense in trying to explain this.  Any advice or help would be greatly appreciated.  I have attached an image of both tables and what data will and won't copy over.

Thanks in advance!