How To: Update shapefiles with duplicate field names
Instructions provided describe how to update shapefiles with duplicate field names. ArcIMS Author does not accept shapefiles with duplicate field names.
ArcIMS only recognizes the first ten characters of an attribute field name. This is a limitation of the dBase format.
Exporting data to a shapefile can result in duplicate field names, even if all of the field names are unique in the primary datasource.
Use the following resources to fix this problem:
- Identify duplicate field names:
Click on the link below or go to the Arcscripts section at http://arcscripts.esri.com and select ArcIMS as the software. In the list that appears there is a program named: 'Identify duplicate fields in Dbf files (use with ArcIMS)'. This program looks through the .dbf files of the shapefiles and identifies what fields are duplicated. See Related Information for more details.
- Change duplicate field names:
Click on the link below in Related Information or go to the Arcscripts section at http://arcscripts.esri.com and select ArcIMS as the software. In the list that appears there is a program named dupFixer. The program mangles duplicate field names in the dBase files to work around this problem.
- Make the changes manually by way of ArcCatalog. See the following KB article for details:
See the article: "Edit shapefile field names as uppercase for use in ArcIMS" by way of the Related Information section below.
- What characters should not be used in ArcGIS for field names and table names?
- Identify duplicate fields in Dbf files
- Edit shapefile field names for use in ArcIMS