[Archivesspace_Users_Group] Time markings in date fields from bulk import spreadsheet

[John F. Anderies]

Thank you, Sarah! I was using Excel. I just downloaded and tried the
LibreOffice spreadsheet. I had to convert to CSV for it to be able to be
importable into ASpace, but then it worked like a charm. (I possibly should
have tried CSV instead of Excel format in the first place). Problem solved,
and hours of editing averted!

John


-----
John Anderies (he/him), Director
John J. Wilcox, Jr. Archives and Library
William Way LGBT Community Center


On Tue, Jul 25, 2023 at 11:47 AM Sarah Shepherd <SShepherd at srmml.org> wrote:

> Hi John,
>
>
>
> 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.
>
>
>
> Best,
>
> Sarah
>
>
>
> Sarah H. Shepherd
>
> (she/her/hers)
> Archivist
> Scottish Rite Masonic Museum and Library
>
> 33 Marrett Road | Lexington, MA 02421
>
> Phone: 781-457-4129 | Email: sshepherd at srmml.org
>
>
>
> *From:* archivesspace_users_group-bounces at lyralists.lyrasis.org <
> archivesspace_users_group-bounces at lyralists.lyrasis.org> *On Behalf Of *John
> F. Anderies
> *Sent:* Tuesday, July 25, 2023 11:39 AM
> *To:* Archivesspace_Users_Group at lyralists.lyrasis.org
> *Subject:* [Archivesspace_Users_Group] Time markings in date fields from
> bulk import spreadsheet
>
>
>
> * CAUTION:* 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.
>
> Apologies if this has been asked and answered before.
>
>
>
> 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.
>
>
>
> 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.
>
>
>
> With thanks,
>
> John
>
>
>
> -----
> John Anderies (he/him), Director
> John J. Wilcox, Jr. Archives and Library
> William Way LGBT Community Center
> _______________________________________________
> 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/90d56886/attachment.html>