Add Attachment Mapping File support #4766
Description
Is your feature request related to a problem? Please describe.
Yes, the catalog number field is a text field in several of the UMich databases. This enables support for the non-number characters they store in the field, like the UMMZI- suffix in this case.
In S6, we have been using an attachment mapping file which describes the catalog numbers and attachment filenames explicitly. I'm attaching an example here for reference. If a similar system could be added to S7, that would be great.
In this example, this mapping file is necessary to work around an issue with the catalog number field being formatted.
From @realVinayak:
Yes, unless the catalog number field itself is formatted (has a formatter other than text), then multiple records would not be matched. Specify 6 "got around" the issue via the mapping file
Here's an example file sent to us by Garth at UMich:
Example mapping file:
Catalog Number Attachment Name UMMZI-90126 UMMZI-90126.jpg UMMZI-90159 UMMZI-90159.jpg UMMZI-90171 UMMZI-90171.jpg UMMZI-90175 UMMZI-90175_1.jpg UMMZI-90175 UMMZI-90175.jpg UMMZI-90176 UMMZI-90176_1.jpg UMMZI-90176 UMMZI-90176.jpg UMMZI-90179 UMMZI-90179_1.jpg UMMZI-90179 UMMZI-90179.jpg UMMZI-90209 UMMZI-90209_1.jpg UMMZI-90209 UMMZI-90209.jpg UMMZI-90231 UMMZI-90231_1.jpg UMMZI-90231 UMMZI-90231.jpg UMMZI-90234 UMMZI-90234_1.jpg UMMZI-90234 UMMZI-90234.jpg UMMZI-90237 UMMZI-90237.jpg UMMZI-119907 UMMZI-119907_1.jpg UMMZI-119907 UMMZI-119907.jpg UMMZI-119908 UMMZI-119908_1.jpg UMMZI-119908 UMMZI-119908.jpg
Describe the solution you'd like
It should be implemented as it was in Specify 6.
Describe alternatives you've considered
They tried to import using the batch attachment uploader but could not indicate multiple images associated with a single specimen due to the formatting for that field.
Reported By
Garth at University of Michigan