[Archivesspace_Users_Group] Problems with Accessions CSV upload

[Caitlin Wells]

Yes, it should be, and was when I saved the document. Is it not displaying
as YYYY-MM-DD?

On Thu, Dec 20, 2018 at 2:53 PM Busch, Ed <buschedw at msu.edu> wrote:

> 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
>
>
>
>
>
>
>
> *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> 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
> <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
> _______________________________________________
> 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/05ec0e70/attachment.html>