ArchivesSpace v1.5.0 Release Candidate 1 Download CSV Functionality Notes
- Carolyn Runyon
- Alston Cobourn
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 | 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
The Download CSV functionality for ArchivesSpace v.1.5.0 RC1 exports thousands of fields of agent data. The Reports Sub-team recommends culling the full list of fields to the following:
| Download CSV Label | Staff Interface Label | Sample Data |
|---|---|---|
| repository | Repository | global |
| id | agents/people/1205 | |
| title | Title | Boylan, Scott J. |
| primary_type | Primary Type | agent_person |
| types | Types | agent_person,agent |
| publish | Publish? | TRUE |
| label_enum_s | Label | existence |
| date_type_enum_s | Type | range |
| certainty_enum_s | Certainty | approximate |
| era_enum_s | Era | ce |
| calendar_enum_s | Calendar | gregorian |
| supressed | none | FALSE |
| authority_id | Authority ID | no2004049662 |
| source | Source | lcnaf |
| rules | Rules | aacr |
| name_order_enum_s | Name Order | indirect |
| notes | Notes | 2d516ec3491018547a3c0cc1d2971e68 Penelope Van Dyke Johnson Allen was born on 1886 October 27 in Chattanooga, Tennessee to James Whiteside and Sue Cleave Johnson... 886be69fe320e6e2964c7fedf40f3642 Allen, Penelope Johnson. 1975. <emph>Tennessee soldiers in the Revolution</emph>. Baltimore: Genealogical Pub. Co. eb5a835313399437527606f968cd77eb Allen, Penelope Johnson. 1935. <emph>Guide book of Chattanooga and vicinity.</emph> Chattanooga: Tennessee Volunteer Chapter of the National Society of the United States Daughters of 1812. |
linked_agent_roles | Linked Agent Roles | creator,source,subject |
| created_by | Created by | kennedyk15 |
| create_time | Date created | 2014-03-25T19:53:46Z |
| 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.
- Prefix
- Title
- Primary Part of Name
- Rest of Name
- Suffix
- Fuller Form
- Number
- Dates
- Qualifier
- Related Agents
- Date(s) of Name Use
Further edits to the CSV export for Agents might include the removal of Persistent IDs from the Notes field. Sub Notes indicated as Citation might be more effectively exported to separate columns, e.g. Citation 1, Citation 2, etc. It would also be useful to to include data from Linked Records, identified by Record Type, Title, and Identifier.
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 | Primary Type | location |
| id | /locations/4 | |
| title | 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.