topic Re: Using Data Interoperability in model as scheduled process in Data Management Questions

Using Data Interoperability in model as scheduled process

ShaunWeston — Thu, 22 Sep 2011 03:57:40 GMT

I have built a model, which imports CSV files using the Quick Import tool and then copies them into a SDE database. This works fine if I run it from ArcCatalog. However if I set this process up as a scheduled service in python, I get the following error:

Could not create reader: Module 'CSV' is not licensed for use with this FME edition

Data Interoperability is licensed on ArcGIS Desktop and Server, so not sure what is going on here?

Re: Using Data Interoperability in model as scheduled process

MitaHajirakar — Tue, 27 Sep 2011 03:05:51 GMT

Hi Shaun,

Can you provide some more details about the scheduled service in Python? That sounds like something we may need to fix and we'd like to try to reproduce it in order to investigate.

In the meantime, could you try exporting the model to Python, and running the Python script from the command line?

Kind regards,
Mita Hajirakar
Safe Software, Inc.

Re: Using Data Interoperability in model as scheduled process

ShaunWeston — Tue, 27 Sep 2011 20:08:28 GMT

Hi there Mita,

Thanks for the feedback. Yeah I have it working now, by putting the entire code into one python script. It does not seem to like referencing tools with "quick import" in them.

So, doing this:

arcpy.gp.toolbox = "C:/Users/gisarc/AppData/Roaming/ESRI/Desktop10.0/ArcCatalog/MDC_Core.sde/MDC_Core.SDE.Toolbox";

arcpy.gp.RatesImport(var)

(The RatesImport is the name of the model and has the quick import tool in it)

Will cause the error in my first post.

Re: Using Data Interoperability in model as scheduled process

MitaHajirakar — Wed, 28 Sep 2011 16:42:00 GMT

Hi Shaun,

You're very welcome.

There is a known issue in ArcGIS 10.0�??s export to Python whereby the line of code required to check out the Data Interoperability extension is not added automatically - once you adds it manually it should work. The line is:

gp.CheckOutExtension("DataInteroperability")

Kind regards,
Mita Hajirakar
Safe Software, Inc.