Open Source Integrated Library System

Evergreen on IRC

#evergreen Logs for Saturday, February 19th, 2011

< Friday, February 18th, 2011Raw Log FileSunday, February 20th, 2011 >
#TimeNickMessage
#01:47:45bencahill_ has quit IRC
#01:48:20bencahill_ has joined #evergreen
#02:30:56Zyph has joined #evergreen
#02:34:14Zyph has quit IRC
#03:20:40pmplett_ has quit IRC
#03:30:07Guest58404 has joined #evergreen
#03:30:42jennam is now known as Guest72517
#03:30:48Guest58404 is now known as jennam
#03:31:18jennam is now known as Guest83223
#03:32:10Guest83223 is now known as jennam
#03:32:11Guest72517 has quit IRC
#03:32:13jennam has quit IRC
#03:32:13jennam has joined #evergreen
#04:09:11jennam has quit IRC
#04:31:52jennam has joined #evergreen
#04:31:56jennam has joined #evergreen
#04:34:32Callender has quit IRC
#04:34:57tater has quit IRC
#04:35:10leed has quit IRC
#04:35:11phasefx has quit IRC
#04:42:16phasefx has joined #evergreen
#04:42:21leed has joined #evergreen
#04:42:35tater has joined #evergreen
#04:49:09Callender has joined #evergreen
#04:53:04jennam has quit IRC
#05:06:11jennam has joined #evergreen
#05:06:17jennam has quit IRC
#05:06:18jennam has joined #evergreen
#05:26:14Guest58404 has joined #evergreen
#05:26:18jennam is now known as Guest97499
#05:26:22Guest58404 is now known as jennam
#05:26:24jennam has joined #evergreen
#05:29:25Guest97499 has quit IRC
#07:27:42pmplett_ has joined #evergreen
#07:45:40shadowspar has quit IRC
#07:45:46shadowspar has joined #evergreen
#08:07:55LBA1 has joined #evergreen
#08:08:45_dkyle_1 has joined #evergreen
#08:13:50_dkyle_ has quit IRC
#10:16:29csharpah... 1.6.1 actor.org_unit now has a unique constraint on "name" - this will be interesting since many PINES libraries call their bookmobile units "Bookmobile"
#11:26:01tsbere_ is now known as tsbere
#11:57:32bshum has joined #evergreen
#11:58:15bshum has left #evergreen
#12:08:21dbscsharp: UPDATE actor.org_unit SET name = shortname || ' ' || name WHERE name = 'Bookmobile'; -- perhaps?
#12:20:03csharpdbs: ha! thanks, but I already did that the hard way :-P
#12:20:17csharp records the command for later use, though
#12:21:17csharpthis is the price of knowing enough PG SQL to be dangerous, but not enough to be efficient ;-)
#12:29:58tsbereAnother thought would be to use the parent ou's shortname instead of the shortname of the bookmobile
#12:30:30tsbereI think something like this would do that: UPDATE actor.org_unit SOU SET name=POU.shortname || ' ' || SOU.name FROM actor.org_unit POU WHERE SOU.parent_ou=POU.id AND SOU.name LIKE 'Bookmobile';
#12:32:20phasefxis the constraint a good thing?
#12:32:46tsbereGiven that in some places the name is the only thing you get for an identifier, probably
#12:32:54phasefxand why are we all here on a Saturday? :)
#12:33:56tsbereBecause if I don't check my work email every day for moderation requests on mailing lists I get overloaded.
#12:34:10tsbereAnd they are easiest to deal with by remoting into my work computer ;)
#12:34:29phasefxand no harm in checking IRC while doing that, eh? :)
#12:34:55tsbereOh, and I tend to decide to randomly start writing code for my eg projects pretty much any day of the week.
#12:35:23tsbere enjoys figuring out coding problems, in general
#12:35:55phasefx is going to work on a unifying the volume/item creator and the item attribute editor. wife is out of town. "I should be cleaning, though :)
#12:42:30csharpphasefx: re: the constraint - it is kind of a nuisance and may result in some library pushback - also within the org tree, it's obvious whose "Bookmobile" it is
#12:42:48csharpdo we know why the constraint was added?
#12:43:10phasefxI don't, but we could try perusing the revision history
#12:43:34csharptsbere: totally with you - I think of something and want to start right away, be it Saturday morning or not ;-)
#12:44:32csharpoh, and that is what I did - system shortname + "Bookmobile"
#12:45:19csharpwhich has an amusing effect in the cases of OHOOP and PIED
#12:45:32csharp wonders if that will throw people off
#12:45:47csharp(Ohoopee and Piedmont systems)
#12:45:58phasefx grumbles over his internet connection
#12:48:01phasefxcsharp: changeset 12455, make org unit name and shortname unique, to avoid mistakes
#12:48:22phasefx2 years ago :)
#12:48:32csharpheh
#12:49:04tsbereTake note, the org tree is nice, but things like circ matchpoints will only show the name before you go to edit them
#12:49:49phasefxmaybe an interface like that should render the whole org path somewhere when dealing with a specific org
#12:50:34csharptsbere: good point
#12:51:40csharpalong that same line, we discovered recently that it's not possible to know on the front end which org_unit owns the current shelving location of an item
#12:52:47csharpe.g., if you assigned your book a SYS1 location of ADULT and your SYS2 also has a shelving location of ADULT, it's not possible to know which system's ADULT is currently assigned
#12:52:57csharpit just says "ADULT"
#12:53:00tsbereyea
#12:53:26r123 has left #evergreen
#12:54:09csharpand to confuse matters further, if you select the list of shelving locations from the dropdown, *those* are whatever locations are available to the OU that you're currently working from, not the currently assigned location
#12:54:39csharpwould this be considered bug? I've been intending to report it on Launchpad, but didn't know which bucket it should live in?
#12:54:42phasefxmight be useful to also expose the circulate, holdable, and opac visible flags as well, associated with a location. perhaps as a tooltip in some interfaces, or extra columns in others
#12:57:54phasefxit's suppose to show appropriate locations based on the owning lib, circ lib, and workstation. However, if you're batch editing items, it'll only show the locations that they have in common, library-wise
#12:58:10phasefxso, bug, if that's not the case
#13:06:11finnapz has joined #evergreen
#13:10:06phasefxfinnapz: howdy
#15:24:17pmplett_ has quit IRC
#15:57:23bshum has joined #evergreen
#18:19:35brendan2_ has joined #evergreen
#18:19:35brendan2 has quit IRC
#18:19:35brendan2_ is now known as brendan2
#21:16:44brendan2_ has joined #evergreen
#21:16:46brendan2 has quit IRC
#21:18:08brendan2_ is now known as brendan2
#21:41:22brendan2 has quit IRC
#21:41:57brendan2 has joined #evergreen
#22:14:44brendan2 has quit IRC
#22:32:13brendan2 has joined #evergreen
#22:38:14brendan2 has quit IRC
#22:38:52brendan2 has joined #evergreen
#22:42:41brendan2 has quit IRC
#22:43:13brendan2 has joined #evergreen
#23:35:46bshum has quit IRC
< Friday, February 18th, 2011Raw Log FileSunday, February 20th, 2011 >