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.
  

  Option 1

  Identifier	Title	Extent Portion	Extent Number	Extent Type	Extent Portion	Extent Number	Extent Type
  MS-122	Nancy Enneking papers	Part	97.98	Linear Feet	Part	55.8	Gigabytes
  MS-123	Nikki Thomas papers	Whole	2	Linear Feet

  Option 2

  Identifier	Title	Extent Portion	Extent Number	Extent Type
  MS-122	Nancy Enneking papers	Part	97.98	Linear Feet
  MS-122	Nancy Enneking papers	Part	55.8	Gigabytes
  MS-123	Nikki Thomas papers	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, 1992

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, 1992	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	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	97.98	Linear Feet
   MS-122	Nancy Enneking papers	Creation, 1998-2002; Bulk, 1992	55.8	Gigabytes