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-boun...@lyralists.lyrasis.org <archivesspace_users_group-boun...@lyralists.lyrasis.org> On Behalf Of Moorman, Amy Sent: Thursday, March 16, 2023 11:44 AM To: archivesspace_users_group@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
_______________________________________________ Archivesspace_Users_Group mailing list Archivesspace_Users_Group@lyralists.lyrasis.org http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
