IRC log for #koha, 2007-03-14

All times shown according to UTC.

Time S Nick Message
11:00 owen ...something we /didn't/ do with the OPAC and the MARC/ISBD views...
11:00 kados yea
11:00 kados that's exactly what I was thinking
11:00 kados also, regarding the OPAC
11:01 kados I'm thinking we should just piggy back on a library like YUI at least for layout
11:01 kados rather than try to roll our own
11:01 kados maybe for tabs too
11:02 kados ie, I really like our OPAC design for dev_week, but we could probably make it more browser compliant in 3.0 if we used selected components in YUI
11:02 kados anyway ... that's my current thinking :-)
11:02 kados subject to change of course :_)
11:02 owen Yeah, that sounds sensible if we go with YUI for the intranet.
11:03 kados I think what we need to do is have a focused meeting to discuss intranet design
11:03 kados ie, how should this thing actually look :-)
11:05 kados tina and I were talking yesterday and she had an interesting idea that I was a bit skeptical of but is probably worth mentioning
11:06 kados rather than have three input boxes on the left-nav, what about a single box that could be used for all three
11:06 kados and some way (maybe a tab or a drop down) that could switch which function it is performing
11:06 kados (or an access key)
11:07 owen I think that's a little too much keyboard interaction for those inputs
11:08 owen Is she worried about the amount of stuff in that menu?
11:08 kados yea, a bit
11:08 kados and in the demos we've done, people tend to be a bit overwhelmed by it
11:10 owen Yeah, it's overwhelming if you're using an unrestricted user. It's a lot more manageable if you're logged in as a circ-staff user.
11:11 kados yea, that's true
11:16 owen Before we get together for a meeting I'd like to have plenty of time to get to know the current status of the 3.0 interface. But yeah, I think getting together to discuss it would be a great idea.
11:19 rch hi owen
11:19 rch hi hdl
11:19 owen hi rch
11:19 kados hdl: I'm writing an agenda for our 15 minute Installer meeting on the wiki
11:24 kados hdl: http://wiki.koha.org/doku.php?[…]ndandnotes07mar12
11:25 kados hdl: is now a good time to have a 15 minute meeting to address those issues?
11:26 hdl yes
11:27 hdl let's do it
11:27 kados great
11:27 rch hdl: do you have userflags sql?
11:27 rch i didn't see them in fr/
11:28 hdl Actually, we donot have translated them yet.
11:29 hdl But we shave to
11:29 hdl But we have to
11:29 kados hdl: will that fix the duplication problem I'm seeing?
11:30 rch kados & i were discussing adding primary key to prevent duplication
11:30 hdl I donot know. I don't see your problem.
11:30 rch vs. testing in installer
11:30 rch -- if you run installer twice :)
11:30 kados hdl: if I run the installer more than once I get duplicates in user flags and sysprefs
11:31 kados hdl: it doesn't happen for you?
11:31 hdl I didnot notice this problem.
11:31 hdl But since you say there are no primary key, this must happen.
11:32 kados so is the best solution to add a primary key to both tables?
11:32 kados if so, who will do it?
11:32 kados if not, what is another solution?
11:33 hdl Maybe adding primary keys to Varaible names and userflags flag woud be a solution.
11:33 hdl You can do it.
11:34 rch seems easier than testing
11:34 rch i'll do it
11:34 hdl Is this the best solution. I donot know.
11:34 hdl Do we still need bibliothesaurus table ?
11:34 kados bibliothesaurus table had a fulltext index, is it OK it’s removed?
11:35 hdl I think no.
11:35 kados if we dont' need it lets remove it
11:35 kados who will find out and take care of it?
11:35 hdl It was to compile subjects.
11:36 hdl I donot have time
11:36 rch so it is supposed to be a myisam table
11:37 hdl I think this table is disposable
11:38 hdl it was used in Koha1.0 to get subjects.
11:38 rch ok, so we can drop it from the sql definition
11:39 kados great
11:39 kados so next:
11:39 kados how to signal that the install’s already been done
11:40 rch the chmod doesn't work for me.
11:40 hdl Adding a value to koha.conf file would be ok for me.
11:41 rch could update 'koha version'
11:41 hdl <webinstaller>kohaversion</webinstaller>
11:41 kados where is koha version stored now?
11:42 hdl nowhere.
11:42 kados hmmm, I thought we had a version string somewhere
11:42 kados it's listed on the about page, right?
11:43 hdl yes.
11:43 hdl Was stored in kohaversion.
11:43 kados can we just use that?
11:44 kados use a specific string like:
11:44 hdl But in xml I donot know.
11:44 kados webinstall-3.0.1 or sth
11:45 rch i think this sounds ok
11:45 hdl ok to me
11:45 rch then user manually removes installer dir
11:48 kados yep
11:48 kados will web installer be used to handle upgrades?
11:49 hdl i think it can.
11:51 rch hdl: what's the status of the migration_tools/22_to_30/ stuff?
11:52 kados to use the installer for upgrades we will need some additions
11:53 kados 1. it will need to tell the user that 'koha's installed, there's a newer version, would you like to install it?'
11:55 rch i'm not sure about 22->3.0 ... seems better to run a series of cmd line scripts.  
11:55 kados yea, I agree
11:55 rch likely many warnings log stuff
11:55 kados but for 3.0.0 -> 3.0.1
11:55 rch right
11:55 kados we could use the web installer if it was tuned a bit
11:56 kados so ...
11:56 kados what's our conclusion on this point?
11:57 kados I'd like to wrap up this mtg in 3 minutes :-)
11:57 rch okay, so webinstaller tests version number...
11:58 rch otherwise, that logic isn't needed until 3.0.1, right?
11:58 hdl was on phone  with paum.
11:58 hdl was on phone  with paul.
11:58 hdl sory.
11:59 hdl rch : for 22 to 3
11:59 hdl I agree it is not webinstaller's duty.
11:59 hdl but console admin tools.
11:59 hdl (paul greets you all)
12:00 kados (hi paul)
12:01 hdl where to put images : in usual images dir
12:02 rch and how important is platform dependent code?
12:02 kados it's very important
12:02 kados otherwise we alienate windows and mac users
12:03 hdl But I can't give you any good solution.
12:03 rch but noone's going to run zebra  on those platforms
12:03 kados tumer does
12:03 rch really?
12:03 kados yep, NEU is a windows show
12:04 rch personally, i don't think we need to support ms.
12:04 rch tho i agree that the installer's methods could be cleaner
12:04 hdl If tumer can tell us about good ways to find an discover exe files on a windows bos, ok for me, but I cannot spend to much time on this issue.
12:05 rch i don't know anything about windows platform.
12:05 hdl You can make proposition. I would be glad to see something taht you consider clean.
12:05 hdl I did what I could in the time frame I had.
12:06 hdl I did what seemed to me the basic assumptions one could do.
12:07 rch hdl: by 'cleaner', i meant less OS-specific :)
12:07 hdl Do not presume any software is installed or even installed the simpler way.
12:07 hdl It works on any Linux *BSD box :D
12:07 rch yes, to make a really robust installer is a very big job
12:08 hdl And I donot have any experience in OSX or windows web installation services.
12:09 hdl Maybe ActiveX for windows could do the job. On OSX, I bet that dev tools can provide ppl with 'find' and 'which' commands.
12:10 rch right...  well we'll have to as k tumer for windows stuff.
12:11 hdl kados : is it ok to consider installer can be used for upgrades over 30 jumping to step3 ?
12:11 hdl I can tweak it to make it work.
12:12 rch that makes sense to me
12:14 rch kados & i were discussing defining install files in xml file instead of reading directory contents.
12:14 rch that might make upgrades easier to manage, too
12:16 kados yep
12:17 kados well one problem we have now
12:17 kados is that the order of the files is not controleld
12:17 kados it's stored in a hash
12:17 hdl XML seems to be VERY powerful and hepful. Maybe the way to go.
12:18 kados so when you install Koha, sometimes it will cause errors because of constraints
12:18 hdl kados: We could provide numbers as 1st letters of files.
12:18 hdl That way, they would be ordered.
12:19 rch that's what we did...
12:19 hdl pb would be for required and optional.
12:19 rch but they're still stored in a hash
12:19 hdl and hash is not ordered ?
12:20 rch no guarantees
12:20 rch it of course can be sorted
12:22 hdl rch : where is the hash ?
12:22 dewey the hash is not ordered ?
12:22 hdl dewey : forget heash
12:22 dewey hdl, I didn't have anything matching heash
12:22 hdl dewey : forget hash
12:22 dewey hdl: I forgot hash
12:23 hdl rch : OK. seen.
12:25 rch ah, looking at it now, actually it's an array
12:25 rch can sort it easily on substring.
12:26 hdl rch : foreach my $file ($query->param('framework')){
12:26 hdl That line ?
12:27 hdl We have to order on basename + directory.
12:29 rch right
12:29 rch but if it used xml instead, could it more readily specify upgrade paths as well as install order?
12:30 rch we are okay for now on ordering.
12:35 rch so i am still interested in how to redirect user to installer.
12:35 rch so you can't go straight to opac before installation
12:43 hdl rch : why not having http redirect in C4::Auth if no kohaversion in Config file ?
12:51 kados that sounds good
12:52 kados can kohaversion be a syspref rather than stored in the config file?
12:52 kados would it be faster to read it then?
12:55 rch i prefer having original redirect to installer, changed after install.
12:56 rch perhaps install step 1: install symbolic link in apache to koha-httpd.conf
12:57 rch at end of install, we rewrite koha-httpd.conf, and instruct to restart web server.
13:29 kados hdl: you there still?
13:29 hdl yes
13:29 kados hdl: rch and I are looking at kohastructure.sql and we were wondering if it would be OK if we use mysqldump to generate it
13:29 kados the only difference is that constraints are stored inside each table def
13:29 hdl I think so.
13:30 kados is there any argument for stroring them at the end instead?
13:30 hdl kados : about kohaversion stored in the sysprefs, I prefer having it in conf file. Thus, it will be read only once with mod_perl.
13:31 kados good point
13:31 kados ok, lets store it in conf file then
13:31 kados but it means we need to write to the conf file
13:32 hdl Yes. I think I'l have to cope with it.
13:32 kados I have another question
13:32 kados why do we use a system call to mysql instead of just using dbi in the installer?
13:33 hdl But it could be dangerous to let conf file writable for apache.
13:33 kados true
13:33 kados what about a simple installer conf file?
13:33 kados installer/install.conf or sth?
13:33 kados it coudl also be used to store directory information
13:34 kados about what files are in sql-datas, etc.
13:34 hdl kados : sytemcall to mysql instead of DBI because when using DBI, SOURCING File couldnot be achieved. (Was it because apache is chrooted ? was it for another matter, I donot know.)
13:35 hdl May be becaus file was too big.
13:35 hdl I tried at first to use dbh->do("SOURCE $myfile")
13:35 hdl [14:20:01] <hdl> But that failed miserably.
13:36 kados hmmm
13:52 kados ok, so that won't be changed then
13:52 kados there are two tasks I'm not sure who's taking them
13:52 kados 1. preventing opac and intranet from being visible before installer is run
13:52 kados 2. signal to installer that install has already been done
13:53 rch hdl: was the failure on source for kohastructure.sql or for frameworks?
13:53 rch or both?
13:53 dewey both are pretty secure though
13:53 hdl kohastructure.sql
13:53 kados dewey: forget both
13:53 dewey kados: I forgot both
13:53 kados so who's taking #1?
13:54 hdl both are linked.
13:54 kados yep
13:54 kados so what is the roadmap to completing them?
13:54 kados and who is taking on responsibility to complete?
13:54 hdl I thought I would take them. But if you have time to do them.
13:55 hdl I won't be able to do it until late this week.
13:55 kados ok, that's fine
13:55 kados you can take them for later this week
13:56 kados I'm going to compose a mail to koha-devel
14:19 kados summary to koha-devel sent
14:44 kados hdl: could you explain what 'cities' and 'roads' and 'departments' are in 3.0?
15:04 hdl cities are for towns
15:04 hdl roads should be Street, Boulevards, ...
15:05 hdl departments are Bouche-du-Rhône (around Marseille), Hérault (around Montpellier) They have different zipcodes :
15:06 hdl 13000 for Marseille
15:06 hdl 34XXX for Hérault
15:06 hdl 75XXX for Paris
15:07 hdl kados : is it clear ?
15:09 tnb hdl: hey :)
15:09 tnb If I send you an email, could you give me a few stats on SAN-OP?
15:09 tnb collection size, # borrowers, etc?
15:10 hdl tnb: send it to btoumi. He should be more able to provide you with figures.
15:11 tnb what is his address?
15:11 tnb never mind, i found it :)
15:11 tnb thanks!
15:13 hpassini SAN-OP have 150 000 notices or biblios
15:13 hdl kados : department stands for library department : Youth Albums, Adults, Science
15:13 hpassini 250 000 items
15:14 hpassini and 20 000 borrowers and btoumi is on hollidays
17:38 kados rach: howdy
17:40 hdl kados : do you have a sorting pb with results on more than 2 pages ?
17:40 hdl There is one on rel_3_0.
17:41 hdl selected order is not kept.
17:41 hdl Could you verify on a devweek box ?
17:41 chris sounds like a template problem?
17:41 chris not passing through the order variable?
17:41 hdl It is.
17:42 chris and hi hdl :-)
17:42 hdl but I think there also can be a mix.
17:42 hdl hi chris.
17:42 hdl How are you and kahungari ?
17:42 chris good thanks, a bit tired today, he woke a couple of times last night
17:42 chris but mostly good :)
17:43 hdl mix between order Selection in template and selected in combobox.
17:43 chris ahh right
17:44 hdl combo box forgets wht has been selected.
17:46 hdl + hardcoded labels in displaySortBy.
17:47 kados we don't have a proper query parser
17:47 kados if you want you could just use zebra
17:47 kados instead of the query parser I slapped on top
17:47 hdl This should not happen.
17:48 kados hdl: feel free to file some bugs
17:48 kados hdl: I'd be happy to work on better query parsing
10:01 kados anyone else having trouble committing to savannah?
10:13 owen Hi kados
10:13 kados hey there
10:14 kados fix the index, break the index, fix the index, break the index :-)
10:14 kados this time it looks to be a problem with the query that's done in addbiblio
10:14 kados to find duplicates
10:53 kados hdl: you around?
10:53 hdl yes
10:53 hdl hi
10:53 kados hdl: could you send a link to the record that you are having trouble with ?
10:53 kados hdl: otherwise it will be impossible to troubleshoot for the perl4lib guys
10:53 kados (hi :-))
10:54 hdl I sent Ed Summers the XML record.
10:54 kados also, just FYI, I've discovered that sending an attachment of a MARC file often corrupts it
10:54 kados excellent
10:54 hdl It is basically failing on what appears as µ
10:55 hdl But should be ae with ligature.
10:55 kados could you send it to me too? :-)
10:55 hdl No. ASCII for mu greek letter.
10:55 kados ahh, that's likely the prob then
10:55 kados don't think MARC::Charset can handle anything but UNICODE or MARC-8
10:56 kados hdl: ok, second question
10:56 kados hdl: did you see my "questions for french team"?
10:56 hdl Yes.
10:56 hdl But cannot answer most of them.
10:56 kados who can? san-op?
10:57 hdl Yes and paul.
10:57 kados ahh, ok
10:57 kados thanks
10:57 kados rch and I are continuing our code audit today
10:57 kados it would be very useful to have those answers asap
10:58 hdl I find it quite dangerous to rename sysprefs, since you have to make code audit to know where it is used.
10:59 hdl a grep C4\:\:Context\-\>preference can help. But I don't know if ppl always use this facility to gain access to sysprefs
10:59 kados well grep -r SysPref can help
10:59 kados but I agree, it should be done carefully if at all

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