Latest Contributions by DominicRobergeIADOT

Thanks @TonyAlmeida but that didn't solved my issue. I also tried to create a function just for the query definition that didn't help either.   So I ended up splitting the code into 2 scripts: Step 1 create the query definition, Step2 update the layouts and PDF. Using a Mode Builder I can run both scripts at the same time and no issue. I would love to get the code to run into 1 script but whatever works for now. Thanks!   below was my revised code with the definition query function: import arcpy import os import sys from arcgis import GIS from datetime import datetime # Get today's date today = datetime.today() formatted_date = today.strftime("%m%d%Y") #******************************************************************************************** def GRDefinitionQuery(MapName,LayerName,FieldNumber,LayoutName): newDefinitionQueryString = "SAG_FieldNumber = "+FieldNumber arcpy.AddMessage(newDefinitionQueryString) m= aprx.listMaps(MapName)[0] arcpy.AddMessage(MapName) for lyr in m.listLayers(): arcpy.AddMessage(lyr.name) if lyr.name ==LayerName: arcpy.AddMessage("We found our layer to update") if lyr.supports('DefinitionQuery'): arcpy.AddMessage("here we go") # Updade Definition query dql = lyr.listDefinitionQueries() arcpy.AddMessage("original dql" + str(dql)) for dq in dql: arcpy.AddMessage("in dq") dq['sql'] = newDefinitionQueryString lyr.updateDefinitionQueries(dql) arcpy.AddMessage("revised dql" + str(dql)) count_result = arcpy.management.GetCount(lyr) record_count = int(count_result[0]) arcpy.AddMessage("number of records: " + str(record_count)) break aprx.save() time.sleep(5) # Small delay def GRMapExtent(MapName,LayerName,FieldNumber,FieldName, LayoutName): map_name = MapName arcpy.AddMessage(" " +map_name) layer_name = LayerName map_frame_name = 'Map Frame' # Access the map map_obj = aprx.listMaps(map_name)[0] # Clear any existing selection for lyr in map_obj.listLayers(): if lyr.isFeatureLayer: lyr.setSelectionSet(None) # Get the layer layer = map_obj.listLayers(layer_name)[0] # Use arcpy.Describe to get extent desc = arcpy.Describe(layer) layer_extent = desc.extent count_result = arcpy.management.GetCount(layer) record_count = int(count_result[0]) arcpy.AddMessage(" number of records: " + str(record_count)) # Access the layout and map frame layout = aprx.listLayouts(LayoutName)[0] # or specify layout by name: aprx.listLayouts("LayoutName")[0] map_frame = layout.listElements("mapframe_element", map_frame_name)[0] cursor = arcpy.da.SearchCursor(layer, ['SHAPE@',FieldNumber,FieldName]) arcpy.AddMessage("*****************") for c in cursor: arcpy.AddMessage(u' {0},{1}'.format(c[1],c[2])) strName = c[2] arcpy.AddMessage(" Final Name: " + str(strName)) extent = c[0].extent paddingFirst = extent.XMax-extent.XMin padding = (float(paddingFirst)/float(20)) new_extent=arcpy.Extent(extent.XMin-padding,extent.YMin-padding,extent.XMax+padding,extent.YMax+padding,None,None,None,None,extent.spatialReference) # Set the map frame extent to the layer extent map_frame.camera.setExtent(new_extent) arcpy.AddMessage(" " +"Mainframe extent done") GRLayoutTitle(SAGFieldNunber + " : "+strName+ " "+ l) arcpy.AddMessage(" " +"Title update") GRExportLayouttoPDF(template_name,strName,formatted_date) arcpy.AddMessage(" " +"Export to PDF done") #sys.exit(0) def GRLayoutTitle(TitleName): elm_name = "SAG Title" # the name you assign to the title (TEXT) element p = arcpy.mp.ArcGISProject("CURRENT") for lyt in p.listLayouts(): # get the element for elm in lyt.listElements("TEXT_ELEMENT"): if elm.name == elm_name: elm.text = TitleName def GRExportLayouttoPDF(layoutName,FieldName, strDate): layout_name = layoutName # Name of the layout in your project output_folder= r"C:\temp" output_name = layoutName+"_"+FieldName+"_"+strDate+".pdf" layout = aprx.listLayouts(layout_name)[0] layout.exportToPDF(output_folder+"\\"+output_name, resolution=150) #,jpeg_compression_quality=80, output_as_image=True,compress_vector_graphics=True #******************************************************************************************** arcpy.AddMessage("Let's update the Definition queries") aprx = arcpy.mp.ArcGISProject("CURRENT") LyrName = arcpy.GetParameterAsText(0) FieldName = arcpy.GetParameterAsText(1) name_field = 'SAG_FieldNumber' #'SAG_SiteName' SAGFieldNunber = arcpy.GetParameterAsText(2) SAGFieldName = 'SAG_FieldName' listMaps = ['2021 Ortho','2023 Ortho','LIDAR'] for l in listMaps: arcpy.AddMessage(l + "-------------------------------------------") NewMapName = "SAG_Manure_Map_"+l template_name = "SAG_Manure_Layout_"+l arcpy.AddMessage("Now let's change the Query Definituon") GRDefinitionQuery(NewMapName,LyrName, SAGFieldNunber,template_name) arcpy.AddMessage("Now let's change the extent of the map") GRMapExtent(NewMapName, LyrName,name_field,SAGFieldName,template_name) arcpy.AddMessage("------------------------") arcpy.AddMessage("Definition query updated") ... View more

@Neal_t_k  and @ChristopherCounsell  Thank you both for all the inputs. As I mentioned before, I am trying to minimize the number of fields in the feature class. So I tested adding a true field for the dropdown list.... everything is working fine EXCEPT if I select the Other option.  ex: Original WEI_BMS field has value of JSON, I update the data using the dropdown field (WEI_DBMS_List) to Shapefile and Submit.... both fields have the Shapefile value If original WEI_BMS field has value of Shapefile, I update the data using the dropdown field (WEI_DBMS_List) to Other ... then I get the option to add a new value: let's say I add KMZ and Submit.... WEI_BMS field will have KMZ and the new WEI_DBMS_List field will have Other has a value. I added a pulldata formula in the Calculate and if I click Recalculate I will get the JSON there. I don't want users to have to click to refresh the data. So how could I pass the WEI_DBMS value to the dropdown list if the value is Other? I tried coalesce and if statement and both of them create an error with the parsing.   ... View more

it just make the survey too cluttered.. my users will get confused with this interface. I would probably need 2 surveys: One for initial data entry and one for data editing.      ... View more

@Neal_t_k , I don't think this is going to work as the calculation over write the existing value with the coalesce formula. I am probably going to need an IF statement there instead... ... View more

Hi @ChristopherCounsell  Yes, I have 2 "dummy" fields as NULL used as place holder (one for the dropdown list and one for the "Other" option). I do not want to created true fields has I want to use this process for the entire survey and I have about 10 questions with dropdown list. The current process work GREAT if I create a new entry from scratch. How could I make use of the search functionality to populate a dropdown using live data from the map service, with an Other option in case of a new value for that dropdown and retain the existing value.... all that without having to create 2 extra fields in the layer. Thanks! ... View more

well I know that, I enabled feature access on the feature service with the following options: I have the fields in the the feature service with values: If I don't add them to the survey, they are not returned in the payload. I just need then hidden (or I could probably do with read only)   ... View more

well... never assume the obvious.... One issue was that the date fields were NOT included in the Survey (my bad I should have checked that first..I am taking over from a co-worker).... But now, when I try to add these fields in the survey (read only) I get the following: I did enabled all the options listed above , but still no go. @j-bromp , how to you have the Created_date field setup in the Survey Connect? ... View more

ok, but I also have other DATE fields (not system fields) and those are not coming either   ... View more