3 replies to this topic

[Robert2009]

Is there a way around that I can copy code value to Domain to multiple geodatabases ? Right now I had to do it by one at a time.

Thanks,
Robert

[Ninomax]

Is there a way around that I can copy code value to Domain to multiple geodatabases ? Right now I had to do it by one at a time.

Thanks,
Robert

Just a quick thinking,
- prepare a table of code value domain in dbf format
- Put all Geodatabases into one folder
- use Python scripting with a loop function and TableToDomain tool
See a quick modified script from ArcGIS help below:

# Purpose: Update an attribute domain to constrain valid pipe material values



# Create the Geoprocessor object

import arcgisscripting

gp = arcgisscripting.create()



try:

	# Set the workspace (to avoid having to type in the full path to the data every time)

	gp.Workspace = r"C:\FolderOfGeodatabases"

	ListOfGeo = gp.listworkspaces("","Access")

	 for Geo in ListOfGeo:

		gp.TableToDomain("diameter.dbf", "code", "descript", Geo, "diameters", "Valid pipe diameters") 



except:

	# If an error occurred while running a tool, print the messages.

	print gp.GetMessages()

Hope this helps!

[Robert2009]

Is this for personal or file geodatabase and yes i have them in one folder. How do I run this script in python ?


Thanks.

[Ninomax]

Is this for personal or file geodatabase and yes i have them in one folder. How do I run this script in python ?


Thanks.

"Access" means Personal Geodatabase. Basically, the script is correct but you have to modify some inputs such as name of table, code value.
ESRI writes help documents very well, you can check them for more details.