Latest Contributions by Nicole_Ueberschär

Thank you both for your replies.  I have a field of the type text that has profile numbers which can be 1, 2, 3 but also 2a, 2b, 2c, etc. that's why I store them as text. My script worked before for one file with 1, 2, 3b, 4, 5b, 6, 7, 8  so I guess it is working as long there is only once the number with a letter but not if the same number has many letters.  The script works when I just leave away the "sorted". Thanks! ... View more

As far as I can see, yes. I added this to have all selected: self.params[3].value=self.params[1].filter.list after your line 79. I also had to add another loop to go through all tables in the folder. It turned out (in contrast to what I thought) that not all tables have data for the same indicators... This is my updated validation code. Note, that I have params[3] in the end... Ah, yes, and I added a lower case sort of the field names.  def updateParameters(self): """Modify the values and properties of parameters before internal validation is performed. This method is called whenever a parameter has been changed.""" filedir=self.params[0].value if filedir: arcpy.env.workspace = filedir list_of_files = arcpy.ListFiles("*.txt") firsttable=list_of_files[0] for txtfile in list_of_files: complete_filename = str(filedir)+"\\"+str(txtfile) table=arcpy.MakeTableView_management(complete_filename, "kivu_tview") desc = arcpy.Describe(table) arcpy.AddMessage("Table to be analyzed: "+str(table)) fieldselectlist=[] #Will collect the field names for ofields in desc.fields: ftype=ofields.type fname=ofields.name.encode("utf-8") if ftype in ["Double","Long"]: #print(fname) if fname not in ["Profile_No","Longitude (degrees_east)" ,"Latitude (degrees_north)" ,"Bot. Depth (m)","Depth (m)","Depth (0.5 m )" ,"Depth (0.5 m)","Distance from platform","Time (actual)"]: with arcpy.da.SearchCursor(table, fname) as calcursor: for calcrow in calcursor: if calcrow[0] is not None: if calcrow[0] not in fieldselectlist: fieldselectlist.append(fname) break arcpy.AddMessage(fieldselectlist) arcpy.Delete_management("kivu_tview","Table View") # delete table view #sorted_list=fieldselectlist.sort(key=str.lower) #sorted_list=fieldselectlist.sort(key=lambda x:x.lower()) if 'pH' in fieldselectlist and 'pH corrected' in fieldselectlist: fieldselectlist.remove('pH') if 'Dissolved Oxygen (mg/L)' in fieldselectlist and 'Dissolved Oxygen corrected (mg/L)' in fieldselectlist: fieldselectlist.remove('Dissolved Oxygen (mg/L)') sorted_list_not_cs=sorted(fieldselectlist,key=str.lower) arcpy.AddMessage("sortiert, not case sensitive: "+str(sorted_list_not_cs)) # for multiple choice try: if self.params[3].values: #if this parameter has seleted values oldValues = self.params[3].values #set old values to the selected values except Exception: pass self.params[3].filter.list = sorted_list_not_cs #set the filter list equal to the sorted values newValues = self.params[3].filter.list self.params[3].value=self.params[3].filter.list try: if len(oldValues): # if some values are selected self.params[3].values = [v for v in oldValues if v in newValues] # check if seleted values in new list, # if yes, retain the seletion. except Exception: pass #self.params[3].filter.list=sorted(fieldselectlist) return‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

Strange... For me both don't do anything.  ... View more

Yes, that was also the work around I thought of.  ... View more

Is there a way to enable the "Select all/unselect all" functionality for the tool?  I was able to "select all" after loading the list through the validator but the buttons inside the tool don't work. I guess that would another "on change" event but how do I catch that? ... View more

Thanks a lot! ... View more

Awesome, thanks a lot, Randy! Works great! ... View more

Well, I used the create Attachments option in the context menu of the feature class. That creates the attachment table and the attachment relationship class. The attachments themselves are created and attached through a python script.  When I do the same (step by step) through the toolbox I end up with the same result.    I can see the attachments with the identify tool but I cannot access them through the related table in the attribute table. That can't be wanted... ... View more