subject:"Re\: \[Archivesspace_Users_Group\] \[External\] Auto formatting with dates on Accession CSV import template"

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-10 Thread Sarah Shepherd

Hi Paul,

This was genius! Thank you so much for your tip!
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: ssheph...@srmml.org


From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of 
Sutherland, Paul
Sent: Thursday, May 4, 2023 10:37 PM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template


 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.
I wonder if anyone has tried using Libre Office as your editor - it handles csv 
opening without trying to help you too much (e.g. date conversion - ISO dates 
stay as ISO dates.) It also handle UTF-8 natively much better. Especially when 
saving as .csv.

The UTF-8 handling is critical if dealing with non-roman languages.

As an aside Libre Office has a certain aesthetic that MS Office seems to lack.

Regards

Paul

From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Brian 
Harrington
Sent: Friday, 5 May 2023 8:40 am
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template

Hi Sarah,

I think that what you're seeing is Excel reformatting the date when you reopen 
the CSV file.  CSV doesn't store dates the same way that Excel does.  So if you 
set the format so that date shows as 2023-05-04 it will be saved that way in 
the CSV.  (You can open it in a text editor and check.) But the next time you 
open the CSV in Excel, Excel will cheerfully convert any dates that it finds 
(and sometimes other things) into Excel formatted dates.  So the key is to not 
reopen the file after you save as CSV.

The UTF-8 errors you're seeing are something completely different.  There are 
two ways to get around them.  The first is to save from Excel with the file 
type set to CSV UTF-8 rather than regular CSV.  The second is to look non-UTF-8 
characters in your CSV and change them.  These are usually curly quotes and 
em-dashes.

I hope this helps.

Brian

--
Brian Harrington (he/him)
Data Migration Specialist
LYRASIS
brian.harring...@lyrasis.org<mailto:brian.harring...@lyrasis.org>


From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 on behalf of Sarah Shepherd mailto:ssheph...@srmml.org>>
Date: Thursday, May 4, 2023 at 3:19 PM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template
Hi Bri,

Thanks for the advice! I wish I had seen this video earlier. Unfortunately, I 
am passed that stage and understand the issues with the formatting and dates, 
the csv file is just not letting me reformat the dates. It keeps reverting 
automatically to the date format when I switch it to the text or general 
format. It's a never-ending circle! I'll keep fiddling with it.
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: ssheph...@srmml.org<mailto:ssheph...@srmml.org>


From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of McLaughlin, Brianna Jean
Sent: Tuesday, May 2, 2023 11:18 AM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template


 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.
Hi Sarah,

I think you may be encountering similar issues that I ran into with the 
accession csv template. I don't have the process I used written out in a way 
that's decipherable by anyone but me, but my colleague, Jeremy, and I talked 
about the errors I ran into with dates during this year's ArchivesSpace Member 
Forum. The Youtube video is here: 
https://www.youtube.com/watch?v=XRAUu58-Lgs=980s. The information between 
11:46-18:23 is probably most relevant to you.

It feels weird to direct you to my own presentation, but I hope it's helpful! 
Feel free to follow up with me if you have questions.

Bri McLaughlin, she/her/hers
Digital Collections Librarian
Indiana University
812-856-3321

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyral

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-10 Thread Sarah Shepherd

Hi Margaret,

Thanks for the tip! I ended up using Brian’s trick on saving the file as a 
UTF-8 CSV file, but this will come in handy in the future.
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: ssheph...@srmml.org


From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Margaret 
Kidd
Sent: Friday, May 5, 2023 10:13 AM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template


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

Another trick for getting rid of UTF-8 errors is to use the CLEAN function in 
Excel<https://support.microsoft.com/en-us/office/clean-function-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41>.
 It takes a little extra work but is worth it when you can't find the one 
character causing the problems.

Best,

Margaret



Margaret Turman Kidd

Access and Electronic Records Archivist, Special Collections & Archives

VCU Libraries | Health Sciences Library

Virginia Commonwealth University

509 N. 12th Street / Box 980582, Richmond, VA 23298-0582

(804) 828-3152

ki...@vcu.edu<mailto:ki...@vcu.edu>

Pronouns: she/her




On Thu, May 4, 2023 at 4:40 PM Brian Harrington 
mailto:brian.harring...@lyrasis.org>> wrote:
Hi Sarah,

I think that what you’re seeing is Excel reformatting the date when you reopen 
the CSV file.  CSV doesn’t store dates the same way that Excel does.  So if you 
set the format so that date shows as 2023-05-04 it will be saved that way in 
the CSV.  (You can open it in a text editor and check.) But the next time you 
open the CSV in Excel, Excel will cheerfully convert any dates that it finds 
(and sometimes other things) into Excel formatted dates.  So the key is to not 
reopen the file after you save as CSV.

The UTF-8 errors you’re seeing are something completely different.  There are 
two ways to get around them.  The first is to save from Excel with the file 
type set to CSV UTF-8 rather than regular CSV.  The second is to look non-UTF-8 
characters in your CSV and change them.  These are usually curly quotes and 
em-dashes.

I hope this helps.

Brian

--
Brian Harrington (he/him)
Data Migration Specialist
LYRASIS
brian.harring...@lyrasis.org<mailto:brian.harring...@lyrasis.org>


From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 on behalf of Sarah Shepherd mailto:ssheph...@srmml.org>>
Date: Thursday, May 4, 2023 at 3:19 PM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template
Hi Bri,

Thanks for the advice! I wish I had seen this video earlier. Unfortunately, I 
am passed that stage and understand the issues with the formatting and dates, 
the csv file is just not letting me reformat the dates. It keeps reverting 
automatically to the date format when I switch it to the text or general 
format. It’s a never-ending circle! I’ll keep fiddling with it.
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: ssheph...@srmml.org<mailto:ssheph...@srmml.org>


From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of McLaughlin, Brianna Jean
Sent: Tuesday, May 2, 2023 11:18 AM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template


 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.
Hi Sarah,

I think you may be encountering similar issues that I ran into with the 
accession csv template. I don’t have the process I used written out in a way 
that’s decipherable by anyone but me, but my colleague, Jeremy, and I talked 
about the errors I ran into with dates during this year’s ArchivesSpace Member 
Forum. The Youtube video is here: 
https://www.youtube.com/watch?v=XRAUu58-Lgs=980s. The information between 
11:46-18:23 is probably most relevant to you.

It feels weird to direct you to my own presentation, but I hope it’s helpful! 
Feel free to follow up with me if you have questions.

Bri McLaughlin, she/her/hers
Digital Collections Libr

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-10 Thread Sarah Shepherd

Hi Brian,

Thanks so much! I didn't realize the UTF-8 error was something different and 
your tip to save the file type as CSV UTF-8 rather than the regular CSV worked 
like a charm. You saved me a lot of frustration down the line!
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: ssheph...@srmml.org


From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Brian 
Harrington
Sent: Thursday, May 4, 2023 4:40 PM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template


 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.
Hi Sarah,

I think that what you're seeing is Excel reformatting the date when you reopen 
the CSV file.  CSV doesn't store dates the same way that Excel does.  So if you 
set the format so that date shows as 2023-05-04 it will be saved that way in 
the CSV.  (You can open it in a text editor and check.) But the next time you 
open the CSV in Excel, Excel will cheerfully convert any dates that it finds 
(and sometimes other things) into Excel formatted dates.  So the key is to not 
reopen the file after you save as CSV.

The UTF-8 errors you're seeing are something completely different.  There are 
two ways to get around them.  The first is to save from Excel with the file 
type set to CSV UTF-8 rather than regular CSV.  The second is to look non-UTF-8 
characters in your CSV and change them.  These are usually curly quotes and 
em-dashes.

I hope this helps.

Brian

--
Brian Harrington (he/him)
Data Migration Specialist
LYRASIS
brian.harring...@lyrasis.org<mailto:brian.harring...@lyrasis.org>


From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 on behalf of Sarah Shepherd mailto:ssheph...@srmml.org>>
Date: Thursday, May 4, 2023 at 3:19 PM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template
Hi Bri,

Thanks for the advice! I wish I had seen this video earlier. Unfortunately, I 
am passed that stage and understand the issues with the formatting and dates, 
the csv file is just not letting me reformat the dates. It keeps reverting 
automatically to the date format when I switch it to the text or general 
format. It's a never-ending circle! I'll keep fiddling with it.
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: ssheph...@srmml.org<mailto:ssheph...@srmml.org>


From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of McLaughlin, Brianna Jean
Sent: Tuesday, May 2, 2023 11:18 AM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template


 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.
Hi Sarah,

I think you may be encountering similar issues that I ran into with the 
accession csv template. I don't have the process I used written out in a way 
that's decipherable by anyone but me, but my colleague, Jeremy, and I talked 
about the errors I ran into with dates during this year's ArchivesSpace Member 
Forum. The Youtube video is here: 
https://www.youtube.com/watch?v=XRAUu58-Lgs=980s. The information between 
11:46-18:23 is probably most relevant to you.

It feels weird to direct you to my own presentation, but I hope it's helpful! 
Feel free to follow up with me if you have questions.

Bri McLaughlin, she/her/hers
Digital Collections Librarian
Indiana University
812-856-3321

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Sarah Shepherd
Sent: Tuesday, May 2, 2023 9:10 AM
To: 
archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>
Subject: [External] [Archivesspace_Users_Group] Auto formatting with dates on 
Accession CSV import template

You don't often get email from ssheph...@srmml.org<mailto:ssheph...@srmml.org>. 
Learn why this is important<https://aka.ms/LearnAboutSenderIde

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-05 Thread Margaret Kidd

Hi,

Another trick for getting rid of UTF-8 errors is to use the CLEAN function
in Excel
<https://support.microsoft.com/en-us/office/clean-function-26f3d7c5-475f-4a9c-90e5-4b8ba987ba41>.
It takes a little extra work but is worth it when you can't find the one
character causing the problems.

Best,

Margaret

--

Margaret Turman Kidd

Access and Electronic Records Archivist, Special Collections & Archives

VCU Libraries | Health Sciences Library

Virginia Commonwealth University

509 N. 12th Street / Box 980582, Richmond, VA 23298-0582

(804) 828-3152

ki...@vcu.edu

Pronouns: she/her



On Thu, May 4, 2023 at 4:40 PM Brian Harrington <
brian.harring...@lyrasis.org> wrote:

> Hi Sarah,
>
>
>
> I think that what you’re seeing is Excel reformatting the date when you
> reopen the CSV file.  CSV doesn’t store dates the same way that Excel
> does.  So if you set the format so that date shows as 2023-05-04 it will be
> saved that way in the CSV.  (You can open it in a text editor and check.)
> But the next time you open the CSV in Excel, Excel will cheerfully convert
> any dates that it finds (and sometimes other things) into Excel formatted
> dates.  So the key is to not reopen the file after you save as CSV.
>
>
>
> The UTF-8 errors you’re seeing are something completely different.  There
> are two ways to get around them.  The first is to save from Excel with the
> file type set to CSV UTF-8 rather than regular CSV.  The second is to look
> non-UTF-8 characters in your CSV and change them.  These are usually curly
> quotes and em-dashes.
>
>
>
> I hope this helps.
>
>
>
> Brian
>
>
>
> --
>
> Brian Harrington (he/him)
>
> Data Migration Specialist
>
> LYRASIS
>
> brian.harring...@lyrasis.org
>
>
>
>
>
> *From: *archivesspace_users_group-boun...@lyralists.lyrasis.org <
> archivesspace_users_group-boun...@lyralists.lyrasis.org> on behalf of
> Sarah Shepherd 
> *Date: *Thursday, May 4, 2023 at 3:19 PM
> *To: *Archivesspace Users Group <
> archivesspace_users_group@lyralists.lyrasis.org>
> *Subject: *Re: [Archivesspace_Users_Group] [External] Auto formatting
> with dates on Accession CSV import template
>
> Hi Bri,
>
>
>
> Thanks for the advice! I wish I had seen this video earlier.
> Unfortunately, I am passed that stage and understand the issues with the
> formatting and dates, the csv file is just not letting me reformat the
> dates. It keeps reverting automatically to the date format when I switch it
> to the text or general format. It’s a never-ending circle! I’ll keep
> fiddling with it.
>
> 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: ssheph...@srmml.org
>
>
>
>
>
> *From:* archivesspace_users_group-boun...@lyralists.lyrasis.org <
> archivesspace_users_group-boun...@lyralists.lyrasis.org> *On Behalf Of 
> *McLaughlin,
> Brianna Jean
> *Sent:* Tuesday, May 2, 2023 11:18 AM
> *To:* Archivesspace Users Group <
> archivesspace_users_group@lyralists.lyrasis.org>
> *Subject:* Re: [Archivesspace_Users_Group] [External] Auto formatting
> with dates on Accession CSV import template
>
>
>
> * 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.
>
> Hi Sarah,
>
>
>
> I think you may be encountering similar issues that I ran into with the
> accession csv template. I don’t have the process I used written out in a
> way that’s decipherable by anyone but me, but my colleague, Jeremy, and I
> talked about the errors I ran into with dates during this year’s
> ArchivesSpace Member Forum. The Youtube video is here:
> https://www.youtube.com/watch?v=XRAUu58-Lgs=980s. The information
> between 11:46-18:23 is probably most relevant to you.
>
>
>
> It feels weird to direct you to my own presentation, but I hope it’s
> helpful! Feel free to follow up with me if you have questions.
>
>
>
> Bri McLaughlin, she/her/hers
>
> Digital Collections Librarian
>
> Indiana University
>
> 812-856-3321
>
>
>
> *From:* archivesspace_users_group-boun...@lyralists.lyrasis.org <
> archivesspace_users_group-boun...@lyralists.lyrasis.org> *On Behalf Of *Sarah
> Shepherd
> *Sent:* Tuesday, May 2, 2023 9:10 AM
> *To:* archivesspace_users_group@lyralists.lyrasis.org
> *Subject:* [External] [Archivesspace_Users_Group] Auto formatting with
> dates on Accession CSV import template
>
>
>
> You don't often get emai

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-04 Thread Sutherland, Paul

I wonder if anyone has tried using Libre Office as your editor - it handles csv 
opening without trying to help you too much (e.g. date conversion - ISO dates 
stay as ISO dates.) It also handle UTF-8 natively much better. Especially when 
saving as .csv.

The UTF-8 handling is critical if dealing with non-roman languages.

As an aside Libre Office has a certain aesthetic that MS Office seems to lack.

Regards

Paul

From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Brian 
Harrington
Sent: Friday, 5 May 2023 8:40 am
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template

Hi Sarah,

I think that what you're seeing is Excel reformatting the date when you reopen 
the CSV file.  CSV doesn't store dates the same way that Excel does.  So if you 
set the format so that date shows as 2023-05-04 it will be saved that way in 
the CSV.  (You can open it in a text editor and check.) But the next time you 
open the CSV in Excel, Excel will cheerfully convert any dates that it finds 
(and sometimes other things) into Excel formatted dates.  So the key is to not 
reopen the file after you save as CSV.

The UTF-8 errors you're seeing are something completely different.  There are 
two ways to get around them.  The first is to save from Excel with the file 
type set to CSV UTF-8 rather than regular CSV.  The second is to look non-UTF-8 
characters in your CSV and change them.  These are usually curly quotes and 
em-dashes.

I hope this helps.

Brian

--
Brian Harrington (he/him)
Data Migration Specialist
LYRASIS
brian.harring...@lyrasis.org<mailto:brian.harring...@lyrasis.org>


From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 on behalf of Sarah Shepherd mailto:ssheph...@srmml.org>>
Date: Thursday, May 4, 2023 at 3:19 PM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template
Hi Bri,

Thanks for the advice! I wish I had seen this video earlier. Unfortunately, I 
am passed that stage and understand the issues with the formatting and dates, 
the csv file is just not letting me reformat the dates. It keeps reverting 
automatically to the date format when I switch it to the text or general 
format. It's a never-ending circle! I'll keep fiddling with it.
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: ssheph...@srmml.org<mailto:ssheph...@srmml.org>


From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of McLaughlin, Brianna Jean
Sent: Tuesday, May 2, 2023 11:18 AM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template


 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.
Hi Sarah,

I think you may be encountering similar issues that I ran into with the 
accession csv template. I don't have the process I used written out in a way 
that's decipherable by anyone but me, but my colleague, Jeremy, and I talked 
about the errors I ran into with dates during this year's ArchivesSpace Member 
Forum. The Youtube video is here: 
https://www.youtube.com/watch?v=XRAUu58-Lgs=980s. The information between 
11:46-18:23 is probably most relevant to you.

It feels weird to direct you to my own presentation, but I hope it's helpful! 
Feel free to follow up with me if you have questions.

Bri McLaughlin, she/her/hers
Digital Collections Librarian
Indiana University
812-856-3321

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Sarah Shepherd
Sent: Tuesday, May 2, 2023 9:10 AM
To: 
archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>
Subject: [External] [Archivesspace_Users_Group] Auto formatting with dates on 
Accession CSV import template

You don't often get email from ssheph...@srmml.org<mailto:ssheph...@srmml.org>. 
Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>
This message was sent from a non-IU address. Please exercise caution when 
clicking links or opening attachments from external sources.

Hello,

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-04 Thread Brian Harrington

Hi Sarah,

I think that what you’re seeing is Excel reformatting the date when you reopen 
the CSV file.  CSV doesn’t store dates the same way that Excel does.  So if you 
set the format so that date shows as 2023-05-04 it will be saved that way in 
the CSV.  (You can open it in a text editor and check.) But the next time you 
open the CSV in Excel, Excel will cheerfully convert any dates that it finds 
(and sometimes other things) into Excel formatted dates.  So the key is to not 
reopen the file after you save as CSV.

The UTF-8 errors you’re seeing are something completely different.  There are 
two ways to get around them.  The first is to save from Excel with the file 
type set to CSV UTF-8 rather than regular CSV.  The second is to look non-UTF-8 
characters in your CSV and change them.  These are usually curly quotes and 
em-dashes.

I hope this helps.

Brian

--
Brian Harrington (he/him)
Data Migration Specialist
LYRASIS
brian.harring...@lyrasis.org


From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 on behalf of Sarah 
Shepherd 
Date: Thursday, May 4, 2023 at 3:19 PM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template
Hi Bri,

Thanks for the advice! I wish I had seen this video earlier. Unfortunately, I 
am passed that stage and understand the issues with the formatting and dates, 
the csv file is just not letting me reformat the dates. It keeps reverting 
automatically to the date format when I switch it to the text or general 
format. It’s a never-ending circle! I’ll keep fiddling with it.
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: ssheph...@srmml.org


From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of 
McLaughlin, Brianna Jean
Sent: Tuesday, May 2, 2023 11:18 AM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template


 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.
Hi Sarah,

I think you may be encountering similar issues that I ran into with the 
accession csv template. I don’t have the process I used written out in a way 
that’s decipherable by anyone but me, but my colleague, Jeremy, and I talked 
about the errors I ran into with dates during this year’s ArchivesSpace Member 
Forum. The Youtube video is here: 
https://www.youtube.com/watch?v=XRAUu58-Lgs=980s. The information between 
11:46-18:23 is probably most relevant to you.

It feels weird to direct you to my own presentation, but I hope it’s helpful! 
Feel free to follow up with me if you have questions.

Bri McLaughlin, she/her/hers
Digital Collections Librarian
Indiana University
812-856-3321

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Sarah Shepherd
Sent: Tuesday, May 2, 2023 9:10 AM
To: 
archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>
Subject: [External] [Archivesspace_Users_Group] Auto formatting with dates on 
Accession CSV import template

You don't often get email from ssheph...@srmml.org<mailto:ssheph...@srmml.org>. 
Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>
This message was sent from a non-IU address. Please exercise caution when 
clicking links or opening attachments from external sources.

Hello,

I’m having some difficulty with the Accession CSV template autoformatting my 
dates into the incorrect format for ArchivesSpace. It is only a problem with a 
single date. For example, I will put in 1920-04-29 which is the proper 
ArchivesSpace format for date_1_begin. The Accession CSV template then 
autocorrects it to be 4/29/1920 turning the cell format into a Date format 
instead of the standard General format. When I switch the cell format back to 
General it turns the number into 7425. When I put the correct date (1920-04-29) 
back in, it again auto formats the cell to a Date format, so it goes back to 
4/29/1920. Bizarrely, it does not do the same for another record which has 
1865-11-27 as date_1_begin.

I tried to look up how to stop this auto formatting but have not found 
anything. I even tried setting the date format to English (South Africa) which 
has a date format of 1920-04-29, but when I save the document, it got rid of 
all the formatting and reverts to 4/29/1920. I have tried importing the 
template without saving so that it keeps the 1920-04-29 date format (set to the 
English (South Africa)) and it gives an error (#ArgumentError: invalid byte 
sequence in UTF-8) which I

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-04 Thread Sarah Shepherd

Hi Mary,

Thanks for the advice! Unfortunately, I have already tried all these steps and 
am having the same problem. When I change the format to text or general, it 
switches back to the date format once I typed in the date. When I chose the 
-mm-dd option under "type," it reverts to dd/mm/ once I close the 
template to upload it. The details are in my previous email. I'm going to keep 
fiddling with it! We don't have that many with single dates so I might also 
just give up and add the single dates manually. Thanks.
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: ssheph...@srmml.org


From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Mary 
Mellon
Sent: Thursday, May 4, 2023 11:54 AM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template


 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.
Hi Sarah,

If you aren't copying and pasting into the template-

For existing data in your spreadsheet, you could try selecting the cells with 
mis-formatted dates, right click, and select "Format Cells." Under the 
"Numbers" tab, select the category "Date", and choose the -mm-dd option 
under "Type."

Or if you are entering new data, you could just select the column and change 
its data type to "text" before entering your dates. They shouldn't autoformat 
after that.

[cid:image001.png@01D97E9C.44F40120]

Best,

Mary

Mary Mellon (she/her)
Metadata Archivist
Rubenstein Rare Book and Manuscript Library
Duke University
mary.mel...@duke.edu<mailto:mary.mel...@duke.edu>



From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Bowers, Kate A.
Sent: Tuesday, May 2, 2023 12:16 PM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template

I suspect that you are opening the template in MS Excel and then pasting. Is 
that correct?

If so, one work-around is to use the text import wizard in Excel, which allows 
you to format the data as it goes into the cells.  I generally just make all 
data I paste into Excel "text" so that Excel won't commit data horrors.

Before you start using the text import wizard, you need to enable it.
https://support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857#ID0EBBJ=Newer_versions<https://urldefense.com/v3/__https:/support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857*ID0EBBJ=Newer_versions__;Iw!!OToaGQ!r7PCl_RFoIDRI-KZBsTr5c60tFxpH_JZP90ufihUtbAaLTfZfbCM2Mj7QKkdnE1aYVLAcZsdGv21qapS1WBJGsyP_-6A$>

Once you have enabled it, you should get the option to use it when you click on 
the down arrow (I've circled it in orange here) beneath the "paste" button in 
Excel.

[cid:image002.jpg@01D97E9C.44F40120]

Please let me know if this helps!

Kate

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of McLaughlin, Brianna Jean
Sent: Tuesday, May 2, 2023 11:18 AM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template

Hi Sarah,

I think you may be encountering similar issues that I ran into with the 
accession csv template. I don't have the process I used written out in a way 
that's decipherable by anyone but me, but my colleague, Jeremy, and I talked 
about the errors I ran into with dates during this year's ArchivesSpace Member 
Forum. The Youtube video is here: 
https://www.youtube.com/watch?v=XRAUu58-Lgs=980s<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_watch-3Fv-3DXRAUu58-2DLgs-26t-3D980s=DwMFAg=WO-RGvefibhHBZq3fL85hQ=wwc_Z_TbmWbPFh7My2zRxmrGgCNO-71Fwzlmd8YZVUY=DRBsnG4ApmYGRxyNLUjaOhfOE2CHTIwktuM5Zw4c_ZjEwbgKTNeCvJ7ACCs-kXUv=gtC_DVg69q3wvWNgmx2kOW7FF963aS-_HLkPkpxnsPo=>.
 The information between 11:46-18:23 is probably most relevant to you.

It feels weird to direct you to my own presentation, but I hope it's helpful! 
Feel free to follow up with me if you have questions.

Bri McLaughlin, she/her/hers
Digital Collections Librarian
Indiana University
812-856-3321

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mail

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-04 Thread Sarah Shepherd

Hi Bri,

Thanks for the advice! I wish I had seen this video earlier. Unfortunately, I 
am passed that stage and understand the issues with the formatting and dates, 
the csv file is just not letting me reformat the dates. It keeps reverting 
automatically to the date format when I switch it to the text or general 
format. It's a never-ending circle! I'll keep fiddling with it.
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: ssheph...@srmml.org


From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of 
McLaughlin, Brianna Jean
Sent: Tuesday, May 2, 2023 11:18 AM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template


 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.
Hi Sarah,

I think you may be encountering similar issues that I ran into with the 
accession csv template. I don't have the process I used written out in a way 
that's decipherable by anyone but me, but my colleague, Jeremy, and I talked 
about the errors I ran into with dates during this year's ArchivesSpace Member 
Forum. The Youtube video is here: 
https://www.youtube.com/watch?v=XRAUu58-Lgs=980s. The information between 
11:46-18:23 is probably most relevant to you.

It feels weird to direct you to my own presentation, but I hope it's helpful! 
Feel free to follow up with me if you have questions.

Bri McLaughlin, she/her/hers
Digital Collections Librarian
Indiana University
812-856-3321

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Sarah Shepherd
Sent: Tuesday, May 2, 2023 9:10 AM
To: 
archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>
Subject: [External] [Archivesspace_Users_Group] Auto formatting with dates on 
Accession CSV import template

You don't often get email from ssheph...@srmml.org<mailto:ssheph...@srmml.org>. 
Learn why this is important<https://aka.ms/LearnAboutSenderIdentification>
This message was sent from a non-IU address. Please exercise caution when 
clicking links or opening attachments from external sources.

Hello,

I'm having some difficulty with the Accession CSV template autoformatting my 
dates into the incorrect format for ArchivesSpace. It is only a problem with a 
single date. For example, I will put in 1920-04-29 which is the proper 
ArchivesSpace format for date_1_begin. The Accession CSV template then 
autocorrects it to be 4/29/1920 turning the cell format into a Date format 
instead of the standard General format. When I switch the cell format back to 
General it turns the number into 7425. When I put the correct date (1920-04-29) 
back in, it again auto formats the cell to a Date format, so it goes back to 
4/29/1920. Bizarrely, it does not do the same for another record which has 
1865-11-27 as date_1_begin.

I tried to look up how to stop this auto formatting but have not found 
anything. I even tried setting the date format to English (South Africa) which 
has a date format of 1920-04-29, but when I save the document, it got rid of 
all the formatting and reverts to 4/29/1920. I have tried importing the 
template without saving so that it keeps the 1920-04-29 date format (set to the 
English (South Africa)) and it gives an error (#ArgumentError: invalid byte 
sequence in UTF-8) which I saw on a different post meant that there is 
incorrect formatting on the template. It goes without saying that when I tried 
to import the template with the date as 4/29/1920, it also did not work (though 
interestingly, returning the same error (#ArgumentError: invalid byte 
sequence in UTF-8) instead of an incorrect date error).

In another weird twist, the template does not get the (#ArgumentError: 
invalid byte sequence in UTF-8) when accession_accession_date autoformats 
its cell to date and ArchivesSpace can also deal with the import just fine with 
the incorrect date format of 3/29/2023 turning it into 2023/03/29 in the record 
in ArchivesSpace. Why the difference?

That was a lot of information, but as you can see, I've done some 
troubleshooting to try to figure out the issue and have only become more 
confused!

Has anyone else run into this issue with single dates? Are there any work 
arounds besides giving up on single dates when importing?

Grateful for any help,
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: ssheph...@srmml.org<mailto:ssheph...@srmml.org>


___
Ar

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-04 Thread Mary Mellon

Hi Sarah,

If you aren't copying and pasting into the template-

For existing data in your spreadsheet, you could try selecting the cells with 
mis-formatted dates, right click, and select "Format Cells." Under the 
"Numbers" tab, select the category "Date", and choose the -mm-dd option 
under "Type."

Or if you are entering new data, you could just select the column and change 
its data type to "text" before entering your dates. They shouldn't autoformat 
after that.

[cid:image001.png@01D97E7E.65F2CB90]

Best,

Mary

Mary Mellon (she/her)
Metadata Archivist
Rubenstein Rare Book and Manuscript Library
Duke University
mary.mel...@duke.edu<mailto:mary.mel...@duke.edu>



From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Bowers, 
Kate A.
Sent: Tuesday, May 2, 2023 12:16 PM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template

I suspect that you are opening the template in MS Excel and then pasting. Is 
that correct?

If so, one work-around is to use the text import wizard in Excel, which allows 
you to format the data as it goes into the cells.  I generally just make all 
data I paste into Excel "text" so that Excel won't commit data horrors.

Before you start using the text import wizard, you need to enable it.
https://support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857#ID0EBBJ=Newer_versions<https://urldefense.com/v3/__https:/support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857*ID0EBBJ=Newer_versions__;Iw!!OToaGQ!r7PCl_RFoIDRI-KZBsTr5c60tFxpH_JZP90ufihUtbAaLTfZfbCM2Mj7QKkdnE1aYVLAcZsdGv21qapS1WBJGsyP_-6A$>

Once you have enabled it, you should get the option to use it when you click on 
the down arrow (I've circled it in orange here) beneath the "paste" button in 
Excel.

[cid:image002.jpg@01D97E7E.65F2CB90]

Please let me know if this helps!

Kate

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of McLaughlin, Brianna Jean
Sent: Tuesday, May 2, 2023 11:18 AM
To: Archivesspace Users Group 
mailto:archivesspace_users_group@lyralists.lyrasis.org>>
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template

Hi Sarah,

I think you may be encountering similar issues that I ran into with the 
accession csv template. I don't have the process I used written out in a way 
that's decipherable by anyone but me, but my colleague, Jeremy, and I talked 
about the errors I ran into with dates during this year's ArchivesSpace Member 
Forum. The Youtube video is here: 
https://www.youtube.com/watch?v=XRAUu58-Lgs=980s<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_watch-3Fv-3DXRAUu58-2DLgs-26t-3D980s=DwMFAg=WO-RGvefibhHBZq3fL85hQ=wwc_Z_TbmWbPFh7My2zRxmrGgCNO-71Fwzlmd8YZVUY=DRBsnG4ApmYGRxyNLUjaOhfOE2CHTIwktuM5Zw4c_ZjEwbgKTNeCvJ7ACCs-kXUv=gtC_DVg69q3wvWNgmx2kOW7FF963aS-_HLkPkpxnsPo=>.
 The information between 11:46-18:23 is probably most relevant to you.

It feels weird to direct you to my own presentation, but I hope it's helpful! 
Feel free to follow up with me if you have questions.

Bri McLaughlin, she/her/hers
Digital Collections Librarian
Indiana University
812-856-3321

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Sarah Shepherd
Sent: Tuesday, May 2, 2023 9:10 AM
To: 
archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>
Subject: [External] [Archivesspace_Users_Group] Auto formatting with dates on 
Accession CSV import template

You don't often get email from ssheph...@srmml.org<mailto:ssheph...@srmml.org>. 
Learn why this is 
important<https://urldefense.proofpoint.com/v2/url?u=https-3A__aka.ms_LearnAboutSenderIdentification=DwMFAg=WO-RGvefibhHBZq3fL85hQ=wwc_Z_TbmWbPFh7My2zRxmrGgCNO-71Fwzlmd8YZVUY=DRBsnG4ApmYGRxyNLUjaOhfOE2CHTIwktuM5Zw4c_ZjEwbgKTNeCvJ7ACCs-kXUv=l8skQdETjlyGUSzlosnz8etszW6mEBohTsuyYzNtuwE=>
This message was sent from a non-IU address. Please exercise caution when 
clicking links or opening attachments from external sources.

Hello,

I'm having some difficulty with the Accession CSV template autoformatting my 
dates into the incorrect format for ArchivesSpace. It is only a problem with a 
single date. For example, I will put in 1920-04-29 which is the proper 
ArchivesSpace format for date_1_begin. The Accession CSV template then 
autocorrects it to be 4/29/1920 turning the cell format into a Date format 
instead of the standard Gene

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-02 Thread Bowers, Kate A.

I suspect that you are opening the template in MS Excel and then pasting. Is 
that correct?

If so, one work-around is to use the text import wizard in Excel, which allows 
you to format the data as it goes into the cells.  I generally just make all 
data I paste into Excel "text" so that Excel won't commit data horrors.

Before you start using the text import wizard, you need to enable it.
https://support.microsoft.com/en-us/office/text-import-wizard-c5b02af6-fda1-4440-899f-f78bafe41857#ID0EBBJ=Newer_versions

Once you have enabled it, you should get the option to use it when you click on 
the down arrow (I've circled it in orange here) beneath the "paste" button in 
Excel.

[cid:image002.jpg@01D97CEF.E4283AD0]

Please let me know if this helps!

Kate

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
  On Behalf Of 
McLaughlin, Brianna Jean
Sent: Tuesday, May 2, 2023 11:18 AM
To: Archivesspace Users Group 
Subject: Re: [Archivesspace_Users_Group] [External] Auto formatting with dates 
on Accession CSV import template

Hi Sarah,

I think you may be encountering similar issues that I ran into with the 
accession csv template. I don't have the process I used written out in a way 
that's decipherable by anyone but me, but my colleague, Jeremy, and I talked 
about the errors I ran into with dates during this year's ArchivesSpace Member 
Forum. The Youtube video is here: 
https://www.youtube.com/watch?v=XRAUu58-Lgs=980s<https://urldefense.proofpoint.com/v2/url?u=https-3A__www.youtube.com_watch-3Fv-3DXRAUu58-2DLgs-26t-3D980s=DwMFAg=WO-RGvefibhHBZq3fL85hQ=wwc_Z_TbmWbPFh7My2zRxmrGgCNO-71Fwzlmd8YZVUY=DRBsnG4ApmYGRxyNLUjaOhfOE2CHTIwktuM5Zw4c_ZjEwbgKTNeCvJ7ACCs-kXUv=gtC_DVg69q3wvWNgmx2kOW7FF963aS-_HLkPkpxnsPo=>.
 The information between 11:46-18:23 is probably most relevant to you.

It feels weird to direct you to my own presentation, but I hope it's helpful! 
Feel free to follow up with me if you have questions.

Bri McLaughlin, she/her/hers
Digital Collections Librarian
Indiana University
812-856-3321

From: 
archivesspace_users_group-boun...@lyralists.lyrasis.org<mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>
 
mailto:archivesspace_users_group-boun...@lyralists.lyrasis.org>>
 On Behalf Of Sarah Shepherd
Sent: Tuesday, May 2, 2023 9:10 AM
To: 
archivesspace_users_group@lyralists.lyrasis.org<mailto:archivesspace_users_group@lyralists.lyrasis.org>
Subject: [External] [Archivesspace_Users_Group] Auto formatting with dates on 
Accession CSV import template

You don't often get email from ssheph...@srmml.org<mailto:ssheph...@srmml.org>. 
Learn why this is 
important<https://urldefense.proofpoint.com/v2/url?u=https-3A__aka.ms_LearnAboutSenderIdentification=DwMFAg=WO-RGvefibhHBZq3fL85hQ=wwc_Z_TbmWbPFh7My2zRxmrGgCNO-71Fwzlmd8YZVUY=DRBsnG4ApmYGRxyNLUjaOhfOE2CHTIwktuM5Zw4c_ZjEwbgKTNeCvJ7ACCs-kXUv=l8skQdETjlyGUSzlosnz8etszW6mEBohTsuyYzNtuwE=>
This message was sent from a non-IU address. Please exercise caution when 
clicking links or opening attachments from external sources.

Hello,

I'm having some difficulty with the Accession CSV template autoformatting my 
dates into the incorrect format for ArchivesSpace. It is only a problem with a 
single date. For example, I will put in 1920-04-29 which is the proper 
ArchivesSpace format for date_1_begin. The Accession CSV template then 
autocorrects it to be 4/29/1920 turning the cell format into a Date format 
instead of the standard General format. When I switch the cell format back to 
General it turns the number into 7425. When I put the correct date (1920-04-29) 
back in, it again auto formats the cell to a Date format, so it goes back to 
4/29/1920. Bizarrely, it does not do the same for another record which has 
1865-11-27 as date_1_begin.

I tried to look up how to stop this auto formatting but have not found 
anything. I even tried setting the date format to English (South Africa) which 
has a date format of 1920-04-29, but when I save the document, it got rid of 
all the formatting and reverts to 4/29/1920. I have tried importing the 
template without saving so that it keeps the 1920-04-29 date format (set to the 
English (South Africa)) and it gives an error (#ArgumentError: invalid byte 
sequence in UTF-8) which I saw on a different post meant that there is 
incorrect formatting on the template. It goes without saying that when I tried 
to import the template with the date as 4/29/1920, it also did not work (though 
interestingly, returning the same error (#ArgumentError: invalid byte 
sequence in UTF-8) instead of an incorrect date error).

In another weird twist, the template does not get the (#ArgumentError: 
invalid byte sequence in UTF-8) when accession_accession_date autoformats 
its cell to date and ArchivesSpace can also deal with the import just fine with 
the incorrect date format of 3/29/2023 t

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

2023-05-02 Thread McLaughlin, Brianna Jean

Hi Sarah,

I think you may be encountering similar issues that I ran into with the 
accession csv template. I don't have the process I used written out in a way 
that's decipherable by anyone but me, but my colleague, Jeremy, and I talked 
about the errors I ran into with dates during this year's ArchivesSpace Member 
Forum. The Youtube video is here: 
https://www.youtube.com/watch?v=XRAUu58-Lgs=980s. The information between 
11:46-18:23 is probably most relevant to you.

It feels weird to direct you to my own presentation, but I hope it's helpful! 
Feel free to follow up with me if you have questions.

Bri McLaughlin, she/her/hers
Digital Collections Librarian
Indiana University
812-856-3321

From: archivesspace_users_group-boun...@lyralists.lyrasis.org 
 On Behalf Of Sarah 
Shepherd
Sent: Tuesday, May 2, 2023 9:10 AM
To: archivesspace_users_group@lyralists.lyrasis.org
Subject: [External] [Archivesspace_Users_Group] Auto formatting with dates on 
Accession CSV import template

You don't often get email from ssheph...@srmml.org. 
Learn why this is important
This message was sent from a non-IU address. Please exercise caution when 
clicking links or opening attachments from external sources.

Hello,

I'm having some difficulty with the Accession CSV template autoformatting my 
dates into the incorrect format for ArchivesSpace. It is only a problem with a 
single date. For example, I will put in 1920-04-29 which is the proper 
ArchivesSpace format for date_1_begin. The Accession CSV template then 
autocorrects it to be 4/29/1920 turning the cell format into a Date format 
instead of the standard General format. When I switch the cell format back to 
General it turns the number into 7425. When I put the correct date (1920-04-29) 
back in, it again auto formats the cell to a Date format, so it goes back to 
4/29/1920. Bizarrely, it does not do the same for another record which has 
1865-11-27 as date_1_begin.

I tried to look up how to stop this auto formatting but have not found 
anything. I even tried setting the date format to English (South Africa) which 
has a date format of 1920-04-29, but when I save the document, it got rid of 
all the formatting and reverts to 4/29/1920. I have tried importing the 
template without saving so that it keeps the 1920-04-29 date format (set to the 
English (South Africa)) and it gives an error (#ArgumentError: invalid byte 
sequence in UTF-8) which I saw on a different post meant that there is 
incorrect formatting on the template. It goes without saying that when I tried 
to import the template with the date as 4/29/1920, it also did not work (though 
interestingly, returning the same error (#ArgumentError: invalid byte 
sequence in UTF-8) instead of an incorrect date error).

In another weird twist, the template does not get the (#ArgumentError: 
invalid byte sequence in UTF-8) when accession_accession_date autoformats 
its cell to date and ArchivesSpace can also deal with the import just fine with 
the incorrect date format of 3/29/2023 turning it into 2023/03/29 in the record 
in ArchivesSpace. Why the difference?

That was a lot of information, but as you can see, I've done some 
troubleshooting to try to figure out the issue and have only become more 
confused!

Has anyone else run into this issue with single dates? Are there any work 
arounds besides giving up on single dates when importing?

Grateful for any help,
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: ssheph...@srmml.org


___
Archivesspace_Users_Group mailing list
Archivesspace_Users_Group@lyralists.lyrasis.org
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

Re: [Archivesspace_Users_Group] [External] Auto formatting with dates on Accession CSV import template

11 matches

Site Navigation

Mail list logo

Footer information