topic Re: Export Geodatabase Contents to Text File? in Data Management Questions

Export Geodatabase Contents to Text File?

JoshuaDamron — Fri, 25 May 2012 14:50:15 GMT

For organizational purposes I'm trying to organize feature class names in an Excel file. Is there a way to export the feature class names/contents of a Geodatabase to a Text file?

If so it will save a lot of time spent recreating the file names.

Thanks in advance!

Re: Export Geodatabase Contents to Text File?

TimHopper — Sat, 11 Dec 2021 19:38:01 GMT

Joshua,

Python will do this for you quite easily. Try something like the following:

import arcpy

# create or open an existing text file
f = open("c:\\data\\fc_list.txt", "a")

# specify the geodatabase you want to retrieve feature classes from
gdb = "c:\\data\\MyGeodatabase.gdb"

# set your environment workspace
arcpy.env.workspace = gdb

#list all of the feature datasets within the geodatabase
datasetList = arcpy.ListDatasets("*")

# within each feature dataset, list the feature classes and write them to the text file
for dataset in datasetList:
 fcList1 = arcpy.ListFeatureClasses("*","",dataset)
 for fc in fcList1:
  f.write(fc + "\n")

# find all of the feature classes which do not reside within a feature dataset
fcList2 = arcpy.ListFeatureClasses("*")

# write the feature class names to the text file which don't reside in the feature dataset
for fc in fcList2:
 f.write(fc + "\n")

Re: Export Geodatabase Contents to Text File?

TimHopper — Sat, 11 Dec 2021 19:38:04 GMT

I modified the script a little bit and threw it in a toolbox as a script tool for you so you can see how it all gets put together.

import arcpy, os

outputDir = arcpy.GetParameterAsText(0)
outputName = arcpy.GetParameterAsText(1)
gdb = arcpy.GetParameterAsText(2)

textFile = (outputDir + os.sep + outputName + ".txt")

f = open(textFile, "a")

arcpy.env.workspace = gdb

datasetList = arcpy.ListDatasets("*")

for dataset in datasetList:
 fcList1 = arcpy.ListFeatureClasses("*","",dataset)
 for fc in fcList1:
  f.write(fc + "\n")

fcList2 = arcpy.ListFeatureClasses("*")

for fc in fcList2:
 f.write(fc + "\n")

Re: Export Geodatabase Contents to Text File?

CharlesBanks1 — Mon, 04 Jun 2012 18:02:18 GMT

Hi Tim,

I tried your Toolbox but there are no contents. Could you please elaborate on how to get it to work? What are the parameters, etc.

Thanks!

Re: Export Geodatabase Contents to Text File?

TimHopper — Mon, 04 Jun 2012 18:11:01 GMT

Hmmm...

Perhaps I accidentally create the toolbox at v10.1? I'm surprised nobody else commented.

I re-created the toolbox at v10.0, seems to work fine for me. Hopefully it works for you as well.

There are three parameters.

1. Output folder (windows folder)
2. Output text file name (such as MyOutputFile)
3. Input geodatabase

Re: Export Geodatabase Contents to Text File?

CharlesBanks1 — Mon, 04 Jun 2012 18:32:37 GMT

Thanks, I am using v10.0 with SP4. Iwill try this.

Re: Export Geodatabase Contents to Text File?

CharlesBanks1 — Mon, 04 Jun 2012 18:40:22 GMT

Hey, Tim, it worked!! It seems to work only for File GDB though. When I try to bring in a SDE GDB it seems not to be connecting to SDE.

Thanks,