[Archivesspace_Users_Group] Problems with Accessions CSV upload

[Caitlin Wells]

Spreadsheet attached! It only has one record, but that one record is giving
me the same error message as the full sheet.

Caitlin

On Thu, Dec 20, 2018 at 2:09 PM Custer, Mark <mark.custer at yale.edu> wrote:

> Caitlin,
>
>
>
> 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)
>
>
>
> 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
> 😊
>
>
>
> Mark
>
>
>
>
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org [mailto:
> archivesspace_users_group-bounces at lyralists.lyrasis.org] *On Behalf Of *Hughes,
> Maggie
> *Sent:* Thursday, 20 December, 2018 11:22 AM
> *To:* Archivesspace Users Group <
> archivesspace_users_group at lyralists.lyrasis.org>
> *Subject:* Re: [Archivesspace_Users_Group] Problems with Accessions CSV
> upload
>
>
>
> Hi Caitlin,
>
>
>
> 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)?
>
>
>
> Maggie
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org <
> archivesspace_users_group-bounces at lyralists.lyrasis.org> *On Behalf Of *Caitlin
> Wells
> *Sent:* Thursday, December 20, 2018 7:54 AM
> *To:* Archivesspace Users Group <
> archivesspace_users_group at lyralists.lyrasis.org>
> *Subject:* [Archivesspace_Users_Group] Problems with Accessions CSV upload
>
>
>
> Hi all,
>
>
>
> 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:
>
>
>
> Error: #<NoMethodError: undefined method `sub' for nil:NilClass>
>
>
>
>
> What does this error message mean? Is there an easy fix for this that I
> can do within the spreadsheet and without a programmer?
>
>
>
> Best,
> Caitlin
>
>
>
> --
>
> Caitlin R. Wells
>
> Collection Services Librarian, Special Collections Research Center
>
> University of Michigan, Ann Arbor 48109
>
> P: (734) 763-7901
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>


-- 
Caitlin R. Wells
Collection Services Librarian, Special Collections Research Center
University of Michigan, Ann Arbor 48109
P: (734) 763-7901
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20181220/85d4a38c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test1.csv
Type: text/csv
Size: 5545 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20181220/85d4a38c/attachment.csv>