Tibetan and Himalayan Library - THL

THL Toolbox > Images & Immersive Technologies > MMS Image Management Manual > Preparing Image Data in a Spreadsheet

Preparing Image Data in a Spreadsheet

Contributor(s): Andres Montano, Steven Weinberger

There is set of standard column headers (similar to places dict) for spreadsheet to import captions and other metadata.

1. workflows.original_filename: for associating captions to an image so you can work on captions before the images have been imported into MMS
2. media.id: this is the MMS id that is generated when the images are imported into the MMS
3. workflows.original_medium_id, workflows.other_id, workflows.sequence_order, workflows.notes
4. media.recording_note, media.private_note, media.taken_on, media.photographer, recording_orientations.title
5. locations.feature_id, geo_code_types.code, features.geo_code, locations.notes, locations.spot_feature
6. captions.title
7. collections.title
8. descriptions.title, descriptions.creator
9. keywords.title
10. sources.title, media_source_associations.shot_number
11. 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

original_medium_id is the id used in previous image cataloging system; other_id is like the bellezza image id

Provided for unrestricted use by the Tibetan and Himalayan Library