Latest Contributions by JoshuaChan2

I find the ESRI help links confusing and unfortunately I cannot find the one I'm looking for. But basically there is a layer property connection that uses a python dictionary to store old/new connection info.  That is the one you need. not the aprx properties method.  I am not very good with python nor dictionaries so I had a colleague help me decipher all this.   I have an excel sheet that stores the old & new fullpath names. It goes thru the aprx looking for broken links. If found it compares it with the spreadsheet to grab the new connection properties and uses the layer.updateConnectionProperties method to change it.  I have some extra lines to document where I have a broken layer but it's not in the spreadsheet - just to alert myself that there's some other layers that probably warrant future investigation. There's also a bit about "bcgw.bcgov" which is our SDE. I didn't want to record those as I was running from an IDE and not connected to our database. I just wanted to ignore those.  # go thru a folder and look for aprx import os import arcpy import pandas as pd # !!! change this for your folder and your Excel that shows your old and new link my_workspace = r"W:\blah\temp\test3" my_changes_excel = r"W:\blah\temp\test3\test_data_changes.xlsx" # !!! this excel stores the broken links that were not found in the spreadsheet above new_excel = my_workspace + '/broken_layers.xlsx' if os.path.exists(new_excel): os.remove(new_excel) def make_aprx_list(wksp): # search the main directory for the APRX files aprx_list = [] # resetting the list for root, dirs, files in os.walk(my_workspace): for f in files: if f.endswith(".aprx"): print(os.path.join(root, f)) aprx_list.append(os.path.join(root, f)) return(aprx_list) if __name__ == "__main__": mylist = make_aprx_list(my_workspace) df = pd.read_excel(my_changes_excel) for aprx_name in mylist: # create pandas dataframe to store broke lyrs with no fix brokenlayers = pd.DataFrame(columns = ['broken layer']) #print(aprx_name) aprx = arcpy.mp.ArcGISProject(aprx_name) for m in aprx.listMaps(): for l in m.listLayers(): if l.isGroupLayer == False: if l.isBroken == True: if l.dataSource in df['old'].values: new_lyr = df.loc[df["old"]== l.dataSource, "new"].values[0] #print(new_lyr) new_connection = l.connectionProperties.copy() old_connection = l.connectionProperties new_connection['dataset'] = new_lyr.rsplit('\\', 1)[1] # new layer name new_connection['connection_info']['database'] = new_lyr.rsplit('\\', 1)[0] #new layer location (i.e. gdb or shapefile in folder) l.updateConnectionProperties(old_connection, new_connection) print('Connection updated: ' + new_lyr.rsplit('\\', 1)[1]) else: if l.dataSource.find('bcgw.bcgov') == -1: print('Broken layer not found: ' + l.dataSource) brokenlayers.loc[len(brokenlayers.index)] = l.dataSource split_name = aprx_name.rsplit('.',1) new_name = split_name[0] + '_brokenLayersFixed' #aprx.saveACopy(new_name) aprx.save() # append record to Excel if the excel exists. if not create it then write to it. if len(brokenlayers)>0: if os.path.exists(new_excel): with pd.ExcelWriter(new_excel, mode="a") as writer: brokenlayers.to_excel(writer, sheet_name = aprx_name.rsplit('\\', 1)[1]) else: with pd.ExcelWriter(new_excel, mode="w") as writer: brokenlayers.to_excel(writer, sheet_name = aprx_name.rsplit('\\', 1)[1]) print('finito')   ... View more

so far no luck... I've tried ChatGPT too but it pointed me to a function that existed in ArcMap 10.8... not pro.    anyone else? ... View more

for line 19 re: shapefiles - actually we also have KMZs too which I'm not going to talk about...  also line 19: I was hoping the search and replace function would have worked for the full path like searching for an entire sentence vs just replacing a single word.  line 9; in the "real" script I'm getting the list of broken layers to review from the aprx.ListBrokenDatasources() and then comparing those to my excel sheet where I hold the old vs new. So the old/new will be a text string I'll try layer connections and let you know how it goes.    ... View more

wanted to echo Meg's comment that email is the most preferred method of communication. I'm not constantly plugged in to AGO. Also it's a lot more plugged in to how we schedule our work around here. Our email is connected to our calendars.  ... View more

hi John I took a look and so far so good... but I have an account on a different subscription (https://governmentofbc.maps.arcgis.com/home/signin.html ) that requires me to use a different log in. How do I access it via the "BCGOV" button instead of the usual ArcGIS Online login?  ... View more

thanks. I'll have a look is ipynb only viewable in Jupyter notebook? ... View more

P.S. i accidentally hit the button that said "Assumed Answered" but I don't know how to turn that off.... help? ... View more

many instances where this would be useful... please vote! ... View more

about 4 wks ago... but I've had to change projects since then please add that in the documentation - to never move the survey123 files out of their folder. that would have saved me half of the headaches I experienced here. ... View more

a lot of things that says you can overwrite will come back with error messages. things like changing drop down lists. it's been a while - i've forgotten the details. ... View more

nobody else knows what happened to Snap2Map?? ... View more

Hi Shelby I haven’t received any emails from you before this one – so if there were any others please send my way. It would be great to have better documentation on what is and what isn’t allowed when republishing surveys. I find the existing document<https://doc.arcgis.com/en/survey123/desktop/create-surveys/publishsurvey.htm#ESRI_SECTION1_97A01E11C37D401EB95C7D22EF251F66> on this to be flat out wrong or at the very least, misleading. I ended up giving up and publishing a new survey, recreating my web map, relinking my dashboard, all the while cursing under my breath ... View more