[Archivesspace_Users_Group] Import Error with Accessions Template

[Joshua D. Shaw]

Hi Amy

If I'm reading that error log correctly, it looks like some bit of data in that csv is not valid UTF-8.

Best,
Joshua

________________________________
From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of Moorman, Amy <Amy.Moorman at avila.edu>
Sent: Thursday, March 16, 2023 11:43 AM
To: archivesspace_users_group at lyralists.lyrasis.org <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [Archivesspace_Users_Group] Import Error with Accessions Template

You don't often get email from amy.moorman at avila.edu. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>

Hello,



I have been attempting to upload a .csv file using the accessions template for *weeks* and I keep receiving an error message that I cannot parse. We have rebooted our server and I have fixed all the data errors I can see that might have caused the issue. I even rekeyed the entire spreadsheet into a new file but I am still receiving the Import Error (see text below). Another template file with different data uploaded with no error during this same time period.



Can anyone help me figure out what this error is indicating? Thank you!



Trace:["org/jruby/RubyString.java:2898:in `sub!'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/csv.rb:1833:in `block in shift'", "org/jruby/RubyKernel.java:1442:in `loop'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/csv.rb:1821:in `shift'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/csv.rb:1764:in `each'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/converters/lib/csv_converter.rb:52:in `block in run'", "uri:classloader:/META-INF/jruby.home/lib/ruby/stdlib/csv.rb:1289:in `open'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/converters/lib/csv_converter.rb:51:in `run'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:44:in `block in run'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/lib/request_context.rb:24:in `open'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:40:in `block in run'", "org/jruby/RubyArray.java:1821:in `each'", "org/jruby/RubyEnumerable.java:1258:in `each_with_index'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:36:in `block in run'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/model/db.rb:210:in `block in open'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/model/db.rb:101:in `block in transaction'", "C:/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:204:in `_transaction'", "C:/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:179:in `block in transaction'", "C:/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/connection_pool/threaded.rb:91:in `hold'", "C:/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/connecting.rb:270:in `synchronize'", "C:/archivesspace/gems/gems/sequel-5.9.0/lib/sequel/database/transactions.rb:145:in `transaction'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/model/db.rb:100:in `transaction'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/model/db.rb:207:in `block in open'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/model/db.rb:204:in `open'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/model/db.rb:542:in `block in DB'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/lib/job_runners/batch_import_runner.rb:32:in `run'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/lib/background_job_queue.rb:126:in `run_pending_job'", "C:/archivesspace/data/tmp/jetty-0_0_0_0-8089-backend_war-_-any-2728129299283477699/webapp/WEB-INF/app/lib/background_job_queue.rb:169:in `block in start_background_thread'"]

Errors: #<ArgumentError: invalid byte sequence in UTF-8>







Regards,

Amy Moorman, Archivist

Avila University
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230316/841183cc/attachment.html>