Test Description
To export data to a Shape file and force the Field Names above the 10 character limit in the dbase file and observe what the resulting Field Names are in the output dbase file.
Test 1 - Numerical changes to the Field Names
During export, I modified the Field Names in the export dialog, appending numbers to selected Fields to exceed the 10 character limit
The resulting Field Names in the dbase file...
For some reason the Field Names have also been appended with an additional letter (N or C), corresponding to the Field Type, "C" for character or "N" for number.
| Original Field Name | Modified Field Name for Export | Resulting Field Name in dbase File |
| COMM_BOARD | COMM_BOARD1 | COMM_BOARD1N |
| COM_BOARD | COM_BOARD23 | COM_BOARD23C |
| CREATED_DA | CREATED_DA2 | CREATED_DA2C |
| DATE_CREAT | DATE_CREAT1 | DATE_CREAT1C |
Test 2 - Alphabetical changes to the Field Names
During export, I modified the Field Names in the export dialog, appending letters to selected Fields to exceed the 10 character limit
The resulting Field Names in the dbase file...
Again, for some reason the Field Names have also been appended with an additional letter (N or C), corresponding to the Field Type, "C" for character or "N" for number.
| Original Field Name | Modified Field Name for Export | Resulting Field Name in dbase File |
| COMM_BOARD | COMM_BOARDA | COMM_BOARDAN |
| COM_BOARD | COM_BOARDAB | COM_BOARDABC |
| CREATED_DA | CREATED_DAC | CREATED_DACC |
| DATE_CREAT | DATE_CREATD | DATE_CREATDC |
Conclusion: well at least it's consistent... looking forward to the SHP Import/Export Improvements in the 2009 release of Map 3D
Recent Comments