Latest Contributions by WesMiller

Obs_data_temp LIKE '%0%' OR Obs_data_temp LIKE '%1%' OR Obs_data_temp LIKE '%2%' OR Obs_data_temp LIKE '%3%' OR Obs_data_temp LIKE '%4%' OR Obs_data_temp LIKE '%5%' OR Obs_data_temp LIKE '%6%' OR Obs_data_temp LIKE '%7%' OR Obs_data_temp LIKE '%8%' OR Obs_data_temp LIKE '%9%' ... View more

Adrian, You could absolutely over complicate if you wanted. Get your domain Validate your excel against your domain Fix errors Join the tables Query for changes originField <> updatedField Calculate originField to match updatedField #import module import arcpy #get the feature class we want the domains for fc = arcpy.GetParameterAsText(0) desc = arcpy.Describe(fc) desc1 = arcpy.Describe(desc.path) #print desc1.datasetType if desc1.dataType == 'FeatureDataset':     fcworkspace = desc1.path else:     fcworkspace = desc.path #List the domains domains = arcpy.da.ListDomains(fcworkspace) #List the fields fields = arcpy.ListFields(fc) domainList = [] #Loop through the fields, determine if they have a domain and add #those with domains to the dictionary and assign it a default value for field in fields:     if field.domain:         domainList.append(field.domain) #Create a dictionary to hold the data domaindict = {} #Loop through domains and grab the coded values for feature class for domain in domains:     if domain.domainType =='CodedValue':         if domain.name in domainList:             domaindict[domain.name]=domain.codedValues textline = "" for key,value in domaindict.iteritems():     textline = textline + key + '\n'     for k,v in value.iteritems():         textline = textline + '\t' + str(k) + '\t:\t' +str(v) + '\n' arcpy.AddMessage(textline) ... View more