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

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,

[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

[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

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

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

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 <

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

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

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

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