topic Re: Export Feature Attribute to ASCII question in Python Questions

Export Feature Attribute to ASCII question

DC — Mon, 09 Apr 2012 16:25:49 GMT

Does anyone know a way to export every "Value_Field" in a shape file without specifically using the name of every one individually? In other words is there some kind of wildcard value or loop that will just export every single "Value_Field" that is in the shape file?

Based on this:
ExportXYv_stats (Input_Feature_Class, Value_Field, Delimiter, Output_ASCII_File, Add_Field_Names_to_Output)

Re: Export Feature Attribute to ASCII question

MathewCoyle — Sat, 11 Dec 2021 17:41:24 GMT

I believe you are looking for something like this.

import arcpy
fields = arcpy.ListFields(<your_layer>)
field_text = list()
for f in fields:
    if fields.type != "Geometry":
        field_text.append(f.name)

arcpy.ExportXYv_stats(<your_layer>,field_text,"COMMA","C:/GIS/Exports/test2.asc","ADD_FIELD_NAMES")

Re: Export Feature Attribute to ASCII question

DC — Sat, 11 Dec 2021 17:41:27 GMT

Thank you for the reply, but I am really new to python and not sure how that would fit into this:

# Export feature locations and attributes to an ASCII text file

# Import system modules

import arcpy


# Local variables...

workspace = "C:\Users\me\Desktop\InputFolder.ospfds"

input_features = "ShapeFile.shp"

export_ASCII = "ExportFile.txt"

 

try:

    # Set the current workspace (to avoid having to specify the full path to the feature classes each time)

    arcpy.env.workspace = workspace

 

    # Process: Export Feature Attribute to ASCII...

    arcpy.ExportXYv_stats(input_features, ["value_field_A","value_field_B","value_field_C"], "COMMA", export_ASCII, "ADD_FIELD_NAMES")

 

except:

    # If an error occurred when running the tool, print out the error message.

    print arcpy.GetMessages()

Re: Export Feature Attribute to ASCII question

DC — Wed, 11 Apr 2012 12:39:33 GMT

Anyone else have any ideas on this?

Re: Export Feature Attribute to ASCII question

ScottBlankenbeckler — Sat, 11 Dec 2021 17:41:29 GMT

Anyone else have any ideas on this?

I would use mathew's solution. Your code should look something like this:

# Export feature locations and attributes to an ASCII text file
 
# Import system modules
 
import arcpy
 
 
# Local variables...
 
workspace = "C:\Users\me\Desktop\InputFolder.ospfds"
 
input_features = "ShapeFile.shp"
fields = arcpy.ListFields (input_features )
field_text = list()
for f in fields:
    if fields.type != "Geometry":
        field_text.append(f.name)
 
export_ASCII = "ExportFile.txt"
 
 
 
try:
 
    # Set the current workspace (to avoid having to specify the full path to the feature classes each time)
 
    arcpy.env.workspace = workspace
 
 
 
    # Process: Export Feature Attribute to ASCII...
 
    arcpy.ExportXYv_stats(input_features, field_text, "COMMA", export_ASCII, "ADD_FIELD_NAMES")
 
 
 
except:
 
    # If an error occurred when running the tool, print out the error message.
 
    print arcpy.GetMessages()

Re: Export Feature Attribute to ASCII question

DC — Wed, 11 Apr 2012 16:44:07 GMT

Ah, I got it to work with a couple changes. Thank you both for the help!

1. input_features = "ShapeFile.shp" needed the entire path instead of just the file name in order to work with arcpy.ListFields for some reason

2. "if fields.type != ...." needed to be changed to "if f.type != ...."

Re: Export Feature Attribute to ASCII question

DonBarker — Mon, 16 Apr 2012 14:48:40 GMT

Really appreciate you guys taking time to document this. Am a Python novice, too. Made a big contribution to my project.