nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error trying to overwrite CSV file in add item properties

ZacharyStanley

I'm trying to overwrite an existing CSV at 15 minute intervals w/ a notebook in AGOL. In the add() method I have the key:value Argument item_properties option set to True for overwrite.

I, however continuously get an error telling me the file already exists:

# add the item to AGOL as csv
projectIdeasTable = gis.content.add(item_properties = {"type": "CSV",
                                   "title": "Project Ideas Table",
                                   "summary": "Table of public project ideas for download as part of particpatory budgeting process",
                                   "snippet": "Intended use for users who have trouble reading content in maps or other forms",
                                   "tags": "participatory budgeting",
                                   "access": "public",
                                   "overwrite": True,          
                                    }, data = 'ProjectIdeas.csv')

Exception: Item 'ProjectIdeas.csv' already exists.
(Error Code: 409)

This seems like a simple issues that shouldn't throw this error. Thoughts?

Trouver plus de publications taguées avec

Accepted answers

ZacharyStanley

The problem is I have to collect data from a feature layer that is turned on for public data collection. The CSV needs to be overwritten with data from the updated feature layer. The CSV will ultimately be shared publicly for downloaded for people with disabilities.

jcarlson

Would it be better to use the arcgis.gis.Item.update() instead? That should specifically allow you to update the content of the given item in-place, rather than attempt to add a "new" item.

All comments

ZacharyStanley

I will explore this solution - thanks!

John_Spence

Oh!!!! Don't do it this way. Go through Hub. If you share the feature layer as a view w/ hub and turn on the export options, the CSV is automatically handled.

https://data.bellevuewa.gov as an example only has services published daily and the CSV, Shapefiles, etc are all auto generated on demand.

ZacharyStanley

John_Spence

        # Find Item
        search_result= connectedP.content.search(serviceID, 'Feature Layer')
        FS_item = search_result[0]

        targetedOverwrite = FeatureLayerCollection.fromitem(FS_item)

        time.sleep(90)

        fileTransfer = r'{}\{}'.format(path_Proj, fileName)
        print ('Updating {} using {}'.format(FS_item.title, fileName))

        # Send for update
        try:
            targetedOverwrite.manager.overwrite(fileTransfer)
            print ('\tSuccessful update of {} \r\r'.format(FS_item.title))

Frankly though, I would not do it this way (recommend) and would likely look at directly accessing the data source or scraping the CSV to a database where you add/remove/update records and then publish/update the service either via writing to the service (depending on record account that might be the most efficient way) or by overwriting the service.

        # Share to portal
        print('     ...Uploading Service Definition')
        arcpy.UploadServiceDefinition_server(inSdFile, inServer, inServiceName, inCluster, inFolderType, inFolder,
                                             inStartup, inOverride, inMyContents, inPublic, inOrganization, inGroups)

jcarlson

Would it be better to use the arcgis.gis.Item.update() instead? That should specifically allow you to update the content of the given item in-place, rather than attempt to add a "new" item.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.