IRC log for #koha, 2012-02-26

All times shown according to UTC.

Time S Nick Message
02:09 gmcharlt @quote random
02:09 huginn gmcharlt: Quote #152: "gmcharlt: Koha: unifying the world one library at a time" (added by wizzyrea at 02:19 PM, September 13, 2011)
02:34 fALSO_ left #koha
04:19 wizzyrea1 joined #koha
05:12 cait joined #koha
05:12 cait good morning #koha
06:08 luisb joined #koha
06:22 magnus_afk hiya cait and #koha
06:24 cait hi magnus_afk :)
06:24 magnus_afk i thought i was up early
06:24 magnus_afk :-)
06:25 cait nope
06:25 cait beat you :)
06:26 magnus_afk you're always here, aren't you ;-)
06:29 cait no
06:29 cait sometimes I sleep :P
06:29 magnus_afk ah
07:04 hdl joined #koha
07:12 hdl joined #koha
07:42 luisb joined #koha
08:04 mbalmer joined #koha
09:10 cait morning mbalmer
09:10 mbalmer morgen!
11:17 Mehwish joined #koha
11:17 Mehwish hi all I need a help regarding KOha database..
11:18 Mehwish is there any one who knows koha database in detail?
11:18 cait ask your question :)
11:19 Mehwish I need to know that what table stores shelving information for books...??
11:20 cait what do you want to do?
11:20 Mehwish means "Shelving location" that we write when we add item..
11:20 Mehwish I want to copy that information from my older koha to newer one.
11:21 cait items information is all stored in the items table
11:21 Mehwish I copied lots of tables but don't know which table stores that info.
11:21 cait copying over single tables is a bit dangerous
11:21 jcamins Mehwish: don't copy over tables.
11:21 jcamins Mehwish: you should take a complete dump of your database, load it on the new system, then run the upgrade script.
11:22 Mehwish no I changed database due to some other reason.
11:22 Mehwish in older Koha I did not use zebra
11:22 jcamins Mehwish: I don't think anyone will be able to offer you any help on your installation.
11:23 Mehwish in new koha I setup zebra and was confused that which tables uses zebra
11:23 Mehwish so i imported books from older koha
11:23 jcamins Mehwish: as long as you understand that you probably won't be able to get help from anyone when you run into problems (and you will!).
11:24 cait Mehwish: zebra doesn't use tables
11:24 cait or not any tables different
11:24 Mehwish hmm.. but can any one just tell me where Authorized values are stored? I mean in which table?
11:24 cait in your database you only need to activate the system preference
11:24 cait in the table with the sa ename
11:25 jcamins Mehwish: read installer/data/mysql/kohastructure.sql
11:28 Mehwish I ok I am trying that.
11:33 Mehwish OK thanks It will help me I hope.
11:33 jcamins Mehwish: good luck, but *please* consider upgrading properly.
11:34 jcamins As I said, I don't think you'll get any help if you insist on copying over individual tables.
11:34 cait Mehwish: it will end up messy and is really not necessary
13:12 jcamins bug 7590
13:12 huginn Bug[…]w_bug.cgi?id=7590 normal, P5 - low, ---, frederic, Needs Signoff , Cataloging authorities search result page is broken
13:17 cait ah yes
13:17 cait not sure how to test that
13:17 cait looking at 7298 now
14:54 mbalmer joined #koha
14:58 mbalmer joined #koha
14:58 hdl joined #koha
15:07 hdl joined #koha
15:33 ago43 joined #koha
16:08 mib_dmc7ok joined #koha
16:50 cait silent day
16:50 cait on #koha
16:52 jcamins_away Indeed it is.
16:56 * cait shares cake with jcamins
16:56 jcamins :)
17:01 cait noone else here.. more cookies for us
17:07 cait new evil bug filed
17:08 jcamins Interesting.
17:08 wahanui well, interesting is good
17:09 jcamins Not in this case, wahanui.
17:09 wahanui jcamins: excuse me?
17:09 cait no, not really
17:09 cait one of our libraries found it
17:09 cait wonder why nobody ever before did
17:10 jcamins It depends on the browser.
17:10 jcamins So maybe old versions of Firefox worked correctly.
17:10 cait bug 7607
17:10 huginn Bug[…]w_bug.cgi?id=7607 major, P5 - low, ---, gmcharlt, NEW , Advanced search: Index and search term don't match when leaving fields empty
17:10 cait I just tested in chrome
17:10 cait I see the same behaviour there :(
17:10 cait so perhaps the browser idea is a false lead
17:10 jcamins Right. But you didn't test *old* versions.
17:11 jcamins No, it's definitely dependent on the browser.
17:11 cait hm no i didn't
17:11 cait well
17:11 cait that#s good
17:11 cait perhaps we can fix it on template level then
17:11 cait becaue fixing in
17:11 jcamins It has to do with whether browsers pass empty CGI params.
17:11 cait do you think it warrants a critical?
17:12 jcamins Hmm.
17:12 jcamins It is a pretty big issue.
17:18 cait I think so too
17:21 jcamins Maybe I could rebase 7248.
17:22 jcamins It seems to me it should be pretty simple. All I'm doing is removing code.
17:23 cait what's the opposite of collapsed?
17:23 jcamins Expanded?
17:23 cait aah
17:23 cait right
17:23 cait thank you
17:25 cait ok another bug filed
17:51 Guillaume joined #koha
18:12 Soupermanito joined #koha
18:46 adnc joined #koha
18:55 Viktor joined #koha
19:04 Viktor_ joined #koha
19:05 Viktor_ left #koha
19:20 ibeardslee joined #koha
19:58 adnc joined #koha
20:44 Space_Librarian joined #koha
20:48 Space_Librarian o/
20:49 cait hi Space_Librarian
20:50 jcamins How was your half-marathon?
20:51 Space_Librarian walked 21km in 2h45 (my stopwatch was 2h43.45, but who's to quibble). It was great. But my toes are very sore today. :D
20:51 * Space_Librarian can finally plot to make fudge
20:51 jcamins Awesome!
20:55 ibeardslee did you use your 5 finger shoes?
20:56 luisb joined #koha
21:00 Space_Librarian ibeardslee, next year - I haven't had them long enough to think it was a good idea.
21:51 Space_Librarian lovely people - when organising serial subscriptions - and the issue number goes up indefinitely, while the volume number ticks over ever 12 issues... how does one set this up? I've RTFM'd, and I've tried all possible variations on the theme. Guidance would be most appreciated so early on a Monday morning... Pretty please?
21:52 jcamins Space_Librarian: you set the numbering to Volume, Number.
21:52 jcamins Then you set rollover to 12.
21:52 jcamins I think.
21:52 eythian hi
21:53 Space_Librarian hey eythian
21:54 Space_Librarian jcamins: and the issue number? (that's where it seems to get iffy)
21:54 cait Space_Librarian: every 12 the X + 1 and y +1 indefinitely, right?
21:54 cait I think you need to use a special pattern here
21:54 jcamins Space_Librarian: oh, I misunderstood.
21:54 cait I have documentation for that... but it's on the hard drive at work
21:54 Space_Librarian There is a paatern
21:54 jcamins Space_Librarian: I have a really bad cold, sorry.
21:54 Space_Librarian pattern*
21:54 Space_Librarian jcamins: np
21:54 jcamins It's like newspapers.
21:55 Space_Librarian I've tried the one in the manual, and it doesn't want to work for me.
21:55 cait I use numbering pattern = none of the above and an advanced pattern for those
21:55 Space_Librarian cait: that's what I was attempting to do
21:55 cait but the problem with advanced patterns is, that the 'test prediction pattern' is broken
21:55 cait so don't look at that
21:55 cait at all
21:56 Space_Librarian right. that's where I'm going wrong then
21:56 Space_Librarian I'm looking at it.
21:56 cait yes
21:56 cait it's very very annoying
21:56 cait not sure we have a bug for that
21:56 Space_Librarian *nods*
21:56 cait but we shoud have one
21:57 cait I think advanced should be
21:57 Space_Librarian so the instructions in the manual is right?
21:57 cait begins with (your year) add 1 once every 1 when more than 9999999
21:57 Space_Librarian cool. done that
21:57 cait for x
21:57 cait and
21:57 cait oh
21:57 cait sorry
21:58 cait x = 1, 12, 9999999, empty, 0, year
21:58 cait now I confused myself, ignoreme
21:59 * Space_Librarian is confused. And would offer cait chocolate, but isn't sure how lent is going...
21:59 cait heh
21:59 cait still trying
21:59 cait ok
21:59 cait slowly
21:59 cait the first number
21:59 cait changes every 12, right?
21:59 cait so
21:59 Space_Librarian yep
22:00 cait add 1 once every 12, when more than when more than 99999, empty, 0, 1 (I think)
22:00 cait then the second goes up every issue by 1
22:01 cait so
22:01 cait 1, 1, 99999, empty, 0, issuenumber
22:01 cait and the last for the first is not one, but your year or whatever
22:01 cait I should test that
22:02 Space_Librarian sweet. :)
22:02 Space_Librarian Thank you!
22:02 cait hope it works :)
22:02 Space_Librarian Should I wait on your test?
22:02 cait yep, wait a second
22:05 cait yep it works
22:07 cait I got the first date wong, should be january
22:07 cait and the prediction pattern preview is wrong, but we already knew that
22:08 cait Space_Librarian: still there? :)
22:11 cait now I scared her away
22:11 cait :(
22:14 Space_Librarian just got a cuppa tea...
22:14 Space_Librarian :)
22:15 Space_Librarian cait++ :)
22:19 BobB joined #koha
22:32 cait night #koha
22:33 cait left #koha

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary