<html 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=utf-8">
<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.EmailStyle21
{mso-style-type:personal-compose;
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>
</head>
<body lang="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Hi John,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I had a lot of difficulties with the dates in the bulk import with Excel auto correcting the format of the cells. Are you opening the bulk import template with Excel? You can try to switch the cell format to the proper format without the
time data in Excel, but I had such a rough time with Excel that I switched to using LibreOffice’s version of Excel (after a recommendation from this listserv) and it solved basically all my annoying formatting problems with the bulk import. I’m now a LibreOffice
convert! I hope that helps.<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">Sarah<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Sarah H. Shepherd<o:p></o:p></p>
<p class="MsoNormal">(she/her/hers)<br>
Archivist<br>
Scottish Rite Masonic Museum and Library<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">33 Marrett Road | Lexington, MA 02421
<o:p></o:p></p>
<p class="MsoNormal" style="margin-bottom:12.0pt">Phone: 781-457-4129 | Email: <a href="mailto:sshepherd@srmml.org">
<span style="color:#0563C1">sshepherd@srmml.org</span></a><o:p></o:p></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>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>John F. Anderies<br>
<b>Sent:</b> Tuesday, July 25, 2023 11:39 AM<br>
<b>To:</b> Archivesspace_Users_Group@lyralists.lyrasis.org<br>
<b>Subject:</b> [Archivesspace_Users_Group] Time markings in date fields from bulk import spreadsheet<o:p></o:p></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>
<div>
<div>
<p class="MsoNormal">Apologies if this has been asked and answered before. <o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">I'm using the bulk import template to import a container inventory into a resource record in ASpace. This is the first time that I have used dates in the spreadsheet that include year, month and date (in the form of YYYY-MM-DD), as opposed
to just year.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Once the import is completed, I find that the date fields are rendered with T00:00:00+00:00 following the correctly imported YYYY-MM-DD characters. Is it possible I am doing something wrong in how I'm rendering the dates in the spreadsheet
or is there a way to prevent what I presume is time related data from being included? I can edit these out directly in ASpace, but it's a time consuming process that defeats the purpose of using the spreadsheet to import data.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">With thanks,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">John<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal">-----<br>
John Anderies (he/him), Director<br>
John J. Wilcox, Jr. Archives and Library<br>
William Way LGBT Community Center<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>