IRC log for #koha, 2007-03-14

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

All times shown according to UTC.

Time Nick Message
11:00 owen ...something we /didn't/ do with the OPAC and the MARC/ISBD views...
11:00 kados yea
11:00 that's exactly what I was thinking
11:00 also, regarding the OPAC
11:01 I'm thinking we should just piggy back on a library like YUI at least for layout
11:01 rather than try to roll our own
11:01 maybe for tabs too
11:02 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 anyway ... that's my current thinking :-)
11:02 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 ie, how should this thing actually look :-)
11:05 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 rather than have three input boxes on the left-nav, what about a single box that could be used for all three
11:06 and some way (maybe a tab or a drop down) that could switch which function it is performing
11:06 (or an access key)
11:07 owen I think that's a little too much keyboard interaction for those inputs
11:08 Is she worried about the amount of stuff in that menu?
11:08 kados yea, a bit
11:08 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 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 hdl: http://wiki.koha.org/doku.php?[…]ndandnotes07mar12
11:25 hdl: is now a good time to have a 15 minute meeting to address those issues?
11:26 hdl yes
11:27 let's do it
11:27 kados great
11:27 rch hdl: do you have userflags sql?
11:27 i didn't see them in fr/
11:28 hdl Actually, we donot have translated them yet.
11:29 But we shave to
11:29 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 -- 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 hdl: it doesn't happen for you?
11:31 hdl I didnot notice this problem.
11:31 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 if so, who will do it?
11:32 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 You can do it.
11:34 rch seems easier than testing
11:34 i'll do it
11:34 hdl Is this the best solution. I donot know.
11:34 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 who will find out and take care of it?
11:35 hdl It was to compile subjects.
11:36 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 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 so next:
11:39 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 it's listed on the about page, right?
11:43 hdl yes.
11:43 Was stored in kohaversion.
11:43 kados can we just use that?
11:44 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 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 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 so ...
11:56 what's our conclusion on this point?
11:57 I'd like to wrap up this mtg in 3 minutes :-)
11:57 rch okay, so webinstaller tests version number...
11:58 otherwise, that logic isn't needed until 3.0.1, right?
11:58 hdl was on phone  with paum.
11:58 was on phone  with paul.
11:58 sory.
11:59 rch : for 22 to 3
11:59 I agree it is not webinstaller's duty.
11:59 but console admin tools.
11:59 (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 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 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 I did what I could in the time frame I had.
12:06 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 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 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 I can tweak it to make it work.
12:12 rch that makes sense to me
12:14 kados & i were discussing defining install files in xml file instead of reading directory contents.
12:14 that might make upgrades easier to manage, too
12:16 kados yep
12:17 well one problem we have now
12:17 is that the order of the files is not controleld
12:17 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 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 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 can sort it easily on substring.
12:26 hdl rch : foreach my $file ($query->param('framework')){
12:26 That line ?
12:27 We have to order on basename + directory.
12:29 rch right
12:29 but if it used xml instead, could it more readily specify upgrade paths as well as install order?
12:30 we are okay for now on ordering.
12:35 so i am still interested in how to redirect user to installer.
12:35 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 can kohaversion be a syspref rather than stored in the config file?
12:52 would it be faster to read it then?
12:55 rch i prefer having original redirect to installer, changed after install.
12:56 perhaps install step 1: install symbolic link in apache to koha-httpd.conf
12:57 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 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 ok, lets store it in conf file then
13:31 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 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 what about a simple installer conf file?
13:33 installer/install.conf or sth?
13:33 it coudl also be used to store directory information
13:34 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 May be becaus file was too big.
13:35 I tried at first to use dbh->do("SOURCE $myfile")
13:35 [14:20:01] <hdl> But that failed miserably.
13:36 kados hmmm
13:52 ok, so that won't be changed then
13:52 there are two tasks I'm not sure who's taking them
13:52 1. preventing opac and intranet from being visible before installer is run
13:52 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 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 so what is the roadmap to completing them?
13:54 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 I won't be able to do it until late this week.
13:55 kados ok, that's fine
13:55 you can take them for later this week
13:56 I'm going to compose a mail to koha-devel
14:19 summary to koha-devel sent
14:44 hdl: could you explain what 'cities' and 'roads' and 'departments' are in 3.0?
15:04 hdl cities are for towns
15:04 roads should be Street, Boulevards, ...
15:05 departments are Bouche-du-Rhône (around Marseille), Hérault (around Montpellier) They have different zipcodes :
15:06 13000 for Marseille
15:06 34XXX for Hérault
15:06 75XXX for Paris
15:07 kados : is it clear ?
15:09 tnb hdl: hey :)
15:09 If I send you an email, could you give me a few stats on SAN-OP?
15:09 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 never mind, i found it :)
15:11 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 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 There is one on rel_3_0.
17:41 selected order is not kept.
17:41 Could you verify on a devweek box ?
17:41 chris sounds like a template problem?
17:41 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 hi chris.
17:42 How are you and kahungari ?
17:42 chris good thanks, a bit tired today, he woke a couple of times last night
17:42 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 + hardcoded labels in displaySortBy.
17:47 kados we don't have a proper query parser
17:47 if you want you could just use zebra
17:47 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 hdl: I'd be happy to work on better query parsing
10:01 anyone else having trouble committing to savannah?
10:13 owen Hi kados
10:13 kados hey there
10:14 fix the index, break the index, fix the index, break the index :-)
10:14 this time it looks to be a problem with the query that's done in addbiblio
10:14 to find duplicates
10:53 hdl: you around?
10:53 hdl yes
10:53 hi
10:53 kados hdl: could you send a link to the record that you are having trouble with ?
10:53 hdl: otherwise it will be impossible to troubleshoot for the perl4lib guys
10:53 (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 excellent
10:54 hdl It is basically failing on what appears as µ
10:55 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 don't think MARC::Charset can handle anything but UNICODE or MARC-8
10:56 hdl: ok, second question
10:56 hdl: did you see my "questions for french team"?
10:56 hdl Yes.
10:56 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 thanks
10:57 rch and I are continuing our code audit today
10:57 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 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 but I agree, it should be done carefully if at all

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

koha1