Batch Edits for Attachments

Get Help
4

Hi @phb,

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)
  • Upload data to the AttachmentMetadata or AttachmentImageAttribute tables directly using the WorkBench, linking the new records to the existing Attachment records (see ‘Dependent Records’).

If you have a specific request or operation you’d like help with, let me know and I can advise!