I've been successfully running the following python script which runs a Spatial ETL Tool that I have created in a custom toolbox.
# ---------------------------------------------------------------------------
# daily_etl_repln.py
# Created on: Mon Mar 30 2009 02:38:54 PM
# (generated by ArcGIS/ModelBuilder)
# ---------------------------------------------------------------------------
# Import system modules
import sys, string, os, arcgisscripting
# Create the Geoprocessor object
gp = arcgisscripting.create()
# Load required toolboxes...
gp.AddToolbox("Z:/ESRI/Data/Replication/Replication.tbx")
gp.AddToolbox("C:/Program Files/ArcGIS/Desktop10.0/ArcToolbox/Toolboxes/Data Management Tools.tbx")
gp.AddToolbox("C:/Program Files/ArcGIS/Desktop10.0/ArcToolbox/Toolboxes/Analysis Tools.tbx")
gp.CheckOutExtension("DataInteroperability")
gp.overwriteoutput = 1
# Local variables...
Destination_Geodatabase_ = "Z:\\ESRI\\Data\\test_Basemap.gdb"
Destination_Geodatabase___2_ = "Z:\\ESRI\\Data\\Basemap.gdb"
Destination_Geodatabase___3_ = "Z:\\ESRI\\Data\\Community_Facilities_Services.gdb"
Destination_Geodatabase___4_ = "Z:\\ESRI\\Data\\Surveying.gdb"
Destination_Geodatabase___5_ = "Z:\\ESRI\\Data\\Water_Reticulation.gdb"
Destination_Geodatabase___6_ = "Z:\\ESRI\\Data\\Infrastructure.gdb"
Destination_Geodatabase___7_ = "Z:\\ESRI\\Data\\Stormwater.gdb"
Destination_Geodatabase___8_ = "Z:\\ESRI\\Data\\Sewer_Reticulation.gdb"
Destination_Geodatabase___9_ = "Z:\\ESRI\\Data\\LEP2000_Gazetted.gdb"
Destination_Geodatabase___10_ = "Z:\\ESRI\\Data\\DCP_Consolidated.gdb"
Destination_Geodatabase___11_ = "Z:\\ESRI\\Data\\Planning_Section94.gdb"
Destination_Geodatabase___12_ = "Z:\\ESRI\\Data\\Draft_LEP09_CEN.gdb"
Destination_Geodatabase___13_ = "Z:\\ESRI\\Data\\Draft_LEP08_Constraints.gdb"
Destination_Geodatabase___14_ = "Z:\\ESRI\\Data\\Draft_LEP08.gdb"
### Process: DAILY: Oracle to FGDB Replication...
gp.toolbox = "Z:/ESRI/Data/Replication/Replication.tbx";
gp.SpatialETLTool("gisp", Destination_Geodatabase_, Destination_Geodatabase___2_, Destination_Geodatabase___3_, Destination_Geodatabase___4_, Destination_Geodatabase___5_, Destination_Geodatabase___6_, Destination_Geodatabase___7_, Destination_Geodatabase___8_, Destination_Geodatabase___9_, Destination_Geodatabase___10_, Destination_Geodatabase___11_, Destination_Geodatabase___12_, Destination_Geodatabase___13_, Destination_Geodatabase___14_,"gisp")
print "ETL Tool finished"
I have updated the paths for the system toolboxes for arcGIS 10.0, but still get the following error:
Traceback (most recent call last):
File "C:\Python26\ArcGIS10.0\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", line 325, in RunScript
exec codeObject in __main__.__dict__
File "Z:\ESRI\Data\Replication\daily_etl_repln_arcgis10.py", line 41, in <module>
gp.SpatialETLTool("gisp", Destination_Geodatabase_, Destination_Geodatabase___2_, Destination_Geodatabase___3_, Destination_Geodatabase___4_, Destination_Geodatabase___5_, Destination_Geodatabase___6_, Destination_Geodatabase___7_, Destination_Geodatabase___8_, Destination_Geodatabase___9_, Destination_Geodatabase___10_, Destination_Geodatabase___11_, Destination_Geodatabase___12_, Destination_Geodatabase___13_, Destination_Geodatabase___14_,"gisp")
AttributeError: Object: Tool or environment <s> not found.
Any ideas?
Thanks.Jane
