...
- 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.
...
Add repeatable fields in separate, repeated columns.
Identifier
Title
Date
Date
MS-122
Nancy Enneking papers
Creation, 1998-2002
Bulk, 1992
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)
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)
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