IRC log for #koha, 2007-07-08

All times shown according to UTC.

Time S Nick Message
13:08 thd seen kados?
13:08 dewey kados was last seen on #koha 1 days, 44 minutes and 35 seconds ago, saying: bout time for some coffee ... I'll bbiab [Sat Jul  7 00:23:51 2007]
13:09 [K] *** part FreeNode!#koha: darcilicious
15:13 kados darcilicious: !
15:13 darcilicious kados! this is where you hide from me, eh? ;-)
15:13 kados hehe
15:15 kados hehe
21:32 chris morning
21:32 kados darcilicious: met chris yet?
21:32 kados darcilicious: chris _invented_ koha :-)
21:32 darcilicious kados! you're not supposed to be at the keyboard! ;-)
21:32 chris heheh not quite :)
21:32 darcilicious hello chris! pleased to meet you :)
21:32 kados hehe, yea
21:33 chris hiya darci
21:34 chris from oregon eh? so far the prettiest state in the US I have visited :)
21:35 darcilicious i like it here :)
21:36 darcilicious i've been to australia twice but haven't made to nz yet... what's wrong with me? >:/
21:36 chris yeah ... picked the wrong country out of those two :-)
21:36 darcilicious ;-)
21:37 darcilicious well, the second time sis was getting married in brisbane so not much choice there ;-)
21:37 chris in that case your forgiven
21:37 kados darcilicious: we'll have to bring you to nz for our next KohaCon
21:37 kados :-)
21:38 darcilicious in the meantime, there's always naples ;-)[…]conf2-using-plone
21:39 kados hehe
21:40 chris[…]es-plone-instance
21:40 darcilicious wonder if all that is still the case...
21:41 chris its being used by more govt depts now
21:41 kados darcilicious: i had the idea of either hiring someone to do a skin for, or doing some kind of competition with a decent giveaway
21:41 kados darcilicious: you have any thoughts on that?
21:41 darcilicious what kind of give away?
21:41 chris
21:42 kados darcilicious: the monetary kind :-)
21:42 darcilicious perhaps an iphone? ;-)
21:42 kados oooh, good idea
21:42 chris restricting to states in the US that way would be my only worry
21:42 kados chris: right
21:43 kados money is probably easier anyway
21:43 chris you might have to do iphone or something if you dont live somewhere an iphone will work
21:43 kados don't have to deal with shipping, etc.
21:43 darcilicious phooey. good points all.
21:43 darcilicious but yes, a contest would be grand :)
21:43 kados darcilicious: think the plone community would respond well?
21:43 darcilicious i think there's some thought for something similar in ;-)
21:43 kados sweet
21:44 kados darcilicious: would you be willing/able to run the contest per chance? :-)
21:44 darcilicious like some group within picks X number of word press themes to have them converted to plone skins
21:44 darcilicious lol!
21:44 darcilicious this is hardly fair, kados!
21:44 kados hehe
21:45 darcilicious unless of course the contest director gets an iphone ;-) (j/k!!)
21:45 kados thing is, I think it's a neat idea
21:45 kados but I don't have time to run it :-)
21:45 darcilicious then i would likewise consider doing it :)
21:45 kados hehe
21:45 darcilicious yeah, because i have all this spare time ;-)
21:45 kados hehe
21:45 kados yea, it's the OSS way
21:46 kados lots of great ideas, no resources
21:46 darcilicious yeup! :)
21:48 darcilicious i've been busy. opened up registration for plone training and have submitted a proposal to present too
21:48 kados darcilicious: is there a plone product that manages that?
21:49 darcilicious joel burton has a custom type / product on his site for training/registrations. he might be willing to open source it or give it to koha as he loves libraries
21:50 kados w00t
21:50 darcilicious for the proposals, plone folks seem to like to surveymonkey of all things
21:50 darcilicious that's a big "might"
21:50 kados that'd be sweet because managing our last con was a real pain
21:50 darcilicious interesting. let me see to what is doign for the conference this year
21:54 darcilicious this year's conference folks are using:[…]ubbhomepage.aspx?
21:54 kados huh, an asp?
21:54 kados
21:54 kados interesting
21:54 darcilicious third party
21:55 kados guess must have trouble with organizing cons too ;-)
21:55 darcilicious plone is a little weak in the ecommerce bit at the moment.
21:55 darcilicious yeah ;-)
21:56 darcilicious actually, the organizing is fine. it's getting paid that seems tough. hence a new project/product: PloneGetPaid ;-)
21:56 chris heh
21:56 kados hehe
22:17 chris hi matthew
22:17 darcilicious oh, kados, you should use this email address for any emails between us: (not sure if you have that one or not?)
22:17 matthewmetzger Hello Chris
22:18 matthewmetzger I'm just stopping by to observe for a while.
22:19 chris its usually pretty quiet today
22:19 matthewmetzger So I can see. Sundays are when you all get together, right?
22:20 chris sundays your time yep .. monday for me
22:21 chris is it reports/ that you are using and can't because of the no item.itemcallnumber problem?
22:21 matthewmetzger Do you have some time to chat about a particular problem that I'm having? I already posted to the list. Yes
22:22 matthewmetzger that's it.
22:22 chris 2.2.9
22:22 chris ?
22:22 matthewmetzger Yes.
22:23 chris interesting i cant see in the code where it uses itemcallnumber, lemme just do a grep
22:23 kados matthewmetzger: see the list
22:23 kados matthewmetzger: just sent you a nice script :-)
22:23 matthewmetzger My latest post to the list asked how I could just transfer the value of one sql field to that of another, but I'm not sure that is going to be the solution.
22:23 kados matthewmetzger: that should solve your ills
22:23 matthewmetzger Thanks so much kados. I'll check it out.
22:28 chris you should be able to do it with a line of sql too
22:29 kados chris: with a subselect maybe?
22:29 chris update items,biblioitems set items.itemcallnumber = biblioitems.classification where items.biblioitemnumber=bib​lioitems.biblioitemnumber;
22:29 kados ahh, right
22:29 kados I think the timestamp too
22:29 chris naw, since about 4 i think mysql supports multi table updates
22:29 kados don't wanna lose the timestamp
22:29 chris right
22:30 kados the script gives you a nice count too :-)
22:30 chris update items,biblioitems set items.itemcallnumber = biblioitems.classification, items.timestamp=items.timsestamp  where items.biblioitemnumber=bib​lioitems.biblioitemnumber;
22:31 chris either oughta work :)
22:31 kados yup
22:31 matthewmetzger so all I have to do is run what Chris just wrote.
22:31 chris what id do before i ran either
22:31 kados matthewmetzger: back up your db beforehand
22:31 chris is select * from items into outfile '/tmp/itemsdata';
22:32 matthewmetzger okay, thanks. I'll be looking at it closely. Yes, I'll definitely back up.
22:32 chris then if it goes wrong you can delete from items;
22:32 chris load data infile '/tmp/itemsdata' into table items;
22:32 kados yea, easy peasy
22:32 chris or, mysqldump that table
22:32 chris (or the whole db if its not so big)
22:33 matthewmetzger I do a daily mysqldump for a backup.
22:33 matthewmetzger I'll just make sure there have been no changes since the last backup
22:33 kados sweet
22:34 matthewmetzger thanks again. I might not actually do this until Monday as I want to make sure I understand everything. I've also got some other work. I'll let you know how it goes.
22:34 chris no problem it might be good to extend kados's script to back up the data
22:34 chris then that would be a handy tool for others
22:35 chris who get into this situation
22:35 chris also if we wanted to be nice and tricky, we'd extend it to populate marc_word and marc_subfield_table too
22:35 kados yea
22:36 kados coffee break
22:36 kados brb
22:44 kados back
22:44 kados coffee++
22:46 kados sweet
22:54 matthewmetzger you are making me thirsty. All I have is green tea. That will have to do. See you guys later and thanks for the help!
22:54 kados hehe
22:54 kados matthewmetzger: cheers, good luck, let us know how it goes
23:38 ryan kados: around ?
23:41 ryan anybody ?
23:42 kados hey ryan
23:42 kados I don't know what the def is
23:42 kados I've never seen it defined anywhere
23:44 kados ryan: it's just:
23:44 kados defaultvalue text,
23:44 kados[…]=koha&view=markup
23:48 ryan ah, simple
23:48 ryan i didn't think it had been committed
23:49 kados ryan: committed now
23:49 kados ryan: I had to overwrite paul's because it was failing
23:50 ryan yikes
23:50 kados sup?
23:52 kados we should take a couple hours and step through each table def
23:52 kados compare what's in CVS now to paul's
23:53 kados for one, paul has all the constraints
23:53 kados the one I committed doesn't have those
23:53 ryan yep - v3 could drop a few tables
23:53 ryan did you do the whole db?
23:53 kados no
23:53 kados all I did was revert paul's commit
23:54 kados plus just now I added defaultvalue
23:54 ryan ah
23:54 kados so now we should go back and manually re-add paul's changes
23:54 kados plus I think he wrote a mail about them
23:54 kados so I'd like to read that
23:54 ryan so no fk constraints on marc structure table
23:55 kados right, not in the current form anyway
23:55 kados I wonder if it should all be in one file
23:55 kados seems like maybe it should be broken up
23:55 kados should constraints be in the same file?
23:56 ryan that makes some sense
23:57 ryan adding constraints & cascades by alter table lets you successfully create in any order
23:57 ryan then add fk stuff after
23:57 kados yea
23:57 kados and should the db def be defined by module?
23:57 kados I really wish we had a plugin architecture like plone
23:57 ryan yeah, i think there should not be a single structure.def
23:58 ryan but several structure.sql's for each module
23:58 ryan er... one for each module
23:59 kados right
23:59 ryan should start thinking about a plugin api
08:16 ogoul i need help to learn koha. some on can help me?
09:07 chris that was random
09:57 oscarog hi
09:58 oscarog i need tuto for koha, can you help me?
09:59 chris
10:02 oscarog thanks chris, i go on the web site
10:06 chris there is other documentation at that might be useful as well
10:20 oscarog there is some french document?
10:21 chris
10:21 oscarog in french?
10:21 chris yes, linked from there
10:21 oscarog ok, thanks
10:22 oscarog i'm already seen this one
10:23 oscarog thanks for your help

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