Re: [OPEN-ILS-GENERAL] Hello!
Right Dan, in retrospect, I should have learned more about how the PO files operate on Launchpad. In the future, it seems that translating using a downloaded copy of the PO file from Launchpad would be most effective; and then uploading it back. In this case, we'll pull a copy of the PO file to add strings for all the contents we can find in the local copy of opac.dtd that we'll be getting from the library's volunteer (yay for Hagaman Library, East Haven, CT!). More to come, thanks for helping us move in the right direction. -- Ben On 12/15/2010 04:42 PM, Dan Scott wrote: On 15 December 2010 14:47, Ben Shum bs...@biblio.org wrote: Hi Jose, One of our libraries had someone willing to translate Evergreen into Spanish. Because they only wanted to focus on OPAC translation to give patrons a Spanish version of the OPAC, we gave them a copy of the opac.dtd file from /openils/var/web/opac/locale/es-ES to work with. Once we get this file back, we're going to contribute its contents back to the Evergreen community. We're unsure if that'll mean we have to copy/paste contents back to Launchpad's translations or something... Hmm. How do you plan to merge that translation with the almost 60% of opac.dtd that has already been translated, according to https://translations.launchpad.net/evergreen/2.0/+lang/es ? Or was the copy of es-ES/opac.dtd that you sent to them from later than 2010-09-28? The nice thing about translating directly via an online service is that you can coordinate efforts to divide and conquer and not step on one another's toes too much. It's definitely good to be talking about these efforts on the list, hopefully we can still manage that coordination. Dan -- Benjamin Shum Open Source Software Coordinator Bibliomation, Inc. 32 Crest Road Middlebury, CT 06762 203-577-4070, ext. 113
[OPEN-ILS-GENERAL] Hold Cancellations
We have observed the following scenario. A patron's hold gets triggered. The patron is notified and we put the item on the hold shelf. Later, the patron goes on-line and cancels the hold. At this point, the item status still says On Hold Shelf. The item sits on the hold shelf because the staff is not warned that item is no longer wanted. The item doesn't show on a list of what's on the hold shelf - presumably because it has been cancelled. Is this the way it's supposed to happen? Is there a work-around so that the staff is notified that the patron has cancelled the hold? James Wagner Technical Services Co-ordinator Lincoln Public Library Vineland ON 905-563-2799 ext 216 wag...@lincoln.library.on.ca
Re: [OPEN-ILS-GENERAL] Question
That is great news Jeremy, thank you and thank you for the link. Have a wonderful day Georgette Rogers Circulation Supervisor Liberty Lake Municipal Library 23123 E Mission Ave Liberty Lake, WA 99019 509-435-0778 1-866-729-8507 From: open-ils-general-boun...@list.georgialibraries.org [open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Jeremy Buhler [jeremy.buh...@gmail.com] Sent: Thursday, December 16, 2010 11:37 AM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Question Hi Georgette, The short answer is yes. There are several customizable limits including number of items out, number of overdue items, and total fine amount. More details are available in the draft manual for Evergreen 1.6 at http://docs.evergreen-ils.org/1.6/draft/html/lsa-group-penalty.html Jeremy -- Jeremy Buhler Trainer/Help Desk Specialist Sitka Evergreen Implementation On Thu, Dec 16, 2010 at 10:51 AM, Georgette Rogers grog...@libertylakewa.govmailto:grog...@libertylakewa.gov wrote: Hello I am doing some research about Evergreen to present to the heads of the city about possibly joining the Evergreen Community. As Circulation Supervisor, I would like to know please, if a patron has reached their maximum fee, will Evergreen automatically block thier card and the cards associated with them? Thank you, Georgette Georgette Rogers Circulation Supervisor Liberty Lake Municipal Library 23123 E Mission Ave Liberty Lake, WA 99019 509-435-0778 1-866-729-8507
Re: [OPEN-ILS-GENERAL] retrieving deleted records
Hi Kathryn, If you are using 1.6., you can find the record ID of an active record by opening the record and pointing your mouse at the phrase Record Summary. The phrase appears in the top left corner of the screen. Hover for just a moment, and the record ID will appear. If the record has already been deleted and you don't have the record ID, you can run a report of deleted items, and display the Record ID. Once you have the record ID, click Search -- Search for Record by Record ID. Enter the record ID in the pop up box. The deleted record should appear. If desired, you can also undelete the record. To undelete the record, click Actions for this Record -- Undelete Record. This action will undelete the record. Hope that helps. Sally On 12/16/2010 4:09 PM, Kathryn Riedener wrote: Can anyone tell me how to retrieve a record once it has been marked as deleted/inactive? I tried using the Title Control Number but that didn't find the record. Also, how do you find the Record ID of a particular record? Thanks. Kathryn -- Sally Fortin Educational Services Manager Equinox Software Inc. / Your Library's Guide to Open Source Tel:770-709-5572 Email: sfor...@esilibrary.com Fax:1-866-497-6390
[OPEN-ILS-GENERAL] New install problem with settings
We are a parish (think county) library with 5 branches trying to migrate from a vendor system into Evergreen. While our library materials will need to be assigned to the branches, our patron database is shared by all branches. Does anyone have experience with this setup who might tell us how the system should be configured so that this can happen? Thank you.
Re: [OPEN-ILS-GENERAL] retrieving deleted records
On Thu, Dec 16, 2010 at 4:09 PM, Kathryn Riedener kriede...@pls-net.org wrote: I tried using the Title Control Number but that didn't find the record. If you use the Search - Search for record by TCN menu option (instead of the TCN search in the embedded OPAC), then it should say something like this: AUTOGENERATED-3 is deleted. Show the deleted record anyway? OK Cancel -- Jason Etheridge | VP, Tactical Development | Equinox Software, Inc. / Your Library's Guide to Open Source | phone: 1-877-OPEN-ILS (673-6457) | email: ja...@esilibrary.com | web: http://www.esilibrary.com
Re: [OPEN-ILS-GENERAL] New install problem with settings
Our patrons are assigned to the parent organization (Killeen City Library System) so that they can check out at any of our locations. Materials are assigned to a shelving location, so they show up as Main Mystery or CMB Nonfiction. Does that make sense? Deanna Frazee Killeen City Library System 205 E. Church Ave. Killeen, TX 76541 254-501-8995 dfra...@ci.killeen.tx.us -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Vicki Reeves Sent: Thursday, December 16, 2010 3:32 PM To: Evergreen Discussion Group Subject: [OPEN-ILS-GENERAL] New install problem with settings We are a parish (think county) library with 5 branches trying to migrate from a vendor system into Evergreen. While our library materials will need to be assigned to the branches, our patron database is shared by all branches. Does anyone have experience with this setup who might tell us how the system should be configured so that this can happen? Thank you.
Re: [OPEN-ILS-GENERAL] New install problem with settings
I think so. If I used this, all of our patrons and all of our items would belong to the main branch and we would use the shelving location to show where each item is being housed as in 'Mid-City branch fiction' or 'East-Side Branch picture books'. Is that correct? If so, my next question is how does this affect circulation statistics? Would I still be able to ask for a count of items checked out at Mid-City branch? Thank you. On Thu, 2010-12-16 at 15:50 -0600, Deanna Frazee wrote: Our patrons are assigned to the parent organization (Killeen City Library System) so that they can check out at any of our locations. Materials are assigned to a shelving location, so they show up as Main Mystery or CMB Nonfiction. Does that make sense? Deanna Frazee Killeen City Library System 205 E. Church Ave. Killeen, TX 76541 254-501-8995 dfra...@ci.killeen.tx.us -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Vicki Reeves Sent: Thursday, December 16, 2010 3:32 PM To: Evergreen Discussion Group Subject: [OPEN-ILS-GENERAL] New install problem with settings We are a parish (think county) library with 5 branches trying to migrate from a vendor system into Evergreen. While our library materials will need to be assigned to the branches, our patron database is shared by all branches. Does anyone have experience with this setup who might tell us how the system should be configured so that this can happen? Thank you.
Re: [OPEN-ILS-GENERAL] New install problem with settings
We have 4 branches. Our patron cards work in any branch and we can pull statistics for each branch - circulation statistics as well as patron statistics. When patrons are registered they are assigned a home library. Sorry, I don't know the hows and wherefores of the setup but I know it works. Mary Toma South Central Regional Library 160 Main Street Box 1540 Winkler, MB R6W 4B4 204-325-5864 204-822-4092 head...@scrlibrary.mb.ca -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Vicki Reeves Sent: December 16, 2010 4:01 PM To: Deanna Frazee Cc: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] New install problem with settings I think so. If I used this, all of our patrons and all of our items would belong to the main branch and we would use the shelving location to show where each item is being housed as in 'Mid-City branch fiction' or 'East-Side Branch picture books'. Is that correct? If so, my next question is how does this affect circulation statistics? Would I still be able to ask for a count of items checked out at Mid-City branch? Thank you. On Thu, 2010-12-16 at 15:50 -0600, Deanna Frazee wrote: Our patrons are assigned to the parent organization (Killeen City Library System) so that they can check out at any of our locations. Materials are assigned to a shelving location, so they show up as Main Mystery or CMB Nonfiction. Does that make sense? Deanna Frazee Killeen City Library System 205 E. Church Ave. Killeen, TX 76541 254-501-8995 dfra...@ci.killeen.tx.us -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Vicki Reeves Sent: Thursday, December 16, 2010 3:32 PM To: Evergreen Discussion Group Subject: [OPEN-ILS-GENERAL] New install problem with settings We are a parish (think county) library with 5 branches trying to migrate from a vendor system into Evergreen. While our library materials will need to be assigned to the branches, our patron database is shared by all branches. Does anyone have experience with this setup who might tell us how the system should be configured so that this can happen? Thank you.
Re: [OPEN-ILS-GENERAL] Hold Cancellations
Hi James, What version of Evergreen are you running? This can be managed by periodically running a report on items that are currently on the holds shelf, so your staff can pull items that no longer belong. Also, I see that this is in the Evergreen 2.0 feature list at http://evergreen-ils.org/dokuwiki/doku.php?id=feature_list_2_0 : The system supports a Clear Hold Shelf process. First, it removes holds from items that have expired on the hold shelf, and generates a report (aka clear hold shelf report) listing items to be cleared from hold shelf. Then staff can print the list, go out and physically pull the items off of the hold shelf. Next, staff scan the items in EG to either reset the items to the correct shelving location, capture the next hold or put the items in transit to the correct owning location. So while it has to be managed manually at this point (by creating reports), we can look forward to this feature in a future upgrade. Hope that helps! Chris Sharp PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 csh...@georgialibraries.org http://pines.georgialibraries.org/ From: James Wagner wag...@lincoln.library.on.ca To: open-ils-general@list.georgialibraries.org Sent: Thursday, December 16, 2010 3:35:58 PM Subject: [OPEN-ILS-GENERAL] Hold Cancellations We have observed the following scenario. A patron's hold gets triggered. The patron is notified and we put the item on the hold shelf. Later, the patron goes on-line and cancels the hold. At this point, the i tem status still says On Hold Shelf. The item sits on the hold shelf because the staff is not w arned that item is no longer wanted. The i tem doesn’t show on a list of what’s on the hold shelf – presumably because it has been cancelled. Is this the way it's supposed to happen ? Is there a work-around so that the staff is notified that the patron has cancelled the hold ? James Wagner Technical Services Co-ordinator Lincoln Public Library Vineland ON 905-563-2799 ext 216 wag...@lincoln.library.on.ca
[OPEN-ILS-GENERAL] Problems with the org chart
Vicki already posted about this problem we are having, but I have been
banging on it a bit longer and have more details to post that might
help.
Seems the whole org chart bit is VERY brittle, anything goes wrong and
evergreen is just dead and apparently unfixable by mortals.
What we want for an org chart:
System Has all patrons
Branch Owns books
What evergreen wants
Consortium Doesn't own anything
System Doesn't own anything
Branch Owns books and users
Any attempt to build an org chart without System at the second level
fails so for now I'm just going with it and leaving it as a dead level.
Almost all attempts end up with throwing an error when
running /openils/bin/autogen.sh like:
Updating OrgTree HTML
Can't call method depth on an undefined value at
org_tree_html_options.pl line 56.
Once that appears there is no way back. Reversing whatever change
resulted in it's appearance does not make it go away, only nuking the
site from orbit and starting over helps.
By being very careful I can almost get there.
$ osrf_ctl.sh -l -a stop_all
Open-ILS/src/sql/Pg$ ./build-db.sh params omitted
$ psql -h dbserver --user evergreen
password
Welcome to psql 8.3.12 (server 8.3.9), the PostgreSQL interactive
terminal.
evergreen=# BEGIN;
evergreen=# DELETE FROM actor.org_unit WHERE id 1;
evergreen=# DELETE FROM actor.org_address WHERE id 1;
evergreen=# DELETE FROM actor.workstation WHERE owning_lib 1;
evergreen=# COMMIT;
evergreen=#
That was from the wiki scratchpad:setup
$ osrf_ctl.sh -l -a start_all
$ /openils/bin/autogen.sh -c /openils/conf/opensrf_core.xml -u
From a browser navigate to http://{hostname}/cgi-bin/config.cgi
Pick org unit types and update so system can have users.
Again, autogen succeeds.
Now remove can have users from branch and try to update. It stays
checked. For a clue, select so that systems can have books. That also
works. Now try to uncheck it. Nope, that too is unreversable.
Change the name of the default top level entry from CONS and autogen
will die every time. And again, it is an unreversable mistake as
putting it back won't get autogen running. Nuke the site from orbit
time.
And a possibly related problem is showing in the staff client. After a
nuke I'm deleting .openils/open_ils_staff_client/ just to be sure. No
matter, I am consistently getting a dialog saying TypeError:
g.data.hash.aout[obj.ou_type()] is undefined on every launch. However
it doesn't appear fatal since it does launch and everything appears to
work. It started appearing after my first wipe reload of the database
and has been consistent since then. Obviously something on the front
end system also needs to be wiped but I am failing to find a document
saying what to wipe.
Really hope a complete wipe of /openils isn't required for every attempt
since so many appear to be required.
signature.asc
Description: This is a digitally signed message part
Re: [OPEN-ILS-GENERAL] Hold Cancellations
Hi Karen, Thanks for the clarification. In my not-so-careful reading I was mistaking expired for cancelled. In any case, this can still be handled either by reports or in the way you mention. Chris Sharp PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 csh...@georgialibraries.org http://pines.georgialibraries.org/ From: Karen Daniel kar...@kcls.org To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org Sent: Thursday, December 16, 2010 5:26:59 PM Subject: Re: [OPEN-ILS-GENERAL] Hold Cancellations Currently in 2.0, the Clear Hold Shelf report does not list holds that have been canceled by staff or patrons. The report only lists holds that have reached their Shelf Expire Time. Our workaround for the time being is to manually look at the hold slips to see if any of them have a date that is too old. Karen Karen Daniel Circulation Coordinator King County Library System 425-369-3471 kar...@kcls.org From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Sharp, Chris Sent: Thursday, December 16, 2010 2:23 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Hold Cancellations Hi James, What version of Evergreen are you running? This can be managed by periodically running a report on items that are currently on the holds shelf, so your staff can pull items that no longer belong. Also, I see that this is in the Evergreen 2.0 feature list at http://evergreen-ils.org/dokuwiki/doku.php?id=feature_list_2_0 : The system supports a Clear Hold Shelf process. First, it removes holds from items that have expired on the hold shelf, and generates a report (aka clear hold shelf report) listing items to be cleared from hold shelf. Then staff can print the list, go out and physically pull the items off of the hold shelf. Next, staff scan the items in EG to either reset the items to the correct shelving location, capture the next hold or put the items in transit to the correct owning location. So while it has to be managed manually at this point (by creating reports), we can look forward to this feature in a future upgrade. Hope that helps! Chris Sharp PINES Program Manager Georgia Public Library Service 1800 Century Place, Suite 150 Atlanta, Georgia 30345 (404) 235-7147 csh...@georgialibraries.org http://pines.georgialibraries.org/ From: James Wagner wag...@lincoln.library.on.ca To: open-ils-general@list.georgialibraries.org Sent: Thursday, December 16, 2010 3:35:58 PM Subject: [OPEN-ILS-GENERAL] Hold Cancellations We have observed the following scenario. A patron's hold gets triggered. The patron is notified and we put the item on the hold shelf. Later, the patron goes on-line and cancels the hold. At this point, the item status still says On Hold Shelf. The item sits on the hold shelf because the staff is not warned that item is no longer wanted. The item doesn’t show on a list of what’s on the hold shelf – presumably because it has been cancelled. Is this the way it's supposed to happen? Is there a work-around so that the staff is notified that the patron has cancelled the hold? James Wagner Technical Services Co-ordinator Lincoln Public Library Vineland ON 905-563-2799 ext 216 wag...@lincoln.library.on.ca
Re: [OPEN-ILS-GENERAL] Problems with the org chart
Hi John,
Sounds like you've done a great job troubleshooting what has to have been a
frustrating problem!
What evergreen wants
Consortium Doesn't own anything
System Doesn't own anything
Branch Owns books and users
Evergreen works this way because it was initially designed for PINES, in which
this is the setup. I'm honestly not sure what sorts of improvements have been
added in the last couple of versions that might accommodate the setup you're
looking for.
From a browser navigate to http://{hostname}/cgi-bin/config.cgi
Pick org unit types and update so system can have users.
Again, autogen succeeds.
In version 1.4 and forward, this can (should?) be done from within the staff
client (Admin - Server Settings - Organizational Unit Types/Organizational
Units).
We have also had problems undoing org_unit changes in our test environments.
They have required a bit of database work (that I have not seen documentation
for).
If you do want someone to walk through this with you, I would suggest going to
the #evergreen chat room: http://webchat.freenode.net/?channels=evergreen , or
asking your technical questions on the Open-ILS-Dev list:
http://libmail.georgialibraries.org/mailman/listinfo/open-ils-dev
Hope that's helpful!
Chris
Chris Sharp
PINES Program Manager
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csh...@georgialibraries.org
http://pines.georgialibraries.org/
- Original Message -
From: John Morris jmor...@beau.org
To: open-ils-general@list.georgialibraries.org
Sent: Thursday, December 16, 2010 5:50:38 PM
Subject: [OPEN-ILS-GENERAL] Problems with the org chart
Vicki already posted about this problem we are having, but I have been
banging on it a bit longer and have more details to post that might
help.
Seems the whole org chart bit is VERY brittle, anything goes wrong and
evergreen is just dead and apparently unfixable by mortals.
What we want for an org chart:
System Has all patrons
Branch Owns books
What evergreen wants
Consortium Doesn't own anything
System Doesn't own anything
Branch Owns books and users
Any attempt to build an org chart without System at the second level
fails so for now I'm just going with it and leaving it as a dead
level.
Almost all attempts end up with throwing an error when
running /openils/bin/autogen.sh like:
Updating OrgTree HTML
Can't call method depth on an undefined value at
org_tree_html_options.pl line 56.
Once that appears there is no way back. Reversing whatever change
resulted in it's appearance does not make it go away, only nuking the
site from orbit and starting over helps.
By being very careful I can almost get there.
$ osrf_ctl.sh -l -a stop_all
Open-ILS/src/sql/Pg$ ./build-db.sh params omitted
$ psql -h dbserver --user evergreen
password
Welcome to psql 8.3.12 (server 8.3.9), the PostgreSQL interactive
terminal.
evergreen=# BEGIN;
evergreen=# DELETE FROM actor.org_unit WHERE id 1;
evergreen=# DELETE FROM actor.org_address WHERE id 1;
evergreen=# DELETE FROM actor.workstation WHERE owning_lib 1;
evergreen=# COMMIT;
evergreen=#
That was from the wiki scratchpad:setup
$ osrf_ctl.sh -l -a start_all
$ /openils/bin/autogen.sh -c /openils/conf/opensrf_core.xml -u
From a browser navigate to http://{hostname}/cgi-bin/config.cgi
Pick org unit types and update so system can have users.
Again, autogen succeeds.
Now remove can have users from branch and try to update. It stays
checked. For a clue, select so that systems can have books. That also
works. Now try to uncheck it. Nope, that too is unreversable.
Change the name of the default top level entry from CONS and autogen
will die every time. And again, it is an unreversable mistake as
putting it back won't get autogen running. Nuke the site from orbit
time.
And a possibly related problem is showing in the staff client. After a
nuke I'm deleting .openils/open_ils_staff_client/ just to be sure. No
matter, I am consistently getting a dialog saying TypeError:
g.data.hash.aout[obj.ou_type()] is undefined on every launch. However
it doesn't appear fatal since it does launch and everything appears to
work. It started appearing after my first wipe reload of the
database
and has been consistent since then. Obviously something on the front
end system also needs to be wiped but I am failing to find a document
saying what to wipe.
Really hope a complete wipe of /openils isn't required for every
attempt
since so many appear to be required.
Re: [OPEN-ILS-GENERAL] Problems with the org chart
On Thu, 2010-12-16 at 19:39 -0500, Sharp, Chris wrote: Evergreen works this way because it was initially designed for PINES, in which this is the setup. I'm honestly not sure what sorts of improvements have been added in the last couple of versions that might accommodate the setup you're looking for. Which wouldn't be a problem if a) It were known what the rules really are so I'd know what I have to settle for and b) if touching things weren't so fatal. Kinda shaking my confidence in EG in general knowing there are user exposed controls that must be adjusted yet are one wrong mouse click from a 100% dead and unrecoverable installation. And I haven't even started importing data yet. I know Thou Shalt Make Backups, but this really kicks it up a notch. And it gets worse. Ok, I'll accept a three level system, but is it possible to change the name of the Consortium from CONS? Can it be done? I got really steamed a while ago and dug into Open-ILS/src/sql/Pg/950.data.seed-values.sql and tried having the system just initialize a different value instead of CONS. build-db.sh ran normally and I could see the new default value in the web interface, however autogen.sh blew up same as if I had changed it post install. And worse still. I'm now increasingly of the belief that there are THREE possibilties when making changes to the org chart. 1. It works 2. Flaming death. 3. It might work... or it might result in flaming death. I now have a situation where the exact same sequence of commands have the flaming death happen at a different step. Start a fresh load of the db. Run that script to whack away the examples. Now look at the org unit types. Delete the bottom one. Run autogen. Reload that page and delete the bottom one. Run autogen. I have had flaming death happen after the first delete, the second delete and made it all the way a few times. Normal bugs are bad, non deterministic ones are a horror. In version 1.4 and forward, this can (should?) be done from within the staff client (Admin - Server Settings - Organizational Unit Types/Organizational Units). Perhaps, but tried that first. Kept stepping on a different land mine. Whichever of the example org codes the staff client gets associated to can never be removed. I'm guessing from a misguided attempt to avoid an incoherent database when actor.workstation would be left with a reference to a non-existent id. So I dug around the wiki and found the web interface and the advice to wipe the examples. We have also had problems undoing org_unit changes in our test environments. They have required a bit of database work (that I have not seen documentation for). Have tried manually probing the database, most attempts to change anything that way just end up with autogen going into it's I'm going to keep dying now until you nuke the db and start over. So Nyeh! routine. So is there a way to actually fix it? And while pondering new stuff to try I have been running the upgrades to get more current. 1.6.0.6 stopped the oddball error in the staff client. At 1.6.0.8 now and still no relief on the autogen death bug. signature.asc Description: This is a digitally signed message part
Re: [OPEN-ILS-GENERAL] Problems with the org chart
Ah, using the power of reading backwards, I see that you did provide us with some of these details in your first message. Sorry about that. I'd still like to see the contents of your actor.org_unit and actor.org_unit_type tables. We probably need to add some context to the official documentation at http://docs.evergreen-ils.org/1.6/draft/html/serveradministration.html#orgunitsandtypes So: Are you trying to use the existing actor.org_unit_type named System (with depth = 1 and parent = 0) as the Org Unit Type for the Org Unit at the top level of your hierarchy? If so, no dice: that means that you'll have an Org Unit with a depth of 1 at the depth 0, and things blow up. My suggestion would be to change the name of the out-of-the-box Org Unit Type named Consortium to System, and to change the name of the out-of-the-box Org Unit Type named System to Branch, and blow away the other org unit types. Here's a SQL recipe for setting up something that seems to be what you want using an out-of-the-box database schema (from trunk, but should be relatively easy to adjust to 1.6): -- Delete all but the core org unit BEGIN; DELETE FROM actor.org_unit WHERE id 1; DELETE FROM actor.org_address WHERE id 1; DELETE FROM actor.workstation WHERE owning_lib 1; COMMIT; -- Clean up our org unit types, in preparation for creating the org unit hierarchy we want BEGIN; DELETE FROM actor.org_unit_type WHERE id 2; UPDATE actor.org_unit_type SET name = 'System', can_have_users = TRUE WHERE id = 1; UPDATE actor.org_unit_type SET name = 'Branch', can_have_users = TRUE, can_have_vols = TRUE WHERE id = 2; COMMIT; -- Create a branch that hangs off the only remaining parent branch -- We'll point at the org address with ID 2, which we'll create within this transaction BEGIN; INSERT INTO actor.org_unit (parent_ou, ou_type, ill_address, holds_address, mailing_address, billing_address, shortname, name) VALUES (1, 2, 2, 2, 2, 2, 'MYBRANCH', 'My Branch'); -- Find out what ID was assigned to the new branch SELECT id FROM actor.org_unit WHERE shortname = 'MYBRANCH'; -- Result is 101 -- Create our required org address, pointing back to org unit 101 INSERT INTO actor.org_address (id, org_unit, street1, city, state, country, post_code) VALUES (2, 101, 'Fake Street', 'Fake', 'Fake', 'Fake', 'FOO BAR'); COMMIT; After this, autogen.sh runs and I can register the workstation and start adding items to the new branch; the two-level hierarchy seems to be working fine in that limited testing. I'm doing this with a stock install of Evergreen trunk, so you might need to adjust slightly if columns have been added to any of the tables where I'm inserting rows compared to your version. Dan On 16 December 2010 23:06, Dan Scott d...@coffeecode.net wrote: On Thu, Dec 16, 2010 at 09:25:49PM -0600, John Morris wrote: On Thu, 2010-12-16 at 19:39 -0500, Sharp, Chris wrote: Evergreen works this way because it was initially designed for PINES, in which this is the setup. I'm honestly not sure what sorts of improvements have been added in the last couple of versions that might accommodate the setup you're looking for. Which wouldn't be a problem if a) It were known what the rules really are so I'd know what I have to settle for and b) if touching things weren't so fatal. Kinda shaking my confidence in EG in general knowing there are user exposed controls that must be adjusted yet are one wrong mouse click from a 100% dead and unrecoverable installation. And I haven't even started importing data yet. I know Thou Shalt Make Backups, but this really kicks it up a notch. Well - they're exposed, but you can't change anything if you don't have the appropriate permissions (which require at least administrator access) - unless you're talking about the config.cgi set of tools, which are both heavily deprecated (even removed from 2.0) and which come with a warning that they should be protected from access. For the new age library hierarchy editing tools, I took away the required permissions from everybody in our consortium on the day we went live and one of our local administrators made their library a child of itself and brought the system back down for a while. Heh. So, given the readily available virtual images and the ability to install as many copies of Evergreen wherever you want, the idea is that you should be able to practice these steps and gain knowledge before you go into production. Yes, it's a pain point, but you set up the library hierarchy once and then (if anything) just tweak it after that. Which is probably why anyone who has got past that point hasn't done much in the way of documenting what they did to get past that point. It would be great for a whiz-bang perfect UI to drop from the heavens, too, but it's not on my employer's priority list (we're live and investing in things we need), and I suspect it's not on most library's list of things they're willing to pay for or have their developers
Re: [OPEN-ILS-GENERAL] Problems with the org chart
On Thu, 2010-12-16 at 23:06 -0500, Dan Scott wrote: So, given the readily available virtual images and the ability to install as many copies of Evergreen wherever you want, the idea is that you should be able to practice these steps and gain knowledge before you go into production. But I don't even trust ME at this point. Uncheck a box, BOOM! Check it back and it is still dead and with no useful error message and bang on it all ya want and it is apparently determined to stay dead. Game over, reload the last savepoint. It's too bad you waited this long to ask for help; there might be something else going on in your configuration that we could help sort out - have you told us what error message autogen.sh blows up with? Does it blow up with a stock install of Evergreen? Well I had been avoiding the lists because during the install phase because I'm hoping to be forced to learn enough about how this sucker works to be able to maintain it. Maybe even patch it if needed, my OO perl skills are still a bit weak but I'm working on that. But this issue was just driving me nuts. There is a complete dump posted today of the errors. But now the story goes really wierd. Poked around some more. The kaboom was always happening in the same place, same line number. Ok, where is that. Tracked it down to /openils/bin/org_tree_html_options.pl so if it won't yield useful info it is time to add some debug code of my own. Not exactly. Added a couple of print statements and now it works every time. Took em back out, still works. Diff it with the copy that came out of the tarball, same file. The md5sum matches the one captured on a backup server from a month ago from before I messed with it today. It hasn't changed between versions 1.6.0.3 and 1.6.0.8 so none of the point updates I have been getting around to today should have made any difference in that file. Never heard of a hardware glitch producing such a consistent problem over days. So now what am I hunting? I have a dump of the database now with the org chart how I want it, but do I dare continue before figuring out what is actually going on? Do I nuke the database again and try to recreate the error? The install is in a pair of kvm virtual machines, postgres on one, everything else on the other. Both are running debian-lenny for AMD64. The physical host for both of them is also running lenny. The physical host is a basic 2U server based on an AMI MB with two sockets for a dozen AMD64 cores, 32GB of ram and a RAID1, nothing too exotic. The buildhost has been rock solid so far, installed everything last year and it has just sat in the rack and done it's thing, currently has 401 days uptime. signature.asc Description: This is a digitally signed message part
