[Archivesspace_Users_Group] Excel Import Question

[Mendoza, David]

Thanks Valerie.  Maybe its my version or user error, but the importer is not taking action relative to the level I select for a resource.  I downloaded the attached file from the help site, but maybe its an older version.  It is a pretty cool tool for new adds though.

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Valerie Addonizio
Sent: Wednesday, May 24, 2023 12:43 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Excel Import Question

David,

It is correct that that importer only creates new records, however they do not have to be for the collection and you can add children to series. The importer takes action at whatever level of the hierarchy is selected when you create the import job. If you're on a Resource record with no existing children, there is only one option (the resource) and in that case you will always get children of that resource; but if you're on a resource with a series, and you're on the series level when you click to import, the archival objects should be created under that series.

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> On Behalf Of Mendoza, David
Sent: Wednesday, May 24, 2023 12:22 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] Excel Import Question

Two more question to all as I get more familiar.  I'm on AS version 3.0.1.
It looks like regardless of what hierarchy level I select while editing a collection, all imports seem to default to a child of the collection.  Is this true for everyone?
Secondly, is it correct to assume that regardless of the level of entry, the import sheet only creates new records?  Ie, it will not add to existing series/children already created in AS, correct?

Thanks!
David

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> On Behalf Of Valerie Addonizio
Sent: Tuesday, May 23, 2023 4:40 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] Excel Import Question

Hi David, any record's URI is available at the top of the record when in View mode. Look for it next to the Created and Last Modified information.

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> On Behalf Of Mendoza, David
Sent: Tuesday, May 23, 2023 1:21 PM
To: archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Excel Import Question

Hi All,
Apologies if this is a cross post.  I've been experimenting with the excel import sheet.  This is kind of embarrassing, but I cannot locate the Resource URI for a given resource/collection.  I assumed it was the Identifier at the collection level, but I'm getting errors that do not recognize the Resource ID.  Alternatively, I used an EAD ID and it worked, but the hierarchy codes are causing errors unless I designate an archival object as level 1.  I'm not sure if hierarchy codes only work if a Resource ID is used.

I'm not sure if this is an issue with the excel sheet or just user error.  If any one has any advice or a youtube clip (I couldn't find one), it would greatly be appreciated.

Thanks!
David
________________________________
This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message.
________________________________
This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer. If you are not the intended recipient, please delete this message.

----------------------------------------------------------------------
This message, and any attachments, is for the intended recipient(s) only, may contain information that is privileged, confidential and/or proprietary and subject to important terms and conditions available at http://www.bankofamerica.com/emaildisclaimer.   If you are not the intended recipient, please delete this message.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230524/ded277d7/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bulk_import_template.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 23444 bytes
Desc: bulk_import_template.xlsx
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230524/ded277d7/attachment.xlsx>