Time |
Nick |
Message |
00:05 |
|
ningalls joined #evergreen |
00:10 |
|
torrie joined #evergreen |
04:57 |
pinesol_green |
Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html> |
07:36 |
|
Dyrcona joined #evergreen |
07:54 |
|
collum joined #evergreen |
08:12 |
csharp |
hmm - looks like the change in 80e3f6f may have borked some long-standing PINES reports templates |
08:12 |
pinesol_green |
[evergreen|Mike Rylander] Correctly mark nested INNER joins as such - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=80e3f6f> |
08:13 |
csharp |
no complaints about the new behavior, just an observation and warning to others that the change alters the way JOINs are done ;-) |
08:13 |
|
Dyrcona joined #evergreen |
08:13 |
|
timlaptop joined #evergreen |
08:13 |
|
asimon joined #evergreen |
08:15 |
|
akilsdonk joined #evergreen |
08:19 |
asimon |
*: I am trying to load a file of bib records into a test server. In order to preserve the rest of the data, I did a truncate cascade on the bre table (there are no copy records) and set record_entry_id_seq to 500000. When I load the records, the id numbering starts at 001. The load script is clearly using the TCN (which begins at 500001) as the id. How is this possible? |
08:22 |
csharp |
asimon: there's a "global flag" that determines that behavior, if I recall correctly |
08:23 |
csharp |
config.global_flag? (I don't have access to our DB right this second to check) |
08:24 |
csharp |
also available via the staff client in the Server Admin section, btw |
08:28 |
asimon |
csharp: I see a 'cat.bib.use_id_for_tcn' in config.global.flag which is set to TRUE, but this should not affect setting the id during a load. |
08:29 |
|
Shae joined #evergreen |
08:34 |
Dyrcona |
asimon: It will move the 001 to 035 and put the id in 001. |
08:36 |
asimon |
Dyrcona: How does this relate to a PostgreSQL COPY which is supposed to honor record_entry_id_seq? |
08:36 |
Dyrcona |
asimon: The id column of the bre entry is not changed. The 001 in the MARC record is changed. |
08:37 |
Dyrcona |
biblio.record_entry.id is unchanged. |
08:37 |
Dyrcona |
biblio.record_entry.marc is changed. |
08:38 |
asimon |
Dyrcona: OK. |
08:38 |
Dyrcona |
asimon: If you copy includes the id column, it won't honor record_entry_id_seq. |
08:42 |
|
mtate joined #evergreen |
08:46 |
|
mmorgan joined #evergreen |
08:56 |
|
akilsdonk_ joined #evergreen |
09:04 |
|
rjackson-isl joined #evergreen |
09:09 |
|
ericar joined #evergreen |
09:10 |
|
mrpeters joined #evergreen |
09:11 |
|
RoganH joined #evergreen |
09:15 |
|
Sato`kun joined #evergreen |
09:16 |
|
dluch joined #evergreen |
09:25 |
|
mllewellyn joined #evergreen |
09:33 |
|
yboston joined #evergreen |
09:37 |
|
denishpatel joined #evergreen |
09:41 |
|
denishpatel joined #evergreen |
09:42 |
dbs |
berick: thanks for putting up with my late-night antics. I know the Mozilla folks want to add more live examples, maybe I'll tackle that one |
09:44 |
berick |
heh, ain't no thing |
09:45 |
berick |
(but, of course, a chicken wing) |
09:46 |
berick |
more moz live examples would be nice |
09:47 |
jeff |
w3schools? That's IT! You're OUT of the band! |
09:54 |
|
Stareagle joined #evergreen |
10:06 |
|
atlas__ joined #evergreen |
10:12 |
Bmagic |
anyone know of any issues with the newer version of DBD::Pg against evergreen code? it looks like the version is 2.17.1 from 2010 |
10:30 |
|
atlas__ joined #evergreen |
10:38 |
mmorgan |
Anybody tried to use the new library setting in 2.5 from lp 856688 ? |
10:38 |
pinesol_green |
Launchpad bug 856688 in Evergreen "Option to disallow use of an org unit as a pickup library for holds" (affected: 4, heat: 18) [Wishlist,Fix released] https://launchpad.net/bugs/856688 |
10:39 |
bshum |
mmorgan: I haven't, but what are you seeing ? :) |
10:39 |
mmorgan |
It doesn't prevent me from choosing the ou as a pickup point when I place the hold, doesn't grey it out. |
10:39 |
mmorgan |
but when I edit the hold, the ou IS greyed out. |
10:40 |
mmorgan |
so seems like the place hold screen isn't looking at the setting? |
10:40 |
bshum |
My kneejerk reaction is to ask you if you've restarted apache lately |
10:40 |
bshum |
Because maybe it's caching the original dropdown choices and not the one reflecting the disallowed ou from the setting |
10:40 |
mmorgan |
fresh install on our training server this week. Just restarted apache a few minutes ago. |
10:41 |
bshum |
But then again, maybe it is ignoring it for some reason :) |
10:45 |
mmorgan |
tried restarting and clearing cache on everything I could think of and still no luck :-( |
10:47 |
csharp |
Bmagic: we're running Ubuntu 12.04 with version 2.19 from the Ubuntu repos and it works fine for us |
10:47 |
csharp |
mmorgan: I think we saw similar issues... |
10:48 |
* csharp |
looks around for terran |
10:52 |
mmorgan |
ok - a launchpad question, so if the new ou setting isn't working, is that an update to the existing bug which is marked "fix released" or a new bug? |
10:52 |
bshum |
New bug usually. |
10:53 |
bshum |
would be what I would recommend when dealing with something that's already been released. |
10:54 |
mmorgan |
I'll poke around some more and open one if warranted. Thanks! |
10:58 |
bshum |
Hmm |
10:58 |
bshum |
mmorgan: Can you tell us a little more about the org unit structure and which ou you're disallowing from hold pickup? |
10:59 |
bshum |
(when I tested it just now, it worked fine to disable the option on the place hold screen...) |
11:01 |
mmorgan |
Interesting. Here's a pic: http://screencast.com/t/AIs8afgOj0gZ |
11:02 |
csharp |
could it be autogen.sh related? |
11:02 |
mmorgan |
We have NOBLE(All libs) as consortium, then Phillips Academy as a system. It's some of the branches I'm trying to disallow, like Phillips Addison |
11:02 |
csharp |
autogen.sh-- # btw |
11:03 |
mmorgan |
ok, I will give autogen a try, but I DID see the choices greyed out when I tried editing the pickup library of an existing hold. |
11:04 |
bshum |
fwiw, when I applied the setting in my system, I didn't restart anything and it was greyed out when I went to look. |
11:04 |
bshum |
Same when removing that setting |
11:05 |
csharp |
bshum: ok - just a shot in the dark |
11:05 |
bshum |
Does NOBLE use custom org units trees? |
11:06 |
bshum |
(we don't, so I'm just curious if maybe that's causing some weird issue) |
11:06 |
bshum |
Or actually, it probably shouldn't affect it. |
11:06 |
bshum |
Hmm |
11:06 |
mmorgan |
Yes, we do use custom org unit trees. |
11:08 |
csharp |
oh, yeah - *that* was our issue |
11:08 |
mmorgan |
Here's a pic of editing a pickup location on an existing hold: http://screencast.com/t/sb1b2A6pjv |
11:08 |
csharp |
we hack our OU display to show System - Branch, and that was interfering with it |
11:08 |
mmorgan |
It's working there. |
11:09 |
csharp |
in our case, rearranging the template code resolved the issue |
11:09 |
mmorgan |
csharp: So a custom tpac file? |
11:09 |
csharp |
yeah |
11:10 |
csharp |
well, not file, just some custom code within one of the templates |
11:13 |
bshum |
csharp: Something weird to rearrange in org_selector.tt2 maybe? |
11:15 |
bshum |
but this is the thing I'm not sure about |
11:15 |
bshum |
The dropdown picker from place_hold.tt2 doesn't have an INCLUDE parameter for show_loc_group |
11:16 |
bshum |
So I wouldn't expect it to interfere if you have custom org unit trees |
11:19 |
|
denishpatel joined #evergreen |
11:21 |
bshum |
Okay, I have no new ideas yet and it's time to go find lunch. |
11:21 |
|
kbutler joined #evergreen |
11:22 |
mmorgan |
I know what to look at now, thanks for your help! |
11:22 |
mmorgan |
bshum++ |
11:22 |
mmorgan |
csharp++ |
11:25 |
bshum |
mmorgan: Good luck, I'll be curious to see what the final issue turns out to be. |
11:32 |
|
kbeswick joined #evergreen |
11:32 |
|
mcooper joined #evergreen |
11:46 |
yboston |
hello everyone, not so long ago I was able to run a nifty query to get counts of every bib tag and sudield combination we have in our system using metabib.full_rec |
11:47 |
yboston |
but now I need to run a similar query on auth tag/subfield combinations. I assuem I can't use soemthing equivalent to metabib.full_rec for auth since it might not exist yet? |
11:49 |
pastebot |
"yboston" at 64.57.241.14 pasted "query using metabib.full_rec to get counts of all bib tag/subfield combinations" (7 lines) at http://paste.evergreen-ils.org/43 |
11:51 |
dbs |
yboston: check authority.full_rec |
11:51 |
jeff |
you can change metabib.full_rec to authority.full_rec in that query and get results. |
11:53 |
yboston |
¡ dbs & jeff muchas gracias! |
12:01 |
|
cmorgan joined #evergreen |
12:05 |
|
jihpringle joined #evergreen |
12:25 |
|
lcathenry joined #evergreen |
12:28 |
Dyrcona |
Is this to be expected: psql:0875.schema.authority.in-line-headings.sql:14: NOTICE: index "unique_by_heading_and_thesaurus" does not exist, skipping |
12:29 |
csharp |
reports-- |
12:29 |
Dyrcona |
Thing is, I know we recreate that index when reloading the database. |
12:29 |
Dyrcona |
I wonder if 0874 causes it to disappear. |
12:34 |
|
gerson joined #evergreen |
12:37 |
Dyrcona |
Oh, never mind. |
12:38 |
Dyrcona |
I see that message comes from a "drop if exists," so we'd be dropping it anyway. |
12:43 |
bshum |
gmcharlt: Your contrived examples in the reply to list make me queasy :( |
12:44 |
* Dyrcona |
finds "contrived" examples happen all too often in reality. ;) |
12:49 |
dbs |
gmcharlt's workflows were good examples of what I was implying |
12:50 |
Dyrcona |
Grr. |
12:50 |
* Dyrcona |
doesn't like it when man pages are not installed on the server. |
12:50 |
dbs |
Gotta save those MB of space! |
12:52 |
Dyrcona |
:) |
12:55 |
Dyrcona |
Most of them can be found via this thing called Google, too. ;) |
12:58 |
* dbs |
runs into "Method [open-ils.circ.copy_note.retrieve.all] not found for OpenILS::Application::Circ" on a freshly upgraded master vm. time to dig. |
12:59 |
Dyrcona |
Not seen that one. |
13:02 |
dbs |
Oh, probably missing Business::Stripe |
13:03 |
Dyrcona |
Could be. |
13:03 |
dbs |
Yep. |
13:04 |
jeff |
I would love to have a standard way for us to not require some of those modules unless they're actually in use. |
13:04 |
jeff |
I think there's existing examples for that, possibly already within Evergreen itself already. |
13:05 |
jeff |
But installing PayPal and Stripe things for a site that doesn't make use of online payments at all seems... dunno. |
13:05 |
dbs |
jeff: alternately, "cpan *" |
13:05 |
bshum |
Haha |
13:06 |
Dyrcona |
:) |
13:07 |
* dbs |
wonders if anyone is willing to add serial.* data to the --load-all side of things |
13:08 |
bshum |
berick: I have a question about websockets and upcoming changes to OpenSRF. |
13:08 |
bshum |
As I work my thoughts together about the XUL vs. web client |
13:09 |
bshum |
I'm wondering if any changes in the underlying architecture would require us to test also the XUL client to make sure we don't break things? |
13:09 |
bshum |
While we transition to the web client |
13:10 |
berick |
bshum: websockets will have no effect on the xul client. it has to be activated within the script / application to be used, and the browser client code is the only thing (for now, anyway) that activates it. |
13:10 |
berick |
the activation occurs within the base browser staff template |
13:10 |
bshum |
berick: Ah, cool deal. Then I feel slightly better on that front. |
13:10 |
berick |
all other code will continue using XHR as before |
13:11 |
Dyrcona |
Waiting for long upgrade scripts isn't much fun. |
13:13 |
bshum |
I'm generally happier with the idea of having the web client be its own thing instead of trying to hammer it to live alongside the existing client. I'd be happiest if we don't break anything XUL side till we're done and can do a full transition. |
13:14 |
bshum |
Mostly because I don't think our folks would really want to handle a hybrid situation. |
13:15 |
berick |
bshum: *nod* |
13:23 |
|
atlas__ joined #evergreen |
13:25 |
jl- |
hello |
13:37 |
bshum |
jl-: Greetings. |
13:53 |
|
kgaug joined #evergreen |
13:54 |
|
mdriscoll joined #evergreen |
13:55 |
yboston |
Heads up, the IRC practice time isstarting at 2 PM EST, I suspect we will not have as many visitors as last time |
13:57 |
|
akilsdonk joined #evergreen |
14:00 |
jl- |
@coffee |
14:00 |
* pinesol_green |
brews and pours a cup of Nicaragua Maragogipe Organic, and sends it sliding down the bar to jl- |
14:01 |
|
b_bonner joined #evergreen |
14:02 |
yboston |
IF any one is here for the IRC practice time. Welcome |
14:03 |
yboston |
If you are an IRC newcomer go ahead an d introduce yourselves. |
14:03 |
* bshum |
waves at yboston |
14:04 |
yboston |
bshum: thanks, I don't think any newcomers are here |
14:04 |
yboston |
I forgot to send a reminder during the week to the general list :( |
14:04 |
yboston |
I only emailed the dev |
14:04 |
yboston |
list |
14:06 |
|
Josephine joined #evergreen |
14:07 |
yboston |
if anyone is here for the IRC practice time, feel free to introduce your self |
14:09 |
|
kgaug left #evergreen |
14:09 |
|
kbeswick joined #evergreen |
14:17 |
|
schrader_ joined #evergreen |
14:19 |
|
hbrennan joined #evergreen |
14:20 |
|
schrader_ joined #evergreen |
14:21 |
hbrennan |
Hello Evergreeners! I'm back from vacation and ready to catch up on IRC chat since the conference. Oh boy!! |
14:21 |
yboston |
hello |
14:22 |
yboston |
are you here for the IRC practice time? |
14:22 |
hbrennan |
Oh, no. Is that scheduled for right now? |
14:22 |
yboston |
yes, but this practice time is not as popular as the first |
14:22 |
hbrennan |
I literally just returned to work and have resisted reading emails |
14:22 |
schrader_ |
I was here for the practice time. Is that why no posts display? |
14:22 |
yboston |
no worries, |
14:23 |
yboston |
no thinkgs are just quiet, less showed up, but I am here to help folks practice |
14:23 |
hbrennan |
Just wanted to say I'm back. I'll just watch, or help if I can |
14:23 |
dbs |
hbrennan++ # i'm impressed at being able to resist reading emails at any time! |
14:23 |
yboston |
BTW, here here is the EG community IRC "quick start guide" put together by kmlussier (Kathy) http://wiki.evergreen-ils.org/doku.php?id=community:irc-quick-start |
14:24 |
hbrennan |
dbs; Only 401 new emails, plus 99 from EG list... |
14:24 |
yboston |
schrader_: this my attempt to "reply" to you by starting this messgae with your nickname and a colon |
14:24 |
hbrennan |
dbs: Wouldn't want to be bored my first day back |
14:24 |
yboston |
schrader_: try replying to me if you want |
14:25 |
schrader_ |
yboston : okay, here it is |
14:25 |
hbrennan |
schrader_: no space |
14:25 |
yboston |
schrader_: good job. |
14:25 |
jl- |
schrader_: welcome |
14:26 |
yboston |
replying makes the other persons IRC software try to alert you someone is trying to get your attention |
14:26 |
yboston |
I hear on the web browser version of IRC the replies appear in red(?) |
14:26 |
hbrennan |
yboston: yep |
14:26 |
hbrennan |
and it flashes the browser window |
14:27 |
hbrennan |
great when you have multiple conversations going |
14:27 |
yboston |
another trick is that you can just write the first couple of letters of someone's nickname, then hit the "tab" key to trigger auto completion |
14:28 |
schrader_ |
hbrennan:didn't think I had a space |
14:28 |
schrader_ |
Maybe it was in my name. Have I told everyone how much I hate invisible spaces? |
14:28 |
hbrennan |
schrader_: It might work.. not sure. But I always write the username: then a space, but not between the username and colon |
14:29 |
hbrennan |
schrader_ : Does this still notify you? |
14:29 |
schrader_ |
hbrennan :yes I can see both posts to me |
14:29 |
hbrennan |
schrader_: Great! Then the space doesn't matter |
14:31 |
yboston |
another useful feature is to create a private chat with some. Usually done in case you want to have a long conversation and don't want to clutter up the public channel |
14:31 |
schrader_ |
Just throwing something out here. I'd like to know who to talk to about Vandelay improvements. |
14:31 |
yboston |
you start your message with: /msg nickname |
14:32 |
hbrennan |
schrader_: That would be a good topic to throw out to the email list. |
14:32 |
yboston |
so if I want to start a private message/chat with schrader_ , I would start a message with /ms schrader_ |
14:32 |
hbrennan |
schrader_: You can also search Launchpad to see if others have requested what you want, or start your own "bug report" which can just be a wish |
14:32 |
yboston |
in most IRC software and even the web version, you will see a new "tab" that will display the private chat |
14:33 |
yboston |
schrader_: I am interested in improving Vandelay's support for authorities, like having authority overlays on import |
14:34 |
yboston |
schrader_: what kind of improvements are you interested in? |
14:36 |
schrader_ |
yboston: get invalid command when using /ms |
14:36 |
yboston |
you need three letters /msg try it on me |
14:37 |
* Dyrcona |
still waits on upgrade scripts. |
14:37 |
Dyrcona |
On the plus side, I think this is the last one. |
14:38 |
yboston |
for the record, here is a link of Evergreen community memebers that have publicly identified their IRC nicknames http://evergreen-ils.org/dokuwiki/doku.php?id=community:irc_channel |
14:40 |
yboston |
schrader_: are you familiar with Launchpad as hbrennan_away suggested. I can tell you about it if you don;t |
14:44 |
hbrennan |
yboston: Oops, thanks for following up on that one for me |
14:46 |
schrader_ |
hbrennan : what's it like in Alaska now? I am still waiting for snow to melt |
14:47 |
yboston |
hbrennan: you are welcome |
14:48 |
hbrennan |
schrader_: Wonderful. Glad to be back in warmer temps. :) It snowed in NY on Monday! |
14:48 |
Dyrcona |
@wunder 01845 |
14:48 |
pinesol_green |
Dyrcona: The current temperature in WB1CHU, Lawrence, Massachusetts is 46.0°F (2:48 PM EDT on April 04, 2014). Conditions: Mostly Cloudy. Humidity: 58%. Dew Point: 32.0°F. Windchill: 42.8°F. Pressure: 30.13 in 1020 hPa (Falling). |
14:50 |
schrader_ |
Sleet last week in MA, with snow and freezing rain as a bonus. Currently 52 here for Red Sox home opener |
14:52 |
hbrennan |
schrader_: That's because I left. I was in Boston on Wednesday, which kicked off the nice temps |
14:52 |
yboston |
schrader_: did we meet at the conferece or before? |
14:52 |
yboston |
hbrennan: BTW, what is the time differece in where you are in Alaska? |
14:53 |
hbrennan |
yboston: 4 hours earlier. I left Boston Wed evening at 6, got to Alaska at 7am yesterday. Now I'm at work to start the day and my body/brain say its time to go home |
14:54 |
hbrennan |
yboston: But I am so appreciative for the EG community hosting most meetings in "afternoon" so I can participate! Wouldn't be where I am now if it hadn't been for that involvement |
14:55 |
yboston |
hbrennan: that is why I asked and why I made sure the IRC practice time happened at 2 PM EST at the earliest |
14:56 |
hbrennan |
yboston++ for thinking of the west coasters (and far west coasters) |
14:56 |
* ericar |
is thankful that she did not bring the cold weather back to Georgia. Already have peppers and tomatoes in the ground. |
14:58 |
yboston |
hbrennan: to be honest I was thinking of west coasters when I had drawn up plans for these practice session before the conference. |
14:58 |
jl- |
ericar: hi erica this is ben wiens |
14:58 |
yboston |
hbrennan: then I heard where you were from, and realized I need to think bigger |
14:59 |
jl- |
I'll have to wait a little longer until I plant tomatoes |
14:59 |
hbrennan |
yboston: Haha. Well thanks. There are two EG libraries in AK but I haven't met anyone from the other library |
14:59 |
ericar |
jl: Hello! |
14:59 |
yboston |
hbrennan: on the other side of the spectrum, Berklee College (my employer), has a small campus (with a library) in Spain. So I have to adjust my maintenace plans for their open hours too |
15:00 |
yboston |
hbrennan: what city/town are you based out of? |
15:00 |
atlas__ |
hey EG IRC, glad to see this channel so active! I'm going to attempt installing Evergreen for the first time here, noticed that the instructions have notes for both Fedora and Ubuntu -- any reason to pick one over the other? |
15:00 |
hbrennan |
yboston: Homer |
15:01 |
jl- |
atlas__: debian |
15:01 |
atlas__ |
jl-: squeeze? |
15:01 |
jl- |
or the latest stable (wheezy) |
15:01 |
atlas__ |
okay thanks |
15:02 |
jl- |
no problem |
15:03 |
jl- |
apt-get makes everything so much easier |
15:03 |
atlas__ |
yum is quite nice too ;) |
15:03 |
jl- |
sure if you like compiling from source |
15:03 |
jl- |
:) |
15:04 |
yboston |
hbrennan: thanks for sharing. Like I told most of you I live like 20 minutes walking from the confernce hotel but I am originally from Puerto Rico |
15:04 |
yboston |
@wunder 00936 |
15:04 |
jl- |
I've lost a good amount of hair trying to make islandora work on fedora, since then I just use debian for everything |
15:04 |
pinesol_green |
yboston: The current temperature in San Ignacio, San Juan, Puerto Rico is 81.3°F (3:04 PM AST on April 04, 2014). Conditions: Mostly Cloudy. Humidity: 71%. Dew Point: 71.6°F. Pressure: 30.01 in 1016 hPa (Falling). |
15:04 |
dbs |
atlas__: I'm one of the only people who runs Fedora, most people run ubuntu or debian. So there's that. |
15:05 |
atlas__ |
jl-: damn, thats too bad, it seems like the latest fedora release always has good up to date packages in the repo, but I'm down for trying debian too if its repo is better for the dependencies evergreen needs |
15:06 |
hbrennan |
yboston: Checked out the outside of your campus. Talked to you about the cool bike lock-up area you have! |
15:06 |
jl- |
atlas__: I love fedora as my desktop but it threw me too many curveballs when running applications like islandora.. I haven't tried evergreen on it tho |
15:06 |
collum |
hairloss-- |
15:06 |
yboston |
For the record, we have hit 3 PM and this concludes today's IRC practice time. YOu can go back to beating your local weather and ordering beverages fromt eh pinesol_green bar |
15:07 |
yboston |
s/beating/talking about the/ |
15:07 |
hbrennan |
yboston++ Thanks for hosting these sessions. Glad to have more new people joining! |
15:07 |
jl- |
yboston++ |
15:08 |
hbrennan |
bshum: We need a new Top 50 karma count. I'm interested to see the difference pre and post conference! |
15:08 |
yboston |
hbrennan: you missed the first practice time, we had a lot of newcomers. I was really happy |
15:08 |
bshum |
hbrennan: Heh, I'll see what I can do in a moment. |
15:08 |
hbrennan |
yboston: Darn my vacation. Next time I'll take time off before the conference, because I really wanted to get back to work after this one! |
15:08 |
bshum |
One of the things I noticed that they do in #code4lib is to reset the karma between conferences. |
15:08 |
bshum |
So that each year they track anew |
15:08 |
ericar |
yboston++ |
15:09 |
yboston |
I want to try to host these IRC training after every conference at the very least |
15:09 |
hbrennan |
Great idea |
15:10 |
yboston |
a variation is to have a newcomer session were we create a luanchpad account, try IRC , learn to browse the git.evergreen-ils.org |
15:10 |
hbrennan |
yboston: Maybe before anticipated big conversations, like when we want to discuss the new browser |
15:10 |
yboston |
at the cofnerence |
15:10 |
yboston |
hbrennan: that is brilliant |
15:11 |
hbrennan |
yboston: Because that's a time when I think we'll see more library staff involvement, who probably don't use IRC much if ever |
15:11 |
yboston |
hbrennan: makes semse |
15:11 |
yboston |
*sense |
15:12 |
* dbs |
notes concerto record 186 still shows "Genre" results from field 659, which is actually undefined in MARC21 |
15:12 |
|
kbeswick joined #evergreen |
15:15 |
jl- |
good news, I migrated all of our universities' records (1 out of 18).. but then when I logged into the staff client, it's like I glimpsed into the matrix.. so much.. library stuff that I have no clue about |
15:15 |
jl- |
around 250k records for now, which might be enough for a pilot |
15:18 |
hbrennan |
jl-: Awesome! You've made a lot of progress in the past 4 weeks! |
15:19 |
jl- |
hbrennan: indeed, splitting the imports into batches of 10k did it for me. 50k would go into a neverending loop.. |
15:19 |
jl- |
too bad there's no clear cut way for migration |
15:20 |
hbrennan |
jl-: That's the world of libraries.. everyone's a little different |
15:20 |
dbs |
For that matter, the 69x mappings are supposed to be local too. There are only a couple that match even OCLC's definitions. |
15:20 |
yboston |
jl-: congrats |
15:20 |
yboston |
jl-: which import approach did you use? |
15:20 |
jl- |
I'm hoping to get one of our libraries as a gineau pig for a pilot now, maybe for a dvd collection, or something.. wean them off voyager |
15:21 |
jl- |
yboston: I used the sql_loader which is pretty close to the staging table from dbs |
15:21 |
jl- |
in /openils/Evergreen-ILS-2.5.1/Open-ILS/tests/datasets/sql/ |
15:22 |
jl- |
I made a script that formats them simialr to the concerto files |
15:26 |
jl- |
anyway, have a good weekend everyone |
15:27 |
jeff |
neat, we have an action.billable_cirulations view. i wonder if that's a known typo or something specific to us. :-) |
15:28 |
hbrennan |
jl-: Ugh, it's 11:30 here, but my body thinks it's later so I can leave too right? |
15:28 |
jeff |
(we also have action.billable_circulations) |
15:29 |
jl- |
hbrennan: I didn't realize Alaska was that far behind ;) |
15:29 |
hbrennan |
jl-: It's true. |
15:35 |
jl- |
are the fairbanks remote? |
15:36 |
hbrennan |
jl-: You talkin to me? |
15:37 |
jl- |
hbrennan: yes |
15:37 |
mmorgan |
jeff: no action.billable_cirulations view here! Must be just you. |
15:38 |
hbrennan |
jl-: Can you repeat the question? Haha. |
15:40 |
jl- |
hbrennan: nvm ;) |
15:40 |
hbrennan |
jl-: I can tell you that Fairbanks is 600 miles north of me. :) |
15:41 |
|
kbeswick joined #evergreen |
15:42 |
rjackson-isl |
jeff: we have one here at EI --> select count(*) from action.billable_cirulations; yields--> 1071972 |
15:42 |
rjackson-isl |
I've noticed that table as well in the past and wondered... |
15:43 |
dbs |
none here |
15:44 |
dbs |
and nothing matching: grep -r "cirulation" Open-ILS/sql/* |
15:44 |
dbs |
perhaps a local support provider copy/pasteo? |
15:44 |
rjackson-isl |
ours appears to be in sync with the "real" named table based on checking max(id) values... |
15:45 |
jeff |
rjackson-isl: it's a view, so that's to be expected. |
15:45 |
rjackson-isl |
jeff: dang - caught again! |
16:01 |
bshum |
Huh.... I just noticed a new question in LP |
16:01 |
bshum |
https://answers.launchpad.net/evergreen/+question/246347 |
16:01 |
bshum |
That's the first time in a long time someone's used that... |
16:03 |
bshum |
I suppose we don't really use LP that way. |
16:05 |
|
madseumas joined #evergreen |
16:10 |
ericar |
bshum: out of curiosity, I just tried recreating what she's reporting. I can't reproduce the results. tested on 2.5.3b |
16:11 |
bshum |
ericar: Thanks for taking a look over. I wasn't too sure what all the circumstances are here. |
16:12 |
bshum |
The LP account who opened that question seems to be someone from Evergreen Indiana. |
16:12 |
ericar |
bshum: me either |
16:12 |
bshum |
Could be a local system issue of some sort |
16:12 |
mmorgan |
We're on 2.4, and one of our libraries has reported a similar problem. |
16:13 |
ericar |
bshum: it stays on Patron Search when I try it. Probably right. |
16:13 |
mmorgan |
I think the same thing results from holding down a function key for too long. |
16:14 |
mmorgan |
Press F1 for checkout, but don't let go of the key right away. |
16:14 |
kbutler |
I'm able to get one popup to happen intermittantly, if I time it right. |
16:14 |
Bmagic |
csharp: Thanks for the info |
16:14 |
bshum |
mmorgan: Oh interesting... holding the key down does give me various JS errors. |
16:14 |
bshum |
For different Fn keys |
16:15 |
madseumas |
Hello, everyone. I just updated a small (20k items or so) library from 2.3.2 to 2.5.3b on a test VM. Upgrades all went fine, no db errors. She (it's my wife's library; I'm a unix admin by trade so I help her maintain it) was using jspac, which is gone now. Should the uncustomized tpac still be able to return records or does it need some basic level of customization before it will? Keyword searches that work on her liv |
16:15 |
bshum |
madseumas: You got cut off at "keyword searches that work on her live" |
16:15 |
bshum |
IRC has a cap on how much you can type at once. So just break up the sentences a bit :) |
16:16 |
madseumas |
argh sorry, will do |
16:16 |
madseumas |
should read " Keyword searches that work on her live system return nada on this test one." |
16:16 |
ericar |
mmorgan: yes, first time got TypeError: $("patronStrings").getString is not a function second try got TypeError: $("commonStrings") is null. Held the key for about 2 seconds |
16:16 |
madseumas |
haven't done IRC in 10 years or so :) |
16:17 |
mmorgan |
lp 1300789 |
16:17 |
pinesol_green |
Launchpad bug 1300789 in Evergreen "F4 (Search for Patrons) Results in Multiple Popup Errors if Interrupted" (affected: 1, heat: 6) [Undecided,New] https://launchpad.net/bugs/1300789 |
16:19 |
bshum |
madseumas: I would expect even an uncustomized TPAC to return results. If it's not there may be a few things to check on. |
16:19 |
bshum |
Are you getting no results in the public catalog vs. staff client catalog search? |
16:19 |
bshum |
I'd be curious if maybe there are problems with missing 901c entries too in the MARC data which would break TPAC display of a bib. |
16:20 |
* bshum |
hasn't used JSPAC since 2.0 so is super rusty |
16:20 |
madseumas |
no results in either. A strict title search will work, but keyword/subject/etc no results |
16:20 |
csharp |
madseumas: have you checked the opensrf logs? |
16:21 |
madseumas |
csharp: no errors in any of the logs |
16:21 |
csharp |
ok |
16:22 |
csharp |
madseumas: did you perform post-upgrade db VACUUM ANALYZEs? |
16:23 |
madseumas |
csharp: no, I didn't, can run those quick. |
16:23 |
* bshum |
wonders about opac visible copies or reingests |
16:24 |
csharp |
madseumas: and you did the reingests after each version upgrade? |
16:24 |
csharp |
(e.g. 2.3-2.4-supplemental.sh) |
16:24 |
rjackson-isl |
regarding https://bugs.launchpad.net/evergreen/+bug/1300789 this occurrs only on the patron search in how I described in ticket |
16:24 |
pinesol_green |
Launchpad bug 1300789 in Evergreen "F4 (Search for Patrons) Results in Multiple Popup Errors if Interrupted" (affected: 3, heat: 14) [Undecided,Confirmed] |
16:24 |
rjackson-isl |
it is repeatable |
16:24 |
madseumas |
csharp: yes, ran reingests, very carefully followed DB script output from each |
16:24 |
rjackson-isl |
use F4 and before the screen pops up hit another F key |
16:25 |
dbs |
madseumas: does the test VM have enough memory? 2.0 GB of RAM or more? |
16:25 |
csharp |
madseumas: well, at the very least, VACUUM ANALYZE all of the metabib.* tables |
16:25 |
rjackson-isl |
other sequence such as F1 then F4 does not produce this |
16:25 |
madseumas |
dbs: test VM has 2GB of RAM. No memory pressure, catalog is quite small |
16:26 |
dbs |
although... if title searches are working, one would think all db calls should |
16:26 |
dbs |
madseumas: heh, 2.0 GB is barely enough for our ~200 test record set with all services running |
16:27 |
csharp |
yeah, I use a minimum of 4 GB, even on small test servers |
16:27 |
ericar |
rjackson-isl: I just reproduced the error you describe above. However, it was from holding the F4 key while still trying to use another F key. Also, holding the F4 too long will reproduce the results |
16:27 |
dbs |
bshum: 901c, yeah, that's something |
16:27 |
csharp |
but you should see swapping or i/o wait in top when the searches are processed |
16:27 |
madseumas |
well, hypervisor has 8 GB free so I can ramp it up if need be, but there is no swap and no i/o wait |
16:28 |
dbs |
madseumas: can you do a very specific author search that matches one of the titles that gets returned from a title search? |
16:28 |
bshum |
It'd be more problematic coming from before 2.3 but I wonder if JSPAC was more tolerant and so they wouldn't have noticed in their previous use. |
16:29 |
madseumas |
dbs: let me check, one sec |
16:29 |
csharp |
madseumas: you can see what happens on the command line when doing searches: http://wiki.evergreen-ils.org/doku.php?id=scratchpad:random_magic_spells#use_srfsh_to_search_the_opac |
16:30 |
* dbs |
also wonders about the usual dump/restore lost indexes issue |
16:30 |
madseumas |
dbs: author search works correctly |
16:30 |
madseumas |
csharp: will do |
16:32 |
dbs |
madseumas: wondering if it's the missing 901 fields, then, as bshum suggested |
16:33 |
|
mrpeters left #evergreen |
16:34 |
madseumas |
csharp: command line search, limit 10, I see 10 ids being returned |
16:34 |
dbs |
SELECT COUNT(*) FROM biblio.record_entry WHERE marc !~ 'tag="901"'; -- if you can query the database would be a good test |
16:34 |
dbs |
Result should be 0. |
16:34 |
madseumas |
dbs: will do, one sec |
16:35 |
madseumas |
dbs: result was 11780 |
16:35 |
bshum |
Oops |
16:35 |
bshum |
:) |
16:35 |
madseumas |
so, missing 901 fields then? :) |
16:37 |
bshum |
Perhaps |
16:37 |
bshum |
So at the end of the 2.1-2.2-upgrade-db.sql script there's some comments explaining problems with 901c missing entries |
16:38 |
madseumas |
bshum: thanks, will check that. this is the first upgrade since we moved from 1.6 to 2.3.2 a few years ago |
16:39 |
dbs |
s/Perhaps/Definitely/ :) |
16:40 |
bshum |
Maybe something like http://pastie.org/8994997 I guess |
16:41 |
bshum |
That should run the triggers through on the bibs that either have missing or broken 901c |
16:41 |
Dyrcona |
bshum: You should try dbs' query again with and deleted = 'f' just to see what that gives. |
16:42 |
bshum |
Ah true, I forgot to put down deleted in it :( |
16:42 |
bshum |
We shouldn't have any.... |
16:44 |
bshum |
0 for us. Either way. |
16:44 |
bshum |
As it should be! |
16:45 |
madseumas |
found the comments at the end of 2.1-2.2 upgrade script. will snap system and run script. |
16:46 |
Dyrcona |
Oops. I misread the scroll back. |
16:46 |
Dyrcona |
Oh well. |
16:51 |
|
mdriscoll left #evergreen |
16:51 |
dbs |
berick: https://developer.mozilla.org/en-US/docs/Web/HTML/Element/datalist now has a live sample for your edification :) |
16:56 |
berick |
dbs++ # nice! |
17:13 |
madseumas |
still running, but from what I can see it is correcting it. Keyword searches are starting to return results. Thanks guys! |
17:13 |
|
alynn26 joined #evergreen |
17:13 |
madseumas |
I must have completely missed that step back when I upgraded a few years ago |
17:14 |
bshum |
Happens to all of us. |
17:14 |
bshum |
Ah yes, the (not so) good ol' days. |
17:16 |
dbs |
madseumas++ |
17:16 |
dbs |
bshum++ # remembering that issue from those days |
17:18 |
madseumas |
Now to go learn how to customize tpac :) |
17:18 |
|
mmorgan left #evergreen |
17:18 |
madseumas |
we've been running this 1.2, but there tends to be long stretches between upgrades |
17:18 |
madseumas |
err *since 1.2 |
17:21 |
bshum |
madseumas++ |
17:21 |
bshum |
You guys have been working with it longer than me then. I showed up between 1.4 and 1.6 era. |
17:24 |
madseumas |
she has a small special library here in the Chicago suburbs, for an educational nonprofit that does adult literacy, ESL, early childhood and a few other things. Original library was a card catalog, and original librarian passed away (in 1999 or so?), librarian after him turned it all into an un-searchable access database. |
17:24 |
madseumas |
it was very very horrible :) |
17:25 |
madseumas |
my wife inherited it after that, and once she found evergreen and she got a grant to get OCLC records we haven't looked back |
17:26 |
hbrennan |
Access?! Oh jeez. |
17:27 |
madseumas |
yah, the forms allowed you to search by specific title or author but that was it. cataloging was a nightmare. |
17:27 |
hbrennan |
I can only imagine. |
17:30 |
pinesol_green |
Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html> |
17:32 |
madseumas |
quick question, where do the default book jackets in a tpac catalog search come from? |
17:32 |
madseumas |
I had thought google books stuff was turned off by default |
17:33 |
bshum |
madseumas: By default in newer versions I believe the added content handler is for OpenLibrary |
17:33 |
madseumas |
ahh thank you |
17:39 |
madseumas |
bshum: dbs: updates have finished running. Populating the 901c fields has completely fixed my issue. thank you so very much, you saved me a bunch of banging my head on walls |
17:40 |
|
Christineb joined #evergreen |
17:47 |
bshum |
madseumas: Glad to help where we can. Enjoy the weekend and happy customizing the new catalog. |
19:08 |
|
madseumas left #evergreen |
23:13 |
|
ktomita joined #evergreen |
23:27 |
|
fparks_ joined #evergreen |