Latest Contributions by JeroenWisse

Hi Bruce, Thank you for your help, I tried repairing the 10.5.1 version but after that I could not browse for datasets in DI for pro. I will try again and see if it works. I'll keep you updated. ... View more

Yes he has. I can run the extension. The problem is that I can't get the tool to work in both ArcGis Desktop and ArcGis Pro. They both have theire sperate install but somehow the installations of both versions corrupt each other. ... View more

Hi Dan, Thanks for your help but I have already installed the 64-bit version which I downloaded from my.esri.com Jeroen ... View more

Thanks for the replies all. I think the problem is something in one of my settings because when I do the following simple arcpy command in python: import arcpy arcpy.env.workspace = "Database Connections\\xyz_select@geooraint.sde" featureclasses = arcpy.ListFeatureClasses() print (str(len(featureclasses)))‍‍‍‍‍‍‍ It gives me 0 results. This is straight from python. So arcpy from python seems to think there are no feature classes in the old geodatabase. When I run the exact same command from the python window in arcmap i get something like 1600 results, which should be correct. Both python versions give the same version number (2.7.12). Does anyone have an idea of a setting that I need to change? ... View more

Hi, Thanks for your answer I still had problems and your solution seems to work. The only problem now is that python seems to crash at some points but the solution seems to work. ... View more

I guess no one has an idea of how to fix it? Does it work for other users? ... View more

I haven't tested this code but it should work, or at least not much editing 🙂 #Specify output path and final output PDF outPath = r"C:MyProjectoutput\" finalPdf = arcpy.mapping.PDFDocumentCreate(outPath + "ParcelReport.pdf") #Specify the map document and the data frame mxd = arcpy.mapping.MapDocument(r"C:MyProjectMyParcelMap.mxd") df = arcpy.mapping.ListDataFrames(mxd, "Layers")[0] #Select a parcel using the LocAddress attribute and zoom to selected parcelLayer = arcpy.mapping.ListLayers(mxd, "Parcels", df)[0] arcpy.SelectLayerByAttribute_management(parcelLayer, "NEW_SELECTION", "LocAddress" = '519 Main St') df.zoomToSelectedFeatures() #Turn on visibility for each theme and export the page lyrList = ["Soils", "Floodplains", "Zones"] for lyrName in lyrList:     lyr = arcpy.mapping.ListLayers(mxd, lyrName, df)[0]     lyr.visible = True     #Export each theme to a temporary PDF and append to the final PDF     tmpPdf = outPath + lyrName + "_temp.pdf"     if os.path.exists(tmpPdf):         os.remove(tmpPdf)     arcpy.mapping.ExportToPDF(mxd, tmpPdf)     finalPdf.appendPages(tmpPdf)     #Turn off layer visibility and clean up for next pass through the loop     lyr.visible = False     del lyr, tmpPdf     del mxd, df, finalPdf The above code only exports the 3 pdf's for location address 519 Main St. The layers it sets as visible are Soils,Floodplains and Zones. If you want to automate the entire process then you need to have a list or a way to get the locaddresses. You could then loop trough the location adressess like this: lyrList = ["Soils", "Floodplains", "Zones"] for locaAddress in locAdresses:     finalPdf = arcpy.mapping.PDFDocumentCreate(outPath + "ParcelReport "+locAddress+".pdf")     arcpy.SelectLayerByAttribute_management(parcelLayer, "NEW_SELECTION", "LocAddress" = locAddress)     df.zoomToSelectedFeatures()     for lyrName in lyrList:         lyr = arcpy.mapping.ListLayers(mxd, lyrName, df)[0]         lyr.visible = True         #Export each theme to a temporary PDF and append to the final PDF         tmpPdf = outPath + lyrName + "_temp.pdf"         if os.path.exists(tmpPdf):             os.remove(tmpPdf)         arcpy.mapping.ExportToPDF(mxd, tmpPdf)         finalPdf.appendPages(tmpPdf)         #Turn off layer visibility and clean up for next pass through the loop         lyr.visible = False         del lyr, tmpPdf Again the above code isn't tested but the idea is that it should give you 800 pdf's name for example ParcelRepor t519 Main St.pdf It should contain 3 pages (because the lyrList has 3 items). I hope this helps ... View more

I am not entirely sure what you are trying to do. Could you please explain it. Also when you post code can you use the code tag? It makes the code more readable. ... View more

It would be nice to see the functions as well. What is the value of your newDBPath?  They should be just the name of the dataset, not the data source.  Perhaps you could change the value to equal layer.datasetName. Jeff The function findNewPath searches a csv file for the new connection and featureclass name. The newDBPath contains just the name of the feature class /table etc. Some examples of the newDBPath: GEONAM_BDMSNRSNRGRD GEONAM_BDMSNRGRNDCONVRNVLK GEONAM_WTRSANCONGRDWTRVLK newDBconnection="Database Connections\\xyz@geooraont.sde\\" As you can see there is no dataset there which is how it should be. The newDBConnection is the connection to the sde. Also without any datasets. If i look at the mxd after i run the script it shows the following: The first layer is set correctly without any dataset see the attachment datasourceOK The other layers are set incorrectly see for an example the attachment datasourceNotOK Notice that the feature dataset is still set ... View more

Thanks for your reply. Unfortunately i am not at my work pc (it's evening over here) so i can't give you the relevant code. I will do that tomorrow morning. ... View more

Thanks for your help. I have it fixed now by setting the display fields of the featureLayer in stead of the query. I know i can use the queryIDs() function if i only need the objectid's but i need more. Anyway it works now thanks again ... View more