Field mapping 10.3.1

PacoAlverez — Sat, 11 Dec 2021 16:40:14 GMT

i upgraded from 10.2.2 to 10.3.1 and now my script does not run properly. It runs all they way and doesn't give an error.

The join runs fin and it creates the feature class but when i check feature class "NotifiLotsTest" all the fields are Null.

It ran fine in 10.2.2 so i am not sure what's going on with it now, something to do with the field mapping???.. help please i am lost it's a simple script but i can't figure out what's going on....

arcpy.env.qualifiedFieldNames = False
arcpy.env.overwriteOutput = True

Taxparcels = r"Database Connections\Taxparcels"
Table = r"Database Connections\Table"

fc = "C:/Temp/Test.gdb/NotifLotsTest"

#Delete feature class if it exists
if arcpy.Exists(fc):
   arcpy.Delete_management(fc)

fc1 = "C:/Temp/Test.gdb/NotifTest"

#Delete feature class if it exists
if arcpy.Exists(fc1):
   arcpy.Delete_management(fc1)   

# Process: Make Feature Layer
arcpy.MakeFeatureLayer_management(Taxparcels, "In_memory\TaxPar")

# Process: Add Join
arcpy.AddJoin_management("In_memory\TaxPar", "ACCOUNT", Table, "Acct")

#check to make sure Joined Feature class is being generated
arcpy.FeatureClassToFeatureClass_conversion("In_memory\TaxPar","C:/Temp/Test.gdb/", "NotifTest")

TaxPar1 = "In_memory\TaxPar"
#arcpy.MakeFeatureLayer_management("C:/Temp/Test.gdb//NotifTest",TaxPar1)

#Field Mapping
def Layers0(TaxPar1):
    FieldMapString = "" \
                + """DXF_TEXT "DXF_TEXT" true true false 20 Text 0 0 ,First,#,""" + TaxPar1 + """,DXF_TEXT,-1,-1;"""\
                + """ACCOUNT "ACCOUNT" true true false 11 Text 0 0 ,First,#,""" + TaxPar1 + """,ACCOUNT,-1,-1;"""\
                + """OwnerName "OwnerName" true true false 100 Text 0 0 ,First,#,""" + TaxPar1 + """,OwnerName,-1,-1;"""\
                + """Address "Address" true true false 64 Text 0 0 ,First,#,""" + TaxPar1 + """,Address,-1,-1;"""\
                + """City "City" true true false 32 Text 0 0 ,First,#,""" + TaxPar1 + """,City,-1,-1;"""\
                + """State "State" true true false 4 Text 0 0 ,First,#,""" + TaxPar1 + """,State,-1,-1;"""\
                + """ZipCode "ZipCode" true true false 10 Text 0 0 ,First,#,""" + TaxPar1 + """,ZipCode,-1,-1;"""\

    fieldmappings = arcpy.FieldMappings()
    fieldmappings.loadFromString(FieldMapString)
    return fieldmappings
def main(args=None):
        if args is None:
                args = sys.argv

# Process: Feature Class to Feature Class
arcpy.FeatureClassToFeatureClass_conversion(TaxPar1, "C:/Temp/Test.gdb/", "NotifLotsTest", "", Layers0(TaxPar1),"")


‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Field mapping 10.3.1

DanPatterson_Retired — Tue, 27 Sep 2016 20:57:17 GMT

quick question... this ... FieldMapString = "" \ ...is that supposed to be... FieldMapString = """ \

Re: Field mapping 10.3.1

PacoAlverez — Tue, 27 Sep 2016 21:09:44 GMT

I have double quotations.

Re: Field mapping 10.3.1

PacoAlverez — Tue, 27 Sep 2016 22:37:54 GMT

If i add more than two quotations marks i get invalid Syntax. Did something change for filed mapping in 10.3.1?

I am confused as to why this simple script doesn't run.

Re: Field mapping 10.3.1

DarrenWiens2 — Sat, 11 Dec 2021 16:40:17 GMT

Not sure if this is the issue, but can you try it with raw notation strings? I'm sure I've had issues not using raw notation with the in_memory workspace. And, '\T' is pretty close to '\t' (tab).

r"in_memory\TaxPar"
vs.
"In_memory\TaxPar"

Re: Field mapping 10.3.1

PacoAlverez — Wed, 28 Sep 2016 21:45:28 GMT

what i found was i had to include line 29, make feature layer from the feature class that was created after the join. I guess i can't use in_memory in the field mapping...? I swear it worked in 10.2.2

topic Re: Field mapping 10.3.1 in Python Questions

Field mapping 10.3.1

Re: Field mapping 10.3.1

Re: Field mapping 10.3.1

Re: Field mapping 10.3.1

Re: Field mapping 10.3.1

Re: Field mapping 10.3.1