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; } } }

SetParameterAsText To View Python Tool Results

DevinUnderwood2

I have the following which I can successfully get my desired results with the input prompt standalone script. Yet, I prefer that a tool I created to be used and display the results. What am I missing in order to view the results?

#Import Modules
import csv,os,arcpy

#Set variables
ifile  = open('PythonShellSave.csv','r')
reader = csv.reader(ifile)
featureclass = input("Name of the feature class ? ")
#featureclass = arcpy.GetParameterAsText(0)
 
#Set path location of Excel (CSV) file 
path = 'C:\WriteMxdInfoToExcel'
os.chdir(path)

#CSV Module terminology row is horizontal & field is vertical;column is horizontal & row is vertical for excel.
for row in reader:
          for field in row:
              if field == featureclass:
                  print row [4] + " " + featureclass
                 
arcpy.SetParameterAsText(1,row)

#Close Excel (CSV) file
ifile.close()

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

DanPatterson_Retired

your incarnation of the script keeps changing sometimes reflecting comments and sometimes not. Currently you are printing a list in line 20. This is new. Your print statements are now gone. This is also new. All I know is that the file isn't printing and you have not reported any errors. So presumably, your files have been created and are empty since you can open them and close them. The only thing I can suggest is you move the source file to a new location and see if a new empty destination file is created. If so, then you know that the file is being created but nothing is being written to it. Without further print statements, this would narrow down the error to somewhere between lines 13 and 20

DevinUnderwood2

I have the following and trying to write to file when using tool getparameterastext. Its not writing though?

#Import Modules
import csv,os,arcpy

#Set path location of Excel (CSV) file 
path = r'C:\Users\dunderwood\Documents\PyScriptTools\Tools\ToolData'
arcpy.env.workspace = path

#Set variables
ifile  = open('PublishedMapsInfo.csv','r')
ofile = open('Results.csv','w')
reader = csv.reader(ifile)
writer = csv.writer(ofile, delimiter=',', quotechar='"', quoting=csv.QUOTE_ALL)
featureclass = arcpy.GetParameterAsText(0)

#CSV Module terminology row is horizontal & field is vertical;column is horizontal & row is vertical for excel
for row in reader:
          for field in row:
              if field == featureclass:
                  final = (row[4] + " " + featureclass)
                  writer.writerow([final])
                  
                                                   
#arcpy.AddMessage('All Mxds associated with fc = {}'.format(viewmessage))
#Close Excel (CSV) file
ifile.close()
ofile.close()

DevinUnderwood2

Interesting, I added what you suggested and get

All Mxds associated with fc = view results not defined, this means it is not recognizing the loop statements.

This works fine as a stand alone, so I know the loop syntax works fine. However, the AddMessage is the issue with a loop statement.

DanPatterson_Retired

with respect to the addmessage line, where is viewresults defined? if viewresults is being defined within a loop for instance, it may never be seen. So to track down the error, put

viewresults = "view results not defined"

way up at the top of the script so that it always has a value. If that message is returned, it is not being derived or returned elsewhere

DevinUnderwood2

I removed the print statement. I receive an error as follows.

Traceback (most recent call last):

File "...\ReadMxdFCCSV.py", line 34, in <module>

arcpy.AddMessage('All Mxds associated with fc = {}'.format(viewresults))

NameError: name 'viewresults' is not defined

Failed to execute (readmxdFC).

Despite previously setting viewresults as a variable

Any Idea why I am having this error ?

DanPatterson_Retired

you can't jumble them together

msg = "All Mxds associated with fc = {}".format(viewresults)

print(msg)

arcpy.AddMessage(msg)

extra lines don't hurt and print only is used when the script is being run outside of an arctoolbox tool

and AddMessage is used to report tools results .... ie it is the toolbox equivalent of print

DevinUnderwood2

I am getting a returned value of None with the following excerpt of my code.

print viewresults + str(arcpy.AddMessage('All Mxds associated with fc = {}'.format(viewresults)))

What does None refer to ?

RebeccaStrauch__GISP

hmm. Not sure off hand why the AddMessage wouldn't show up in results. here i part of the results from one of my tools that is under construction....all those with the date/time tacked on the end are myMsgs

DevinUnderwood2

Make sense, I will make note of creating better naming conventions.

Interesting how when I run it as a tool the results yield successful but the add message doesn't appear.

Maybe my tool parameters are set incorrectly.

The tool works fine as I use a dropdown to navigate to location of featureclass. This is straight forward.

The output I am not entirely sure about.

RebeccaStrauch__GISP

Not running it myself, if it works in the python window, I would think it would run as a tool. One more warning, try to keep away from any spaces or special characters in file names/paths. I may work, but it will come back to bite you at some points. Also, keep filenames and field names short, i.e. not ThisIsAFieldNameForWhoKnowsWhat

How To Name Things In ArcGIS in Curtis Price's Blog

DevinUnderwood2

I believe this reflects your comments.

#Import Modules
import csv,os,arcpy

#Set variables
ifile  = open('PythonShellSave.csv','r')
reader = csv.reader(ifile)
featureclass = input("Name of the feature class ? ")
#featureclass = arcpy.GetParameterAsText(0)

#Set path location of Excel (CSV) file 
path = r'C:\Users\dunderwood\Documents\My Python Scripts\WriteMxdInfoToExcel'
arcpy.env.workspace = path

#Create Function
def myMsgs(message):
    arcpy.AddMessage(message)
    print(message)

#CSV Module terminology row is horizontal & field is vertical;column is horizontal & row is vertical for excel
for row in reader:
          for field in row:
              if field == featureclass:
                  final = row[4] + " " + featureclass
                  #print(final)
                  message = final
                  myMsgs(message)
                 
#Close Excel (CSV) file
ifile.close()

DevinUnderwood2

Thank you for taking the time to further explain. Will this work in a script that I am using with a tool I created? To automatically display message to results? I tested out the function but it is not automatic when run and seen in python shell. However, as mentioned, my actual goal is to use it as a tool.

I will take a look at the Blog, thanks.

RebeccaStrauch__GISP

if you are going to us

myMsgs(message)

as you show in line 25, then you need to have a

myMsgs(final)

just link you are trying to print in line 24....which line 24 could be commented out.

the myMsgs(message) assuming that the variable "message" is already set, and passes the value of it to the function. if you want that line to stay as is, then add

message = final

before that....assuming "final" is a good variable.

DanPatterson_Retired

your first variable should be

message = "" # two double or two single quotes

also

print(message) # no spaces between print and the bracket

RebeccaStrauch__GISP

If you want something more generic with a time stamp (sorry about the %formatting instead of the {} .format style...haven't updated it for a while)

import time
import arcpy

def timeStamp():
    """
    returns time stamp.
    """
    return time.strftime(' --  %B %d - %H:%M:%S')

def myMsgs(message):
    arcpy.AddMessage(message + ' %s' %(timeStamp()))
    print(message)     # + ' %s' %(timeStamp()))

then if you enter

myMsgs("you message here with whatever formatting {0}".format(variableToFormat))

the myMsgs will work in either without having to add both lines. works for me (in my_utils.py file) but it is a pain when I have to share my code on the forums.