topic Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'??? in Python Questions

"Search Cursor() got an unexpected keyword argument 'sort_fields'???

MichelleCouden1 — Mon, 22 Apr 2013 13:01:23 GMT

I have this program to go through layers in an mxd and search for missing values. For Example, it sorts through the layer AADT in the FLAG field and then sorts through the layer AADTAnnoLabel in the TFLAG field to compare for missing values. I am getting a sort fields error. Could someone please explain that to me. What am I doing wrong!! I am not finding help online when I search for it. Thanks!!

import arcpy  flayer = "AADT" alayer = "AADTAnnoLabel"  FRows = arcpy.SearchCursor(flayer,"", sort_fields="FLAG A") ARows = arcpy.SearchCursor(alayer,"", sort_fields="TFLAG A")  FList = [] AList = []  for row in FRows:     Fvalue = row.getValue("FLAG")     FList.append(str(Fvalue))  for rows in ARows:     Avalue = row.getValue("TFLAG")     AList.append(str(Avalue))  matched = set(FList) & set(AList)  for x in matched:     exp = "ID = " + x     arcpy.SelectLayerByAttribute_management(flayer, "ADD_TO_SELECTION", exp)     arcpy.SelectLayerByAttribute_management(flayer, "SWTCH_SELECTION")

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

ChrisSnyder — Mon, 22 Apr 2013 15:57:51 GMT

I'm not sure if the traditional (non data access) cursors support named parameters (which is what you are doing with the 'sort_fields' named parameter in your code).

I think it would either have to be like this:

In traditional cursors:
FRows = arcpy.SearchCursor(flayer,"", "", "", "FLAG A")

Or in data access cursors like this:
FRows = arcpy.da.SearchCursor(flayer,["*"], sql_clause=(None, 'ORDER BY FLAG'))

This thread might help: http://forums.arcgis.com/threads/64580-SQL-sort-parameter-syntax-for-da.cursors

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MathewCoyle — Mon, 22 Apr 2013 18:34:23 GMT

As of 10.1 all arcpy tools should support kwargs for parameters. 10.0 they did not.

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

ChrisSnyder — Mon, 22 Apr 2013 20:47:14 GMT

Upon testing in v10.1, indeed the 'sort_fields' named parameter/kwarg appears to work as advertised.

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MichelleCouden1 — Fri, 10 Dec 2021 23:33:38 GMT

OK, ran the first code for traditional cursors and got a runtime error of error:999999. Saw that error on the forum but no one answered the poor guy, so I am not sure what that error means. Tried the second code for data access cursors and got the error 'module' object has no attribute 'da'. I'm thinking that means I just need to declare the object maybe??

import arcpy

flayer = "AADT"
alayer = "AADTAnnoLabel"

FRows = arcpy.da.SearchCursor(flayer,["*"],sql_clause=(None, 'ORDER BY FLAG'))
ARows = arcpy.da.SearchCursor(alayer,["*"],sql_clause=(None, 'ORDER BY TFLAG'))

FList = []
AList = []

for row in FRows:
    Fvalue = row.getValue("FLAG")
    FList.append(str(Fvalue))

for rows in ARows:
    Avalue = row.getValue("TFLAG")
    AList.append(str(Avalue))

matched = set(FList) & set(AList)

for x in matched:
    exp = "ID = " + x
    arcpy.SelectLayerByAttribute_management(flayer, "ADD_TO_SELECTION", exp)
    arcpy.SelectLayerByAttribute_management(flayer, "SWTCH_SELECTION")

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MathewCoyle — Tue, 23 Apr 2013 14:40:52 GMT

It sounds like you are using ArcGIS 10.0 not 10.1.

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MichelleCouden1 — Tue, 23 Apr 2013 15:12:32 GMT

Yep, you are correct! I am sorry I did not check. I forgot I work for the state. They don't believe in current. So from the previous threads, I should be using I can use the sort fields I just have it coded wrong correct??? I am sorry this version stuff is hard for me to get.

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

ChrisSnyder — Tue, 23 Apr 2013 15:33:11 GMT

Use the "traditional cursor method" shown here: http://forums.arcgis.com/threads/82818-quot-Search-Cursor()-got-an-unexpected-keyword-argument-sort_fields?p=291755&viewfull=1#post291755

Since you are using v10.0, you cannot use the named parameter feature.

Upgrade! v10.2 will be out in June...

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MichelleCouden1 — Fri, 10 Dec 2021 23:33:41 GMT

OK, when I change my code to work for the traditional cursors I get the lovely Error: 999999: Error executing function. Which from what i get from other threads in the forum, this is not good. Iam running it in the python window inside the mxd could that be the problem?

import arcpy

flayer = "AADT"
alayer = "AADTAnnoLabel"

FRows = arcpy.SearchCursor(flayer,"","","","FLAG")
ARows = arcpy.SearchCursor(alayer,"","","","TFLAG")

FList = []
AList = []

for row in FRows:
    Fvalue = row.getValue("FLAG")
    FList.append(str(Fvalue))

for rows in ARows:
    Avalue = row.getValue("TFLAG")
    AList.append(str(Avalue))

matched = set(FList) & set(AList)

for x in matched:
    exp = "ID = " + x
    arcpy.SelectLayerByAttribute_management(flayer, "ADD_TO_SELECTION", exp)
    arcpy.SelectLayerByAttribute_management(flayer, "SWTCH_SELECTION")
Runtime error <type 'exceptions.RuntimeError'>: ERROR 999999: Error executing function.

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MichelleCouden1 — Tue, 23 Apr 2013 19:09:03 GMT

I think I would rather it start in the PythonWin window instead of the window in ArcMAP. Because I did learn there are other codes for searching. I need help at the start of the code to make that work, because I've only written codes with parameters being set and this one doesn't need it.

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

ChrisSnyder — Tue, 23 Apr 2013 19:16:00 GMT

import arcpy
flayer = "AADT"
alayer = "AADTAnnoLabel"

Seems like you need to better define the paths to your inputs. Also, are you sure the fields you are attempting to sort exist in the input tables? Are you sure these are the actual field names and not just aliases?

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MathewCoyle — Fri, 10 Dec 2021 23:33:44 GMT

import arcpy

flayer = "AADT"
alayer = "AADTAnnoLabel"

FRows = arcpy.SearchCursor(flayer,"","","","FLAG")
ARows = arcpy.SearchCursor(alayer,"","","","TFLAG")

FList = []
AList = []

for row in FRows:
    Fvalue = row.getValue("FLAG")
    FList.append(str(Fvalue))

for rows in ARows:
    Avalue = row.getValue("TFLAG")
    AList.append(str(Avalue))

matched = set(FList) & set(AList)

for x in matched:
    exp = "ID = " + x
    arcpy.SelectLayerByAttribute_management(flayer, "ADD_TO_SELECTION", exp)
    arcpy.SelectLayerByAttribute_management(flayer, "SWTCH_SELECTION")
Runtime error <type 'exceptions.RuntimeError'>: ERROR 999999: Error executing function.

Is the error coming from your search cursor line? If so the most likely cause of a 999999 error is that the fields you are trying to sort by do not exist in that table.

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MichelleCouden1 — Wed, 24 Apr 2013 12:15:32 GMT

Your good Matt!! Yeah, it's coming from the search cursor line. I did talk to some guys across the hallway and they said just make it a stand alone script in PythonWin because the search cursor commands inside the ArcMAP python window are different. I've only set parameters at the beginning of a code. What would I put at the begnning of this code to make it work as a script tool in ArcMAP without parameters. For Example: He would just open or start the script from the toolbox and it would work that mxd.

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MichelleCouden1 — Fri, 10 Dec 2021 23:33:47 GMT

Would I do an mxd = arcpy.mapping.MapDocument..... and then a lstLayers. In order for it to be a stand alone script that I could move into a toolbox. See code below:

import arcpy

mxd = arcpy.mapping.MapDocument(r"K:\TASS\4_MAPPING_DATA_SUPPORT\Traffic_Mapping\District_Maps\2012\Abilene")
lstLayers = arcpy.mapping.ListLayers(mxd)

flayer = "AADT"
alayer = "AADTAnnoLabel"

FRows = arcpy.SearchCursor(flayer,"","","","FLAG")
ARows = arcpy.SearchCursor(alayer,"","","","TFLAG")

FList = []
AList = []

for row in FRows:
    Fvalue = row.getValue("FLAG")
    FList.append(str(Fvalue))

for rows in ARows:
    Avalue = row.getValue("TFLAG")
    AList.append(str(Avalue))

matched = set(FList) & set(AList)

for x in matched:
    exp = "ID = " + x
    arcpy.SelectLayerByAttribute_management(flayer, "ADD_TO_SELECTION", exp)
    arcpy.SelectLayerByAttribute_management(flayer, "SWTCH_SELECTION")

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MathewCoyle — Fri, 10 Dec 2021 23:33:49 GMT

Yes you can do that. You would just need to reference the layer names as layer objects in the mxd.

eg

flayer = arcpy.mapping.ListLayers(mxd, "AADT")[0]
alayer = arcpy.mapping.ListLayers(mxd, "AADTAnnoLabel")[0]

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MichelleCouden1 — Wed, 24 Apr 2013 18:23:29 GMT

Thank You Matt for all your help!! You to csny490!! You guys are the best! I really appreciate all your help!!

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MichelleCouden1 — Fri, 10 Dec 2021 23:33:52 GMT

I am getting an exception raised on the SearchCursor. So wouldn't I change the Search Cursor code to, look at the layer and then add a ListFields line of code like what I have below:

import arcpy

mxd = arcpy.mapping.MapDocument(r"K:\TASS\2 - GEO-DATA PROCESSING SUPPORT\MICHELLE'S WORK_ENTER NOT!!\Work Folder\Python Programming\Wayne's Tools\Abilene_Base_Map.mxd")
lstLayers = arcpy.mapping.ListLayers(mxd)

flayer = arcpy.mapping.ListLayers(mxd, "AADT")[0]
alayer = arcpy.mapping.ListLayers(mxd, "AADTAnnoLabel")[0]

FRows = arcpy.SearchCursor(flayer)
ARows = arcpy.SearchCursor(alayer)

fields = arcpy.ListFields(mxd, "", "FLAG")

FList = []
AList = []

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

MichelleCouden1 — Thu, 25 Apr 2013 14:36:15 GMT

I am getting an exception raised on my for row lines. I am thinking it is because I have notdeclared the field names correctly. Would I use the ListFields command line or something else.

import arcpy  mxd = arcpy.mapping.MapDocument(r"K:\TASS\2 - GEO-DATA PROCESSING SUPPORT\MICHELLE'S WORK_ENTER NOT!!\Work Folder\Python Programming\Wayne's Tools\Abilene_Base_Map.mxd") lstLayers = arcpy.mapping.ListLayers(mxd)  flayer = arcpy.mapping.ListLayers(mxd, "AADT")[0] alayer = arcpy.mapping.ListLayers(mxd, "AADTAnnoLabel")[0]  FRows = arcpy.SearchCursor(flayer) ARows = arcpy.SearchCursor(alayer)  #ffields = arcpy.ListFields(mxd, "", "FLAG") #afields = arcpy.ListFields(mxd, "", "TFLAG")  FList = [] AList = []  for row in FRows:     Fvalue = row.getValue("FLAG")     FList.append(str(Fvalue))  for rows in ARows:     Avalue = row.getValue("TFLAG")     AList.append(str(Avalue))  matched = set(FList) & set(AList)  for x in matched:     exp = "ID = " + x     arcpy.SelectLayerByAttribute_management(flayer, "ADD_TO_SELECTION", exp)     arcpy.SelectLayerByAttribute_management(flayer, "SWTCH_SELECTION")

topic Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'??? in Python Questions

&quot;Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

Re: "Search Cursor() got an unexpected keyword argument 'sort_fields'???

"Search Cursor() got an unexpected keyword argument 'sort_fields'???