What in the Samhain is going on with the table macro?
| Wiki Markup |
|---|
{table:border=1|cellspacing=0|cellpadding=3}
{th} Table {th}{th} Columns {th}{th} CSpace destination {th}{th} Cleaned? {th}{th} Migrated? {th}{th} Mapping {th}{th} Notes {th}
{tr}{td}MediaFiles{tr}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {tr}{td}FileDate{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: date created{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}Migrate if
not automatically extracted upon import{td}{tr}
{tr}{td} {tr}{td}FileName{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: file name{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}Migrate if
not automatically extracted upon import{td}{tr}
{tr}{td} {tr}{td}FileSize{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: dimension ?{td}{td:align=center}{td}{td:align=center}{td}{td}WHERE FileSize
<> 0{td}{td}{td}{tr}
{tr}{td} {tr}{td}FormatID{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: format{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to
MediaFormats.FormatID to get format info.{td}{td}{td}{tr}
{tr}{td} {tr}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {tr}{td}MemorySize{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: dimension ?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {tr}{td}PathID{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: location{td}{td:align=center}{td}{td:align=center}{td}{td}use as FK to
MediaPaths.PathID to get file location{td}{td}{td}{tr}
{tr}{td} {tr}{td}PixelH{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: dimension ?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {tr}{td}PixelW{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: dimension ?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {tr}{td}RenditionID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Needed? Useful if importing unlinked images{td}{tr}
{tr}{td}MediaMaster{tr}{td}ApprovedForWeb{td}{td}• Schema extension/ custom field needed? Needed for filtering for public web viewing on Delphi.{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {tr}{td}Copyright{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: rights holder{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {tr}{td}Description{td}{td}append to [Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: description{td}{td:align=center}{td}{td:align=center}{td}{td}{td}
{td}{td}{tr}
{tr}{td} {tr}{td}MediaView{td}{td}• Schema extension/ custom field needed? (or append to [Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: description){td}
{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}{td}{tr}
{tr}{td} {tr}{td}PublicCaption{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: description (first part, followed by MediaMaster.MediaView,
MediaMaster.Description, MediaRenditions.Remarks, and MediaXrefs.Remarks{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td} {tr}{td}Restrictions{td}{td}• Schema extension/ custom field needed?{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{tr}{td}MediaRenditions{tr}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {tr}{td}LoginID{td}{td}—?—{td}{td:align=center}no{td}{td:align=center}no{td}{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}
Only if useful for attribution content.{td}{tr}
{tr}{td} {tr}{td}MediaSizeID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Useful? If MediaSizeID=2, original film format was 35mm{td}{tr}
{tr}{td} {tr}{td}MediaTypeID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Needed? Indicates whether file is Image ("1"), Audio ("2"), Video ("3"), Document ("4"), Slide ("10"), or Negative ("9")
{td}{tr}
{tr}{td} {tr}{td}ParentRendID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Useful? (799 are != -1){td}{tr}
{tr}{td} {tr}{td}Quality{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Worth importing? ("great": 209; "Peru": 512; <null>: 521,838){td}{tr}
{tr}{td} {tr}{td}Remarks{td}{td}append to [Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: description{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}
{td}{tr}
{tr}{td} {tr}{td}RenditionNumber{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: identification number{td}{td:align=center}{td}{td:align=center}{td}
{td}{td}{td}{td}{tr}
{tr}{td} {tr}{td}ThumbFileName{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Needed?{td}{tr}
{tr}{td} {tr}{td}ThumbPathID{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}—?—{td}{td}Indicates location of thumbnails for the images (6 different locations){td}{tr}
{tr}{td}MediaXrefs{tr}{td}EnteredDate{td}{td}—?—{td}{td:align=center}————{td}{td:align=center}no{td}{td}—?—{td}{td}Only if useful for versioning context.{td}{tr}
{tr}{td} {tr}{td}ID{td}{td}(person-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information{td}{td}{td}{tr}
{tr}{td} {tr}{td} {td}{td}(exhibition-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=47, use as FK to Exhibitions.ExhibitionID to get exhibition info.{td}{td}{td}{tr}
{tr}{td} {tr}{td} {td}{td}(loan-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=81, use as FK to Loans.LoanID to get loan info.{td}{td}{td}{tr}
{tr}{td} {tr}{td} {td}{td}(conservation- and/or condition-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=97, use as FK to CondLineItems.CondLineItemID to get \[conservation\]
condition line item info.{td}{td}{td}{tr}
{tr}{td} {tr}{td} {td}{td}(object-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=108, use as FK to Objects.ObjectID to get object info.{td}{td}{td}{tr}
{tr}{td} {tr}{td} {td}{td}(historical event-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=187, use as FK to HistEvents.HistEventID to get historical event info.{td}{td}{td}{tr}
{tr}{td} {tr}{td} {td}{td}(place-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=189, use as FK to Sites.SiteID to get place info.{td}{td}{td}{tr}
{tr}{td} {tr}{td} {td}{td}(shipment-related digital media){td}{td:align=center}{td}{td:align=center}{td}{td}WHERE TableID=345, use as FK to Shipments.ShipmentID to get shipment info.{td}{td}{td}{tr}
{tr}{td} {tr}{td}LoginID{td}{td}[Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: contributor? (or publisher?){td}{td:align=center}no{td}{td:align=center}no{td}
{td}use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info{td}{td}Only if useful for attribution content.{td}{tr}
{tr}{td} {tr}{td}PrimaryDisplay{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}The primary image to be displayed is indicated by PrimaryDisplay=1{td}{tr}
{tr}{td} {tr}{td}Rank{td}{td}—?—{td}{td:align=center}{td}{td:align=center}{td}{td}{td}{td}Indicates the relative display order of images (media with lower numbers should be displayed before media with higher numbers).
{td}{tr}
{tr}{td} {tr}{td}Remarks{td}{td}• Schema extension/ custom field needed? (or append to [Media handling information|http://wiki.collectionspace.org/display/collectionspace/Media+Handling+Schema]: description){td}
{td:align=center}{td}{td:align=center}{td}{td}{td}{td}{td}{tr}
{table}| HTML Table |
|---|
| border | 1 |
|---|
| cellpadding | 3 |
|---|
| cellspacing | 0 |
|---|
|
| Table Head (th) |
|---|
| CSpace destination |
| Table Head (th) |
|---|
| Migrated? |
| Table Cell (td) |
|---|
| EnteredDate |
| Table Cell (td) |
|---|
| Only if useful for versioning context. |
FileDateMedia handling information: date created| Table Cell (td) |
|---|
Migrate if
not automatically extracted upon import |
FileNameMedia handling information: file name| Table Cell (td) |
|---|
Migrate if
not automatically extracted upon import |
FileSizeMedia handling information: dimension ?| Table Cell (td) |
|---|
WHERE FileSize
<> 0 |
FormatIDMedia handling information: format| Table Cell (td) |
|---|
use as FK to
MediaFormats.FormatID to get format info. |
LoginID—?—| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
MemorySizeMedia handling information: dimension ?PathIDMedia handling information: location| Table Cell (td) |
|---|
use as FK to
MediaPaths.PathID to get file location |
PixelHMedia handling information: dimension ?PixelWMedia handling information: dimension ?RenditionID—?—| Table Cell (td) |
|---|
| Needed? Useful if importing unlinked images |
| Table Cell (td) |
|---|
| MediaMaster |
ApprovedForWeb• Schema extension/ custom field needed? Needed for filtering for public web viewing on Delphi.CopyrightMedia handling information: rights holderDescriptionappend to Media handling information: description
MediaView• Schema extension/ custom field needed? (or append to Media handling information: description)PublicCaptionMedia handling information: description (first part, followed by MediaMaster.MediaView,
MediaMaster.Description, MediaRenditions.Remarks, and MediaXrefs.RemarksRestrictions• Schema extension/ custom field needed?| Table Cell (td) |
|---|
| MediaRenditions |
EnteredDate—?—| Table Cell (td) |
|---|
| Only if useful for versioning context. |
LoginID—?—| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
Only if useful for attribution content. |
MediaSizeID—?—| Table Cell (td) |
|---|
| Useful? If MediaSizeID=2, original film format was 35mm |
MediaTypeID—?—| Table Cell (td) |
|---|
| Needed? Indicates whether file is Image (”1”), Audio (”2”), Video (”3”), Document (”4”), Slide (”10”), or Negative (”9”) |
ParentRendID—?—| Table Cell (td) |
|---|
| Useful? (799 are != -1) |
Quality—?—| Table Cell (td) |
|---|
| Worth importing? (”great”: 209; “Peru”: 512; <null>: 521,838) |
Remarksappend to Media handling information: descriptionRenditionNumberMedia handling information: identification number
ThumbFileName—?—ThumbPathID—?—| Table Cell (td) |
|---|
| Indicates location of thumbnails for the images (6 different locations) |
| Table Cell (td) |
|---|
| MediaXrefs |
EnteredDate—?—| Table Cell (td) |
|---|
| Only if useful for versioning context. |
ID(person-related digital media)| Table Cell (td) |
|---|
| WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information |
(exhibition-related digital media)| Table Cell (td) |
|---|
| WHERE TableID=47, use as FK to Exhibitions.ExhibitionID to get exhibition info. |
(loan-related digital media)| Table Cell (td) |
|---|
| WHERE TableID=81, use as FK to Loans.LoanID to get loan info. |
(conservation- and/or condition-related digital media)| Table Cell (td) |
|---|
WHERE TableID=97, use as FK to CondLineItems.CondLineItemID to get [conservation]
condition line item info. |
(object-related digital media)| Table Cell (td) |
|---|
| WHERE TableID=108, use as FK to Objects.ObjectID to get object info. |
(historical event-related digital media)| Table Cell (td) |
|---|
| WHERE TableID=187, use as FK to HistEvents.HistEventID to get historical event info. |
(place-related digital media)| Table Cell (td) |
|---|
| WHERE TableID=189, use as FK to Sites.SiteID to get place info. |
(shipment-related digital media)| Table Cell (td) |
|---|
| WHERE TableID=345, use as FK to Shipments.ShipmentID to get shipment info. |
LoginIDMedia handling information: contributor? (or publisher?)
| Table Cell (td) |
|---|
| use as FK to Users.Login, then use Users.MTB_ConstituentID as FK to Constituents.ConstituentID to get person's info |
| Table Cell (td) |
|---|
| Only if useful for attribution content. |
PrimaryDisplay—?—| Table Cell (td) |
|---|
| The primary image to be displayed is indicated by PrimaryDisplay=1 |
Rank—?—| Table Cell (td) |
|---|
| Indicates the relative display order of images (media with lower numbers should be displayed before media with higher numbers). |
Remarks• Schema extension/ custom field needed? (or append to Media handling information: description) |