Caitlin, I was just writing back to say exactly what Brian just mentioned! Attached is a copy of the CSV file that I was able to import.
Mark -----Original Message----- From: archivesspace_users_group-boun...@lyralists.lyrasis.org [mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org] On Behalf Of Brian Harrington Sent: Thursday, 20 December, 2018 3:10 PM To: Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org> Subject: Re: [Archivesspace_Users_Group] Problems with Accessions CSV upload If you open a CSV in Excel, it always helpfully reformats the date. Sigh. I think the specific error you were getting was due to the lack of an agent_type. Try adding “agent_person” there. You will also need to fill in agent_name_name_order (“indirect”), move the name to agent_name_primary_name, and then add either an agent_name_source or and agent_name_rules. (I used “dacs” in agent_name_rules). Then the csv should load. :-) I’d say this needs to be better documented somewhere, but then I’d feel guilty for not having written it up myself. Brian — Brian Harrington Migration Specialist LYRASIS brian.harring...@lyrasis.org Skype: abbistani > On Dec 20, 2018, at 2:58 PM, Caitlin Wells <c...@umich.edu> wrote: > > 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 <busch...@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 > > busch...@msu.edu > > > > > > > > From: archivesspace_users_group-boun...@lyralists.lyrasis.org > <archivesspace_users_group-boun...@lyralists.lyrasis.org> On Behalf Of > Caitlin Wells > Sent: Thursday, December 20, 2018 2:45 PM > To: Archivesspace Users Group > <archivesspace_users_group@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.cus...@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-boun...@lyralists.lyrasis.org > [mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org] On Behalf Of > Hughes, Maggie > Sent: Thursday, 20 December, 2018 11:22 AM > To: Archivesspace Users Group > <archivesspace_users_group@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-boun...@lyralists.lyrasis.org > <archivesspace_users_group-boun...@lyralists.lyrasis.org> On Behalf Of > Caitlin Wells > Sent: Thursday, December 20, 2018 7:54 AM > To: Archivesspace Users Group > <archivesspace_users_group@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@lyralists.lyrasis.org > https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=02%7C01%7Cmark.custer%40yale.edu%7Cd55f220262e54e20a31d08d666b73440%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C636809334381749996&sdata=FBa4W1dVsGxlwaitvHe6GoMi6QEyN1UlPnXfBU62p1U%3D&reserved=0 > > > > > > -- > > 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@lyralists.lyrasis.org > https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=02%7C01%7Cmark.custer%40yale.edu%7Cd55f220262e54e20a31d08d666b73440%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C636809334381749996&sdata=FBa4W1dVsGxlwaitvHe6GoMi6QEyN1UlPnXfBU62p1U%3D&reserved=0 > > > -- > 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@lyralists.lyrasis.org > https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=02%7C01%7Cmark.custer%40yale.edu%7Cd55f220262e54e20a31d08d666b73440%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C636809334381749996&sdata=FBa4W1dVsGxlwaitvHe6GoMi6QEyN1UlPnXfBU62p1U%3D&reserved=0 _______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org https://na01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=02%7C01%7Cmark.custer%40yale.edu%7Cd55f220262e54e20a31d08d666b73440%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C636809334381749996&sdata=FBa4W1dVsGxlwaitvHe6GoMi6QEyN1UlPnXfBU62p1U%3D&reserved=0
test1_agent-change.csv
Description: test1_agent-change.csv
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group