I have a feature class table that i need to export to excel, the feature class will be created weekly. The problem i am having is that on creation the feature class gets the date added to the end of the feature class name and i am trying to access with a wildcard because the date will change based on when the feature class gets created. How can i get the feature class with a wildcard? import arcpy workspace = "Database Servers\GIS.gds\GISSERVER1 (VERSION:dbo.DEFAULT)" arcpy . env . workspace = workspace ''' lyrs = ['Hyrdo_FINAL_ALL_*'] for fc in arcpy.ListFeatureClasses(): for lyr in lyrs: if fc.startswith(lyr): print 'lyr' ''' lyr = "Hyrdo_FINAL_ALL_*" #Database Servers\GIS.gds\GISSERVER1 (VERSION:dbo.DEFAULT)\Hyrdo_FINAL_ALL_121817 arcpy . MakeFeatureLayer_management ( lyr , "In_memory\lyr1" ) arcpy . TableSelect_analysis ( "In_memory\lyr1" , "C:/Temp/Export_Output.xls" , "" ) print 'done'

I was able to get it to work by removing the feature_dataset [0] and making the workspace a "database connection" not a direct connection. import arcpy from arcpy import env arcpy . env . workspace = "Database Connections\GISSERVER1 (VERSION:dbo.DEFAULT)" lyr = arcpy . ListFeatureClasses ( "Hydro_FINAL_ALL_*" ) #Database Servers\GIS.gds\GISSERVER1 (VERSION:dbo.DEFAULT)\Hyrdo_FINAL_ALL_121817 for fc in lyr : arcpy . MakeFeatureLayer_management ( fc , "In_memory\lyr1" ) arcpy . TableSelect_analysis ( "In_memory\lyr1" , "C:/Temp/Export_Output.xls" , "" ) #arcpy.FeatureClassToFeatureClass_conversion("In_memory\lyr1","C:\Temp","Export.shp") print 'done'

that error message is only returned when there is an empty list... for example a = [ ] # define an empty list a [ 0 ] # slice the empty list and get an error Traceback ( most recent call last ) : File " " , line 1 , in module > a [ 0 ] IndexError : list index out of range Now you say... but the list isn't empty... Another way to get the error a = [ 1 , 2 ] # so now we have 2 elements in the list... a [ 2 ] # so let's get the second Traceback ( most recent call last ) : File " " , line 1 , in module > a [ 2 ] IndexError : list index out of range But python is zero-indexed, so if you want the second, then you have to slice by [1], since [0] returns the first. That's how slicing works... it is either empty or you sliced beyond the range, or you sliced wrong.

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Feature class name wildcard

CCWeedcontrol

I have a feature class table that i need to export to excel, the feature class will be created weekly. The problem i am having is that on creation the feature class gets the date added to the end of the feature class name and i am trying to access with a wildcard because the date will change based on when the feature class gets created. How can i get the feature class with a wildcard?

<SPAN class="keyword token">import</SPAN> arcpy&nbsp; 
 
workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Servers\GIS.gds\GISSERVER1 (VERSION:dbo.DEFAULT)"</SPAN> 
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> workspace

<SPAN class="string token">'''
lyrs = ['Hyrdo_FINAL_ALL_*']&nbsp; 
for fc in arcpy.ListFeatureClasses():&nbsp; 
&nbsp;&nbsp;&nbsp; for lyr in lyrs:&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if fc.startswith(lyr):
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print 'lyr'
'''</SPAN>
lyr <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Hyrdo_FINAL_ALL_*"</SPAN> <SPAN class="comment token">#Database Servers\GIS.gds\GISSERVER1 (VERSION:dbo.DEFAULT)\Hyrdo_FINAL_ALL_121817</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"In_memory\lyr1"</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>TableSelect_analysis<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"In_memory\lyr1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"C:/Temp/Export_Output.xls"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>


<SPAN class="keyword token">print</SPAN> <SPAN class="string token">'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>

Najděte více příspěvků označených jako

Accepted answers

All comments

CCWeedcontrol

I was able to get it to work by removing the feature_dataset [0] and making the workspace a "database connection" not a direct connection.

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

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections\GISSERVER1 (VERSION:dbo.DEFAULT)"</SPAN>

lyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Hydro_FINAL_ALL_*"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="comment token">#Database Servers\GIS.gds\GISSERVER1 (VERSION:dbo.DEFAULT)\Hyrdo_FINAL_ALL_121817</SPAN>
<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> lyr<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"In_memory\lyr1"</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; arcpy<SPAN class="punctuation token">.</SPAN>TableSelect_analysis<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"In_memory\lyr1"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"C:/Temp/Export_Output.xls"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#arcpy.FeatureClassToFeatureClass_conversion("In_memory\lyr1","C:\Temp","Export.shp")</SPAN>


<SPAN class="keyword token">print</SPAN> <SPAN class="string token">'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>

DanPatterson_Retired

that error message is only returned when there is an empty list...

for example

a <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp; <SPAN class="comment token"># define an empty list</SPAN>

a<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># slice the empty list and get an error</SPAN>

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

&nbsp; File <SPAN class="string token">"<ipython-input-18-6a1284577a36>"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
&nbsp;&nbsp;&nbsp; a<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>

IndexError<SPAN class="punctuation token">:</SPAN> list index out of range<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>

Now you say... but the list isn't empty...

Another way to get the error

a <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp; <SPAN class="comment token"># so now we have 2 elements in the list... </SPAN>

a<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># so let's get the second</SPAN>

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>

&nbsp; File <SPAN class="string token">"<ipython-input-21-fc907be37984>"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
&nbsp;&nbsp;&nbsp; a<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN>

IndexError<SPAN class="punctuation token">:</SPAN> list index out of range<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>

But python is zero-indexed, so if you want the second, then you have to slice by [1], since [0] returns the first.

That's how slicing works... it is either empty or you sliced beyond the range, or you sliced wrong.

CCWeedcontrol

Fixing the typo didn't not fix it the "list index out of range" error.

DanPatterson_Retired

did you fix this

lyr = "Hyrdo_FINAL_ALL_*" #Database Servers\GIS.gds\GISSERVER1 (VERSION:dbo.DEFAULT)\Hyrdo_FINAL_ALL_12181

and try it again given the spelling error (or is it?)

CCWeedcontrol

Yes Hydro, sorry. The feature class gets delete and replace with a new one with the date it was created, sorry i should have mentioned that.

MicahBabinski

Hmmm, it's possible that would due to a typo. Is the spelling "Hyrdo_FINAL_ALL_..." or "Hydro_FINAL_ALL_..."?

Also, is the old feature class deleted and replaced by the date-stamped new copy, or is a date-stamped new copy added to the workspace? If there is a stack of them going back multiple weeks you might need to parse the date field like Randy said to find the newest one.

Micah

DanPatterson_Retired

did you then try Randy's suggestion of 'startswith' that would be the next extension... assuming Hyrdo is the correct spelling and not Hydro

CCWeedcontrol

I am getting "list index out of range" at lyr = arcpy.ListFeatureClasses("<SPAN class="">Hyrdo_FINAL_ALL_*</SPAN>") [0]?

thanks for the TableToExcel.

RandyBurton

First, I would use a date format that is suitable for sorting: YYMMDD. Append this to your feature names when backing up. You can then append the feature name to a list (if it starts with, contains, etc. what you are looking for) when you loop through a ListFeatureClasses or ListLayers, sort the list and then pick the first or last item in the sorted list as the oldest or newest.

features <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Hyrdo_FINAL_ALL_171218'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Hyrdo_FINAL_ALL_171012'</SPAN><SPAN class="punctuation token">,</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="string token">'My_Feature_170101'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Another_Feature_161012'</SPAN><SPAN class="punctuation token">]</SPAN>
found <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> feature <SPAN class="keyword token">in</SPAN> features<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> feature<SPAN class="punctuation token">.</SPAN>startswith<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'Hyrdo_FINAL_ALL_'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># assumes this is name up to date</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; found<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>feature<SPAN class="punctuation token">)</SPAN>

found<SPAN class="punctuation token">.</SPAN>sort<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> found<SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</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>

MicahBabinski

Hi CC,

ListFeatureClasses has an optional wildcard parameter I think you could use.

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"[path to your workspace]"</SPAN>
lyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFeatureClasses<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"Hyrdo_FINAL_ALL_*"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="comment token"># do something with lyr</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

By the way, I don't think an excel file is a valid output to TableSelect. If you just want to write the table to an excel spreadsheet you could do:

arcpy<SPAN class="punctuation token">.</SPAN>TableToExcel_conversion<SPAN class="punctuation token">(</SPAN>lyr<SPAN class="punctuation token">,</SPAN> r<SPAN class="string token">"[path].xls"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Hope this helps!

Micah

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.