TMS to CSpace Media crosswalk
What in the Samhain is going on with the table macro?
MediaFiles | |||||
EnteredDate | β?β | ββββ | no | β?β | Only if useful for versioning context. |
Media handling information: date created | Migrate if not automatically extracted upon import | ||||
Media handling information: file name | Migrate if not automatically extracted upon import | ||||
Media handling information: dimension ? | WHERE FileSize <> 0 | ||||
Media handling information: format | use as FK to MediaFormats.FormatID to get format info. | ||||
β?β | no | no | use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
Only if useful for attribution content. | |
Media handling information: dimension ? | |||||
Media handling information: location | use as FK to MediaPaths.PathID to get file location | ||||
Media handling information: dimension ? | |||||
Media handling information: dimension ? | |||||
β?β | β?β | Needed? Useful if importing unlinked images | |||
MediaMaster | |||||
β’ Schema extension/ custom field needed? Needed for filtering for public web viewing on Delphi. | |||||
Media handling information: rights holder | |||||
append to Media handling information: description | |||||
β’ Schema extension/ custom field needed? (or append to Media handling information: description) | β?β | ||||
Media handling information: description (first part, followed by MediaMaster.MediaView, | |||||
β’ Schema extension/ custom field needed? | |||||
MediaRenditions | |||||
β?β | ββββ | no | β?β | Only if useful for versioning context. | |
β?β | no | no | use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
Only if useful for attribution content. | |
β?β | β?β | Useful? If MediaSizeID=2, original film format was 35mm | |||
β?β | β?β | Needed? Indicates whether file is Image (β1β), Audio (β2β), Video (β3β), Document (β4β), Slide (β10β), or Negative (β9β) | |||
β?β | β?β | Useful? (799 are != -1) | |||
β?β | β?β | Worth importing? (βgreatβ: 209; βPeruβ: 512; <null>: 521,838) | |||
append to Media handling information: description | |||||
Media handling information: identification number | |||||
β?β | β?β | Needed? | |||
β?β | β?β | Indicates location of thumbnails for the images (6 different locations) | |||
MediaXrefs | |||||
β?β | ββββ | no | β?β | Only if useful for versioning context. | |
(person-related digital media) | WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information | ||||
(exhibition-related digital media) | WHERE TableID=47, use as FK to Exhibitions.ExhibitionID to get exhibition info. | ||||
(loan-related digital media) | WHERE TableID=81, use as FK to Loans.LoanID to get loan info. | ||||
(conservation- and/or condition-related digital media) | WHERE TableID=97, use as FK to CondLineItems.CondLineItemID to get [conservation] condition line item info. | ||||
(object-related digital media) | WHERE TableID=108, use as FK to Objects.ObjectID to get object info. | ||||
(historical event-related digital media) | WHERE TableID=187, use as FK to HistEvents.HistEventID to get historical event info. | ||||
(place-related digital media) | WHERE TableID=189, use as FK to Sites.SiteID to get place info. | ||||
(shipment-related digital media) | WHERE TableID=345, use as FK to Shipments.ShipmentID to get shipment info. | ||||
Media handling information: contributor? (or publisher?) | no | no | use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info | Only if useful for attribution content. | |
β?β | The primary image to be displayed is indicated by PrimaryDisplay=1 | ||||
β?β | Indicates the relative display order of images (media with lower numbers should be displayed before media with higher numbers). | ||||
β’ Schema extension/ custom field needed? (or append to Media handling information: description) | |||||