Page Comparison

What in the Samhain is going on with the table macro?

HTML Table

border	1
cellpadding	3
cellspacing	0

Table Head (th)
Table

Table Head (th)
Columns

Table Head (th)
CSpace destination

Table Head (th)
Cleaned?

Table Head (th)
Migrated?

Table Head (th)
Mapping

Table Head (th)
Notes

Table Row (tr) Table Cell (td)MediaFiles

Table Cell (td)
EnteredDate

Table Cell (td)
—?—

Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td) Table Row (tr)FileDate Table Cell (td)Media handling information: date created Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
Migrate if not automatically extracted upon import

Table Row (tr) Table Cell (td) Table Row (tr)FileName Table Cell (td)Media handling information: file name Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
Migrate if not automatically extracted upon import

Table Row (tr) Table Cell (td) Table Row (tr)FileSize Table Cell (td)Media handling information: dimension ? Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE FileSize <> 0

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)FormatID Table Cell (td)Media handling information: format Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to MediaFormats.FormatID to get format info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)LoginID Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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.

Table Row (tr) Table Cell (td) Table Row (tr)MemorySize Table Cell (td)Media handling information: dimension ? Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)PathID Table Cell (td)Media handling information: location Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
use as FK to MediaPaths.PathID to get file location

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)PixelH Table Cell (td)Media handling information: dimension ? Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)PixelW Table Cell (td)Media handling information: dimension ? Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)RenditionID Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Needed? Useful if importing unlinked images

Table Row (tr) Table Cell (td)MediaMaster Table Row (tr)ApprovedForWeb Table Cell (td)• Schema extension/ custom field needed? Needed for filtering for public web viewing on Delphi. Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)Copyright Table Cell (td)Media handling information: rights holder Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)Description Table Cell (td)append to Media handling information: description Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)MediaView Table Cell (td)• Schema extension/ custom field needed? (or append to Media handling information: description) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)PublicCaption Table Cell (td)Media handling information: description (first part, followed by MediaMaster.MediaView,
MediaMaster.Description, MediaRenditions.Remarks, and MediaXrefs.Remarks Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)Restrictions Table Cell (td)• Schema extension/ custom field needed? Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td)MediaRenditions Table Row (tr)EnteredDate Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td) Table Row (tr)LoginID Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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.

Table Row (tr) Table Cell (td) Table Row (tr)MediaSizeID Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Useful? If MediaSizeID=2, original film format was 35mm

Table Row (tr) Table Cell (td) Table Row (tr)MediaTypeID Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Needed? Indicates whether file is Image ("1"), Audio ("2"), Video ("3"), Document ("4"), Slide ("10"), or Negative ("9")

Table Row (tr) Table Cell (td) Table Row (tr)ParentRendID Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Useful? (799 are != -1)

Table Row (tr) Table Cell (td) Table Row (tr)Quality Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Worth importing? ("great": 209; "Peru": 512; <null>: 521,838)

Table Row (tr) Table Cell (td) Table Row (tr)Remarks Table Cell (td)append to Media handling information: description Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)RenditionNumber Table Cell (td)Media handling information: identification number Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)ThumbFileName Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Needed?

Table Row (tr) Table Cell (td) Table Row (tr)ThumbPathID Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
—?—

Table Cell (td)
Indicates location of thumbnails for the images (6 different locations)

Table Row (tr) Table Cell (td)MediaXrefs Table Row (tr)EnteredDate Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

————

Table Cell (td)

align	center

no

Table Cell (td)
—?—

Table Cell (td)
Only if useful for versioning context.

Table Row (tr) Table Cell (td) Table Row (tr)ID Table Cell (td)(person-related digital media) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=23, use as FK to Constituents.ConstituentID to get person?s information

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr) Table Cell (td)(exhibition-related digital media) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=47, use as FK to Exhibitions.ExhibitionID to get exhibition info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr) Table Cell (td)(loan-related digital media) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=81, use as FK to Loans.LoanID to get loan info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr) Table Cell (td)(conservation- and/or condition-related digital media) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=97, use as FK to CondLineItems.CondLineItemID to get [conservation] condition line item info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr) Table Cell (td)(object-related digital media) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=108, use as FK to Objects.ObjectID to get object info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr) Table Cell (td)(historical event-related digital media) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=187, use as FK to HistEvents.HistEventID to get historical event info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr) Table Cell (td)(place-related digital media) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=189, use as FK to Sites.SiteID to get place info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr) Table Cell (td)(shipment-related digital media) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)
WHERE TableID=345, use as FK to Shipments.ShipmentID to get shipment info.

Table Cell (td) Table Row (tr) Table Cell (td) Table Row (tr)LoginID Table Cell (td)Media handling information: contributor? (or publisher?) Table Cell (td) Table Cell (td)

align	center

no

Table Cell (td)

align	center

no

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.

Table Row (tr) Table Cell (td) Table Row (tr)PrimaryDisplay Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
The primary image to be displayed is indicated by PrimaryDisplay=1

Table Row (tr) Table Cell (td) Table Row (tr)Rank Table Cell (td)—?— Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td)

Table Cell (td)
Indicates the relative display order of images (media with lower numbers should be displayed before media with higher numbers).

Table Row (tr) Table Cell (td) Table Row (tr)Remarks Table Cell (td)• Schema extension/ custom field needed? (or append to Media handling information: description) Table Cell (td) Table Cell (td)

align	center

Table Cell (td)

align	center

Table Cell (td) Table Cell (td)tr 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}

Versions Compared

Old Version 1

New Version 2

Key