<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=utf-8">
<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:-webkit-standard;
panose-1:2 11 6 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.m-783283539278659583hoenzb
{mso-style-name:m_-783283539278659583hoenzb;}
span.EmailStyle20
{mso-style-type:personal-reply;
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>
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Then you’ll appreciate that this is waiting for my wife today at home:
<a href="http://www.thinkgeek.com/product/kloj/?srp=3">http://www.thinkgeek.com/product/kloj/?srp=3</a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Edgar<o:p></o:p></p>
<div>
<div>
<div>
<p class="MsoNormal"><span style="font-size:10.5pt;font-family:"-webkit-standard",serif;color:black">----------<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><b><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Edgar Garcia</span></b><span style="font-size:10.5pt;font-family:"-webkit-standard",serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Senior Software Developer</span><span style="font-size:10.5pt;font-family:"-webkit-standard",serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Discovery Platform Services</span><span style="font-size:10.5pt;font-family:"-webkit-standard",serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Metadata & Discovery Services</span><span style="font-size:10.5pt;font-family:"-webkit-standard",serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Digital Strategies</span><span style="font-size:10.5pt;font-family:"-webkit-standard",serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Northwestern University Libraries</span><span style="font-size:10.5pt;font-family:"-webkit-standard",serif;color:black"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:#623F96">Northwestern University</span><span style="font-size:10.5pt;font-family:"-webkit-standard",serif;color:black"><o:p></o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Arial",sans-serif;color:black">Evanston, IL 60208</span><o:p></o:p></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:12.0pt;color:black">From: </span></b><span style="font-size:12.0pt;color:black"><archivesspace_users_group-bounces@lyralists.lyrasis.org> on behalf of Olivia S Solis <livsolis@utexas.edu><br>
<b>Reply-To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Date: </b>Tuesday, February 13, 2018 at 5:09 PM<br>
<b>To: </b>Archivesspace Users Group <archivesspace_users_group@lyralists.lyrasis.org><br>
<b>Subject: </b>Re: [Archivesspace_Users_Group] Data cleanup<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal"><a name="_MailOriginalBody">:) I'm a bit corgi obsessed.<o:p></o:p></a></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">On Tue, Feb 13, 2018 at 8:54 AM, Margaret Kidd <</span><a href="mailto:kiddm@vcu.edu" target="_blank"><span style="mso-bookmark:_MailOriginalBody">kiddm@vcu.edu</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">>
wrote:<o:p></o:p></span></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">Totally off topic but, Olivia, your title slide might be the best ever!
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">Margaret<o:p></o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><br clear="all">
<o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-family:"Arial",sans-serif;color:black"><img border="0" width="1233" height="1" style="width:12.8437in;height:.0104in" id="Horizontal_x0020_Line_x0020_1" src="cid:image001.png@01D3A566.AAABCF30"></span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-family:"Arial",sans-serif;color:black"><o:p></o:p></span></span></p>
<p style="margin:0in;margin-bottom:.0001pt"><span style="mso-bookmark:_MailOriginalBody"><b><span style="font-family:"Arial",sans-serif;color:#646464">Margaret Turman Kidd</span></b><o:p></o:p></span></p>
<p style="margin:0in;margin-bottom:.0001pt"><span style="mso-bookmark:_MailOriginalBody"><span style="font-family:"Arial",sans-serif;color:#646464">Access and Electronic Records Archivist, Special Collections & Archives</span><o:p></o:p></span></p>
<p style="margin:0in;margin-bottom:.0001pt"><span style="mso-bookmark:_MailOriginalBody"><span style="font-family:"Arial",sans-serif;color:#646464">VCU Libraries | Tompkins-McCaw Library for the Health Sciences</span><o:p></o:p></span></p>
<p style="margin:0in;margin-bottom:.0001pt"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#8D8D8D">509 N. 12th Street / Box 980582, Richmond, VA 23298-0582</span><o:p></o:p></span></p>
<p style="margin:0in;margin-bottom:.0001pt"><span style="mso-bookmark:_MailOriginalBody"></span><a href="tel:(804)%20828-3152" target="_blank"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:10.0pt;font-family:"Arial",sans-serif">(804) 828-3152</span></span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"></span><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__twitter.com_VCUTMLibrary&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=K_5atGy51REG1LQ2X6PZr15eB98PT06l-ic9z-MME64&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1155CC;text-decoration:none"><img border="0" width="217" height="217" style="width:2.2604in;height:2.2604in" id="_x0000_i1028" src="https://lh3.googleusercontent.com/CvwxmA9bdbubHH0SSvacsiCM35wJ3MMtdY8qFmOw7soBA46uNNHXG89hFi99w8XCP3MCPTkbSx7uxdAcW5YyV2eqviun-t6OoCTFe7aUbHhv3JJNonLo6sEH49IczUqAHOw8B8w" alt="em_twitter.png"></span></span><span style="mso-bookmark:_MailOriginalBody"></span></a><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__www.facebook.com_VCUTMLib&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=bac3hX5knnJ-E48C7mDdX3lwzmgdygHBwU5jyMStEe0&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:10.0pt;font-family:"Arial",sans-serif;color:#1155CC;text-decoration:none"><img border="0" width="217" height="217" style="width:2.2604in;height:2.2604in" id="_x0000_i1027" src="https://lh6.googleusercontent.com/bBkgQaDHlTe4cYH8-0RSwlNxAs91Xv-D8Jewu8tOyHXmx4Efy0m8hspT1EvUAnFQTuqH8NcCOb8OndayaOVeZeKkpPxKcC8yI0Guylmkdithc0ZWyxfzPPFHt_6NDWmVNoQvr3M" alt="em_fb.png"></span></span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><b>Error! Filename not specified.</b></span><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.vcu.edu_&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=OsAZQjYc9WgAOqWLasblWwts2y_SrqNoGlyEVyQd4xE&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody"><span style="text-decoration:none"><img border="0" width="180" height="72" style="width:1.875in;height:.75in" id="_x0000_i1026" src="http://identity.vcu.edu/images/photos/vcu_brand_mark_email_sig.jpg" alt="http://identity.vcu.edu/images/photos/vcu_brand_mark_email_sig.jpg"></span></span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">
</span><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__vaheritage.org&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=st0DZTZMD76RilJTpUOCU34V1zprSlPdKTg5c4YQEPk&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody"><span style="text-decoration:none"><img border="0" width="200" height="96" style="width:2.0833in;height:1.0in" id="_x0000_i1025" src="http://pages.shanti.virginia.edu/Virginia_Heritage/files/2013/01/vhpban.jpg" alt="http://pages.shanti.virginia.edu/Virginia_Heritage/files/2013/01/vhpban.jpg"></span></span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">On Tue, Feb 13, 2018 at 9:25 AM, Olivia S Solis <</span><a href="mailto:livsolis@utexas.edu" target="_blank"><span style="mso-bookmark:_MailOriginalBody">livsolis@utexas.edu</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">>
wrote:<o:p></o:p></span></p>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">Hi there, <o:p>
</o:p></span></p>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">Yes it is definitely possible to use OpenRefine to migrate data into the system. It's my primary tool for our data migration. One of the nice things about OpenRefine is its Templating export
option. I was inspired by an extremely helpful University of Maryland Chaos to Order post:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"></span><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__icantiemyownshoes.wordpress.com_2015_11_20_how-2Di-2Dlearned-2Dto-2Dstop-2Dworrying-2Dand-2Dlove-2Dthe-2Dapi_&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=0tbsuWFx_U7Vtsn2gCr-EtBVJywCEqpJ31yvcPjc3nk&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody">https://icantiemyownshoes.wordpress.com/2015/11/20/how-i-learned-to-stop-worrying-and-love-the-api/</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">That is how we've been creating records and we have developed a number of templates to export the JSON. There are a few differences in our process. For instance, the bash script didn't like spaces
in content, so we added a line <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">IFS=$| <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">and all of my templates end in a pipe.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">To update records, we were inspired by a Duke Python script:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"></span><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_duke-2Dlibraries_archivesspace-2Dduke-2Dscripts_blob_master_python_duke-5Farchival-5Fobject-5Fmetadata-5Fadder.py&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=cbfsf4kpul-fSX68tgL-zqcahhHfA2zmsXjtG3OBDE4&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody">https://github.com/duke-libraries/archivesspace-duke-scripts/blob/master/python/duke_archival_object_metadata_adder.py</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"></span><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__blogs.library.duke.edu_bitstreams_2016_09_21_archivesspace-2Dapi-2Dfun_&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=-qefkAwZtir42axnbTE8AvmAYoDvhlJfxjYaznRIQRY&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody">https://blogs.library.duke.edu/bitstreams/2016/09/21/archivesspace-api-fun/</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">as described in the blog post above.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">So for instance, we migrated our EAD by using BaseX to extract elements. I created minimal resource records and incrementally added notes.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">The process is somewhat laid out in the slides I made for a presentation:<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"></span><a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__docs.google.com_presentation_d_1cBrd8qzHK4i8S6SQ-5FvDlScERixX95lAbE-5F-5Fhd48yIDg_edit-3Fusp-3Dsharing&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=0SR7fmyIhhG-mo819WmjV-lTseRlWo5_J8Y6s-2DXHQ&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody">https://docs.google.com/presentation/d/1cBrd8qzHK4i8S6SQ_vDlScERixX95lAbE__hd48yIDg/edit?usp=sharing</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">Hopefully, this helps.<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">-Olivia<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
<div>
<div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">On Mon, Feb 12, 2018 at 9:45 AM, Joan Curbow <</span><a href="mailto:CurbowJ@bvu.edu" target="_blank"><span style="mso-bookmark:_MailOriginalBody">CurbowJ@bvu.edu</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody">>
wrote:<o:p></o:p></span></p>
</div>
</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>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody">We are a new archives, so we have not had to import any existing data. Lucky us, right? But I’m all-too-human, and I’d now like to do
some data cleanup. Is it possible to do data cleanup using OpenRefine? Theoretically, it seems possible to export “stuff” and pull it into OpenRefine, but I’ve only ever used OpenRefine in a classroom situation, where the data was already populated for us.
We did not import the data back into an existing database, either, so my experience is limited to just the mechanics of OpenRefine. Has anyone used OpenRefine in a real-world situation with data that’s already in Aspace? Or is there a better method for data
cleanup?<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody">A further question/complication is that I’m a lone arranger, and my instance is hosted by Libraryhost, so any data cleanup may have
to be done by them? My tech skills are rudimentary, so I’m not clear just how I could get this to work. I asked them once, but didn’t get a real answer.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody">Sincerely,<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"><b><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#002244">Joan Curbow</span></b><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#90A4B7">Reference Librarian and Archivist</span><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#90A4B7">Buena Vista University Library</span><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#90A4B7">Buena Vista University</span><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#90A4B7">610 West Fourth Street</span><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#90A4B7">Storm Lake, Iowa 50588</span><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"></span><a href="tel:(712)%20749-2094" target="_blank"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">712.749.2094</span></span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"></span><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__www.library.bvu.edu&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=3tr9n8ZYzyoL1nlLX2cOO3O2g6vCT4byD11uM3tAWW0&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:12.0pt;font-family:"Times New Roman",serif">www.library.bvu.edu</span></span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:12.0pt;font-family:"Times New Roman",serif;color:#90A4B7"></span><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="mso-bookmark:_MailOriginalBody"> <o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="mso-bookmark:_MailOriginalBody">_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
</span><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank"><span style="mso-bookmark:_MailOriginalBody">Archivesspace_Users_Group@lyralists.lyrasis.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
</span><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=NK-umBXCkIOdhPuORgtYXJ5ygwabItkQiYx7nXMbvx4&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
</blockquote>
</div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="color:#888888"><br>
<br clear="all">
</span><span class="m-783283539278659583hoenzb"><span style="color:#888888"><o:p></o:p></span></span></span></p>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span class="m-783283539278659583hoenzb"><span style="color:#888888">--
</span><o:p></o:p></span></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">Olivia Solis, MSIS</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">Metadata Coordinator</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:#888888"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">Dolph Briscoe Center for American History</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:#888888"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">The University of Texas at Austin</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:#888888"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">2300 Red River St. Stop D1100</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:#888888"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">Austin TX, 78712-1426</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:#888888"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"></span><a href="tel:(512)%20232-8013" target="_blank"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt">(512) 232-8013</span></span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:#888888"><o:p></o:p></span></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="mso-bookmark:_MailOriginalBody"><br>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
</span><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" target="_blank"><span style="mso-bookmark:_MailOriginalBody">Archivesspace_Users_Group@lyralists.lyrasis.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
</span><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=NK-umBXCkIOdhPuORgtYXJ5ygwabItkQiYx7nXMbvx4&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
</blockquote>
</div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span style="mso-bookmark:_MailOriginalBody"><br>
_______________________________________________<br>
Archivesspace_Users_Group mailing list<br>
</span><a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org"><span style="mso-bookmark:_MailOriginalBody">Archivesspace_Users_Group@lyralists.lyrasis.org</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><br>
</span><a href="https://urldefense.proofpoint.com/v2/url?u=http-3A__lyralists.lyrasis.org_mailman_listinfo_archivesspace-5Fusers-5Fgroup&d=DwMFaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=qL9mtrzN5YM9JLty72jmSvS2xXL_z4-MUTBxVwpL3SM&m=gn0LkCour0XUTNFKe5XswZtBLCpalmrOsrZuHB-qMcI&s=NK-umBXCkIOdhPuORgtYXJ5ygwabItkQiYx7nXMbvx4&e=" target="_blank"><span style="mso-bookmark:_MailOriginalBody">http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group</span><span style="mso-bookmark:_MailOriginalBody"></span></a><span style="mso-bookmark:_MailOriginalBody"><o:p></o:p></span></p>
</blockquote>
</div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><br>
<br clear="all">
<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><o:p> </o:p></span></p>
</div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody">-- <o:p></o:p></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">Olivia Solis, MSIS</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">Metadata Coordinator</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">Dolph Briscoe Center for American History</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">The University of Texas at Austin</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">2300 Red River St. Stop D1100</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">Austin TX, 78712-1426</span></span><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt"><o:p></o:p></span></span></p>
</div>
<div>
<p class="MsoNormal"><span style="mso-bookmark:_MailOriginalBody"><span style="font-size:9.5pt;color:black">(512) 232-8013</span></span><span style="mso-bookmark:_MailOriginalBody"></span><span style="font-size:9.5pt;color:#888888"><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>