<div dir="ltr"><div>Hi VivianLea,</div><div><br></div><div>Ah, thanks, that is good to know. I thought I had set the date fields to TEXT suspecting that the format could get wonky, but looking back at my spreadsheet I see that they somehow converted themselves back to DATE format again!</div><div><br></div><div>Best,</div><div>John<br></div><div><br></div><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr">-----<br>
John Anderies (he/him), Director<br>
John J. Wilcox, Jr. Archives and Library<br>
William Way LGBT Community Center</div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jul 25, 2023 at 12:09 PM Solek, VivianLea <<a href="mailto:VivianLea.Solek@kofc.org">VivianLea.Solek@kofc.org</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg-2072254162615167257">
<div style="overflow-wrap: break-word;" lang="EN-US">
<div class="m_-2072254162615167257WordSection1">
<p class="MsoNormal">Hi John,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I found that if you turn the fields into a text field, you do not get the time stamp after it. I do not know if that causes any other issues (we’ll see if any of the ASpace staff weigh in), but I hated the look of the timestamp too.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">One thing to watch for….if there are true dates already in the field, converting them to text will often mess up the date. I copy the column, turn the new column into a text field and then go down and correct those dates that have changed.
It’s a bit more work, but is so worth it for me.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Hope that fix helps you out.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">All the best,<u></u><u></u></p>
<p class="MsoNormal">VivianLea<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal"><span style="color:black">VivianLea Solek<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black">Archivist<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black">Knights of Columbus Supreme Council Archives<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black"><br>
1 State Street<br>
New Haven, CT 06511-6702<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:black">Phone 203 752-4578<br>
Fax 203 865-0351</span><u></u><u></u></p>
<p class="MsoNormal"><img style="width: 3.2222in; height: 1.5in;" id="m_-2072254162615167257Picture_x0020_1" src="cid:1898de42aa34cff311" width="309" height="144"><u></u><u></u></p>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div style="border-color:rgb(225,225,225) currentcolor currentcolor;border-style:solid none none;border-width:1pt medium medium;padding:3pt 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>John F. Anderies<br>
<b>Sent:</b> Tuesday, July 25, 2023 11:39 AM<br>
<b>To:</b> <a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> [Archivesspace_Users_Group] Time markings in date fields from bulk import spreadsheet<u></u><u></u></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<table style="width:100%" width="100%" cellspacing="0" cellpadding="0" border="0" align="left">
<tbody>
<tr>
<td style="background:rgb(255,185,0);padding:5pt 2pt"></td>
<td style="width:100%;background:rgb(255,248,229);padding:5pt 4pt 5pt 12pt" width="100%">
<div>
<p class="MsoNormal">
<b><span style="color:rgb(34,34,34)">Caution:</span></b><span style="color:rgb(34,34,34)"> This email originated outside of the Knights of Columbus. Do not click links or open attachments unless you recognize the sender and know the content is safe.
<u></u><u></u></span></p>
</div>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<div>
<p class="MsoNormal">Apologies if this has been asked and answered before. <u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></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.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></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.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">With thanks,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">John<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></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<u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
CONFIDENTIALITY NOTICE: This message and any attachments may contain confidential, proprietary or legally privileged information and is intended only for the use of the addressee or addressees named above for its intended purpose. If you are not the intended
recipient of this message, this message constitutes notice that any review, retransmission, distribution, copying or other use or taking any action in reliance on the information in this message and its attachments, is prohibited. If you receive this communication
in error, please immediately advise the sender by reply e-mail and delete this message and its attachments from your system without keeping a copy. Unless expressly stated in this e-mail, nothing in this message may be construed as a digital or electronic
signature. Thank you.
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</div></blockquote></div>