[Archivesspace_Users_Group] Problems with Accessions CSV upload

Busch, Ed buschedw at msu.edu
Thu Dec 20 14:52:23 EST 2018


Does the date need to be YYYY-MM-DD rather than MM-DD-YYYY?

Ed Busch, MLIS
Electronic Records Archivist
Michigan State University Archives
Conrad Hall
943 Conrad Road, Room 101
East Lansing, MI 48824
517-884-6438
buschedw at msu.edu<mailto:buschedw at msu.edu>



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 2:45 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Problems with Accessions CSV upload

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<mailto: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> [mailto: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<mailto: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<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto: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<mailto: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<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwMFaQ&c=nE__W8dFE-shTxStwXtp0A&r=nzQRpzss_AwHOHAKVWRsNQ&m=plkgBpmZYQ2VOy6LxgfumFCkXitMI9bowcNRnXaCgwI&s=EfH0EdZQSyFZNx4Pnxu__bYlFgiDBEmNKvTFX3NLDcI&e=>


--
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/6ed54694/attachment.html>


More information about the Archivesspace_Users_Group mailing list