[Archivesspace_Users_Group] New School bulk update plugin error

[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-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Joshua D. Shaw
Sent: Wednesday, August 4, 2021 4:54 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
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-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> on behalf of McLaughlin, Brianna Jean <brijmcla at iu.edu<mailto:brijmcla at iu.edu>>
Sent: Wednesday, August 4, 2021 4:21 PM
To: archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org> <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at 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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20210804/6ac6fb7d/attachment.html>