IRC log for #koha, 2006-07-08

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
12:00 cm hey kados--I was just wondering if there's still the incompatibility with mysql 5.
12:01 i'm installing koha (the zebra version from your instructions) on ubuntu and 5 is the default.
12:03 4.1 is in universe though, so I can switch if need be.
12:16 kados yea, I'd stick with 4.1
12:17 at least wtih 4.1 you get the encoding support
12:17 cm okay, thanks.  I'll let you know how it all goes.  :)
12:17 kados cm: http://wiki.koha.org/doku.php?[…]ncodingscratchpad
12:18 cm: that will tell you how to set up your my.cnf for utf8
12:18 cm: some of the standard distros aren't set up currectly
12:18 cm: also, as a normal user, run:
12:18 echo $LANG
12:18 if what you get back isn't 'UTF-8'
12:19 you should reconfigure localse
12:19 locales even
12:19 dpkg-reconfigure locales
12:19 should do the trick
12:20 cm thanks.  LANG is en_US.UTF-8.  
12:21 kados nice
12:21 you're all set then
12:21 just make sure mysql is set up right
12:21 cm yep.  I do like ubuntu.  :)
12:21 kados :-)
12:21 also, make sure you are converting your MARC to utf-8
12:21 from marc-8
12:22 cm how do I do that?
12:23 kados you'll need to use the MARC::* suite
12:23 but before you do so, I'd make sure your SAX parser is set up right
12:23 here's a thread you should read:
12:23 http://www.nntp.perl.org/group/perl.perl4lib/2369
12:23 :-)
12:24 thd cm: bulkmarcimport.pl does it automatically if you have a CVS checkout from rel_2_2 in the past couple of months
12:24 kados yea, but if I were you, I'd preprocess it first
12:25 because if there are any errors, you won't notice them with bulkmarcimport
12:25 cm good to know.
12:25 kados you can think of the scripts in Koha as examples
12:25 thd cm: kados Is right. I should commit some preprocessing scripts soon
12:26 kados they really need to be customized for each migration
12:26 thd kados: yes but there should be at least one generic script for modification
12:26 kados: as an example
12:27 kados roundtrip.pl is a fairly good example
12:27 thd kados: what directory is that in
12:27 kados it's not committed
12:27 it's in the /public/ dir on liblime.com
12:28 though it needs updating I see
12:28 doesn't check leader lenght
12:29 cm thanks guys for the pointers.  got to get back to it now.
12:30 thd kados: what protocol is used for the liblime public directory?
12:37 kados: listing the liblime public directory contents is forbidden
12:37 kados: that would be semi-public
12:48 kados: are you still there?
13:28 kados: are you there?
13:30 kados: if not I will try to find you again later :)
13:31 kados thd: I'm here
13:33 thd /msg kados kados: records need to be able to come out of Koha losslessly for me to be able to market it in good faith
13:35 kados: are you still here?
13:42 kados yes
13:43 in 2.4, records are stored in their entirity in one sql field
13:43 so that shouldn't be a problem
13:57 thd kados: does the record blob change as it is edited or is it only filled on initial import.
13:59 kados: I mean the record blob stored in an SQL database.
14:08 kados it is changed as it is edited
16:49 MrDys so...I'd like to start helping with this project
16:50 who do I talk to about that?
16:51 kados MrDys: what's the project?
16:52 MrDys ...koha
16:53 kados MrDys: really?
16:53 dewey really are quite different
16:53 kados MrDys: :-)
16:53 MrDys: so how can we help?
16:53 MrDys more like...how can I help?
16:53 kados ahh
16:54 there's lots to do :-)
16:54 in what way would you like to help?
16:54 MrDys well...here's my story
16:55 I'm currently in library school
16:55 kados excellent
16:55 we need more librarians involved in the tech side of things
16:55 MrDys my undergrad degree was in IT with a focus on web applications development/usability
16:55 and library school just isn't tickling that itch right now
16:55 kados :-)
16:55 I run liblime.com
16:56 send me a resume: jmf AT liblime DOT com
16:56 MrDys so I'd like to kinda work on this as a way to meld the two worlds
16:56 kados seriously :-)
16:56 MrDys ...if  you say so
16:57 kados we've got a few positions opening up
16:57 and always looking for programmers with a library background :-)
16:58 so ... back to how you can help
16:58 usability testing would be one way
16:58 chris bug fixing is another
16:58 kados yep
17:00 MrDys alrighty
17:03 I'm working on setting up a local installation
17:04 mason i could always do with some help on my personal project...
17:04 porting koha to run on Vbasic and access
17:04 MrDys yow
17:04 dewey And furthermore, my bowling average is unimpeachable!!!
17:04 mason lol L)
17:05 chris mrdys: friday morning humour ... its been a long wet week for us nzers :-)
17:05 mason a seriously underrated development framework
17:05 MrDys hehe it's very much thursday afternoon here in vancouver
17:06 mason yow
17:06 dewey Gibble, Gobble, we ACCEPT YOU ...
17:06 chris have you seen http://bugs.koha.org ?
17:06 russ crikey dewey is on form today
17:06 kados hehe
17:10 MrDys got a bugzilla account
17:10 chris cool
17:45 MrDys are any bugs up for grabs or is it just the assignee or what?
19:34 thd MrDys: please fix all the bugs, nevermind to whom they are assigned
19:34 MrDys hehe okay
19:37 thd MrDys: once you are done fixing the bugs, I will report some more bugs, including all the new bugs that your fixes will have introduced :)
19:37 mason_ and dont forget about my Vbasic port!
02:13 ToinS hello world
02:16 Burgundavia hey ToinS
07:21 kados wow, ToinS is really cooking on the commits :-)
07:21 ToinS hehe
07:21 kados ToinS++ :-)
07:21 ToinS yep
07:33 kados ToinS: have you looked at the holiday management feature in HEAD?
07:33 ToinS kados: no
07:33 kados: why ?
07:33 kados just wondering
07:33 ToinS ok
07:39 johnb Kados: Is someone working on holiday management?
07:54 ToinS salut alaurin
07:54 alaurin salut, tu vas bien ??
08:15 kados ToinS: when will paul be back?
08:15 ToinS: I have some additional information about how budget-based acquisitions are buggy in rel_2_2
08:16 ToinS kados: in fact, he is back now... BUT he has no internet connection yet
08:16 kados ahh
08:16 :-)
08:16 ToinS he hopes, he can have one on monday
08:16 but not sure
08:16 kados I have been working with a client to define bugs in 226:
08:16 http://wiki.liblime.com/doku.php?id=koha226bugs
08:17 with descriptions from a non-tech POV
08:17 (I will show the client how to use bugzilla next time :-))
08:22 morning owen
08:22 owen Hi kados
08:23 kados youre in early :-)
08:23 and from NPL by the IP address :-)
08:23 owen In The Plains today, so I'm 9-5.
08:23 kados ahh ... right
09:03 ToinS: is there any way to delete a supplier from the order page in budget based acquisitions?
09:08 ToinS kados: i'm not sure to understand, what is this page ? (order page in bugdet base acqui ???)
09:09 kados ToinS: is hdl around?
09:09 ToinS i don't know...
09:09 kados ToinS: it's this page: /cgi-bin/koha/acqui/order.pl
09:10 ToinS ah ok
09:11 it could be easy to code the function to delete a supplier from here..
09:13 kados ToinS: does that mean that no library using koha now has ever deleted a supplier? :-)
09:15 ToinS hehe.. I don't know... I'm 4 days old on the koha code.... and still now, i've never seen this feature !
09:15 perhaps it's could be great i add this function on Serials.pm
09:17 kados so i've not spent much time looking
09:17 we have one client intereste now
09:18 but there are several things about it that are confusing (like not being able to delete a supplier)
09:18 (and and the basket.pl doesn't contain the details of the basket number, managed by, open on, or invoice number)
09:19 and why when you add a new supplier does it pre-populate the form with the previous supplier's data?
09:19 ToinS still now i'v worked on Suggestions.pm and Serials.pm
09:20 kados right
09:20 ToinS next on acquisitions
09:20 kados cool
09:20 ToinS so, soon i can answer with much precision
09:20 kados ok :-)
09:21 owen: in the default template, adding a new supplier doesn't pre-populate the form with the previous supplier's data
09:21 owen ?
09:22 kados owen: ok ...
09:23 owen: http://koha.smfpl.org/cgi-bin/[…]erid=8&op=display
09:23 owen: I tried creating a new supplier with the default template
09:24 owen: and the details page for the supplier works correctly
09:24 cancel that last sentence
09:25 when you create a new supplier using the NPL templates, the details from a previously created supplier are in the form
09:25 ToinS: I've confirmed that even with default templates, when you create a new vendor, the basket info is not properly filled out
09:27 ahh ...
09:27 but when you create an 'order line' the 'open on' and 'for' are populated
09:36 hmmm
09:37 well I can add to an order
09:37 and it shows up in the opac
09:37 so that's good
09:39 owen: there are some js bugs on the newbiblio.pl screen as well
09:39 f.elements[currency] has no properties
09:40 owen It would be great if you could go ahead and file bugs as you see them. That would help me keep track.
09:40 kados part of the problem is I'm not sure they are bugs :-)
09:41 it could be operator error :-)
09:41 owen Well, a js error isn't operator error!
09:42 kados true :-)
10:00 owen I committed a fix, kados
10:03 kados thx
10:04 owen: what's the fix for>
10:04 owen both issues you just mentioned
10:05 the js bug and the new supplier thing
10:05 kados ahh, cool
10:05 you're fast :-)
10:05 so from the top
10:06 I add a new supplier
10:07 any idea what the 'publishers and imprints' option is about?
10:07 also, if GST is set to 0, it shouldn't show up in the list IMO
10:07 since in the US, there's no such thing as GST
10:07 (I think)
10:08 2. I add an order
10:08 a. from existing record
10:08 owen Publishers and Imprints: I think that means what different publisher names fall under the heading of that supplier
10:09 kados what is the invoice number for?
10:09 when adding an order
10:10 (BTW: still getting the js errors in NPL templates)
10:10 owen same page?
10:10 kados yea
10:12 owen The same "showPanel" error?
10:12 (in the Javascript console)
10:12 kados I put in quantity '1'
10:12 and hit tab
10:12 and I get:
10:12 Error: f.elements[currency] has no properties
10:12 Source File: http://koha.smfpl.org/cgi-bin/[…]no=&biblio=106226
10:12 Line: 147
10:12 owen Oh, sorry, I missed that one.
10:13 kados then, I type 12.00 in 'supplier's list price'
10:13 and tab and I get:
10:13 same message
10:17 owen Does that work in the default template?
10:18 :) Nope.
10:19 kados seems to be the same in both
10:23 I guess I dont' understand why you'd have a 'actual cost' listed when you are entering in a new item
10:23 as well as an 'invoice number'
10:23 wouldn't those be entered in when you recieved the item?
10:23 and invoice number seems to be marked mandatory with a *
10:23 but where are those invoice numbers supposed to be coming from?
10:24 owen No idea.
10:24 kados and when I enter one it
10:24 it doesn't show up on the basket details
10:24 and comes out as an 'order number'
10:24 http://koha.smfpl.org/cgi-bin/[…]asket.pl?basket=6
10:24 (I entered in '12' as the invoice number when I created that line in the order
10:25 the math seems to be working :-)
10:26 and how to do you add budgets and bookfunds?
10:26 this acquisitions system could use a bit of loving in terms of navigation links
10:26 owen In system prefs
10:26 kados ahh book funds
10:27 so there are several book funds defined, why aren't they showing up?
10:27 weird
10:27 owen I'm not going to try to puzzle out this javascript. I'll let someone who knows how it should work tackle it.
10:28 kados sure
10:28 hopefully that's paul :-)
10:29 http://koha.smfpl.org/cgi-bin/[…]admin/aqbudget.pl
10:29 there are two lines for branch
10:29 and neither one of them has a dropdown
10:29 is that a bug?
10:30 ok, creating a new budget with correct date ranges seems to work
10:31 owen Hm.... the default template doesn't even have the branch fields
10:31 kados maybe just delete them then?
10:33 owen: the 'receive' link here: http://koha.smfpl.org/cgi-bin/koha/acqui/order.pl
10:34 doesn't seem to be loading the recieve page correctly
10:34 try clicking on the one next to 'Josh's Book Supplies'
10:34 it loads a different supplier
10:34 and clicking on 'manage orders'
10:35 doesn't pull up any orders :-)
10:35 ahh ... probably due to the '
10:35 that's a bug :-)
10:36 the 'created by' feature doesn't seem to do anything
10:36 in the help file it says there is a place to enter in a name
10:36 but I've never seen that
10:36 it seems like it would be a nice feature
10:39 part of the problem is that their seem to be so many different names for things
10:39 it's very confusing
10:39 so is an order equivilent to a basket/
10:40 ahh
10:40 so you have an order
10:41 and you can add items to the order
10:41 seems like order and basket are the same
10:41 why have two names?
10:42 so seems like we can add to orders via suggestions, records, or create new minimal records for them
10:43 and all three ways koha creates new records that can be reserved from the OPAC
10:43 creating a new budget works
10:43 so now how abotu receiving
10:44 right ... this is the bug where it won't pull up the right supplier
10:49 owen The 'receive' link is corrected now in CVS
10:50 someone had changed 'id' to 'supplierid' at some point and I missed it.
10:50 kados cool
10:50 it's busted in default too
10:52 ok, working in NPL
10:52 but ...
10:52 I'm not sure what to do with the page once it loads
10:53 it wants 'parcel code', GST, and Freight
10:53 right
10:53 so entered in some random data
10:54 http://koha.smfpl.org/cgi-bin/[…]6&gst=1&freight=3
10:54 0 bibliographic records received
10:54 also, invoice, received by, date are not filled at the top of the page
10:55 and the 'pending orders' section is confusing since I think that was the order I just received :-)
10:55 owen Same in the default template
10:55 kados yea, it didn't update the status of the order
10:56 I don't see how any library could
10:56 it plainly doesn't work
10:56 so Koha does not have acquisitions
10:57 and we should be saying it does :-)
10:57 s/should/shouldn't/
10:57 sigh
10:58 ToinS: do you know if any of paul's libraries use budget-based acquisitions?
10:58 interesting
10:58 I'm getting some errors in the logs:
10:58 [Fri Jul 07 05:43:48 2006] [error] [client 70.106.243.12] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /home/koha/intranet/modules/C4/Acquisition.pm line 1188., referer: http://koha.smfpl.org/cgi-bin/koha/acqui/order.pl
10:58 [Fri Jul 07 05:47:19 2006] [error] [client 70.106.243.12] DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and datereceived is not null group by aqorders.booksellerinvoice at /home/koha/intranet/modules/C4/Acquisition.pm line 1186., referer: http://koha.smfpl.org/cgi-bin/koha/acqui/order.pl
10:58 [Fri Jul 07 05:47:19 2006] [error] [client 70.106.243.12] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /home/koha/intranet/modules/C4/Acquisition.pm line 1188., referer: http://koha.smfpl.org/cgi-bin/koha/acqui/order.pl
10:59 no errors when receiving an order though
11:07 ok ... well no sense in proceeding on acquisitions until we hear back from palu
11:07 paul even
11:07 I think
11:07 owen: got some time to talk about item statuses?
11:07 owen: I know NPL has some requests with regards to that
11:11 owen Yes
11:15 kados owen: so can you encapsulate the needs? :-)
11:15 owen Alright, give me a sec to think on it
11:15 Okay, take the inventory situation, for example
11:16 That's a situation where we'd like to be able to have a new status, something beyond Lost and Cancelled.
11:16 kados right
11:16 so 'on order'
11:16 for instance
11:16 also, probably want one for 'damaged'
11:16 right?
11:17 owen Yes. It would be nice to be able to set up custom statuses and say, for instance, whether items with that status should appear in the OPAC.
11:17 kados gotcha
11:17 now ... I _think_ koha claims to be able to do this in the rel_2_2 branch
11:17 the question is, does it work :-)
11:17 owen With itemcallnumber?
11:17 kados no
11:18 in the framework
11:18 you map 'notforloan'
11:18 to an authorized value
11:18 and in the authorized value
11:18 you specify all the status codes (numeric) and descriptions (text)
11:19 and statuses > 0 can't be seen in the OPAC
11:19 at least that's the advertised functionality
11:19 as I understand it
11:19 so we should do some tests
11:19 to see if it works
11:19 fix it if it doesn
11:19 t
11:19 and make it simpler to change the statuses
11:20 SMFPL has the same requirements
11:20 and they're sponsoring the work :-)
11:20 so I've got time to spend on this
11:20 yay
11:24 owen if it does work, then the issue is how to easily change statuses without editing the records
11:24 kados right
11:24 should be simple enough
11:24 could add a drop-down box to moredetail.pl
11:25 owen: how does your 'make lost' work?
11:25 owen: the button ...
11:25 owen: does it set the hardcoded status field in Koha's items table?
11:28 owen Yes
11:30 kados owen: don't you want newly ordered items to show up in the catalog?
11:33 ahh ... you want the biblios to show up
11:33 not the items though
11:33 until they arrive
11:33 right?
11:36 owen: http://opac.smfpl.org/cgi-bin/[…]ail.pl?bib=132080
11:36 owen: changed the status, at least it shows up in the OPAC
11:36 (the status I mean)
11:36 owen: and you can't reserve it
11:36 owen: so I think it's working
11:39 owen: the hidelostitems syspref isn't working
11:39 owen: but the status changing is
11:39 owen: so it's just a template job
11:39 owen: I propose we create a new syspref
11:39 owen: called 'OpacHidenotforloan'
11:40 owen: because I think 'hidelostitems' is for legitimately lost items
11:40 owen: make sense to you?
11:41 hehe
11:41 nope, it doesn't work
11:43 owen But what does 'not for loan' cover?
11:44 kados well ...
11:44 you've got up to 9 values that mean
11:44 'can't make a reserve and can't issue'
11:44 and 9 values that don't do anything
11:44 the negitive numbers
11:44 hmmm
11:44 cancel that
11:45 as currently programmed, they all weill set it to 'can't make reserve and can't issue'
11:45 so I've got authoried values set up for:
11:45 1 => damaged
11:45 2 => on order
11:45 guess the on order bit isn't really quite right
11:46 as you wouldn't be adding an item
11:46 anyway
11:46 but I think damaged will work the way we want
11:47 what statuses does NPL need and what should they do?
11:47 damaged => don't show up in OPAC, can't reserve, can't issue
11:47 what else?
11:54 owen What about in-transit?
11:55 kados good one
11:55 while we're on the topic
11:55 do you understand how HLT does in transit and transfers?
11:55 is that opening a can of worms?
11:55 :-)
11:56 owen I don't know
11:57 How do they do it?
11:59 kados dunno
11:59 :-)
11:59 owen I don't think they /do/ handle in transit. I think that's the problem

← Previous day | Today | Next day → | Search | Index

koha1