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

[Mauro, Sari]

Hi all –

For folks who work in the API I have written a script that will go through a list of identified items and remove the time markings. I’ve just uploaded it to GitHub<https://github.com/sarimauro/SMauroGeneralRepo/blob/main/Dates_timestampRemediation.py> for easy access.

The script works with an input csv which contains the URI and date of the Archival Object. We generate this from the Word Order Report plug in. You are welcome to use the code as is or to remix as appropriate for your setting!

--Sari

--


Sari Mauro
Digital Collections Project Manager
Tufts Archival Research Center | Tufts University

sari.mauro at tufts.edu<mailto:sari.mauro at tufts.edu>
617-627-2498





From: archivesspace_users_group-bounces at lyralists.lyrasis.org <archivesspace_users_group-bounces at lyralists.lyrasis.org> On Behalf Of Sarah Shepherd
Sent: Tuesday, July 25, 2023 2:48 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org>
Subject: [External] Re: [Archivesspace_Users_Group] Time markings in date fields from bulk import spreadsheet

Hi John,

Wonderful! I’m glad I was able to help.
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<mailto:sshepherd at srmml.org>

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org>> On Behalf Of John F. Anderies
Sent: Tuesday, July 25, 2023 12:13 PM
To: Archivesspace Users Group <archivesspace_users_group at lyralists.lyrasis.org<mailto:archivesspace_users_group at lyralists.lyrasis.org>>
Subject: Re: [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.
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<mailto: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<mailto:sshepherd at srmml.org>

From: archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto:archivesspace_users_group-bounces at lyralists.lyrasis.org> <archivesspace_users_group-bounces at lyralists.lyrasis.org<mailto: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<mailto: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<mailto:Archivesspace_Users_Group at lyralists.lyrasis.org>
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Caution: This message originated from outside of the Tufts University organization. Please exercise caution when clicking links or opening attachments. When in doubt, email the TTS Service Desk at it at tufts.edu<mailto:it at tufts.edu> or call them directly at 617-627-3376.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230727/232853bb/attachment.html>