<div dir="ltr">Spreadsheet attached! It only has one record, but that one record is giving me the same error message as the full sheet. <div><br>Caitlin</div></div><br><div class="gmail_quote"><div dir="ltr">On Thu, Dec 20, 2018 at 2:09 PM Custer, Mark <<a href="mailto:mark.custer@yale.edu" target="_blank">mark.custer@yale.edu</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_7794109039760143087gmail-m_6780541751235254626WordSection1">
<p class="MsoNormal">Caitlin,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">It looks like that error means that the conversion process is trying to replace some text (using “sub”), but there’s no text there at the point that it’s trying to do the replacement (hence the “nil” part). Hard to say exactly what would
be causing that without seeing the CSV file, though. Looking at the code, it seems likely that it could be caused by a date or an agent link, perhaps. The dates are transformed a bit during the process, so I’d review those first (the accession dates, and
any event-related dates)<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">If it’s completely unclear what could be causing the issue when reviewing the file, one strategy is just to delete half of the rows, and then try the import again. If it fails, delete half and try again. Of course, that’s hoping that
not every row has the same issue, but that’s good to know, too <span style="font-family:"Segoe UI Emoji",sans-serif">
😊</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Mark<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>
<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> [mailto:<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>Hughes, Maggie<br>
<b>Sent:</b> Thursday, 20 December, 2018 11:22 AM<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] Problems with Accessions CSV upload<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Hi Caitlin,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I never know what the error messages mean, but it is probably something within the spreadsheet. Are you able to send the CSV (or a sample of it, esp. if it contains sensitive data)?
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Maggie<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<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>Caitlin Wells<br>
<b>Sent:</b> Thursday, December 20, 2018 7:54 AM<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> [Archivesspace_Users_Group] Problems with Accessions CSV upload<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Hi all,<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I'm trying to upload accessions via the CSV and keep getting the same error. Every time I try to run the background job, it fails and I get the following message:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10pt;font-family:"Courier New";color:rgb(51,238,51);background:rgb(51,51,51)">Error: #<NoMethodError: undefined method `sub' for nil:NilClass></span> <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">What does this error message mean? Is there an easy fix for this that I can do within the spreadsheet and without a programmer? <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Best,<br>
Caitlin<br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal">-- <u></u><u></u></p>
<div>
<div>
<div>
<div>
<p class="MsoNormal">Caitlin R. Wells<u></u><u></u></p>
<div>
<p class="MsoNormal">Collection Services Librarian, Special Collections Research Center<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">University of Michigan, Ann Arbor 48109<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">P: (734) 763-7901<u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</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-m_7794109039760143087gmail_signature"><div dir="ltr"><div><div dir="ltr">Caitlin R. Wells<div>Collection Services Librarian, Special Collections Research Center</div><div>University of Michigan, Ann Arbor 48109</div><div>P: (734) 763-7901</div></div></div></div></div>