Issue attaching Attachments via Workbench

[Grant]

Hi @nfshoobs,

If you want to perform a mass import of attachments and have access to the asset server backend, you can:

1. Add the attachments directly to the configured attachments/originals directory for the Asset Server. You can model this off other attachments already present in the directory and on the asset server!

2. Create a corresponding attachment record using SQL for each asset in the database, setting the attachmentLocation field in each record to the file name in the attachments/originals directory.

3. Create a collectionobjectattachment record with the appropriate CollectionMemberID, AttachmentID, and CollectionObjectID, linking the new attachment record to the correct collectionobject. You will likely want to include an identifier to match in step 2, allowing you to easily link the correct records!

This process can be automated using a script, allowing you to complete it entirely outside of the main interface and without the use of the APIs.

For some more information about how Specify talks to the asset server, you can read this doc here:

How does Specify 7 work with the Web Asset Server?

This article describes how attachments in Specify are linked to attachments on the Web Asset Server. Linking an Attachment to the Source When an attachment is uploaded to Specify, it is added to the database as a set of attachment records (in the attachment table and the joining attachment table, in this case collectionobjectattachment). In this example, I uploaded an attachment for a Collection Object with the catalog number 29499: [Puntius sophore (Hamilton, 1822) specimen] Cit…

You don’t need to generate the thumbnails manually as they are created dynamically when viewed in Specify 7!