<div dir="ltr">Hi Christine,<div><br></div><div>Following up on your exchange with Wendy regarding the improved spreadsheet importer. Do you know when we can expect the next version of ArchivesSpace will be released?</div><div><br></div><div>Thanks,</div><div>Anna</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Oct 1, 2020 at 9:45 AM 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_1638195480140425846WordSection1">
<p class="MsoNormal">Hi Wendy,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">That’s great to hear. The improved importer will be in the next version of ArchivesSpace.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I understand that Bobbi Fox, the original developer of this functionality, has been in touch with you. She confirmed that what you’re trying to do is not supported. Now that the importer is in ArchivesSpace, new feature requests would be
evaluated through our regular development prioritization process. You can file a feature request by following the instructions at
<a href="https://archivesspace.atlassian.net/wiki/spaces/ADC/pages/19202060/How+to+Request+a+New+Feature" target="_blank">
https://archivesspace.atlassian.net/wiki/spaces/ADC/pages/19202060/How+to+Request+a+New+Feature</a>.<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>
<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 3:28 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>
<p class="MsoNormal">Hi Christine,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">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?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">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?<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Many thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Wendy <u></u><u></u></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>
<p style="margin:0in"><span style="font-size:10pt;font-family:Arial,sans-serif;color:rgb(34,34,34)">____________________________________</span><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:black"><u></u><u></u></span></p>
<p style="margin:0in"><b><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(172,147,110)">WENDY SCHEIR<br>
</span></b><b><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(102,102,102)">DIRECTOR</span></b><span style="font-family:Arial,sans-serif"><u></u><u></u></span></p>
<p style="margin:0in"><span style="font-family:Arial,sans-serif"><img border="0" width="420" height="37" style="width: 4.375in; height: 0.3819in;" id="gmail-m_1638195480140425846_x0000_i1026" src="https://docs.google.com/uc?export=download&id=16Nic6T4ZK1k1BhLOUToez7KP5Tzv8f9o&revid=0B4enrSUaFYtfdnV0R3E3bEkvek9LUVdsbkRIVUNJaXh1MU9VPQ"></span><span style="font-family:Arial,sans-serif"><u></u><u></u></span></p>
<p style="margin:0in"><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(102,102,102)">66 5TH AVENUE, NEW YORK, NY 10011<br>
</span><span style="font-family:Arial,sans-serif"><a href="mailto:scheirw@newschool.edu" target="_blank"><span style="font-size:7.5pt;color:rgb(102,102,102)">scheirw@newschool.edu</span></a><u></u><u></u></span></p>
<p style="margin:0in"><b><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:black">T</span></b><span style="font-size:7.5pt;font-family:Arial,sans-serif;color:rgb(102,102,102)"> 212.229.5942 x2888</span><u></u><u></u></p>
<p style="margin:0in"><span style="font-size:7.5pt;font-family:Arial,sans-serif"><a href="http://library.newschool.edu/archives" target="_blank"><span style="font-size:8.5pt;color:rgb(172,147,110)">Explore the Archives</span></a> <span style="color:black">| </span><a href="http://digitalarchives.library.newschool.edu/" target="_blank"><span style="font-size:8.5pt;color:rgb(172,147,110)">Digital
Collections from the Archives</span></a> <span style="color:black">| </span><a href="http://newschoolhistories.org/" target="_blank"><span style="font-size:8.5pt;color:rgb(172,147,110)">New School Histories</span></a> <span style="color:black">|</span> <a href="https://twitter.com/tnsarchives" target="_blank"><span style="font-size:8.5pt;color:rgb(172,147,110)">@tnsarchives</span></a><u></u><u></u></span></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>
<p class="MsoNormal" style="outline-width:0px"><u></u> <u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">On Wed, Sep 30, 2020 at 2:43 PM Christine Di Bella <<a href="mailto:christine.dibella@lyrasis.org" target="_blank">christine.dibella@lyrasis.org</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>
<div>
<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</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)">ArchivesSpace Program Manager</span><u></u><u></u></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></span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)">800.999.8558 x2905</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)">678-235-2905</span><u></u><u></u></p>
<p class="MsoNormal"><span style="font-family:Arial,sans-serif;color:rgb(31,73,125)"> </span><u></u><u></u></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_1638195480140425846gmail-m_-4673172023434538502Picture_x0020_1" src="cid:17504e467e86917eb1" 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:5pt 0in 5pt 4.8pt">
<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>
<p class="MsoNormal">_______________________________________________<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" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><u></u><u></u></p>
</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><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><p style="font-family:arial;font-size:10px;padding:5px 0px 0px 5px;margin:0px"><font color="#ac936e"><b>ANNA ROBINSON-SWEET</b></font><br><font color="#000000"><b>ASSOCIATE ARCHIVIST</b></font><br><span style="color:rgb(172,147,110)">THE NEW SCHOOL</span><br><font color="#666666">ARCHIVES & SPECIAL COLLECTIONS</font></p><p style="font-family:arial;font-size:10px;color:rgb(102,102,102);padding:10px 0px 0px 5px;margin:0px"><span>she/her pronouns</span></p><p style="font-family:arial;font-size:10px;color:rgb(102,102,102);padding:10px 0px 0px 5px;margin:0px"><span>66 FIFTH AVENUE, NEW YORK, NY 10011</span><br>robinsa1<a href="mailto:XXXX@newschool.edu" style="color:rgb(102,102,102)" target="_blank">@newschool.edu</a><br><span style="color:rgb(0,0,0);font-weight:bold">T</span> 212.229.2942 x3375</p><p style="font-family:arial;font-size:10px;color:rgb(102,102,102);padding:10px 0px 0px 5px;margin:0px">@TNSArchives</p><p style="font-family:arial;font-size:10px;color:rgb(102,102,102);padding:10px 0px 0px 5px;margin:0px"><a href="http://www.newschool.edu/100" style="font-size:11px;color:rgb(172,147,110)" target="_blank">newschool.edu/100</a></p><div dir="ltr"><br></div><div dir="ltr"><img src="https://docs.google.com/uc?export=download&id=189ZGQUNkFTPT1lROYObQ8PLnSSMd5Hk6&revid=0B5_JPhPijR4aTVZLSEQ5VlR5VkkyaGU2K3JHYmVPUFU2UWpJPQ" width="420" height="37"><br><br></div></div></div></div></div></div></div></div></div></div></div>