<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
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]-->
</head>
<body lang="FR-CA" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="mso-fareast-language:EN-US">Hello Olivia, <o:p>
</o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">During our ASpace implementation, Atlas helped us play around with trying to add labels to notes using the spreadsheet. We came to the conclusion that it is not possible.
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">Would be happy if someone proved me wrong though!<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US">Anna<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<P style="FONT-SIZE: 8pt; FONT-FAMILY: ARIAL">---<BR><BR><STRONG>Anna
Haywood<BR></STRONG>Archiviste<BR>Archivist<BR><BR><SPAN
style="FONT-SIZE: 8pt"><STRONG>Centre Canadien d'Architecture<BR>Canadian Centre
for Architecture</STRONG><BR></SPAN>1920, rue Baile, Montréal, Québec, Canada,
H3H 2S6<BR>+1 5149397001x1368<BR><A title="" style="TEXT-DECORATION: none; COLOR: #000000"
href="https://www.cca.qc.ca/fr/?utm_source=fr_email_signature&utm_medium=email">cca.qc.ca</A><BR><A
title="" href="https://www.twitter.com/ccawire">Twitter</A> | <A title=""
href="https://www.instagram.com/canadiancentreforarchitecture/">Instagram</A> |
<A title="" href="https://www.facebook.com/cca.conversation">Facebook</A> | <A
title="" href="https://www.youtube.com/user/CCAchannel">YouTube</A></P>
<P style="FONT-SIZE: 8pt; FONT-FAMILY: ARIAL"><A title=""
href="https://www.cca.qc.ca/fr/83986/territoires-vivants">Comment comprendre les
liens que nous entretenons avec les processus coloniaux?</A><BR><A title=""
href="https://www.cca.qc.ca/en/83986/living-lands">How can we understand the
broader connections we have to settler colonial processes?</A></P>
<P style="FONT-SIZE: 8pt; FONT-FAMILY: ARIAL"><A title=""
href="https://www.cca.qc.ca/fr/?go=enews&utm_source=fr_email_signature&utm_medium=email">Inscrivez-vous</A>
pour recevoir de nos nouvelles.<BR><A title=""
href="https://www.cca.qc.ca/en/?go=enews&utm_source=en_email_signature&utm_medium=email">Sign
up</A> to get news from us.</P><div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span lang="EN-US">From:</span></b><span lang="EN-US"> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Olivia S Solis<br>
<b>Sent:</b> Monday, March 28, 2022 1:38 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] Adding columns to Harvard spreadsheet importer<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hello all,<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">A couple months ago, I similarly wanted to import a value in the Label field along with the content of a General Note. I tried with a column header of n_odd_label to see if this would work, but it did not. I posted to this group, but did not
get a response. The error I got read:<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#33EE33;background:#333333">Row 6: ERROR ["Note Type 'odd_label' is not supported"]</span><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Is there a different way to do this?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Thanks,<br>
Olivia<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Mon, Mar 28, 2022 at 12:20 PM Anna Haywood <<a href="mailto:ahaywood@cca.qc.ca">ahaywood@cca.qc.ca</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hello Bri,
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">You can definitely do this. We have added lots of extra columns to our spreadsheet (particularly for notes that weren’t already there. You just need to copy the
exact same format as the previous columns for the ArchivesSpace field codes found in Row 4. One column has the note contents and the other has the publish yes or no value. The field codes follow the format n_[note type] for note contents and p_[note type]
for publish true/false. For the [note type], you must use the exact value (and not the translation) for that note type, found in the ASpace Controlled Value Lists: Note Singlepart Type (note_singlepart_type) or Note Multipart Type (note_multipart_type).</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">For instance, if you wanted to add columns for the note type Accruals: Add 1 column with the ArchivesSpace field code n_accruals and add 1 column with the ArchivesSpace
field code p_accruals. </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Best,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Anna</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p><span style="font-size:8.0pt;font-family:"Arial",sans-serif">---<br>
<br>
<strong><span style="font-family:"Arial",sans-serif">Anna Haywood</span></strong><b><br>
</b>Archiviste<br>
Archivist<br>
<br>
<strong><span style="font-family:"Arial",sans-serif">Centre Canadien d'Architecture</span></strong><b><br>
<strong><span style="font-family:"Arial",sans-serif">Canadian Centre for Architecture</span></strong></b><br>
1920, rue Baile, Montréal, Québec, Canada, H3H 2S6<br>
+1 5149397001x1368<br>
<a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cca.qc.ca%2Ffr%2F%3Futm_source%3Dfr_email_signature%26utm_medium%3Demail&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=U81UEB5i69rTL4M%2BL8%2BQ9tr4KaKL5Q8Y7viWysbviKk%3D&reserved=0" target="_blank"><span style="color:black;text-decoration:none">cca.qc.ca</span></a><br>
<a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.twitter.com%2Fccawire&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=depDhsH8Je%2FrY9LnNALr8Zl4b39Zfxa3tWRdfVH4mJ8%3D&reserved=0" target="_blank">Twitter</a>
| <a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fcanadiancentreforarchitecture%2F&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=taivbLmE0diFBpoAZHoLT8rx0z7imeGwsjP3UJIrB3A%3D&reserved=0" target="_blank">
Instagram</a> | <a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.facebook.com%2Fcca.conversation&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=AjfbIeaU4ZjGuc0NPycyz1%2FX4JLot%2FxHjYiBbdVeIl4%3D&reserved=0" target="_blank">
Facebook</a> | <a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.youtube.com%2Fuser%2FCCAchannel&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=nqN3764nc8JK6qZYHWHP5Sw9PXiSdrne9JP7IyvjswY%3D&reserved=0" target="_blank">
YouTube</a><o:p></o:p></span></p>
<p><span style="font-size:8.0pt;font-family:"Arial",sans-serif"><a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cca.qc.ca%2Ffr%2F83986%2Fterritoires-vivants&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=NvwwAkE%2Fcqw%2FAqe9DsaL6%2FYUnSUpjTbZhKyK9mG1dfc%3D&reserved=0" target="_blank">Comment
comprendre les liens que nous entretenons avec les processus coloniaux?</a><br>
<a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cca.qc.ca%2Fen%2F83986%2Fliving-lands&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=4DMQX%2FB%2B0TXAkFGBvNwVu8W8Xj1fWXnijROPFluH30E%3D&reserved=0" target="_blank">How
can we understand the broader connections we have to settler colonial processes?</a><o:p></o:p></span></p>
<p><span style="font-size:8.0pt;font-family:"Arial",sans-serif"><a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cca.qc.ca%2Ffr%2F%3Fgo%3Denews%26utm_source%3Dfr_email_signature%26utm_medium%3Demail&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803435359%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=ytzSdayMw9JkhDXo%2B4wxP0DXyApTRgb703tXOa9nSpo%3D&reserved=0" target="_blank">Inscrivez-vous</a>
pour recevoir de nos nouvelles.<br>
<a href="https://can01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.cca.qc.ca%2Fen%2F%3Fgo%3Denews%26utm_source%3Den_email_signature%26utm_medium%3Demail&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803591572%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=inKS438tZxEccMZEHtOnYHWyCSbgyEAkocSu27S382s%3D&reserved=0" target="_blank">Sign
up</a> to get news from us.<o:p></o:p></span></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><b><span lang="EN-US">From:</span></b><span lang="EN-US">
<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org" target="_blank">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>McLaughlin, Brianna Jean<br>
<b>Sent:</b> Thursday, March 24, 2022 4:38 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org" target="_blank">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] Adding columns to Harvard spreadsheet importer</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Hi everyone,</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Does anyone know if it’s possible/ advisable to add columns to the spreadsheet template? For example, there are not columns for Note Labels in the spreadsheet
even though the fields exist in ArchivesSpace. </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Thanks!</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Bri McLaughlin, she/her/hers</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Visiting Metadata Services Librarian</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Indiana University </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">812-856-3321</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"> </span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="https://can01.safelinks.protection.outlook.com/?url=http%3A%2F%2Flyralists.lyrasis.org%2Fmailman%2Flistinfo%2Farchivesspace_users_group&data=04%7C01%7Cahaywood%40cca.qc.ca%7C51d33665fa454f1a57bf08da10e1b371%7C4e72076180cf4800ad14ca034727386b%7C0%7C0%7C637840858803591572%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=MhpEJE1rCwMSpfzHIjyJ4%2BE%2Fu0aUB7Py04H2Ukn6NDY%3D&reserved=0" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><o:p></o:p></p>
</blockquote>
</div>
<p class="MsoNormal"><br clear="all">
<o:p></o:p></p>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">-- <o:p></o:p></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">Olivia Solis, MSIS (she/her)</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">Metadata Coordinator</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">Dolph Briscoe Center for American History</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">The University of Texas at Austin</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">2300 Red River St. Stop D1100</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">Austin TX, 78712-1426</span><span style="font-size:9.5pt"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.5pt;color:black">(512) 232-8013</span><span style="font-size:9.5pt;color:#888888"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>