Sure - There is more there because it exports and puts away several file geodatabase files with the download that creates folders elsewhere but the general flow for one of them is here.
It was working for over a year and now, fails on one which may be due to a change my customer made in layer assignment still trying to sort that out and the changes I had to make to arcgis.gis for some reason..? ArcPro upgrades not sure.. but it's running on Python 3.6.10 64bit and works for one Hosted Feature... hope this helps with some context.
#import arcgis.gis
from arcgis.gis import GIS as g
# Snipped from calling python file to file doing the detail export work
start = timer()
print ("Export Hosted Feature")
from AGOL_aaaaaaaaa import export_xxxxxxxx_from_agol
export_xxxxxxxx_from_agol()
end = timer()
print ("aaaaaaaaaaaaa export in AGOL Done " + str((end - start)/60) ) # Time in minutes
# ---- python general flow of export on one of the hosted features called by the 'main' python snippet above
import time
import datetime
import os
import zipfile
#import arcgis.gis
from arcgis.gis import GIS as g
from zipfile import ZipFile
from datetime import datetime
import pathlib
from timeit import default_timer as timer
from datetime import datetime, date
from dateutil.relativedelta import relativedelta
import csv, sys
# --------------------------------- vars -----------------------------------------------
# Where the GDB will be extracted to after extraction and then download of that extraction
outputFolder=r"\\xxxxxxxxx\yyyyyyyyyy\zzzzzz"
# Path to credentials file for Prod
credentialsFile=r"C:\\aaa\\bbb\\cccc\\yourcreds.csv"
# Gather site url and login credentials
cred = ''
# log into AGOL object
gis = ''
# name of AGOL temporary GDB saved from Hosted feature class
GDBname = "xxxxxxxxx_fgdb"
# item_id is the service_ID of the hosted Prod CRUB feature layer to download
item_id='aaaaaaaaaaaaaaaaaaaaaaaaaaa'
#Parameters for editor tracking try and preserve
pub_params = {"editorTrackingInfo" : {"enableEditorTracking":True, "preserveEditUsersAndTimestamps":True}}
# --------------------------- called functions ------------------------------
# open(file, mode, buffering, encoding, errors, newline, closefd, opener)
def read_credentials():
with open(credentialsFile, newline='') as f:
reader = csv.reader(f)
for row in reader:
print("row[0] :" + str(row[0]))
return row
def export_xxxxxxxx_from_agol():
print ("AGOL_ADA_Export_CURB_Prod.py mndot.maps.arcgis.com")
# Gather site url and login credentials
cred = read_credentials()
# log into AGOL object
gis = g(cred[0], cred[1], cred[2])
print ("GDBname : " + GDBname )
# search AGOL for the item to export via the item id
AGOLitem = gis.content.get(item_id)
print ("Exporting Hosted ccccccccc Feature Layer to temp AGOL file..." + str(GDBname))
AGOLitem.export(GDBname,'File Geodatabase', parameters=pub_params, wait=True)
#add 20 seconds delay to allow export to complete
time.sleep(60)
print ("Export Hosted xxxxxxxxx Feature Layer to temp AGOL file Done ..." + str(GDBname))
return GDBname
# --------------------------- called functions ------------------------------
def search_for_agol_fgdb(monthFolder):
"""This function searches for the name of the AGOL
file geodatabase exported from the hosted feature class"""
try:
print ("Try targeted search for :" + str(GDBname) + ".zip")
# Gather site url and login credentials
cred = read_credentials()
# log into AGOL object
gis = g(cred[0], cred[1], cred[2])
print ("GDBname : " + GDBname )
search_fgb = gis.content.search(query=(str(GDBname) + ".zip"), item_type = 'File Geodatabase',sort_field="created" ,sort_order="desc")
fgb_item_id = search_fgb[0].id
fgb = gis.content.get(fgb_item_id)
print ("Finished search. Starting download to folder..:" + monthFolder)
fgb.download(save_path=monthFolder) #download file gdb from ArcGIS Online to your computer
return fgb
print ("Finished targeted search")
except Exception as e:
print("type error: " + str(e))
print ("Was not able to find exact match to download :" + (str(GDBname) + ".zip") )
return "Error : " + str(e) + " : No data found"
finally:
print ("Finished search.")
# backup one month and year if needed for folder name to store downloads
def create_month_directory():
mydate = datetime.now()
backdate = mydate - relativedelta(months=1)
# create the output folder
pathlib.Path(outputFolder + '\\' + str(backdate.strftime("%b")) + '_' + str(backdate.strftime("%Y"))).mkdir(exist_ok=True)
monthFolder = (outputFolder + '\\' + str(backdate.strftime("%b")) + '_' + str(backdate.strftime("%Y")))
print("monthFolder : " + str(monthFolder))
return monthFolder
