What in the Samhain is going on with the table macro?
Table | Columns | CSpace destination | Cleaned? | Migrated? | Mapping | Notes |
---|---|---|---|---|---|---|
MediaFiles | ||||||
EnteredDate | —?— | ———— | no | —?— | Only if useful for versioning context. | |
Media handling information: date created | Migrate if | |||||
Media handling information: file name | Migrate if | |||||
Media handling information: dimension ? | WHERE FileSize | |||||
Media handling information: format | use as FK to | |||||
—?— |
| 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 | |||||
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] | |||||
(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) | ||||||