Date and Time Use Cases

Statens Museum fur Kunst

Error rendering macro 'viewfile' : Failed to find attachment with Name null

Date and Time Requirements

1. Date entry in our current system generates Display strings in a predictable way.

In CollectionSpace, however, everything must be manually entered.

Action: Create a date display entry module to add on to CollectionSpace which can generate display texts.

Update 07 Sept 2010: A prototype has been created for this module, based on the specification included in the slides above.

Update 18 Nov 2010: Sample screen shots will be added to this page to demonstrate how the prototype works.

2. Date text is more detailed than the date ranges.

Typically this seems to be because there was confusion over how to enter a month/year in the current system.

Example : SMKDate id 484685. "From" and "To" dates identify a whole year, but the text identifies a single month. Text is "August 1961". "Date from" is Sunday, 1 January 1961 (22282) ,"Date to" is Sunday, 31 December 1961 (22646).

Action: Try to provide a means for users to enter month (and seasons) in a way which the current system does not.

3. CollectionSpace date format does not have room for some SMK date information.

The datetype and dateextent fields from the current system describe two sets of strings which are used to help the user generate a display text. If we don't save this data, we cannot present the user with the expected user interface when editing data.

Action: We will not store this data. User can create a new date if they want to edit the old one via our interface extension.

4. Representation of dates in the current system.

Dates stored in the current system are represented as integers, in such a way that 0 = 30.12.1899, 1 = 31.12.1899 etc. (This is the same way dates are represented in most spreadsheets such as Open Office Calc and MS Excel so these programs can be used to quickly examine dates exported from the current system).

5. Mapping to CollectionSpace date format.

There is no explicit mapping to the SMK date format described in Kim's mapping spreadsheet. The decision has been taken to use the Date - earliest/single, Date - latest and Date text fields to represent all SMK date information (examples are shown below).

Globus Group	CS Date Information representation	Example data
Day	Date - association
	Date - earliest/single	26.07.1970
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	26.07.1970

Globus Group	CS Date Information representation	Example data
Year	Date - association
	Date - earliest/single	1970
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	1970

Globus Group	CS Date Information representation	Example data
Segment	Date - association
	Date - earliest/single	01-01-1970

	> Date - earliest/single qualifier
	Date - latest	30-06-1970
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	First half 1970
Globus Group	CS Date Information representation	Example data
Before	Date - association
	Date - earliest/single	1870
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest	1970
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	Before 1970
Globus Group	CS Date Information representation	Example data
After	Date - association
	Date - earliest/single	1870
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest	1970
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	After 1870
Globus Group	CS Date Information representation	Example data
Circa	Date - association
	Date - earliest/single	1950
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest	1954
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	Circa 1970
Globus Group	CS Date Information representation	Example data
Period	Date - association
	Date - earliest/single	1970
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest	1984
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	1970 - 1984
Globus Group	CS Date Information representation	Example data
Decade	Date - association
	Date - earliest/single	1970
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest	1980
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	1970s
Globus Group	CS Date Information representation	Example data
Decade segment	Date - association
	Date - earliest/single	1970
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest	1975
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	First half 1970's
Globus Group	CS Date Information representation	Example data
Century segment	Date - association
	Date - earliest/single	1900
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest	1950
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	Beginning 20th century
Globus Group	CS Date Information representation	Example data
Millenium	Date - association
	Date - earliest/single	500
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest	1000
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	Second half of first Millennium AD
Globus Group	CS Date Information representation	Example data
Century by first year	Date - association
	Date - earliest/single	1900
	> Date - earliest/single certainty
	> Date - earliest/single qualifier
	Date - latest	2000
	> Date - latest certainty
	> Date - latest qualifier
	Date - period
	Date text	1900's

Date and Time Use Cases

Statens Museum fur Kunst

Date and Time Requirements

0 Comments