[Archivesspace_Users_Group] Issues with spreadsheet load

[Christine Di Bella]

Hi everyone,

In addition to this discussion, please feel free to add comments to the existing JIRA for this issue. It’s a hard one to search for because of the usual challenges of natural language, but it’s at https://archivesspace.atlassian.net/browse/ANW-1427.

Christine

Christine Di Bella
ArchivesSpace Program Manager
christine.dibella at lyrasis.org<mailto:christine.dibella at lyrasis.org>
800.999.8558 x2905
678-235-2905


[ASpaceOrgHomeMedium]



From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Valerie Addonizio
Sent: Tuesday, November 30, 2021 11:44 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: Re: [Archivesspace_Users_Group] Issues with spreadsheet load

I have also encountered this issue, and want to suggest, purely as a means of troubleshooting, to try and upload the same data using the CSV version of the spreadsheet<https://github.com/archivesspace/archivesspace/tree/master/templates>, and specifically Save As-ing as an UTF-8 CSV using Excel. We were never able to definitively determine if this made a difference, but it’s something I wanted to share as an idea on the path to troubleshooting. If you choose to try the CSV route, there are some quirks. One is that any Publish value that you have set to TRUE or FALSE in the xlsx version needs to be submitted as a 1 or 0 respectively in the CSV version.

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 Noah Huffman
Sent: Tuesday, November 30, 2021 11:24 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] Issues with spreadsheet load

Hi Tom,

We have been experiencing this same issue for a while on our production v2.8.1 instance and on a test version of v3.1.0.

If we attempt to load a spreadsheet that does not validate it not only fails, but essentially wrecks the importer for all future imports, even spreadsheets that are properly formatted. Any subsequent import attempt will return a server error in the UI. I’m also seeing the same error you reported in my log file.

The only fix we have found is to restart the application.

I thought I had submitted a bug report for this, but I’ll double-check now.

-Noah

================
Noah Huffman
Archivist for Metadata, Systems, and Digital Records
David M. Rubenstein Rare Book & Manuscript Library
Duke University | 919-660-5982
http://library.duke.edu/rubenstein/
Pronouns: he / him / his

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 Tom Hanstra
Sent: Tuesday, November 30, 2021 11:08 AM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: [Archivesspace_Users_Group] Issues with spreadsheet load

I'm trying to track down some issues we are having with the load of a spreadsheet. I'm wondering if I have some database corruption behind the scenes or just have some bad spreadsheet info.

We are running ArchivesSpace v 2.8.1. When trying to load the spreadsheet, we consistently get the error in the background log of:

E, [2021-11-30T10:59:08.769519 #7965] ERROR -- : Thread-3238: Unhandled exception!
E, [2021-11-30T10:59:08.770805 #7965] ERROR -- :
invalid byte sequence in UTF-8

I got this error just with the Only Validate option chosen, but I don't know enough about what Only validate does.

We've also now gotten this with a couple of different spreadsheets against a few different records. We have not found a spreadsheet that will work as things currently stand.

How can I best track down where the issue lies. Might I have an issue with the database? Or just bad data somewhere in this spreadsheet? Is there a way to validate an archivesspace database?

Thanks,
Tom

--
Tom Hanstra
Sr. Systems Administrator
hanstra at nd.edu<mailto:hanstra at nd.edu>

[https://docs.google.com/uc?export=download&id=1GFX1KaaMTtQ2Kg2u8bMXt1YwBp96bvf0&revid=0B7APN9POn6xAQ244WWFYMFU3aVJwZ0lxbmVHK3FxNXlCd0RRPQ]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20211130/84403c20/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 13904 bytes
Desc: image001.jpg
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20211130/84403c20/attachment.jpg>