nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Getting ObjectID's using Fieldmapping in FeatureClasstoFeatureClass tool

MarcCusumano

I have field mapping working for all fields but when I try to pull the ObjectID's in I get an error message:

"FieldMappings: Error in getting field map from field mapping for GetFieldMap"

Here is my code:

CONVERSION_InputPrefix = "Database Connections\\Sun120 - 5151.sde\\" CONVERSION_CPTestPoint = CONVERSION_InputPrefix + "CONVERSION.GasDataset\\CONVERSION.CPTestPoint"   try:     fieldmappings = arcpy.FieldMappings()     fieldmappings.addTable(CONVERSION_CPTestPoint)         fieldmap_CPTESTPOINT = fieldmappings.getFieldMap(fieldmappings.findFieldMapIndex("OBJECTID"))     fieldmap_CPTESTPOINT.addInputField(CONVERSION_CPTestPoint, "OBJECTID")      fieldmap_CPTESTPOINT = fieldmappings.getFieldMap(fieldmappings.findFieldMapIndex("GAS_CORR_TEST_STA_NO"))     fieldmap_CPTESTPOINT.addInputField(CONVERSION_CPTestPoint, "GAS_CORR_TEST_STA_NO")     fieldmap_CPTESTPOINT = fieldmappings.getFieldMap(fieldmappings.findFieldMapIndex("STATE_MCD"))     fieldmap_CPTESTPOINT.addInputField(CONVERSION_CPTestPoint, "STATE_MCD")     fieldmap_CPTESTPOINT = fieldmappings.getFieldMap(fieldmappings.findFieldMapIndex("DISTRICT_NAME"))     fieldmap_CPTESTPOINT.addInputField(CONVERSION_CPTestPoint, "DISTRICT_NAME")      fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("ANCILLARYROLE"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("ENABLED"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("CREATIONUSER"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("DATECREATED"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("DATEMODIFIED"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("LASTUSER"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("LEGACYID"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("INSTALLATIONDATE"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("COMMENTS"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("LOCATIONDESCRIPTION"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("OPERATINGSTATUS"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("PROPERTYUNITCODE"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("SUBTYPECD"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("SYMBOLROTATION"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("GASTRACEWEIGHT"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("ISR_NO"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("ISR_SEQ_NO"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("ISR_EXTERNAL_NO1"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("SAP_EQUIPMENT_NO"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("SAP_FUNCTIONAL_LOCATION"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("TESTPOINTTYPE"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("WIRECOUNT"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("APPT_NO"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("STREET_NAME1"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("STREET_NAME2"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("ZIP_CODE"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("DELETE_INDICATOR"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("CATHODICPROTECTIONDEVICE"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("CIVIC_NO"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("CPSYSTEMOBJECTID"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("CONVERSIONID"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("STR_SEQ_ID"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("IMAGEID"))     fieldmappings.removeFieldMap(fieldmappings.findFieldMapIndex("IMAGELINK"))      except Exception as e:     print e     logging.error(": Error setting up field mappings: %s" %(str(e)))     msgTxtErr = msgTxtErr + "\n" + "* Error setting up field mappings: " + str(e)     flMail(from_addr, to_addr, msgTxtErr)

Again if I comment out the ObjectID portion the code runs fine and I get the fields I want in the output. What do I have to do to get the existing ObjectID

Trouver plus de publications taguées avec

Accepted answers

MathewCoyle

This should be all you need if you are going that route.

fld_OBJID.type = "Long"

All comments

MarcCusumano

This should be all you need if you are going that route.
fld_OBJID.type = "Long"

This worked great, thank you!

MathewCoyle

This should be all you need if you are going that route.

fld_OBJID.type = "Long"

MarcCusumano

Matt, I'm having trouble understanding your solution in that thread because it is much more elaborate than what I'm trying to do. I just need to set one field to LONG or TEXT.

MathewCoyle

Yes you'll need to specify the type due to some quirks in how field mapping is implemented by Esri through arcpy. A long or double should suit your needs.

I go through the same issue in this thread.

http://forums.arcgis.com/threads/72269-field-map-problems

ChrisSnyder

Did you define your new OID field as a Short Integer? If so, make sure it's a Long Integer.

MarcCusumano

I used an example in the thread you provided, and it seems to be working. But now it is failing on OID 32768.

ERROR 001156: Failed on input OID 32768, could not write value '32768' to output field O_OID
Failed to execute (FeatureClassToFeatureClass).

try:
    fieldmappings = arcpy.FieldMappings()
    fieldmappings.addTable(CONVERSION_CPTestPoint)

    fldmap_OBJID = arcpy.FieldMap()
    fldmap_OBJID.addInputField(CONVERSION_CPTestPoint, "OBJECTID")
    fld_OBJID = fldmap_OBJID.outputField
    fld_OBJID.name = "O_OID"
    fldmap_OBJID.outputField = fld_OBJID
    fieldmappings.addFieldMap(fldmap_OBJID)

Obvoiusly this new "O_OID" field is a short integer, how can I specify it as a LONG in the fieldmappings?

MathewCoyle

Here's a thread that goes through several examples of field mapping.

http://forums.arcgis.com/threads/33060-field-mapping-in-python-for-ArcGIS-10

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.