topic Re: Running Spatial ETL (10.1) tools from Python in Data Management Questions

Running Spatial ETL (10.1) tools from Python

StephanieWidas — Fri, 31 Aug 2012 14:40:27 GMT

I am trying to run several spatial ETL tools from a python script. The tools run fine in Model Builder, but not when called from Python. I receive the following error: "AttributeError: 'module' object has no attribute..."

I found the following thread:
http://support.esri.com/en/knowledgebase/techarticles/detail/38563

I added the code that it suggested to check for license errors. It raises the license error and tells me that the license is unvailable. I added a line to check the status of the extension - arcpy.CheckExtension("DataInteroperability") - and found that it was NotLicensed.

I'm running Windows Server 2008 R2, with ArcGIS Desktop and Server 10.1. My Data Interoperablity license is only for Desktop, not Server.

I tried setting a Windows Environment variable DI_DESKTOP to force the use of the desktop license as described here - http://support.esri.com/en/knowledgebase/techarticles/detail/37392. Not exactly the same problem, but thought it was worth a try. It didn't fix the problem.

Does anyone know what I need to do so that I can run the ETL tools from Python? Is it a conflict with server and desktop?

Thanks,
Stephanie

Re: Running Spatial ETL (10.1) tools from Python

StephanieWidas — Fri, 31 Aug 2012 19:13:28 GMT

Additional info:
When I use arcpy.ProductInfo() it returns ArcServer.

Can I add something to my script to just use a Desktop license instead? I tried using "import arcview" and "import arcinfo" statements before importing arcpy, but that just gives me an error - - RuntimeError: ERROR 999999: Error executing function.

We really need to be able to run these ETLs from a scheduled Python script on a server that also has ArcGIS Server installed on it. Is there a way to make this work? Hopefully I'm just missing something obvious.

Thanks again,
Stephanie

Re: Running Spatial ETL (10.1) tools from Python

SrijanaTuladhar — Thu, 14 May 2015 17:58:54 GMT

Hi Stephanie,

I have a same question, I came across your thread regarding converting the ETL tool into python script and schedule to run automatically in daily or weekly basis. Did you find a solution? If so, would you mind helping us. Thanks in advance.