I’m trying to upload image attachments to current records, however, I can’t seem to include important metadata. Curiously, if I try to Batch Edit attachments later, they system indicates that I’m not allowed to Batch Edit attachments, specifically saying:
“Batch edit is disabled for system tables and scoping hierarchy tables”
I need to edit the metadata since there is no batch upload option that allows me to provide metadata. Any help would be appreciated!
At this time, this behavior is not configurable as Batch Edit specifically excludes any tables considered to be system-level. This definition currently includes all Attachment tables, but I agree that editing attachment metadata is needed as the current bulk attachment uploader does not enable the attachment of metadata.
I’ve added this to our GitHub repository for our developers to review:
Thank you so much for your question and for reaching out!
Hi Grant, thanks for the reply. So what is the solution then to editing attachments en masse? It still needs to be something that happens since we have images that have been uploaded but don’t have the correct metadata.
At present, there is no tool to batch update attachment metadata. This is something we plan to address in the coming months by enabling Batch Edit for those tables!
For now, you may want to consider the following:
Use the Query Builder to edit all relevant results in a series individually, using the ‘Browse In Forms’ function
Use the APIs to update attachment metadata in batches (possibly using the ‘Specify Edit Bot’ under the beatybiodiversitymuseum GitHub)
Use direct SQL queries to update the relevant attachment records (discouraged if the API can be used as this comes with additional risks)