[Archivesspace_Users_Group] Example of a CSV excel spreadsheet?

[Calev, Suzanna]

Dear Noah,

Thank you so much for this! What I'm wondering, do you need to keep the
rows 1-3 and 5 for AS to recognize the metadata or is it only row 4 that is
being recognized? does it matter if you do or don't keep those rows in?

Also if you're trying to connect digital objects from a server or a DAMS to
this metadata, is there a separate workflow that you use to connect them? I
saw a different DO archivesspace template and do you need to do that
separately or can you add it to this csv file?

My institution uses Omeka and typically I have to upload the digital files
to the Omeka server and then upload the CSV file to have it recognize and
connect the digital file pathways to the DO. Since we're hosting AS on our
own servers I was wondering if there's something I should be doing with AS
to connect them with the files in Omeka or if I wanted to upload them
directly from our server?

Just curious if that's something you've done.

Thank you so much for your help,
Suzanna

On Fri, Jan 29, 2021 at 5:00 PM Noah Huffman <noah.huffman at duke.edu> wrote:

> 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.J
>
>
>
> 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
>
>
>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>


-- 
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
Cell: 917-656-3515
suzanna.calev at wilkes.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210129/657d7015/attachment.html>