Re: [Archivesspace_Users_Group] New School bulk update plugin error

2021-08-04 Thread McLaughlin, Brianna Jean
Thank you for the confirmation, Joshua!

Bri McLaughlin, she/her/hers
Visiting Metadata Services Librarian
Indiana University
812-856-3321

From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Joshua 
D. Shaw
Sent: Wednesday, August 4, 2021 4:54 PM
To: Archivesspace Users Group 
Subject: [External] Re: [Archivesspace_Users_Group] New School bulk update 
plugin error

This message was sent from a non-IU address. Please exercise caution when 
clicking links or opening attachments from external sources.

Looks like the migration that added that column came in 2.8.0. Though the bulk 
updater *might* work with 2.8.0 (I have not tested it), it definitely will 
*not* work with 2.7.1

Cheers,
Joshua


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 McLaughlin, Brianna Jean mailto:brijm...@iu.edu>>
Sent: Wednesday, August 4, 2021 4:21 PM
To: 
archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: [Archivesspace_Users_Group] New School bulk update plugin error


Hi everyone,



Has anyone tried to use the New School bulk updater plugin on AS versions 
before 2.8.1? We're on 2.7.1 and I got this error when I tried to use the 
plugin:

{"error":{"db_error":["Database integrity constraint conflict: 
Java::JavaSql::SQLSyntaxErrorException: Unknown column 
'sub_container.barcode_2' in 'field list'"]}}



The README says the plugin is compatible with 2.8.1, so we just may not have a 
compatible AS version. However, I'm trying to rule out other reasons I could 
have gotten this error. Relatedly, is there a sample spreadsheet someone could 
link?



Thanks!



Bri McLaughlin, she/her/hers

Visiting Metadata Services Librarian

Indiana University

812-856-3321


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


Re: [Archivesspace_Users_Group] New School bulk update plugin error

2021-08-04 Thread Joshua D. Shaw
Looks like the migration that added that column came in 2.8.0. Though the bulk 
updater *might* work with 2.8.0 (I have not tested it), it definitely will 
*not* work with 2.7.1

Cheers,
Joshua


From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 on behalf of 
McLaughlin, Brianna Jean 
Sent: Wednesday, August 4, 2021 4:21 PM
To: archivesspace_users_group@lyralists.lyrasis.org 

Subject: [Archivesspace_Users_Group] New School bulk update plugin error


Hi everyone,



Has anyone tried to use the New School bulk updater plugin on AS versions 
before 2.8.1? We’re on 2.7.1 and I got this error when I tried to use the 
plugin:

{"error":{"db_error":["Database integrity constraint conflict: 
Java::JavaSql::SQLSyntaxErrorException: Unknown column 
'sub_container.barcode_2' in 'field list'"]}}



The README says the plugin is compatible with 2.8.1, so we just may not have a 
compatible AS version. However, I’m trying to rule out other reasons I could 
have gotten this error. Relatedly, is there a sample spreadsheet someone could 
link?



Thanks!



Bri McLaughlin, she/her/hers

Visiting Metadata Services Librarian

Indiana University

812-856-3321


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


[Archivesspace_Users_Group] New School bulk update plugin error

2021-08-04 Thread McLaughlin, Brianna Jean
Hi everyone,

Has anyone tried to use the New School bulk updater plugin on AS versions 
before 2.8.1? We're on 2.7.1 and I got this error when I tried to use the 
plugin:
{"error":{"db_error":["Database integrity constraint conflict: 
Java::JavaSql::SQLSyntaxErrorException: Unknown column 
'sub_container.barcode_2' in 'field list'"]}}

The README says the plugin is compatible with 2.8.1, so we just may not have a 
compatible AS version. However, I'm trying to rule out other reasons I could 
have gotten this error. Relatedly, is there a sample spreadsheet someone could 
link?

Thanks!

Bri McLaughlin, she/her/hers
Visiting Metadata Services Librarian
Indiana University
812-856-3321

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