topic Re: arcpy.ExtractData_production does not work in Python GUI? in Python Questions

arcpy.ExtractData_production does not work in Python GUI?

ThomasColson — Sat, 11 Dec 2021 17:16:09 GMT

>>> arcpy.ExtractData_production("'C:\\Temp\\Python\\GRSM_20140326075058.gdb\\Boundaries_And_AOIs\\grsm_bndry_polygon'","C:\\Temp\\Python\\GRSM_20140326075333.gdb","DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","")

 
<Result 'C:\\Temp\\Python\\GRSM_20140326075333.gdb'>

Works fine in the Arc Map Python window.

Per the ESRI help for Extract Data (Production Mapping) one could conclude that

>>> import arcpy
>>> arcpy.CheckOutExtension("Foundation")
u'CheckedOut'
>>> arcpy.ExtractData_production("C:/Temp/Python/GRSM_20140326075058.gdb/Boundaries_And_AOIs/grsm_bndry_polygon","C:/Temp/Python/GRSM_20140326075333.gdb","DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","")

Would work as well in Python Shell.

Nope.

Traceback (most recent call last):
  File "<pyshell#26>", line 1, in <module>
    arcpy.ExtractData_production("C:/Temp/Python/GRSM_20140326075058.gdb/Boundaries_And_AOIs/grsm_bndry_polygon","C:/Temp/Python/GRSM_20140326075333.gdb","DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","")
AttributeError: 'module' object has no attribute 'ExtractData_production'

Tried numerous variations of back, forward, double-slash as per http://resources.arcgis.com/en/help/main/10.1/index.html#//002z0000000r000000

None worked.

So what special trick is required to get arcpy.ExtractData_production to work in Python Shell?

Re: arcpy.ExtractData_production does not work in Python GUI?

JamesCrandall — Sat, 11 Dec 2021 17:16:11 GMT

Just a shot in the dark, but maybe problem is with escape characters in your string paths? Or perhaps not having the extension available? Not sure but you can deal with these possible issues:


in_ds = r'C:\Temp\Python\GRSM_20140326075058.gdb\Boundaries_And_AOIs\grsm_bndry_polygon'
target_db = r'C:\Temp\Python\GRSM_20140326075333.gdb'

### see if spatial analyst extension is available for use
availability = arcpy.CheckExtension("Foundation")
if availability == "Available":
   arcpy.CheckOutExtension("Foundation")
   arcpy.AddMessage("Foundation Ext checked out")
else:
   arcpy.AddError("%s extension is not available (%s)"%("Foundation Extension",availability))
   arcpy.AddError("Please ask someone who has it checked out but not using to turn off the extension")
   return

arcpy.ExtractData_production(in_ds,target_db,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","")

#return the extension
arcpy.CheckInExtension("Foundation")

Re: arcpy.ExtractData_production does not work in Python GUI?

ThomasColson — Sat, 11 Dec 2021 17:16:14 GMT

I was unable to get

availability = arcpy.CheckExtension("Foundation")
if availability == "Available":
   arcpy.CheckOutExtension("Foundation")
   arcpy.AddMessage("Foundation Ext checked out")
else:
   arcpy.AddError("%s extension is not available (%s)"%("Foundation Extension",availability))
   arcpy.AddError("Please ask someone who has it checked out but not using to turn off the extension")
   return

to work however:

>>> arcpy.CheckOutExtension("Foundation")
u'CheckedOut'
>>> arcpy.CheckInExtension("Foundation")
u'CheckedIn'

works fine. I'm running a checked-out license enviroment, and this workstation has every extension and license checked out to it, and all tool in all toolboxes work fine with no license issues.

Trans = r'C:\Temp\Python\GRSM_20140326075058.gdb\Boundaries_And_AOIs\grsm_bndry_polygon'
TarGDB = r'C:\Temp\Python\GRSM_20140326075333.gdb'
arcpy.ExtractData_production(Trans,TarGDB,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","")

still fails with:

Traceback (most recent call last):
  File "C:\Temp\Python\GRSM.PY", line 17, in <module>
    arcpy.ExtractData_production(Trans,TarGDB,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","")
AttributeError: 'module' object has no attribute 'ExtractData_production'

I've put this in a .py file, so there are no carraige return or escape issues, same result.

>>> Trans = r'C:\Temp\Python\GRSM_20140326075058.gdb\Boundaries_And_AOIs\grsm_bndry_polygon'
>>> Trans
'C:\\Temp\\Python\\GRSM_20140326075058.gdb\\Boundaries_And_AOIs\\grsm_bndry_polygon'
>>> TarGDB = r'C:\Temp\Python\GRSM_20140326075333.gdb'
>>> TarGDB
'C:\\Temp\\Python\\GRSM_20140326075333.gdb'
>>> arcpy.ExtractData_production(Trans,TarGDB,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","")
Traceback (most recent call last):
  File "<pyshell#7>", line 1, in <module>
    arcpy.ExtractData_production(Trans,TarGDB,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","")
AttributeError: 'module' object has no attribute 'ExtractData_production'

Re: arcpy.ExtractData_production does not work in Python GUI?

JamesCrandall — Wed, 26 Mar 2014 16:30:31 GMT

I don't have this Foundation extension to be able to test but if it works in your ArcMap/Python environment but not in a PythonIDE, then perhaps an environment variable is confusing you IDE install somehow. That is, the Python executing from ArcMap is using the correct Python.exe install but your standalone copy is not.

Just a guess really.

Re: arcpy.ExtractData_production does not work in Python GUI?

ThomasColson — Wed, 26 Mar 2014 16:53:39 GMT

C:\Python27\ArcGISx6410.1\pythonw.exe "C:\Python27\ArcGISx6410.1\Lib\idlelib\idle.pyw" is what I'm using for standalone. Further testing reveals that ALL of the production mapping tools return this error, I am able to run other tools just fine in standalone python. Production mapping tools run fine in Arc Map, as a tool, or Arc Map python window.

Has ESRI perhaps disabled execution of Production Mapping tools in standalone python in Arc Map 10.1?

I'm able to reproduce this on many different workstations.

Re: arcpy.ExtractData_production does not work in Python GUI?

ThomasColson — Thu, 10 Apr 2014 13:33:29 GMT

This has been resolved with the application of the latest 10.1 SP1 QIP service pack.

Re: arcpy.ExtractData_production does not work in Python GUI?

ThomasColson — Sat, 11 Dec 2021 17:16:17 GMT

And now with the installation of Mapping and Charting Solutions 10.2.2 Patch 2 | Samples and Utilities the same error is produced once again with ArcMap 10.2.2. Really frustrated with how every version and patch from ESRI continually breaks things that reasonably would be stable through releases.....

Traceback (most recent call last):
  File "X:\GIS_Final\data\basedata\basemap\Data\Working\Python_Automated_Scripts\GRSMHYDRO.py", line 39, in <module>
    arcpy.ExtractData_production("X:\\GIS_Final\\data\\basedata\\basemap\\Data\\Working\\Python_Automated_Scripts\\GRSM.sde\\GRSM.DBO.Boundaries_And_AOIs","USE_FILTERS", GDB,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","")
AttributeError: 'module' object has no attribute 'ExtractData_production'

Re: arcpy.ExtractData_production does not work in Python GUI?

ChrisWelch1 — Fri, 25 Sep 2015 15:32:31 GMT

Does anyone know if there's been any movement on this? We're using 10.2.1 and getting the same problems. Even when I point the script to the proper toolbox, I get the error:

ERROR 000617: Error accessing tool Extract Data

Failing an actual fix for this, does anyone know of a decent way to replicate the speed of Extract Data in the ArcPy environment? Clip works, but it's far slower than Extract Data.

Re: arcpy.ExtractData_production does not work in Python GUI?

ThomasColson — Wed, 03 Jan 2018 15:13:11 GMT

No, as of 10.5.1 this is still not working.

Re: arcpy.ExtractData_production does not work in Python GUI?

JamesCrandall — Sat, 11 Dec 2021 17:16:19 GMT

Maybe a path issue? Try,

outputWS = r'X:\GIS_Final\data\basedata\basemap\Data\Working\Python_Automated_Scripts\GRSM.sde'
outputName = r'GRSM.DBO.Boundaries_And_AOIs'
inputFC = os.path.join(outputWS, outputName)
 
arcpy.ExtractData_production(inputFC,"USE_FILTERS", GDB,"DO_NOT_REUSE","NO_FILTER_BY_GEOMETRY","INTERSECTS","")   ‍‍‍‍‍‍‍‍‍‍

Re: arcpy.ExtractData_production does not work in Python GUI?

ThomasColson — Wed, 03 Jan 2018 16:22:11 GMT

I'm able to verify the path is valid in the following (sorry for the formatting Geonet toolbars don't work in IE):

import arcpy, sys, traceback
from arcpy import env
import time, os
from subprocess import call
arcpy.CheckOutExtension("Foundation")
arcpy.CheckOutExtension("Spatial")
arcpy.CheckOutExtension("Network")

OutFolder = "C:\\GDB\\OUTPUT\\"
OutName = "TEST_"+time.strftime("%Y%m%d%H%M%S")+".gdb"
GDB = OutFolder+"\\"+OutName

if os.path.exists("C:\\GDB\\TEST.gdb"):
    arcpy.Delete_management("C:\\GDB\\TEST.gdb")
else:
    print ("Nothing to Delete")

arcpy.env.configKeyword = "DEFAULTS"
arcpy.CreateFileGDB_management(OutFolder, OutName)

arcpy.env.workspace = "C:\\GDB\\RESTON DB.sde"

arcpy.ExtractData_production("TEST.DBO.Boundaries_And_AOIs",GDB,"DO_NOT_REUSE","","","")
arcpy.ExtractData_production("TEST.DBO.Air_Photo_Footprints",GDB,"DO_NOT_REUSE","","","")
arcpy.ExtractData_production("TEST.DBO.Elevation",GDB,"DO_NOT_REUSE","","","")
arcpy.ExtractData_production("TEST.DBO.GridsAndGrats",GDB,"DO_NOT_REUSE","","","")

arcpy.Compact_management(GDB)

if os.path.exists("C:\\GDB\\TEST.gdb"):
arcpy.Delete_management("C:\\GDB\\TEST.gdb")
else:
print ("Nothing to Delete")

arcpy.Copy_management(GDB, "C:\\GDB\\TEST.gdb", "")

Re: arcpy.ExtractData_production does not work in Python GUI?

JamesCrandall — Sat, 11 Dec 2021 17:16:22 GMT

The example at http://desktop.arcgis.com/en/arcmap/10.3/tools/production-mapping-toolbox/extract-data.htm shows a selection being applied to the input feature layer as well as a test to make sure there is only 1 feature selected before creating the value table of input datasets. I'm simply not familiar with this tool and what it is supposed to accomplish but it looks like you are attempting to initiate the tool over and over on the unique data within the gdb rather than generating a value table of input datasets and executing the tool once with this parameter.

Instead of executing on each input dataset,

arcpy.ExtractData_production("TEST.DBO.Boundaries_And_AOIs",GDB,"DO_NOT_REUSE","","","")
arcpy.ExtractData_production("TEST.DBO.Air_Photo_Footprints",GDB,"DO_NOT_REUSE","","","")
arcpy.ExtractData_production("TEST.DBO.Elevation",GDB,"DO_NOT_REUSE","","","")
arcpy.ExtractData_production("TEST.DBO.GridsAndGrats",GDB,"DO_NOT_REUSE","","","")‍‍‍‍‍‍‍‍

The example shows that each of these need to be as a single input parameter,

#change your workspace to the folder rather than the sde connection file
arcpy.env.workspace = "C:/GDB/"

# create a value table of input datasets and filter options
inDatasets="RESTON DB.sde/TEST.DBO.Boundaries_And_AOIs;RESTON DB.sde/TEST.DBO.Air_Photo_Footprints;RESTON DB.sde/TEST.DBO.Elevation;RESTON DB.sde/TEST.DBO.GridsAndGrats ALL_ROWS"

# extract data
reuseSchema="DO_NOT_REUSE"
useFilter="FILTER_BY_GEOMETRY"
filterType="CONTAINS"

arcpy.ExtractData_production(inDatasets,extractGdb,reuseSchema,useFilter,filterType,inFeaturesLyr)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍