IRC log for #koha, 2007-07-10

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

All times shown according to UTC.

Time Nick Message
12:00 hdl yep
12:00 kados hi :-)
12:00 hdl: could you do mysqldump for me of the two production databases running 3.0?
12:00 LANG=C mysqldump -cnQ koha >kohastructure.sql
12:01 hdl you mean zebra and nozebra ?
12:01 or SAN WP and IPT ?
12:01 SAN is not up to date.
12:01 kados SAN WP and IPT
12:01 hdl IPT I can.
12:02 and SAN is out of reach from outside. ask hpassini or btoumi.
12:02 kados ok
12:03 hdl paul's machine seems off.
12:03 Can you wait a little bit ?
12:03 kados ok
12:05 hdl: also, I have another question
12:06 hdl: Robi Sturman has sent me UNIMARC English frameworks
12:06 hdl: I think they should be an option for the web installer, but they don't fit into our taxonomy
12:07 the installer should maybe ask about MARC flavor after language?
12:07 and we can put frameworks as:
12:07 installer/data/en/usmarc/mandatory
12:07 installer/data/en/unimarc/mandatory
12:07 etc.
12:07 ?
12:08 hdl kados : this will raise problems when we have *MARC gateways ...
12:08 kados you mean run unimarc along usmarc?
12:08 same db?
12:09 hdl I thought zebra server answering both usmarc and unimarc.
12:09 kados it's a neat idea
12:09 hdl anyway, unimarc along with usmarc in same zebra base is already possible.
12:09 kados so where shall I put the English unimarc frameworks?
12:10 hdl definitley in data/en/
12:10 maybe we should not too much anticipate the future.
12:11 And make as you suggested.
12:11 I thought that eventually, we should come to xml files that would contain default frameworks.
12:12 With xml-lang set to fr or en or spanish...
12:12 but this is TOO far away.
12:29 lloyd mmm I've got a file with a bunch of marc records in it... whats the best (quickest) way to convert it to a csv?
12:29 jaron lloyd: write a little script
12:30 lloyd meh
12:30 jaron perl, ruby, python, java--any of those would work.
12:30 not an answer you like? :)
12:32 lloyd well... i was hoping there was already something I could use
12:32 jaron do you want a lot of the record in the file or just a few fields?
12:33 lloyd all fields
12:34 hdl It would be a mess to put only values in csv.
12:34 You should consider dump marc record to a text file.
12:34 marcdump is good for that.
12:35 Mason ???? what's up ??
12:35 jaron lloyd: hdl's correct that the whole record wouldn't make much sense.
12:35 toins Mason is excellent !!!
12:36 dewey: mason is http://masonhq.com
12:36 dewey ...but mason is flying to australa tomorrow :(...
12:36 lloyd i've got the marc as a text file atm
12:37 argh.. i've got this CD on my desk with the file on saying they want it in csv, thats all the info i've got :/
12:37 jaron lloyd: what's the end goal?
12:38 and the records on the CD are in text format or MARC transmission format?
12:39 lloyd Goal : they just want there records readable in excel so they can manipulate the data
12:39 Format : god knows, how do I tell
12:39 jaron open it up in a text editor
12:40 hdl lloyd: you should ask your employer which information they want to process.
12:40 lloyd snippet : of autonomy in long-term care /b/cCharles W. Lidz, Lynn Fischer, Robert M. Arnold  aOxford :bOxford University Press,c1992  a(240)pc24cm  a$35.00 : CIP entry (Dec.)  aUEANN  aOld age homes --zUnited States  aNursing home patients --zUnited States  aAutonomy (Psychology) in old age  aAged --xLong term care.1 aArnold, Robert M.,d1957-1 aFischer, Lynn.  a26 930208 lw 16050500694nam  2200229l B45
12:40 hdl OK.
12:40 This seems iso2709
12:41 jaron lloyd: hdl's correct
12:41 kados trying to manipulate MARC in Excell is a mistake
12:41 lloyd: have you tried MARCEdit?
12:41 lloyd no
12:41 hdl you should
12:41 jaron that's right MARCEdit would make it easier.
12:41 lloyd url?
12:41 dewey it has been said that url is http://bugs.koha.org/cgi-bin/bugzilla/
12:42 hdl But I advise you to ask ppl to tell you more about the process they want to do.
12:42 kados lloyd: google is your friend
12:42 hdl Do they want to have a list.
12:42 owen dewey: MARCEdit is http://oregonstate.edu/~reeset[…]it/html/index.php
12:42 dewey OK, owen.
12:42 kados morning owen
12:43 owen Hi
12:43 hdl Do they want to edit Authors names ?
12:43 This is not the same.
12:44 kados : some of our scripts make use of CGI::ScrollingList
12:44 This is not translatable.
12:44 Can I modify it ?
12:51 lloyd mmm marcedit can still only export to marc format right?
12:52 jaron lloyd: there should be a csv feature
12:52 lloyd: it can also export to many different formats
12:53 dublin core, marcxml, mods
12:56 kados hdl: yes
12:56 hdl ok.
12:56 kados hdl: I thought we had created a new way to do most of the lists
12:57 hdl The new way is to get codes and descriptions and pass it to TMPL LOOPs.
12:58 kados yea, I thought Koha.pm had a bunch of get* routines that could be used
12:59 hdl: just a reminder, when you get a chance, send me the sql dump
12:59 hdl: LANG=C mysqldump -cnQ koha >kohastructure.sql
13:15 hdl kados :  LANG=C mysqldump -cnQ koha >kohastructure.sql exports data too.
13:18 toins kados: do you know if chris catalfo will be back soon ?
13:18 kados toins: I'm not sure, he had a baby :-)
13:18 hdl: ahh, sorry, that was MJ's syntax
13:18 toins hum... ok...
13:19 hdl OK.
13:19 kados add -d
13:19 hdl I found
13:19 kados -d|--no-data
13:19 hdl -d  does it.
13:19 yes
13:27 kados hdl: you'll mail me the file?
13:27 hdl yes
13:28 kados hdl: -cnQ are important too
13:28 Q is quote names
13:28 hdl I got it
13:44 kados : email sent.
13:44 kados hdl: thanks
13:45 hdl Did tumer commit his stuff ?
13:45 kados hdl: what stuff? sql def stuff?
13:45 hdl No. What he designed for NEU. I would like to see some improvements he made.
13:46 kados it's in a branch I believe
13:46 rel-TG maybe? :-)
13:46 hdl I hope so.
13:46 kados we also have some improvements to add from dev_week
13:47 label printing is much improved
13:47 and serials from rel_2_2 also
13:50 hdl:
13:50 The following error occcurred while importing the database structure:
13:50 Query was empty
13:51 Please contact your system administrator
13:51 the same problem I had before with Paul's commit
13:51 hdl: I have to get breakfast, I'll be back soon, could you try to use that kohastructure for an install, see if it works for you?
13:51 hdl i shall try
14:13 kados : I have not had any problem with kohastructure import.
15:15 kados hdl: you tried it from the installer?
15:15 hdl: using the new kohastructure that you sent me?
15:15 hdl: you can see what happens to me here: http://aragorn.metavore.com
15:15 hdl not from the installer using mysql.
15:16 kados ahh, try from the installer please
15:17 hdl on aragorn I had no problems.
15:17 I cannot do it right away...
15:18 Will try tonight
15:18 kados hdl: on aragorm there IS a problem, it gives the error "Query was empty"
15:19 hdl pls keep it dropped.
15:19 And *I* will try
15:20 kados ok, it's dropped, try it now
15:20 I will wait
15:21 hdl The following error occcurred while importing the database structure:
15:21 Query was empty
15:21 Please contact your system administrator
15:21 Aha !!!
15:21 kados now db has 87 tables
15:21 instead of 90 I think
15:21 hdl out of 89
15:22 mysql version ?
15:22 kados mysql  Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2
15:41 [K] *** join #koha@FreeNode: darcilicious n=plinkit@159.121.122.150
15:46 kados hey darci
15:46 darci discovers the freenode relay :-)
15:46 [K] <darcilicious@FreeNode> hey kados! (can't reach the NZ server from work on port 6667. are there any other ports?)
15:46 kados huh, weird
15:46 [K] * darcilicious@FreeNode actually discovered it late last week...
15:48 lloyd ;)
15:49 look at that, its actually come in useful :p
15:49 [K] <darcilicious@FreeNode> :-)
15:49 lloyd you can pm through it, but god knows how lol
15:50 [K] * darcilicious@FreeNode suspects [K] would be heavily involved ;-)
15:50 lloyd haha
16:31 kyle__ hello all, I'm working on an offline circulation system, and I have a question about Auth::checkpw, anyone care to answer a question? : )
17:25 slef hi all. Can someone take a look at kohabug 1382 and tell me whether it's the same issue chris has been fiddling with?
17:29 ryan slef: yes, i think chris answered this on list
17:30 slef ok, if it's the same issue, I'll commit a minimal fix
17:54 [K] *** join #koha@FreeNode: darcilicious n=plinkit@159.121.122.150
18:57 matthewmetzger Hello, I'm working on my inventory.pl problem and I have some questions. Do kados or ryan have some time?
19:46 slef hello guest!
19:46 CGI603 hello slef
19:46 slef Try /nick yourname to set your screen name
19:47 hello JCATS!
19:47 JCATS may I ask smth?
19:47 slef yep... no promises I can answer it, or that anyone else is awake
19:47 JCATS lol
19:47 slef (general online chat tip: don't ask to ask - just ask)
19:48 JCATS is koha 3.0 ready for production?
19:49 slef IMO no.  It can be massaged into production (and has been by several people) but most users would be better off waiting for a real release.
19:49 JCATS ok
19:49 matthewmetzger Any estimates to when that 3.0 release will be?
19:49 JCATS do u recommend me version 2.2.9 or version 2.4?
19:49 slef if you want to beta-test and bug-fix, go for it ;-)
19:49 2.2.9
19:50 JCATS debian sarge or etch?
19:50 slef matthewmetzger: kados's call, but I estimate late-July release-candidates, so probably mid-August 3.0
19:50 JCATS: etch.  See http://serene.ttllp.co.uk/~mjr/ for packages and notes for etch
19:50 kados slef: I'm aiming for Sept
19:51 mid-sept
19:51 matthewmetzger Wow! That's closer than I expected. Mid sept. is still great.
19:51 slef kados: rc date?
19:51 kados slef: mid-July :-)
19:51 slef heh
19:51 kados I'd like to do two releases between now and 'stable'
19:52 1. developers
19:52 2. testing
19:52 developers in mid-July
19:52 testing in mid-Aug
19:52 slef matthewmetzger: these are targets.  The more people beta-test and bug-fix the release candidates (rc), the more likely we can meet them.
19:52 kados and stable in mid-Sept
19:53 matthewmetzger Good stuff. Time permitting, I'd like to test a RC.
19:53 kados there's a pre-release version you can test today if you want
19:53 http://kados.org/stuff/koha_30[…]rerelease_0.4.tgz
19:53 give that a shot if you're especially eager
19:53 slef kados: reply to email: what dir are the build unit tests in?
19:53 kados koha/t/
19:54 matthewmetzger Today, I have to work on that inventory report. But, are there some docs for the prerelease?
19:54 kados ahh
19:54 slef I thought that was for installed systems?
19:54 kados slef: we don't have any build tests
19:54 slef: just unit tests for an installed system
19:54 matthewmetzger: there's a install doc that's pretty step-by-step
19:54 slef matthew: there's a quickstart in the tarball when I tried it, but ask
19:54 here for opaque steps
19:54 matthewmetzger thanks.
19:54 slef kados: have you expanded "4. start Zebra" or whatever it was?
19:55 kados matthewmetzger: for a debian system it should take about 30 minutes to install
19:55 slef: yep, corrected that
19:55 slef kados: has it stopped telling people to splatter cpan modules across their filesystem? ;-)
19:55 kados hehe, no :-)
19:55 some of the modules are only avaialble on CPAN
19:55 slef matthewmetzger: so look at that URL I mentioned for the debs of the CPAN stuff
19:56 matthewmetzger: I am a debian developer and will upload them when I get enough time to make them follow policy
19:56 kados slef: we could distribute your debs along with the releases
19:56 slef kados: dh-make-perl --cpan --build modulename
19:56 kados slef: I haven't seen them yet though
19:57 *nod*
19:57 slef kados: no point IMO.  Just give an apt source line, once I make it an apt source (probably on people.d.o)
19:57 kados slef: sounds good
19:58 matthewmetzger kados: do you have a bit of time for questions about my inventory.pl problem?
19:58 kados matthewmetzger: I'm kinda swamped atm
19:58 matthewmetzger okay.
19:58 kados matthewmetzger: could you post the questions to the list?
19:58 matthewmetzger sure, I'll do that.
19:58 kados thx
21:16 chris morning
21:18 darcilicious afternoon chris :)
21:18 chris :)
21:18 clocking in from work darci?
21:18 darcilicious nope. home on personal time at the moment :)
21:18 chris ahh fair enough
22:56 kados chris: can you see me?
22:57 chris: freenode seems to have split
22:57 chris yep
22:57 ur back now
22:57 kados cool
22:57 russel is sara back?
22:58 kados dunno yet
08:52 chris toins do you know?
08:52 toins hi chris
08:52 chris hi toins :)
08:52 toins macles is a plugin isn't it ?
08:53 but don't know what it does.
08:53 ask hdl
08:53 chris is it a french word?
08:53 ahh yep, ill ask hdl
08:53 hdl nope.
08:53 toins chris: english for macles is mykey
08:54 hdl and yes
08:54 chris :)
08:54 hdl english for macles is mykeys
08:54 toins yes...
08:54 hdl But this plugin is FRANTIQ specifiq.
08:54 chris ahh
08:55 hdl It allows them, from authorised_values consituted as XYZ
08:55 to have mutiple tabs
08:55 with tables
08:55 chris wow
08:55 hdl X being the tab number
08:56 Y on line
08:56 Z on colums.
08:56 + they have multiple entries
08:57 say "Ming period" is 562,542,521
08:57 chris http://frantiq.mom.fr/portal.php
08:57 hdl yes.
08:57 chris very cool
08:58 hdl I think this script can be very helpful for structured authorised_values.
08:58 But structure has to be precisely defined.
08:58 chris right
08:58 hdl (+ I must commit a css for tabs to work.)
08:59 chris *nod*
08:59 hdl http://frantiq.mom.fr/html/macles/0__.html
08:59 chris very good idea
09:00 hdl http://frantiq.mom.fr/html/macles/1__.html
09:00 to have an idea of the result.
09:00 chris ahh i see
09:02 and the mom use koha?
09:03 hdl Yes. But java was added on top of this.
09:04 chris ahh, people do some strange things some times :)
09:06 hdl: you were in new caledonia recently?
09:06 hdl yes
09:07 chris for work, or for holiday?
09:07 or both :)
09:07 hdl I wish I could visit you....;)
09:07 chris yes, you were quite close :)
09:07 hdl For work. (I was without my wife.)
09:07 chris next time (if you go back) maybe I can meet you there :-)
09:08 there are sometimes very cheap flights from nz to new caledonia
09:08 hdl Paul is going next time (maybe in late october)
09:08 chris ohhh
09:08 taking turns :)
09:11 maybe tahiti next ? :)
09:18 hdl Haïti or thaïti (seems more realistic)
09:18 Maybe Fidji.
09:20 chris :)
09:24 have you seen this http://www.ohloh.net/projects/[…]ontributors/37880
09:24 and for toins
09:24 http://www.ohloh.net/projects/[…]ontributors/37910
09:27 toins interesting...
09:28 chris i saw it there the other day, it had been registered but no one had filled out any info, so i added some information
09:28 http://www.ohloh.net/projects/1541
09:28 quite interesting
09:29 it fetches the code from cvs and analyses it, quite smart
09:31 toins yes
09:31 chris: do you know this one => http://cia.vc/
09:31 it's the same idea
09:32 chris ohh i havent seen that one
09:32 toins there isn't koha in
09:32 but opencataloger yes !
09:32 chris :)
09:33 cool
09:34 its good to seem commits being made :)
09:34 s/seem/see/
09:36 toins hehe
10:02 hdl chris around ?
10:02 chris yep
10:02 hdl why is aqorderbrakdown here for ?
10:03 chris what is it for?
10:03 hdl *aqorderbreakdown* here for ?
10:03 yes. I have this table but it is quite empty for me.
10:04 So I want to understand.
10:04 ordernumberok But linenumber is NULL.
10:04 chris right ordernumber and bookfund are always filled in
10:05 linenumber isnt used but the idea for it is that you have maybe 10 lines in a basket
10:05 so you could have 1 .. 10 in linenumber then order them that way on the invoice
10:06 but we just order by them by ordernumber instead
10:06 bookfund could be moved to aqorder
10:07 and that table could disapear .. originally i had planned that one ordernumber might have lots of orders .. but now we have 1 basket with lots of ordernumbers
10:07 so aqorderbreakdown isnt needed
10:07 does that help?
10:08 hdl OK.
10:08 So an aqorderbrakdown is just to store the budget the line is linked to ?
10:09 breakdown again
10:09 chris currently yes, thats all its being used for
10:10 hdl OK thanks

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

koha1