Support attachments in the workbench

[benanhalt]

edit by @grantfitzsimmons:

This feature goes beyond simply attaching files to WorkBench items. It also includes an image window that allows users to transcribe data from a herbarium sheet. Users should be able to navigate between lines, ensuring the image updates accordingly.

Documentation for Image Window in Specify 6

The Image Window in Specify 6 is an important feature that has not yet been made available in Specify 7. Having specimen and label images linked in Workbench enables transcription from the images.

We have tried using shared folders in file sharing utilities like Google Drive and Dropbox for hosting images for transcription. This works, but lacks many of the features that are supported in the Specify 6 Workbench. Record transcription into a spreadsheet lacks the data validation tools available in Workbench, increasing the probability of errors and the need for data quality control before uploading. The Image Window in Specify 6 conveniently and automatically moves between linked images when the user changes rows in the Workbench dataset. This is a really useful feature for label transcription, decreasing the probability of errors where users inadvertently enter data into an incorrect row. Transcription in temporary spreadsheets and shared folders outside of Specify requires also more coordination by transcriptionists and collection managers.

Requested By: @gholman on the Specify Community Forum

on behalf of the University of Michigan

[maxpatiiuk]

From @grantfitzsimmons:

Is your feature request related to a problem? Please describe.
UMich uses Specify 6 to enter its main herbarium specimen data into the workbench directly from specimen images linked to the workbench.

Describe the solution you'd like
Specify 7 should replicate this capability that 6 currently offers.

Reported By
UMich

[maxpatiiuk]

From @tlammer:

Users have reported needing to bulk upload attachments to existing records due to digitation efforts.
PRI Paleo mentioned having around 1700 images to upload to existing records and North Carolina mentioned not having the ability as a reason they are not going to go into Specify 7 yet.

Specify 6 has a tool that allows users to bulk upload attachments either based on the name of the file, if the name matches a value in a record such as catalog number, field number, or a few other fields. Or, it can use a mapping file which contains an identifying value for a record (such as catalog number) and the file name, to upload the records to the appropriate records.
Users can also upload multiple images to the same record in this tool by adding a suffix to the name such as a, b, c, or 1, 2, 3.

[maxpatiiuk]

Related to #2390