IRC log for #koha, 2009-05-28

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

All times shown according to UTC.

Time Nick Message
12:16 kf hi, is it possible to generate a link to a koha-record in opac using field 001?
12:16 i tried sn, but cant get it to work
12:16 gmcharlt kf: yes, if you've indexed the 001, you can generate a permalink using that index name
12:16 depends on your Zebra config
12:17 kf where to look at?
12:17 searching in zebra files, but im a little confused
12:17 gmcharlt first, look at the record.abs for your MARC format to see if the 001 is indexed at all
12:18 there would be a melm 001 IndexName line
12:18 then look at bib1.att and ccl.properties to see if that index is mapped to a search index qualifier
12:19 kf ok, I have a printed version of that here, but I will check the file directl
12:19 gmcharlt have you made any changes to your Zebra config?  if not, if you tell me whether you're using MARC21 or UNIMARC, I can look it up for you
12:19 kf y
12:19 MARC21 - but I know we did some changes, or a colleague did, who is now on vacation
12:21 ok, there is melm 001 Control-number - differnt from my print out
12:22 gmcharlt ok, so now look for Control-number in the biblios bib1.att
12:23 kf att 9001    Control-number
12:23 gmcharlt ok, so now we know that it's properly indexed
12:23 kf yay :)
12:23 gmcharlt so now check ccl.properties for Control-number and/or 9001
12:24 kf Control-number 1=9001
12:24 gmcharlt ok, so that means that using Control-number as the full index name in your permalink should work
12:25 kf case-sensitive?
12:25 gmcharlt I don't think so
12:27 if you want a short index name, you can add a 'cn Control-number' line to ccl.properties
12:27 kf http://hfjst.bsz-bw.de/cgi-bin[…]-number:208862560 <wrong
12:28 hdl_laptop kf
12:28 kf hi hdl
12:28 hdl_laptop Control-number should be declared in ccl
12:28 kf it is, I checked with Galen
12:28 hdl_laptop for you to use it in query
12:37 kf had to reboot :(
12:37 gmcharlt was wondering :)
12:38 kf software update, wanted to click no, clicked yes ... now all windows and documents got closed
12:41 gmcharlt: do I have to reindex after changing ccl.properties?
12:41 gmcharlt kf: no
12:41 ccl.properties only maps from the CCL codes used by Koha's C4::Search to the Z39.50 attributes
12:42 you don't even need to restart zebrasrv
12:42 one thing to check
12:42 kf great, thx!
12:42 gmcharlt if you resave your 208862560 record and index it
12:42 and it turns out that the URL works
12:42 kf ok, will try
12:42 gmcharlt that means that a reindexing wasn't done after the melm 001 Control-Number index was added
12:43 in which case, you would have to reindex
12:43 kf oh, is it possible to translate xsl-files for detail and results? I tried, but it seems its only using en/xslt
12:44 gmcharlt kf: not a present
12:44 there's a simple fix (letting it look for XSLT outside of the en tempalte directory)
12:44 kf ok, perhaps I should file an enhancement-bug for this :)
12:44 gmcharlt yes
12:45 but the other thing is that you currently have to translate the XSLT yourself
12:45 it's not handled by Pootle at translate.koha.org
12:45 kf thats ok, but I noticed that the xslt-files are in DE-de
12:46 but my changes were not visible - so I tried en and it worked
12:46 gmcharlt right - just not used, but as I said, that part is the simple thing to fix
12:58 kf added cn Control-number and link works now - thx again!
13:00 gmcharlt you're welcome
13:32 pianohacker Good morning
13:56 nahuel pianohacker, hi jesse !
13:56 pianohacker, what's up ?
13:57 pianohacker Not much, busy working on Koha
13:57 Yourself?
14:04 nahuel the same :)
14:04 pianohacker Anything exciting?
14:04 nahuel this ... stuff of holding by public/branch/itype
14:05 pianohacker Oh, yes
14:05 nahuel toooooo "hard" stuff
14:05 it's breaking my head
14:05 pianohacker Rules often seem so simple in theory and so frustrating to implement
14:05 I feel your pain
14:05 nahuel hehe
14:06 :'(
14:06 but well, i'll complete this task! I'm sure i will !
14:53 jwagner gmcharlt or anyone -- Does someone know if there has been a change in the way Koha deals with cancelled holds?  I had a SQL query working that checked the old_reserves table for expired or cancelled holds.  Both were showing up in that table.  In latest Koha (give or take an .03x level), cancelled holds don't seem to be written to that table.  I am dumping out the entire table contents, and there is no change before and after I cancelled a couple of hold
14:53 gmcharlt jwagner: no intentional one - they should be going to old_reserves
14:55 jwagner Hmmm.  They aren't going there on my test system.  Wonder what could be blocking them.  I'm running a straight koha.org install.
14:56 gmcharlt what path are you using to cancel the requests?
14:57 jwagner In staff mode, go to the patron record, look at the holds tab, set the pulldown in the Delete column to Yes, click Cancel Marked Requests.
14:58 Just logged into the OPAC & cancelled one there too.  Neither show up in old_reserves.  Any sysprefs that could be a factor?
15:02 It's gotta be something unique to this system, I think.  I'm testing the same SQL on another server that's at the same level (3.01.00.032), and a cancelled hold shows up fine in the old_reserves table.  A puzzlement.....
15:04 gmcharlt yeah, I'm not seeing any syspref that would be overriding it
15:05 if the database in question is (supposed to be) completely up to date
15:05 a git diff origin/master will tell you if there are in fact any differences in the code
15:06 jwagner Running under git checkout master doesn't show anything with the diff.  There are a lot of code branches on this server, and some table changes, but I can't see that any of them would be a factor here.
15:06 Gonna try it on another development server, I think.
15:07 gmcharlt table changes could do it if there's a column in reserves that's not in that DB's old_reserves table
15:07 and would be evident in the Apache error log for that DB
15:07 jwagner AHA.  I think we've made a reserves table change.  We'll investigate that, thanks.
15:13 wizzyrea_away jwagner: we got the same report this morning
15:13 that it wasn't telling the staff member where to transfer the item to after cancelling a hold
15:13 jwagner On expired holds?
15:14 wizzyrea_away yea
15:14 jwagner Have you done any table changes?  I'm strongly suspecting that in our case, because there are some reserves changes.
15:14 wizzyrea_away no maam
15:14 jwagner Harrumph.  Why can't there EVER be one simple explanation!
15:14 wizzyrea *shrug* :)
15:17 I'm missing it in the docs: is there an AND type operator in jquery? like, I want #div AND tr
15:17 sorry to be such a nub >.<
15:18 pianohacker How do you mean? If you want to find a tr with a given id, you can just do tr#id
15:18 Although, since ids have to be unique, #id is usually enough
15:18 wizzyrea this table has a div, but no table ID
15:19 or maybe I'm misunderstanding
15:19 pianohacker $("#id tr") ?
15:22 wizzyrea this is what I'm trying to do:
15:22 $("#patron-messaging-prefs tr:contains('Upcoming Events')").css("border","3px solid red");
15:22 or somesuch
15:24 but this only selects the entire div
15:24 i want the row containing upcoming events selected so I can squash it
15:24 (since it doesn't work)
15:24 pianohacker Try $("#patron-messaging-prefs td:contains('Upcoming Events')").parent()
15:25 I think :contains() only finds text contained within that element, not any of its children
15:25 wizzyrea AH
15:25 ...trying
15:27 pianohacker You might also try th if td doesn't work. Not familiar enough with the HTML of that page to tell you which it is
15:28 wizzyrea right. it's gotta be something parent/child-y
15:28 that's keeping me from my goal
15:28 thanks for the tip
15:28 pianohacker No problem, good luck
15:28 wizzyrea thanks ^.^
15:45 hdl_laptop gmcharlt: question about issues and foreign keys.
15:45 gmcharlt hdl_laptop: go ahead
15:45 hdl_laptop can you account for the fact that ON borrower UPDATE and item update issue row is set to NULL ?
15:46 gmcharlt that's wrong
15:46 although on borrower update (i.e., changing the ID of an existing borrowernumber) shouldn't happen often
15:46 likewise for on item update
15:47 hdl_laptop So should be considered as a bug.
15:47 gmcharlt but ON UPDATE CASCADE would be better for both of those
15:47 I'd say so
16:12 wizzyrea plenty of mentions of koha on twitter these days
17:15 gmcharlt hdl_laptop, nahuel, nicomo: any you around to translate sysprefs
17:15 viewISBD - Allow display of ISBD view of bibiographic records
17:15 nahuel gmcharlt, i'm here for 2mn and go home
17:16 gmcharlt viewLabeledMARC Allow display of labeled MARC view of bibiographic records
17:16 viewMARC - Allow display of MARC view of bibiographic records
17:16 are the three
17:16 nahuel "Autoriser l'affichage de la vue ISBD des notices bibliographiques"
17:16 gmcharlt any accent characters in that?
17:16 if so, better use pastebin
17:16 nahuel no accent for the first then the 2nd :
17:17 "Autoriser la vue MARC des notices bibliographiques"
17:17 and the 3rd
17:17 hmmm
17:17 i'm wrong
17:17 the 2nd:
17:17 arg
17:17 2s :)
17:17 gmcharlt :)
17:18 nahuel viewISBD - "Autoriser l'affichage de la vue ISBD des notices bibliographiques"
17:19 viewLabeledMARC "Autoriser l'affichage MARC labellisé des notices bibliographiques"
17:19 viewMARC - "Autoriser l'affichage de la vue MARC des notices bibliographiques"
17:19 now i'm right :)
17:19 gmcharlt nahuel: thanks!
17:19 nahuel well have a good day in usa :)
17:19 and others countries :)
17:19 -s
17:19 :)
17:19 gmcharlt you too
17:20 nahuel hehe i'm going to sleep, too tired :)
17:20 see you tomorrow
17:58 Sharon Hello
17:59 pianohacker hi
17:59 Sharon I have words of praise and thanksgiving to share from the staff at one of our libraries...they are thrilled with how the label maker now works and are happy to see $b, $p and $n of the 245 in OPAC search results.
17:59 kudos, kudos, kudos
18:00 I was told they did a 'happy dance'
18:01 jwagner Happy dances are always fun :-)
18:01 Sharon gmcharlt our LOST functionality magically returned after the updates...that bug can be closed.
18:14 gmcharlt Sharon: thanks
18:14 wizzyrea atz: didn't you fix the labelmaker? apparently it's a huge hit here lol
18:15 atz wizzyrea: partially fix, anyway
18:15 it still can't do diacritics
18:18 pianohacker Are there any plans to change the PDF output module for the label maker? I've had luck outputting diacritics using PDF::API2
18:21 ryan pianohacker: no, but i'd give you a ++ if you took the reigns on it.  
18:21 wizzyrea atz: even with that limitation, it works much better
18:22 ebegin pianohacker, do you have problem to output diacritics with PDF::Reuse?
18:23 pianohacker ebegin: From my investigation, the module does not support it unless you use a difficult-support hack involving custom-loading TTF fonts
18:24 ebegin pianohacker, hold on... I'll check how I solved this :)
18:24 pianohacker ebegin: http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=2246
18:24 ryan: I might get to it by the end of summer; so many coding projects I want/need to do...
18:29 ebegin pianohacker, Ok... I had to normalize the $field->{data} using Unicode::Normalize.  NFD($field->{data}).  Maybe there is a best way to do it.  I guess PDF::Reuse has some trouble with NFC unicode.
18:30 pianohacker Hmm. The error I was getting was far more basic: "Wide character in string"
18:31 If you solved the problem and have a patch for #2246, though, you would make many non-US libraries very happy
18:34 ebegin pianohacker, I'll check that soon ;)
18:34 pianohacker thanks
18:34 atz ebegin: the limitations are you don't get to know what fonts are on the server or the client
18:34 so we aren't embedding anything
18:35 pianohacker: we used to use PDF::API2, but it had ample problems as well
18:35 pianohacker I've noticed a few oddities. What were some you noticed?
18:36 atz not maintaining spacing on the barcodes, for example... makes them useless
18:37 pianohacker That's mildly problematic, for a barcode printer
18:39 atz http://git.koha.org/cgi-bin/gi[…]42798bac4b4401ccb
18:39 example of the old code
18:40 bad design... writes everything to a tempfile first
18:40 pianohacker Yeah. I don't think that's necessary with PDF::API2
18:41 I'll have to investigate the barcode problem
18:41 Were there any other showstoppers?
18:41 atz i remember there were enough widespread issues (format creep, performance) that we were ready to try something else
18:42 but a lot of that could have been that our implementation also sucked
18:42 pianohacker Heh
18:42 PDF support in Perl does seem to be a lesser-of-several-mediocrities problem
18:43 atz yeah, i'm sure there are great commercial executables that you can just throw postscript at and it will make a PDF
18:44 but the CPAN stuff isn't really 100% yet
20:47 chris morning
20:47 pianohacker Good morning
20:47 hdl_laptop hi chris
20:48 Jo Morning
20:48 Sharon Chris we can officially edit reports now - our install was updated last night with the dev weekend patches and improvements...thank you
20:48 Jo I am over whelmed at the very generous and munerous responses I have had to my  plea for a cataloguing coach.
20:49 chris Sharon: awesome :)
20:49 Jo Sharon moreland?
20:49 Sharon yes
20:49 Jo hello Sharon!
20:49 brendan hey Jo Sharon, chris
20:49 Jo Hiya Brendan.
20:49 (Sharo is one of the generous souls ..
20:50 and pianohacker was instrumental in getting another offer to us.
20:50 brendan hey pianohcaker
20:50 pianohacker Hey brendan
20:50 Jo this is the beauty of a warm, supportive, cooperative koha community... I fel a blog post coming on :)
20:50 brendan whoops -- sorry about hacking your name
20:50 chris :)
20:51 pianohacker Hmm. I think I prefer this version, especially as I'm kind of hungry right now
20:52 chris mmm piano cakes
20:58 now im hungry too
20:59 brendan ha -- yup I'm hungry
20:59 Jo well i'm not - its not long after breakfast!
21:00 is the socer over (was 2-nil) when i left home
21:19 Ricardo Hi everyone!  :)
21:20 Sharon Is the 586 Awards field included in the notes/comments search?
21:23 gmcharlt Sharon: not currently
21:24 Sharon it came up in some search training I did - US public libraries have a lot of questions about newbery and caldecott winners
21:25 Ricardo Galen: Hi Galen!  :) Is it possible to "cherry pick" my "INSTALL.opensuse" update/patch to the 3.0.x branch (besides of HEAD where you already placed, thanks for doing that BTW)?
21:25 gmcharlt Ricardo: yes, but that's for hdl to do - I'm sure he'll get to it tomorrow
21:25 Ricardo gmcharlt: Oh, OK. Thanks for the info!
21:32 Back in 10 mins (machine highly unstable)
21:49 OK. I logged off (Windows), logged back in disabled the "Automatic [hard disk] Defragmentation" in Diskeeper 2008. My machine seems to be more stable now
21:49 chris :)
21:49 i can make it more stable :)
21:50 Ricardo chris: Hi Chris!  I know, I know... You'd install Linux or Mac OS X, right?  ;-)
21:50 chris Linux ... no point replacing something proprietary with something else proprietary ;)
21:51 Ricardo chris: Well, that depends on what's your goal... but OK, I understand you  :)
21:52 chris: Still regarding translations... Should the .tmpl files also be submitted through git?
21:53 chris nope
21:53 we only store the english ones
21:53 because we can create the others ones from them + the .po file
21:54 Ricardo chris: Right. I thought so, but wasn't sure. Cool!  :)
22:30 pianohacker Time to get off, have been staring at the same line of code for way too long
22:30 bye, all
22:40 Ricardo I really, Really, REALLY *hate* editing the "INSERT INTO"  SQL statement for the NoZebraIndexes system preference  :(
22:40 chris oh?
22:41 Ricardo Let me try to show you
22:42 chris: http://pastebin.com/m777dc120
22:43 chris ah yeah not fun
22:43 Ricardo Right!
22:43 chris http://koha.pastebin.com/  <-- for future ref
22:43 Ricardo chris: Nice! Thanks for the info  :)
22:44 I know, I'll copy the French one:
22:44 chris good plan
22:45 Ricardo http://koha.pastebin.com/m5826a159
22:45 Much nicer output/layout  :)
22:45 chris sure is
22:45 Ricardo Eheh
22:55 chris: I see that "authorised_values_\[COUNTRY\].csv.sql" (in the ru-RU and uk-UA translations) use LAST_INSERT_ID() function + some number... Is this safe /recommended?
22:56 chris hmm how does the english one do it?
22:57 Ricardo Can't find it for English  :(
22:58 chris it feels dangerous to me
22:58 i wonder if gmcharlt is around?
22:58 Ricardo Right. It looks dangerous to me too
22:58 I think I found it:
22:58 File: blib/INTRANET_CGI_DIR/installer/​data/mysql/en/optional/auth_val.sql
22:58 INSERT INTO `authorised_values` (category, authorised_value, lib) VALUES ('LOST','0','');
22:59 No IDs... I like that better !  :)
22:59 chris yeah
23:00 Ricardo The French hardcode IDs (I like that EVEN less):
23:00 chris hehe yeah
23:00 Ricardo INSERT INTO `authorised_values` (`id`, `category`, `authorised_value`, `lib`) VALUES (457, 'qualif', '650', ' Editeur');
23:00 chris yeah thats even more dangerous
23:00 Ricardo Right. At least, that's also my opinion
23:01 chris well it assumes to much to be safe really
23:01 ill have a chat with paul and hdl if i see them tonight (nz time)
23:01 Ricardo OK  :)
23:03 Actually, I think this localization should take a major change, regarding SQL files (to avoid much copy+paste+doing similar things/inserts in slightly different ways in several languages)... but that would require a pretty big change to the data model. And that's NOT nice NOR easy  :(
23:05 The PO/Pootle part, on the other hand, works pretty well IMHO  :)
23:13 (there's a deafening silence here, now  ;-)
23:44 chris heh
23:45 was at meetings
23:45 yeah we need to work out a way to make .po files from the sql
23:46 Ricardo Yeah... Maybe add a "language_id" column to some of the tables. That will be a BIG headache first, but better later, I think
23:47 Speaking of which, I think I detected several mistakes, regarding Country Codes in the authorised_values.sql file of the French. I'm wondering if it's good etiquette to submit that in git  :-S
23:48 chris you should talk to jesse (pianohacker)
23:48 he has done some stuff to make the systempreferences translatable
23:49 Ricardo: yep, do it as a separate patch
23:49 Ricardo OK (to both. Thanks!  :)
23:49 chris that way if its not accepted it doesnt block your other stuff
23:49 if that makes sense
23:49 Ricardo Kinda...
23:50 chris (you dont wnat your translation patch depending on the fixes to the french one, or mixed in with it)
23:50 because then if for some reason they say "oh but we need it like that"
23:50 Ricardo The "smallest" problem they have is that they use 2 letter lowercase country codes (I think country codes, according to ISO 3166, should be UPPERCASE). The Russian do it as UPPERCASE
23:50 Oh yeah... agreed
23:51 Not sure how I split that in git, though...
23:51 chris just do them as 2 commits
23:51 Ricardo Do a commit first ?
23:51 right
23:51 chris *nod*
23:51 Ricardo Again: I think git is very powerful, but lacks a bit in the "User friendliness" section
23:52 chris *nod*
23:52 its getting better though
23:52 rapidly
23:52 so thats good
23:52 Ricardo Yep!  :)
23:53 Do you use some kind of Graphical Interface for git or do you use it like me  (command line only)?
23:53 chris i use gitk sometimes
23:53 but mostly commandline
23:54 Ricardo OK.Thanks for the info
23:54 chris for fun sometime, just change into your koha git repo
23:54 and type gitk
00:00 Ricardo Application initialization failed: no display name and no $DISPLAY environment variable
00:00 Error in startup script: invalid command name "image"
00:00    while executing
00:00 "image create bitmap tri-rt -background black -foreground blue -data {
00:00    #define tri-rt_width 13
00:00    #define tri-rt_height 13
00:00    static unsigned cha..."
00:00    (file "/usr/bin/gitk" line 2696)
00:00 Sorry, eheh
00:00 That's what happens when you have a Virtual Machine WITHOUT XWindows  :)
00:01 chris :)
00:01 yep
00:02 Ricardo Is the order of the INSERT INTO `authorised_values` ... lines relevant for something (e.g: for display in a list)?
00:22 Hello?
00:31 Back in 30 mins, I think... See ya!  :)
01:17 Time to go to bed. Take care everyone. Chris: Thanks again for the tips / help!  :)
03:26 Amit hi brendan, chris, mason
03:26 morning #koha
03:27 mason morning amit
03:27 long time no chat
04:24 brendan hey amit
04:25 Amit heya brendan
04:25 Jo hey Amit
04:25 Amit heya Jo
06:41 chris evening
06:51 paul_p hello chris
07:25 Elwell chris: the /. story on MS/NZ -- (http://news.slashdot.org/artic[…]=09/05/26/0155209 ) will that actually open up the door to more Open Source stuff or in reality just mean each dept buys their own MS licences?
07:27 chris well its a big opportunity
07:27 one that hasnt been available before
07:28 whether much comes of it or not, is to be seen, but at least it is possible to actually consider other than MS
07:28 Elwell cool. Good Luck :-)
07:29 chris and give the Electoral commission, and the electoral role all run on OS, and the Ministry of Justice use plone .. there are some feet in the door already
07:31 roll even :)
08:27 hi jo
08:48 wxcv anyone know how to "emulate" a user session in koha from perl?
08:50 chris you could use mechanize, to fake a cookie
08:52 well www::mechanize + http::cookies
08:56 wxcv yeah, i guess.
08:56 i was wondering wether there was something easier, like set_userenv :)
08:56 but doesn't look like that's the way to go
08:57 chris yeah, i think you need to fake a cookie
09:03 wxcv thanks, i'll try without doing that, but i have a feeling you're right.
11:44 gmcharlt good morning
11:51 jwagner Morning!

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

koha1