Re: [Archivesspace_Users_Group] Problems with Accessions CSV upload

2018-12-20 Thread Custer, Mark
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 
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  wrote:
> 
> Yes, it should be, and was when I saved the document. Is it not displaying as 
> -MM-DD?
> 
> On Thu, Dec 20, 2018 at 2:53 PM Busch, Ed  wrote:
> Does the date need to be -MM-DD rather than MM-DD-?
> 
>  
> 
> 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 
>  On Behalf Of 
> Caitlin Wells
> Sent: Thursday, December 20, 2018 2:45 PM
> To: Archivesspace Users Group 
> 
> 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  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 
> 
> 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 
>  On Behalf Of 
> Caitlin Wells
> Sent: Thursday, December 20, 2018 7:54 AM
> To: Archivesspace Users Group 
> 
> 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
> 
> ___

Re: [Archivesspace_Users_Group] Problems with Accessions CSV upload

2018-12-20 Thread Caitlin Wells
Thank you, Brian, for the agent tips! I'll fill out those fields and see if
it loads now! (And I've been fighting with Excel for literally hours over
the date formatting, so glad to know that might be an issue as well.)

On Thu, Dec 20, 2018 at 3:10 PM Brian Harrington <
brian.harring...@lyrasis.org> wrote:

> 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  wrote:
> >
> > Yes, it should be, and was when I saved the document. Is it not
> displaying as -MM-DD?
> >
> > On Thu, Dec 20, 2018 at 2:53 PM Busch, Ed  wrote:
> > Does the date need to be -MM-DD rather than MM-DD-?
> >
> >
> >
> > 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 
> 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
> 

Re: [Archivesspace_Users_Group] Problems with Accessions CSV upload

2018-12-20 Thread Brian Harrington
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  wrote:
> 
> Yes, it should be, and was when I saved the document. Is it not displaying as 
> -MM-DD?
> 
> On Thu, Dec 20, 2018 at 2:53 PM Busch, Ed  wrote:
> Does the date need to be -MM-DD rather than MM-DD-?
> 
>  
> 
> 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 
>  On Behalf Of 
> Caitlin Wells
> Sent: Thursday, December 20, 2018 2:45 PM
> To: Archivesspace Users Group 
> 
> 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  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 
> 
> 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 
>  On Behalf Of 
> Caitlin Wells
> Sent: Thursday, December 20, 2018 7:54 AM
> To: Archivesspace Users Group 
> 
> 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
> 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
> 
> ___

Re: [Archivesspace_Users_Group] Problems with Accessions CSV upload

2018-12-20 Thread Busch, Ed
Not when I open but maybe local defaults? I haven’t used the importer myself 
but was curious. ☺

From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Caitlin 
Wells
Sent: Thursday, December 20, 2018 2:58 PM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] Problems with Accessions CSV upload

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

On Thu, Dec 20, 2018 at 2:53 PM Busch, Ed 
mailto:busch...@msu.edu>> wrote:
Does the date need to be -MM-DD rather than MM-DD-?

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<mailto:busch...@msu.edu>



From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Caitlin Wells
Sent: Thursday, December 20, 2018 2:45 PM
To: Archivesspace Users Group 
mailto: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 
mailto: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>
 
[mailto: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 
mailto: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<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Caitlin Wells
Sent: Thursday, December 20, 2018 7:54 AM
To: Archivesspace Users Group 
mailto: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<mailto:Archivesspace_Users_Group@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=DwMFaQ=nE__W8dFE-shTxStwXtp0A=nzQRpzss_AwHOHAKVWRsNQ=plkgBpmZYQ2VOy6LxgfumFCkXitMI9bowcNRnXaCgwI=EfH0EdZQSyFZNx4Pnxu__bYlFgiDBEmNKvTFX3NLDcI=>


--
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<mailto:Archivesspace_Users_Group@lyralists.lyrasis.org>
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<https://urldefense.proofpoint.com/v2/url?u=h

Re: [Archivesspace_Users_Group] Problems with Accessions CSV upload

2018-12-20 Thread Caitlin Wells
Yes, it should be, and was when I saved the document. Is it not displaying
as -MM-DD?

On Thu, Dec 20, 2018 at 2:53 PM Busch, Ed  wrote:

> Does the date need to be -MM-DD rather than MM-DD-?
>
>
>
> *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  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
> 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=DwMFaQ=nE__W8dFE-shTxStwXtp0A=nzQRpzss_AwHOHAKVWRsNQ=plkgBpmZYQ2VOy6LxgfumFCkXitMI9bowcNRnXaCgwI=EfH0EdZQSyFZNx4Pnxu__bYlFgiDBEmNKvTFX3NLDcI=>
>
>
>
>
> --
>
> 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
> 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
___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group


Re: [Archivesspace_Users_Group] Problems with Accessions CSV upload

2018-12-20 Thread Custer, Mark
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 
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<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Caitlin Wells
Sent: Thursday, December 20, 2018 7:54 AM
To: Archivesspace Users Group 
mailto: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
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group


Re: [Archivesspace_Users_Group] Problems with Accessions CSV upload

2018-12-20 Thread Hughes, Maggie
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 
 On Behalf Of Caitlin 
Wells
Sent: Thursday, December 20, 2018 7:54 AM
To: Archivesspace Users Group 
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
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group