c-76-105-203-39.hsd1.or.comcast.netgmail.com (not sure if you have that one or not?)← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | 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 i=plinkitc-76-105-203-39.hsd1.or.comcast.net |
| 15:13 | kados | darcilicious: ! |
| 15:13 | darcilicious | kados! this is where you hide from me, eh? ;-) |
| 15:13 | kados | hehe |
| 15:15 | hehe | |
| 21:32 | chris | morning |
| 21:32 | kados | darcilicious: met chris yet? |
| 21:32 | 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 | from oregon eh? so far the prettiest state in the US I have visited :) | |
| 21:35 | darcilicious | i like it here :) |
| 21:36 | 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 | 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 | :-) | |
| 21:38 | darcilicious | in the meantime, there's always naples ;-) http://plonebootcamps.com/cour[…]conf2-using-plone |
| 21:39 | kados | hehe |
| 21:40 | chris | http://plone.org/news/new-zeal[…]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 koha.org, or doing some kind of competition with a decent giveaway |
| 21:41 | darcilicious: you have any thoughts on that? | |
| 21:41 | darcilicious | what kind of give away? |
| 21:41 | chris | http://www.e.govt.nz/policy/open-source |
| 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 | 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 | 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 plone.org ;-) |
| 21:43 | kados | sweet |
| 21:44 | darcilicious: would you be willing/able to run the contest per chance? :-) | |
| 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 | lol! | |
| 21:44 | 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 | 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 | yea, it's the OSS way | |
| 21:46 | lots of great ideas, no resources | |
| 21:46 | darcilicious | yeup! :) |
| 21:48 | 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 | 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 plone.org is doign for the conference this year |
| 21:54 | this year's conference folks are using: http://ploneconference2007.boo[…]ubbhomepage.aspx? | |
| 21:54 | kados | huh, an asp? |
| 21:54 | alter.it | |
| 21:54 | interesting | |
| 21:54 | darcilicious | third party |
| 21:55 | kados | guess plone.org must have trouble with organizing cons too ;-) |
| 21:55 | darcilicious | plone is a little weak in the ecommerce bit at the moment. |
| 21:55 | yeah ;-) | |
| 21:56 | 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: darci.hanninggmail.com (not sure if you have that one or not?) |
| 22:17 | matthewmetzger | Hello Chris |
| 22:18 | 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 | is it reports/inventory.pl 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 | that's it. | |
| 22:22 | chris | 2.2.9 |
| 22:22 | ? | |
| 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 | 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=biblioitems.biblioitemnumber; |
| 22:29 | kados | ahh, right |
| 22:29 | 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=biblioitems.biblioitemnumber; |
| 22:31 | 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 | load data infile '/tmp/itemsdata' into table items; | |
| 22:32 | kados | yea, easy peasy |
| 22:32 | chris | or, mysqldump that table |
| 22:32 | (or the whole db if its not so big) | |
| 22:33 | matthewmetzger | I do a daily mysqldump for a backup. |
| 22:33 | 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 | then that would be a handy tool for others | |
| 22:35 | who get into this situation | |
| 22:35 | 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 | coffee break | |
| 22:36 | brb | |
| 22:44 | back | |
| 22:44 | coffee++ | |
| 22:46 | 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 | matthewmetzger: cheers, good luck, let us know how it goes | |
| 23:38 | ryan | kados: around ? |
| 23:41 | anybody ? | |
| 23:42 | kados | hey ryan |
| 23:42 | I don't know what the def is | |
| 23:42 | I've never seen it defined anywhere | |
| 23:44 | ryan: it's just: | |
| 23:44 | defaultvalue text, | |
| 23:44 | http://cvs.savannah.nongnu.org[…]=koha&view=markup | |
| 23:48 | ryan | ah, simple |
| 23:48 | i didn't think it had been committed | |
| 23:49 | kados | ryan: committed now |
| 23:49 | ryan: I had to overwrite paul's because it was failing | |
| 23:50 | ryan | yikes |
| 23:50 | kados | sup? |
| 23:52 | we should take a couple hours and step through each table def | |
| 23:52 | compare what's in CVS now to paul's | |
| 23:53 | for one, paul has all the constraints | |
| 23:53 | the one I committed doesn't have those | |
| 23:53 | ryan | yep - v3 could drop a few tables |
| 23:53 | did you do the whole db? | |
| 23:53 | kados | no |
| 23:53 | all I did was revert paul's commit | |
| 23:54 | 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 | plus I think he wrote a mail about them | |
| 23:54 | 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 | I wonder if it should all be in one file | |
| 23:55 | seems like maybe it should be broken up | |
| 23:55 | should constraints be in the same file? | |
| 23:56 | ryan | that makes some sense |
| 23:57 | adding constraints & cascades by alter table lets you successfully create in any order | |
| 23:57 | then add fk stuff after | |
| 23:57 | kados | yea |
| 23:57 | and should the db def be defined by module? | |
| 23:57 | 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 | but several structure.sql's for each module | |
| 23:58 | 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 | i need tuto for koha, can you help me? | |
| 09:59 | chris | http://www.kohadocs.org/newbieguide.html |
| 10:02 | oscarog | thanks chris, i go on the web site |
| 10:06 | chris | there is other documentation at www.kohadocs.org that might be useful as well |
| 10:20 | oscarog | there is some french document? |
| 10:21 | chris | http://www.kohadocs.org/ |
| 10:21 | oscarog | in french? |
| 10:21 | chris | yes, linked from there |
| 10:21 | oscarog | ok, thanks |
| 10:22 | i'm already seen this one | |
| 10:23 | thanks for your help |
← Previous day | Today | Next day → | Search | Index
