Preparing Image Data In A Spreadsheet
<h3 class="heading-h6"><a name="THLToolboxhomegtImagesampImmersiveTechnologiesgtMMSImageManagementManualMMSImagesManualgtPreparingImageDatainaSpreadsheet" class="anchorpoint"></a><a href="/tools/wiki/home.html">THL Toolbox</a> > <a href="/tools/wiki/Images%20%26%20Immersive%20Technologies.html">Images & Immersive Technologies</a> > <a href="/tools/wiki/MMS%20Images%20Manual.html">MMS Image Management Manual</a> > Preparing Image Data in a Spreadsheet</h3><p class="paragraph">
</p><h3 class="heading-h1"><a name="PreparingImageDatainaSpreadsheet" class="anchorpoint"></a>Preparing Image Data in a Spreadsheet</h3><p class="paragraph"><strong class="bold">Contributor(s):</strong> Andres Montano, Steven Weinberger</p><p class="paragraph">There is set of standard column headers (similar to places dict) for spreadsheet to import captions and other metadata.
</p><ol><li>workflows.original_filename: for associating captions to an image so you can work on captions before the images have been imported into MMS</li>
<li>media.id: this is the MMS id that is generated when the images are imported into the MMS</li>
<li>workflows.original_medium_id, workflows.other_id, workflows.sequence_order, workflows.notes</li>
<li>media.recording_note, media.private_note, media.taken_on, media.photographer, recording_orientations.title</li>
<li>locations.feature_id, geo_code_types.code, features.geo_code, locations.notes, locations.spot_feature</li>
<li>captions.title</li>
<li>collections.title</li>
<li>descriptions.title, descriptions.creator</li>
<li>keywords.title</li>
<li>sources.title, media_source_associations.shot_number</li>
<li>fields for the creation of the content that the photograph is of (for example, a photo of a painting or of a statue, etc): name of the creator of the content (for example, the name of the artist who painted the painting that the photo is of): contents.creator.fullname; the date the person created the content (for example the date the artist painted the painting, or the year an architect constructed a building, etc): contents.created_on; and the place of creation: contents.location.feature_id</li></ol><p class="paragraph">original_medium_id is the id used in previous image cataloging system; other_id is like the bellezza image id
</p><h3 class="heading-h6"><a name="ProvidedforunrestrictedusebythespanclassnobrimgsrcsakairwikitoolimagesicklearrowgifaltexternallinktitleexternallinkahrefhttpwwwthliborgtargetrwikiexternalTibetanandHimalayanLibraryaspan" class="anchorpoint"></a><em class="italic">Provided for unrestricted use by the <span class="nobr"><img src="/" alt="external link: " title="external link"/><a href="http://www.thlib.org" target="rwikiexternal">Tibetan and Himalayan Library</a></span></em></h3>