Thanks for this as well. I have a list I produced but guessing your process is even more thorough than mine so will take a look.
Yes. I probably annoy the librarians sometimes with all the previewing/testing I request before making batch changes but so far there hasn’t been much weeping and gnashing of teeth when all is said and done so hopefully I will continue the trend J Thanks again. Jim From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan Hamby Sent: Monday, April 25, 2016 2:04 PM To: swills beyond-print.com; Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Programmatic Merging of Bibliographic Records Hi Jim, It is available. To be clear I helped create the de-duplication algorithm but the actual coding was done by Galen Charlton of Equinox. You can find it here: http://git.esilibrary.com/?p=migration-tools.git;h=300a04108fc6a3d14424c6d365329be334114f7d The full scope of the script goes a bit beyond the original question as it also does de-duplication before the merging. The merging work is done by the merge_record_assets function that Jason referenced. Whatever method you use I heartily recommend doing so on a testing system and having catalogers look over the results first. You may have already done all the due diligence but I say it for anyone reading along as well. I've never had problems with this method and heard back from others with positive success with it as well but I also heard from at least one whose data was apparently different enough that it was not a clean merge. Caveat usor, let the user beware. On Mon, Apr 25, 2016 at 2:36 PM, swills beyond-print.com <swi...@beyond-print.com> wrote: Rogan Hamby shared his work with me. It's a set of SQL procedures that product a 'best bib' and then identifies the less interesting duplicate and it seems to work well. I modified it so that it produces the candidates but doesn't actually do the merge since we like to have that personal touch up in Maine. I'm not sure if it is in Evergreen Repos or not? Rogan, can you help and thanks again. Steve Wills On April 25, 2016 at 2:24 PM Jim Taylor <jtay...@jtdata.com> wrote: I raised the question at the conference regarding the ability to merge records outside the program interface and was told there was a procedure/function that would allow this to be done. Does anyone know where I can find this function? My searching has availed me naught. I found something under the Vandelay tables but not sure it is what I am needing as the above mentioned function is supposed to take two tcn numbers. Thanks. Jim -- -------------------------------------------------------------- Rogan R. Hamby, Data and Project Analyst Equinox - Open Your Library <mailto:ro...@esilibrary.com> ro...@esilibrary.com 1-877-OPEN-ILS | www.esilibrary.com