<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=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><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;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 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:#0563C1;
text-decoration:underline;}
span.EmailStyle23
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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="EN-US" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Benn,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I just attended a session in the Forum presented by Valerie Addonizio from Atlas Systems, she suggested using “0” or “1” for the TRUE/FALSE fields. And I am kicking myself because now I can’t recall which is for True and which for false!
Lol I didn’t get it down in my notes quick enough.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<table class="MsoTableGrid" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse;border:none">
<tbody>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><img width="49" height="61" style="width:.5104in;height:.6354in" id="_x0000_i1028" src="cid:image001.png@01D78956.CB73DDC0"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:10.5pt;font-family:"Verdana",sans-serif"><o:p> </o:p></span></b></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><b><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">Sarit Hand</span></b><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></b></p>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">Digital Archivist</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
</span><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">AP Corporate Archives</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
<br>
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">200 Liberty Street<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">New York, NY 10281<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">T
</span><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">212.621.7035<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><a href="mailto:shand@ap.org"><span style="color:blue">shand@ap.org</span></a><br>
</span><span style="font-size:12.0pt;font-family:Consolas"><a href="http://www.ap.org"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;text-decoration:none">ap.org</span></a></span><span lang="FR" style="font-size:10.5pt;font-family:"Verdana",sans-serif"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif"><img border="0" width="266" height="69" style="width:2.7708in;height:.7187in" id="_x0000_i1027" src="cid:image002.png@01D78956.CB73DDC0"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> archivesspace_users_group-bounces@lyralists.lyrasis.org <archivesspace_users_group-bounces@lyralists.lyrasis.org>
<b>On Behalf Of </b>Benn Joseph<br>
<b>Sent:</b> Wednesday, August 4, 2021 4:24 PM<br>
<b>To:</b> Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] digital object import issue<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:red">[EXTERNAL]<o:p></o:p></span></p>
<div>
<p class="MsoNormal">Thanks Sarit--yes, we did just go back through the process again to verify that all AOs were published before importing digital objects with the ‘bulk_import_DO_template.xlsx’. The “publish” column in this spreadsheet has “TRUE” throughout.
After the load, the “publish” box for the digital objects is not checked.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This sounds like a bug, so I’ll plan to submit a ticket unless this is something that was fixed in a later version.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks!<o:p></o:p></p>
<p class="MsoNormal">--Benn<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Hand, Sarit<br>
<b>Sent:</b> Tuesday, August 03, 2021 2:31 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> Re: [Archivesspace_Users_Group] digital object import issue<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Hi Benn,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">This may seem obvious but just checking, are the Archival Object records, you are linking the DO records to, published?
<o:p></o:p></p>
<p class="MsoNormal">When you use ‘bulk_import_template.xlsx’, Publish is determined by the status you set for the Archival Object record you are creating hence no Publish field for the digital object record. That importer is for bulk importing Archival Objects
with an option to include a DO. <o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">The ‘bulk_import_DO_template.xlsx’, is for uploading DO records to pre-existing AO records, I was unable to find anything in AS Help Center that indicates whether or not the pre-existing record in AS needs to be published or not.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">If the Archival Objects you are linking to are published and the DOs are still importing FALSE, then maybe there is a glitch that needs to be fixed. Perhaps a support ticket?<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I have not used the DO importer yet, but now I’ll know to watch out for this, tnx.<o:p></o:p></p>
<p class="MsoNormal">Please update if/when you figure this out.<o:p></o:p></p>
<p class="MsoNormal">Cheers<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<table class="MsoNormalTable" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse">
<tbody>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><img border="0" width="49" height="61" style="width:.5104in;height:.6354in" id="Graphic_x0020_3" src="cid:image007.png@01D78956.64FDDAF0"></span><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-family:"Verdana",sans-serif"><o:p> </o:p></span></b></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><b><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">Sarit Hand</span></b><b><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></b></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">Digital Archivist</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
</span><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">AP Corporate Archives</span><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">200 Liberty Street<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">New York, NY 10281<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">T
</span><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif">212.621.7035<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><a href="mailto:shand@ap.org"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:blue">shand@ap.org</span></a><span style="font-size:10.0pt;font-family:"Arial",sans-serif"><br>
</span><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__http%3A%2Fwww.ap.org__%3B!!Dq0X2DkFhyF93HkjWTBQKhk!Hq-A_wGYcwVUD3P-m9CEeyHSIdxyeBGeWP2nXoSxAJvMF5N7EIzfoBMv_euGoj9zFXoIR77l%24&data=04%7C01%7Cshand%40ap.org%7Cde37cd53ce0545aab6ab08d95785c99f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C637637054844093634%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=7vQ7XJIAZW6F0JeglHj36A0jEMWfKsDy6si4J08JC6A%3D&reserved=0"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:black;text-decoration:none">ap.org</span></a><span lang="FR" style="font-family:"Verdana",sans-serif"><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="542" valign="top" style="width:406.45pt;padding:0in 0in 0in 0in">
<p class="MsoNormal"><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif"><img border="0" width="266" height="69" style="width:2.7708in;height:.7187in" id="Graphic_x0020_4" src="cid:image008.png@01D78956.64FDDAF0"></span><span lang="FR" style="font-size:10.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
</td>
</tr>
</tbody>
</table>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> <a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">
archivesspace_users_group-bounces@lyralists.lyrasis.org</a> <<a href="mailto:archivesspace_users_group-bounces@lyralists.lyrasis.org">archivesspace_users_group-bounces@lyralists.lyrasis.org</a>>
<b>On Behalf Of </b>Benn Joseph<br>
<b>Sent:</b> Tuesday, August 3, 2021 2:19 PM<br>
<b>To:</b> Archivesspace Users Group <<a href="mailto:archivesspace_users_group@lyralists.lyrasis.org">archivesspace_users_group@lyralists.lyrasis.org</a>><br>
<b>Subject:</b> [Archivesspace_Users_Group] digital object import issue<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:red">[EXTERNAL]<o:p></o:p></span></p>
<div>
<p class="MsoNormal">Hi everyone,<o:p></o:p></p>
<p class="MsoNormal">We’re trying to use the DO import spreadsheet to add digital objects to existing archival objects in a resource record using the templates here:
<a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fnam12.safelinks.protection.outlook.com%2F%3Furl%3Dhttps*3A*2F*2Fgithub.com*2Farchivesspace*2Farchivesspace*2Ftree*2Fmaster*2Ftemplates%26data%3D04*7C01*7Cshand*40ap.org*7C2b6c482cef1048e2145508d956ab3799*7Ce442e1abfd6b4ba3abf3b020eb50df37*7C1*7C0*7C637636116244260093*7CUnknown*7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0*3D*7C2000%26sdata%3DeoRQPjmZPaROcYkD0GEvryaFvMHmBcfg92iobB*2Bx*2Few*3D%26reserved%3D0__%3BJSUlJSUlJSUlJSUlJSUlJSUlJSUlJSU!!Dq0X2DkFhyF93HkjWTBQKhk!Hq-A_wGYcwVUD3P-m9CEeyHSIdxyeBGeWP2nXoSxAJvMF5N7EIzfoBMv_euGoj9zFSTE75eT%24&data=04%7C01%7Cshand%40ap.org%7Cde37cd53ce0545aab6ab08d95785c99f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C637637054844103626%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=1Po3KJQB2Xq7vaa%2FMJ%2Bfx4yhn8CSVo9eHUsXAohgC3s%3D&reserved=0">
https://github.com/archivesspace/archivesspace/tree/master/templates</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">When using ‘bulk_import_template.xlsx’, we’re able to import digital objects no problem, but they come into the system unpublished…and there isn’t a column for ‘publish=TRUE’ in the digital object section. We’ve also tried using ‘bulk_import_DO_template.xlsx’
because that one <i>does</i> have a ‘publish=’ column, but even when it’s set to TRUE, our digital objects are still coming into ASpace unpublished. We have a lot of these to do, and publishing them all manually will take forever!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">We’re using v2.8.1 and I can’t find any bug reports mentioning this--attached is the DO import spreadsheet we tried most recently, in case anyone can see what we’re missing.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks!<o:p></o:p></p>
<p class="MsoNormal">--Benn<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0D0D0D">Benn Joseph
</span></b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0D0D0D">(he/him/his)<b><o:p></o:p></b></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0D0D0D">Head, Collections Services<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0D0D0D">McCormick Library of Special Collections & University Archives<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0D0D0D">Northwestern University Libraries<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#4E2A84">Northwestern University<o:p></o:p></span></p>
<p class="MsoNormal"><a href="https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2Fnam12.safelinks.protection.outlook.com%2F%3Furl%3Dhttp*3A*2F*2Fwww.library.northwestern.edu*2F%26data%3D04*7C01*7Cshand*40ap.org*7C2b6c482cef1048e2145508d956ab3799*7Ce442e1abfd6b4ba3abf3b020eb50df37*7C1*7C0*7C637636116244270092*7CUnknown*7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0*3D*7C2000%26sdata%3DR4*2BUh4JLRfhei8fwfM9qfNpmwLzfaPH*2FgKUnlNloDC4*3D%26reserved%3D0__%3BJSUlJSUlJSUlJSUlJSUlJSUlJQ!!Dq0X2DkFhyF93HkjWTBQKhk!Hq-A_wGYcwVUD3P-m9CEeyHSIdxyeBGeWP2nXoSxAJvMF5N7EIzfoBMv_euGoj9zFT8QTG4j%24&data=04%7C01%7Cshand%40ap.org%7Cde37cd53ce0545aab6ab08d95785c99f%7Ce442e1abfd6b4ba3abf3b020eb50df37%7C1%7C0%7C637637054844103626%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=jwgF6G98pCnJywS0itLnqRd39xiHmmzfOZx%2F6tmIikc%3D&reserved=0"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:windowtext">www.library.northwestern.edu</span></a><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></p>
<p class="MsoNormal"><a href="mailto:benn.joseph@northwestern.edu%0d"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:windowtext">benn.joseph@northwestern.edu</span></a><u><span style="font-size:9.0pt;font-family:"Arial",sans-serif"><o:p></o:p></span></u></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#0D0D0D">847.467.6581</span><span style="font-size:9.0pt"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">The information contained in this communication is intended for the use of the designated recipients named above. If the reader of this communication is not the intended recipient, you are hereby notified that you have received this communication
in error, and that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify The Associated Press immediately by telephone at +1-212-621-1500 and delete
this email. Thank you. <o:p></o:p></p>
</div>
</div>
The information contained in this communication is intended for the use of the designated recipients named above. If the reader of this communication is not the intended recipient, you are hereby notified that you have received this communication in error,
and that any review, dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify The Associated Press immediately by telephone at +1-212-621-1500 and delete this email.
Thank you.
</body>
</html>