<div dir="ltr">Hi Christine,<div><br></div><div>Thank you for your reply. Yes! I was able to successfully import both spreadsheets in the sandbox! No error messages. Is there a patch that we can apply to our instance to make this work for us?</div><div><br></div><div>This does, however, lead me to another question. We are hoping to use the File version URI field to enter an internal file path (not an actual link), and I thought that if I used column BL on the import spreadsheet (column K on the DO spreadsheet) that the file path would populate the URI field--alas, it doesn't. But I don't see another field on the spreadsheet where one can place the non-linking file path to have it populate the URI field. Is there one that I'm just not interpreting properly?</div><div><br></div><div>Many thanks,</div><div>Wendy </div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p style="color:rgb(0,0,0);font-family:arial;font-size:10px;padding:5px 0px 0px 5px;margin:0px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">____________________________________</span><span style="color:rgb(232,46,33)"><br></span></p><p style="font-family:arial;padding:5px 0px 0px 5px;margin:0px"><span style="font-size:10px;color:rgb(172,147,110);font-weight:bold">WENDY SCHEIR<br></span><b style="font-size:10px"><font color="#666666">DIRECTOR</font></b><br></p><p style="font-family:arial;padding:5px 0px 0px 5px;margin:0px"><img src="https://docs.google.com/uc?export=download&id=16Nic6T4ZK1k1BhLOUToez7KP5Tzv8f9o&revid=0B4enrSUaFYtfdnV0R3E3bEkvek9LUVdsbkRIVUNJaXh1MU9VPQ" width="420" height="37" style="color:rgb(102,102,102);font-size:10px;margin-right:0px"></p><p style="font-family:arial;padding:5px 0px 0px 5px;margin:0px"><span style="font-size:10px;color:rgb(102,102,102)">66 5TH AVENUE, NEW YORK, NY 10011<br></span><a href="mailto:scheirw@newschool.edu" style="font-size:10px;color:rgb(102,102,102)" target="_blank">scheirw@newschool.edu</a></p><p style="padding:5px 0px 0px 5px;margin:0px"><span style="font-family:arial;font-size:10px;color:rgb(0,0,0);font-weight:bold">T</span><span style="font-family:arial;font-size:10px;color:rgb(102,102,102)"> 212.229.5942 x2888</span></p><p style="font-family:arial;font-size:10px;padding:10px 0px 0px 5px;margin:0px"><a href="http://library.newschool.edu/archives" style="color:rgb(172,147,110);font-size:11px" target="_blank">Explore the Archives</a> <span style="color:rgb(0,0,0)">| </span><a href="http://digitalarchives.library.newschool.edu/" style="color:rgb(172,147,110);font-size:11px" target="_blank">Digital Collections from the Archives</a> <span style="color:rgb(0,0,0)">| </span><a href="http://newschoolhistories.org/" style="color:rgb(172,147,110);font-size:11px" target="_blank">New School Histories</a> <font color="#000000">|</font> <a href="https://twitter.com/tnsarchives" style="color:rgb(172,147,110);font-size:11px" target="_blank">@tnsarchives</a></p><div><div><p style="vertical-align:baseline;outline-width:0px;margin:0in 0in 0.0001pt"><font color="#999999" face="Arial, sans-serif" size="1"><span style="line-height:18px"></span></font></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Sep 30, 2020 at 2:43 PM Christine Di Bella <<a href="mailto:christine.dibella@lyrasis.org">christine.dibella@lyrasis.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="gmail-m_-4673172023434538502WordSection1">
<p class="MsoNormal">Hi Wendy,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Can you try importing your file into a dummy record on our test server:
<a href="http://test.archivesspace.org/staff/" target="_blank">http://test.archivesspace.org/staff/</a>? (username admin, password admin)<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">We’ve been working on a number of changes to the importer based on feedback since 2.8.0. The pretty_inspect message usually means there’s a data error that should be caught by the logging process that shows up post-import. Some errors were
not accounted for in the version in 2.8.0 so you get that message instead of the error, but should be there. The digital objects issue is not familiar to me, but I’m wondering if that may be different there too.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">You’ll start the import the same way you usually would on the test server, but it will move the process over to a background job so that it can run more quickly and the log is more easily downloadable afterwards. If you need any more guidance
on that, please let me know.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Christine<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)">Christine Di Bella<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)">ArchivesSpace Program Manager<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)"><a href="mailto:christine.dibella@lyrasis.org" target="_blank"><span style="color:rgb(5,99,193)">christine.dibella@lyrasis.org</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)">800.999.8558 x2905<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)">678-235-2905<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><img border="0" width="267" height="61" style="width: 2.7777in; height: 0.6388in;" id="gmail-m_-4673172023434538502Picture_x0020_1" src="cid:174e06e0e6f5b006a1" alt="ASpaceOrgHomeMedium"><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Wendy Scheir<br>
<b>Sent:</b> Wednesday, September 30, 2020 2:14 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] spreadsheet imports in 2.8v SUI<u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">In addition to the DO import spreadsheet error that I indicated in my recent email re: duplicate field codes, another error message I'm receiving in trying to import the DOs is: "<span style="font-family:Helvetica,sans-serif;color:rgb(51,51,51)">{"error":"undefined
method `pretty_inspect' for #"}"</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Helvetica,sans-serif;color:rgb(51,51,51)">I'd be grateful for any insight you can provide on these issues.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Helvetica,sans-serif;color:rgb(51,51,51)">Many thanks,</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-family:Helvetica,sans-serif;color:rgb(51,51,51)">Wendy</span><u></u><u></u></p>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Wed, Sep 30, 2020 at 1:28 PM Wendy Scheir <<a href="mailto:scheirw@newschool.edu" target="_blank">scheirw@newschool.edu</a>> wrote:<u></u><u></u></p>
</div>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">In attempting to upload spreadsheets into ASpace using the Load via Spreadsheet functionality in the 2.8v SUI, I'm running into 2 issues and hoping that someone can shed some light. In each case, I'm using the import spreadsheets downloaded
from Github: <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">(1) Using the general import spreadsheet to upload a collection that includes digital objects--fields BJ (digital_object_id), BK (digital_object_title), BL (digital_object_link) the archival objects imported, but not the digital objects.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">(2) Using the DO import spreadsheet (again, downloaded directly from Github), I'm getting the error message "This spreadsheet has duplicate Archive Space Field codes: , , , , , , , , , , , , ," However, I don't see any obvious duplicate
field codes in Row 4 of the spreadsheet.<u></u><u></u></p>
</div>
</div>
</blockquote>
</div>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div>