[Archivesspace_Users_Group] [External Message] Error in Bulk Import

[Andrew Morrison]

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...

SHOW CREATE TABLE tablename;

...returns a statement including...

/* mariadb-5.3 */

...in the datetime fields.

If so, there is an explanation and methods for fixing it here:

https://mariadb.com/kb/en/datetime/#internal-format

Andrew.


On 18/07/2023 09:14, Becky Gainsford wrote:
>
> 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.
>
> Thanks again for helping.
>
> *Becky Gainsford*
>
> Project Archivist (Metadata Support)
>
> Special Collections
>
> Bodleian Libraries
>
> Working days  - Mon-Weds
>
> Tel: 01865 277131
>
> Post: The Weston Library, Broad Street, Oxford, OX1 3BG
>
> Email: becky.gainsford at bodleian.ox.ac.uk
>
> Web: http://www.bodleian.ox.ac.uk/weston 
> <http://www.bodleian.ox.ac.uk/weston>
>
> *From:*archivesspace_users_group-bounces at lyralists.lyrasis.org 
> <archivesspace_users_group-bounces at lyralists.lyrasis.org> *On Behalf 
> Of *Kendall Aughenbaugh
> *Sent:* 17 July 2023 15:54
> *To:* archivesspace_users_group at lyralists.lyrasis.org
> *Subject:* Re: [Archivesspace_Users_Group] [External Message] Error in 
> Bulk Import
>
> Hi Becky,
>
> 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.
>
> 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!
>
> Cheers,
>
> Kendall
>
>
> *Kendall Aughenbaugh*
> Digital Services Archivist
> 202.243.3912
> kaughenbaugh at hillwoodmuseum.org
>
> Hillwood Estate, Museum & Gardens
> 4155 Linnean Ave NW
> Washington, DC 20008
> www.hillwoodmuseum.org <http://www.hillwoodmuseum.org/>
>
> Special Exhibition
> Special Exhibitions <https://www.hillwoodmuseum.org/exhibitions>
> Through January 14, 2024
>
> Follow us on Facebook <https://www.facebook.com/HillwoodMuseum> and 
> Instagram <https://www.facebook.com/HillwoodMuseum>
>
> ------------------------------------------------------------------------
>
> *From:*archivesspace_users_group-bounces at lyralists.lyrasis.org 
> <archivesspace_users_group-bounces at lyralists.lyrasis.org> on behalf of 
> Becky Gainsford <becky.gainsford at bodleian.ox.ac.uk>
> *Sent:* Monday, July 17, 2023 4:56 AM
> *To:* archivesspace_users_group at lyralists.lyrasis.org 
> <archivesspace_users_group at lyralists.lyrasis.org>
> *Subject:* [External Message] [Archivesspace_Users_Group] Error in 
> Bulk Import
>
> 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?
>
> 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 archivesspace/templates at master · 
> archivesspace/archivesspace · GitHub 
> <https://github.com/archivesspace/archivesspace/tree/master/templates>
>
> 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….
>
> Thanks,
>
> *Becky Gainsford*
>
> Project Archivist (Metadata Support)
>
> Special Collections
>
> Bodleian Libraries
>
> Working days - Mon-Weds
>
> Tel: 01865 277131
>
> Post: The Weston Library, Broad Street, Oxford, OX1 3BG
>
> Email: becky.gainsford at bodleian.ox.ac.uk
>
> Web: http://www.bodleian.ox.ac.uk/weston 
> <http://www.bodleian.ox.ac.uk/weston>
>
>
> _______________________________________________
> Archivesspace_Users_Group mailing list
> Archivesspace_Users_Group at lyralists.lyrasis.org
> http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230725/6c70680f/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 21868 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230725/6c70680f/attachment.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 24090 bytes
Desc: not available
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230725/6c70680f/attachment.png>