topic Re: Automating Quick Import in python, 9.3.1 sp2 in Data Management Questions https://community.esri.com/t5/data-management-questions/automating-quick-import-in-python-9-3-1-sp2/m-p/380507#M21668 <HTML><HEAD></HEAD><BODY><SPAN>Hello John</SPAN><BR /><BR /><SPAN>Please log a support call for this issue, it will need to be reproduced in your environment for a response.</SPAN><BR /><BR /><SPAN>regards</SPAN></BODY></HTML> Tue, 14 Aug 2012 16:14:51 GMT BruceHarold 2012-08-14T16:14:51Z Automating Quick Import in python, 9.3.1 sp2 https://community.esri.com/t5/data-management-questions/automating-quick-import-in-python-9-3-1-sp2/m-p/380506#M21667 <HTML><HEAD></HEAD><BODY><SPAN>My goal is to automate the process of importing data from Views in an Oracle Database. I have built a model with modelbuilder in ArcGIS Desktop 9.3.1 SP2. The model utilizes the quick import tool available with the Data Interoperability Extention. The model runs great in ArcCatalog, but if I export it out into python, it throws the following error:</SPAN><BR /><BR /><SPAN style="font-family:Courier New;">arcgisscripting.ExecuteError: Java reader not found -- no reader named `ORACLE8I' is available in this FME version<BR />Tool execution failed.</SPAN><BR /><BR /><SPAN>Why will the tool run great from ArcCatalog, but not execute in python? Below is the python script I am using. I will leave out the connection information contained in the parantheses of the last line.</SPAN><BR /><BR /><SPAN style="font-family:Courier New;"># Import system modules<BR />import sys, string, os, arcgisscripting<BR /><BR /># Create the Geoprocessor object<BR />gp = arcgisscripting.create()<BR /><BR /># Check out any necessary licenses<BR />gp.CheckOutExtension("DataInteroperability")<BR /><BR /># Load required toolboxes...<BR />gp.AddToolbox("D:/Program Files (x86)/ArcGIS/ArcToolbox/Toolboxes/Data Interoperability Tools.tbx")<BR /><BR /><BR /># Local variables...<BR />DPWtest_gdb = "D:\\TEMP\\DPWtest.gdb"<BR /><BR /># Process: Quick Import...<BR />gp.QuickImport_interop(</SPAN></BODY></HTML> Mon, 13 Aug 2012 18:18:47 GMT https://community.esri.com/t5/data-management-questions/automating-quick-import-in-python-9-3-1-sp2/m-p/380506#M21667 JohnBuzzard 2012-08-13T18:18:47Z Re: Automating Quick Import in python, 9.3.1 sp2 https://community.esri.com/t5/data-management-questions/automating-quick-import-in-python-9-3-1-sp2/m-p/380507#M21668 <HTML><HEAD></HEAD><BODY><SPAN>Hello John</SPAN><BR /><BR /><SPAN>Please log a support call for this issue, it will need to be reproduced in your environment for a response.</SPAN><BR /><BR /><SPAN>regards</SPAN></BODY></HTML> Tue, 14 Aug 2012 16:14:51 GMT https://community.esri.com/t5/data-management-questions/automating-quick-import-in-python-9-3-1-sp2/m-p/380507#M21668 BruceHarold 2012-08-14T16:14:51Z Re: Automating Quick Import in python, 9.3.1 sp2 https://community.esri.com/t5/data-management-questions/automating-quick-import-in-python-9-3-1-sp2/m-p/380508#M21669 <HTML><HEAD></HEAD><BODY><SPAN>ESRI Technical support was eventually able to point me to a work around that was documented in a technical article. Ultimately the real issue was having both desktop and server installed on the same machine.</SPAN><BR /><BR /><A href="http://support.esri.com/en/knowledgebase/techarticles/detail/37392">http://support.esri.com/en/knowledgebase/techarticles/detail/37392</A></BODY></HTML> Mon, 20 Aug 2012 13:42:51 GMT https://community.esri.com/t5/data-management-questions/automating-quick-import-in-python-9-3-1-sp2/m-p/380508#M21669 JohnBuzzard 2012-08-20T13:42:51Z