topic Re: Export Attributes from Arcmap without Geometry fields in Python Questions

Export Attributes from Arcmap without Geometry fields

2Quiker — Sat, 11 Dec 2021 14:46:52 GMT

I need to export attributes from a certain layer in Arcmap but without the OID & Geometry fields to excel.

I've tried the following bet i am getting error ("AttributeError: DescribeData: Method areaFieldName does not exist") on line 15. I would appreciate any help with the code, thanks.

import arcpy
import os

arcpy.env.overwriteOutput = True
mxd = arcpy.mapping.MapDocument("CURRENT")
df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0]
lyr = arcpy.mapping.ListLayers(mxd, "Notified")[0]

arcpy.env.workspace = os.path.dirname(mxd.filePath)
wp = os.path.dirname(mxd.filePath)

fc = "Notified"
desc = arcpy.Describe(fc)
f = desc.fields
fields = [f.name for f in f if f.name != desc.OIDFieldName and f.type != 'Geometry' and f.name != desc.areaFieldName and f.name != desc.lengthFieldName]
for fld in fields:  
    fields.remove(fields)

arcpy.MakeQueryTable_management(fc, "tmp_table", "NO_KEY_FIELD")‍‍‍‍‍‍‍‍
arcpy.TableToExcel_conversion("tmp_table", Notified_xls) ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Export Attributes from Arcmap without Geometry fields

JakeSkinner — Fri, 01 Nov 2019 17:59:20 GMT

I would recommend executing the Table to Table tool and export the layer to a File Geodatabase. You can remove the OID using the Field Mapping paramter (the geometry should already be removed). Then execute the Table to Excel tool on the geodatabase table. After executing each of these, you can copy the python commands and paste them into your script.

Re: Export Attributes from Arcmap without Geometry fields

2Quiker — Fri, 01 Nov 2019 18:21:54 GMT

Jake,

Thanks for the recommendation but I would have thought that just dropping or removing the fields would be easier.

I didn't want to do the field mapping.

Re: Export Attributes from Arcmap without Geometry fields

JakeSkinner — Sat, 11 Dec 2021 14:46:55 GMT

In your code you are removing the fields from the list, but you are not applying the fields list to any function afterwards. I believe you will have to do some field mapping. Here is an example that I was able to get to work:

import arcpy

# Set data path
intable = r"C:\temp\python\test.gdb\airports"

# Create a fieldinfo object
fieldInfo = arcpy.FieldInfo()

# Get the fields from the input
fields= arcpy.ListFields(intable)
for field in fields:
    if field.type != 'OID' and field.type != 'Shape':
       fieldInfo.addField(field.name, field.name, "VISIBLE", "")
    if field.type == 'OID':
       fieldInfo.addField(field.name, field.name, "HIDDEN", "")

# Create table view
arcpy.MakeTableView_management(intable, "airports_view", "", "", fieldInfo)

# Export to Excel
arcpy.conversion.TableToExcel("airports_view", r"C:\TEMP\Python\airports.xlsx")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

For some reason the OID is always added, so I had to add this as HIDDEN.

Re: Export Attributes from Arcmap without Geometry fields

JoeBorgione — Fri, 01 Nov 2019 19:34:23 GMT

I shy away from field mapping as well. If you don't mind a hack, you could do a table to excel and then open your new excel worksheet and just delete the fields you don't want.....

Re: Export Attributes from Arcmap without Geometry fields

2Quiker — Fri, 01 Nov 2019 21:14:31 GMT

Ya I agree i could just open the excel spreadsheet and delete them if i were only doing it so often. I usually run this process about 10 times a week. So i was trying to make it as stream lined as possible.

Re: Export Attributes from Arcmap without Geometry fields

2Quiker — Fri, 01 Nov 2019 21:24:36 GMT

I am still have the the FID, Shape_Lenth & Shape_Area fields after the export to Excel after using what you posted

Re: Export Attributes from Arcmap without Geometry fields

JakeSkinner — Sat, 11 Dec 2021 14:46:57 GMT

Try setting those fields to HIDDEN as well. Ex:

if field.type == 'FID':
       fieldInfo.addField(field.name, field.name, "HIDDEN", "")

If this still does not resolve the issue, can you upload a sample of your data?

Re: Export Attributes from Arcmap without Geometry fields

DanPatterson_Retired — Mon, 04 Nov 2019 17:36:55 GMT

Has anyone tried the editable property? aka, only export those that are editable in conjunction with some of the others.

editable

(Read and Write)

The editable state: True if the field is editable.

Boolean

Re: Export Attributes from Arcmap without Geometry fields

2Quiker — Sat, 11 Dec 2021 14:47:00 GMT

I tried this again but i am not getting an error.

The Export_Output layer is a shapefile and the fields that are in the layer that i don't need are

Shape*, OBJECTID, Shape_Leng & Shape_Area

Traceback (most recent call last):
File "c:\program files (x86)\arcgis\desktop10.6\ArcToolbox\Scripts\TableToExcel.py", line 224, in <module>
arcpy.GetParameter(3))
File "c:\program files (x86)\arcgis\desktop10.6\ArcToolbox\Scripts\TableToExcel.py", line 194, in table_to_excel
for row in cursor:
RuntimeError: Cannot find field ''

Failed to execute (TableToExcel).

import arcpy

arcpy.env.overwriteOutput = True
mxd = arcpy.mapping.MapDocument("CURRENT")
lyr = arcpy.mapping.ListLayers(mxd, "Export_Output")[0]

#Exports NotifiedLots tabel to excel table
intable = lyr  
# Create a fieldinfo object
fieldInfo = arcpy.FieldInfo()

# Get the fields from the input
fields= arcpy.ListFields(intable)
for field in fields:
    if field.type != 'OID' and field.type != 'Shape':
       fieldInfo.addField(field.name, field.name, "VISIBLE", "")
    if field.type == 'OID':
       fieldInfo.addField(field.name, field.name, "HIDDEN", "")

# Create table view
arcpy.MakeTableView_management(intable, "Notif_view", "", "", fieldInfo)

# Export to Excel
arcpy.conversion.TableToExcel("Notif_view", r"C:\TEMP\Notif_view.xls")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Export Attributes from Arcmap without Geometry fields

JakeSkinner — Fri, 15 Nov 2019 17:58:04 GMT

2 Quiker‌ can you zip and upload your shapefile? Make sure you include the .shp, .shx, .dbf, and .prj in the zip file.

Re: Export Attributes from Arcmap without Geometry fields

2Quiker — Fri, 15 Nov 2019 18:11:05 GMT

I have attached a sample of the data.

Thanks for your help!

Re: Export Attributes from Arcmap without Geometry fields

JakeSkinner — Sat, 11 Dec 2021 14:47:03 GMT

I created a tuple called hiddenFields, and added all the fields I did not want to show in that. Try the following:

import arcpy
arcpy.env.overwriteOutput = 1

# Set data path
intable = r"C:\TEMP\PYTHON\UserData\Export_Output.shp"

# Create a fieldinfo object
fieldInfo = arcpy.FieldInfo()

# Fields to Hide
hiddenFields = ('FID', 'Shape', 'OBJECTID', 'Shape_Leng', 'Shape_Area')

# Get the fields from the input
fields= arcpy.ListFields(intable)
for field in fields:
    if field.name not in hiddenFields:
       fieldInfo.addField(field.name, field.name, "VISIBLE", "")
    else:
       fieldInfo.addField(field.name, field.name, "HIDDEN", "")


# Create table view
arcpy.MakeTableView_management(intable, "export_view", "", "", fieldInfo)

# Export to Excel
arcpy.conversion.TableToExcel("export_view", r"C:\TEMP\Python\UserData\export.xlsx")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Export Attributes from Arcmap without Geometry fields

2Quiker — Sat, 11 Dec 2021 14:47:06 GMT

Jake,

I get error on in TableToExcel raise e ExecuteError: ERROR 000814: Invalid file type Failed to execute (TableToExcel) with ".xlsx"

If i change the output to ".xls" get "RuntimeError: Cannot find field ''.

I need this to run in side python in Arcmap not in a stand alone script. This will be made into a tool script.

import arcpy

arcpy.env.overwriteOutput = True
mxd = arcpy.mapping.MapDocument("CURRENT")
lyr = arcpy.mapping.ListLayers(mxd, "Export_Output")[0]

# Create a fieldinfo object
fieldInfo = arcpy.FieldInfo()

# Fields to Hide
hiddenFields = ('FID', 'Shape', 'OBJECTID', 'Shape_Leng', 'Shape_Area')

# Get the fields from the input
fields= arcpy.ListFields(lyr)
for field in fields:
    if field.name not in hiddenFields:
       fieldInfo.addField(field.name, field.name, "VISIBLE", "")
    else:
       fieldInfo.addField(field.name, field.name, "HIDDEN", "")

# Create table view
arcpy.MakeTableView_management(lyr, "Notif_view", "", "", fieldInfo)

# Export to Excel
arcpy.conversion.TableToExcel("Notif_view", r"C:\temp\Notif_view.xlsx")
                 
arcpy.RefreshActiveView()
arcpy.RefreshTOC()‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Export Attributes from Arcmap without Geometry fields

JohannesBierer — Sat, 11 Dec 2021 14:47:08 GMT

A working possibility could be to convert to numpy array, then use pandas to convert the array to excel?

import arcpy
import pandas as pd

arcpy.env.overwriteOutput = True

inTable = r"yourpath\Export_Output.shp"

outTable1 = r"yourpath\export.xls"

fieldNames = ["OBJECTID", "PARCEL_NO", "OwnerName", "Address", "City", "State", "ZipCode"]

arr = arcpy.da.FeatureClassToNumPyArray(inTable, fieldNames)

df = pd.DataFrame(arr)

df1 = df.to_excel(outTable1, index=False)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍