[OPEN-ILS-GENERAL] Release Manager Election
Hi, all. The election for 2.9 Release Manager will take place in the Evergreen irc channel on freenode.net on Thursday, May 28 at 1:00 PM EDT. That would be 10:00 AM PDT and 5:00 PM GMT. -- Jason Stephenson Assistant Director for Technology Services Merrimack Valley Library Consortium 1600 Osgood ST, Suite 2094 North Andover, MA 01845 Phone: 978-557-5891 Email: jstephen...@mvlc.org
Re: [OPEN-ILS-GENERAL] Open-ils-general Digest, Vol 107, Issue 41
Here is the link to my presentation: Receipt Template Magic and documentation. I will be updating it with more templates as I get them polished up. http://chestateelibrary.org/?page_id=780 Tina Jordan Assistant Director Chestatee Regional Library System 342 Allen Street Dawsonville, GA 30534 706-344-3690 x16 -Original Message- From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of open-ils-general-requ...@list.georgialibraries.org Sent: Saturday, May 23, 2015 12:00 PM To: open-ils-general@list.georgialibraries.org Subject: Open-ils-general Digest, Vol 107, Issue 41 Send Open-ils-general mailing list submissions to open-ils-general@list.georgialibraries.org To subscribe or unsubscribe via the World Wide Web, visit http://libmail.georgialibraries.org/mailman/listinfo/open-ils-general or, via email, send a message with subject or body 'help' to open-ils-general-requ...@list.georgialibraries.org You can reach the person managing the list at open-ils-general-ow...@list.georgialibraries.org When replying, please edit your Subject line so it is more specific than Re: Contents of Open-ils-general digest... Today's Topics: 1. Re: presentations (Ben Shum) 2. Re: presentations (Yamil Suarez) -- Message: 1 Date: Fri, 22 May 2015 13:16:03 -0400 From: Ben Shum bs...@biblio.org To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] presentations Message-ID: CAHkwDt7qEemKV+zHvxdgZY=firwg1h9rvatioljw8f0cudd...@mail.gmail.com Content-Type: text/plain; charset=UTF-8 This is Jason's and my presentation on Running with the Bulls: Mastering Production Google: https://docs.google.com/presentation/d/10c6Dj_uvojbXvtnjadqt_hUwWlchAauoVnQBMlHBfUI/edit?usp=sharing PDF: http://evergreen-ils.org/~bshum/eg15/running-with-the-bulls.pdf -- Ben On Fri, May 15, 2015 at 7:23 PM, Rogan Hamby rogan.ha...@yclibrary.net wrote: In the interest of sharing presentations (that weren't done before the conference): http://www.slideshare.net/roganhamby/welcome-to-the-community and http://www.slideshare.net/roganhamby/adding-data-sources-to-the-report er There were quite a few from other folks that I wasn't able to attend so I hope everyone sends out their presentations! -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis -- Benjamin Shum Evergreen Systems Manager Bibliomation, Inc. 24 Wooster Ave. Waterbury, CT 06708 203-577-4070, ext. 113 -- Message: 2 Date: Fri, 22 May 2015 13:31:01 -0400 From: Yamil Suarez ysua...@berklee.edu To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org Subject: Re: [OPEN-ILS-GENERAL] presentations Message-ID: canakoqa4otepptgs9b0ebipeb+8qn7ew9kith_xxmvbxmy7...@mail.gmail.com Content-Type: text/plain; charset=UTF-8 Hello, Here are the presentations I gave... 1) How do I participate in EG community This is a more detailed version of my section of this group presentation... https://docs.google.com/presentation/d/1IJoXPyySDXLuI4wR7H_4fLJHykVYotVEzKaGvHhtboo/edit?usp=sharing short URL: https://goo.gl/ksf18V 2) 2015 EG Board update https://docs.google.com/presentation/d/16J2Fas4hzHh9g95Kgz_IFTqioNLj_npu4Q1GgjuZThI/edit?usp=sharing short URL: https://goo.gl/AB9MH5 3) Evergreen for Academics Wiki page link http://goo.gl/e9p2av 4) Intro to IRC http://goo.gl/w3zml2 Later, Yamil On Fri, May 15, 2015 at 10:00 PM, Galen Charlton g...@esilibrary.com wrote: Hi, Thanks, Rogan, for starting this thread; I'll update the program schedule page with links to the slides that the presenters choose to share. Also, if your presentation is in the form of a PDF file or some other presentation file and you wish to share it, please send it to me and I'll can put it up on the Evergreen website. Regards, Galen On Fri, May 15, 2015 at 5:07 PM, Kathy Lussier kluss...@masslnc.org wrote: Thanks Rogan! Here are my slides: State of Evergreen Initiatives and Outreach - http://slides.com/kathylussier/state-eg Getting What You Want in Your Next Development Project - http://slides.com/kathylussier/development-projects Evergreen Search Tune-Up - http://slides.com/kathylussier/evergreen-search Kathy On 05/15/2015 04:23 PM, Rogan Hamby wrote: In the interest of sharing presentations (that weren't done before the conference): http://www.slideshare.net/roganhamby/welcome-to-the-community and http://www.slideshare.net/roganhamby/adding-data-sources-to-the-reporter There were quite a few from other folks that I wasn't able to attend so I hope everyone sends out their presentations! -- Rogan Hamby, MLS, CCNP, MIA
Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution?
Thanks Rogan, this would be something I think a lot of Evergreen libraries would be interested in pursuing…. --Tony Tony Bandy to...@ohionet.orgmailto:to...@ohionet.org OHIONET 1500 West Lane Ave. Columbus, OH 43221-3975 614-484-1074 (Direct) 614-486-2966 x19 From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan Hamby Sent: Tuesday, May 26, 2015 2:05 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution? a bit of postscript, I can't speak to the documentation but I tried this as far as creating a new auditor table, and the function and trigger to do this and it worked fine on a test VM. I didn't go so far as to write the query to find them but it should be doable. I might play with it some more if I have some time. On Thu, May 21, 2015 at 1:56 PM, Tony Bandy to...@ohionet.orgmailto:to...@ohionet.org wrote: Hi all, Rogan, Appreciate the update….but not being a developer or SQL person, I was a little lost after the second sentence. ☺ If something like this would get done, do you think this could be part of the documentation, etc? --Tony Tony Bandy to...@ohionet.orgmailto:to...@ohionet.org OHIONET 1500 West Lane Ave. Columbus, OH 43221-3975 614-484-1074tel:614-484-1074 (Direct) 614-486-2966 x19tel:614-486-2966%20x19 From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.orgmailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan Hamby Sent: Thursday, May 21, 2015 1:49 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution? Hi Tony, I've never done this but as I hope SCLENDS moves to authorities in the not too distant future I'm interested in this topic a lot. If I remember correctly when a MARC record gets updated the old metabib.real_full_rec entries get deleted and new ones are entered. I would be tempted to create a conditional auditor trigger that only write entries for the headings fields so that it's not a huge auditor table. I've not done that but some quick googling showed up examples of it. It would be a fun experiment if nothing else. Then it would be easy to write a sql report to get distinct records from those whose inserted IDs (current metabib) are different from the audited ones and then export just those records. On Thu, May 21, 2015 at 1:04 PM, Tony Bandy to...@ohionet.orgmailto:to...@ohionet.org wrote: Hello all, At COOL, we’ve recently started authority control with BSLW. We have had our entire DB cleaned up and are getting ready to start the quarterly updates. In this, we will be sending them new bibs that have been added to the system for headings cleanup. However, we are also considering sending edited bibs as well. This would be bib records that were authorized and cleaned up, but have since been overlaid or updated. The biggest issue we are having is how to do this. While the edit date in the bib is a starting point, we really only want to send bibs whose headings have changed, not other values in the record. The question is: How? We’ve looked at the auditing tables as a starting point, but am thinking there might be a better solution: - Initial thoughts: 1.Using PGAdmin, we can extract a list of TCN’s that have been modified (edited) since our last full DB dump. 2. Using this list, extract bibs in MARC format from the system. 3. Using MARC Compare (found in Marc Edit 6.x) I can compare these bibs with the original cleaned up records from BSLW and get a list of changed fields. (I’ve done a sample file this am) 4. This solution actually works to scan fields by hand for changes. 5. However, with MARC Compare the records have to be in order or everything falls apart. (Plus if you have a ton-o-records, this can prove time consuming). - Solution? So my proposed solution is to write a custom PERL script to take original bibs and edited bibs, extract them down and compare headings in each of the two files, sending output out (via TCN’s) of those bibs whose headings fields have changed (such as the 100's, 400's, 600's, 700-740's as examples). Once I have the TCN’s, it would be easy to dump these out of the system for cleanup by BSLW. - My question is: Has this been done before? (I don’t want to reinvent the wheel). Is there a better way that someone else has come up with to do this? I’ve been digging around http://perldoc.perl.org/File/Compare.html this am as well as http://marcpm.sourceforge.net/tutorial.pdf, and https://metacpan.org/pod/MARC::Record and I think this would be do-able. I’m certainly not a developer, but have written perl scripts in the past….so this would be fun to try. Any thoughts? --Tony Tony Bandy to...@ohionet.orgmailto:to...@ohionet.org OHIONET 1500 West Lane Ave. Columbus, OH
Re: [OPEN-ILS-GENERAL] Conference Transportation
There's also Evergreen State College up in Olympia - we ought to convince them to switch to the Evergreen ILS! http://evergreen.edu/ Terran McCanna PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 404-235-7138 tmcca...@georgialibraries.org - Original Message - From: Buzzy Nielsen bu...@hoodriverlibrary.org To: open-ils-general@list.georgialibraries.org Sent: Tuesday, May 26, 2015 2:22:41 PM Subject: Re: [OPEN-ILS-GENERAL] Conference Transportation Ha, nice! I forgot about them. I will say, however, that I'm not sure we want to be associated with that particular airline. http://www.oregonlive.com/business/index.ssf/2013/03/oregon_justice_dept_examines_w.html It is a cool air museum, by the way, if anyone comes back this way. We've got a pretty decent one in Hood River, too. http://waaamuseum.org/ Cheers! Buzzy Library Director Hood River County Library District 502 State Street Hood River, Oregon 97031 541-387-7062 http://hoodriverlibrary.org On 05/26/2015 10:58 AM, Jeff Klapes wrote: After the conference (which was great, by the way) my partner and I spent a week enjoying Oregon's beautiful scenery. I'm sure the Oregonians are already aware of this, but we came across this plane at one of the air museums. I didn't realize the open-source community owned a 747! Perhaps for next year's conference, Buzzy could arrange an air charter? :-) Cheers, -- Jeff Klapes kla...@noblenet.org Head of Reference Services 781-246-6334 x6565 Lucius Beebe Memorial Library, 345 Main St, Wakefield, MA 01880 Where Wakefield Connects www.wakefieldlibrary.org ___ I'm currently reading Karpathia by Mathias Menegoz and Six and a half sins by Colin Cotterill
Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution?
a bit of postscript, I can't speak to the documentation but I tried this as far as creating a new auditor table, and the function and trigger to do this and it worked fine on a test VM. I didn't go so far as to write the query to find them but it should be doable. I might play with it some more if I have some time. On Thu, May 21, 2015 at 1:56 PM, Tony Bandy to...@ohionet.org wrote: Hi all, Rogan, Appreciate the update….but not being a developer or SQL person, I was a little lost after the second sentence. J If something like this would get done, do you think this could be part of the documentation, etc? --Tony Tony Bandy to...@ohionet.org OHIONET 1500 West Lane Ave. Columbus, OH 43221-3975 614-484-1074 (Direct) 614-486-2966 x19 *From:* Open-ils-general [mailto: open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Rogan Hamby *Sent:* Thursday, May 21, 2015 1:49 PM *To:* Evergreen Discussion Group *Subject:* Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution? Hi Tony, I've never done this but as I hope SCLENDS moves to authorities in the not too distant future I'm interested in this topic a lot. If I remember correctly when a MARC record gets updated the old metabib.real_full_rec entries get deleted and new ones are entered. I would be tempted to create a conditional auditor trigger that only write entries for the headings fields so that it's not a huge auditor table. I've not done that but some quick googling showed up examples of it. It would be a fun experiment if nothing else. Then it would be easy to write a sql report to get distinct records from those whose inserted IDs (current metabib) are different from the audited ones and then export just those records. On Thu, May 21, 2015 at 1:04 PM, Tony Bandy to...@ohionet.org wrote: Hello all, At COOL, we’ve recently started authority control with BSLW. We have had our entire DB cleaned up and are getting ready to start the quarterly updates. In this, we will be sending them new bibs that have been added to the system for headings cleanup. However, we are also considering sending edited bibs as well. This would be bib records that were authorized and cleaned up, but have since been overlaid or updated. The biggest issue we are having is how to do this. While the edit date in the bib is a starting point, we really only want to send bibs whose headings have changed, not other values in the record. The question is: How? We’ve looked at the auditing tables as a starting point, but am thinking there might be a better solution: - Initial thoughts: 1.Using PGAdmin, we can extract a list of TCN’s that have been modified (edited) since our last full DB dump. 2. Using this list, extract bibs in MARC format from the system. 3. Using MARC Compare (found in Marc Edit 6.x) I can compare these bibs with the original cleaned up records from BSLW and get a list of changed fields. (I’ve done a sample file this am) 4. This solution actually works to scan fields by hand for changes. 5. However, with MARC Compare the records have to be in order or everything falls apart. (Plus if you have a ton-o-records, this can prove time consuming). - Solution? So my proposed solution is to write a custom PERL script to take original bibs and edited bibs, extract them down and compare headings in each of the two files, sending output out (via TCN’s) of those bibs whose headings fields have changed (such as the 100's, 400's, 600's, 700-740's as examples). Once I have the TCN’s, it would be easy to dump these out of the system for cleanup by BSLW. - My question is: Has this been done before? (I don’t want to reinvent the wheel). Is there a better way that someone else has come up with to do this? I’ve been digging around http://perldoc.perl.org/File/Compare.html this am as well as http://marcpm.sourceforge.net/tutorial.pdf, and https://metacpan.org/pod/MARC::Record and I think this would be do-able. I’m certainly not a developer, but have written perl scripts in the past….so this would be fun to try. Any thoughts? --Tony Tony Bandy to...@ohionet.org OHIONET 1500 West Lane Ave. Columbus, OH 43221-3975 614-484-1074 (Direct) 614-486-2966 x19 -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis
Re: [OPEN-ILS-GENERAL] Conference Transportation
+1 on the private airline and Evergreen State College ILS. So, +2 On Tue, May 26, 2015 at 2:37 PM, McCanna, Terran tmcca...@georgialibraries.org wrote: There's also Evergreen State College up in Olympia - we ought to convince them to switch to the Evergreen ILS! http://evergreen.edu/ Terran McCanna PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, GA 30345 404-235-7138 tmcca...@georgialibraries.org - Original Message - From: Buzzy Nielsen bu...@hoodriverlibrary.org To: open-ils-general@list.georgialibraries.org Sent: Tuesday, May 26, 2015 2:22:41 PM Subject: Re: [OPEN-ILS-GENERAL] Conference Transportation Ha, nice! I forgot about them. I will say, however, that I'm not sure we want to be associated with that particular airline. http://www.oregonlive.com/business/index.ssf/2013/03/oregon_justice_dept_examines_w.html It is a cool air museum, by the way, if anyone comes back this way. We've got a pretty decent one in Hood River, too. http://waaamuseum.org/ Cheers! Buzzy Library Director Hood River County Library District 502 State Street Hood River, Oregon 97031 541-387-7062 http://hoodriverlibrary.org On 05/26/2015 10:58 AM, Jeff Klapes wrote: After the conference (which was great, by the way) my partner and I spent a week enjoying Oregon's beautiful scenery. I'm sure the Oregonians are already aware of this, but we came across this plane at one of the air museums. I didn't realize the open-source community owned a 747! Perhaps for next year's conference, Buzzy could arrange an air charter? :-) Cheers, -- Jeff Klapes kla...@noblenet.org Head of Reference Services 781-246-6334 x6565 Lucius Beebe Memorial Library, 345 Main St, Wakefield, MA 01880 Where Wakefield Connects www.wakefieldlibrary.org ___ I'm currently reading Karpathia by Mathias Menegoz and Six and a half sins by Colin Cotterill -- Ruth Frasur Director of the Historic(ally Awesome) Hagerstown - Jefferson Township Library 10 W. College Street in Hagerstown, Indiana (47346) p (765) 489-5632; f (765) 489-5808 Our Kickin' Website http://hagerstownlibrary.org Our Rockin' Facebook Page http://facebook.com/hjtplibrary and Stuff I've Read http://pinterest.com/hjtplibrary/ruth-reads/
Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution?
We can talk off list if you want. I don't know if this is something everyone would be interested in or not. It would need a bit of work and testing. What I put in in the trigger for conditional testing isn't very robust (it's just a proof of functionality). I did wite a quick SQL report and it worked as well. On Tue, May 26, 2015 at 2:20 PM, Tony Bandy to...@ohionet.org wrote: Thanks Rogan, this would be something I think a lot of Evergreen libraries would be interested in pursuing…. --Tony Tony Bandy to...@ohionet.org OHIONET 1500 West Lane Ave. Columbus, OH 43221-3975 614-484-1074 (Direct) 614-486-2966 x19 *From:* Open-ils-general [mailto: open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Rogan Hamby *Sent:* Tuesday, May 26, 2015 2:05 PM *To:* Evergreen Discussion Group *Subject:* Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution? a bit of postscript, I can't speak to the documentation but I tried this as far as creating a new auditor table, and the function and trigger to do this and it worked fine on a test VM. I didn't go so far as to write the query to find them but it should be doable. I might play with it some more if I have some time. On Thu, May 21, 2015 at 1:56 PM, Tony Bandy to...@ohionet.org wrote: Hi all, Rogan, Appreciate the update….but not being a developer or SQL person, I was a little lost after the second sentence. J If something like this would get done, do you think this could be part of the documentation, etc? --Tony Tony Bandy to...@ohionet.org OHIONET 1500 West Lane Ave. Columbus, OH 43221-3975 614-484-1074 (Direct) 614-486-2966 x19 *From:* Open-ils-general [mailto: open-ils-general-boun...@list.georgialibraries.org] *On Behalf Of *Rogan Hamby *Sent:* Thursday, May 21, 2015 1:49 PM *To:* Evergreen Discussion Group *Subject:* Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution? Hi Tony, I've never done this but as I hope SCLENDS moves to authorities in the not too distant future I'm interested in this topic a lot. If I remember correctly when a MARC record gets updated the old metabib.real_full_rec entries get deleted and new ones are entered. I would be tempted to create a conditional auditor trigger that only write entries for the headings fields so that it's not a huge auditor table. I've not done that but some quick googling showed up examples of it. It would be a fun experiment if nothing else. Then it would be easy to write a sql report to get distinct records from those whose inserted IDs (current metabib) are different from the audited ones and then export just those records. On Thu, May 21, 2015 at 1:04 PM, Tony Bandy to...@ohionet.org wrote: Hello all, At COOL, we’ve recently started authority control with BSLW. We have had our entire DB cleaned up and are getting ready to start the quarterly updates. In this, we will be sending them new bibs that have been added to the system for headings cleanup. However, we are also considering sending edited bibs as well. This would be bib records that were authorized and cleaned up, but have since been overlaid or updated. The biggest issue we are having is how to do this. While the edit date in the bib is a starting point, we really only want to send bibs whose headings have changed, not other values in the record. The question is: How? We’ve looked at the auditing tables as a starting point, but am thinking there might be a better solution: - Initial thoughts: 1.Using PGAdmin, we can extract a list of TCN’s that have been modified (edited) since our last full DB dump. 2. Using this list, extract bibs in MARC format from the system. 3. Using MARC Compare (found in Marc Edit 6.x) I can compare these bibs with the original cleaned up records from BSLW and get a list of changed fields. (I’ve done a sample file this am) 4. This solution actually works to scan fields by hand for changes. 5. However, with MARC Compare the records have to be in order or everything falls apart. (Plus if you have a ton-o-records, this can prove time consuming). - Solution? So my proposed solution is to write a custom PERL script to take original bibs and edited bibs, extract them down and compare headings in each of the two files, sending output out (via TCN’s) of those bibs whose headings fields have changed (such as the 100's, 400's, 600's, 700-740's as examples). Once I have the TCN’s, it would be easy to dump these out of the system for cleanup by BSLW. - My question is: Has this been done before? (I don’t want to reinvent the wheel). Is there a better way that someone else has come up with to do this? I’ve been digging around http://perldoc.perl.org/File/Compare.html this am as well as
Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution?
In our previous ILS we sent newly added bibs and edited bibs out for authority control on a monthly basis. We are now using Backstage and had them start with all bibs added between 11/1/2012 and 12/31/2014. We are now sending new bibs quarterly. I would also like to include edited/overlayed bibs with the quarterly file so I’m interested in how to find/include these. I believe our quarterly processing cost is flat rate based on an average number of records so we could send records with any edits. Janet Janet Schrader Bibliographic Services Supervisor C/W MARS, Inc. 67 Millbrook Street, Suite 201 Worcester, MA 01606 Tel: 508-755-3323 ext. 25 FaX: 508-757-7801 jschra...@cwmars.orgmailto:jschra...@cwmars.org From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan Hamby Sent: Tuesday, May 26, 2015 2:41 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution? We can talk off list if you want. I don't know if this is something everyone would be interested in or not. It would need a bit of work and testing. What I put in in the trigger for conditional testing isn't very robust (it's just a proof of functionality). I did wite a quick SQL report and it worked as well. On Tue, May 26, 2015 at 2:20 PM, Tony Bandy to...@ohionet.orgmailto:to...@ohionet.org wrote: Thanks Rogan, this would be something I think a lot of Evergreen libraries would be interested in pursuing…. --Tony Tony Bandy to...@ohionet.orgmailto:to...@ohionet.org OHIONET 1500 West Lane Ave. Columbus, OH 43221-3975 614-484-1074tel:614-484-1074 (Direct) 614-486-2966 x19tel:614-486-2966%20x19 From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.orgmailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan Hamby Sent: Tuesday, May 26, 2015 2:05 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution? a bit of postscript, I can't speak to the documentation but I tried this as far as creating a new auditor table, and the function and trigger to do this and it worked fine on a test VM. I didn't go so far as to write the query to find them but it should be doable. I might play with it some more if I have some time. On Thu, May 21, 2015 at 1:56 PM, Tony Bandy to...@ohionet.orgmailto:to...@ohionet.org wrote: Hi all, Rogan, Appreciate the update….but not being a developer or SQL person, I was a little lost after the second sentence. ☺ If something like this would get done, do you think this could be part of the documentation, etc? --Tony Tony Bandy to...@ohionet.orgmailto:to...@ohionet.org OHIONET 1500 West Lane Ave. Columbus, OH 43221-3975 614-484-1074tel:614-484-1074 (Direct) 614-486-2966 x19tel:614-486-2966%20x19 From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.orgmailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Rogan Hamby Sent: Thursday, May 21, 2015 1:49 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Authority Control Questions-Maybe a Solution? Hi Tony, I've never done this but as I hope SCLENDS moves to authorities in the not too distant future I'm interested in this topic a lot. If I remember correctly when a MARC record gets updated the old metabib.real_full_rec entries get deleted and new ones are entered. I would be tempted to create a conditional auditor trigger that only write entries for the headings fields so that it's not a huge auditor table. I've not done that but some quick googling showed up examples of it. It would be a fun experiment if nothing else. Then it would be easy to write a sql report to get distinct records from those whose inserted IDs (current metabib) are different from the audited ones and then export just those records. On Thu, May 21, 2015 at 1:04 PM, Tony Bandy to...@ohionet.orgmailto:to...@ohionet.org wrote: Hello all, At COOL, we’ve recently started authority control with BSLW. We have had our entire DB cleaned up and are getting ready to start the quarterly updates. In this, we will be sending them new bibs that have been added to the system for headings cleanup. However, we are also considering sending edited bibs as well. This would be bib records that were authorized and cleaned up, but have since been overlaid or updated. The biggest issue we are having is how to do this. While the edit date in the bib is a starting point, we really only want to send bibs whose headings have changed, not other values in the record. The question is: How? We’ve looked at the auditing tables as a starting point, but am thinking there might be a better solution: - Initial thoughts: 1.Using PGAdmin, we can extract a list of TCN’s that have been modified (edited) since our last full DB dump. 2. Using this list, extract bibs in MARC format from
[OPEN-ILS-GENERAL] Correction for Release Manager Plans/Goals for 2.9
Hi, all! Hat tip to Dan Wells for pointing out a typo/thinko in my timeline for the 2.9 release. I have the date for the release candidate as August 2. That should be September 2. Cheers, Jason -- Jason Stephenson Assistant Director for Technology Services Merrimack Valley Library Consortium 1600 Osgood ST, Suite 2094 North Andover, MA 01845 Phone: 978-557-5891 Email: jstephen...@mvlc.org