A concise summary of thoughts about the CSV export functionality is that this is definitely a step in the right direction, but the data pulled for export could benefit from some curation. Further, field labels may be more useful if they match the field labels employed on the staff interface of the application. The order of the display of the fields in the CSV export of data may also benefit from a re-ordering to better match the display order of fields on the staff interface.
Accessions
The Download CSV functionality for ArchivesSpace v.1.5.0 RC1 exports 414 fields of accession data. The Reports Sub-team recommends culling the full list of fields to the following:
| Download CSV Label | Staff Interface Label | Sample Data |
|---|---|---|
| primary_type | Primary Type | accession |
| id | /repositories/2/accessions/30 | |
| title | Title | Concha Espina correspondence |
| identifier | Identifier | 1999-01 |
| accession_date | Accession Date | 5/1/99 |
| accession_date_year | Accession Date Year | 1999 |
| acquisition_type_enum_s | Acquisition Type | gift |
| resource_type | Resource Type | papers |
| restrictions_apply | Restrictions Apply? | FALSE |
| publish | Publish? | FALSE |
| access_restrictions | Access Restrictions? | FALSE |
| use_restrictions | Use Restrictions? | FALSE |
| portion_enum_s | Extent Portion | whole |
| extent_type_enum_s | Extent Type | linear_feet |
| created_by | Created by | csg376 |
| create_time | Date Created | 2014-08-21T18:40:48Z |
The following useful data points do not display in individual fields in the CSV export, however this data may be found in json field.
- Content Description
- Provenance
- Container Summary
- Extent Number
Resources
The Download CSV functionality for ArchivesSpace v.1.5.0 RC1 exports over 13,000 fields of resource data. The Reports Sub-team recommends culling the full list of fields to the following:
| Download CSV Label | Staff Interface Label | Sample Data |
|---|---|---|
primary_type | Resource | |
| resource_type | Resource Type | Papers |
| title | Title | Emily Morrison Bondurant Papers |
| identifier | Indentifier | WLU Coll 0267 |
| level | Level of Description | Collection |
| publish | Publish | TRUE |
| restrictions | Restrictions | FALSE |
| create_time | Date Created | 2014-05-22T18:08:30Z |
| created_by | Created by | brooksm |
| extent_type_enum_s | Extent Type | linear_feet |
| portion_enum_s | Extent Portion | whole |
| finding_aid_status | Finding Aid Status | in_progress |
| classification_paths | Classification | [{"title":"Manuscript Collections"\,"identifier":"WLU Coll"}] |
| subjects | Subjects | Spiritual journals,Church records and registers,Virginia -- Lexington |
| agents | Agents | Monefeldt\, Jeanne (1906-1985),Paroissin\, Mary (1907- ),Monefeldt\, Edward,Lindbergh\, Charles A. (Charles Augustus\, 1902-1974) |
| creators_text | Creators | Govan\, Gilbert E. (Gilbert Eaton\, 1892- ),Govan\, Christine Noble (1898-1985) |
| role_enum_s | Agent Role | Creator |
| processing_priority_enum_s | Processing Priority | low |
The following useful data points do not display in individual fields in the CSV export, however this data may be found in json field.
- Related Accessions
- Revision Statements
- Related Resources
- Date Expression
- Begin Date
- End Date
- Extent Number
- Last Modified by
Further edits to the CSV export for Resources might include using a semicolon in lieu of a comma to separate multiple values in the subjects fields. LCSH such as Authors, American contain commas. The same issues applies to other fields, like creator and agents, that include personal names.
Digital Objects
The Download CSV functionality for ArchivesSpace v.1.5.0 RC1 exports 413 fields of digital object data, displaying information for representative file versions. The Reports Sub-team recommends culling the full list of fields to the following:
| Download CSV Label | Staff Interface Label | Sample Data |
|---|---|---|
| primary_type | Primary Type | digital_object |
| id | /repositories/2/digital_objects/1 | |
| suppressed | Suppressed? | FALSE |
| title | Title | Dennis Haskins interview |
| digital_object_id | Identifier | MS-135-04-01 |
| publish | Publish? | TRUE |
| level_enum_s | VRA Core Level | work |
| digital_object_type | Type | moving_image |
| language_enum_s | Language | eng |
| use_statement_enum_s | File Version Use Statement | Video-Streaming |
| label_enum_s | Date Label | creation |
| date_type_enum_s | Date Type | single |
| era_enum_s | Era | ce |
| calendar_enum_s | Calendar | Gregorian |
| portion_enum_s | Extent Portion | whole |
| extent_type_enum_s | Extent Type | hours |
| file_format_name_enum_s | File Format Name | avi |
| created_by | Created by | csg376 |
| create_time | Date Created | 2016-03-11T13:59:51Z |
| last_modified_by | Last Modified by | csg376 |
The following useful data points do not display in individual fields in the CSV export, however this data may be found in json field.
- Date Expression
- Begin Date
- End Date
- Extent Number
Subjects
Agents
Locations
The Download CSV functionality for ArchivesSpace v.1.5.0 RC1 exports 414 fields of location data, displaying information for representative file versions. The Reports Sub-team recommends culling the full list of fields to the following:
| Download CSV Label | Staff Interface Label | Sample Data |
|---|---|---|
| primary_type | location | |
| id | /locations/4 | |
| title | Library, 4, 437, Compact shelving [123456789, Manuscripts, Row: 17, Section: 1, Shelf: 1] | |
| temporary | Temporary | exhibit |
| building | Building | Library |
| floor | Floor | 4 |
| room | Room | 437 |
| area | Area | Compact shelving |
| repository | Repository | global |
| publish | Publish? | FALSE |
| suppressed | Suppressed? | FALSE |
| created_by | Created By | csg376 |
| create_time | Date Created | 2014-12-30T14:42:18Z |
| last_modified_by | Last Modified By | csg376 |
The following useful data points do not display in individual fields in the CSV export, however this data may be found in json field.
- Coordinate Label 1
- Coordinate Indicator 1
- Coordinate Label 2
- Coordinate Indicator 2
- Coordinate Label 3
- Coordinate Indicator 3
- Classification
- Barcode
Events
Classifications
ABC: Honestly, I doubt I will ever use this CSV dump in real life. My main interest with Classifications is to have a list of all the resources belonging to each one and that information is available in the Resource CSV dump. I did not identify any additional information that I truly need in the Classification CSV dump.