[Archivesspace_Users_Group] Import Error with Accessions Template

[Valerie Addonizio]

Hello! This is a quick note. Try saving your spreadsheet as a CSV UTF-8 file, using Excel. That should be available in the drop-down menu when you Save As This should strip all non-UTF8 encoding. If it fails again, try restarting ASpace and then try the upload again.

From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Moorman, Amy
Sent: Thursday, March 16, 2023 11:44 AM
To: archivesspace_users_group at lyralists.lyrasis.org
Subject: [Archivesspace_Users_Group] Import Error with Accessions Template

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/c3513490/attachment.html>