[Archivesspace_Users_Group] Problems with Accessions CSV upload

Custer, Mark mark.custer at yale.edu
Thu Dec 20 15:15:37 EST 2018 

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-bounces at lyralists.lyrasis.org [mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org] On Behalf Of Brian Harrington
Sent: Thursday, 20 December, 2018 3:10 PM
To: Archivesspace Users Group <archivesspace_users_group at 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.harrington at lyrasis.org
Skype: abbistani


> On Dec 20, 2018, at 2:58 PM, Caitlin Wells <cwel at 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 <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
> 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 at 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 at 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 at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: test1_agent-change.csv
Type: application/octet-stream
Size: 5566 bytes
Desc: test1_agent-change.csv
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20181220/389d8c1f/attachment.obj>

More information about the Archivesspace_Users_Group mailing list