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()
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.
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()
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