| Time |
S |
Nick |
Message |
| 00:05 |
|
* tcohen |
overstepped on 9579 |
| 00:06 |
|
|
alexh joined #koha |
| 00:19 |
|
mtompset |
dcook: MySQL query to find a record with a 999$c on it? |
| 00:22 |
|
tcohen |
SELECT biblionumber FROM biblioitems WHERE ExtractValue(biblioitems.marcxml,'//datafield[@tag="999"]/subfield[@code="c"]')<>'' |
| 00:24 |
|
* wizzyrea |
giggles at wahanui's new trick |
| 00:24 |
|
tcohen |
which one? |
| 00:24 |
|
wahanui |
somebody said which one was that? The fixed navbar? |
| 00:24 |
|
mtompset |
shh wahanui |
| 00:24 |
|
wahanui |
I'M EXCERCISING eythian's ROBOT RIGHT TO FREE DATA TRANSMISSION |
| 00:24 |
|
* mtompset |
laughs. |
| 00:24 |
|
eythian |
rats |
| 00:24 |
|
mtompset |
Mistake, eythian. ;) |
| 00:24 |
|
eythian |
no wahanui, shh wahanui is <reply>I'M EXCERCISING \MY ROBOT RIGHT TO FREE DATA TRANSMISSION |
| 00:24 |
|
wahanui |
okay, eythian. |
| 00:25 |
|
mtompset |
shh wahanui |
| 00:25 |
|
wahanui |
I'M EXCERCISING MY ROBOT RIGHT TO FREE DATA TRANSMISSION |
| 00:25 |
|
mtompset |
There we go. ;) |
| 00:27 |
|
tcohen |
night #koha |
| 00:27 |
|
* wizzyrea |
hopes pianohacker pops up |
| 00:29 |
|
mrx |
Hi Guys, I have a couple of queries? |
| 00:30 |
|
mrx |
Is it possible to search through all isbns using sql? Like isbn listed in 020|z or in case of multiple 020s? |
| 00:30 |
|
mrx |
Using Catalog -> search catalog I can search any isbn and it will bring up results even with muliple 020 fields and also apparently search z subfield but while trying to fetch same isbn using sql like 'Select biblionumber from biblioitems where isbn=9781922244024' it is not returning anything. |
| 00:30 |
|
mrx |
Do I have to use some different sql query? |
| 00:30 |
|
mtompset |
dcook: I think I figured out why I couldn't do steps 5-7 in the bug. |
| 00:30 |
|
mtompset |
The export didn't put out the 999$c. |
| 00:30 |
|
|
francesca joined #koha |
| 00:31 |
|
dcook |
mtompset: That's odd. |
| 00:31 |
|
mtompset |
How do you export? |
| 00:31 |
|
wizzyrea |
there might be a report for that in the sql library mrx |
| 00:31 |
|
|
emmah joined #koha |
| 00:31 |
|
dcook |
Using the export bibliographic holdings tool, I believe |
| 00:31 |
|
dcook |
It's been a little whie |
| 00:31 |
|
mtompset |
Because I just trigged an error on MARC non-unicode. |
| 00:32 |
|
mtompset |
Ah... I'm at the biblio and using Save button drop down. |
| 00:32 |
|
dcook |
Interesting |
| 00:32 |
|
wahanui |
Interesting is, like, sometimes good and sometimes bad |
| 00:33 |
|
|
Roman_ joined #koha |
| 00:34 |
|
wizzyrea |
I think they are all in there - you probably need a LIKE instead of an = |
| 00:35 |
|
wizzyrea |
mrx ^ |
| 00:35 |
|
rangi |
academy: 11566 is the bug to attach your accessibility stuff too |
| 00:35 |
|
wizzyrea |
because as you have it, it will only come back if you have one ISBN that matches what you've given. |
| 00:36 |
|
rangi |
emmah, alexh, Roman_ etc |
| 00:37 |
|
mrx |
wizzyrea: http://wiki.koha-community.org[…]L_Reports_Library has all reports or there are some other links too? |
| 00:37 |
|
wizzyrea |
that has all of the user submitted reports, yes |
| 00:38 |
|
|
aleishaa joined #koha |
| 00:38 |
|
|
maximep left #koha |
| 00:38 |
|
dcook |
Hmm? |
| 00:38 |
|
* aleishaa |
waves |
| 00:38 |
|
wizzyrea |
aleishaa? |
| 00:38 |
|
wahanui |
JUST LET ME WORK!!!! |
| 00:38 |
|
wizzyrea |
hehehehehe |
| 00:38 |
|
dcook |
mrx: Searching the 020 using ExtractValue will give you a concatenated string of all the results |
| 00:38 |
|
* francesca |
waves bacl |
| 00:38 |
|
aleisha |
hahahahahaha |
| 00:38 |
|
dcook |
of all the isbns* |
| 00:38 |
|
aleisha |
wizzyrea? |
| 00:38 |
|
wahanui |
somebody said wizzyrea was silly |
| 00:39 |
|
* wizzyrea |
nods |
| 00:39 |
|
* francesca |
waves *back |
| 00:39 |
|
|
MrAgent075 joined #koha |
| 00:39 |
|
wizzyrea |
francesca? |
| 00:39 |
|
wahanui |
I love the 11th doctor! |
| 00:39 |
|
* dcook |
hides |
| 00:39 |
|
wizzyrea |
sorry sorry you're doing work and stuff. We'll stop now |
| 00:40 |
|
dcook |
Work? |
| 00:40 |
|
wahanui |
Work is progressing nicely |
| 00:40 |
|
* dcook |
nods |
| 00:43 |
|
mtompset |
11th or 12th? The whole war doctor caused a bizarre temporal renumbering, I think. Women should explicitly swoon over David Tennant not over an wibbly wobbly timey wimey mess of a number. :P |
| 00:43 |
|
wizzyrea |
ok, now |
| 00:43 |
|
francesca |
well matt smith is the 11th actor to play the doctor so we call him the 11th doctor |
| 00:44 |
|
wizzyrea |
^^ what she said |
| 00:44 |
|
daniel_ |
David is the best doctor |
| 00:44 |
|
wizzyrea |
^^ what he said |
| 00:44 |
|
MrAgent075 |
Agreed. |
| 00:44 |
|
emmah |
yes^^ |
| 00:44 |
|
rangi |
if you wanna know what you changed |
| 00:44 |
|
rangi |
run git status |
| 00:45 |
|
dcook |
Oh, David Tennant...*beams* |
| 00:45 |
|
francesca |
but technically matt smiths doctor was in his last body as the 10th doctor used a regenration to heal himself and kept the same face(the meta crises doctor ) |
| 00:46 |
|
francesca |
and the war doctor (john hurt) was counted as a regeneration as well, making matt smith the 11th doctor, but in his final body |
| 00:47 |
|
wizzyrea |
get the popcorn |
| 00:47 |
|
wahanui |
I'm a bot, wizzyrea. Not a popcorn transfer technician. |
| 00:47 |
|
wizzyrea |
hrmph. |
| 00:47 |
|
francesca |
in the christmas speical the timelords granted matt smith another cycle or regenerations so peter capaldi is the 12th doctor, but the 13th regeneration |
| 00:47 |
|
francesca |
does this help? |
| 00:48 |
|
mtompset |
all find and dandy, but David Tennant beats Matt Smith any day. |
| 00:48 |
|
mtompset |
Oh, and the Doctor doesn't need to be granted another cycle by the TimeLords. |
| 00:49 |
|
francesca |
well he got one anyway |
| 00:49 |
|
mtompset |
His psychopathic wife, River Song, likely gave "all her regenerations" when we revived him in Nazi Germany. :P |
| 00:49 |
|
mtompset |
(Amy said it to River) |
| 00:49 |
|
francesca |
true but we don't actually know that for sure |
| 00:50 |
|
wizzyrea |
popcorn |
| 00:50 |
|
wizzyrea |
popcorn? |
| 00:50 |
|
wahanui |
well, popcorn is a vital part of any work day. |
| 00:50 |
|
wizzyrea |
true. |
| 00:50 |
|
francesca |
lol |
| 00:50 |
|
wizzyrea |
http://persephonemagazine.com/[…]art-popcorn11.gif |
| 00:50 |
|
wizzyrea |
is what I was getting at. |
| 00:50 |
|
francesca |
nice |
| 00:50 |
|
mtompset |
wizzyrea++ # nice link! |
| 00:51 |
|
MrAgent075 |
If that were true, I'd like to see Catalyst 'shouting' their employees (& part-time volunteers) popcorn. |
| 00:54 |
|
mtompset |
What ticks me off is Netflix only has until Season 7 episode 6 with Matt Smith. |
| 00:54 |
|
wizzyrea |
we get fancy coffee and fruit, much more than that is rather stretching it don't you think? |
| 00:54 |
|
pastebot |
"francesca" at 127.0.0.1 pasted "hover link css" (10 lines) at http://paste.koha-community.org/81 |
| 00:54 |
|
francesca |
you may want to take out the > but see if it works with them first |
| 00:55 |
|
francesca |
mtompset if you're looking for a good site to watch doctor who online go to doctorwhomedia.uk |
| 00:55 |
|
* dcook |
gets... |
| 00:55 |
|
dcook |
A place to put his water bottle? |
| 00:55 |
|
MrAgent075 |
@wizzyrea: "You can't always get what you want, but if you try sometimes, you get what you need...." |
| 00:55 |
|
huginn |
MrAgent075: I've exhausted my database of quotes |
| 00:56 |
|
wizzyrea |
ah MrAgent075 you can leave off the @ :) |
| 00:56 |
|
wizzyrea |
@ makes huginn feel crabby. |
| 00:56 |
|
eythian |
yeah, this ain't twitter :) |
| 00:56 |
|
MrAgent075 |
Or Facebook... |
| 00:56 |
|
wahanui |
facebook is *not* a universal authenticator! |
| 00:56 |
|
francesca |
hahahaha |
| 00:57 |
|
francesca |
true though |
| 00:57 |
|
MrAgent075 |
Man, I'm feeling love from the bots today... :D |
| 00:57 |
|
eythian |
@quote random |
| 00:57 |
|
huginn |
eythian: Quote #139: "library_systems_guy: I guess I could put (git-bz) in /usr/games because Koha + git = fun times" (added by wizzyrea at 05:55 PM, May 31, 2011) |
| 00:58 |
|
|
daniel_ joined #koha |
| 00:59 |
|
dcook |
Man...I've had two issues recently where backing up the database and restoring it to dev has fixed issues :S |
| 00:59 |
|
mtompset |
"Doctor Who Media does not fully support Mozilla Firefox." -- oh foobar to them. |
| 00:59 |
|
dcook |
Inexplicably fixed issues.. |
| 01:00 |
|
francesca |
"francesca" at 127.0.0.1 pasted "hover link css" (10 lines) at http://paste.koha-community.org/81 you may want to take out the > but see if it works with them first |
| 01:00 |
|
francesca |
what!! thats sad |
| 01:01 |
|
mtompset |
No such message for IE. |
| 01:01 |
|
mtompset |
Super foobar to them. |
| 01:01 |
|
wizzyrea |
ah yea netflix runs a year behind. If one lived in a place that had netflix. |
| 01:02 |
|
francesca |
we don't have netflix in nz |
| 01:02 |
|
francesca |
do we? |
| 01:02 |
|
MrAgent075 |
We have video streaming services, but I'm not sure if Netflix is operating here... |
| 01:03 |
|
wizzyrea |
you do not technically have netflix here, no. |
| 01:04 |
|
|
yhager joined #koha |
| 01:04 |
|
yhager |
is there a way to send mass email to all library patrons through Koha? |
| 01:04 |
|
wizzyrea |
yhager, no. |
| 01:04 |
|
eythian |
report and mail-merge is the best way |
| 01:04 |
|
wizzyrea |
don't do that, unless every single person in your library has opted in. |
| 01:05 |
|
dcook |
My public library mass emails us :o |
| 01:05 |
|
dcook |
Only about workshops though, and they're always during work :/ |
| 01:05 |
|
dcook |
(They usually look boring anyway) |
| 01:05 |
|
wizzyrea |
that is so wrong, unless you signed something that said it was ok when you registered. |
| 01:05 |
|
* wizzyrea |
considers that abuse of borrower submitted data. |
| 01:05 |
|
dcook |
Hmm |
| 01:06 |
|
* dcook |
tries to remember if he has a copy of that document somewhere |
| 01:06 |
|
yhager |
eythian: mail-merge? |
| 01:07 |
|
eythian |
https://www.google.com/search?[…]ws=0&q=mail+merge <-- yhager |
| 01:07 |
|
mrx |
Another query, if two different users try to update same record at the same time, is it possible to lock the rescord so that other can not edit or some way of managing muliple edits so no change is lost or overwritten? |
| 01:07 |
|
yhager |
eythian: okay, that I can do myself. thought you meant something specific :) |
| 01:07 |
|
eythian |
wizzyrea: it totally depends on your situation, a corporate library could do it happily, as could a special-interest one in general. |
| 01:07 |
|
wizzyrea |
big no no for a public |
| 01:08 |
|
wizzyrea |
a corporate could, because they are presumably employees. |
| 01:08 |
|
dcook |
mrx: As far as I know, there are no locks. |
| 01:09 |
|
yhager |
we are a very small community library, and we have an upcoming event. We'll do it manually this time, but I'll want to set up some system that will allow people to opt-out. |
| 01:09 |
|
dcook |
There should be though |
| 01:09 |
|
wizzyrea |
any library where a borrower self presents and gives data should be opt-in to any emails that are outside standard ILS operations (overdues, holds, fines) |
| 01:09 |
|
* wizzyrea |
has very strong opinions about it |
| 01:09 |
|
* dcook |
has noticed :p |
| 01:10 |
|
rangi |
so if you look at this |
| 01:10 |
|
rangi |
http://opac.library.org.nz/ |
| 01:10 |
|
rangi |
or |
| 01:10 |
|
wizzyrea |
(but I'm not, as it might seem, trying to be actively hostile :)) |
| 01:10 |
|
dcook |
But when you sign up to the library, you're not signing up to the ILS |
| 01:10 |
|
dcook |
You're signing up to the library |
| 01:10 |
|
rangi |
http://ils.stdc.govt.nz/ |
| 01:10 |
|
rangi |
or |
| 01:10 |
|
dcook |
That said, I think you have a point about specifying it in your terms of library membership though.. |
| 01:10 |
|
wizzyrea |
the library still needs to declare their intentions with your data |
| 01:10 |
|
rangi |
http://library.waitaki.govt.nz/ |
| 01:10 |
|
dcook |
wizzyrea: Agreed |
| 01:10 |
|
* dcook |
really wonders where his membership doc is now... |
| 01:11 |
|
mtompset |
francesca: The site was http://doctorwhomedia.co.uk/ |
| 01:11 |
|
dcook |
I signed up before I got my personal filing system up and running.. |
| 01:11 |
|
mrx |
dcook: humm ok |
| 01:11 |
|
dcook |
mrx: I've never known it to be an issue, but it's theoretically possible |
| 01:11 |
|
dcook |
For there to be mangling that is |
| 01:12 |
|
wizzyrea |
even in big systems, it's pretty rare for two librarians to be working on the exact same record at the exact same time. The workflow just generally doesn't work that way |
| 01:12 |
|
wizzyrea |
if you have an example of a workflow where this would be an issue I'm sure we'd be happy to hear it |
| 01:13 |
|
jcamins |
wizzyrea: dueling catalogers! |
| 01:13 |
|
wizzyrea |
get your banjo! |
| 01:14 |
|
mtompset |
dcook: YAY! I got it tested for steps 5-7. |
| 01:16 |
|
* wizzyrea |
suspects that "installing pazpar2"will become relevant when this external searches patch gets in |
| 01:16 |
|
|
rambutan joined #koha |
| 01:16 |
|
dcook |
wizzyrea: Yarp. That's partially why I want to test the patch.. |
| 01:17 |
|
|
rocio left #koha |
| 01:17 |
|
wizzyrea |
that's what I'm trying to do |
| 01:17 |
|
dcook |
\o/ |
| 01:18 |
|
dcook |
Hence wanting pianohacker to come along, yes? |
| 01:18 |
|
wizzyrea |
heh yea |
| 01:18 |
|
|
MrAgent075 joined #koha |
| 01:20 |
|
rangi |
http://catalogue.bu.univ-rennes2.fr/ |
| 01:24 |
|
MrAgent075 |
@quote random |
| 01:24 |
|
huginn |
MrAgent075: Quote #210: "< oleonard> You could carpet a floor in FIXME's from C4/Search" (added by jcamins at 12:35 PM, July 17, 2012) |
| 01:26 |
|
mrx |
I'm not sure will the scenario fit in real library system or not but at the moment we have different users responsible for handling title descriptions and title subject headings and came across simultaneous record updatation problems |
| 01:27 |
|
jcamins |
I have three pizzas worth of dough left, but no idea what to put on them. |
| 01:28 |
|
jcamins |
I already have two pizzas worth of caramelized onion-goat cheese. |
| 01:28 |
|
jcamins |
Advice welcomed. |
| 01:29 |
|
MrAgent075 |
I wonder what the conversion equation for pizza worth to kg is... |
| 01:29 |
|
MrAgent075 |
Because I can't precisely imagine a pizza worth of anything. |
| 01:30 |
|
jcamins |
MrAgent075: I mean, I already made two full pizzas with caramelized onion and goat cheese. ;) |
| 01:30 |
|
MrAgent075 |
jcamins: I see... :) |
| 01:30 |
|
francesca |
pizza! |
| 01:30 |
|
gmcharlt |
Catalyst_Academy++ # moar prettier dashboard |
| 01:31 |
|
MrAgent075 |
Umm... Hmm... Depends on what's available. |
| 01:31 |
|
wizzyrea |
francesca++ |
| 01:31 |
|
francesca |
:) |
| 01:33 |
|
rangi |
francesca: https://www.ohloh.net/p/koha_d[…]tributors/summary |
| 01:33 |
|
rangi |
everyone else |
| 01:34 |
|
rangi |
https://www.ohloh.net/p/koha/c[…]time_span=30+days |
| 01:34 |
|
MrAgent075 |
I haz an idea for pizza jcamins. |
| 01:34 |
|
MrAgent075 |
jcamins: Just alot of Cheese... |
| 01:34 |
|
rangi |
https://www.ohloh.net/p/koha |
| 01:35 |
|
jcamins |
MrAgent075: I don't really have much in the way of cheese. |
| 01:35 |
|
jcamins |
I decided to do a cinnamon sugar flatbread. |
| 01:36 |
|
rangi |
if you claim your commits |
| 01:36 |
|
rangi |
then you get |
| 01:36 |
|
rangi |
https://www.ohloh.net/accounts/ranginui |
| 01:37 |
|
francesca |
so do we claim them? |
| 01:37 |
|
mtompset |
francesca++ # dr. who fan and 2 commits in 23 hours |
| 01:38 |
|
francesca |
:) |
| 01:38 |
|
MrAgent075 |
jcamins: Good way to go - wish I could try them. |
| 01:39 |
|
rangi |
http://meta.ohloh.net/2013/07/[…]ing-ohloh-badges/ |
| 01:40 |
|
Roman_ |
daniel_? |
| 01:40 |
|
mrx |
thanks wizzyrea: I'm not sure will the scenario fit in real library system or not but at the moment we have different users responsible for handling title descriptions and title subject headings and came across simultaneous record updatation problems |
| 01:44 |
|
francesca |
@quote random |
| 01:44 |
|
huginn |
francesca: Quote #13: "<atz> ricardo: ask and ye shall receive.... eventually, ye shall stop asking." (added by gmcharlt at 08:31 PM, July 09, 2009) |
| 01:45 |
|
MrAgent075 |
I wonder how we can create quotes on here... |
| 01:48 |
|
MrAgent075 |
wizzyrea: PROGRESS // The bar in add-item.pl is working & is fixed. Just thinking... Might place it down at the bottom of the page. All-in-all, it is functioning. |
| 01:48 |
|
wizzyrea |
ohhh nice |
| 01:48 |
|
wizzyrea |
! |
| 01:48 |
|
wizzyrea |
MrAgent075++ |
| 01:49 |
|
wizzyrea |
mrx: hm, yeah that'd do it. What kind of library? |
| 01:52 |
|
* dcook |
shakes his fists and shouts "Double-encoding!!!" |
| 01:56 |
|
mtompset |
MrAgent075: could it be were someone doesn't have to scroll? -- Just noting my dislike for scrolling. :) |
| 01:57 |
|
MrAgent075 |
mtompset: like... let's say... if the bar was to appear at the bottom of the screen already? Or that it'd be at the top? I think either option would be sensibly possible. |
| 01:57 |
|
wizzyrea |
MrAgent075: I think it should closely mirror the cataloguing interface |
| 01:57 |
|
wizzyrea |
i.e. at the top, and floating. |
| 01:58 |
|
MrAgent075 |
Brill, will keep it at the top... But what about the table? ... :/ |
| 01:58 |
|
wizzyrea |
:) a problem to solve |
| 01:59 |
|
mtompset |
well, sometimes pages put things at the bottom, and the content in between varies. |
| 01:59 |
|
wizzyrea |
mtompset: the thing he is working on is making the add item save button float like the buttons do in cataloguing. |
| 01:59 |
|
wizzyrea |
on the edit bib page. |
| 01:59 |
|
mtompset |
Okay. :) |
| 01:59 |
|
rangi |
Roman_: http://bugs.koha-community.org[…]_bug.cgi?id=11089 <-- see if you can fix this |
| 02:00 |
|
huginn |
Bug 11089: enhancement, P5 - low, ---, oleonard, NEW , Item edit screen should use floating toolbar like cataloging interface |
| 02:00 |
|
MrAgent075 |
'additem.pl' had the buttons on the bottom, originally. |
| 02:00 |
|
mtompset |
Anyways. |
| 02:00 |
|
mtompset |
So, let's say we have a bug, and there's a problem, and I fix it while testing it for sign off. Do I still sign off? |
| 02:00 |
|
wizzyrea |
ooh now it's a race ^.^ |
| 02:01 |
|
gmcharlt |
mtompset: yes, assuming it's a correction, and not, say, a follow-up that completely revamps the patch |
| 02:01 |
|
rangi |
http://bugs.koha-community.org[…]_bug.cgi?id=11363 <-- fair game too for someone |
| 02:01 |
|
huginn |
Bug 11363: minor, P5 - low, ---, koha-bugs, NEW , Label printer profile units are not translatable |
| 02:02 |
|
mtompset |
for example, gmcharlt, there was a string quoting problem. I fixed the string quoting problem, so the patch would do what it was supposed to do. |
| 02:02 |
|
gmcharlt |
mtompset: yep, that's small enough |
| 02:02 |
|
gmcharlt |
a larger follow-up you might attach to the bug, and ask the original patch submitter to sign off on your follow-up |
| 02:02 |
|
mtompset |
okay... just checking. :) |
| 02:04 |
|
mrx |
wizzyrea: we have an online bookstore (wheelers.co.nz) and at the moment offering custom developed ebook lending system to libraries but we are evaluating koha for marc record management as a separate solution, if possible |
| 02:04 |
|
wizzyrea |
Ah cool! |
| 02:05 |
|
|
yhager joined #koha |
| 02:06 |
|
mtompset |
dcook: finally. the bug is signed off. :) |
| 02:07 |
|
* wizzyrea |
swears a bit at pazpar2 |
| 02:07 |
|
wizzyrea |
on an outside chance that anyone knows, what is the config file you start it with for Koha? |
| 02:08 |
|
gmcharlt |
etc/pazpar2/pazpar2.xml |
| 02:09 |
|
wizzyrea |
yay thank you gmcharlt |
| 02:09 |
|
gmcharlt |
also see misc/bin/koha-pazpar2-ctl.sh |
| 02:09 |
|
wizzyrea |
gmcharlt++ |
| 02:09 |
|
wizzyrea |
<3 thank you |
| 02:10 |
|
wizzyrea |
that, I feel like that is not written down anywhere. |
| 02:11 |
|
* wizzyrea |
says, realising that the manual was not consulted |
| 02:11 |
|
* wizzyrea |
facepalms |
| 02:12 |
|
wizzyrea |
oh, doesn't matter anyway because it's not there. |
| 02:12 |
|
* gmcharlt |
makes no guarantees that it got documented, given the age and relative disused of the feature |
| 02:13 |
|
wizzyrea |
well it's about to become relevant |
| 02:13 |
|
gmcharlt |
http://librarypolice.com/wiki.[…]ndmetasearch.html |
| 02:15 |
|
|
rambutan joined #koha |
| 02:18 |
|
|
Emma_ joined #koha |
| 02:19 |
|
|
papa joined #koha |
| 02:20 |
|
wizzyrea |
ohh thanks |
| 02:29 |
|
dcook |
When comparing two systems that seem to have the same code and the same database...it helps to make sure they have the same indexing configuration |
| 02:29 |
|
* dcook |
facepalm |
| 02:29 |
|
wahanui |
facepalm is a tiny member of the Arecaceae family whose preference for warm, humid environments makes it a perfect choice for cultivation in the human nasal cavity. |
| 02:35 |
|
mtompset |
Arecaceae ... *laugh* |
| 02:36 |
|
eythian |
It's the traditional family for palms |
| 02:41 |
|
mtompset |
Yes, which is why it is funny. |
| 02:43 |
|
mtompset |
Out of curiosity, are hypens in an ISBN13 in any particular positions? |
| 02:44 |
|
|
MrAgent075 joined #koha |
| 02:45 |
|
rangi |
ok. we are gonna finish at 4.30 today |
| 02:46 |
|
pastebot |
"francesca" at 127.0.0.1 pasted "font change for header" (7 lines) at http://paste.koha-community.org/82 |
| 02:49 |
|
francesca |
@quote random |
| 02:49 |
|
huginn |
francesca: Quote #213: "jwagner: There are few problems that can't be solved with patience, ingenuity, and a large kick in the pants (assuming servers wear pants, that is)." (added by wizzyrea at 06:18 PM, August 07, 2012) |
| 02:52 |
|
MrAgent075 |
Now getting onboard the Dashboard Train. |
| 02:57 |
|
pastebot |
"francesca" at 127.0.0.1 pasted "more code for header" (5 lines) at http://paste.koha-community.org/83 |
| 02:58 |
|
rangi |
MrAgent075: http://wiki.koha-community.org[…]ack-and-white.jpg |
| 02:58 |
|
rangi |
http://wiki.koha-community.org[…]f-client-logo.svg |
| 03:02 |
|
eythian |
ah good, there is an svg logo |
| 03:03 |
|
wizzyrea |
hm those are somewhere in the git repo as well I think... |
| 03:07 |
|
francesca |
@quote random |
| 03:07 |
|
huginn |
francesca: Quote #39: "chris <chris> nope, ive made it my aim in life not to learn js or html" (added by ricardo at 06:00 PM, October 07, 2009) |
| 03:08 |
|
pastebot |
"francesca" at 127.0.0.1 pasted "changing font for h3" (5 lines) at http://paste.koha-community.org/84 |
| 03:13 |
|
francesca |
chris you also need to do the same thing to .span8 h3 { |
| 03:20 |
|
aleisha |
https://docs.google.com/file/d[…]ZVJReUN6T29n/edit |
| 03:20 |
|
francesca |
thanks |
| 03:22 |
|
wizzyrea |
MrAgent075 is funny |
| 03:23 |
|
MrAgent075 |
#memories |
| 03:24 |
|
francesca |
you kept going on in the presentation about how the nav bar was awful in design terms, yet your presentation is pretty much entirely purple and orange... |
| 03:30 |
|
wizzyrea |
ohsnap |
| 03:32 |
|
francesca |
goodbyyye! see you/talk to you tomorrow :) |
| 03:47 |
|
pastebot |
"MrAgent075" at 127.0.0.1 pasted "logo for Koha Dashboard" (23 lines) at http://paste.koha-community.org/85 |
| 03:55 |
|
|
Oak joined #koha |
| 04:00 |
|
wizzyrea |
that url is going to be problematic |
| 04:00 |
|
wizzyrea |
for the image |
| 04:01 |
|
MrAgent075 |
Which is why it should be uploaded to the server that is operating the Dashboard site. |
| 04:01 |
|
MrAgent075 |
I can't do that... |
| 04:09 |
|
|
coreyfromaotea joined #koha |
| 04:11 |
|
|
MrAgent075 joined #koha |
| 04:11 |
|
mtompset |
@later tell cait Remember that loss of currency problem on basket groups? Check out bug 11471. |
| 04:11 |
|
huginn |
mtompset: The operation succeeded. |
| 04:13 |
|
mtompset |
Anyone want a simple signoff? :) |
| 04:14 |
|
mtompset |
It helps stop floody warnings when you are setting up a library's patron categories. :) |
| 04:16 |
|
MrAgent075 |
wizzyrea: better URL (not temporary :] // http://files.pilcrowsquared.com/koha_128dpi.png) |
| 04:16 |
|
MrAgent075 |
wizzyrea: is that alright? |
| 04:20 |
|
|
yhager joined #koha |
| 04:23 |
|
|
dac joined #koha |
| 04:30 |
|
mtompset |
Well, have a great day (24 hour period), #koha wizzyrea MrAgent075 dac Oak and others. :) |
| 04:45 |
|
eythian |
rangi: there is definitely a memory leak under plack. Where do you change things like how many requests it does before a restart I want to experiment with it. |
| 04:49 |
|
eythian |
oh, it's in the init script |
| 04:54 |
|
dcook |
10 minutes and I'm at the Koha web installer |
| 04:54 |
|
dcook |
Not bad |
| 04:55 |
|
dcook |
I even dawdled at the beginning... |
| 04:57 |
|
eythian |
hmm, I just hit memory limits with plack on a 3GB machine. This is going to need some tuning. |
| 04:57 |
|
dcook |
13 minutes! |
| 04:57 |
|
dcook |
pas mal |
| 05:22 |
|
eythian |
starman seems to reap memory more when it's not busy. That's unfortunate. |
| 05:34 |
|
|
yhager joined #koha |
| 05:43 |
|
dcook |
When using Debian packages, are we defaulting to DOM indexing with 3.14? |
| 05:43 |
|
eythian |
no, not yet |
| 05:43 |
|
dcook |
Huh... |
| 05:43 |
|
dcook |
Ok, thanks, eythian :) |
| 05:43 |
|
eythian |
I don't think so anyway |
| 05:44 |
|
dcook |
I suppose I could just check the files.. |
| 05:44 |
|
eythian |
I'd look, but I'm in the middle of seeing how far I can push a production Koha server without it falling over, and really don't want it to fall over :) |
| 05:44 |
|
* gmcharlt |
has just looked at it -- the default is indeed DOM nowadays |
| 05:44 |
|
dcook |
No worries, eythian |
| 05:45 |
|
dcook |
gmcharlt: Thanks. That makes sense. |
| 05:45 |
|
eythian |
gmcharlt: for packages? |
| 05:45 |
|
dcook |
Is there any way to specify grs1 instead? |
| 05:45 |
|
gmcharlt |
eythian: yep, unless you're munging koha-create when you package |
| 05:45 |
|
gmcharlt |
see commit aba3db26 (when you're not tortuing a poor, defenseless server, that is) |
| 05:46 |
|
gmcharlt |
;) |
| 05:46 |
|
dcook |
Just checked as well. Defo DOM. |
| 05:46 |
|
gmcharlt |
dcook: and yes -- koha-create --biblio-dix grs1 ... |
| 05:46 |
|
eythian |
ah, I remember that now :) |
| 05:46 |
|
gmcharlt |
er |
| 05:46 |
|
gmcharlt |
--biblio-idx |
| 05:46 |
|
dcook |
Ah, yes |
| 05:46 |
|
dcook |
Excellent |
| 05:46 |
|
* paxed |
is getting high blood pressure before 8am... |
| 05:46 |
|
dcook |
gmcharlt++ |
| 05:46 |
|
dcook |
eythian++ |
| 05:46 |
|
dcook |
paxed: Indexing related? |
| 05:46 |
|
paxed |
dcook: translation related. |
| 05:47 |
|
eythian |
it was just gmcharlt, I lied to you :) |
| 05:47 |
|
dcook |
eythian: Your answer might not have been correct, but the spirit was there :) |
| 05:47 |
|
dcook |
Unless you were meaning to mislead me... |
| 05:47 |
|
dcook |
In which case, points for seeming genuine! |
| 05:48 |
|
dcook |
Now what was I doing.. |
| 05:48 |
|
eythian |
OK, 2000 requests to opac-detail, 10 concurrent, mean response time 350ms and memory use peaked at about 60%. Now I'm getting somewhere. |
| 05:48 |
|
paxed |
just out of curiosity, is owen leonard american? |
| 05:49 |
|
gmcharlt |
yep |
| 05:49 |
|
paxed |
do you happen to know if he speaks any other language than english? |
| 05:50 |
|
dcook |
Ooo the man page for koha-create has been updated. That's handy.. |
| 05:50 |
|
dcook |
paxed: I think he speaks some Czech |
| 05:50 |
|
eythian |
dcook: yeah, magnus_away is good for making sure that happens. |
| 05:50 |
|
eythian |
it might also have a good --help, some of the scripts do |
| 05:51 |
|
dcook |
Hmm, not sure that I necessarily understand --use-database.. |
| 05:51 |
|
dcook |
Actually, I think I do, and it's not what I'm thinking |
| 05:52 |
|
eythian |
It lets you use a pre-existing mysql database instead of creating one |
| 05:52 |
|
dcook |
Well, what I want to do is clone a DB |
| 05:52 |
|
dcook |
Or can you have two instances running off the same DB with different config? |
| 05:52 |
|
eythian |
my method for that is to do a dump, and then after a koha-create load the dump in. |
| 05:52 |
|
eythian |
I really wouldn't do that |
| 05:53 |
|
dcook |
Yeah, it sounds mental |
| 05:53 |
|
eythian |
you _can_ but it's probably not a good idea |
| 05:53 |
|
eythian |
there's also not much point |
| 05:54 |
|
dcook |
How do you load the dump into a koha-create? |
| 05:54 |
|
dcook |
Ideally, that's what I was thinking of doing, but I don't see a place to specify the name of the new instance |
| 05:54 |
|
eythian |
it depends, but generally you can do cat dump.sql | sudo koha-mysql newinstance |
| 05:55 |
|
dcook |
Interesting...I'll give that a shot |
| 05:55 |
|
eythian |
there are situations where that may abort (primarily if the dump has 'use koha_anothername'), in which case you can do sudo koha-mysql instance and then use \. to load the dump |
| 05:56 |
|
eythian |
the first way uses one transaction so the wrong name causes the whole load to abort, the second doesn't. |
| 05:56 |
|
dcook |
I was wondering about 'use koha_anothername' |
| 05:57 |
|
eythian |
in the second case, the use fails, but everything else works. |
| 05:57 |
|
eythian |
so that's OK |
| 05:57 |
|
dcook |
Oooh :D |
| 05:58 |
|
* eythian |
has zebra using 20% CPU and koha using the remaining 180%... |
| 06:01 |
|
dcook |
All right, let's give this a go.. |
| 06:01 |
|
eythian |
978ms per search, not too bad, but you don't want to be doing 10 at once. A mean of nearly 10 seconds per request. |
| 06:02 |
|
eythian |
I don't think I can squeeze more performance out of this server, but I know it's not going to go down in a flaming heap. |
| 06:02 |
|
eythian |
could do with 2 more cores really. |
| 06:02 |
|
dcook |
Hmm, that's not good.. |
| 06:03 |
|
* dcook |
mutters to himself |
| 06:03 |
|
|
rambutan joined #koha |
| 06:03 |
|
dcook |
mysqldump: Got error: 1045: Access denied for user 'koha_devone'@'localhost' (using password: YES) when using LOCK TABLES |
| 06:03 |
|
eythian |
hmm |
| 06:03 |
|
eythian |
oh |
| 06:03 |
|
eythian |
that's not koha |
| 06:03 |
|
eythian |
(as in, not an error from koha) |
| 06:03 |
|
dcook |
Yeah, I know. Mysql error. |
| 06:04 |
|
dcook |
But not sure why.. |
| 06:04 |
|
wahanui |
somebody said not sure why was still pulling it |
| 06:04 |
|
eythian |
are you using the right password? |
| 06:04 |
|
dcook |
I dumped the same database not that long ago |
| 06:04 |
|
dcook |
I'm just using koha-dump |
| 06:04 |
|
eythian |
oh |
| 06:04 |
|
eythian |
that is an error from koha then |
| 06:04 |
|
eythian |
sorta |
| 06:04 |
|
eythian |
that's not expected |
| 06:04 |
|
eythian |
unless you've manually created that db |
| 06:04 |
|
dcook |
Hmm, perhaps I broke it the first time.. |
| 06:05 |
|
dcook |
Yep |
| 06:05 |
|
eythian |
then you probably didn't grant access to it |
| 06:05 |
|
dcook |
Interesting |
| 06:05 |
|
wahanui |
hmmm... Interesting is sometimes good and sometimes bad |
| 06:05 |
|
dcook |
Mmm, right |
| 06:05 |
|
dcook |
Because I loaded it up as the root user as the koha user couldn't do it |
| 06:06 |
|
eythian |
yeah, you can't do that |
| 06:06 |
|
eythian |
well, you shouldn't do that |
| 06:06 |
|
eythian |
because then this happens :) |
| 06:06 |
|
dcook |
hehe |
| 06:06 |
|
dcook |
Indeed. |
| 06:06 |
|
eythian |
a grant _might_ take care of it |
| 06:06 |
|
dcook |
I'll just start over..sort of |
| 06:07 |
|
dcook |
Interesting...that first method didn't work.. |
| 06:07 |
|
dcook |
ERROR 1227 (42000) at line 140990: Access denied; you need (at least one of) the SUPER privilege(s) for this operation |
| 06:08 |
|
eythian |
you'll have to grant as the root user |
| 06:08 |
|
|
cait joined #koha |
| 06:08 |
|
eythian |
hi cait |
| 06:08 |
|
dcook |
When doing " cat dump.sql | sudo koha-mysql newinstance" ? |
| 06:09 |
|
eythian |
well in that case, you'll have to grant to the database for the koha user |
| 06:09 |
|
eythian |
or see what like 140990 is. |
| 06:09 |
|
eythian |
maybe it's something weird |
| 06:09 |
|
* cait |
waves |
| 06:10 |
|
dcook |
heya cait :) |
| 06:10 |
|
cait |
hi dcook and eythian |
| 06:14 |
|
dcook |
Hmmm, I think koha_devone and koha_devtwo have full privileges? :S |
| 06:14 |
|
eythian |
what does that mean? |
| 06:14 |
|
dcook |
" GRANT ALL PRIVILEGES ON `koha_devtwo`.* TO 'koha_devtwo'@'%'" |
| 06:14 |
|
dcook |
So I'm wondering why there were those issues with dumping/restoring.. |
| 06:15 |
|
eythian |
there's some oddness with the way that mysql does privileges sometimes. |
| 06:15 |
|
eythian |
s/privileges/anything/ |
| 06:16 |
|
dcook |
Seems like it :S |
| 06:16 |
|
eythian |
in particular, I'm not sure you want @'%' |
| 06:16 |
|
eythian |
have a look at how koha-create does it. |
| 06:17 |
|
dcook |
CREATE DATABASE \`$mysqldb\`; |
| 06:17 |
|
dcook |
CREATE USER \`$mysqluser\`@'$mysql_hostname' IDENTIFIED BY '$mysqlpwd'; |
| 06:17 |
|
dcook |
CREATE USER \`$mysqluser\`@'%' IDENTIFIED BY '$mysqlpwd'; |
| 06:17 |
|
dcook |
GRANT ALL PRIVILEGES ON \`$mysqldb\`.* TO \`$mysqluser\`; |
| 06:17 |
|
dcook |
FLUSH PRIVILEGES; |
| 06:17 |
|
eythian |
yeah that |
| 06:17 |
|
wahanui |
yeah that is golded jcamins |
| 06:18 |
|
dcook |
Huh... |
| 06:18 |
|
dcook |
Yeah, when i look at the user table, it looks like the koha_ users don't have that many privileges.. |
| 06:19 |
|
eythian |
it's not just a user, it's also correlated with where you're connecting from |
| 06:19 |
|
dcook |
Right. The error said localhost annd there are entries in the user table for localhost as the host as well |
| 06:20 |
|
dcook |
But I can dump devtwo but not devone (possibly because of that earlier manual mangling job I did) |
| 06:21 |
|
rangi |
eythian: i remapped capslock to left shift |
| 06:21 |
|
rangi |
(*()#$&#$#* |
| 06:21 |
|
rangi |
and i can do that again |
| 06:22 |
|
eythian |
rangi: that is totally bizarre |
| 06:22 |
|
rangi |
still cant do a exclamation mark |
| 06:22 |
|
rangi |
but everythign else works |
| 06:22 |
|
rangi |
yeah it really is |
| 06:22 |
|
eythian |
no not-equals for j00! |
| 06:22 |
|
rangi |
xmodmap -e "keycode 66 = Shift_L" |
| 06:22 |
|
eythian |
map another key you never use to !. Like z, no one needs z. |
| 06:23 |
|
dcook |
Hmm that second method got further.. |
| 06:23 |
|
rangi |
:) |
| 06:24 |
|
dcook |
wtf... |
| 06:24 |
|
rangi |
good idea there is the menu key over by the right control |
| 06:24 |
|
rangi |
i never use that |
| 06:24 |
|
dcook |
My first database appears to have disappeared.. |
| 06:24 |
|
dcook |
That might be why it couldn't dump.. |
| 06:24 |
|
rangi |
can someone fire up xev |
| 06:25 |
|
eythian |
that's my có₥pøśê key |
| 06:25 |
|
rangi |
and tell me what the name is when they push shift+1 |
| 06:25 |
|
dcook |
Oh wait, I'm an idiot.. |
| 06:25 |
|
eythian |
KeyPress event, serial 34, synthetic NO, window 0x3600001, |
| 06:25 |
|
eythian |
root 0xb6, subw 0x0, time 1023361165, (502,530), root:(2423,602), |
| 06:25 |
|
eythian |
state 0x11, keycode 10 (keysym 0x21, exclam), same_screen YES, |
| 06:25 |
|
eythian |
XLookupString gives 1 bytes: (21) "!" |
| 06:25 |
|
eythian |
XmbLookupString gives 1 bytes: (21) "!" |
| 06:25 |
|
eythian |
XFilterEvent returns: False |
| 06:26 |
|
rangi |
cool exclam |
| 06:26 |
|
rangi |
thanks |
| 06:26 |
|
rangi |
!!!! |
| 06:26 |
|
rangi |
yay |
| 06:26 |
|
rangi |
!! |
| 06:26 |
|
rangi |
i can write #! again |
| 06:27 |
|
rangi |
bizzare |
| 06:27 |
|
rangi |
but workable |
| 06:27 |
|
eythian |
it sure sounds like something liquid or otherwise conductive got in there. |
| 06:28 |
|
* dcook |
has no idea what happened in the end, but thinks he has a workable solution? |
| 06:28 |
|
dcook |
eythian++ |
| 06:28 |
|
rangi |
yeah the weird thing is in xev if i hit left shift |
| 06:28 |
|
rangi |
it all works fine |
| 06:28 |
|
eythian |
oh, curiouser and curiouser. |
| 06:28 |
|
rangi |
state 0x1, keycode 50 (keysym 0xffe1, Shift_L), same_screen YES, |
| 06:28 |
|
rangi |
but if i push shift and 1 |
| 06:28 |
|
rangi |
xev sees nothing |
| 06:29 |
|
eythian |
ah |
| 06:29 |
|
eythian |
yeah, something is munted in hardware. |
| 06:30 |
|
rangi |
yeah gotta be |
| 06:32 |
|
dcook |
After all that, my conclusion is...grs1 blows. |
| 06:33 |
|
dcook |
And that ampersands get encoded and recoded way too many times in way too many spots.. |
| 06:34 |
|
dcook |
Oh, but I was going to look at the TT filter... |
| 06:34 |
|
dcook |
But it's 5:34... |
| 06:35 |
|
eythian |
rangi: I've found a starman configuration that gets slow under high load, but never seems to run out of RAM. It's all CPU bound now, which is nicer. |
| 06:36 |
|
rangi |
excellent |
| 06:37 |
|
dcook |
Maybe one more experiment before the gym.. |
| 06:42 |
|
dcook |
Bleargh. Whatever. |
| 06:46 |
|
dcook |
night all |
| 06:46 |
|
wahanui |
goodnight dcook. You'll be back. |
| 06:46 |
|
dcook |
thanks again, eythian |
| 07:06 |
|
cait |
time for the dentist... ew. |
| 07:06 |
|
cait |
bbl |
| 07:06 |
|
|
cait left #koha |
| 07:15 |
|
|
laurence joined #koha |
| 07:46 |
|
|
marcelr joined #koha |
| 07:46 |
|
|
magnuse joined #koha |
| 07:47 |
|
* magnuse |
waves |
| 07:49 |
|
|
reiveune joined #koha |
| 07:49 |
|
magnuse |
bonjour reiveune |
| 07:49 |
|
magnuse |
@wunder boo |
| 07:49 |
|
huginn |
magnuse: The current temperature in Bodo, Norway is -7.0°C (8:20 AM CET on January 16, 2014). Conditions: Clear. Humidity: 58%. Dew Point: -14.0°C. Windchill: -18.0°C. Pressure: 30.18 in 1022 hPa (Steady). |
| 07:50 |
|
magnuse |
windchill-- |
| 07:50 |
|
reiveune |
hello |
| 07:50 |
|
wahanui |
kai ora, reiveune |
| 07:52 |
|
|
paul_p joined #koha |
| 07:52 |
|
magnuse |
kia ora paul_p |
| 07:54 |
|
paul_p |
hi magnuse. Just read a mail from Arve (oslo p.l.) . Good new ;-) |
| 07:54 |
|
marcelr |
hi #koha magnuse reiveune paul_p |
| 07:55 |
|
|
alex_a joined #koha |
| 07:56 |
|
alex_a |
bonjour |
| 07:56 |
|
marcelr |
hi alex_a |
| 07:59 |
|
magnuse |
paul_p: yup :-) |
| 08:09 |
|
|
sophie_m joined #koha |
| 08:10 |
|
|
alexia joined #koha |
| 08:18 |
|
alexia |
hello! we have a problem with our koha installation. We had a server crash a couple of days ago, and after we managed to bring it back online, the system does not return any results when searcing bibliographic records or authorities. I have re-indexed the system but still nothing appears. We also get some lock errors on the |
| 08:18 |
|
alexia |
file /var/log/koha/koha-zebra-daemon-output.log |
| 08:19 |
|
alexia |
10:07:35-16/01 zebrasrv(9) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/authorities/shadow..LCK [Permission denied] 10:07:45-16/01 zebrasrv(10) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/norm..LCK [Permission denied] 10:07:45-16/01 zebrasrv(10) [warn] zebra_lock_create fail fname=/var/lock/koha/zebradb/biblios/shadow..LCK [Permission denied] |
| 08:19 |
|
alexia |
any help? |
| 08:19 |
|
wahanui |
i guess any help is appreciated ;) |
| 08:19 |
|
|
HB joined #koha |
| 08:20 |
|
HB |
Hey koha i try to run build_oai_sets.pl i get Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl /5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/pe rl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at ./build_oai_sets.pl line 45. |
| 08:20 |
|
HB |
annyone has tips ? |
| 08:23 |
|
|
alexia joined #koha |
| 08:23 |
|
|
alexia joined #koha |
| 08:25 |
|
|
ashimema joined #koha |
| 08:26 |
|
|
cait joined #koha |
| 08:27 |
|
cait |
ah no Joubu yet |
| 08:27 |
|
|
gaetan_B joined #koha |
| 08:27 |
|
cait |
hi gaetan_B :) |
| 08:27 |
|
gaetan_B |
hello :) |
| 08:28 |
|
ashimema |
Mornin' all |
| 08:28 |
|
cait |
hi ashimema :) |
| 08:31 |
|
HB |
hey |
| 08:48 |
|
|
gaetan_B joined #koha |
| 08:51 |
|
|
papa joined #koha |
| 08:57 |
|
paxed |
cait: in commit bbe6497 there's +VALUES( 'Laoo', 'script', 'en', 'Laotisch'); in file installer/data/mysql/de-DE/mandatory/subtag_registry.sql -- that should be 'de', not 'en', right? |
| 08:57 |
|
cait |
paxed: i think you might be right, but can't look at the file right now :( |
| 08:57 |
|
cait |
if you file a bug somewhere i will take a look later |
| 08:57 |
|
cait |
probably me who messed it up in the first place |
| 08:59 |
|
cait |
ok, meeting time |
| 08:59 |
|
wahanui |
i think meeting time is always going to favour one section of the globe |
| 08:59 |
|
cait |
bbl |
| 09:01 |
|
magnuse |
have fun cait! |
| 09:03 |
|
|
MrAgent075 joined #koha |
| 09:04 |
|
magnuse |
paul_p: has the hackfest been announced officially yet? |
| 09:05 |
|
paul_p |
magnuse nope, it's on my todo list. But date are marc 10-14th |
| 09:08 |
|
magnuse |
paul_p: yup, but some people might need an "official" announcement to refer to, to get the green light to go :-) |
| 09:09 |
|
paul_p |
magnuse yes, I know. could you ask God to add 12 hours to each day please ;-) |
| 09:15 |
|
magnuse |
paul_p: will do! ;-) |
| 09:17 |
|
|
Joubu joined #koha |
| 09:17 |
|
Joubu |
hello |
| 09:19 |
|
magnuse |
bonjour Joubu |
| 09:22 |
|
marcelr |
hi Joubu |
| 09:26 |
|
HB |
is there a command to get your intance |
| 09:30 |
|
magnuse |
HB: if you installed with the packages you can do "sudo koha-list" to see all your instances |
| 09:34 |
|
HB |
thx got it running but just to be sure (thx fr the mail) i would not have found it myself ++++ |
| 09:40 |
|
magnuse |
HB: do "man koha-common" for a list of available koha-* commands :-) |
| 09:42 |
|
HB |
aha more secrets reveiled :) |
| 09:54 |
|
paxed |
cait: UPDATE systempreferences SET value = 'FR' WHERE variable = 'CurencyFormat'; -- should be Cur_r_ency? |
| 10:33 |
|
|
kathryn joined #koha |
| 10:33 |
|
|
druthb_away joined #koha |
| 10:33 |
|
|
jeff__ joined #koha |
| 10:33 |
|
|
nlegrand joined #koha |
| 10:33 |
|
|
eythian joined #koha |
| 10:33 |
|
|
aquaman joined #koha |
| 10:33 |
|
|
cjh joined #koha |
| 10:33 |
|
|
fredericd joined #koha |
| 10:41 |
|
|
Joubu joined #koha |
| 10:41 |
|
|
cait joined #koha |
| 10:41 |
|
|
ashimema joined #koha |
| 10:41 |
|
|
paul_p joined #koha |
| 10:41 |
|
|
reiveune joined #koha |
| 10:41 |
|
|
magnuse joined #koha |
| 10:41 |
|
|
wahanui joined #koha |
| 10:41 |
|
|
janPasi joined #koha |
| 10:41 |
|
|
BobB joined #koha |
| 10:41 |
|
|
liw joined #koha |
| 10:41 |
|
|
clrh joined #koha |
| 10:41 |
|
|
paxed joined #koha |
| 10:41 |
|
|
ibeardslee joined #koha |
| 10:41 |
|
|
halcyonCorsair joined #koha |
| 10:41 |
|
|
slef joined #koha |
| 10:41 |
|
|
wizzyrea joined #koha |
| 11:12 |
|
magnuse |
woooo that was fun |
| 12:03 |
|
|
tcohen joined #koha |
| 12:04 |
|
tcohen |
morning #koha! |
| 12:11 |
|
cait |
magnus: make it 18 hours please |
| 12:13 |
|
|
tcohen joined #koha |
| 12:14 |
|
marcelr |
hi tcohen |
| 12:14 |
|
tcohen |
hi marcelr, thanks for signing |
| 12:14 |
|
marcelr |
np |
| 12:21 |
|
tcohen |
how is the qa team doing? |
| 12:21 |
|
tcohen |
too many stuff to qa? |
| 12:27 |
|
|
jwagner joined #koha |
| 12:30 |
|
magnuse |
w00000t!!! http://digital.deichman.no/blo[…]d-library-system/ |
| 12:34 |
|
magnuse |
confetti! |
| 12:34 |
|
wahanui |
o/ '`'`'`'`'`'`'`'` |
| 12:34 |
|
tcohen |
magnuse++ petter++\o/ |
| 12:34 |
|
magnuse |
woohoo! |
| 12:42 |
|
|
petter joined #koha |
| 12:43 |
|
petter |
hi koha! |
| 12:45 |
|
kivilahtio_ |
hi petter! |
| 12:45 |
|
petter |
hi olli! |
| 12:46 |
|
cait |
petter |
| 12:46 |
|
cait |
petter++ |
| 12:46 |
|
cait |
can't type |
| 12:46 |
|
cait |
good news! |
| 12:46 |
|
wahanui |
it has been said that good news is it looks like it's running properly. |
| 12:47 |
|
kivilahtio_ |
patter++ can't type :) |
| 12:47 |
|
petter |
So my library now finally and officially has approved of us changing to koha! |
| 12:48 |
|
kivilahtio_ |
I think your library takes the term "shadow IT" to the MAX |
| 12:48 |
|
petter |
haha |
| 12:48 |
|
kivilahtio_ |
considering you have been working with Koha for how many years? |
| 12:48 |
|
petter |
well, this is quite fast actually, for an organization like ours |
| 12:49 |
|
petter |
and the bureaucracy we have |
| 12:49 |
|
kivilahtio_ |
but good you made it |
| 12:49 |
|
petter |
so now we can start actually WORKING on it; rather than endless meetings, workshop, risk-assesments and so on |
| 12:49 |
|
kivilahtio_ |
c u in the other side then |
| 12:50 |
|
tcohen |
petter: congratulations! |
| 12:50 |
|
petter |
:) |
| 12:50 |
|
tcohen |
petter++ |
| 12:50 |
|
|
meliss joined #koha |
| 12:51 |
|
petter |
Secret tip: we'll be hiring a koha-perl-ninja soon.. Anyone feel like coming to Oslo? |
| 12:51 |
|
tcohen |
honeymoon doesn't count, right? |
| 12:51 |
|
kivilahtio_ |
:) |
| 12:51 |
|
tcohen |
heh |
| 12:51 |
|
petter |
hehe |
| 12:51 |
|
petter |
maybe we can work something out:) |
| 12:51 |
|
petter |
working holiday? |
| 12:53 |
|
tcohen |
if by work you mean drink lots of beer? |
| 12:53 |
|
kivilahtio_ |
I would if I could |
| 12:53 |
|
kivilahtio_ |
tcohen: beer in Oslo is expensive |
| 12:53 |
|
petter |
sure, beer is a big part of the job |
| 12:53 |
|
petter |
our boos is brewing, so dont worry about cost! |
| 12:53 |
|
petter |
boss |
| 12:53 |
|
tcohen |
kivilahtio_: well, a tiny amount then |
| 12:54 |
|
tcohen |
heh |
| 12:57 |
|
kivilahtio_ |
did I already ask here about Solr? |
| 12:57 |
|
kivilahtio_ |
I did |
| 12:57 |
|
kivilahtio_ |
cait siad it's not production ready |
| 12:57 |
|
kivilahtio_ |
but I would like to know how far is solr from being production ready |
| 12:58 |
|
kivilahtio_ |
because we are facing LOTS of issues with Zebra facets |
| 12:58 |
|
kivilahtio_ |
and searches in general |
| 12:59 |
|
petter |
I'd rather wait for ElasticSearch |
| 12:59 |
|
kivilahtio_ |
I feel we need to work a lot with Zebra to make it work for us and the code doesn't look too nice |
| 12:59 |
|
petter |
coming in 3.16? |
| 12:59 |
|
kivilahtio_ |
3.16? |
| 12:59 |
|
petter |
i think |
| 12:59 |
|
kivilahtio_ |
petter: Any idea when 3.16 is due? |
| 13:00 |
|
cait |
kivilahtio_: i think probably less work fixing koha's facets than making solr ready for production |
| 13:00 |
|
petter |
http://lists.koha-community.or[…]ember/040113.html |
| 13:00 |
|
petter |
in may |
| 13:00 |
|
cait |
but that's only my impression |
| 13:00 |
|
kivilahtio_ |
cait: ok |
| 13:00 |
|
cait |
kivilahtio_: 6 months after 3.14 ;) |
| 13:01 |
|
kivilahtio_ |
lol |
| 13:01 |
|
kivilahtio_ |
damn it |
| 13:01 |
|
kivilahtio_ |
gotta hit the Zebra book |
| 13:01 |
|
|
tgoatley joined #koha |
| 13:01 |
|
kivilahtio_ |
I was hoping I wouldn't have to learn yet another library technology |
| 13:01 |
|
petter |
olli, hwen are you going live? |
| 13:01 |
|
kivilahtio_ |
ASAP |
| 13:01 |
|
kivilahtio_ |
:) |
| 13:01 |
|
petter |
I see |
| 13:01 |
|
kivilahtio_ |
we are going live 1.1.2014 |
| 13:01 |
|
petter |
zebra it is then! |
| 13:01 |
|
cait |
kivilahtio_: the problem with zebra facetting are well known and there has been a poc at kohacon i think, but i am not sure anyone is actively working on it |
| 13:02 |
|
cait |
using zebra's facets instead of having koha make facets... |
| 13:02 |
|
cait |
kivilahtio_: that's already expired |
| 13:02 |
|
kivilahtio_ |
cait: gee? you think so? |
| 13:03 |
|
kivilahtio_ |
well I am going on a holiday this saturday so... |
| 13:03 |
|
kivilahtio_ |
I don't need to worry about that |
| 13:04 |
|
petter |
You'l be reading zebra manual on the beach, miserable |
| 13:04 |
|
tcohen |
facets in zebra seem to work great as we saw on kohacon13 |
| 13:04 |
|
kivilahtio_ |
petter: I won't :) |
| 13:04 |
|
petter |
hehe, I hope so! |
| 13:04 |
|
kivilahtio_ |
tcohen: I received some reports that they don't but maybe it is something else on the OPAC's left frame |
| 13:05 |
|
tcohen |
we don't currently use Zebra's facets |
| 13:05 |
|
kivilahtio_ |
tcohen: hmm, but you do use facets? |
| 13:06 |
|
tcohen |
we use a poorly documented Zoom::Results feature |
| 13:06 |
|
tcohen |
->render() |
| 13:06 |
|
jcamins |
tcohen: better to describe it as "we compute the facets using custom code," IMO. |
| 13:06 |
|
tcohen |
we also do that |
| 13:06 |
|
kivilahtio_ |
tcohen: Do you have a separate server for that ? :) |
| 13:06 |
|
jcamins |
While we do use ->render(), that makes it sound like facets are coming from Zebra. |
| 13:07 |
|
jcamins |
:) |
| 13:07 |
|
tcohen |
heh |
| 13:07 |
|
|
francharb joined #koha |
| 13:08 |
|
tcohen |
there is a problem with multibyte chars in facets that is addressed by 9579 |
| 13:08 |
|
francharb |
Good morning #koha |
| 13:08 |
|
kivilahtio_ |
good afternoon francharb! |
| 13:08 |
|
francharb |
:) |
| 13:09 |
|
|
mtompset joined #koha |
| 13:09 |
|
tcohen |
kivilahtio_: when I say "we" i mean the stable source code, not my university's Koha deploy |
| 13:10 |
|
kivilahtio_ |
tcohen: So if I install for git, am I using Zoom::Results? |
| 13:10 |
|
kivilahtio_ |
with default configuration? |
| 13:10 |
|
tcohen |
that's how we've been doing it for years I guess |
| 13:11 |
|
* magnuse |
guesses so too |
| 13:11 |
|
kivilahtio_ |
tcohen: thank you! I'll look into it when I get back from my holiday week |
| 13:12 |
|
tcohen |
Zoom::Record->render() |
| 13:12 |
|
jcamins |
But that doesn't actually generate facets at all. |
| 13:12 |
|
jcamins |
All that does is creates a string that can be parsed using string parsing in Perl. |
| 13:13 |
|
tcohen |
what do u mean? |
| 13:13 |
|
|
collum joined #koha |
| 13:14 |
|
jcamins |
tcohen: |
| 13:14 |
|
jcamins |
Whoops. |
| 13:14 |
|
jcamins |
C4::Search lines 509-539. |
| 13:15 |
|
tcohen |
yes, i almost have all those lines in my head since kohacon13 heh |
| 13:15 |
|
jcamins |
We parse the result of the render() call to generate facets, but the render() call is not actually a meaningful part of the facet generation. |
| 13:16 |
|
|
NateC joined #koha |
| 13:16 |
|
jcamins |
We could just as easily use a MARC::Record object in that context, and it would make no difference. |
| 13:16 |
|
tcohen |
you are saying that what we are building does not have the semantics of what one would call facets |
| 13:16 |
|
jcamins |
(in terms of functionality, which is what kivilahtio_ is interested in) |
| 13:17 |
|
jcamins |
No, what we are building has the semantics of facets, but based on the scrollback, kivilahtio_ is planning to read about ->render() so that he can modify the behavior of facets. |
| 13:17 |
|
kivilahtio_ |
jcamins: I think the entities I represent are interested in those things :) |
| 13:17 |
|
tcohen |
jcamins: agreed, that's what 11096 does |
| 13:18 |
|
tcohen |
i was focusing on the effects bug 9579 has (read "the problems we have with facets") |
| 13:18 |
|
huginn |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9579 major, P1 - high, ---, tomascohen, Needs Signoff , Facets truncation broken for multi-byte characters |
| 13:19 |
|
jcamins |
tcohen: and with luck, by the time kivilahtio_ gets back from vacation, there won't be any calls to ->render() anyway. |
| 13:19 |
|
kivilahtio_ |
jcamins: looking forward to it :) |
| 13:20 |
|
|
oleonard joined #koha |
| 13:20 |
|
tcohen |
i hope so jcamins |
| 13:20 |
|
kivilahtio_ |
jcamins: what I find extrememly cool is your capability to read my mind |
| 13:20 |
|
kivilahtio_ |
jcamins: I wonder how you do it. |
| 13:20 |
|
jcamins |
kivilahtio_: a lot of painful experience talking about search in Koha. |
| 13:21 |
|
kivilahtio_ |
but I gather from this conversation that I should just wait, regarding facet generation |
| 13:23 |
|
jcamins |
kivilahtio_: some of the bugs have patches, but if you want to substantially improve facets (for example, making the availability facet work), that could probably be started now, just on top of work that's already been done. |
| 13:23 |
|
tcohen |
what problems do u actually have kivilahtio_ ? |
| 13:23 |
|
* oleonard |
waits for jcamins to read his mind |
| 13:23 |
|
kivilahtio_ |
tcohen: lemme, see, I have some screenshots around |
| 13:24 |
|
kivilahtio_ |
oleonard: jcamins already read my mind regarding the availability facet |
| 13:24 |
|
jcamins |
oleonard: I'm getting... "coffee... cookies... fudge... cookies... cookies? cookies? cookies!" |
| 13:24 |
|
* tcohen |
remembers how awesome jcamins' cookies are |
| 13:24 |
|
oleonard |
jcamins: You're reading your own mind again. Oh wait, except for the coffee part. |
| 13:24 |
|
kivilahtio_ |
it must be boring to read one's own mind |
| 13:25 |
|
jcamins |
oleonard: I may have been a bit in advance. |
| 13:28 |
|
kivilahtio_ |
Locations-facet apparently has something worng? |
| 13:28 |
|
kivilahtio_ |
I can't believe these bug reports |
| 13:28 |
|
kivilahtio_ |
Under locations-facet, we have Serials and show more |
| 13:29 |
|
kivilahtio_ |
When one clicks "show more", "show more" vanishes, and nothing happens!!! |
| 13:29 |
|
kivilahtio_ |
so there is only "Serials" under Locations-facet |
| 13:30 |
|
kivilahtio_ |
:D |
| 13:30 |
|
kivilahtio_ |
the facets work well |
| 13:33 |
|
|
janPasi joined #koha |
| 13:58 |
|
oleonard |
Bug 11567 |
| 13:58 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=11567 major, P5 - low, ---, koha-bugs, NEW , Shortcut is searching with every keypress |
| 13:59 |
|
oleonard |
Anyone else have that problem? |
| 14:00 |
|
tcohen |
i have seen it in master a while ago, but after a couple of testing for other stuff (I assumed it was a problem with the patches I was testing) the problem dissappeared |
| 14:07 |
|
kivilahtio_ |
I had similar issues today, but it vanished after reloading/refreshing |
| 14:11 |
|
magnuse |
yup, i had that, updating my templates/translation fixed it |
| 14:13 |
|
* magnuse |
commented on the bug |
| 14:14 |
|
* tcohen |
thinks maybe it is time to check bug 10942 |
| 14:14 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=10942 enhancement, P5 - low, ---, koha-bugs, Needs Signoff , Provide a way for package upgrades to update template translations |
| 14:17 |
|
magnuse |
that would be neat :-) |
| 14:18 |
|
|
rambutan joined #koha |
| 14:18 |
|
|
talljoy joined #koha |
| 14:20 |
|
|
SherryS joined #koha |
| 14:22 |
|
tcohen |
magnuse: it is just a couple of signoffs away :-P |
| 14:42 |
|
cait |
tcohen: how is work going on the new time machine module? |
| 14:42 |
|
tcohen |
:-P |
| 14:45 |
|
oleonard |
cait: Ask him yesterday. |
| 14:47 |
|
cait |
oleonard: oh, i will put a reminder in my calendar |
| 15:04 |
|
|
maximep joined #koha |
| 15:13 |
|
paxed |
oleonard: re my comment (#5) on bug 11487: let's say the language must add something to the number to make it grammatical. (think: "1st" or "2nd" in english). would that be enough to convince you concatenating strings is very bad for translation? |
| 15:13 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=11487 normal, P5 - low, ---, koha-bugs, Failed QA , Untranslatable tooltip "Dates of birth should be entered in the format ..." |
| 15:14 |
|
oleonard |
paxed: The goal of the reformatted comment was to remove the requirement that the number must be modified |
| 15:16 |
|
paxed |
...sorry? |
| 15:17 |
|
oleonard |
I don't see how the example you provide applies to the bugs we're talking about. |
| 15:17 |
|
paxed |
"Päivämäärät pitää syöttä %s -muodossa." |
| 15:18 |
|
paxed |
_("Dates of birth should be entered in this format:")+ " '"+[% format %]+"'"; |
| 15:20 |
|
oleonard |
You're saying that [% format %] needs to be modified somehow to be grammatically correct? |
| 15:21 |
|
paxed |
no. i'm saying the translator should be able to decide where in that sentence it goes. |
| 15:21 |
|
cait |
paxed, oleonard: i commented on bug 11488 |
| 15:21 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=11488 normal, P5 - low, ---, emmaheath.student, Needs Signoff , Untranslatable warning "Are you sure you want to write off ..." |
| 15:22 |
|
oleonard |
cait++ |
| 15:22 |
|
oleonard |
Joubu++ |
| 15:22 |
|
oleonard |
...for suggesting alternative solutions. |
| 15:24 |
|
Joubu |
It is not perfect because only 1 placeholder is possible. But it fixes this specific string. |
| 15:24 |
|
cait |
thin the problem here was probably the tt variable in the message |
| 15:24 |
|
cait |
poor emma :( I told her a non working solution. |
| 15:25 |
|
Joubu |
And it avoids modifying the translate script... |
| 15:25 |
|
paxed |
doesn't koha use jQuery? it has placeholder replacement functions, iirc. |
| 15:25 |
|
cait |
oleonard: i remember something about the paging for datatables using multiple variable replacement, something like __PREV__? |
| 15:29 |
|
oleonard |
Look at datatables.inc |
| 15:35 |
|
huginn |
New commit(s) kohagit: Bug 7143: add another name to the about page <http://git.koha-community.org/[…]78d87f2eefe3fbcf5> / Bug 7143: Updating about page and history <http://git.koha-community.org/[…]b99e58c6d2ca7ba72> |
| 15:36 |
|
|
yhager joined #koha |
| 15:38 |
|
|
rocio joined #koha |
| 15:40 |
|
Joubu |
tcohen: bug 10987, why did you switch back the status to NSO? |
| 15:40 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=10987 enhancement, P5 - low, ---, tomascohen, Needs Signoff , Too many 'see also' and 'usedfor/see from' labels occurences |
| 15:41 |
|
tcohen |
Joubu: I fixed a couple of minor problems (rebased against latest 10691), but mostly because I added bootstrap to get bonus points |
| 15:42 |
|
Joubu |
tcohen: ha yes (rebased+bootstrap). I did not see that! |
| 15:44 |
|
tcohen |
i think it can be safely signed btw |
| 15:54 |
|
|
mcooper joined #koha |
| 16:03 |
|
* Joubu |
are sending 2 bonus points to tcohen |
| 16:04 |
|
tcohen |
heh |
| 16:05 |
|
* cait |
adds another for being tcohen |
| 16:06 |
|
cait |
tcohen: hm do you think 10908 should go into 3.12? |
| 16:06 |
|
cait |
i see that my coworker has added it to our 3.12.7 branch |
| 16:07 |
|
cait |
together with 10605 |
| 16:07 |
|
cait |
which will be in 3.12.9 |
| 16:07 |
|
tcohen |
i thought i had 10908 on 3.12 |
| 16:07 |
|
tcohen |
gotta test it, |
| 16:12 |
|
|
SherryS left #koha |
| 16:22 |
|
|
BigRig joined #koha |
| 16:23 |
|
cait |
tcohen++ thx :) |
| 16:35 |
|
cait |
bye all |
| 16:35 |
|
|
cait left #koha |
| 16:49 |
|
rambutan |
looks like magnus is buying donuts this week |
| 16:49 |
|
rambutan |
:) don't know that he had anything to do with it |
| 16:52 |
|
oleonard |
? |
| 16:53 |
|
tcohen |
Anne Lena Westrum's email to the koha list |
| 16:55 |
|
oleonard |
magnuse isn't going to have time to buy donuts with all the work they'll have for him |
| 16:55 |
|
* oleonard |
hopes donuts were included in the contract |
| 17:01 |
|
|
cait joined #koha |
| 17:14 |
|
* cait |
waves |
| 17:22 |
|
rambutan |
waves |
| 17:26 |
|
Joubu |
bye all |
| 17:26 |
|
|
Joubu left #koha |
| 17:43 |
|
gaetan_B |
bye ! |
| 17:45 |
|
reiveune |
bye |
| 17:45 |
|
|
reiveune left #koha |
| 18:01 |
|
tcohen |
can anyone confirm bug 11533 |
| 18:01 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=11533 major, P5 - low, ---, gmcharlt, NEW , "use" QueryParser breaks authority search |
| 18:01 |
|
tcohen |
? |
| 18:02 |
|
gmcharlt |
tcohen: it works for me, but previous experience indicates that knowing exactly what kind of search you're doing would help for the bug report |
| 18:03 |
|
gmcharlt |
e.g., main heading vs all headings, contains vs starts with, and so forth |
| 18:03 |
|
tcohen |
isn't the unit test enough evidence? |
| 18:03 |
|
gmcharlt |
ah |
| 18:03 |
|
gmcharlt |
let me take a look |
| 18:04 |
|
tcohen |
thanks! |
| 18:08 |
|
gmcharlt |
tcohen: OK, so the difference between the UI and the test is that the UI has sets the default sort order to heading A-Z |
| 18:08 |
|
gmcharlt |
while the test has the sort order as 'none' |
| 18:09 |
|
gmcharlt |
and it looks like it's sort-order none that doesn't work in QP, specifically |
| 18:09 |
|
|
dpk1 joined #koha |
| 18:09 |
|
tcohen |
ok, and it happens to be the default, right? |
| 18:11 |
|
gmcharlt |
looks like Heading A-Z is the implicit default if there's no op CGI parameter |
| 18:12 |
|
tcohen |
besides the difference between the regression test and the UI handling sorting |
| 18:13 |
|
tcohen |
I can say the result is "no results" as soon as I enable QP |
| 18:13 |
|
tcohen |
in the UI |
| 18:13 |
|
gmcharlt |
only if the sort order is none |
| 18:13 |
|
gmcharlt |
a-z, z-a, works for me |
| 18:14 |
|
tcohen |
ok, how should I proceed? fix QP to default to something? |
| 18:15 |
|
gmcharlt |
tcohen: one moment, let me check something |
| 18:23 |
|
pastebot |
"gmcharlt" at 127.0.0.1 pasted "tcohen: try this one on for size" (13 lines) at http://paste.koha-community.org/86 |
| 18:27 |
|
tcohen |
hmm, i have $sortby: HeadingAsc and QP |
| 18:28 |
|
gmcharlt |
which works for me |
| 18:28 |
|
gmcharlt |
with or without that patch |
| 18:30 |
|
|
pianohacker joined #koha |
| 18:31 |
|
tcohen |
gmcharlt: i just did a super-fresh master install |
| 18:31 |
|
tcohen |
added a couple of authority records, and nothing else |
| 18:33 |
|
tcohen |
how can I upload a screencast? |
| 18:33 |
|
gmcharlt |
tcohen: I've used http://www.techsmith.com/jing.html in the past |
| 18:35 |
|
tcohen |
gmcharlt: for me it doesn't work with QP, no matter which order I choose |
| 18:36 |
|
* magnuse |
waves |
| 18:36 |
|
gmcharlt |
tcohen: well, turn off the TortureTomas syspref! |
| 18:36 |
|
gmcharlt |
;) |
| 18:37 |
|
tcohen |
that'd be great gmcharlt heh |
| 18:38 |
|
tcohen |
I just want to move to using QP so we can add our work hours to that |
| 18:41 |
|
tcohen |
maybe we broke it recently and you have an old QP file? |
| 18:42 |
|
gmcharlt |
no, they're in sync for me |
| 18:45 |
|
|
jwagner joined #koha |
| 18:46 |
|
* tcohen |
is puzzled, and gives up |
| 18:46 |
|
gmcharlt |
tcohen: does the test case pass for you, at least, with the patch? |
| 18:46 |
|
|
meliss joined #koha |
| 18:47 |
|
rangi |
if you like the new dashboard |
| 18:47 |
|
rangi |
then you can thank https://secure.flickr.com/phot[…]72157639826342535 |
| 18:47 |
|
rangi |
the young woman on the left |
| 18:48 |
|
|
collum joined #koha |
| 18:48 |
|
tcohen |
gmcharlt: yes, they pass |
| 18:48 |
|
rangi |
tcohen: emma is on the left https://secure.flickr.com/phot[…]72157639826342535 |
| 18:48 |
|
tcohen |
she's really young! |
| 18:49 |
|
rangi |
yep they are all 16 or 17 |
| 18:49 |
|
|
pianohacker joined #koha |
| 18:49 |
|
rangi |
https://secure.flickr.com/phot[…]72157639826342535 <-- the koha team (with francesca missing to the right |
| 18:50 |
|
rangi |
https://secure.flickr.com/phot[…]72157639826342535 <-- piwik |
| 18:51 |
|
rangi |
(matthieu the original author (and lead developer still) on the right) |
| 18:52 |
|
magnuse |
ooh, that's cool! |
| 18:52 |
|
rangi |
i think every project, drupal, mahara, piwik and Koha got some code into core |
| 18:52 |
|
magnuse |
awesome! |
| 18:52 |
|
cait |
rangi: cool photos :) |
| 18:52 |
|
wahanui |
That'll be $1 for the awesome jar, magnuse |
| 18:52 |
|
cait |
did you see magnuse big news yet? |
| 18:52 |
|
rangi |
the students are doing their reports back today, so we will find out |
| 18:53 |
|
rangi |
yep :) |
| 18:53 |
|
rangi |
tweeted it :) |
| 18:53 |
|
magnuse |
:-) |
| 18:53 |
|
cait |
:) |
| 18:53 |
|
cait |
a week of good news |
| 18:53 |
|
rangi |
cait: anitsirk took the photos, she takes good photos |
| 18:53 |
|
cait |
yep she does :) |
| 18:53 |
|
magnuse |
mother energy? |
| 18:54 |
|
cait |
? |
| 18:54 |
|
rangi |
ah yeah, energy drink |
| 18:54 |
|
rangi |
about 6 coffees worth of caffeine |
| 18:54 |
|
magnuse |
lol |
| 18:54 |
|
* magnuse |
likes the look of this whiteboard: https://secure.flickr.com/phot[…]2157639826342535/ |
| 18:55 |
|
rangi |
trust me, i need about 8 of those |
| 18:55 |
|
rangi |
ah yep that goes with this |
| 18:55 |
|
gmcharlt |
tcohen: once I finish witha meeting I'll attach the patch + more test cases to the bug |
| 18:55 |
|
pianohacker |
that reminds me, we need to get a good coffee setup for hackfest |
| 18:55 |
|
rangi |
http://bugs.koha-community.org[…]_bug.cgi?id=11558 |
| 18:55 |
|
huginn |
Bug 11558: enhancement, P5 - low, ---, oleonard, NEW , Collector bug for Academy bootstrap3 upgrading work - Not ready (not even close) for use yet |
| 18:55 |
|
magnuse |
pianohacker: us hackfest? |
| 18:56 |
|
magnuse |
s/us/U.S./ |
| 18:56 |
|
tcohen |
gmcharlt: thanks, I'm leaving home now, but will try to do more testing on this. My first thought was it was a local problem, but a fresh setup yielded the same results |
| 18:56 |
|
rangi |
magnuse: and also http://bugs.koha-community.org[…]_bug.cgi?id=11566 |
| 18:56 |
|
huginn |
Bug 11566: enhancement, P5 - low, ---, oleonard, NEW , Fixing accessibility on OPAC |
| 18:56 |
|
tcohen |
we'll sort it out sooner or later |
| 18:56 |
|
tcohen |
bye! |
| 18:56 |
|
tcohen |
and congrats rangi |
| 18:56 |
|
rangi |
cya tcohen |
| 18:57 |
|
tcohen |
FOSS for the win! |
| 18:57 |
|
rangi |
@quote add < tcohen> FOSS for the win! |
| 18:57 |
|
huginn |
rangi: Error: You must be registered to use this command. If you are already registered, you must either identify (using the identify command) or add a hostmask matching your current hostmask (using the "hostmask add" command). |
| 18:57 |
|
magnuse |
rangi: will there be any more work done on 11558 by the students? |
| 18:57 |
|
rangi |
@qyote get 3 |
| 18:57 |
|
huginn |
rangi: downloading the Perl source |
| 18:58 |
|
rangi |
@quote search identify |
| 18:58 |
|
huginn |
rangi: 1 found: #73: "<chris_n> owen: try /msg munin identify nick..." |
| 18:58 |
|
rangi |
@qyote get 73 |
| 18:58 |
|
huginn |
rangi: downloading the Perl source |
| 18:58 |
|
rangi |
@quote get 73 |
| 18:58 |
|
huginn |
rangi: Quote #73: "<chris_n> owen: try /msg munin identify nick password" (added by owen at 12:38 PM, April 29, 2010) |
| 18:58 |
|
rangi |
magnuse: probably not, we are out of time, but i will collate it together into a branch |
| 18:58 |
|
rangi |
and get it to a testable state |
| 18:58 |
|
|
collum joined #koha |
| 18:59 |
|
rangi |
@quote add < tcohen> FOSS for the win! |
| 18:59 |
|
huginn |
rangi: The operation succeeded. Quote #289 added. |
| 19:00 |
|
|
collum joined #koha |
| 19:01 |
|
magnuse |
rangi: very cool! |
| 19:02 |
|
rangi |
pianohacker: https://fbcdn-sphotos-d-a.akam[…]_1419204447_n.jpg |
| 19:03 |
|
rangi |
right gotta go back downstairs now for the last day of academy |
| 19:03 |
|
pianohacker |
pfffft |
| 19:05 |
|
magnuse |
rangi: have fun! |
| 19:07 |
|
|
as joined #koha |
| 19:14 |
|
magnuse |
kia ora as |
| 19:30 |
|
|
Emma_ joined #koha |
| 19:31 |
|
|
aleishaa joined #koha |
| 19:35 |
|
|
t-houlks joined #koha |
| 19:38 |
|
|
francesca joined #koha |
| 19:39 |
|
rangi |
https://secure.flickr.com/phot[…]2157639826342535/ |
| 19:44 |
|
|
alexh joined #koha |
| 19:44 |
|
|
Roman_ joined #koha |
| 19:45 |
|
aleishaa |
https://secure.flickr.com/phot[…]2157639826342535/ |
| 19:46 |
|
rangi |
https://secure.flickr.com/search/?q=kohacon13 <-- kohacon13 in Reno last year |
| 19:47 |
|
|
daniel_ joined #koha |
| 19:48 |
|
|
mtompset joined #koha |
| 19:49 |
|
|
francesca joined #koha |
| 19:50 |
|
rangi |
http://bugs.koha-community.org[…]y_format=advanced |
| 19:50 |
|
rangi |
does that url work for people? |
| 19:51 |
|
francesca |
works for me |
| 19:52 |
|
oleonard |
That's a big list :| |
| 19:52 |
|
rangi |
so students lets see if we can make that list a big shorter by testing and signing off |
| 19:53 |
|
|
francesca joined #koha |
| 19:54 |
|
|
MrAgent075 joined #koha |
| 19:56 |
|
pianohacker |
cait: translation q |
| 19:56 |
|
cait |
filling up my queue is the plan? :) |
| 19:56 |
|
* magnuse |
cheers the students on |
| 19:57 |
|
cait |
pianohacker: yes? |
| 19:57 |
|
magnuse |
yeah, fill all the queues! |
| 19:57 |
|
pianohacker |
cait: Is there any way at all to do formatted translations in JavaScript? |
| 19:58 |
|
cait |
? |
| 19:58 |
|
cait |
what are you trying to do? |
| 19:58 |
|
pianohacker |
For example, "Found 10 matches in 3 external targets" |
| 19:59 |
|
pianohacker |
There's ways to break that up so it isn't needed, but it looks a lot less natural |
| 19:59 |
|
cait |
i think we had this discussion earlier |
| 19:59 |
|
pianohacker |
possibly |
| 19:59 |
|
cait |
there seems to be a jquery replace thing |
| 19:59 |
|
cait |
look at the logs from today |
| 20:00 |
|
cait |
there was a discussion with paxed and oleonard |
| 20:00 |
|
pianohacker |
woot! Thanks. |
| 20:00 |
|
cait |
well not a perfect solution, but maybe some ideas :) |
| 20:01 |
|
pianohacker |
And is it considered kosher to leave the tags inside a short HTML bit? like |
| 20:01 |
|
rangi |
mtompset: one of the students is going to test bug 11513 |
| 20:01 |
|
huginn |
Bug http://bugs.koha-community.org[…]_bug.cgi?id=11513 minor, P5 - low, ---, mtompset, Needs Signoff , Warnings in Patron categories |
| 20:01 |
|
pianohacker |
$stuff.html( _( "<span>Yay!</span>" ) ); |
| 20:02 |
|
mtompset |
Sounds good to me, rangi. I think the test plan is easy enough to follow. :) |
| 20:02 |
|
rangi |
yep |
| 20:02 |
|
oleonard |
pianohacker: No |
| 20:02 |
|
cait |
well in that example i wouldn't leave it in |
| 20:03 |
|
magnuse |
@later tell slef: a cycling library unconference between barcelona and lyon - something for you? :-)http://cyc4libse.tumblr.com/po[…]nas-och-lyon-dock |
| 20:03 |
|
huginn |
magnuse: The operation succeeded. |
| 20:03 |
|
cait |
if you just wan to bold one word... i might leave it... to not break up the sentence but best to avoid totally |
| 20:03 |
|
mtompset |
pianohacker: you forgot the style="display: none" ;) |
| 20:03 |
|
pianohacker |
so $stuff.html( '<span>' + _( "Yay!" ) + '</span>' ) ? |
| 20:04 |
|
cait |
way better |
| 20:04 |
|
* pianohacker |
loves our translaters and hates our JS translation system... |
| 20:04 |
|
cait |
feel free to improve ;) |
| 20:04 |
|
pianohacker |
heh well that's the thing |
| 20:05 |
|
|
rambutan joined #koha |
| 20:05 |
|
pianohacker |
you'd need the kind of masochistic fool who'd do something like redo the sysprefs |
| 20:05 |
|
pianohacker |
and where are we gonna find one of those? |
| 20:05 |
|
* mtompset |
looks at pianohacker. :) |
| 20:09 |
|
cait |
http://www.librarytechnology.o[…]ytext.pl?RC=18805 < opl again :) |
| 20:09 |
|
cait |
or someone who would redo catalouging ;) |
| 20:10 |
|
|
laurence left #koha |
| 20:12 |
|
pianohacker |
woo! and yeah, that kinda weirdo |
| 20:15 |
|
wizzyrea |
pianohacker |
| 20:15 |
|
wahanui |
somebody said pianohacker was a Dune fan, it seems. |
| 20:15 |
|
wizzyrea |
just the person I wanted :) |
| 20:15 |
|
pianohacker |
uh oh |
| 20:15 |
|
pianohacker |
wazzup :) |
| 20:16 |
|
wizzyrea |
well I am trying to use your z39.50 external search patch |
| 20:16 |
|
wizzyrea |
and for the life of me I cannot make pazpar2 cooperate |
| 20:17 |
|
pianohacker |
wizzyrea: do you have all of the new config files from the patch and its followups? |
| 20:17 |
|
wizzyrea |
yep, I applied all of them |
| 20:17 |
|
pianohacker |
and the pazpar2 config files are installed? |
| 20:18 |
|
MrAgent075 |
http://paste.koha-community.org/87 |
| 20:18 |
|
rangi |
thanks |
| 20:18 |
|
wizzyrea |
that's what I don't know |
| 20:18 |
|
rangi |
students http://git.koha-community.org/[…]6d2ca7ba72#patch1 |
| 20:19 |
|
pianohacker |
someone more familiar with the perl installer: is there an easy way to reinstall select config files from the templates? |
| 20:20 |
|
cait |
no |
| 20:20 |
|
cait |
mysql client |
| 20:20 |
|
cait |
or myswl on command line... or... :) |
| 20:20 |
|
cait |
pianohacker: i have an idea for another great gui project for you |
| 20:20 |
|
cait |
circulation rules :) |
| 20:26 |
|
gmcharlt |
pianohacker: it depends |
| 20:27 |
|
gmcharlt |
there's an update_zebra_conf Makefile target, for example |
| 20:27 |
|
rangi |
MrAgent075++ checkout out the dashboard now |
| 20:27 |
|
* cait |
does |
| 20:27 |
|
cait |
logo? :) |
| 20:28 |
|
rangi |
yep |
| 20:28 |
|
cait |
woo :) |
| 20:28 |
|
MrAgent075 |
Yay, it works! :) |
| 20:28 |
|
MrAgent075 |
(Person who make the .svg logo)++ |
| 20:29 |
|
cait |
:) |
| 20:29 |
|
pianohacker |
gmcharlt: Am I reading that code right? It looks like it should also update the pazpar2 configuration |
| 20:29 |
|
cait |
the dashboard looks great |
| 20:29 |
|
gmcharlt |
pianohacker: correct |
| 20:30 |
|
pianohacker |
hell yeah |
| 20:30 |
|
pianohacker |
gmcharlt++ |
| 20:30 |
|
cait |
gmcharlt++ :) |
| 20:31 |
|
francesca |
http://pbrd.co/1dzopVX link to favicon for dashboard |
| 20:32 |
|
pastebot |
"francesca" at 127.0.0.1 pasted "favicon code" (3 lines) at http://paste.koha-community.org/88 |
| 20:36 |
|
francesca |
@quote random |
| 20:36 |
|
huginn |
francesca: Quote #213: "jwagner: There are few problems that can't be solved with patience, ingenuity, and a large kick in the pants (assuming servers wear pants, that is)." (added by wizzyrea at 06:18 PM, August 07, 2012) |
| 20:37 |
|
MrAgent075 |
rangi: possibly impliment the maxlength attribute on the Random Quotes? #koha-dashboard |
| 20:38 |
|
rangi |
hmm yeah, wanna paste me the code? |
| 20:40 |
|
wizzyrea |
that's really pretty! |
| 20:42 |
|
cait |
:) |
| 20:42 |
|
cait |
can i make a suggestion? |
| 20:42 |
|
t-houlks |
chris, where's that list that has all of our patches saying if they're signed off or not? |
| 20:42 |
|
cait |
the hover on the toolbar is a bit dark, maybe it could pop a bit more? |
| 20:42 |
|
cait |
looking at it in firefox |
| 20:42 |
|
rangi |
t-houlks: http://wiki.koha-community.org[…]/Catalyst_Academy |
| 20:43 |
|
t-houlks |
cheers |
| 20:43 |
|
francesca |
I'm fixing the hover colour for the links now |
| 20:44 |
|
cait |
cool, thx francesca |
| 20:44 |
|
francesca |
is there a particular colour you would like the links to turn when when hovered over? |
| 20:44 |
|
wizzyrea |
light grey |
| 20:45 |
|
francesca |
ok |
| 20:45 |
|
MrAgent075 |
rangi: Where are the quotes being generated from? The idea I had seems like the easy way out, but ultimately, a script should be made where quotes that are at the limit of 'x' and under should be put up. |
| 20:46 |
|
pastebot |
"francesca" at 127.0.0.1 pasted "changing link hover colour" (4 lines) at http://paste.koha-community.org/89 |
| 20:46 |
|
rangi |
they are from the bot |
| 20:46 |
|
rangi |
fetched from a file |
| 20:46 |
|
rangi |
if you look here |
| 20:47 |
|
rangi |
MrAgent075: https://gitorious.org/koha-das[…]c7d431c9d377:data |
| 20:47 |
|
rangi |
the koha_irc_quotes.txt file |
| 20:47 |
|
rangi |
is where they come from |
| 20:50 |
|
gmcharlt |
with the latest and greatest from http://librarypolice.com/~gmc/koha_irc_quotes.txt |
| 20:54 |
|
rangi |
thanks gmcharlt |
| 20:56 |
|
cait |
:) |
| 20:57 |
|
cait |
@wunder Konstanz |
| 20:57 |
|
huginn |
cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 4.7°C (9:55 PM CET on January 16, 2014). Conditions: Mostly Cloudy. Humidity: 90%. Dew Point: 3.0°C. Windchill: 5.0°C. Pressure: 29.74 in 1007 hPa (Rising). |
| 20:57 |
|
rangi |
@wunder nzwn |
| 20:57 |
|
huginn |
rangi: The current temperature in Wellington, New Zealand is 15.0°C (9:30 AM NZDT on January 17, 2014). Conditions: Partly Cloudy. Humidity: 72%. Dew Point: 10.0°C. Pressure: 29.62 in 1003 hPa (Steady). |
| 20:59 |
|
cait |
way too warm here still |
| 21:00 |
|
rangi |
@wunder melbourne |
| 21:00 |
|
huginn |
rangi: Error: No such location could be found. |
| 21:00 |
|
rangi |
@wunder melbourne, australia |
| 21:00 |
|
huginn |
rangi: The current temperature in AO-GSO, Melbourne, Victoria is 28.8°C (7:48 AM EST on January 17, 2014). Conditions: Clear. Humidity: 45%. Dew Point: 16.0°C. Pressure: 29.80 in 1009 hPa (Steady). |
| 21:00 |
|
rangi |
that is too warm, its getting to 45 there today |
| 21:00 |
|
rangi |
i hope its cooler by february |
| 21:06 |
|
magnuse |
@wunder boo |
| 21:06 |
|
huginn |
magnuse: The current temperature in Bodo, Norway is -6.0°C (9:50 PM CET on January 16, 2014). Conditions: Clear. Humidity: 58%. Dew Point: -13.0°C. Windchill: -16.0°C. Pressure: 30.15 in 1021 hPa (Steady). |
| 21:07 |
|
pastebot |
"francesca" at 127.0.0.1 pasted "link hover colour fix" (7 lines) at http://paste.koha-community.org/90 |
| 21:08 |
|
|
SatanlovesHash joined #koha |
| 21:11 |
|
francesca |
color: rgb(184, 184, 184); |
| 21:13 |
|
pianohacker |
francesca: not a fan of hex colors? :) |
| 21:14 |
|
|
Roman_ joined #koha |
| 21:15 |
|
oleonard |
Bye #koha |
| 21:16 |
|
|
MrAgent075 joined #koha |
| 21:19 |
|
MrAgent075 |
@wunder London, England |
| 21:19 |
|
huginn |
MrAgent075: The current temperature in London / Heathrow Airport, United Kingdom is 7.0°C (9:00 PM GMT on January 16, 2014). Conditions: Light Rain. Humidity: 84%. Dew Point: 5.0°C. Pressure: 29.17 in 988 hPa (Falling). |
| 21:19 |
|
MrAgent075 |
@wunder Maarssen, Netherlands |
| 21:20 |
|
huginn |
MrAgent075: The current temperature in Maarssenbroek, Maarssen, Netherlands is 6.7°C (10:19 PM CET on January 16, 2014). Conditions: Scattered Clouds. Humidity: 99%. Dew Point: 7.0°C. Windchill: 7.0°C. Pressure: 29.42 in 996 hPa (Rising). |
| 21:24 |
|
|
t-houlks joined #koha |
| 21:24 |
|
|
daniel_ joined #koha |
| 21:26 |
|
pastebot |
"MrAgent075" at 127.0.0.1 pasted "maxlength attribute to Random Quotes" (9 lines) at http://paste.koha-community.org/91 |
| 21:26 |
|
|
Roman_ joined #koha |
| 21:31 |
|
|
alexh joined #koha |
| 21:37 |
|
|
Roman_ joined #koha |
| 21:39 |
|
|
as joined #koha |
| 21:43 |
|
|
alexh joined #koha |
| 21:47 |
|
cait |
good night #koha |
| 21:47 |
|
pianohacker |
good night cait |
| 21:47 |
|
cait |
bye pianohacker :) |
| 21:47 |
|
|
cait left #koha |
| 21:50 |
|
pastebot |
"francesca" at 127.0.0.1 pasted "new favicon" (2 lines) at http://paste.koha-community.org/92 |
| 21:51 |
|
francesca |
heres the link to the image http://pbrd.co/Km1RLy |
| 21:54 |
|
MrAgent075 |
wizzyrea: you on Lv. 7? |
| 22:01 |
|
wizzyrea |
ya |
| 22:01 |
|
wizzyrea |
ok that favicon is super cute. |
| 22:01 |
|
pianohacker |
is that a reference to a floor or a game? |
| 22:02 |
|
pianohacker |
That is an excellent favicon yes |
| 22:02 |
|
* wizzyrea |
uses it on the koha website |
| 22:02 |
|
* pianohacker |
thought at first wizzy was talking about habitrpg :) |
| 22:05 |
|
francesca |
wow. |
| 22:07 |
|
* francesca |
is very excited |
| 22:07 |
|
pianohacker |
about? :) |
| 22:08 |
|
francesca |
the favicon I designed for the dashboard being used on the koha website |
| 22:09 |
|
|
mrx joined #koha |
| 22:09 |
|
rambutan |
francesca: you have some artistic ability it would seem? |
| 22:10 |
|
francesca |
not really.. I just use inkscape |
| 22:10 |
|
pianohacker |
inkscape++ |
| 22:10 |
|
rambutan |
inkscape requires some artistic ability! |
| 22:11 |
|
|
papa joined #koha |
| 22:14 |
|
mrx |
Hi guys, I am using ExtractValue as below to search isbn listed in a record as a second 020 field but the statment is not returning anything but if I use the first isbn listed in 020 filed of the same record it returns all 020 fields. Is there a way to search isbn other than the first listed in 020 filed? |
| 22:14 |
|
mrx |
SELECT ExtractValue((SELECT marcxml FROM biblioitems WHERE |
| 22:14 |
|
mrx |
isbn=9781922244024), '//datafield[@tag="020"]/subfield[@code>="a"]') AS |
| 22:14 |
|
mrx |
ITEM |
| 22:16 |
|
wizzyrea |
francesca: http://img585.imageshack.us/img585/9908/6ykn.png |
| 22:18 |
|
rangi |
mrx: no |
| 22:18 |
|
rangi |
is the short answer |
| 22:19 |
|
rangi |
the only way is to do LIKE %value% |
| 22:19 |
|
rangi |
which might get you some false positives occassionally |
| 22:21 |
|
francesca |
so exciting!! |
| 22:23 |
|
mrx |
rangi: what will be the LIKE query in this case as I'm unable to get it to work I think |
| 22:28 |
|
rangi |
SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as isbns WHERE isbns LIKE '%9781922244024%' |
| 22:29 |
|
rangi |
actually |
| 22:29 |
|
rangi |
SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as isbns FROM biblioitems WHERE isbns LIKE '%9781922244024%' |
| 22:30 |
|
rangi |
something like that anyway |
| 22:33 |
|
mrx |
rangi: humm, unfortunately returns same results as before. It only appears to search the for 1st listed isbn not the rest... |
| 22:35 |
|
|
dcook joined #koha |
| 22:35 |
|
wizzyrea |
maybe you'd have better luck with something like select biblionumber, isbn from biblioitems where isbn LIKE '%9781922244024%' |
| 22:36 |
|
wizzyrea |
guess it would depend on how you catalogued them. |
| 22:38 |
|
mrx |
wizzyrea: what do you mean by how you catalogued them as that query return same result |
| 22:43 |
|
rangi |
Roman_: https://web.archive.org/web/20[…]ha-community.org/ |
| 22:43 |
|
francesca |
tom heres the link to the image http://pbrd.co/Km1RLy |
| 22:45 |
|
wizzyrea |
do you have multiple 020a fields per record, or several isbns in a single 020a? |
| 22:46 |
|
mrx |
wizzyrea: multiple 020s |
| 22:52 |
|
francesca |
tom http://img585.imageshack.us/img585/9908/6ykn.png |
| 22:59 |
|
wizzyrea |
SELECT biblionumber, isbns FROM (select biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') AS 'isbns' FROM biblioitems) as isbns where isbns LIKE '%YOURISBN%'; |
| 22:59 |
|
wizzyrea |
or something. |
| 22:59 |
|
wahanui |
i think something is fishy |
| 22:59 |
|
wizzyrea |
me too. Me. Too. |
| 23:02 |
|
dcook |
wizzyrea: What's the scenario? |
| 23:02 |
|
wahanui |
rumour has it the scenario is a problematic patch across versions |
| 23:02 |
|
|
as joined #koha |
| 23:02 |
|
wizzyrea |
he wants to see all biblionumbers that have a certain ISBN in one of their multiple 020a's |
| 23:03 |
|
wizzyrea |
biblioitems isbn only has the first, but the xml has them all. |
| 23:03 |
|
dcook |
Pretty sure that your first "select biblionumber, isbn from biblioitems where isbn LIKE '%9781922244024%'" should work for that then |
| 23:03 |
|
dcook |
Oh wait |
| 23:03 |
|
dcook |
Durr |
| 23:03 |
|
dcook |
Nvm |
| 23:04 |
|
dcook |
select biblionumber from biblioitems where ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') like '%ISBN%' |
| 23:04 |
|
wizzyrea |
he wants to see the ISBN as well |
| 23:04 |
|
wizzyrea |
isbns* |
| 23:04 |
|
dcook |
select biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as 'isbns' from biblioitems where ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') like '%ISBN%' |
| 23:04 |
|
dcook |
or.. |
| 23:05 |
|
dcook |
select biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code>="a"]') as 'isbns' from biblioitems having `isbns` like '%ISBN%' |
| 23:05 |
|
dcook |
May or may not need those mysql backticks...can't recall for sure.. |
| 23:05 |
|
dcook |
Actually subfield[@code>="a"] should probably just be subfield[@code="a"] |
| 23:06 |
|
dcook |
No real reasoon to have that > in there |
| 23:06 |
|
wizzyrea |
either way, a buffet of queries there for him to choose from |
| 23:06 |
|
dcook |
Yep |
| 23:06 |
|
* dcook |
was just wondering because this seems to have been the same question from yesterday? :S |
| 23:06 |
|
jcamins |
dcook: or, if performance is a concern: SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="020"]/subfield[@code="a"]') AS 'isbns' FROM biblioitems WHERE marcxml LIKE '%ISBN%'; |
| 23:07 |
|
dcook |
Hmm, probably. Although you might have that same number somewhere other than the 020$a |
| 23:07 |
|
dcook |
Doubtful though |
| 23:07 |
|
jcamins |
dcook: if performance is a concern, filter after-the-fact. |
| 23:07 |
|
dcook |
Totes |
| 23:08 |
|
jcamins |
(to get rid of whichever records don't match) |
| 23:08 |
|
wizzyrea |
mrx: all of that ^ was for you. |
| 23:08 |
|
wizzyrea |
(also, that's pretty magic, 4 people, 3 countries, one question.) |
| 23:09 |
|
jcamins |
I don't actually know what we're trying to do. |
| 23:09 |
|
wizzyrea |
(3 timezones as well) |
| 23:09 |
|
mrx |
Thanks heaps guys, very much helpful |
| 23:09 |
|
jcamins |
Something to do with ISBNs. |
| 23:09 |
|
mrx |
much appreciated |
| 23:11 |
|
huginn |
New commit(s) kohagit: Bug 10987: (follow-up) fix display of authorities containing only one see from or... <http://git.koha-community.org/[…]8f8fecff115b661d4> / Bug 10987: remove duplicate 'see also' and 'see from' labels from authority search... <http://git.koha-community.org/[…]b0e768fd7c013f449> / Bug 10691: (follow-up) replace HTML co |
| 23:11 |
|
jcamins |
Wow, I'm loving this module maintainer gig. |
| 23:11 |
|
jcamins |
Within five minutes of getting home, someone's taken care of it for me. :D |
| 23:11 |
|
jcamins |
gmcharlt++ |
| 23:26 |
|
francesca |
@quote random |
| 23:26 |
|
huginn |
francesca: Quote #123: "rangi: #thingsihavelearnt if there is a mad scheme a library somewhere will be doing it ... except madder" (added by wizzyrea at 09:20 PM, March 30, 2011) |
| 23:27 |
|
wizzyrea |
too right |
| 23:30 |
|
dcook |
mhm |
| 23:30 |
|
* dcook |
is looking at MFHD |
| 23:30 |
|
jcamins |
Avaunt foul spirit! |
| 23:32 |
|
dcook |
It seemed like a good idea in theory? |
| 23:33 |
|
jcamins |
dcook: I find your theory to be wholly disturbing. |
| 23:33 |
|
jcamins |
:P |
| 23:33 |
|
dcook |
hehe |
| 23:34 |
|
dcook |
I just wonder if MARC is fully implemented anywhere or has ever been |
| 23:34 |
|
dcook |
There are so many fields that a user would never use |
| 23:34 |
|
dcook |
There are so many fields that a librarian would probably never use |
| 23:35 |
|
francesca |
@quote random |
| 23:35 |
|
dcook |
There are so many fields that a super anal archivist might use...but with no one ever looking at it again |
| 23:35 |
|
huginn |
francesca: Quote #214: "obelos: Perhaps this means it's time for HLT to choose a different name so we can all move on with our work without this distraction." (added by mtj at 01:52 AM, August 08, 2012) |
| 23:35 |
|
dcook |
marc? |
| 23:35 |
|
wahanui |
The MARC specs live at http://www.loc.gov/marc/bibliographic/ - abandon hope all ye who enter here. |
| 23:35 |
|
dcook |
Hmm |
| 23:35 |
|
dcook |
die marc? |
| 23:35 |
|
dcook |
die marc! |
| 23:35 |
|
dcook |
I'll leave it there :p |
| 23:38 |
|
|
as joined #koha |
| 23:38 |
|
|
rocio1 joined #koha |
| 23:42 |
|
wizzyrea |
to that quote I say http://kohadevreactions.tumblr[…]on-for-kohails-in |
| 23:42 |
|
dcook |
lol |
| 23:42 |
|
|
rocio1 left #koha |
| 23:43 |
|
dcook |
@karma davidtennant |
| 23:43 |
|
huginn |
dcook: davidtennant has neutral karma. |
| 23:43 |
|
dcook |
davidtennant++ |
| 23:43 |
|
dcook |
Just sayin' |
| 23:44 |
|
dcook |
http://kohadevreactions.tumblr[…]bborn-bug-kohails |
| 23:44 |
|
dcook |
It took way too long but sort of figured out that double encoding of ampersands.. |
| 23:45 |
|
dcook |
Well, not so much figured out as ran out of room to debug |
| 23:45 |
|
dcook |
OH SNAP |
| 23:45 |
|
* dcook |
facepalm |
| 23:45 |
|
wahanui |
rumour has it facepalm is a tiny member of the Arecaceae family whose preference for warm, humid environments makes it a perfect choice for cultivation in the human nasal cavity |
| 23:45 |
|
dcook |
I lies |
| 23:45 |
|
dcook |
I just found it |
| 23:45 |
|
dcook |
#$*^(%^@@%@)! |
| 23:50 |
|
|
as joined #koha |
| 23:51 |
|
dcook |
So much rubber duck... |
