<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hello! This is a quick note. Try saving your spreadsheet as a
<b>CSV UTF-8</b> 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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Moorman, Amy<br>
<b>Sent:</b> Thursday, March 16, 2023 11:44 AM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] Import Error with Accessions Template<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hello,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have been attempting to upload a .csv file using the accessions template for *<b>weeks</b>* 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.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Can anyone help me figure out what this error is indicating? Thank you!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">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'"]<o:p></o:p></p>
<p class="MsoNormal">Errors: #<ArgumentError: invalid byte sequence in UTF-8><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Regards,<o:p></o:p></p>
<p class="MsoNormal">Amy Moorman, Archivist<o:p></o:p></p>
<p class="MsoNormal">Avila University<o:p></o:p></p>
</div>
</body>
</html>