I am attempting to search directories and sub directories for file in 'name' and return full file path of found file in a new field. When I print the value of variable 'string' it prints the desired results However after the script runs the field is populated with a single value instead of unique values for each subsequent row. Can anyone tell me why this is?
# Set local variable
source = 'R:\\'
fc = "I14__ATTACH_TEST"
field = "ATT_NAME"
addfieldName = "fullPath"
fieldLength = 200
# Add field
arcpy.AddField_management(fc, addfieldName, "TEXT", "", "", fieldLength)
### Attempting to search directories and sub directories for file in 'name'
### and return full file path of found file (name)
sc = arcpy.SearchCursor(fc)
names = []
for scrow in sc:
names.append(scrow.getValue(field))
for root, dirnames, filenames in os.walk(source):
for filename in filenames:
if filename in names:
string = os.path.join(root, filename)
cursor = arcpy.UpdateCursor(fc)
row = cursor.next()
while row:
# field2 will be equal to field1 multiplied by 3.0
row.setValue(addfieldName, string)
cursor.updateRow(row)
row = cursor.next()
