Add "caption" field to Asset

[eddierubeiz]

Creating for Oral Histories migration, although it will be metadata on any Asset.

Stakeholders decided we will just go ahead and add a "Caption" field.

---

caption field exists for portraits field in microsite, how to handle it in Digital Collections data migration

Visit the Roald Hoffman OH metadata form at https://oh.sciencehistory.org/node/7682/edit, and note a small piece of metadata entitled Image Caption whose contents read credit: Michael Grace-Martin. Presumably this is a photographer credit for Hoffman's headshot.

I'd feel bad about not importing image caption, but if we do, we should make a decision about where it would go.

Just making a note of this so we can come back to it later.

[jrochkind]

If we were sure this were always used for "photographer credit", we might want a "credit" field instead of a "caption" field, and just put eg Michael Grace-Martin in it instead of credit: Michael Grace-Martin..

But figuring out what the data looks like and then possibly transforming it is another step.

@eddierubeiz Can you easily make a list of all non-blank "Image Caption" field values, so we can see what's in there?

[jrochkind]

Related to, really a sub-part of, #990

[eddierubeiz]

<p>Detail of Image, CHF Collections</p>
<p>Photograph of Michael Szwarc, Science History Institute Collections, Photograph by Jim Bohning.</p>
<p>Science History Institute Collections</p>
<p>Gift of Herman Skolnik, CHF Collections</p>
<p>CHF Collections, Photograph by Douglas Lockard</p>
<p>Herman Francis Mark in 1986 displaying Hermann Staudinger's rigid-rod model of macromolecules, CHF Collections. Photograph by Jim Bohning</p> |
<p>CHF Collections, Photograph by Douglas A. Lockard</p>
<p>CHF Collections, Photograph by Jim Bohning</p>
<p>Science History Institute Collections, Photograph by Ray Ferguson</p>
<p>Gift of Oliver M. Hayden, CHF Collections</p>
<p>Dow Historical Collection, CHF Collections</p>
<p>Daniel Fox holding a sample of Lexan polycarbonate resin, CHF Collections.</p>
<p>CHF Collections</p>
<p>Dow Historical Collection, Science History Institute Collections</p>
<p>CHF Collections, Photograph by Harry Kalish</p>
<p>Charles P. Smyth. Science History Institute Collections.</p>
<p>Gift of Dr. Cheves Walling, Science History Institute Collections</p>
<p>Science History Institute Collections, Photograph by Douglas Lockard</p>
<p>Robert W. Allington</p>
<p>Detail of Image, CHF Collections, Photograph by Douglas Lockard</p>
<p>John H. Sinfelt in his laboratory. Courtesy ExxonMobil Research and Engineering Company.</p>
<p>Dr. Leo Sternbach, Science History Institute Collections, gift of Dr. Sternbach</p>
<p>Alison E. M. Adams</p>
<p>&nbsp;Courtesy of Douglas Lockard, CHF Collections</p>
<p>Detail of Image, CHF Collections, Photograph by Carol Sonstein, San Diego Business Journal</p>
<p>Courtesy of Mary L. Good</p>
<p>Detail of Image, Science History Institute Collections</p>
<p>Courtesy of John D. Roberts, CHF Collections</p>
<p>||</p>
<p>Image of Christopher Rongo</p>
<p>Detail of Image, Gift of Claire Schultz, Science History Institute Collections</p>
<p>Phillip A. Sharp</p>
<p>Harold A. Sorgenti. Science History Institute Collections, Photograph by Douglas Lockard</p>
<p>Jonathan S. Stamler</p>
<p>William S. Stavropoulos. Dow Historical Collection, Science History Institute Collections</p>
<p>Markus Stoffel</p>
<p>Gilbert Stork, Courtesy of John D. Roberts, Science History Institute Collections</p>
<p>Lubert Stryer</p>
<p>Hong Sun</p>
<p>Karel Svoboda</p>
<p>Henrique P. von Gersdorff</p>
<p>John L. Holmes</p>
<p>Photograph provided by Dr. March.</p>
<p>photo provided by David Pyott</p>
<p>credit: Michael Grace-Martin</p>

[eddierubeiz]

select distinct field_image_caption_value from field_data_field_image_caption;