<div dir="ltr"><span id="gmail-docs-internal-guid-1b1cb731-7fff-d0bd-7075-c6b19157adbb"><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">Hi,</span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><br></span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">I wanted to clarify and expand upon the email I sent yesterday regarding our current (proposed) use of Digital Objects in ArchivesSpace and the related issues that we've encountered when importing DOs using the importer. My thought is that perhaps there are others out there who are working on a similar or related workflow issue who may have some suggestions for us.</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:700;font-style:italic;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><br></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="background-color:transparent;color:rgb(0,0,0);font-family:Arial;font-size:11pt;white-space:pre-wrap">When we have a digital object publicly available on our external digital collections site and we wish to provide a link to that object from the component (archival object) level in the ASpace PUI:</span><br></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">We leave </span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><b style="font-style:italic">Publish? </b>unchecked <i>(that is Publish? = FALSE) </i></span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">in the Basic Information section, but we <i>do </i>click </span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-style:italic;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">Publish? </span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">in the File Version section:</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><span style="border:1pt solid rgb(0,0,0);display:inline-block;overflow:hidden;width:624px;height:310px"><img src="https://lh6.googleusercontent.com/UQmRV-pqw1TD_rwZqoC1cD0A4Z3yGahtsHjYwfSzmP-RmI07PE_gGkXkmcAbEGN-WKDQ0N-Nn3kJCvp8WaoTHEl93Jldebskgk80DSSC4VhW4QHxoVOxE46oeG6vbnJe0QohOtoq" width="624" height="501.5365202993802" style="margin-left: 0px; margin-top: 0px;"></span></span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><span style="border:1pt solid rgb(0,0,0);display:inline-block;overflow:hidden;width:624px;height:319px"><br><img src="https://lh4.googleusercontent.com/GaF1UYDhvl1QcGVmWUAKKoxx7cG0EM8zfWEup2AJk3bJw45jIJDrwqKIeKU5Zvi7-TH-z-pEvm0tF0ngPo44N30Mcwzyvu1gypC6W1NqIQABD7glLiEoYrX1VReBjZCxNbuXPHox" width="624" height="443" style="margin-left: 0px;"></span></span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">In the PUI, the above looks like this:</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-weight:700;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><span style="border:1pt solid rgb(0,0,0);display:inline-block;overflow:hidden;width:624px;height:187px"><img src="https://lh4.googleusercontent.com/D2cP_mxbtWK-pEhmRK1ACYGtRbRjCz59DQ4S9N1bom7bT2HOTfZQxNdRFuzwKvQkk1LPi2z6ObT6UqebFnVnXxQfYk8WpHKkY4rd2N84gvC-iGVsOXwukx0WBo7P7FH_oy9XpF7_" width="624" height="187" style="margin-left: 0px; margin-top: 0px;"></span></span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">Here, what we wanted was the link out to the digital object on the external site. The reason we do not click <i>Publish? </i></span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">in the Basic Information section is because we believe users find it confusing when there are two disconnected references to digital objects within the component record.</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><br></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">This is what the PUI looks like if both <i>Publish? </i>fields are clicked (both are TRUE):</span></p><img src="cid:ii_kyacg8hu0" alt="image.png" width="563" height="217"><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><br></span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="background-color:transparent;color:rgb(0,0,0);font-family:Arial;font-size:11pt;white-space:pre-wrap">Clicking FALSE under Basic Information suppresses the link to the Digital Object record in ASpace.</span><br></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">However</span><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">, the import spreadsheet has a single field for Publish and the File Version field inherits the imported selection for the Basic Info field, and does not provide the option to mark the Basic Information field FALSE and the File Version field TRUE: </span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><span style="border:none;display:inline-block;overflow:hidden;width:624px;height:180px"><img src="https://lh5.googleusercontent.com/DLgtSIP3kKvG3X5wZYq8B28rC-J8QldZPCn2ZjckfsQ5DLR3WlddkQMKjfpPXyplxYzPNfTDQ0Mzo-8MX2AlQ8mNq89RMXtzKCvLHS14SQM0kgyzuaKbE_g3TUeHjuF6RUWtcci7" width="624" height="180" style="margin-left: 0px; margin-top: 0px;"></span></span></p><br><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">This means that we don't have the option to import a batch of digital objects in the same way that we want them to display, which results in having to manually edit DOs after import.</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><br></span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">Feel free to email me independently with any questions or if you'd like to continue this conversation offline.</span></p><p dir="ltr" style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap"><br></span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">All best,</span></p><p style="line-height:1.38;margin-top:0pt;margin-bottom:0pt"><span style="font-size:11pt;font-family:Arial;color:rgb(0,0,0);background-color:transparent;font-variant-numeric:normal;font-variant-east-asian:normal;vertical-align:baseline;white-space:pre-wrap">Wendy</span></p></span><br class="gmail-Apple-interchange-newline"><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><p style="color:rgb(0,0,0);font-family:arial;font-size:10px;padding:5px 0px 0px 5px;margin:0px"><span style="color:rgb(34,34,34);font-family:arial,sans-serif;font-size:13px">____________________________________</span><span style="color:rgb(232,46,33)"><br></span></p><p style="font-family:arial;padding:5px 0px 0px 5px;margin:0px"><span style="font-size:10px;color:rgb(172,147,110);font-weight:bold">WENDY SCHEIR</span><br></p><p style="color:rgb(34,34,34);background:none 0% 0% repeat scroll transparent;margin:0px;padding:5px 0px 0px 5px;border:0px none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor none 0px"><span style="color:rgb(0,0,0);margin:0px;padding:0px;border:0px none;background:none 0% 0% repeat scroll transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor none 0px;text-transform:uppercase">director</span><br><span style="color:rgb(232,46,33);margin:0px;padding:0px;border:0px none;background:none 0% 0% repeat scroll transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor none 0px;text-transform:uppercase">THE NEW SCHOOL </span><span style="color:rgb(102,102,102);margin:0px;padding:0px;border:0px none;background:none 0% 0% repeat scroll transparent;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor none 0px;text-transform:uppercase">ARCHIVES & SPECIAL COLLECTIONS</span></p><p style="color:rgb(34,34,34);background:none 0% 0% repeat scroll transparent;margin:0px;padding:5px 0px 0px 5px;border:0px none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor none 0px"><span style="background-color:transparent;font-family:inherit;font-style:inherit;font-weight:inherit;color:rgb(102,102,102);text-transform:uppercase">66 FIFTH AVENUE, NEW YORK, NY 10011</span></p><p style="color:rgb(34,34,34);background:none 0% 0% repeat scroll transparent;margin:0px;padding:5px 0px 0px 5px;border:0px none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor none 0px"><a href="https://www.newschool.edu/email-signature-generator/robinsa1@newschool.edu" style="background-color:transparent;color:rgb(102,102,102);text-transform:lowercase" target="_blank">scheirw@newschool.edu</a></p><p style="background:none 0% 0% repeat scroll transparent;margin:0px;padding:10px 0px 0px 5px;border:0px none;font-stretch:inherit;line-height:15px;font-family:arial;font-size:10px;vertical-align:baseline;outline:currentcolor none 0px;color:rgb(102,102,102);text-transform:uppercase"><span style="margin:0px;padding:0px;border:0px none;background:none 0% 0% repeat scroll transparent;font-style:inherit;font-variant:inherit;font-weight:bold;font-stretch:inherit;line-height:inherit;font-family:inherit;vertical-align:baseline;outline:currentcolor none 0px;color:rgb(0,0,0)">T</span> 212-229-5942</p><p style="background:none 0% 0% repeat scroll transparent;margin:0px;padding:10px 0px 0px 5px;border:0px none;font-stretch:inherit;line-height:16.5px;font-family:arial;font-size:11px;vertical-align:baseline;outline:currentcolor none 0px;color:rgb(0,0,0);text-transform:uppercase"><a href="http://archives.newschool.edu" style="text-transform:none;color:rgb(172,147,110)" target="_blank">Explore the Archives</a><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><span style="text-transform:none;font-size:10px">| </span><a href="http://digitalarchives.library.newschool.edu/" style="text-transform:none;color:rgb(172,147,110)" target="_blank">Digital Collections from the Archives</a><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><span style="text-transform:none;font-size:10px">| </span><a href="http://newschoolhistories.org/" style="text-transform:none;color:rgb(172,147,110)" target="_blank">New School Histories</a><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><font color="#000000" style="text-transform:none;font-size:10px">|</font><span style="color:rgb(32,33,36);text-transform:none;font-size:10px"> </span><a href="https://twitter.com/tnsarchives" style="text-transform:none;color:rgb(172,147,110)" target="_blank">@tnsarchives</a><br></p><p style="font-family:arial;padding:5px 0px 0px 5px;margin:0px"><img src="https://www.newschool.edu/edu-assets/marketing-communication/signature-tns.jpg" alt="THE NEW SCHOOL" style="background:none 0% 0% repeat scroll transparent;margin:0px;padding:15px 0px 0px 3px;border:0px none;font-stretch:inherit;line-height:inherit;font-family:neue,"Helvetica Neue",Helvetica,Arial,sans-serif;font-size:17px;vertical-align:baseline;outline:currentcolor none 0px;color:rgb(25,25,25);width:262px"></p><div><div><p style="vertical-align:baseline;outline-width:0px;margin:0in 0in 0.0001pt"><font color="#999999" face="Arial, sans-serif" size="1"><span style="line-height:18px"></span></font></p></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div></div><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jan 10, 2022 at 7:15 PM Wendy Scheir <<a href="mailto:scheirw@newschool.edu">scheirw@newschool.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="auto">I think a related or adjacent issue to this is that there are 2 separate <i>Publish?</i> fields for each Digital Object record, but the import spreadsheet has the option to select TRUE/FALSE for only 1 of them.<div dir="auto"><br></div><div dir="auto">The way we're using DOs, sometimes (often, actually) we want one=TRUE and the other=FALSE within a single record.<div dir="auto"><div dir="auto"><div dir="auto"><br></div><div dir="auto">Wendy<br><div dir="auto"><br></div><div dir="auto">The New Archives and Special Collections</div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Jan 10, 2022, 5:11 PM Wetherill, Julie M. <<a href="mailto:julie_wetherill@harvard.edu" target="_blank">julie_wetherill@harvard.edu</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US" style="overflow-wrap: break-word;">
<div>
<p class="MsoNormal">Hi everyone, <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">In August 2021, a <a href="http://lyralists.lyrasis.org/mailman/htdig/archivesspace_users_group/2021-August/008619.html" rel="noreferrer" target="_blank">
list message</a> from Benn Joseph at Northwestern UL described their trouble getting incorrect Publish values when importing digital objects via spreadsheet. Harvard migrated to v3.0.2 in Fall 2021 and we also have this problem. It seems like the ASpace code
that interprets the incoming spreadsheet data is being extra picky about the Type value of the “publish” (Publish Digital Object Record) attribute that is supplied in the spreadsheet.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">If the archivist uses the TRUE/FALSE controlled values provided in the official template on github (bulk_import_DO_template.xlsx), digital objects load with the correct “publish” values and their PUI display looks good. When I run the TYPE
function on these values, I get type 4 (logical value).<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">But sometimes, an archivist will paste in TRUE/FALSE values copied from another file (especially true in high volume automated workflows). At a glance these TRUE/FALSE values look identical but they aren’t. I noticed that these values are
left aligned in the cell, rather than centered as Excel does to indicate a logical TRUE or FALSE. And when I run the TYPE function on a cell with these values I get type 2 (text). Seems like ASpace wants only the logical TRUE/FALSE. An imported digital object
that has the text value TRUE for “publish” will be set to the default FALSE (unpublished). When this happens in high volume it’s a mess to clean up. And despite being marked Published=FALSE in staff mode, in the PUI, these digital objects are partially displaying.
By that I mean, there is no digital link but the DO’s are labeled DIGITAL and display in the PUI list of digital objects.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I guess the work-around is user education (warn users to only supply logical TRUE/FALSE). But I’d prefer we tweaked ASpace code to accept either the logical or text value of TRUE/FALSE as I suspect used to be the case when spreadsheet import
was plugin-based. <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Regards. –julie<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Julie Wetherill<u></u><u></u></p>
<p class="MsoNormal">HUIT Library Technology Services<u></u><u></u></p>
<p class="MsoNormal">Harvard University<u></u><u></u></p>
</div>
</div>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" rel="noreferrer" target="_blank">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br>
<a href="http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group" rel="noreferrer noreferrer" target="_blank">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</a><br>
</blockquote></div>
</blockquote></div>