<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">
<div class=""><br class="">
</div>
<div class="">May be able to be fixed in EAD import. </div>
<div class="">Or, perhaps added to pre-flight schematrons and fixed in XSLT before import, since there are already a number of required fixes. </div>
<div class=""><br class="">
</div>
<div class="">But that would be too late to fix resources you’ve already imported. </div>
<div class=""><br class="">
</div>
<div class="">Those, you can fix it in MySQL with something like:</div>
<div class=""><br class="">
</div>
<div class="">
<div class="">select count(*) from archivesspace.archival_object WHERE title LIKE '%,,%';</div>
<div class="">SET SQL_SAFE_UPDATES=0;</div>
<div class="">UPDATE archivesspace.archival_object </div>
<div class="">SET </div>
<div class=""> title = REPLACE(title, ',,', ',')</div>
<div class="">WHERE</div>
<div class=""> title LIKE '%,,%';</div>
<div class="">select count(*) from archivesspace.archival_object WHERE title LIKE '%,,%';</div>
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">except repeat the archival_object.title update for archival_object.display_string, resource.title, accession.title, and accession.display_string as needed. ( I think that's all of them. ) </div>
<div class=""><br class="">
</div>
<div class="">May require triggering a reindex afterwards. </div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">Note: I find too many false positives using regex search rlike: display_string rlike "[.,;],”</div>
<div class="">i.e. strings with an abbrev., : “… U.S. Commissioners, et.al., 1931-56;” or "Photographs, India, Thomas Gampper, M.D., undated” . And searching for double periods ( like “%..%” ) mostly brings up intended ellipses in my sample, so if you want
to try any other patterns, you should inspect the search results first. </div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">The above is all assuming that the problem is in the database and not just some display string constructed on the fly. I’ve found some matching “,,” instances in my sample, so that’s my guess at the source of the problem. However, I have no way
to search display only instances other than by eyeball. ( Reminds me of the joke about the drunk looking for his keys under the streetlight! ;-) </div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">— Steve Majewski</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<br class="">
<div>
<blockquote type="cite" class="">
<div class="">On Jun 27, 2017, at 4:28 PM, Lara Friedman-Shedlov <<a href="mailto:ldfs@umn.edu" class="">ldfs@umn.edu</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<div dir="ltr" class="">I was sure I had seen a JIRA issue for this a while back, but now I can't find it. We have thousands of finding aids imported from EAD that have punctuation (commas and periods) at the end of the unittitle and/or unitdate fields. Since
ArchivesSpace automatically inserts commas between unittitles and unitdates, you end up with double punctuation. Rather than edit thousands and thousands of records to remove this superfluous punctuation, is there a way for ASpace to just ignore it? Please
say yes! :-)
<div class=""><br class="">
</div>
<div class="">/ Lara Friedman-Shedlov</div>
<div class="">
<div class=""><br class="">
</div>
<div class="">
<div class="">-- <br class="">
<div class="gmail_signature" data-smartmail="gmail_signature">
<div dir="ltr" class="">
<div class="">
<div dir="ltr" class="">
<div class="">_________________________________<br class="">
</div>
<div class=""><br class="">
<div class="">Lara D. Friedman-Shedlov<br class="">
<a href="http://www.lib.umn.edu/ymca" style="font-size:12.8px" target="_blank" class="">Kautz Family YMCA Archives</a> | University of Minnesota Libraries<br class="">
<a href="mailto:ldfs@umn.edu" target="_blank" class="">ldfs@umn.edu</a> | 612.626.7972 | </div>
<div class=""><br class="">
</div>
<div class=""><a href="http://www.facebook.com/yarchives" style="color:rgb(17,85,204);font-size:12.8px" target="_blank" class=""><img alt="www.facebook.com/IHRCA" src="http://i.imgbox.com/6DCAk0cT.png" height="35" width="35" class=""></a><span style="font-size:12.8px" class=""> </span><a href="https://twitter.com/yarchives" style="color:rgb(17,85,204);font-size:12.8px" target="_blank" class=""><img alt="https://twitter.com/yarchives" src="http://i.imgbox.com/JlcfS0i5.png" height="35" width="35" class=""></a><br class="">
<br class="">
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br class="">
Archivesspace_Users_Group mailing list<br class="">
<a href="mailto:Archivesspace_Users_Group@lyralists.lyrasis.org" class="">Archivesspace_Users_Group@lyralists.lyrasis.org</a><br class="">
http://lyralists.lyrasis.org/mailman/listinfo/archivesspace_users_group<br class="">
</div>
</blockquote>
</div>
<br class="">
</body>
</html>