<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;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Garamond;
panose-1:2 2 4 4 3 3 1 1 8 3;}
/* 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.EmailStyle22
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi,<o:p></o:p></p>
<p class="MsoNormal">I am attempting this now and I got the error that I am missing an EAD ID. However, we do not use EAD IDs, plus the instructions do not indicate it is required. IT does clearly state that ONLY the archival object ID is used in the upload.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">One issue not addressed, if I want to link/create new multiple top containers to one archival object record.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Not sure what you are missing, consider sending your spreadsheet so someone can look it over. Did you delete any rows you shouldn’t have? Did you include the required data for creating new top containers and/or use the correct ID numbers?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hope someone can help on this. Will be checking JIRA tickets to see if there are any reports on this feature.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Cheers,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><img width="49" height="61" style="width:.5104in;height:.6354in" id="Graphic_x0020_3" src="cid:image001.png@01D9412D.60101220"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-family:"Verdana",sans-serif"><o:p> </o:p></span></b></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><b><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">Sarit Hand</span></b><b><span style="font-size:10.0pt;font-family:"Garamond",serif"><o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">Digital Archivist</span><span style="font-size:10.0pt;font-family:"Garamond",serif"><br>
</span><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">AP Corporate Archives</span><span style="font-size:10.0pt;font-family:"Garamond",serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">200 Liberty Street<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">New York, NY 10281<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif">T
</span><span lang="FR" style="font-size:10.0pt;font-family:"Garamond",serif">212.621.7035<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Garamond",serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><a href="mailto:shand@ap.org"><span style="color:blue">shand@ap.org</span></a><br>
</span><span style="font-size:12.0pt"><a href="http://www.ap.org"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black">ap.org</span></a></span><span lang="FR" style="font-family:"Verdana",sans-serif"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif"><img border="0" width="266" height="69" style="width:2.7708in;height:.7187in" id="Graphic_x0020_4" src="cid:image002.png@01D9412D.60101220"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<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> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Julie Swierczek<br>
<b>Sent:</b> Monday, February 6, 2023 3:27 PM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] Importing and linking Top Containers via Spreadsheet?<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">Has anyone successfully used the ArchivesSpace 3.0+ bulk import of top containers? I have followed the instructions here:
<a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Farchivesspace.atlassian.net%2Fwiki%2Fspaces%2FArchivesSpaceUserManual%2Fpages%2F2457075717%2FImporting%2Band%2BLinking%2BTop%2BContainers%2Bvia%2BSpreadsheet&data=05%7C01%7Cshand%40ap.org%7C278e61438eb14db01f7108db0880832f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C638113120394802367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=GmuNWpI9Duq5nJOkIHRlCHrilGOf6fuUlKcvJrzR9y8%3D&reserved=0">
https://archivesspace.atlassian.net/wiki/spaces/ArchivesSpaceUserManual/pages/2457075717/Importing+and+Linking+Top+Containers+via+Spreadsheet</a>. I’ve tried importing as .xslx and .csv, but I always get the same error: “Skipping creation and linking of top
containers due to errors.” <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The instructions page says “A detailed note will appear in the Background Jobs page with the reason for failure”, but the error message isn’t particularly helpful.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I’m running v.3.3.1. I’ve tried the usual – using LibreOffice while working with spreadsheets, making sure the cells are formatted as text, etc. I’m wondering if I’m missing some other magic that someone else has figured out? Some of my
box numbers include dashes and parentheses – are there any known restrictions on character types in these fields? Or do I need to sacrifice a paper clip under a full moon before running the upload?
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Any advice would be greatly appreciated!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Julie<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">----<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif">Julie C. Swierczek (SWER-check)<br>
Associate Librarian for Collection Description and Imaging<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#EB3300"><a href="mailto:jswierczek@folger.edu"><span style="color:#EB3300">jswierczek@folger.edu</span></a></span><span style="font-family:"Arial",sans-serif"> | She/her/hers<o:p></o:p></span></p>
<p class="MsoNormal"><b><span style="font-family:"Arial",sans-serif">Folger Shakespeare Library</span></b><span style="font-family:"Arial",sans-serif"> | 201 East Capitol Street SE, Washington, D.C. 20003<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Arial",sans-serif;color:#EB3300"><a href="https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.folger.edu%2F&data=05%7C01%7Cshand%40ap.org%7C278e61438eb14db01f7108db0880832f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C638113120394802367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=FXbZnnNjN0Nio7YkXA6lLp2MNhPwAXGVBeoYemh6z%2Bw%3D&reserved=0"><span style="color:#EB3300">www.folger.edu</span></a></span><span style="font-family:"Arial",sans-serif;color:black">
</span><span style="font-family:"Arial",sans-serif;color:#222222">| Follow us on</span><span style="font-family:"Arial",sans-serif;color:black">
</span><span style="font-family:"Arial",sans-serif;color:#EB3300"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Ffolgershakespearelibrary&data=05%7C01%7Cshand%40ap.org%7C278e61438eb14db01f7108db0880832f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C638113120394802367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=dxaPP2qK%2Fd%2BcHkBlBsIT0Mlk%2BT%2BnEmNRdHNrHBIYNxs%3D&reserved=0"><span style="color:#EB3300">Facebook</span></a></span><span style="font-family:"Arial",sans-serif;color:black">,
</span><span style="font-family:"Arial",sans-serif;color:#EB3300"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2Ffolgerlibrary&data=05%7C01%7Cshand%40ap.org%7C278e61438eb14db01f7108db0880832f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C638113120394802367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=VtKUGBjb5V52SQu8Z0eH2PmT1P0%2FxyGlRA3EVW%2F6JZE%3D&reserved=0"><span style="color:#EB3300">Twitter</span></a></span><span style="font-family:"Arial",sans-serif;color:black">,
and </span><span style="font-family:"Arial",sans-serif;color:#EB3300"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Ffolgerlibrary%2F&data=05%7C01%7Cshand%40ap.org%7C278e61438eb14db01f7108db0880832f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C638113120394802367%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=rQFuPAlOhEluU1bcnqri8o2d%2F1Vp1CI%2FzLq5lqnlTOY%3D&reserved=0"><span style="color:#EB3300">Instagram</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><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>