Re: [OPEN-ILS-GENERAL] Upgrade Script for 2.6.4 to 2.7
On 2015-03-15, at 22:53 , Jayaraj JR jaya...@iisertvm.ac.in wrote:
As of now, we are already on Evergreen 2.6.4 version. In this context what
would be best way to upgrade to 2.7 series. Can we use
the upgrade script 2.6.3 to 2.7.0 here. If not what modifications are
necessary ?. If we upgrade to 2.6.7, will it cause further complexity
when upgrading to the 2.7 version.
Generally speaking, you need to examine your upgrade log and cross-reference
the major and minor schema upgrade scripts up to the version you’re upgrading
to. Then you should modify schema upgrade scripts to make custom versions that
include all the numbered schema upgrades that you need to apply and exclude all
the numbered schema updates that have already been applied.
Specifically for version 2.6.4, the 2.6.3-2.6.4 schema upgrade script includes
schema upgrades 0892, 0893, 0894, 0895.
The 2.6.3-2.7.0 upgrade script includes upgrades 0884, 0885, 0886, 0888, 0889,
but not any of the upgrades included in the 2.6.3-2.6.4. So, you should be able
to run the 2.6.3-2.7.0 schema upgrade script against your version without
trouble.
If you look at the 2.7.0-2.7.1 schema upgrade script, it has schema upgrades
0892, 0893, 0894, 0895, which is equivalent to the 2.6.3-2.6.4 script. So, you
will need to modify the 2.7.0-2.7.1 script to exclude all those upgrades, but
you probably want to keep the 2.7.1 version stamp, so your modified 2.7.0-2.7.1
script will look like this:
--Upgrade Script for 2.7.0 to 2.7.1
\set eg_version '''2.7.1'''
BEGIN;
INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.7.1',
:eg_version);
COMMIT;
From then on you should just be fine with the rest of the 2.7 series minor
version schema upgrade scripts, but check for yourself.
When you’re done upgrading, your goal is to make sure that the schema is in
accordance with it’s expected state for that particular version. If your
database ends up missing any of these numbered upgrades, you may later discover
the consequences in surprising ways.
Also, keep in mind what Galen recommended earlier in this thread: checking
through all of the point schema upgrades you plan to apply and seeing if there
are any redundant bib reingests that you can skip can save you some time.
Aleksey Lazar
IS Developer and Integrator - PALS
http://www.mnpals.org/
[OPEN-ILS-GENERAL] Acquisitions Workflow Request
Greetings, I have a request from one of the library systems in our consortium...The library started using Acquisitions in January, and is the only one of our libraries using it. They're a 7-branch (plus bookmobile) system with centralized acquisitions and cataloging. They're also using EDI with Baker Taylor (and, soon, Bound to Stay Bound). We're on Evergreen 2.7. As they are settling in with Acquisitions and refining their workflows and processes, they would like to talk on the phone with another library system with established Acquisitions workflows, preferably one similar to them--several branches, centralized acquisitions/cataloging, preferably using Baker Taylor EDI, and in the U.S. If your library, or one you work with, would be willing to talk with them, please let me know! Thanks, Debbie Debbie Luchenbill Missouri Evergreen Coordinator MOBIUS 111 E. Broadway, Ste. 220 Columbia, MO 65203 debo...@mobiusconsortium.org 573-234-4914/877-312-3517 http://libraries.missourievergreen.org http://mobiusconsortium.org
[OPEN-ILS-GENERAL] Permissions Questions
Hi, We would like to stop a specific Permission Group from forcing holds to the top of the queue and from being able to edit items. Which permissions control these? Thank you, Scott Scott Thomas, MLS Head of Information Technologies and Technical Services Scranton Public Library Lackawanna County Library System 2006 N. Main Ave. Scranton, PA 18508 Ph: 570-207-2379 Fx: 570-348-3020 Email: sc...@albright.orgmailto:sc...@albright.org
Re: [OPEN-ILS-GENERAL] Permissions Questions
We would like to stop a specific Permission Group from forcing holds to the top of the queue and from being able to edit items. Which permissions control these? Hi Scott, You're looking for UPDATE_HOLD_REQUEST_TIME -- Jason Etheridge | Community and Migration Manager | Equinox Software, Inc. / The Open Source Experts | phone: 1-877-OPEN-ILS (673-6457) | email: ja...@esilibrary.com | web: http://www.esilibrary.com
Re: [OPEN-ILS-GENERAL] Acquisitions Workflow Request
Hi Debbie, We have a library with branches that is similar to that, though they have BT do their cataloging for them, and my department (Bibliomation Database Services) loads the records to the catalog on their behalf. They have the same arrangement with Brodart. I’m cc’ing our librarian, so if she wishes to make contact with yours, they can hook up. Mary Mary Llewellyn Database Manager Bibliomation, Inc. 24 Wooster Ave. Waterbury, CT 06708 mllew...@biblio.org From: Open-ils-general [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Deborah Luchenbill Sent: Monday, March 16, 2015 3:06 PM To: Evergreen Discussion Group Subject: [OPEN-ILS-GENERAL] Acquisitions Workflow Request Greetings, I have a request from one of the library systems in our consortium...The library started using Acquisitions in January, and is the only one of our libraries using it. They're a 7-branch (plus bookmobile) system with centralized acquisitions and cataloging. They're also using EDI with Baker Taylor (and, soon, Bound to Stay Bound). We're on Evergreen 2.7. As they are settling in with Acquisitions and refining their workflows and processes, they would like to talk on the phone with another library system with established Acquisitions workflows, preferably one similar to them--several branches, centralized acquisitions/cataloging, preferably using Baker Taylor EDI, and in the U.S. If your library, or one you work with, would be willing to talk with them, please let me know! Thanks, Debbie Debbie Luchenbill Missouri Evergreen Coordinator MOBIUS 111 E. Broadway, Ste. 220 Columbia, MO 65203 debo...@mobiusconsortium.org 573-234-4914/877-312-3517 http://libraries.missourievergreen.org http://mobiusconsortium.org
