[Archivesspace_Users_Group] Example of a CSV excel spreadsheet?

[Noah Huffman]

Hi Suzanna,

I’ve attached a sample import spreadsheet. This sheet may not use the most up-to-date template, but it should give you an idea of how the data should be formatted and it should still import successfully. Obviously, you’ll note that this is fake data, but hopefully illustrative.☺

For the publish column, use TRUE if you want to the imported record to be visible in the ArchivesSpace public interface, FALSE if not. I think if you leave that column blank it will default to TRUE, which will effectively check all the “publish” checkboxes for the imported archival objects.

For the EADID column, the value in your spreadsheet must match the value in the EAD ID field of your resource record in ArchivesSpace.

Here’s a link to video tutorial on using the Spreadsheet importer (formerly known as the Harvard Import Tool): https://youtu.be/xl-KjVCmm9g

Hope this helps,
-Noah

================
Noah Huffman
Archivist for Metadata, Systems, and Digital Records
David M. Rubenstein Rare Book & Manuscript Library
Duke University | 919-660-5982
http://library.duke.edu/rubenstein/
Pronouns: he / him / his

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Calev, Suzanna
Sent: Friday, January 29, 2021 4:41 PM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] Example of a CSV excel spreadsheet?

Hi everyone,
I apologize if this is extremely obvious, but I'm still trying to figure out how to do things in AS.  I'm trying to create a csv file from the templates provided in the AS documentation and I'm confused as to what to put in certain sections. For example, the publish column, do we say yes or no? or put something else to indicate whether we want it to be published? For the hierarchy one, we are just putting numbers 1, 2, or 3 to indicate if the item is a resource, child, or grandchild of the parent item?
For the EAD ID, should you be entering a unique number into the resource so that it identifies what resource you're using? or is that for the component unique identifier column?

I think what would really help me is to see an example of what other people have done for a particular collection, even if it's just a few rows, if anyone is willing to share with me what they've entered into the different columns for your csv files, I think it would help me figure out how to configure my own for the photo collection metadata I'm trying to upload.
Thank you,
Suzanna

--
Suzanna Calev, MLIS & MA
Archivist/Public Services Librarian
Farley Library
187 South Franklin Street
Wilkes-Barre, PA 18766
Office: 570-408-2012
Archives: 570-408-4264

suzanna.calev at wilkes.edu<mailto:suzanna.calev at wilkes.edu>



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210129/39013805/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: noahs_ark_test_import_excel_to_aspace.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 51634 bytes
Desc: noahs_ark_test_import_excel_to_aspace.xlsx
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210129/39013805/attachment.xlsx>