Providing data for the Drupal web site

DRAFT

This document is obsolete and should not be used except as an artifact. Refer to the appropriate JIRA for details of the current BAMPFA public site.

This documents the mapping of BAM/PFA Art Collection metadata from CollectionSpace to the Drupal web site framework for the main BAM/PFA web site.

Collection Items

FM Pro Field Name	Description	Example	CSpace mapping and questions
__kp_CollectionItem_ID	Unique key field	COL012345	We imported the FM Pro "COL" numbers into the hidden CSpace field copyNumber but it won't be maintained for new items. Mediatrope: Should we a) give you only are internal unique identifiers (CSID which is a UUID), b) give you copyNumber where we have it and CSIDs for new objects? Note we found that the COL numbers were not to be trusted!
A.D.B.C.		A.D.
Circa	boolean	yes/no/blank	We were told that this field was no longer useful because it was assumed everyone was now entering "circa" or "c." in the Early Date or Late Date fields. We can provide the yes/no circa data that we imported but it will be blank in new records.
CreditLine	text
EarliestDate	text, not date format	"n.d., 16th c.", "1902"	When we imported Earliest Date and Latest Date into the Production Date field in CollectionSpace, we populated a single CollectionSpace structured date schema that comprises a display date (calculated by concatenating to create "Earliest Date - Latest Date"), and earliest dates and latest date parts. This allows us to have a nice display date but to also have date-based boundaries. Mediatrope: Do you want to add a display date? What are you doing with the FM Pro Earliest Date and Latest Date fields? Let's talk!
exp_ArtistsAttributeQualifiers	FM Pro calculation: Substitute ( List ( Artist LineItems::AttributionQualifier_exp ) ; "¶" ; "\|" ). A concatenated list pipe-separated.	"NONE", blank, "Attributed to"	It seems strange but we can give this to you unless there is something else you would like.
exp_ArtistsIDs	FM Pro calculation: Substitute ( List ( Artist LineItems::_kf_Artist_ID ) ; "¶" ; "\|" )	ART1317\|ART1133	The existing artist records will have these same identifiers, but new artists will have a CSpace "short identifier" that looks more like "ChrisHoffman109870124309870".
exp_ArtistsNames	concatenated pipe-delimited list of FML name forms. FM Pro calculation: If ( not IsEmpty ( Artist LineItems::_kf_Artist_ID ) ; Substitute ( List ( Artist LineItems::ArtistName_fml ) ; "¶" ; "\|" ) ; Artist )	Jacques Villon\|Henri Matisse	This does get the Artist Display Override.
exp_PeriodOrStyle	concatenated pipe-delimited list of PeriodStyle values. FM Pro calculation not in files we have but it looks straightforward.	Abstract Expressionism\|Abstraction\|Modernism (for 1966.62)
exp_Subdescription	concatenated pipe-delimited list of ThemeSubject values. FM Pro calculation not in files we have but it looks straightforward.	History\|-Place (named)\|Landscape\|-Urban (for 1978.24.8)	Note that in CSpace, these became "History-Place (named)" and "Landscape-Urban" so the list of accepted values will be different.
ID Number
ItemClass			On import we standardized the upper-case/lower-case handling of these data.
LatestDate	Text	"late 18th century", "1902"	See Earliest Date for discussion. Mediatrope: We could give you pretty much what you have or something slightly different and perhaps better.
Materials	Text
Measurement	Text
Title	Text
zz_ModificationTimestamp	FM Pro timestamp	4/1/2014 7:28:23 PM	CSpace timestamps are different (Postgres UTC "Zulu" time) but I can try to convert to this format.

Artists

FM Pro Field Name	Description	Example	CSpace mapping and questions
__kp_Artist_ID	Unique artist identifier	ART012345	The existing artist records will have these same identifiers, but new artists will have a CSpace "short identifier" that looks more like "ChrisHoffman109870124309870".
BirthCountry
c_FullName_fml	FM Pro calculation: Case ( NameLast = "Unknown" ; NameLast & " (" & Nationality & ")" ; Substitute ( List ( NamePrefix ; NameFirst ; NameMiddle ; NameLast ; NameSufix ; ) ; "¶" ; " " ) ) // end case
ct_ArtistDates	FM Pro calculation: ct_ArtistDates Case ( IsEmpty ( Artist::DOB_Year & Artist::DOD_Year ) ; "" ; IsEmpty ( Artist::DOD_Year ) and not IsEmpty ( Artist::DOB_Year ) ; "born " & Artist::DOB_Year ; IsEmpty ( Artist::DOB_Year ) and not IsEmpty ( Artist::DOD_Year ) ; "dead " & Artist::DOD_Year ; Artist::DOB_Year & "—" & Artist::DOD_Year )	"c. 1730—c. 1776", "born 1941", "dead 1884", "1898—1976"	I will have to study how we imported these data into CollectionSpace, but we can probably do something just like this.
ct_NationalityDisplay	FM Pro calculation: Artist::Nationality & If ( not IsEmpty ( Artist::BirthCountry ) ; ", born " & Artist::BirthCountry ; "" )	"Flanders, born Netherlands"
Dates Active
DOB_Year		"c. 1863"
DOD_Year		"after 1787"
Dynasty_Period
NameFirst
NameLast
NameMiddle
NamePrefix
NameSufix
Nationality
Other Regional Info
zz_ModificationTimestamp		9/10/2014 9:35:49 PM	CSpace timestamps are different (Postgres UTC "Zulu" time) but I can try to convert to this format.