Latest Contributions by MarcoPretorius1

Hello!  I am trying to loop through a list in python and the script is only processing the first database and not the remainder of the list. Where is the script wrong?  1 # import packages 2 import os, arcpy, time, smtplib 3 # setup workspace and SDE databases in folder 4 for dirpath, dirnames, filenames in os.walk(r'C:\Users\XXX\AppData\Roaming\Esri\Desktop10.7\ArcCatalog\SDE'): 5 for file in dirpath: 6 print filenames 7 string = 'C:/Users/XXX/AppData/Roaming/Esri/Desktop10.7/ArcCatalog/SDE/' 8 new_list = [string + x for x in filenames] 9 print new_list 10 for database in new_list: 11 # Block new connections to the database. 12 print('The database is no longer accepting connections{}'.format(database)) 13 arcpy.AcceptConnections(database, False) 14 # Wait 5 minutes 15 time.sleep(5) 16 # Disconnect all users from the database. 17 print("Disconnecting all users") 18 arcpy.DisconnectUser(database, "ALL") 19 # Run the compress tool. 20 print("Running compress") 21 arcpy.Compress_management(database) 22 # Allow the database to begin accepting connections again 23 print("Allow users to connect to the database again") 24 arcpy.AcceptConnections(database, True) 25 # Rebuild indexes in database(s) 26 print("Rebuilding indexes on the system tables") 27 arcpy.RebuildIndexes_management(database, "SYSTEM") 28 # Updating statistics in database(s) 29 print("Updating statistics on the system tables") 30 arcpy.AnalyzeDatasets_management(database, "SYSTEM") 31 print ("Finished") 32 break 33 break 34 break ... View more

I keep getting this error when trying to batch export KMZ's into a file geodatabase. There are KMZ in the environment so confused on the error.  TypeError Traceback (most recent call last)<ipython-input-23-ee7602b7dcab> in <module>() 17 18 # Convert all KMZ and KML files found in the current workspace---> 19 for kmz in arcpy.ListFiles('*.KM*'): 20 print("CONVERTING: {0}".format(os.path.join(arcpy.env.workspace, kmz))) 21 arcpy.KMLToLayer_conversion(kmz, out_location)TypeError: 'NoneType' object is not iterable ... View more

I'm running Jupyter and trying to run this script to pull files from arcgis enterprise to a desktop folder and I am getting the following bolded error. What is needed to fix this?  # Version 1.2 import logging, os, re, datetime from IPython.display import display from arcgis.gis import GIS (ModuleNotFoundError: No module named 'arcgis') ''' ********************** SCRIPT CONFIGURATION START ********************** ''' #What is the ID of the Feature Layer you want to download attachments from? FeatureLayerId = 'XXXX' #What are your ArcGIS Enterprise/ArcGIS Online credentials? This is case sensitive. PortalUserName = 'XXXX' PortalPassword = 'XXXX' PortalUrl = 'XXXX' #Where do you want your attachments stored? SaveAttachmentsTo = 'S:\GIS\Pictures' SaveLogsTo = 'Logging' #How do you want your attachments stored? Options are GroupedFolder and IndividualFolder #GroupedFolder - Attachments from every feature in each layer is stored in the same folder - attachments are renamed in the format OBJECTID-ATTACHMENTID-OriginalFileName #IndividualFolder - A new folder is created for each OBJECTID, and associated attachments are stored in that folder - attachments are renamed in the format ATTACHMENTID-OriginalFileName AttachmentStorage = 'GroupedFolder' #Set to False if ArcGIS Enterprise cert is not valid PortalCertVerification = True #Setup logging - levels are DEBUG,INFO,WARNING,ERROR,CRITICAL logging.basicConfig(level=logging.INFO) ''' ********************** SCRIPT CONFIGURATION END ********************** ''' #https://stackoverflow.com/questions/273192/how-can-i-create-a-directory-if-it-does-not-exist def createFolder(folderPath): if not os.path.exists(folderPath): try: os.makedirs(folderPath) except OSError as e: if e.errno != errno.EEXIST: raise def renameFile(currentAttachmentPath, newAttachmentPath): #Rename file - ensure new attachment path does not exist already if not os.path.exists(newAttachmentPath): os.rename(currentAttachmentPath, newAttachmentPath) logger.info('{} being renamed as {}'.format(currentAttachmentPath, newAttachmentPath)) else: logger.warning('Not able to rename {} as {} because file already exists. Removing {}'.format(currentAttachmentPath, newAttachmentPath, currentAttachmentPath)) os.remove(currentAttachmentPath) #Create specified folder if it does not exist already createFolder(SaveAttachmentsTo) createFolder(SaveLogsTo) #Logging level specified in script configuration logger = logging.getLogger(__name__) logFileName = datetime.datetime.now().strftime('%Y-%m-%d %H-%M-%S') fileHandler = logging.handlers.RotatingFileHandler('{}/{}.log'.format(SaveLogsTo, logFileName), maxBytes=100000, backupCount=5) formatter = logging.Formatter('%(asctime)s %(levelname)s %(relativeCreated)d \n%(filename)s %(module)s %(funcName)s %(lineno)d \n%(message)s\n') fileHandler.setFormatter(formatter) logger.addHandler(fileHandler) logger.info('Script Starting at {}'.format(str(datetime.datetime.now()))) #Connect to GIS, and get Feature Layer information if PortalUserName == '' and PortalPassword == '': gis = GIS() else: gis = GIS(PortalUrl, PortalUserName, PortalPassword, verify_cert=PortalCertVerification) downloadCounter = 0 nonDownloadCounter = 0 downloadSizeCounter = 0 itemObject = gis.content.get(FeatureLayerId) logger.info('Iterating through layers in Feature Layer "{}"'.format(itemObject.name)) display(itemObject) #Loop through layers in Feature Layer for i in range(len(itemObject.layers)): featureLayer = itemObject.layers #Skip layer if attachments are not enabled if featureLayer.properties.hasAttachments == True: #Remove any characters from feature layer name that may cause problems and ensure it's unique... featureLayerName = '{}-{}'.format(str(i), re.sub(r'[^A-Za-z0-9]+', '', featureLayer.properties.name)) featureLayerFolder = SaveAttachmentsTo + r'\\' + featureLayerName createFolder(featureLayerFolder) #Query to get list of object ids in layer featureObjectIds = featureLayer.query(where='1=1', return_ids_only=True) #Provide some updates to user... logger.info('Time: {}'.format(str(datetime.datetime.now()))) logger.info('Currently looping through feature attachments in layer {} of {}: storing in folder named "{}"'.format(str(i + 1), str(len(itemObject.layers)), featureLayerName)) logger.info('There are {} features to iterate in this layer'.format(str(len(featureObjectIds['objectIds'])))) #Loop through features in layer emptyAttachments = 0 for j in range(len(featureObjectIds['objectIds'])): currentObjectId = featureObjectIds['objectIds'] currentObjectIdAttachments = featureLayer.attachments.get_list(oid=currentObjectId) if len(currentObjectIdAttachments) > 0: #Loop through feature attachments and download to appropriate folder for k in range(len(currentObjectIdAttachments)): attachmentId = currentObjectIdAttachments ['id'] attachmentName = currentObjectIdAttachments ['name'] attachmentSize = currentObjectIdAttachments ['size'] if AttachmentStorage == 'IndividualFolder': currentFolder = featureLayerFolder + r'\\' + str(currentObjectId) #Create a folder for attachments createFolder(currentFolder) fileName = '{}-{}'.format(attachmentId, attachmentName) newAttachmentPath = '{}\\{}'.format(currentFolder, fileName) if not os.path.isfile(newAttachmentPath): logger.info('The size of the current attachment being downloaded is {}MB'.format((attachmentSize/1000000))) currentAttachmentPath = featureLayer.attachments.download(oid=currentObjectId, attachment_id=attachmentId, save_path=currentFolder) #Rename to ensure file name is unique renameFile(currentAttachmentPath, newAttachmentPath) downloadCounter += 1 downloadSizeCounter += attachmentSize else: logger.info('File {} already exists. Not downloading again!'.format(newAttachmentPath)) nonDownloadCounter += 1 elif AttachmentStorage == 'GroupedFolder': fileName = '{}-{}-{}'.format(currentObjectId, attachmentId, attachmentName) newAttachmentPath = '{}\\{}'.format(featureLayerFolder, fileName) if not os.path.isfile(newAttachmentPath): logger.info('The size of the current attachment being downloaded is {}MB'.format((attachmentSize/1000000))) currentAttachmentPath = featureLayer.attachments.download(oid=currentObjectId, attachment_id=attachmentId, save_path=featureLayerFolder) #Rename to ensure file name is unique renameFile(currentAttachmentPath, newAttachmentPath) downloadCounter += 1 downloadSizeCounter += attachmentSize else: logger.info('File {} already exists. Not downloading again!'.format(newAttachmentPath)) nonDownloadCounter += 1 else: logger.error('AttachmentStorage option not valid: {}. Valid options are IndividualFolder and GroupedFolder'.format(AttachmentStorage)) else: emptyAttachments += 1 logger.info('{} of these features do not contain attachments'.format(str(emptyAttachments))) else: logger.info('Layer {} does not have attachments enabled'.format(featureLayer.properties.name)) logger.info('Summary: {} new files have been downloaded totalling {}MB in size'.format(downloadCounter, (downloadSizeCounter/1000000))) logger.info('Summary: {} attachments already existed so were not downloaded again'.format(nonDownloadCounter)) ... View more