Page Comparison

...

• The subteam discussed the results of the ArchivesSpace v1.5.2 Reports Review and determined a prioritized list of reports to keep and remove, in addition to 5 new reports to develop for the March 2017 release. The results of this discussion are included in the Addenda below.
• The subteam discussed the challenge of repeatable fields, like extents and dates, for CSV exports. A full description of the issues is included the Addenda below. The group agreed that all CSV exports should feature separate columns for each discrete value, but failed to come to a consensus about whether (1) repeatable fields should be entered in separate columns or , (2) the entire record should be repeats to accommodate repeatable fields, or (3) we should adopt a hybrid approach depending on the need to statistically analyze data in a give field.
  

  Option 1

  Identifier	Title	Date Label	Date Expression	Date Begin	Date End	Date Label	Date Expression	Date Begin	Date End	Extent Portion	Extent Number	Extent Type	Extent Portion	Extent Number	Extent Type
  MS-122	Nancy Enneking papers	Creation	1998-2002	1998	2002	Bulk	2001	2001		Part	97.98	Linear Feet	Part	55.8	Gigabytes
  MS-123	Nikki Thomas papers	Creation	2012-2016	2012	2016					Whole	2	Linear Feet

  Option 2

  Identifier	Title	Date Label	Date Expression	Date Begin	Date End	Extent Portion	Extent Number	Extent Type
  MS-122	Nancy Enneking papers	Creation	1998-2002	1998	2002	Part	97.98	Linear Feet
  MS-122	Nancy Enneking papers	Bulk	2001	2001		Part	55.8	Gigabytes
  MS-123	Nikki Thomas papers	Creation	2012-2016	2012	2016	Whole	2	Linear Feet

  Option 3

  Identifier	Title	Date Label	Date Expression	Date Begin	Date End	Date Label	Date Expression	Date Begin	Date End	Extent Portion	Extent Number	Extent Type
  MS-122	Nancy Enneking papers	Creation	1998-2002	1998	2002	Bulk	2001	2001		Part	97.98	Linear Feet
  MS-122	Nancy Enneking papers	Creation	1998-2002	1998	2002	Bulk	2001	2001		Part	55.8	Gigabytes
  MS-123	Nikki Thomas papers	Creation	2012-2016	2012	2016					Whole	2	Linear Feet

• The group decided that list reports (reports with basic information, extents, and dates) should include a CSV export, however, record reports (fuller reports with basic information, extents, dates, notes, instances, subjects, agents, etc.) should not include a CSV export as the CSV for such a detailed report is not ideal for statistical analysis purposes.

...

1. Add repeatable fields in separate, repeated columns.

   Identifier	Title	Date	Date
   MS-122	Nancy Enneking papers	Creation, 1998-2002	Bulk, 19922001

2. Repeat the entire record to accommodate repeatable fields.

   Identifier	Title	Date	Extent
   MS-122	Nancy Enneking papers	Creation, 1998-2002	Part, 97.98 Linear Feet (212 Boxes)
   MS-122	Nancy Enneking papers	Bulk, 19922001	Part, 55.8 Gigabytes (219 Files)

3. Separate multiple entires in a repeatable field with a semicolon in a single CSV field.

   Identifier	Title	Date	Extent
   MS-122	Nancy Enneking papers	Creation, 1998-2002; Bulk, 1992 2001	Part, 97.98 Linear Feet (212 Boxes); Part, 55.8 Gigabytes (219 Files)

4. Take a hybrid approach.

   Identifier	Title	Date	Extent Number	Extent Type
   MS-122	Nancy Enneking papers	Creation, 1998-2002; Bulk, 1992 2001	97.98	Linear Feet
   MS-122	Nancy Enneking papers	Creation, 1998-2002; Bulk, 1992 2001	55.8	Gigabytes