<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>FYI, the cause of this has been traced to a problem when
upgrading from an old version of MySQL to a newer version of
MariaDB. If anyone gets "Incorrect datetime value" messages (or
"translation missing" errors including "incorrect_datetime_value"
in the staff interface) then one thing to check for is whether...<br>
</p>
<p>SHOW CREATE TABLE tablename;</p>
<p>...returns a statement including...<br>
</p>
<p>/* mariadb-5.3 */</p>
<p>...in the datetime fields.<br>
</p>
<p>If so, there is an explanation and methods for fixing it here:</p>
<p><a class="moz-txt-link-freetext" href="https://mariadb.com/kb/en/datetime/#internal-format">https://mariadb.com/kb/en/datetime/#internal-format</a><br>
</p>
<p>Andrew.</p>
<p><br>
</p>
<p></p>
<div class="moz-cite-prefix">On 18/07/2023 09:14, Becky Gainsford
wrote:<br>
</div>
<blockquote type="cite" cite="mid:LO0P265MB4975C3B8CDE86ACBB21CC6D1EC38A@LO0P265MB4975.GBRP265.PROD.OUTLOOK.COM">
<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-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;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}p.xmsonormal, li.xmsonormal, div.xmsonormal
{mso-style-name:x_msonormal;
margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}p.xmsochpdefault, li.xmsochpdefault, div.xmsochpdefault
{mso-style-name:x_msochpdefault;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}span.xmsohyperlink
{mso-style-name:x_msohyperlink;
color:#0563C1;
text-decoration:underline;}span.xmsohyperlinkfollowed
{mso-style-name:x_msohyperlinkfollowed;
color:#954F72;
text-decoration:underline;}span.xemailstyle17
{mso-style-name:x_emailstyle17;
font-family:"Calibri",sans-serif;
color:windowtext;}span.EmailStyle26
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}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]-->
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hi
Kendall, thanks for the help, much appreciated. This is a
very strange error. We have another instance of
ArchivesSpace running v3.4.0 and importing the same file
works successfully there. The initial file that uncovered
this error was quite a complex import with hundreds of rows
of data. So I also assumed I must have some bad
data/incorrect date format or something similar. So I
created a test file, using a newly downloaded bulk import
template and have only 3 lines in it, a file, a folder and
an item. The dates I’ve used are super simple ( 1900 and
1901 ) so I don’t think it is that. We have tried a server
re-boot but the error persists.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Thanks
again for helping.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><b><span style="color:#1F497D">Becky
Gainsford<o:p></o:p></span></b></p>
<p class="MsoNormal"><span style="color:#1F497D">Project
Archivist (Metadata Support)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Special
Collections<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Bodleian
Libraries<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:red">Working days -
Mon-Weds<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Tel: 01865
277131<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Post: The
Weston Library, Broad Street, Oxford, OX1 3BG<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Email: </span><a href="mailto:becky.gainsford@bodleian.ox.ac.uk" moz-do-not-send="true" class="moz-txt-link-freetext">becky.gainsford@bodleian.ox.ac.uk</a><span style="color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#1F497D">Web: </span><a href="http://www.bodleian.ox.ac.uk/weston" moz-do-not-send="true"><span style="color:blue">http://www.bodleian.ox.ac.uk/weston</span></a><o:p></o:p></p>
</div>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1
1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US">
<a class="moz-txt-link-abbreviated" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
<a class="moz-txt-link-rfc2396E" href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org"><archivesspace_users_group-bounces@lyralists.lyrasis.org></a>
<b>On Behalf Of </b>Kendall Aughenbaugh<br>
<b>Sent:</b> 17 July 2023 15:54<br>
<b>To:</b>
<a class="moz-txt-link-abbreviated" href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group]
[External Message] Error in Bulk Import<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Hi Becky, <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">I've run into some
weird issues with the bulk importer before. From what I
can tell, this looks like the issues start on Row 6 of
your sheet -- something has been entered incorrectly and
kept the archival object from being created. Since rows 7
and 8 are contingent on row 6 they're not being created
either. <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">IF I'm making it out
correctly (the screenshot is a bit fuzzy for me) the issue
is with the date/time formatting for one of your columns.
If you can't locate which cell is causing the issue, feel
free to share your data with me and I'll see if I can't
find it!<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Cheers, <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Kendall<o:p></o:p></span></p>
</div>
<div>
<div id="Signature">
<div>
<p class="MsoNormal"><br>
<strong><span style="font-family:"Calibri",sans-serif">Kendall
Aughenbaugh</span></strong>
<br>
Digital Services Archivist<br>
202.243.3912<br>
<a href="mailto:kaughenbaugh@hillwoodmuseum.org" moz-do-not-send="true" class="moz-txt-link-freetext">kaughenbaugh@hillwoodmuseum.org</a><br>
<br>
Hillwood Estate, Museum & Gardens<br>
4155 Linnean Ave NW<br>
Washington, DC 20008<br>
<a href="http://www.hillwoodmuseum.org/" moz-do-not-send="true">www.hillwoodmuseum.org</a><br>
<br>
Special Exhibition<br>
<a href="https://www.hillwoodmuseum.org/exhibitions" moz-do-not-send="true"><span style="color:blue;text-decoration:none"><img id="_x0000_i1025" src="https://hillwoodmuseum.org/sites/default/files/2023-06/Glassmail.png" alt="Special Exhibitions" moz-do-not-send="true" border="0"></span></a><br>
Through January 14, 2024<br>
<br>
Follow us on <a href="https://www.facebook.com/HillwoodMuseum" moz-do-not-send="true">Facebook</a> and <a href="https://www.facebook.com/HillwoodMuseum" moz-do-not-send="true">
Instagram</a><o:p></o:p></p>
</div>
</div>
</div>
<div class="MsoNormal" style="text-align:center" align="center">
<hr width="98%" size="2" align="center">
</div>
<div id="divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span style="color:black">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" moz-do-not-send="true" class="moz-txt-link-freetext">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>
<<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" moz-do-not-send="true" class="moz-txt-link-freetext">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
on behalf of Becky Gainsford <<a href="mailto:becky.gainsford@bodleian.ox.ac.uk" moz-do-not-send="true" class="moz-txt-link-freetext">becky.gainsford@bodleian.ox.ac.uk</a>><br>
<b>Sent:</b> Monday, July 17, 2023 4:56 AM<br>
<b>To:</b> <a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" moz-do-not-send="true" class="moz-txt-link-freetext">archivesspace_users_group@lyralists.lyrasis.org</a>
<<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" moz-do-not-send="true" class="moz-txt-link-freetext">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [External Message]
[Archivesspace_Users_Group] Error in Bulk Import</span>
<o:p></o:p></p>
<div>
<p class="MsoNormal"> <o:p></o:p></p>
</div>
</div>
<div>
<div>
<p class="xmsonormal">Hi all, I’m running the Bulk Import
process on v2.8.1 and am encountering this error, has
anyone seen this before or know what may be causing it?<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"><img style="width:9.8333in;height:2.7708in" id="x_Picture_x0020_1" src="cid:part1.HAjANvCd.2chi82h4@bodleian.ox.ac.uk" class="" width="944" height="266" border="0"><o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal">The file does validate successfully
and it is a very simple test file which I am using to try
to diagnose this problem. I’m using the Bulk import
template downloaded from
<a href="https://github.com/archivesspace/archivesspace/tree/master/templates" moz-do-not-send="true">archivesspace/templates at master
· archivesspace/archivesspace · GitHub</a><o:p></o:p></p>
<p class="xmsonormal">I have previously run many successful
Bulk imports using the same version of ArchivesSpace and
the same template so am feeling baffled. Thanks for any
help, hoping this is something very simple which someone
with more experience with ArchivesSpace will be able to
jump in and help with….<o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
<p class="xmsonormal"><img style="width:8.0833in;height:2.125in" id="x_Picture_x0020_2" src="cid:part2.qwb9O1lB.VoYG6oI3@bodleian.ox.ac.uk" class="" width="776" height="204" border="0"><o:p></o:p></p>
<p class="xmsonormal">Thanks,<o:p></o:p></p>
<p class="xmsonormal"><b><span style="color:#1F497D">Becky
Gainsford</span></b><o:p></o:p></p>
<p class="xmsonormal"><span style="color:#1F497D">Project
Archivist (Metadata Support)</span><o:p></o:p></p>
<p class="xmsonormal"><span style="color:#1F497D">Special
Collections</span><o:p></o:p></p>
<p class="xmsonormal"><span style="color:#1F497D">Bodleian
Libraries</span><o:p></o:p></p>
<p class="xmsonormal"><span style="color:red">Working days
- Mon-Weds</span><o:p></o:p></p>
<p class="xmsonormal"><span style="color:#1F497D">Tel: 01865
277131</span><o:p></o:p></p>
<p class="xmsonormal"><span style="color:#1F497D">Post: The
Weston Library, Broad Street, Oxford, OX1 3BG</span><o:p></o:p></p>
<p class="xmsonormal"><span style="color:#1F497D">Email: </span><a href="mailto:becky.gainsford@bodleian.ox.ac.uk" moz-do-not-send="true" class="moz-txt-link-freetext">becky.gainsford@bodleian.ox.ac.uk</a><o:p></o:p></p>
<p class="xmsonormal"><span style="color:#1F497D">Web: </span><a href="http://www.bodleian.ox.ac.uk/weston" moz-do-not-send="true"><span style="color:blue">http://www.bodleian.ox.ac.uk/weston</span></a><o:p></o:p></p>
<p class="xmsonormal"> <o:p></o:p></p>
</div>
</div>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Archivesspace_Users_Group mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org">Archivesspace_Users_Group@lyralists.lyrasis.org</a>
<a class="moz-txt-link-freetext" href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a>
</pre>
</blockquote>
</body>
</html>