<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi David,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If the agent or subject currently exists in the system, you have to use the ID, you cannot put in a partial name or word and expect the system to recognize which record you are referencing. Afterall, if you have multiple records with the
same word as part of the record title it would be impossible to rectify, hence you need the UID. If the agent or subject record is new to the system you can add the full title in the importer and a new record will be created, however, you then have to go into
ASpace to fill in the remaining fields for that agent or subject record. If you are adding many new records, there is the
<a href="https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/894533770">
LCNAF importer</a> (if you use that) consider bulk importing those first, acquiring their UIDs and then using the UID in the bulk importer for your resource records and/or components. It is not ideal but if you Browse Agents/subjects you can see the URI which
containers the UID. If you cannot see that, then you will need to go into your preferences and change/add column to include the URI. After that you can copy and paste just the number or download the list and use excel to extract the numbers if you are doing
bulk stuff. Sometimes you must look at workarounds to get what you want. Hope this all makes sense and answers your questions.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt">Cheers,</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><img border="0" width="61" height="70" style="width:.6319in;height:.7291in" id="Picture_x0020_1" src="cid:image001.png@01D9A5E4.DC2C5640"> <img border="0" width="87" height="47" style="width:.9097in;height:.4861in" id="Picture_x0020_2" src="cid:image002.jpg@01D9A5E4.DC2C5640"><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt">Sarit Hand <span style="color:#323130">200 Liberty St.</span></span><o:p></o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt">Digital Archivist <span style="color:#323130">New York, NY 10281</span></span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt">Corporate Archives <span style="color:#323130">T 212.621.7035</span></span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt"> </span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt"><br>
shand@ap.org </span><o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><a href="http://www.ap.org/"><span style="font-size:10.0pt;color:blue">www.ap.org</span></a><o:p></o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Mendoza, David<br>
<b>Sent:</b> Tuesday, June 13, 2023 4:01 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Excel Import Question<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:red">[EXTERNAL]<o:p></o:p></span></p>
<div>
<p class="MsoNormal">Hi All,<o:p></o:p></p>
<p class="MsoNormal">Reopening my query regarding Agent Links. Can the excel import spreadsheet link to existing Agents? I assume yes, but can the Primary Part of the Name be used to create a link or are record IDs required in some way? I don’t see any required
cells for agents in the spreadsheet. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Also, forgive me if asked before, but are container profiles linkable? I don’t see the option in the spreadsheet to specify container profiles.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks again in advance to anyone who might know.<o:p></o:p></p>
<p class="MsoNormal">David <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><a name="_____replyseparator"></a><b>From:</b> Mendoza, David
<br>
<b>Sent:</b> Wednesday, May 24, 2023 1:59 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> RE: [Archivesspace_Users_Group] Excel Import Question<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Valerie Addonizio<br>
<b>Sent:</b> Wednesday, May 24, 2023 12:43 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Excel Import Question<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">David,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Mendoza, David<br>
<b>Sent:</b> Wednesday, May 24, 2023 12:22 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Excel Import Question<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Two more question to all as I get more familiar. I’m on AS version 3.0.1.
<o:p></o:p></p>
<p class="MsoNormal">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?
<o:p></o:p></p>
<p class="MsoNormal">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?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks!<o:p></o:p></p>
<p class="MsoNormal">David <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Valerie Addonizio<br>
<b>Sent:</b> Tuesday, May 23, 2023 4:40 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Excel Import Question<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi David, any record’s URI is available at the top of the record when in View mode. Look for it next to the
<b>Created</b> and <b>Last Modified</b> information.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Mendoza, David<br>
<b>Sent:</b> Tuesday, May 23, 2023 1:21 PM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Excel Import Question<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi All,<o:p></o:p></p>
<p class="MsoNormal">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. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks!<o:p></o:p></p>
<p class="MsoNormal">David <o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="100%" align="center">
</div>
<p class="MsoNormal">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
<a href="http://www.bankofamerica.com/emaildisclaimer">http://www.bankofamerica.com/emaildisclaimer</a>. If you are not the intended recipient, please delete this message.<o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="1" width="100%" align="center">
</div>
<p class="MsoNormal">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
<a href="http://www.bankofamerica.com/emaildisclaimer">http://www.bankofamerica.com/emaildisclaimer</a>. If you are not the intended recipient, please delete this message.<o:p></o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p class="MsoNormal">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
<a href="http://www.bankofamerica.com/emaildisclaimer">http://www.bankofamerica.com/emaildisclaimer</a>. If you are not the intended recipient, please delete this message.<o:p></o:p></p>
</div>
</div>
The information contained in this communication is intended for the use of the designated recipients named above. If the reader of this communication is not the intended recipient, you are hereby notified that you have received this communication in error,
and that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify The Associated Press immediately by telephone at +1-212-621-1500 and delete this email.
Thank you.
</body>
</html>