Very Simple ArcPy script using arcpy.SearchCursor and row.getValue The Next CEO of Stack OverflowGetParameterAsText() error in python scriptError when creating insert cursor in ArcPy?Trying to modify records from one shapefile to another gives Error 999999?Export attributes of shapefiles into text fileUpdate Cursor with Date IssuePerforming Project_management in batch using ArcPy?Runtime error arcpyy using fields[f].append(row.getValue(f))keep getting error while trying to insert row using insert-cursorExecuteError: ERROR 000539: Error running expression: rcexec()
Trouble understanding the speech of overseas colleagues
Whats the best way to handle refactoring a big file?
Apart from "berlinern", do any other German dialects have a corresponding verb?
What is meant by a M next to a roman numeral?
Is a stroke of luck acceptable after a series of unfavorable events?
Why were Madagascar and New Zealand discovered so late?
How to use tikz in fbox?
Why do remote companies require working in the US?
Too much space between section and text in a twocolumn document
MAZDA 3 2006 (UK) - poor acceleration then takes off at 3250 revs
Go Pregnant or Go Home
I believe this to be a fraud - hired, then asked to cash check and send cash as Bitcoin
Fastest way to shutdown Ubuntu Mate 18.10
How do scammers retract money, while you can’t?
How do I go from 300 unfinished/half written blog posts, to published posts?
Unreliable Magic - Is it worth it?
Inappropriate reference requests from Journal reviewers
What does "Its cash flow is deeply negative" mean?
Does the Brexit deal have to be agreed by both Houses?
Should I tutor a student who I know has cheated on their homework?
Where to find order of arguments for default functions
Can a single photon have an energy density?
Is it my responsibility to learn a new technology in my own time my employer wants to implement?
Why does standard notation not preserve intervals (visually)
Very Simple ArcPy script using arcpy.SearchCursor and row.getValue
The Next CEO of Stack OverflowGetParameterAsText() error in python scriptError when creating insert cursor in ArcPy?Trying to modify records from one shapefile to another gives Error 999999?Export attributes of shapefiles into text fileUpdate Cursor with Date IssuePerforming Project_management in batch using ArcPy?Runtime error arcpyy using fields[f].append(row.getValue(f))keep getting error while trying to insert row using insert-cursorExecuteError: ERROR 000539: Error running expression: rcexec()
I am trying to run a very simple script to test the usage of arcpy.SearchCursor and row.getValue.
I want to do a very simple exercise: I have a table with some fields, and I want to print the values of one of the fields (e.g. fldname) for every record.
The script is the below:
import arcpy
IN_Table = "C:/ZZtest/test.mdb/table"
Field1="fldname"
cursor=arcpy.SearchCursor(IN_Table)
for row in cursor:
printf=row.getValue(Field1)
print(printf)
del row, cursor
When I am running this I have the error below:
Traceback (most recent call last):
File "C:ZZtestScriptName.py", line 28, in <module>
printf=str(row.getValue(Field1))
File "C:Program Files (x86)ArcGISEngine10.2arcpyarcpyarcobjectsarcobjects.py", line 1048, in getValue
return convertArcObjectToPythonObject(self._arc_object.GetValue(*gp_fixargs(args)))
RuntimeError: ERROR 999999: Error executing function.
I tried to search for similar questions. But they all included more complicated scripts.
My ArcGIS version is 10.2.
The type of the "fldname" field is Integer.
Where is my mistake?
arcpy cursor
add a comment |
I am trying to run a very simple script to test the usage of arcpy.SearchCursor and row.getValue.
I want to do a very simple exercise: I have a table with some fields, and I want to print the values of one of the fields (e.g. fldname) for every record.
The script is the below:
import arcpy
IN_Table = "C:/ZZtest/test.mdb/table"
Field1="fldname"
cursor=arcpy.SearchCursor(IN_Table)
for row in cursor:
printf=row.getValue(Field1)
print(printf)
del row, cursor
When I am running this I have the error below:
Traceback (most recent call last):
File "C:ZZtestScriptName.py", line 28, in <module>
printf=str(row.getValue(Field1))
File "C:Program Files (x86)ArcGISEngine10.2arcpyarcpyarcobjectsarcobjects.py", line 1048, in getValue
return convertArcObjectToPythonObject(self._arc_object.GetValue(*gp_fixargs(args)))
RuntimeError: ERROR 999999: Error executing function.
I tried to search for similar questions. But they all included more complicated scripts.
My ArcGIS version is 10.2.
The type of the "fldname" field is Integer.
Where is my mistake?
arcpy cursor
Welcome to GIS SE. As a new user please take the Tour. Please edit the question to specify the exact version of ArcGIS in use. Your first mistake was using an "old" SearchCursor at all. They have been replaced by Data Access cursors (arcpy.da.SearchCursor
), which use a different row access protocol. Using personal geodatabase could also be mistake (they are not compatible with 64-bit arcpy). But the problem lies with the datatype of or data within the "fldname" column (which you will need to describe in the question text)
– Vince
Dec 20 '16 at 12:29
add a comment |
I am trying to run a very simple script to test the usage of arcpy.SearchCursor and row.getValue.
I want to do a very simple exercise: I have a table with some fields, and I want to print the values of one of the fields (e.g. fldname) for every record.
The script is the below:
import arcpy
IN_Table = "C:/ZZtest/test.mdb/table"
Field1="fldname"
cursor=arcpy.SearchCursor(IN_Table)
for row in cursor:
printf=row.getValue(Field1)
print(printf)
del row, cursor
When I am running this I have the error below:
Traceback (most recent call last):
File "C:ZZtestScriptName.py", line 28, in <module>
printf=str(row.getValue(Field1))
File "C:Program Files (x86)ArcGISEngine10.2arcpyarcpyarcobjectsarcobjects.py", line 1048, in getValue
return convertArcObjectToPythonObject(self._arc_object.GetValue(*gp_fixargs(args)))
RuntimeError: ERROR 999999: Error executing function.
I tried to search for similar questions. But they all included more complicated scripts.
My ArcGIS version is 10.2.
The type of the "fldname" field is Integer.
Where is my mistake?
arcpy cursor
I am trying to run a very simple script to test the usage of arcpy.SearchCursor and row.getValue.
I want to do a very simple exercise: I have a table with some fields, and I want to print the values of one of the fields (e.g. fldname) for every record.
The script is the below:
import arcpy
IN_Table = "C:/ZZtest/test.mdb/table"
Field1="fldname"
cursor=arcpy.SearchCursor(IN_Table)
for row in cursor:
printf=row.getValue(Field1)
print(printf)
del row, cursor
When I am running this I have the error below:
Traceback (most recent call last):
File "C:ZZtestScriptName.py", line 28, in <module>
printf=str(row.getValue(Field1))
File "C:Program Files (x86)ArcGISEngine10.2arcpyarcpyarcobjectsarcobjects.py", line 1048, in getValue
return convertArcObjectToPythonObject(self._arc_object.GetValue(*gp_fixargs(args)))
RuntimeError: ERROR 999999: Error executing function.
I tried to search for similar questions. But they all included more complicated scripts.
My ArcGIS version is 10.2.
The type of the "fldname" field is Integer.
Where is my mistake?
arcpy cursor
arcpy cursor
edited Dec 20 '16 at 15:23
whyzar
10.7k92866
10.7k92866
asked Dec 20 '16 at 12:12
PhilpPhilp
185
185
Welcome to GIS SE. As a new user please take the Tour. Please edit the question to specify the exact version of ArcGIS in use. Your first mistake was using an "old" SearchCursor at all. They have been replaced by Data Access cursors (arcpy.da.SearchCursor
), which use a different row access protocol. Using personal geodatabase could also be mistake (they are not compatible with 64-bit arcpy). But the problem lies with the datatype of or data within the "fldname" column (which you will need to describe in the question text)
– Vince
Dec 20 '16 at 12:29
add a comment |
Welcome to GIS SE. As a new user please take the Tour. Please edit the question to specify the exact version of ArcGIS in use. Your first mistake was using an "old" SearchCursor at all. They have been replaced by Data Access cursors (arcpy.da.SearchCursor
), which use a different row access protocol. Using personal geodatabase could also be mistake (they are not compatible with 64-bit arcpy). But the problem lies with the datatype of or data within the "fldname" column (which you will need to describe in the question text)
– Vince
Dec 20 '16 at 12:29
Welcome to GIS SE. As a new user please take the Tour. Please edit the question to specify the exact version of ArcGIS in use. Your first mistake was using an "old" SearchCursor at all. They have been replaced by Data Access cursors (
arcpy.da.SearchCursor
), which use a different row access protocol. Using personal geodatabase could also be mistake (they are not compatible with 64-bit arcpy). But the problem lies with the datatype of or data within the "fldname" column (which you will need to describe in the question text)– Vince
Dec 20 '16 at 12:29
Welcome to GIS SE. As a new user please take the Tour. Please edit the question to specify the exact version of ArcGIS in use. Your first mistake was using an "old" SearchCursor at all. They have been replaced by Data Access cursors (
arcpy.da.SearchCursor
), which use a different row access protocol. Using personal geodatabase could also be mistake (they are not compatible with 64-bit arcpy). But the problem lies with the datatype of or data within the "fldname" column (which you will need to describe in the question text)– Vince
Dec 20 '16 at 12:29
add a comment |
1 Answer
1
active
oldest
votes
Welcome to the GIS SE.
I have edited your script. Please note:
I have updated the search cursor to include the new, faster "da" approach. Please read up on using cursors here
The script below will print out the value of the fld_name for each row in the table.
Please use the raw input format when trying to identify file locations.
import arcpy
in_table = r"c:/ZZtest/test.mdb/table"
with arcpy.da.SearchCursor(in_table, ["fld_name"]) as scursor:
for srow in scursor:
print srow[0]
del srow, scursor
Thank you for your suggestions. I used this script and also changed the .mdb to a .gdb and it worked.
– Philp
Dec 20 '16 at 13:40
no problem. Please mark the question as answered to close it.
– MacroZED
Dec 20 '16 at 13:41
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f222063%2fvery-simple-arcpy-script-using-arcpy-searchcursor-and-row-getvalue%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Welcome to the GIS SE.
I have edited your script. Please note:
I have updated the search cursor to include the new, faster "da" approach. Please read up on using cursors here
The script below will print out the value of the fld_name for each row in the table.
Please use the raw input format when trying to identify file locations.
import arcpy
in_table = r"c:/ZZtest/test.mdb/table"
with arcpy.da.SearchCursor(in_table, ["fld_name"]) as scursor:
for srow in scursor:
print srow[0]
del srow, scursor
Thank you for your suggestions. I used this script and also changed the .mdb to a .gdb and it worked.
– Philp
Dec 20 '16 at 13:40
no problem. Please mark the question as answered to close it.
– MacroZED
Dec 20 '16 at 13:41
add a comment |
Welcome to the GIS SE.
I have edited your script. Please note:
I have updated the search cursor to include the new, faster "da" approach. Please read up on using cursors here
The script below will print out the value of the fld_name for each row in the table.
Please use the raw input format when trying to identify file locations.
import arcpy
in_table = r"c:/ZZtest/test.mdb/table"
with arcpy.da.SearchCursor(in_table, ["fld_name"]) as scursor:
for srow in scursor:
print srow[0]
del srow, scursor
Thank you for your suggestions. I used this script and also changed the .mdb to a .gdb and it worked.
– Philp
Dec 20 '16 at 13:40
no problem. Please mark the question as answered to close it.
– MacroZED
Dec 20 '16 at 13:41
add a comment |
Welcome to the GIS SE.
I have edited your script. Please note:
I have updated the search cursor to include the new, faster "da" approach. Please read up on using cursors here
The script below will print out the value of the fld_name for each row in the table.
Please use the raw input format when trying to identify file locations.
import arcpy
in_table = r"c:/ZZtest/test.mdb/table"
with arcpy.da.SearchCursor(in_table, ["fld_name"]) as scursor:
for srow in scursor:
print srow[0]
del srow, scursor
Welcome to the GIS SE.
I have edited your script. Please note:
I have updated the search cursor to include the new, faster "da" approach. Please read up on using cursors here
The script below will print out the value of the fld_name for each row in the table.
Please use the raw input format when trying to identify file locations.
import arcpy
in_table = r"c:/ZZtest/test.mdb/table"
with arcpy.da.SearchCursor(in_table, ["fld_name"]) as scursor:
for srow in scursor:
print srow[0]
del srow, scursor
edited yesterday
Miro
5,24953464
5,24953464
answered Dec 20 '16 at 12:59
MacroZEDMacroZED
2,074519
2,074519
Thank you for your suggestions. I used this script and also changed the .mdb to a .gdb and it worked.
– Philp
Dec 20 '16 at 13:40
no problem. Please mark the question as answered to close it.
– MacroZED
Dec 20 '16 at 13:41
add a comment |
Thank you for your suggestions. I used this script and also changed the .mdb to a .gdb and it worked.
– Philp
Dec 20 '16 at 13:40
no problem. Please mark the question as answered to close it.
– MacroZED
Dec 20 '16 at 13:41
Thank you for your suggestions. I used this script and also changed the .mdb to a .gdb and it worked.
– Philp
Dec 20 '16 at 13:40
Thank you for your suggestions. I used this script and also changed the .mdb to a .gdb and it worked.
– Philp
Dec 20 '16 at 13:40
no problem. Please mark the question as answered to close it.
– MacroZED
Dec 20 '16 at 13:41
no problem. Please mark the question as answered to close it.
– MacroZED
Dec 20 '16 at 13:41
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f222063%2fvery-simple-arcpy-script-using-arcpy-searchcursor-and-row-getvalue%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Welcome to GIS SE. As a new user please take the Tour. Please edit the question to specify the exact version of ArcGIS in use. Your first mistake was using an "old" SearchCursor at all. They have been replaced by Data Access cursors (
arcpy.da.SearchCursor
), which use a different row access protocol. Using personal geodatabase could also be mistake (they are not compatible with 64-bit arcpy). But the problem lies with the datatype of or data within the "fldname" column (which you will need to describe in the question text)– Vince
Dec 20 '16 at 12:29