IRC log for #koha, 2006-04-12

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

All times shown according to UTC.

Time Nick Message
12:01 tim yeah.  That's fine.
12:01 Thanks!
12:02 kados np
12:05 T-MINUS 2 HOURS TO KOHA MEETING
13:06 owen tim: I just committed a fix for your deletions problem
13:15 tim That was quick owen
13:15 owen It was a silly template error on my part, easily fixed.
13:16 tim Some day I hope to be able to make (and fix) silly template errors.
13:35 kados tim: I've updated your install with the new changes
13:41 T-MINUS 25 MINUTES TO KOHA MEETING
13:54 tim Thanks kados and owen
14:01 kados well by my clock it's 19:00 GMT ...
14:01 anyone around for the meeting?
14:02 hey pierrick
14:02 looks like it's just you and me :-)
14:02 pierrick rally?
14:02 really?
14:03 kados so far yes :-)
14:03 pierrick what time is it in Ohio?
14:03 kados 3:00 pm
14:03 pierrick 9:04 pm in France
14:03 (strange offset ;-)
14:05 kados :-)
14:06 pierrick I've worked with hdl today, interesting working session
14:06 kados what did you work on?
14:06 pierrick we worked separately, but we had discussion about how Koha works (the application, the project)
14:07 kados ahh, cool
14:07 any conclusions? :-)
14:08 pierrick I was wondering whether each Koha supplier (Paul, Liblime, slef, Katipo) had a local version manager to work on customer specific branches
14:08 Paul and hdl don't
14:08 I think I'll do it for INEO
14:08 kados imo all customer-specific code should be managed in sysprefs
14:08 pierrick we spoke about localization, template status for 3.0 and so on
14:09 kados otherwise the koha project looses local customization
14:09 pierrick kados: you're right, but IMO adding a feature on a stable branch is dangerous
14:09 kados why?
14:09 pierrick you never know how many bugs your new feature is bringing
14:10 kados and that's where QA comes in :-)
14:10 pierrick anyway, this is the release manager role to give rules about that :-)
14:10 :-)
14:10 kados I suspect we are approaching Koha development quite differently than other software projects
14:10 of course, RM makes the rules about that
14:11 pierrick kados: how does Koha differs from other opensource projects?
14:11 kados I've found that it's a nightmare to try to maintain multiple client installations using a non-stock CVS
14:11 well, we don't have very many users/developers compared to the size/complexity of the code bases for one
14:12 pierrick (maybe we should think about the tool we use)
14:12 CVS was not designed to manage branches
14:12 kados right
14:12 pierrick so evidently, working on many branches is not a good idea, we should only have a few branches (dev/stable)
14:13 kados I think two branches is best
14:13 three at the most
14:13 pierrick maybe we'll think about that when we move to Subversion :-)
14:13 kados moving to subversion would require retraining all koha developers and some koha users
14:14 so while I agree in theory
14:14 i think it might be tough to pull off successfully
14:14 pierrick kados: moving to Subversion is a really easy task I can assure you
14:14 kados cool
14:14 pierrick Subversion was designed to replace CVS and to be compliant in the way it works
14:14 kados the other worry I have is that if we use subversion folks will have less incentive for contribbuting their changes back
14:15 pierrick why???
14:15 kados 1. because they will not be familiar with sv
14:15 2. because they will not know now to create their own sv 'branch'
14:15 3. because even if they do, it will be hard for the RM to keep track of all changes and have an 'authoritative' branch
14:16 but maybe I don't understand well how it works
14:16 pierrick kados, I think you should not worry so much :-)
14:17 kados hehe
14:17 pierrick kados: do we say the meeting is adjourned?
14:17 kados pierrick: almost
14:17 pierrick: in your opinion, is the new wiki ready?
14:18 pierrick: if so I will announce it on koha-devel
14:18 pierrick: also, do you think we have time for a bug squash mtg before paul releases 2.4?
14:18 pierrick IMO remaining migration issues need manual work
14:18 kados pierrick: IMO we should have one because surely 2.4 has bugs
14:19 pierrick bug squashing next week for example?
14:19 kados that's good for me
14:19 pierrick: final question
14:19 pierrick Paul have to say, I'll organize the party, but I need Paul to say
14:20 kados pierrick: I need instructions for UNICODE
14:20 no, you can organize the party without paul's approval
14:20 you are the QA Manager now :-)
14:20 pierrick kados, OK, I'll give a date for the BSP as soon as possible
14:21 kados great!
14:21 pierrick so Unicode?
14:21 kados yes
14:21 I would like to confirm that head is 100% unicode safe
14:22 pierrick I can tell you about MySQL communication, but not about zebra
14:22 kados sure, I already know zebra :-)
14:22 pierrick IMO, UTF8 is working fine on HEAD
14:23 kados did you alter your db schema or any code to get it working?
14:23 pierrick My tests are successful, I didn't work anymore on this subject
14:23 I did
14:23 kados ok
14:23 pierrick my code modification was commited
14:23 kados can you commit your changes?
14:23 ahh, great
14:24 ok, so meeting adjourned then :-)
14:24 have a good evening
14:24 I'll read you tomorrow :-)
14:24 pierrick my database modification was not commited, I made the conversion manually, but today I saw hdl had commited the conversion to UTF8 in updatedatabase
14:24 kados unless you have anything more to add
14:24 ahh ... is hdl's commit the same as your db modif?
14:25 pierrick yep, if you have time to tell me about the new stopwords management page I wrote, it would be great :-)
14:25 kados ok, I'll try to look at it today
14:25 pierrick kados: I need a check about hdl commit
14:26 owen pierrick: how is the number of items per page controlled with the new pagination function?
14:26 pierrick each page has its own $pagesize
14:27 owen Ah, I see it.
14:27 pierrick having a common $pagesize wouldn't be a good idea
14:27 IMO
14:27 owen I agree
14:27 pierrick listing stopwords and budgets is not the same thing
14:28 owen: your opinion about the pagination bar?
14:29 owen Is in use somewhere else now too?
14:29 besides stopwords and budgets?
14:29 pierrick yep, itemtypes, stopwords, authorities
14:29 owen that's right, itemtypes
14:29 pierrick (budgets not commited yet)
14:32 owen itemtypes is only displaying 5 items at a time
14:32 pierrick owen, when will the "beautiful" template work start for 3.0? is this action planned?
14:32 owen: yes, I commited an extreme test value :-(
14:33 owen I'm not really sure. The last time we had an in-depth discussion of new templates for 3.0, I thought Katipo had agreed to work on a new design
14:34 I was to help code it. But I haven't heard anything about that since then.
14:35 pierrick OK, because in the current state, we can't show the prog template to any customer
14:35 (IMO)
14:35 owen about the pagination bar: I worry each time I see HTML generated by a script, because as a template designer I see that as a limitation.
14:35 However, the HTML generated by the pagination script is very clean
14:35 pierrick owen: I understand, but what a simplification !
14:35 owen: thank you
14:35 I've tried to have semanticaly correct CSS classes
14:36 I'm sure we'll produce beautiful and useful pagination bar
14:36 always looking the same on every page
14:37 owen, if you have nothing else to ask, I would like to go to bed (feeling very tired today)
14:38 owen I have nothing to add other than "Good night!"
14:38 pierrick thank you, read you tomorrow :-)
15:12 kados owen: noticed your recent commit to opac-authorities...
15:12 owen Everything look okay?
15:13 kados yea, it's just that I had been working on a version too :-)
15:13 and cvs can't resolve the conflicts
15:13 only difference that I can see
15:13 owen All I did was copy over some updates from the css templates
15:13 kados is that mine includes links if there are existing bibs
15:13 I'll just manually add that change
15:13 since it's kinda nice
15:14 also, the dictionary searches don't seem to be working for me
15:14 they return results, but i can't close and insert the values into the search box
15:14 have you had similar probs?
15:26 yea, me too
15:31 owen: so remember you were asking how authorities would change things?
15:31 owen: http://smfplopac.liblime.com
15:31 owen: should give you a basic idea
15:31 owen: for instance, when you pull up the detail page
15:31 owen: the subjects are links to authorities searches if they exist in the auth database
15:32 owen: otherwise they are regular subject searches as per usual
15:32 owen: the same could be done with authors and uniform titles
15:32 owen: really, with any link
15:33 owen So they pay for authority records?
15:33 kados well, in the case of sfmpl, they have _very_ minimal records
15:33 _just_ the headings
15:33 minimal authority records I mean
15:33 because their old dynix system could only save the headings
15:33 and not the full records
15:34 but yes, they did pay for the auth records at some point
15:34 owen Do you have an example of a record which links to an authority subject search?
15:34 kados most of them should
15:34 http://smfplopac.liblime.com/c[…]tail.pl?bib=38273
15:35 is one that does for sure
15:35 owen Does it indicate an authority recrd search if the link shows 'marclist=6509'
15:35 kados yes
15:36 that means 'search tag 650 subfield $9 (the linking field) for the authid=<whatever that id is>
15:36 owen It's too bad the results list says "Results for Search: 6509 = 2576582"
15:36 kados in otherwords, it does a search for every other bib with the same authid
15:36 yea, we could easily fix that
15:36 I'm sure SMFPL will want that changed
15:37 the whole searchdesc var needs to be changed in fact
15:37 it's a poor design IMO
15:38 owen It has never worked well out of the box for us
15:39 kados there's so much we could do
15:39 but so little time
15:40 yea, I'll look at that just as soon as I've finished merging our changes to opac auth display
15:40 owen It works fine in the css templates... the javascript is identical...
15:42 kados huh ... the markup must have changed
15:42 are we still valid xhtml?
15:43 w00t, Tumer just made his first commits
15:43 owen: thanks for walking him through that!
15:44 owen No problem. Is the Wiki open for editing?
15:45 kados the new wiki?
15:45 ahhh ... better wait
15:45 I need to confirm with pierrick that we've got the latest snapshot
15:46 but you could email your stuff to Stephen, that'd be a useful kohadocs addition
15:48 chris morning
15:48 owen Okay, I'll do that too after I get a chance to clean it up
15:48 Hi chris
15:49 kados morning chris
15:49 chris: Tumer did his first commit today :-)
15:51 chris woo hoo
15:51 kados owen: so the error I'm getting is 'opener.document.f.value has no properties'
15:53 owen But everything I look at in the two versions of the templates matches
15:53 kados in the js we have:
15:53 opener.document.f.value[myindex].value!=""
15:53 what is value[myindex] in the markup?
15:55 <!-- TMPL_VAR NAME="value" ESCAPE="URL" --> maybe?
15:55 arrg, not that
15:57 huh
16:00 hmmm
16:00 owen: 'opener' referes to the previous window
16:00 owen: so maybe our problem is in the opac-searchresults.tmpl markup, not the opac-dictionary.tmpl markup
16:01 and notice it says 'opener.document.f.value' ... it's not getting the id for some reason
16:02 owen: shoudl this be a href?<a  href="javascript:SelectEntry('Lewis%2C%20C.%20S​.%20%28Clive%20Staples%29%2C%201898-1963',2,0)" class="button catalogue">Select</a> |
16:03 shouldn't it be something like <a href="" onclick=javasript...
16:03 ?
16:03 owen It's not relevant to this issue, but yes.
16:04 The guidelines I've seen say that you should always include a relevant href value to allow for non-javascript browsers. That doesn't really apply here, of course, because it's a pop-up window.
16:04 The alternative would be to use href="#" onclick="SelectEntry..."
16:06 kados yea, that's not what's causing this prob
16:06 well I'm burned out on it
16:07 let me know if you find anything
16:07 otherwise I'll work on it some more tomorrow
16:07 owen I'll keep poking at it.
16:08 I've encountered this problem before... not that it helps.
22:19 kados anyone have ideas for a poll related to Koha or open source in libraries for LibLime's first Newsletter?
22:19 I was thinking maybe a question about the Koha foundation ...
22:21 russ: any ideas?
22:22 russ hmm
22:22 now i was thinking about something along these lines
22:22 as i had some q's i wanted to ask
22:22 our clients
22:50 kados chris: stephen agreed to do an op-ed column
22:50 chris: we're calling it 'the hedge'
22:50 chris heh
22:50 kados chris: and tina just made a nice graphic
22:50 chris hedging your bets
22:50 kados http://newlabs.liblime.com/new[…]pete-with-web-20/
22:50 hehe
05:20 pierrick_ hi there
05:21 pierrick does anybody know how to insert a line in a table with a null value for one column, using the binding method?
05:21 (I've tried with undef value in Perl, but it doesn't seem to work)
05:22 chris how do you mean?
05:22 is it a different column every time? or always the same column?
05:22 pierrick insert into aqbookfund (bookfundid,bookfundname,branchcode) values (?,?,?)
05:22 the branchcode can be null
05:23 chris and you want null, not '' ?
05:23 pierrick if I sth->execute($bookfundid, $bookfundname, undef), it doesn't work
05:23 chris $branchcode='';
05:23 pierrick I want SQL NULL value, not an empty string
05:23 chris right
05:23 i dont think that you can
05:23 pierrick :-(
05:24 chris the way id do it
05:24 is with an if, and 2 $query
05:24 one
05:24 insert into aqbookfund (bookfundid,bookfundname) values (?,?)
05:25 and one with all three
05:25 pierrick I understand what you mean, but this is not a scalable solution :-/
05:25 chris what about 'NULL'
05:25 does that work?
05:25 pierrick imagine ou have 23 columns to fill, and 20 can be NULL, will you write 40 queries?
05:26 chris yep
05:26 pierrick I can insert the string 'NULL', but it is absolutely not what I want. I'd prefer inserting an empty string than 'NULL' string
05:26 chris that definitely inserst the string null
05:26 ?
05:27 pierrick yes, it does
05:27 chris right
05:27 hmm
05:27 pierrick I've tested sth->execute($bookfundid, $bookfundname, $branchcode || 'NULL')
05:28 chris Undefined values, or "undef", can be used to indicate null values.  However, care must be taken in
05:28       the particular case of trying to use null values to qualify a "SELECT" statemeny
05:28 the DBI man page reckons we can somehow
05:29 pierrick OK, that's what I supposed at the beginning (using a Perl undef to insert an SQL NULL value) but it doesn't work :-/
05:29 chris right
05:30 pierrick wait wait wait
05:30 sth->execute($bookfundid, $bookfundname, $branchcode || undef)
05:30 works
05:30 ???
05:31 chris weird
05:31 pierrick I thought $input->param('branchcode') was returning undef if the parameter was not defined!
05:31 chris i think it returns blank
05:32 pierrick no because I would have had the error:  DBD::mysql::st execute failed: called with 2 bind variables when 3 are needed
05:32 chris so my $branchcode=input->param('branchcode') || undef;
05:32 pierrick an empty string would have been a correct value
05:34 anyway, thank you chris :-)
08:19 kados morning folks
08:19 pierrick morning Johsua
08:20 s{Johsua}{Joshua}
08:57 kados, do you know how to have two distinct actions (destinations) in a form, depending on the submit button you click?
08:59 kados pierrick: not off the top of my head, sorry
09:01 pierrick kados, OK, I continue to search a solution
09:32 kados morning owen
09:32 owen Hi
09:34 No luck yesterday on debugging the opac-dictionary popup.
09:35 pierrick hi owen, have you ever used a multiselect with Perl as scripting language?
09:35 owen My Perl skills are very limited.
09:36 pierrick OK, :-/

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

koha1