Time |
S |
Nick |
Message |
00:00 |
|
|
logbot joined #koha |
00:00 |
|
|
Topic for #koha is now Topic for #koha is Koha ILS | Don't ask to ask, just ask! | http://www.koha-community.org | http://paste.koha-community.org |
00:04 |
|
jcamins |
Anyone know where the patch for bug 5101 got to? |
00:04 |
|
munin |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5101 trivial, PATCH-Sent, ---, oleonard, ASSIGNED, Creators tab isn't highlighted when selected |
00:04 |
|
|
davi left #koha |
00:14 |
|
chris_n |
http://gitorious.org/koha-dev/[…]4c6b292f1657de488 |
00:14 |
|
chris_n |
or |
00:14 |
|
chris_n |
http://www.mail-archive.com/ko[…]org/msg00464.html |
00:14 |
|
chris_n |
per google |
00:15 |
|
jcamins |
Oh, sorry, that wasn't a literal "where is the patch" question. |
00:15 |
|
jcamins |
It was more of a "where in the process is the patch" question. |
00:21 |
|
chris_n |
its marked for HEAD, so it will probably appear in the 3.4 branch when it appears |
00:21 |
|
jcamins |
Okay. |
00:21 |
|
jcamins |
Thanks. |
00:22 |
|
chris_n |
np |
00:22 |
|
jcamins |
How do I make sure that a file deletion shows up in my patch? |
00:22 |
|
jcamins |
I think you have to do something special? |
00:22 |
|
chris_n |
git rm <file-to-remove> |
00:23 |
|
jcamins |
Thanks. |
00:24 |
|
chris_n |
good luck wasabi |
00:25 |
|
jcamins |
Heh. |
00:25 |
|
wasabi |
no, good luck to the current site-admins of www.koha.org... |
00:25 |
|
jcamins |
It could happen. |
00:25 |
|
* chris_n |
holds his breath |
00:26 |
|
wasabi |
... its currently *their* stupid problem, not mine |
00:26 |
|
chris_n |
fortunately it is impossible to hold one's breath to the point of death :-) |
00:26 |
|
|
alan left #koha |
00:28 |
|
wasabi |
a problem with a rather obvious solution too |
00:30 |
|
|
brendan_l left #koha |
00:30 |
|
jcamins |
Hm. |
00:30 |
|
jcamins |
I guess there's no way to e-mail a patch to the bugzilla to attach to a bug? |
00:31 |
|
chris_n |
I'm not sure... chris would probably know |
00:31 |
|
jcamins |
In the meantime I guess I'd better download my patch so I can upload it... |
00:34 |
|
jcamins |
Oh, you can attach by URL. |
00:34 |
|
wasabi |
aah, thats way cool |
00:35 |
|
jcamins |
git send-email isn't a git command? |
00:35 |
|
jcamins |
What? |
00:36 |
|
* jcamins |
bangs his head on the table |
00:37 |
|
jcamins |
Why doesn't git send-email work on Debian? |
00:38 |
|
wasabi |
its a separate package |
00:38 |
|
jcamins |
Ah. |
00:38 |
|
jcamins |
Any idea what the package is? |
00:38 |
|
|
brendan_l joined #koha |
00:38 |
|
wasabi |
masonxen1:~/koha$ dpkg -l|grep git-email |
00:38 |
|
wasabi |
ii git-email 1:1.7.1-1.1~bpo50+1 fast, scalable, distributed revision control |
00:39 |
|
jcamins |
It says it's broken. :( |
00:39 |
|
wasabi |
http://packages.debian.org/lenny/git-email |
00:40 |
|
wasabi |
ive got the backports version... |
00:40 |
|
wasabi |
http://packages.debian.org/len[…]ckports/git-email |
00:41 |
|
jcamins |
I think I am very unimpressed with Debian's packaging system. |
00:41 |
|
jcamins |
However, I think that did it. |
00:41 |
|
jcamins |
Thanks. |
00:42 |
|
wasabi |
well, its about 10,00 times faster than my lappy's darwin-ports |
00:42 |
|
jcamins |
Woohoo! git send-email works! |
00:43 |
|
wasabi |
alias git-email='git send-email --to koha-patcheslists.koha-community.org' |
00:44 |
|
jcamins |
chris: I sent you a patch for bug 5261 to sign off on. |
00:44 |
|
munin |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5261 enhancement, P5, ---, koha, ASSIGNED, Can't get to Cataloging sysprefs from Local Use |
00:44 |
|
jcamins |
wasabi: Ooh, good idea. |
00:47 |
|
jcamins |
Where are all the patches that need sign-offs? |
01:00 |
|
|
logbot joined #koha |
01:00 |
|
|
Topic for #koha is now Topic for #koha is Koha ILS | Don't ask to ask, just ask! | http://www.koha-community.org | http://paste.koha-community.org |
01:00 |
|
chris |
http://www.google.com/search?q[…]er.org+inurl:koha <-- trick |
01:05 |
|
jcamins |
Okay, that's just weird. |
01:09 |
|
|
logbot joined #koha |
01:09 |
|
|
Topic for #koha is now Topic for #koha is Koha ILS | Don't ask to ask, just ask! | http://www.koha-community.org | http://paste.koha-community.org |
01:20 |
|
jcamins |
Is there any way to download a patch from the mailing list archives? |
01:28 |
|
chris |
yup |
01:31 |
|
chris |
hmm at least i thought there was |
01:34 |
|
chris |
hmm looks like only the whole mailbxo |
01:34 |
|
chris |
http://lists.koha-community.or[…]ail/koha-patches/ |
01:39 |
|
chris |
nice work on the signoff ;) |
01:41 |
|
jcamins |
:) Thanks. |
01:41 |
|
jcamins |
Oh, speaking of which. |
01:42 |
|
jcamins |
wasabi: when you change your OpacNotPublic patch to an OpacPrivate patch, let me know and I'll sign off on it. |
01:49 |
|
jcamins |
@later tell owen Do you want me to sign-off on your patch for bug 3013? |
01:49 |
|
munin |
jcamins: The operation succeeded. |
01:51 |
|
jcamins |
Okay, bed time. |
01:51 |
|
jcamins |
Good night, #koha |
01:51 |
|
|
jcamins is now known as jcamins_a |
01:58 |
|
|
bankhead joined #koha |
02:01 |
|
|
logbot joined #koha |
02:01 |
|
|
Topic for #koha is now Topic for #koha is Koha ILS | Don't ask to ask, just ask! | http://www.koha-community.org | http://paste.koha-community.org |
03:01 |
|
|
logbot joined #koha |
03:01 |
|
|
Topic for #koha is now Topic for #koha is Koha ILS | Don't ask to ask, just ask! | http://www.koha-community.org | http://paste.koha-community.org |
03:02 |
|
brendan |
heya amit |
03:02 |
|
Amit |
heya brendan |
03:05 |
|
brendan |
chris_n around? |
03:56 |
|
wasabi |
oops, TCL fail... |
04:01 |
|
|
logbot joined #koha |
04:01 |
|
|
Topic for #koha is now Topic for #koha is Koha ILS | Don't ask to ask, just ask! | http://www.koha-community.org | http://paste.koha-community.org |
04:01 |
|
robin |
wasabi: so, situation normal then... |
04:02 |
|
wasabi |
a minor blip, im not complaining :) |
04:06 |
|
|
darling left #koha |
04:12 |
|
robin |
wonder if that was a big quake somewhere else, or a small one here. |
04:16 |
|
robin |
ah, big one somewhere else. Only looks like a 6 though |
05:05 |
|
|
logbot joined #koha |
05:05 |
|
|
Topic for #koha is now Topic for #koha is Koha ILS | Don't ask to ask, just ask! | http://www.koha-community.org | http://paste.koha-community.org |
05:44 |
|
|
hdl joined #koha |
05:45 |
|
|
hdl1 joined #koha |
05:49 |
|
|
hdl left #koha |
05:53 |
|
|
hdl1 left #koha |
06:12 |
|
brendan |
night |
06:18 |
|
|
laurence joined #koha |
06:36 |
|
|
hdl joined #koha |
06:52 |
|
|
hdl left #koha |
06:53 |
|
|
francharb joined #koha |
06:55 |
|
|
stephane1 joined #koha |
07:16 |
|
|
magnus joined #koha |
07:17 |
|
chris |
hi magnus |
07:17 |
|
magnus |
g'day chris |
07:26 |
|
|
ivanc joined #koha |
07:35 |
|
|
ivanc left #koha |
07:58 |
|
|
stephane2 joined #koha |
08:02 |
|
|
stephane1 left #koha |
09:15 |
|
|
stephane1 joined #koha |
09:16 |
|
|
pianohack joined #koha |
09:19 |
|
|
stephane2 left #koha |
09:22 |
|
|
pianohack left #koha |
09:31 |
|
|
Braedon left #koha |
09:31 |
|
|
Braedon joined #koha |
09:38 |
|
|
ivanc joined #koha |
09:39 |
|
ivanc |
hallo #koha |
09:45 |
|
magnus |
hi ivanc |
09:45 |
|
ivanc |
hi magnus |
09:57 |
|
|
markk joined #koha |
10:15 |
|
|
davi joined #koha |
10:25 |
|
wasabi |
http://developers.slashdot.org[…]s-Gosling-Unloads |
10:37 |
|
wasabi |
...very interesting stuff |
10:54 |
|
|
laurence left #koha |
11:38 |
|
|
jwagner joined #koha |
11:41 |
|
|
collum joined #koha |
11:44 |
|
Braedon |
apparently google can |
11:44 |
|
Braedon |
can't find you in a valley in new zealand... :P |
11:44 |
|
|
lgw_wrt left #koha |
11:52 |
|
|
druthb joined #koha |
11:55 |
|
druthb |
mornin'. |
11:56 |
|
|
davi left #koha |
11:58 |
|
magnus |
hiya druthb |
11:58 |
|
druthb |
:) |
12:04 |
|
|
kmkale joined #koha |
12:04 |
|
kmkale |
hi all |
12:05 |
|
druthb |
hi, kmkale. :) |
12:05 |
|
kmkale |
hi druthb |
12:07 |
|
magnus |
hi kmkale |
12:07 |
|
kmkale |
hi magnus |
12:08 |
|
|
Nate joined #koha |
12:12 |
|
|
owen joined #koha |
12:28 |
|
|
wasabi left #koha |
12:29 |
|
|
Amit left #koha |
12:29 |
|
|
alohalog left #koha |
12:30 |
|
|
alohalog joined #koha |
12:32 |
|
|
kmkale left #koha |
12:32 |
|
|
kmkale joined #koha |
12:32 |
|
|
wasabi joined #koha |
12:42 |
|
|
Elwell left #koha |
12:43 |
|
|
Elwell joined #koha |
12:47 |
|
|
davi joined #koha |
12:49 |
|
|
davi left #koha |
12:51 |
|
|
davi joined #koha |
12:59 |
|
|
davi left #koha |
13:02 |
|
|
schuster joined #koha |
13:03 |
|
|
davi joined #koha |
13:05 |
|
schuster |
Look out Ruth's in the house! |
13:05 |
|
|
jcamins_a is now known as jcamins |
13:06 |
|
jcamins |
Morning, #koha |
13:10 |
|
* druthb |
hides from schuster. |
13:10 |
|
jwagner |
No, no -- it's your turn! I had to hide from him yesterday :-) |
13:11 |
|
* jwagner |
hides from everyone.... |
13:11 |
|
* druthb |
wants to hide a lot, lately. |
13:11 |
|
owen |
#koha is a good place to hide |
13:12 |
|
druthb |
That depends on what you're hiding *from*, owen. It's about as good a place to hide as the middle of a football field, for me. |
13:13 |
|
owen |
This place is so quiet lately though |
13:14 |
|
|
lgw_wrt joined #koha |
13:15 |
|
lgw_wrt |
looks like last night's fixes are working |
13:15 |
|
lgw_wrt |
but i could still use some MARC help if anyone is willing to provide it... |
13:17 |
|
jcamins |
lgw_wrt: I can't promise anyone will be able to help, but if you ask your question, someone might be able to at least suggest where to look for the answer. |
13:18 |
|
lgw_wrt |
i figured...so here goes |
13:19 |
|
lgw_wrt |
I've never created MARC records before, and they appear to be very overwhelming. |
13:19 |
|
lgw_wrt |
I'd like to create something for my organization that represents our CD/DVD/BD archives |
13:19 |
|
lgw_wrt |
Some discs have one project, some have many. FIle listings would be great in the description. |
13:19 |
|
lgw_wrt |
I just don't know where to start that is not as confusing as the templates i've seen online |
13:22 |
|
jcamins |
Ah. Unfortunately I mostly avoid cataloging non-book formats. |
13:24 |
|
jcamins |
Well, that's fortunate for me, but not so fortunate for you. ;) |
13:24 |
|
lgw_wrt |
:) |
13:25 |
|
lgw_wrt |
would Koha not be the right solution for what I want? |
13:25 |
|
owen |
lgw_wrt: We have CD-ROMs in our collection, but a quick look doesn't turn up any examples which include a file listing. |
13:25 |
|
owen |
http://search.myacpl.org/cgi-b[…]it=mc-ccode%3ACDR |
13:25 |
|
owen |
I'm not a cataloger, so I can't tell you any more than that. |
13:26 |
|
jcamins |
lgw_wrt: no, it probably would be, I just don't have any advice more helpful than "the MARC format documentation describes the 007 field (and all the others)." |
13:28 |
|
owen |
lgw_wrt: Any sane person would be asking "is MARC the right solution for what I want?" |
13:28 |
|
jcamins |
lgw_wrt: actually, I guess it depends. If all you want is a finding aid, you might be better off using Archivist's Toolkit. |
13:28 |
|
owen |
But library people are not sane. |
13:28 |
|
jcamins |
owen: you noticed? :) |
13:29 |
|
lgw_wrt |
i'll take a look at both and see what looks right |
13:29 |
|
collum |
lgw_wrt: We are not on Koha, but it looks like our catalogers put the contents in the 505 field. http://bit.ly/bqzlc3 |
13:29 |
|
jcamins |
lgw_wrt: http://www.archiviststoolkit.org/ |
13:30 |
|
jcamins |
Do you have materials other than the disk archive? |
13:30 |
|
lgw_wrt |
not right now |
13:30 |
|
jcamins |
Do you lend the disks out? |
13:31 |
|
lgw_wrt |
we do |
13:31 |
|
lgw_wrt |
that's why we're looking at this type of system. we keep losing track on our hand-written sheets |
13:31 |
|
jcamins |
Okay. I'm not sure how AT does with lending. |
13:31 |
|
schuster |
Are the disks proprietary stuff or comercially produced stuff? |
13:31 |
|
lgw_wrt |
proprietary |
13:31 |
|
* collum |
is looking for CDRoms with file contents |
13:32 |
|
lgw_wrt |
be back in a bit... |
13:32 |
|
schuster |
Do the files have to be on disks or could you store them on servers? |
13:32 |
|
lgw_wrt |
on discs...we archive to regain space. |
13:32 |
|
lgw_wrt |
i have to go handle another issue. i'll be back in a while. i'lll keep this open and check for comments when i get back |
13:34 |
|
schuster |
lgw_wrt - yes the 505 - content note would be your best bet at first look on where to put file names. The problem becomes if they cover different concerns. |
13:34 |
|
schuster |
Then you almost need to analytically catalog each file and indicate which disk it would be on and relate all of the titles. |
13:35 |
|
schuster |
A lot of it depends on the down the road what is your goal, and how much time you have to do the cataloging as it all looks like original cataloging. |
13:36 |
|
schuster |
You could probably pay a good cataloger to create a template so then you only have to put in a "FEW" of the tags rather than starting from scratch every time. |
13:40 |
|
|
OpenUser joined #koha |
13:49 |
|
|
wasabi left #koha |
13:49 |
|
|
wasabi joined #koha |
13:52 |
|
lgw_wrt |
each disc is for a specific archive, although some hold multiples. cataloging each disc is relatively simple |
14:04 |
|
|
tcohen joined #koha |
14:10 |
|
lgw_wrt |
i'm thinking this may be beyond what i can do with my allotted resources. i have no funding for this project, and no staff assistance (our IT dept is 2 people for 150 ) |
14:14 |
|
jcamins |
lgw_wrt: yeah, Koha might not be the right thing for you. |
14:19 |
|
|
ebegin joined #koha |
14:24 |
|
|
kmkale left #koha |
14:24 |
|
ebegin |
Anybody has problem with the Year limit? |
14:25 |
|
ebegin |
As soon as I use a date limit, nothing is found... I would like to find in the pubdate (260$c) field. |
14:26 |
|
|
kmkale joined #koha |
14:29 |
|
|
wizzyrea_ joined #koha |
14:40 |
|
Braedon |
ebegin: using zebra? |
14:41 |
|
* druthb |
waves to kmkale and wizzyrea_ |
14:41 |
|
kmkale |
hi wizzyrea_ |
14:42 |
|
wizzyrea_ |
hi kmkale! |
14:42 |
|
wizzyrea_ |
hi druthb! |
14:47 |
|
Braedon |
ebegin: i have to run (and by run i mean sleep), but if you are using nozebra indexing, that could well be your problem. If you are using zebra, no clue sorry. |
14:48 |
|
jcamins |
ebegin: the problem may be that you don't have dates in the 008 field. |
14:48 |
|
lgw_wrt |
just imported a record created using "Archivist's Toolkit". It imported successfully, but I can't seem to search for it. Any advice? |
14:48 |
|
Braedon |
is a zebra indexing job running? |
14:49 |
|
lgw_wrt |
how do i check? |
14:49 |
|
jcamins |
lgw_wrt: I've never used AT, I just know that it is good for archival collections. |
14:50 |
|
lgw_wrt |
i created the MARC record using AT so I could have a "template" to work with |
14:50 |
|
Braedon |
(the answer to all search related issues is blame zebra or nozerbra :P) |
14:50 |
|
lgw_wrt |
the import into koha was successful, but i can't search for my record |
14:50 |
|
jcamins |
Braedon: good night. |
14:50 |
|
jcamins |
lgw_wrt: try reindexing? |
14:50 |
|
lgw_wrt |
how? |
14:50 |
|
jcamins |
rebuild_zebra.pl |
14:51 |
|
Braedon |
but alas i really should get to bed, being 4am and all. sorry lgw_wrt, look on the wiki for zebra script stuffs |
14:51 |
|
Braedon |
night jcamins |
14:52 |
|
jcamins |
lgw_wrt: do you have any records in Koha? |
14:52 |
|
jcamins |
Other than the one you just added, I mean. |
14:52 |
|
lgw_wrt |
no. that's where i've been struggling |
14:52 |
|
jcamins |
Okay. |
14:53 |
|
lgw_wrt |
error on rebuild_zebra...missing a perl module. installing that right now |
14:53 |
|
jcamins |
http://koha-community.org/docu[…]on/faq/searching/ |
14:55 |
|
wizzyrea_ |
is there something odd about the withdrawn authorized value? |
14:55 |
|
wizzyrea_ |
something different from the other authorized values? |
14:56 |
|
jcamins |
Well, we don't have any category for it, but I am imagining that's a misconfiguration on our part. |
14:57 |
|
wizzyrea_ |
hmmm |
14:58 |
|
lgw_wrt |
the debian install never created a kohauser, so scripts can't run under that user |
14:58 |
|
jcamins |
lgw_wrt: how did you install Koha? |
14:59 |
|
lgw_wrt |
sqeeuze/koha apt source |
14:59 |
|
jcamins |
Hm. |
14:59 |
|
jcamins |
When I did that it created a Koha user. |
15:00 |
|
jcamins |
I think it was koha-[something]. |
15:00 |
|
lgw_wrt |
scripts also can't find c4 perl modules. |
15:00 |
|
lgw_wrt |
i'm thinking this is more of a headache than i need right now |
15:00 |
|
lgw_wrt |
i love the power of koha, but it's just too frustrating right now to get up and running for my environment |
15:01 |
|
jcamins |
lgw_wrt: the FAQ gives you the command to put the C4 modules in your environment. |
15:02 |
|
jcamins |
PERL5LIB=/wherever/koha/is |
15:02 |
|
jcamins |
export PERL5LIB |
15:02 |
|
jcamins |
Oh, you also need: |
15:02 |
|
jcamins |
KOHA_CONF=/path/to/koha-conf.xml |
15:02 |
|
jcamins |
export KOHA_CONF |
15:03 |
|
jcamins |
However, since you have no resources for this project, I (personally) would probably tend to agree that administering Koha might be a bit much. |
15:04 |
|
lgw_wrt |
maybe again in the future. |
15:04 |
|
lgw_wrt |
thanks to all for the assistance |
15:06 |
|
jcamins |
You're welcome. |
15:06 |
|
jcamins |
Good luck. |
15:06 |
|
kmkale |
bye all |
15:07 |
|
|
kmkale left #koha |
15:17 |
|
|
lgw_wrt left #koha |
15:17 |
|
|
alex_a left #koha |
15:19 |
|
ebegin |
jcamins, sorry, I had to step away. Concerning the search on the year, you are correct, i don't have data in the 008 field, the data I want to search is in the 260$c, which is the copydate index |
15:21 |
|
jcamins |
ebegin: yeah, you can't limit on that. |
15:21 |
|
jcamins |
However, it is possible to search on copydate. |
15:22 |
|
jcamins |
If I can remember how... |
15:22 |
|
ebegin |
Oh, that is why the seach on it works but not the limit |
15:22 |
|
ebegin |
s/seach/search |
15:23 |
|
ebegin |
Where are set the fields for the limit? |
15:23 |
|
jcamins |
008. |
15:24 |
|
jcamins |
I don't know how to change that. |
15:42 |
|
ebegin |
ok, thanks for the hint jcamins, i'll look into it |
15:47 |
|
|
ivanc left #koha |
15:47 |
|
|
nengard joined #koha |
15:48 |
|
nengard |
question about the items table - what is stored in the reserves field? the current number of holds or all the holds ever placed on the item? |
15:48 |
|
wizzyrea_ |
the 2nd |
15:48 |
|
nengard |
ick |
15:48 |
|
wizzyrea_ |
er |
15:48 |
|
wizzyrea_ |
no, sorry I misunderstood |
15:48 |
|
wizzyrea_ |
the current holds |
15:48 |
|
|
markk left #koha |
15:48 |
|
nengard |
:) woo hoo |
15:48 |
|
nengard |
thanks |
15:48 |
|
wizzyrea_ |
the old holds go to the deleted reserves |
15:48 |
|
wizzyrea_ |
or old reserves |
15:48 |
|
wizzyrea_ |
can't remember |
15:48 |
|
wizzyrea_ |
but they move on outta there |
15:49 |
|
wizzyrea_ |
had a situation just yesterday where I had to look up an accidentally deleted hold and sho nuff it was in the old reserves |
15:52 |
|
nengard |
k - so when it moves to old it subtracts one from 'reserves' |
16:01 |
|
|
sekjal joined #koha |
16:01 |
|
nengard |
need help |
16:01 |
|
wizzyrea_ |
yep |
16:01 |
|
nengard |
writing a report to show items that are overdue that have holds on them ... i want it to show who has the book out so i cna call them and say give us the book cause it has holds on it |
16:01 |
|
nengard |
this is what i have - it's wrong |
16:02 |
|
nengard |
and my brain is tired |
16:02 |
|
nengard |
SELECT borrowers.cardnumber, borrowers.surname, borrowers.firstname, borrowers.phone, borrowers.address, borrowers.city, borrowers.zipcode, issues.date_due, (TO_DAYS(curdate())-TO_DAYS( date_due)) AS 'days overdue', items.itype, biblio.title, biblio.author, items.itemcallnumber, items.barcode, COUNT(reserves.biblionumber) AS 'holds' FROM borrowers LEFT JOIN issues ON (borrowers.borrowernumber=issues.borrowernumber) LEFT JO |
16:02 |
|
nengard |
IN items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) LEFT JOIN reserves ON (biblio.biblionumber=reserves.biblionumber) |
16:02 |
|
nengard |
GROUP BY reserves.biblionumber WHERE issues.branchcode = 'VSN5' AND holds >= 1 ORDER BY borrowers.surname ASC, issues.date_due ASC |
16:02 |
|
wizzyrea_ |
zounds |
16:02 |
|
|
stephane1 left #koha |
16:04 |
|
nengard |
first it was in the wrong order a bit |
16:04 |
|
nengard |
so here it is again: |
16:04 |
|
nengard |
SELECT borrowers.cardnumber, borrowers.surname, borrowers.firstname, borrowers.phone, borrowers.address, borrowers.city, borrowers.zipcode, issues.date_due, (TO_DAYS(curdate())-TO_DAYS( date_due)) AS 'days overdue', items.itype, biblio.title, biblio.author, items.itemcallnumber, items.barcode, COUNT(reserves.biblionumber) AS 'holds' FROM borrowers LEFT JOIN issues ON (borrowers.borrowernumber=issues.borrowernumber) LEFT JO |
16:04 |
|
nengard |
IN items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) LEFT JOIN reserves ON (biblio.biblionumber=reserves.biblionumber) WHERE issues.branchcode = 'VSN5' AND holds >= 1 GROUP BY reserves.biblionumber ORDER BY borrowers.surname ASC, issues.date_due ASC |
16:04 |
|
nengard |
i tried querying items.reserves - but that didn't work |
16:07 |
|
|
reva joined #koha |
16:13 |
|
reva |
hi all again, there is a .pl script called bulkauthorityimport in the same folder as the bulkmarcimport; has anyone here tried it? Also, do I pick "run" option in the options that come up when I "open"? (I mean does it run a GUI version of it as opposed to "run in terminal" option? |
16:15 |
|
nengard |
sekjal helped me - report going to the wiki as soon as i eat |
16:17 |
|
reva |
Just FYI: the link to the 3.2 manual on this page seems broken or something: http://koha-community.org/docu[…]/faq/authorities/ |
16:18 |
|
reva |
The link appears here: For more information, navigate to the 3.2 Manual and scroll down to section 1.4.1.3 and see the entry on ‘Thesaurus.’ |
16:22 |
|
|
rhcl_away left #koha |
16:26 |
|
|
rhcl_away joined #koha |
16:26 |
|
|
rhcl_away left #koha |
16:26 |
|
|
rhcl_away joined #koha |
16:26 |
|
|
rhcl_away is now known as rhcl |
16:28 |
|
owen |
Hi rhcl, did you get my reply to your patron search message? |
16:36 |
|
reva |
hi anyone, as you know I run a Live CD version of Koha 3.0.6. It has gotten quite a few records, all done by trainee staff for practice. It would be too much work to correct them all. So I would like to reinstall the Koha part alone without starting from scratch (i.e., leave the ubuntu server untouched in ubuntu/koha appliance). Is there a way to do it? |
16:36 |
|
|
druthb left #koha |
16:36 |
|
rhcl |
owen: was away from desk for a sec, lemme look |
16:37 |
|
reva |
Oh, I forgot to mention, my Live CD is right now in the VirtualBox. |
16:38 |
|
jcamins |
reva: you need to run the scripts from the command line. |
16:39 |
|
jcamins |
And why don't you just delete all the records, if that's what you want to do? |
16:39 |
|
reva |
ok, I am game. But are you answering the question running the perl scripts? |
16:40 |
|
jcamins |
I have never used bulkauthorityimport, but I do know that you can't run the scripts by double-clicking. |
16:40 |
|
jcamins |
They won't work without the appropriate arguments. |
16:41 |
|
reva |
I suppose I can delete the records, but deleting does not get rid of the log entries for them. So looking at the log is messy. |
16:43 |
|
jcamins |
Hm. |
16:43 |
|
jcamins |
I would suggest that is probably a better option than trying to reinstall Koha. |
16:44 |
|
jcamins |
Wait, why can't you just reinstall the entire system? |
16:44 |
|
jcamins |
It's a LiveCD, so it's preconfigured. |
16:44 |
|
reva |
jcamins, this is in regards to running perl scripts: when I right clicked on one of them, it gave me two options: one to "Open" and another to "Open with other application"; when I clicked to "Open" it came up with further option to "display", "run" or "run in terminal". That was why I asked as to what exactly "run" does as opposed to "run in termina". |
16:45 |
|
jcamins |
reva: you shouldn't be right-clicking them at all. You need to open up a terminal and run them from the terminal. |
16:45 |
|
jcamins |
So you open the terminal, change to the directory they are in, and run them from there. |
16:45 |
|
jcamins |
reva: http://www.freesoftwaremagazin[…]ommand_line_intro |
16:46 |
|
reva |
jcamins, I can; but I did not have to go through running all those commands for clipboard/desktop integration. (Braedon walked me through that; I have the instructions saved; but it is a pain.) |
16:47 |
|
reva |
jcamins, I will look at the link you have given here. |
16:48 |
|
jcamins |
I would suggest just deleting the records and dealing with the data in the log. |
16:48 |
|
jcamins |
Just always make sure you look at the log starting September 29. |
16:50 |
|
reva |
jcamins, Yeah, I suppose I can mark the cut off date and the bib and item record numbers where we start "serious" input.:) |
16:51 |
|
|
hdl joined #koha |
16:53 |
|
|
hdl left #koha |
16:53 |
|
reva |
Anyway, we will be installing the 3.2 directly on the hard drive with Debian. I am leaving the Live CD in the VirtualBox (just in case situation to serve as a template and for future training in case of staff change). |
16:54 |
|
jcamins |
reva: in that case why does it matter at all? |
16:54 |
|
nengard |
http://wiki.koha-community.org[…]ith_Holds_Waiting |
16:54 |
|
reva |
I know; it should not jcamins; but I am a tidiness freak. |
16:57 |
|
jcamins |
My rule of thumb is that anything that doesn't significantly impact my patrons or my productivity doesn't matter. It means I'm only surprisingly gray and not entirely gray. ;) |
16:57 |
|
reva |
what do you mean? as in mature? |
16:58 |
|
reva |
I meant about the word "grey" in your comment. But I saw your avatar picture in one of the FAQ comments. You do not have grey hair:) |
16:59 |
|
reva |
I will try to be mature too about being obsessive with behind the scenes things, jcamins:0 |
16:59 |
|
jcamins |
reva: no, everyone in my family goes gray young, and I blame it on dealing with MARC. ;) |
17:00 |
|
jcamins |
That's a very old picture. |
17:00 |
|
|
hdl1 joined #koha |
17:01 |
|
reva |
So vain to put in a very old picture:). And I can very well see a direct cause and effect association with MARC tags and going grey early. |
17:04 |
|
jcamins |
Actually, I just didn't have any other good pictures of myself in digital format. ;) |
17:07 |
|
reva |
ok, ok, take that comment back about vanity. I am reading the contents on the page you just pointed me to; it starts me off at an elementary level: I have to say, my minor was Computer Science and that was when there were only Unix terminals:P and gnu debuggers, emacs and vi editor> |
17:08 |
|
jcamins |
Oh, then just pull up a terminal, and go to. :) |
17:12 |
|
reva |
Ok, I will get back with more questions, I am sure. Thanks jcamins. |
17:36 |
|
rhcl |
munin - bug 5266 |
17:36 |
|
munin |
rhcl: Error: "-" is not a valid command. |
17:36 |
|
rhcl |
deal with it dude |
17:36 |
|
rhcl |
bug 5266 |
17:36 |
|
munin |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5266 major, P5, ---, kyle.m.hall, NEW, Patron Search Produces Incorrectly Sorted and Missing Results |
17:38 |
|
|
magnus left #koha |
17:38 |
|
|
francharb left #koha |
18:02 |
|
owen |
nengard around? |
18:02 |
|
nengard |
1/2 |
18:03 |
|
owen |
nengard I don't understand Bug 5267 |
18:03 |
|
munin |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5267 minor, P5, ---, oleonard, NEW, koha logo shouldn't be on authorities page |
18:03 |
|
owen |
The koha logo is on almost every staff client page |
18:03 |
|
owen |
Any page which has a search box at the top has the Koha logo |
18:04 |
|
nengard |
you know what - my brain is so wiped out - it's that the search box is below the logo instead of to the right of it that made it look funny |
18:04 |
|
nengard |
and that might be that i was zoomed in |
18:04 |
|
nengard |
hang on |
18:04 |
|
owen |
I see, the layout does break if your browser window is too small |
18:05 |
|
owen |
The authorities search form is wider than most |
18:08 |
|
nengard |
closed as invalid - i have been going nonstop since last sunday so my brain has no more power in it and i'm doing silly/stupid things |
18:09 |
|
owen |
Thanks for clarifying nengard |
18:10 |
|
nengard |
no prob - thanks for pointing it out to me |
18:11 |
|
owen |
Bug 5265 is a good one though :) |
18:11 |
|
munin |
Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5265 minor, P5, ---, oleonard, NEW, error message on lists is misleading |
18:23 |
|
nengard |
:) |
18:23 |
|
nengard |
i do have 1/2 a brain today |
18:23 |
|
* owen |
looks forward to reading 50% of your bug reports today |
18:24 |
|
nengard |
LOL |
18:24 |
|
nengard |
i'm done |
18:24 |
|
nengard |
i'm going to the airport now!! home for a rest of the brain |
18:33 |
|
|
nengard left #koha |
18:37 |
|
|
hdl1 left #koha |
18:39 |
|
|
hdl joined #koha |
18:40 |
|
chris |
Morning |
18:40 |
|
owen |
Hi chris |
18:41 |
|
chris |
Hey owen how's things? |
18:42 |
|
owen |
Not bad. Been fighting with Drupal for the last few days. |
18:42 |
|
* chris_n |
greets chris |
18:42 |
|
chris_n |
and hands owen a bigger stick |
18:43 |
|
owen |
Thanks chris_n, I'm wearing Drupal down through perseverance |
18:43 |
|
chris |
Owen: shiny knows craploads about drupal |
18:43 |
|
|
wajasu joined #koha |
18:44 |
|
chris |
If you get stuck pester her :) |
18:45 |
|
owen |
Usually if I get stuck I just work on Koha for a few weeks ;) |
18:45 |
|
chris |
Heh |
18:46 |
|
hdl |
hi |
18:47 |
|
chris |
Hi hdl |
18:47 |
|
chris |
Started packing yet? |
18:47 |
|
chris |
:) |
18:48 |
|
wizzyrea_ |
/me has started packing |
18:48 |
|
wizzyrea_ |
srs. |
18:49 |
|
chris |
heh |
18:49 |
|
chris |
Based on today, bring a rain coat |
18:52 |
|
chris |
Ok my stop |
18:58 |
|
|
wajasu left #koha |
18:59 |
|
|
tcohen left #koha |
19:10 |
|
|
briceSanc joined #koha |
19:10 |
|
briceSanc |
hello |
19:11 |
|
chris |
back |
19:14 |
|
briceSanc |
We have to change the default Koha template for our client's needs. With your experience, what is the best approach to not be too upset when Koha be updated ? |
19:14 |
|
owen |
briceSanc: Are you *sure* you need to change the template? |
19:15 |
|
briceSanc |
I'm sure |
19:15 |
|
chris |
what do you need it to do? |
19:15 |
|
briceSanc |
not the template engine but the design |
19:16 |
|
briceSanc |
am�liorations ergonomiques, nouvelles couleurs, ... |
19:16 |
|
briceSanc |
oops |
19:16 |
|
ebegin |
hehe :) |
19:16 |
|
briceSanc |
ergonomic improvements, new colors ... |
19:17 |
|
owen |
briceSanc: I'd be happy to advise you on changes which can be made via CSS if you can share specifics |
19:17 |
|
briceSanc |
ctrl+c,v problem :) |
19:17 |
|
owen |
Colors are an obvious thing which don't require a new template |
19:17 |
|
ebegin |
There is no really easy way other than limiting your modification of the .tmpl file. When a new verison is release, compare the previous community-release to the new one and adapt your template accordingly |
19:17 |
|
chris |
yeah you can probably do a lot of that with jquery and css |
19:18 |
|
chris |
so yeah do as much as you possibly can that way, otherwise you just make upgrading harder and harder |
19:18 |
|
wizzyrea_ |
< was in the template updating trap |
19:18 |
|
wizzyrea_ |
I escaped with jquery |
19:18 |
|
chris |
ohh way cool |
19:18 |
|
chris |
check out the latest message to the list |
19:18 |
|
chris |
http://bugs.koha-community.org[…]w_bug.cgi?id=5260 |
19:18 |
|
munin |
Bug 5260: enhancement, P5, ---, henridamien, NEW, It would be nice if Koha's Acquisition module could order by email |
19:18 |
|
wizzyrea_ |
OOOOO |
19:19 |
|
wizzyrea_ |
oooOOOooo |
19:19 |
|
wizzyrea_ |
that's a good one |
19:19 |
|
chris |
with a patch to test out |
19:19 |
|
chris |
i need 6 more hands |
19:19 |
|
sekjal |
chris: I hear you on that; want to test, don't have so much the time right now |
19:19 |
|
wizzyrea_ |
I might get to it in a couple of days |
19:19 |
|
ebegin |
when you mean with jquery, you mean that you are updating the site DOM with JQuery function? |
19:19 |
|
wizzyrea_ |
I have a couple of libraries who migt want that |
19:20 |
|
owen |
ebegin: You can use system prefs to embed jQuery which changes HTML on the page |
19:20 |
|
chris |
ill reply and say, very cool, #koha on irc got quite excited |
19:20 |
|
|
jwagner left #koha |
19:20 |
|
|
cait joined #koha |
19:20 |
|
ebegin |
owen: what about the performances? |
19:20 |
|
cait |
hi #koha |
19:21 |
|
sekjal |
gtg. later, #koha |
19:21 |
|
|
sekjal left #koha |
19:21 |
|
wizzyrea_ |
bye i... oh bother |
19:21 |
|
owen |
ebegin: The only answer to that question is test it |
19:21 |
|
briceSanc |
ok thanks for your answers |
19:21 |
|
ebegin |
:) |
19:21 |
|
chris |
ebegin: firefox and chromium are fast, ie 7 .... not so much |
19:21 |
|
ebegin |
briceSanc, there is another option... |
19:22 |
|
ebegin |
Make such a kick ass template that the whole community will adopt it ;) |
19:22 |
|
|
collum left #koha |
19:22 |
|
briceSanc |
:) |
19:22 |
|
briceSanc |
it would be nice |
19:22 |
|
briceSanc |
i want but i don't know for my client... |
19:23 |
|
chris |
right, emailed edgar |
19:29 |
|
|
schuster left #koha |
19:29 |
|
briceSanc |
bye everyone, i return to the hourly loan |
19:29 |
|
|
briceSanc left #koha |
19:29 |
|
owen |
Missed opportunity |
19:30 |
|
jcamins |
owen: what opportunity? |
19:30 |
|
owen |
To preach the customization gospel of CSS and jQuery |
19:30 |
|
chris |
:) |
19:30 |
|
jcamins |
Oh, well, I'm converted. |
19:31 |
|
owen |
Or at the very least to be able to say "Yeah, you need a new template for that, sucks to be you" ;) |
19:31 |
|
jcamins |
Of course, I mostly want to add new pages, not modify existing ones. |
19:32 |
|
|
hdl left #koha |
19:34 |
|
slef |
morning |
19:34 |
|
chris |
hi slef |
19:35 |
|
slef |
it's all go here this week... bones on the beach Monday, hotel on fire tonight |
19:35 |
|
|
hdl joined #koha |
19:35 |
|
chris |
yikes! |
19:35 |
|
chris |
human bones? |
19:36 |
|
slef |
yes... let me get the link from http://identi.ca/mjray |
19:36 |
|
|
richard joined #koha |
19:36 |
|
slef |
http://bbc.co.uk/news/mobile/u[…]somerset-11418528 |
19:36 |
|
slef |
hotel on fire is http://www.bbc.co.uk/news/mobi[…]-bristol-11439046 |
19:36 |
|
chris |
we've just got whales :( |
19:37 |
|
chris |
http://www.msnbc.msn.com/id/39[…]news-environment/ |
19:37 |
|
slef |
yeah, something I wondered... instead of NZ pushing them back into the sea and Japan dodgily hunting "for scientific research", why doesn't NZ export the stupid ones to Japan? |
19:37 |
|
|
CGI358 joined #koha |
19:37 |
|
chris |
heh |
19:37 |
|
chris |
is the hotel near you? |
19:38 |
|
slef |
not massively, but I go past it on my way into town |
19:38 |
|
chris |
happy whale |
19:38 |
|
chris |
http://www.youtube.com/watch?v=ZdVHZwI8pcA |
19:38 |
|
wizzyrea_ |
oo, whale watching |
19:38 |
|
|
CGI358 left #koha |
19:38 |
|
slef |
Kewstoke Toll Road is closed, which is my usual route in |
19:40 |
|
chris |
http://www.stuff.co.nz/nationa[…]e-entangled-whale <-- and good whale news |
19:43 |
|
chris_n |
@wunder 28334 |
19:43 |
|
munin |
chris_n: The current temperature in Dunn, North Carolina is 21.1�C (3:49 PM EDT on September 29, 2010). Conditions: Light Rain. Humidity: 87%. Dew Point: 19.0�C. Pressure: 29.44 in 996.8 hPa (Steady). Flash Flood Watch in effect through Thursday afternoon... |
19:43 |
|
* chris_n |
goes after his canoe |
19:43 |
|
chris |
:) |
19:44 |
|
chris_n |
although "Light Rain" is a bit of an understatement |
19:45 |
|
|
reva left #koha |
19:46 |
|
|
hdl left #koha |
19:46 |
|
jcamins |
@wunder 11105 |
19:46 |
|
munin |
jcamins: The current temperature in Astoria, Astoria, New York is 25.0�C (3:51 PM EDT on September 29, 2010). Conditions: Mostly Cloudy. Humidity: 53%. Dew Point: 15.0�C. Pressure: 29.91 in 1012.8 hPa (Steady). Flood Watch in effect from late tonight through late Friday night... |
19:47 |
|
jcamins |
What, now that the threat of tornado is past we have to worry about flooding? |
19:47 |
|
|
hdl joined #koha |
19:47 |
|
slef |
jcamins: yep, if the rain doesn't get you from above, it will from below. |
19:49 |
|
jcamins |
Lucky us. |
19:52 |
|
jcamins |
owen: I won't be doing it tonight, but would you like me to sign-off on your patch for the 006 builder? |
19:53 |
|
cait |
jcamins++ |
19:53 |
|
owen |
Sure jcamins, if it looks good to you. Thanks |
19:53 |
|
cait |
thx for signing-off my patch! |
19:53 |
|
jcamins |
cait: you're welcome. |
19:54 |
|
jcamins |
cait: oh, that reminds me. Is there any chance you could send your patch for the ohloh links directly to me? Apparently you can't download just one message from the archives, and our mail server ran out of room so I had to delete my local archives. |
19:54 |
|
jcamins |
I'll sign off on it. |
19:55 |
|
jcamins |
I'm feeling sign-off-y, probably because this allows me to avoid my own development for a while. |
19:55 |
|
cait |
jcamins: no problem |
19:56 |
|
cait |
will try to do it tomorrow |
19:56 |
|
jcamins |
Thanks. |
19:56 |
|
ebegin |
Am i correct when I state that we cannot delete a vendor? |
19:57 |
|
ebegin |
(other than removing it from the db) |
19:57 |
|
owen |
ebegin: Yes |
19:57 |
|
owen |
But you can make it inactive |
19:57 |
|
ebegin |
Is there a reason? |
19:58 |
|
owen |
Because you might have past orders in the system from that vendor |
19:59 |
|
chris |
yeah if you ahve ever ordered anything from that vendor, the item will be linked to it |
19:59 |
|
chris |
but we should allow ppl to delete ones that have never been used |
19:59 |
|
ebegin |
that what I was about to suggest. |
19:59 |
|
chris |
interviewee is late ... not a good start |
20:00 |
|
slef |
chris: depends on the explanation. |
20:00 |
|
chris |
true |
20:00 |
|
owen |
"Found bones on the beach on way to interview" |
20:00 |
|
slef |
"my bus got stuck under a whale" might pass, for example |
20:00 |
|
cait |
ebegin: i wrote a bug report for " can not delete vendor " |
20:00 |
|
slef |
but they should have emailed |
20:00 |
|
cait |
it's somewhere in bugzilla |
20:00 |
|
slef |
assuming the whale had wifi |
20:01 |
|
ebegin |
ok, thanks cait! |
20:01 |
|
|
alan joined #koha |
20:14 |
|
|
schuster joined #koha |
20:19 |
|
|
schuster left #koha |
20:21 |
|
|
owen left #koha |
20:37 |
|
|
jcamins is now known as jcamins_a |
20:37 |
|
|
ivanc joined #koha |
20:37 |
|
|
ivanc left #koha |
20:54 |
|
|
darling joined #koha |
21:33 |
|
|
cait left #koha |
21:45 |
|
|
davi left #koha |
21:50 |
|
|
wizzyrea_ left #koha |
22:22 |
|
munin |
New commit(s) kohagit: bug 4084: remove \r from header line for sake of consistency <http://git.koha-community.org/[…]933c93747e2fe30f6> / (bug #4084) fix offline circ <http://git.koha-community.org/[…]2acbab29f530c35e7> |
23:07 |
|
brendan |
@wunder 93117 |
23:07 |
|
munin |
brendan: The current temperature in Northwest Goleta, Goleta, California is 26.3�C (4:10 PM PDT on September 29, 2010). Conditions: Clear. Humidity: 53%. Dew Point: 16.0�C. Pressure: 29.74 in 1007.0 hPa (Falling). |
23:10 |
|
|
hdl left #koha |
23:40 |
|
|
Nate left #koha |
23:55 |
|
|
bankhead joined #koha |