topic Re: Table to Excel export using python in ArcSDE in Python Questions

Table to Excel export using python in ArcSDE

DougMerrick — Thu, 21 Jul 2016 21:56:26 GMT

Hi,

I am wanting to (from Windows 10 desktop) to run a python script that exports the table from feature classes, within a feature dataset, in an ArcSDE environment. I can manually run the script in ArcMap everyday, but this will add to the tasks that I already have. I need the script to run outside of ArcGIS so I can automatically run the script with Scheduled Tasks in Windows.

I have created the connection file and can list feature datasets and classes but I cannot figure out how to use the arcpy "table to excel" tool on the feature datasets within feature classes.

What I have so far:

# Import arcpy module

import arcpy

from arcpy import env

import os

arcpy.env.workspace = "G:\Location_of_Connection.sde_file"

Utility_Pipe = "Utility_pipe_???_Unsure how to point directly at the FC in SDE"

Utility_xls = "Location of Utility Excel\Utility.xls"

# Process: Table To Excel

arcpy.TableToExcel_conversion(Utility_Pipe, Utility_xls, "NAME", "CODE")

print "done"

I using ArcMap 10.3.1 in an enterprise geodatabase on windows 10.

Thanks!

Re: Table to Excel export using python in ArcSDE

DanPatterson_Retired — Thu, 21 Jul 2016 22:18:49 GMT

If you have done it manually, perhaps you can use the information in the Results window

Using the Results window—Help | ArcGIS for Desktop

maybe even exporting to a python snippet

Re: Table to Excel export using python in ArcSDE

DougMerrick — Thu, 21 Jul 2016 22:48:08 GMT

I looked at that before realizing that by using a python script to run the model itself would reduce the coding headache significantly.
The python script to run the model can be found here http://joelmccune.com/run-models-as-scheduled-tasks/

When making the model, add the data directly from the source (ie. NCGIS.GIS.UtilityMain instead of from the table of Contents-Utility Main).

Re: Table to Excel export using python in ArcSDE

CCWeedcontrol — Thu, 21 Jul 2016 22:57:53 GMT

Table to Table (Conversion)

import arcpy fc = r'C:\path\to\your\fc' outtable = r'C:\temp'

arcpy.TableToTable_conversion (fc, outtable, 'outtableFile.dbf')

Re: Table to Excel export using python in ArcSDE

DougMerrick — Fri, 22 Jul 2016 15:47:05 GMT

I was able to get this to work on local data, but pointing the fc to the specific feature class in the versioned ArcSDE environment was proving troublesome. So I went with the solution I detailed above.

Thanks though