*Title*
_How to maintain a list of metadata mappings outside of the script_
*Detailed description*
_The embedded metadata contains keywords that need to be mapped to specific Dublin Core fields. In the process the keyword may need to be transformed into another value. The list of these mappings and transformations needs to be kept in a file outside of the script that a non-technical person can maintain._
*Issue champion*
[~ecorrado]
*Other interested parties*
_I hope so\!_
*Possible Solution approaches*
_I think a csv (or tab deliminated) file might b the way to go. It should have 3 columns: 1) keyword from embedded metadata, 2) what the keyword should be transformed to, 3) what Dublin Core field should be used. Bash, python, and php approaches were considered with php winning because of the way exiftool can output data in a php-friendly manner. Example of a configuration file might be:_
ec, Binghamton University Events Center, dc:subject
bl, Glen G. Bartle Library, dc:subject
"defleur", "DeFleur, Lous B., 1936-", "dc:contributor"
administration, Binghamton University Administrators Photographs, {color:black}dcterms:isPartOf{color}
*Context*
_There are over 45,000 photos with this embedded metadata. This can not be done by hand but we want the best descriptive metadata as possible and want to take advantage of the work the photographers put into embedding descriptive metadata,_
*Lessons Learned*
_Having the metadata in the photos from the photographer is a huge benefit, but we need to extract it and remap it. Some code that looks for all keywords in the corpus of photo metadata would be of great help for te people who create the mappings, in our case a metadata librarian. An easy way to extract these from our photos is the following GNU/Linux command:_
{code}
find . -type f -name '*.tif' -exec exiftool -S -q -m -sep "__" -xmp:Subject {} \; 2> error.txt | sed s/Subject:\ //g | sed 's|__|\n|g' | sort | uniq -c | sort -r -n
{code}
*Datasets*
[University Photographs with embedded metadata|SPR:University Photographs with embeded metadata]
...