<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)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* 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.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",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">Hi Mary,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for the advice! Unfortunately, I have already tried all these steps and am having the same problem. When I change the format to text or general, it switches back to the date format once I typed in the date. When I chose the yyyy-mm-dd
option under “type,” it reverts to dd/mm/yyyy once I close the template to upload it. The details are in my previous email. I’m going to keep fiddling with it! We don’t have that many with single dates so I might also just give up and add the single dates
manually. Thanks. <o:p></o:p></p>
<p class="MsoNormal">Best,<o:p></o:p></p>
<p class="MsoNormal">Sarah<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<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: sshepherd@srmml.org<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>
</div>
<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><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>Mary Mellon<br>
<b>Sent:</b> Thursday, May 4, 2023 11:54 AM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] [External] 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 style="margin:0in"><strong><span style="font-size:11.5pt;font-family:"Calibri",sans-serif;color:#E25041;background:#F7DA64"> CAUTION:</span></strong><span style="font-size:11.5pt;color:#E25041;background:#F7DA64"> </span><span style="font-size:11.5pt;color:black;background:#F7DA64">This
email originated outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. </span><span style="font-size:11.5pt"><o:p></o:p></span></p>
<div>
<p class="MsoNormal">Hi Sarah,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If you aren’t copying and pasting into the template-<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">For existing data in your spreadsheet, you could try selecting the cells with mis-formatted dates, right click, and select “Format Cells.” Under the “Numbers” tab, select the category “Date”, and choose the yyyy-mm-dd option under “Type.”<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Or if you are entering new data, you could just select the column and change its data type to “text” before entering your dates. They shouldn’t autoformat after that.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-ligatures:none"><img width="559" height="608" style="width:5.8229in;height:6.3333in" id="Picture_x0020_1" src="cid:image001.png@01D97E9C.44F40120"></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Best,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Mary<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#1F4E79;mso-ligatures:none">Mary Mellon (she/her)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F4E79;mso-ligatures:none">Metadata Archivist<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F4E79;mso-ligatures:none">Rubenstein Rare Book and Manuscript Library<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F4E79;mso-ligatures:none">Duke University<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F4E79;mso-ligatures:none"><a href="mailto:mary.mellon@duke.edu">mary.mellon@duke.edu</a><o:p></o:p></span></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>
<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">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Bowers, Kate A.<br>
<b>Sent:</b> Tuesday, May 2, 2023 12:16 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] [External] 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">I suspect that you are opening the template in MS Excel and then pasting. Is that correct?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If so, one work-around is to use the text import wizard in Excel, which allows you to format the data as it goes into the cells. I generally just make all data I paste into Excel “text” so that Excel won’t commit data horrors.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Before you start using the text import wizard, you need to enable it.
<o:p></o:p></p>
<p class="MsoNormal"><a href="https://urldefense.com/v3/__https:/support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857*ID0EBBJ=Newer_versions__;Iw!!OToaGQ!r7PCl_RFoIDRI-KZBsTr5c60tFxpH_JZP90ufihUtbAaLTfZfbCM2Mj7QKkdnE1aYVLAcZsdGv21qapS1WBJGsyP_-6A$">https://support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857#ID0EBBJ=Newer_versions</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Once you have enabled it, you should get the option to use it when you click on the down arrow (I’ve circled it in orange here) beneath the “paste” button in Excel.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-ligatures:none"><img border="0" width="176" height="200" style="width:1.8333in;height:2.0833in" id="Picture_x0020_2" src="cid:image002.jpg@01D97E9C.44F40120"></span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Please let me know if this helps! <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Kate<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><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>McLaughlin, Brianna Jean<br>
<b>Sent:</b> Tuesday, May 2, 2023 11:18 AM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] [External] 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">Hi Sarah,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I think you may be encountering similar issues that I ran into with the accession csv template. I don’t have the process I used written out in a way that’s decipherable by anyone but me, but my colleague, Jeremy, and I talked about the
errors I ran into with dates during this year’s ArchivesSpace Member Forum. The Youtube video is here:
<a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_watch-3Fv-3DXRAUu58-2DLgs-26t-3D980s&d=DwMFAg&c=WO-RGvefibhHBZq3fL85hQ&r=wwc_Z_TbmWbPFh7My2zRxmrGgCNO-71Fwzlmd8YZVUY&m=DRBsnG4ApmYGRxyNLUjaOhfOE2CHTIwktuM5Zw4c_ZjEwbgKTNeCvJ7ACCs-kXUv&s=gtC_DVg69q3wvWNgmx2kOW7FF963aS-_HLkPkpxnsPo&e=">
https://www.youtube.com/watch?v=XRAUu58-Lgs&t=980s</a>. The information between 11:46-18:23 is probably most relevant to you.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">It feels weird to direct you to my own presentation, but I hope it’s helpful! Feel free to follow up with me if you have questions.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="mso-ligatures:none">Bri McLaughlin, she/her/hers<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:none">Digital Collections Librarian<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:none">Indiana University <o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:none">812-856-3321<o:p></o:p></span></p>
</div>
<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><span style="mso-ligatures:none">From:</span></b><span style="mso-ligatures:none">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Sarah Shepherd<br>
<b>Sent:</b> Tuesday, May 2, 2023 9:10 AM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> [External] [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>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" align="left" width="100%" style="width:100.0%">
<tbody>
<tr>
<td style="background:#A6A6A6;padding:5.25pt 1.5pt 5.25pt 1.5pt"></td>
<td width="100%" style="width:100.0%;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 11.25pt">
<div>
<p class="MsoNormal" style="mso-element:frame;mso-element-frame-hspace:2.25pt;mso-element-wrap:around;mso-element-anchor-vertical:paragraph;mso-element-anchor-horizontal:column;mso-height-rule:exactly">
<span style="font-size:9.0pt;font-family:"Segoe UI",sans-serif;color:#212121;mso-ligatures:none">You don't often get email from
<a href="mailto:sshepherd@srmml.org">sshepherd@srmml.org</a>. <a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__aka.ms_LearnAboutSenderIdentification&d=DwMFAg&c=WO-RGvefibhHBZq3fL85hQ&r=wwc_Z_TbmWbPFh7My2zRxmrGgCNO-71Fwzlmd8YZVUY&m=DRBsnG4ApmYGRxyNLUjaOhfOE2CHTIwktuM5Zw4c_ZjEwbgKTNeCvJ7ACCs-kXUv&s=l8skQdETjlyGUSzlosnz8etszW6mEBohTsuyYzNtuwE&e=">
Learn why this is important</a><o:p></o:p></span></p>
</div>
</td>
<td width="75" style="width:56.25pt;background:#EAEAEA;padding:5.25pt 3.75pt 5.25pt 3.75pt;align:left">
</td>
</tr>
</tbody>
</table>
<div>
<p class="MsoNormal" style="background:#FFECE5"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#82270D;mso-ligatures:none">This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from
external sources.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:none"><o:p> </o:p></span></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>
</div>
</div>
</body>
</html>