Re: [Archivesspace_Users_Group] Deleting duplicate commas - MySQL woes

2018-12-20 Thread Blake Carver 
Maybe it's just the copy and paste has left you with those darn "fancy quotes", 
I brought up MySQL 8 here and these both worked, but after I made sure to put 
the regular ' in there because when I copied and pasted your message it had the 
curly things and both commands barfed with:

"ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
that corresponds to your MySQL server version for the right syntax to use near 
',’ FROM title)' at line 2"

It's not super obvious in there, but the single quotes ' are curved, and not a 
plain '


Here's what worked:


MySQL [archivesspace]> UPDATE archival_object SET display_string = 
replace(display_string, ',,', ',');
Query OK, 1 row affected (0.10 sec)
Rows matched: 18501  Changed: 1  Warnings: 0

MySQL [archivesspace]> UPDATE archival_object SET title = TRIM(TRAILING ',' 
FROM title);
Query OK, 5 rows affected (0.12 sec)
Rows matched: 18501  Changed: 5  Warnings: 0

Not sure how this will get formatted or reformatted from the mail programs, so 
you may need to do it again.


From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 on behalf of Danielle 
Butler 
Sent: Thursday, December 20, 2018 6:26:47 PM
To: Archivesspace Users Group
Subject: [Archivesspace_Users_Group] Deleting duplicate commas - MySQL woes


We’re trying to get rid of duplicate commas in our data in component 
descriptions. We manually included commas when we were using Archivists' 
Toolkit, and we migrated all of that data. Now we'd like to clean it up so that 
every description doesn't have two commas if we were to ever more to the PUI.


I was given a command for an older MySQL server version, and modified it using 
the MySQL Server v. 8 manual.

I believe this is the appropriate way to format the command, but I am getting 
syntax errors on the first command. I've scoured the manual and can't sort out 
what is causing the error.


Does anyone see an apparent issue with my syntax that I'm missing? Again, these 
commands are for v. 8.


REPLACE INTO archival_object VALUES (display_string , ',,', ',');

SELECT TRIM(TRAILING ',' FROM 'title');


Thanks for any advice you can give,


Danielle Butler, CA | Archivist

Butler Center for Arkansas Studies | Central Arkansas Library System

www.butlercenter.org

100 Rock Street

Little Rock, AR 72201

501-320-5724


___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

[Archivesspace_Users_Group] Deleting duplicate commas - MySQL woes

2018-12-20 Thread Danielle Butler 
We’re trying to get rid of duplicate commas in our data in component 
descriptions. We manually included commas when we were using Archivists' 
Toolkit, and we migrated all of that data. Now we'd like to clean it up so that 
every description doesn't have two commas if we were to ever more to the PUI.


I was given a command for an older MySQL server version, and modified it using 
the MySQL Server v. 8 manual.

I believe this is the appropriate way to format the command, but I am getting 
syntax errors on the first command. I've scoured the manual and can't sort out 
what is causing the error.


Does anyone see an apparent issue with my syntax that I'm missing? Again, these 
commands are for v. 8.


REPLACE INTO archival_object VALUES (display_string , ',,', ',');

SELECT TRIM(TRAILING ',' FROM 'title');


Thanks for any advice you can give,


Danielle Butler, CA | Archivist

Butler Center for Arkansas Studies | Central Arkansas Library System

www.butlercenter.org

100 Rock Street

Little Rock, AR 72201

501-320-5724


___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Re: [Archivesspace_Users_Group] REMINDER: Proposal for Container Management Enhancements - Call for Community Input

2018-12-20 Thread Bowers, Kate A. 
Dear ArchivesSpace community:

Apologies for the length of this. I’ll try to address a lot of comments, but 
not all!  Please let me know if (as they may well do) my elaborations only 
elicit more questions!

In general, most of these proposals are derived from facing problems of scale. 
Harvard has 30 repositories and over 200 users of ArchivesSpace. Others have to 
do with managing “medium rare” materials’ locations and containers in 
ArchivesSpace.  (Medium-rare is a tongue-in-cheek term used to cover materials 
that might exist in multiple manifestations but that have archival or rare 
characteristics or treatment. Examples include entire libraries ingested into 
an archives, author’s own copies of their books, annotated books, or the record 
copy of serials or reports kept by institutional archives.)

 • Multi-field top container indicators
 Some commenters wondered if the multiple fields were to accommodate child 
containers. To clarify, the suggestion was to facilitate parsing top container 
identifiers.  As a few commenters have surmised, this is to cope with legacy 
numbers.  These are especially common on medium-rare materials.
 One suggestion was to use a sort algorithm that would obviate the need for 
separated fields for data. However, because there would be is more than one 
algorithm necessary over the installation, such a solution would require an 
added field to identify the algorithm and probably a third field retain a value 
derived by the algorithm to be sorted alphanumerically. Thus, the direct 
3-field solution seems simpler. (A 4-field suggestion was mooted in the 
committee as potentially more useful communally.) It does occur to me that 
there just might not be enough really old, really big repositories with lots of 
legacy identifiers in the ArchivesSpace community for the parsing of legacy 
numbers to be a common problem. I appreciate the recognition that a plug-in 
might be needed instead, but it would be worth hearing from any repositories 
with similar issues.

 • Container and location profiles by repository
   We were envisioning a one-to-one profile-to-repository scenario. Due to 
the ArchivesSpace staff user interface requirement that one identify only a 
single repository at login, it is extremely easy for users to forget the impact 
they might have beyond their repository if they change or delete a shared 
record.  We have already experienced mistaken mergers and deletions of agents 
due to the design of AS staff user interface that does not allow one to see 
where the record may be linked beyond their repository.  For this reason, it is 
wise to be able to limit changes and deletions of location profiles and 
container profiles impact to the same chosen repository.

 • Inactive
 As Maureen wisely intuited, inactive locations are necessary to recording 
a complete location history.  However, there are additional use cases. When a 
repository is renovating, for example (as is happening now at the Schlesinger 
Library) the shelves in a location may be inactive for a time and become active 
again when the building re-opens.  Other scenarios include water intrusion or 
other occasions when a smaller sub-set of shelves may have to become inactive 
until repairs are completed and tested before the shelving can again come into 
use. Because inactive locations are to be eliminated by default from search 
results, we can prevent them from overwhelming staff members’ search results or 
sending staff to unusable locations.

 • Notes in containers and locations
 Notes are for dedicated shelving or rehousing issues.  Notes on containers 
may contain things like “Label falling off” “Acidic-needs replacing” “Acid box 
replaced with acid-free box 2017-06-08” “Not on shelf 2015-10-10”.  Notes on 
locations may contain things like “only use as last resort—overhead drip pan 
makes retrieval difficult” “reserved for outgoing transfers until 2019-01-01”.  
In locations especially, we would expect the reason for a location becoming 
inactive might be noted.  “Made inactive because next to heating duct—do not 
reactivate”.

 • Bibliographic record IDs in containers
 This data would allow for more sustainable interoperability between 
systems and more flexibility in workflows.
 Especially with medium-rare materials, the physical item’s location might 
need to be recorded before description is finalized, and if the description is 
to be created in foreign system and ingested to ArchivesSpace, hooking up the 
container and location will be problematic.  In this scenario, a resource with 
initial description in a bibliographic system could be placed on an archives’ 
shelf, and the description, once completed in the ILS, could be ingested via 
MARC XML ingest for example.  After the resource is ingested, the ILS 
bibliographic record number could be searched in the containers to link the 
container to the resource.
 When an ILS system migrates, it is unlikely that

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
> 
> ___
> 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_groupdata=02%7C01%7Cmark.custer%40yale.edu%7Cd55f220262e54e20a31d08d666b73440%7Cdd8cbebb21394df8b4114e3e87abeb5c%7C0%7C0%7C636809334381749996sdata=FBa4W1dVsGxlwaitvHe6GoMi6QEyN1UlPnXfBU62p1U%3Dreserved=0
>

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
> 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
> >

[Archivesspace_Users_Group] release candidate available - ArchivesSpace v2.5.2-RC1

2018-12-20 Thread Christine Di Bella 
Hello ArchivesSpace members,

The ArchivesSpace team is pleased to announce a release candidate, v2.5.2-RC1. 
You can download it at 
https://github.com/archivesspace/archivesspace/releases/tag/v2.5.2-RC1 or test 
it out without downloading at http://test.archivesspace.org/staff (username 
admin /password admin). We do encourage you to download and try it out with 
your own local setup and/or data if you can for the most accurate results.

This release candidate contains program-led and community pull requests that 
provide feature enhancements, bug fixes, infrastructure improvements, and 
documentation updates. A focus is continuing to improve accessibility of the 
public and staff interfaces. The release candidate also includes an enhanced 
agent merge function and more options for configuring OAI-PMH harvesting.

Thanks to the community members who made contributions to this release, 
including individual archives staff and developers, as well as our Development 
Prioritization sub-team, Technical Documentation sub-team, and Core Committers 
Group.

Recognizing that many people will be spending less time with their 
ArchivesSpaces for a bit, we'll be taking feedback on this release candidate 
through Friday, January 4. Please let us know at archivesspaceh...@lyrasis.org 
if you notice any problems with the specific areas addressed in this release, 
or if anything that was working before no longer is. Barring major issues, we 
expect to release v2.5.2 in early January.

Christine

Christine Di Bella
ArchivesSpace Program Manager
christine.dibe...@lyrasis.org
800.999.8558 x2905
678-235-2905
cdibella13 (Skype)

[ASpaceOrgHomeMedium]

___
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 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
> 
> ___
> 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
>

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



From: 
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]
 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>>
 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


--
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

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
> 
>
>
>
>
> --
>
> 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>>
 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

[Archivesspace_Users_Group] Problems with Accessions CSV upload

2018-12-20 Thread Caitlin Wells 
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