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