Save field names to a .txt file

SoratoSouza_e_Silva

Hi,

how can i change this code to write to a file all field names of each feature class that exists in a geodatabase.

import arcpy
enviro = r"C:/EsriTraining/PYTH/Automate/"
arcpy.env.workspace = enviro +"{}".format("SanDiego.gdb")
field_list = arcpy.ListFields("MajorAttractions")
txtFile = open(enviro +"{}".format("Majorattractions.txt"),"w")
txtFile.write("MajorAttractions field information" + "\n")
txtFile.write("-------------------------------------" + "\n")
for field in field_list:
      line = "Name: {}, Type: {}, Length: {}\n".format(
            field.name, field.type, field.length)
      txtFile.write(line)
txtFile.close()

Thank´s

deleted-user-NvcfpBOWaKwr

Instead of trying to fix your code I just wrote this up. I tested it several times to make sure it works. The script will make a folder called "Logfiles" in the same directory path that the script is running from. There you will find the text file with the field information for all of the feature classes within the .gdb

Happy Thanksgiving, Enjoy and most of all enjoy the time ahead with the family!!

EDIT:

Added in some code to write the field type and length to the logfile. I missed that part when I grazed over your code.

You can also replace my concatenation's with the format() function. Especially on line 38. Bad habit on my end. 

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os
<SPAN class="keyword token">from</SPAN> os <SPAN class="keyword token">import</SPAN> path

<SPAN class="comment token">#################################################################</SPAN>
<SPAN class="comment token">#</SPAN>
<SPAN class="comment token"># Change the workSpace variable to point to the .gdb you want to work with</SPAN>
<SPAN class="comment token">#</SPAN>
<SPAN class="comment token">##################################################################</SPAN>

workSpace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"Put the path of your .gdb here.. Make sure you keep the path within the double quotes and don't delete the r"</SPAN> <SPAN class="comment token"># Sorry if you already know this.</SPAN>
logFile <SPAN class="operator token">=</SPAN>  os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>dirname<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>abspath<SPAN class="punctuation token">(</SPAN>__file__<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"Logfiles"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"Field_Export_Log.txt"</SPAN>
logFolder <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>dirname<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>abspath<SPAN class="punctuation token">(</SPAN>__file__<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\\"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">"Logfiles"</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workSpace

<SPAN class="keyword token">if</SPAN> path<SPAN class="punctuation token">.</SPAN>exists<SPAN class="punctuation token">(</SPAN>logFolder<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># Checks to see if there is a Logfiles folder in the same directory path that the script is running from</SPAN>
    <SPAN class="keyword token">pass</SPAN>

<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># If there is not a Logfiles folder it will make one</SPAN>
    os<SPAN class="punctuation token">.</SPAN>mkdir<SPAN class="punctuation token">(</SPAN>logFolder<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">if</SPAN> path<SPAN class="punctuation token">.</SPAN>exists<SPAN class="punctuation token">(</SPAN>logFile<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># This checks to see if there is already a logfile. If there is one it will pass over this section</SPAN>
    <SPAN class="keyword token">pass</SPAN>

<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
    txtWriter <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>logFile<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"a"</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># If there is not a logfile it will create one</SPAN>
    txtWriter<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"******Begin Field Name Listing******"</SPAN><SPAN class="punctuation token">)</SPAN>
    txtWriter<SPAN class="punctuation token">.</SPAN>close<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> listFC <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># This creates a list of the featureclasses within the .gdb and loops through each one</SPAN>
    describe <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>listFC<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># This pull information about the featureclass so we can use the .name method in the txt file</SPAN>
    txtWriter2 <SPAN class="operator token">=</SPAN> open<SPAN class="punctuation token">(</SPAN>logFile<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"a"</SPAN><SPAN class="punctuation token">)</SPAN>  <SPAN class="comment token"># Opens the lofile</SPAN>
    txtWriter2<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\n\n\n********"</SPAN> <SPAN class="operator token">+</SPAN> <SPAN class="string token">" Field Names for Feature Class "</SPAN> <SPAN class="operator token">+</SPAN> describe<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">+</SPAN> <SPAN class="string token">" ********"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># Writes some stuff to the log file</SPAN>

    <SPAN class="keyword token">for</SPAN> listFields <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>listFC<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># This creates a list of the fields in the feature class that the loop on line 23 is currently on</SPAN>
        txtWriter2<SPAN class="punctuation token">.</SPAN>write<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"\n\nName: "</SPAN> <SPAN class="operator token">+</SPAN> listFields<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\nField Type: "</SPAN> <SPAN class="operator token">+</SPAN> listFields<SPAN class="punctuation token">.</SPAN>type <SPAN class="operator token">+</SPAN> <SPAN class="string token">"\nField Length: "</SPAN> <SPAN class="operator token">+</SPAN> str<SPAN class="punctuation token">(</SPAN>listFields<SPAN class="punctuation token">.</SPAN>length<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># This writes the field names, types and lengths to the logfile</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Added Field "</SPAN> <SPAN class="operator token">+</SPAN> listFields<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">+</SPAN> <SPAN class="string token">" From Feature Class: "</SPAN> <SPAN class="operator token">+</SPAN> describe<SPAN class="punctuation token">.</SPAN>name <SPAN class="operator token">+</SPAN> <SPAN class="string token">" To .txt file"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># For debugging so you know what the script is doing</SPAN>

    txtWriter2<SPAN class="punctuation token">.</SPAN>close <SPAN class="comment token"># This closes the write session on the logfile</SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Done!!!"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># All done</SPAN>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>