<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;}
@font-face
{font-family:"Arial Nova Light";}
@font-face
{font-family:Times;
panose-1:2 2 6 3 5 4 5 2 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Arial Nova Light",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@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"><span style="font-size:12.0pt;font-family:"Arial Nova Light",sans-serif">I’ve been copying and pasting a lot between Word and Excel this week, so I know your pain. My inefficient solution to this issue for me has been adding an extra character
to the beginning of the date string and then using the RIGHT() function to pull the date without the beginning character and use paste value to replace the cell. So far, it’s working and takes a little less time than retyping everything.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial Nova Light",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial Nova Light",sans-serif">I hope this helps,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial Nova Light",sans-serif"><o:p> </o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="background:white"><span style="font-size:12.0pt;font-family:"Times",serif;color:#442D7D;mso-ligatures:none">~Heidi</span><span style="color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="color:#201F1E;mso-ligatures:none"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#442D7D;mso-ligatures:none">HEIDI PETTITT</span></b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#442D7D;mso-ligatures:none"> (she/her)</span><span style="color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#442D7D;mso-ligatures:none">Director of the Center for Dubuque History</span><span style="font-size:10.0pt;color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#442D7D;mso-ligatures:none">Access Services & Special Collections Librarian</span><span style="color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="color:#201F1E;mso-ligatures:none"><o:p> </o:p></span></p>
<p class="MsoNormal" style="background:white"><b><span style="font-size:12.0pt;font-family:"Arial",sans-serif;color:#D1B888;mso-ligatures:none">LORAS COLLEGE</span></b><span style="color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#442D7D;mso-ligatures:none">Library & Center for Dubuque History</span><span style="font-size:10.0pt;color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#442D7D;mso-ligatures:none">Miller Academic Resource Center 154</span><span style="font-size:10.0pt;color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#442D7D;mso-ligatures:none">1450 Alta Vista</span><span style="font-size:10.0pt;color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#442D7D;mso-ligatures:none">Dubuque, IA 52001</span><span style="font-size:10.0pt;color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Times New Roman",serif;color:#442D7D;mso-ligatures:none">563-588-7873</span><span style="font-size:10.0pt;color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;font-family:"Times New Roman",serif;color:#201F1E;mso-ligatures:none"><a href="https://loras.libcal.com/appointments" target="_blank">Meet With Me!</a></span><span style="font-size:10.0pt;color:#201F1E;mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal" style="background:white"><span style="font-size:10.0pt;color:#201F1E;mso-ligatures:none"><a href="http://library.loras.edu/" target="_blank"><span style="font-family:"Times New Roman",serif">http://library.loras.edu/</span></a><o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span style="font-size:12.0pt;font-family:"Arial Nova Light",sans-serif"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Sarah Shepherd<br>
<b>Sent:</b> Tuesday, May 2, 2023 8:10 AM<br>
<b>To:</b> archivesspace_users_group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] Auto formatting with dates on Accession CSV import template<o:p></o:p></span></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’m having some difficulty with the Accession CSV template autoformatting my dates into the incorrect format for ArchivesSpace. It is only a problem with a single date. For example, I will put in 1920-04-29 which is the proper ArchivesSpace
format for date_1_begin. The Accession CSV template then autocorrects it to be 4/29/1920 turning the cell format into a Date format instead of the standard General format. When I switch the cell format back to General it turns the number into 7425. When I
put the correct date (1920-04-29) back in, it again auto formats the cell to a Date format, so it goes back to 4/29/1920. Bizarrely, it does not do the same for another record which has 1865-11-27 as date_1_begin.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I tried to look up how to stop this auto formatting but have not found anything. I even tried setting the date format to English (South Africa) which has a date format of 1920-04-29, but when I save the document, it got rid of all the formatting
and reverts to 4/29/1920. I have tried importing the template without saving so that it keeps the 1920-04-29 date format (set to the English (South Africa)) and it gives an error (#<ArgumentError: invalid byte sequence in UTF-8>) which I saw on a different
post meant that there is incorrect formatting on the template. It goes without saying that when I tried to import the template with the date as 4/29/1920, it also did not work (though interestingly, returning the same error (#<ArgumentError: invalid byte
sequence in UTF-8>) instead of an incorrect date error).<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">In another weird twist, the template does not get the (#<ArgumentError: invalid byte sequence in UTF-8>) when accession_accession_date autoformats its cell to date and ArchivesSpace can also deal with the import just fine with the
incorrect date format of 3/29/2023 turning it into 2023/03/29 in the record in ArchivesSpace. Why the difference?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">That was a lot of information, but as you can see, I’ve done some troubleshooting to try to figure out the issue and have only become more confused!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Has anyone else run into this issue with single dates? Are there any work arounds besides giving up on single dates when importing?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Grateful for any help,<o:p></o:p></p>
<p class="MsoNormal">Sarah<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-ligatures:none">Sarah H. Shepherd<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:none">(she/her/hers)<br>
Archivist<br>
Scottish Rite Masonic Museum and Library<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="mso-ligatures:none">33 Marrett Road | Lexington, MA 02421
<o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="mso-ligatures:none">Phone: 781-457-4129 | Email:
<a href="mailto:sshepherd@srmml.org">sshepherd@srmml.org</a><o:p></o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="font-size:12.0pt;mso-ligatures:none"><o:p> </o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
CONFIDENTIALITY NOTICE: This email, including any attachments, is the property of Loras College. The information may be legally privileged and/or confidential and is intended solely for the use of the addressee. If you are not the intended recipient be advised
that any unauthorized disclosure, copying, distribution or use of the contents herein is strictly prohibited. If you have received this message in error, please notify the sender immediately and destroy all electronic and hard copies of the communication,
including attachments.
</body>
</html>