<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
What Valerie said as well!</div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font style="font-size: 11pt; color: rgb(0, 0, 0);" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on
behalf of Joshua D. Shaw <Joshua.D.Shaw@dartmouth.edu><br>
<b>Sent:</b> Thursday, March 16, 2023 12:15 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Import Error with Accessions Template</font>
<div> </div>
</div>
<div dir="ltr">
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
Hi Amy</div>
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
<br>
</div>
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
If I'm reading that error log correctly, it looks like some bit of data in that csv is not valid UTF-8.</div>
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
<br>
</div>
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
Best,</div>
<div class="x_elementToProof" style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0); background-color:rgb(255,255,255)">
Joshua<br>
</div>
<div id="x_appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="x_divRplyFwdMsg" dir="ltr"><font style="font-size:11pt; color:rgb(0,0,0)" face="Calibri, sans-serif" color="#000000"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf
of Moorman, Amy <Amy.Moorman@avila.edu><br>
<b>Sent:</b> Thursday, March 16, 2023 11:43 AM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> [Archivesspace_Users_Group] Import Error with Accessions Template</font>
<div> </div>
</div>
<div lang="EN-US">
<table style="border:0; display:table; width:100%; table-layout:fixed; border-collapse:seperate; float:none" width="100%" cellspacing="0" cellpadding="0" border="0" align="left">
<tbody style="display:block">
<tr>
<td cellpadding="7px 2px 7px 2px" style="padding:7px 2px 7px 2px; background-color:#A6A6A6" width="1px" valign="middle" bgcolor="#A6A6A6">
</td>
<td cellpadding="7px 5px 7px 15px" color="#212121" style="width:100%; background-color:#EAEAEA; padding:7px 5px 7px 15px; font-family:wf_segoe-ui_normal,Segoe UI,Segoe WP,Tahoma,Arial,sans-serif; font-size:12px; font-weight:normal; color:#212121; text-align:left; word-wrap:break-word" width="100%" valign="middle" bgcolor="#EAEAEA">
<div>You don't often get email from amy.moorman@avila.edu. <a href="https://aka.ms/LearnAboutSenderIdentification" data-auth="NotApplicable" data-loopstyle="link">
Learn why this is important</a></div>
</td>
<td cellpadding="7px 5px 7px 5px" color="#212121" style="width:75px; background-color:#EAEAEA; padding:7px 5px 7px 5px; font-family:wf_segoe-ui_normal,Segoe UI,Segoe WP,Tahoma,Arial,sans-serif; font-size:12px; font-weight:normal; color:#212121; text-align:left; word-wrap:break-word" width="75px" valign="middle" bgcolor="#EAEAEA" align="left">
</td>
</tr>
</tbody>
</table>
<div>
<div class="x_x_WordSection1">
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
Hello,</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
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.</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
Can anyone help me figure out what this error is indicating? Thank you!</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
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'"]</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
Errors: #<ArgumentError: invalid byte sequence in UTF-8></p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
Regards,</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
Amy Moorman, Archivist</p>
<p class="x_x_MsoNormal" style="margin-top: 0px; margin-bottom: 0px;margin:0in 0in 0.0001pt; font-size:11pt; font-family:"Calibri",sans-serif">
Avila University</p>
</div>
</div>
</div>
</div>
</body>
</html>