[Archivesspace_Users_Group] Issues with spreadsheet load

[Tom Hanstra]

Thanks, all, for the confirmation that this is happening so regularly
elsewhere. That helps.

Valerie: I think your suggestion of loading CSV seems like a good one. In
my testing, the same data which had problems as an xslx file worked fine as
csv. I've suggested that to our group here and will follow up with them to
see if that helps get things working better.

Hopefully this will be able to be fixed in upcoming versions.

Tom

On Tue, Nov 30, 2021 at 12:45 PM Christine Di Bella <
christine.dibella at lyrasis.org> wrote:

> 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
>
> 800.999.8558 x2905
>
> 678-235-2905
>
>
>
>
>
> [image: 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 <
> 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>
> *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 <
> 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>
> *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
>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
>


-- 
*Tom Hanstra*
*Sr. Systems Administrator*
hanstra at nd.edu
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20211130/356fd4d1/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 13904 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20211130/356fd4d1/attachment.jpg>