Latest Contributions by StephenM

Thanks Joshua! I forgot to mention that I had tried registering, but ran into errors when doing so. I just ran through the process again and I think my issue was that the shape field was set to be "not null". I set the shape field to be nullable and was able to register the table. Now that the table is registered the associated feature layer works fine in a dashboard. I wasn't sure if I needed to register the table, but it looks like that was the key. The steps I took were: Used SQL Server Management Studio to add and populate a geometry field in the table based on lat/long Used the Register with Geodatabase tool to register the table with the geodatabase, allowing the tool to create an ObjectID and using the geometry field for the shape Added spatial index Is that about right? ... View more

I've run into this issue before as well. It seems like changing the field names using the Make Feature Layer "field_info" parameter doesn't work. My solution was to use field mapping and the Feature Class to Feature Class tool instead. Here's an example that uses field mapping and the Feature Class to Feature Class tool to export and rename selected fields from one shapefile to another: dataset = r"C:\Users\username\Desktop\scratch\test_rename.shp" out_path = r"C:\Users\username\Desktop\scratch" out_name = "renamed" # Define the field names (keys) and their replacements (values) # Fields not included here will not be included in the exported dataset rename_dict = {"GRIDCODE":"BATHYMETRY", "GRIDCODE_1":"WIND", "GRIDCODE_2":"WAVE"} # Create a list from the keys in 'rename_dict' rename_fields = list(rename_dict.keys()) # Create a FieldMappings object fmappings = arcpy.FieldMappings() # Populate FieldMap objects with the desired fields, then populate the # FieldMappings object with FieldMap objects for name in rename_fields: fm = arcpy.FieldMap() fm.addInputField(dataset, name) fmappings.addFieldMap(fm) # Store the list of FieldMap objects that make up the FieldMappings object fmaps = fmappings.fieldMappings # Get the length of the 'fmaps' list fmaps_count = len(fmaps) # Iterate through the FieldMap objects. Get the Field object returned from the # outputField property, modify the object's name and aliasName properties, replace # the existing outputField property, and replace the field map at the current index. for i in range(fmaps_count): out_field = fmaps[i].outputField out_field.name = rename_dict[fmaps[i].getInputFieldName(0)] out_field.aliasName = rename_dict[fmaps[i].getInputFieldName(0)] fmaps[i].outputField = out_field fmappings.replaceFieldMap(i, fmaps[i]) # Export the input dataset to a new dataset, using 'fmappings' to define the field # map for the new dataset arcpy.FeatureClassToFeatureClass_conversion(dataset, out_path, out_name, "", fmappings, "")‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I had this same question and got it to work using the getattr() function. if ms.enabled: name_field = ms.pageNameField.name for pageNum in range(1, ms.pageCount + 1): ms.currentPageNumber = pageNum pageName = getattr(ms.pageRow, name_field)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

The entire layout should be exported if you uncheck "Clip to Graphics Extent" on the Export Layout dialog box. ... View more

Maybe you could create a separate list of users by checking to see if they belong to the target group. Example: source_users = source.users.search('!esri_ & !admin') group_name = "My Group" users_subset = [] for user in source_users: if len(user.groups) > 0: for group in user.groups: if group.title == group_name: users_subset.append(user) print(user.username + "\t:\t" + str(user.role))‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

You can check for nulls using the string-length function or by checking a value against an empty string. If you nest some "if" statements, the calculation will return once a condition is met. if(string-length(${NEOFormPHONENUMBER}) != 0, ${NEOFormPHONENUMBER}, if(string-length(${NEOFormMOBILENUMBER}) != 0, ${NEOFormMOBILENUMBER}, if(string-length(${NEOFormBUSINESSNUMBER}) != 0, ${NEOFormBUSINESSNUMBER}, if(string-length(${NEOFormEMERGENCYNUMBER}) != 0, ${NEOFormEMERGENCYNUMBER}, "NONE")))) if(${NEOFormPHONENUMBER} != "", ${NEOFormPHONENUMBER}, if(${NEOFormMOBILENUMBER} != "", ${NEOFormMOBILENUMBER}, if(${NEOFormBUSINESSNUMBER} != "", ${NEOFormBUSINESSNUMBER}, if(${NEOFormEMERGENCYNUMBER} != "", ${NEOFormEMERGENCYNUMBER}, "NONE")))) Documentation: Formulas—Survey123 for ArcGIS ... View more