Time Nick Message 23:58 dcook I wonder which is faster.. 23:58 dcook Interesting... it looks like if you use list context, it does return a list of objects and you can just iterate through those using foreach 23:47 dcook :) 23:47 rangi yep, there will be others 23:46 dcook Disappointed not to meet eythian in the flesh as well, but there's always next time :) 23:46 rangi ahhh 23:46 dcook Disappointed to miss some of the sessions, but oh well 23:46 dcook I ended up cancelling my OSDC trip so I could be at home with the wife 23:45 huginn 04Bug 12478: enhancement, P5 - low, ---, robin, NEW , Elasticsearch support for Koha 23:45 rangi http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12478#c13 23:45 rangi pretty good 23:45 rangi hows osdc going? 23:45 dcook How's the ES stuff coming along? 23:44 dcook Yeah, I recall eythian mentioning it a while ago :) 23:44 rangi thats what we use to index stuff for elasticsearch 23:44 rangi cool 23:44 rangi *nod* 23:43 dcook Thanks for that, rangi. That's helpful :) 23:42 dcook Is that where you include the "items" option? 23:42 dcook That %options bit looks neat 23:37 * dcook takes a look at the link 23:37 dcook Also thought about using the hashrefinflator? 23:36 dcook But then I noticed the thing about list context returning a list of result objects? 23:36 dcook I was thinking about doing it that way 23:36 rangi http://git.catalyst.net.nz/gw?p=koha.git;a=blob;f=Koha/Biblio/Iterator.pm;h=fc150f433c1b68de7cada6bf22e77ffd02ef911f;hb=3e1705213116472b44fb1f0d618875db2538d34d 23:36 rangi have a look at 23:36 rangi my $row = $self->{rs}->next(); 23:36 dcook Or even if you can point me to some examples. The ones I found on the wiki weren't very helpful :/. 23:35 dcook \o/ 23:35 rangi yep 23:35 dcook Just trying to iterate through a list of results returned from a search 23:35 dcook Or anyone familiar with DBIC? 23:35 dcook I don't suppose a gmcharlt, rangi, or khall_away would be around? 22:55 dcook No worries :) 22:52 wizzyrea thanks for looking 22:52 * wizzyrea keeps testing 22:52 wizzyrea annoying problem. 22:50 wizzyrea that's 3.17 22:50 wizzyrea on the virtualshelves 22:50 wizzyrea in the schema 22:50 wizzyrea ) ENGINE=InnoD 22:50 wizzyrea no cascaded delete, please see HandleDelBorrower in VirtualShelves.pm 22:49 dcook My 3.17 is pristine 22:49 dcook So I don't think that's it? 22:48 dcook My 3.17 says "set null" as well 22:48 dcook Hmm 22:48 wizzyrea \o/ 22:47 dcook Same on a 3.14 upgraded from 3.8 22:47 wizzyrea YES that's exactly it then. new db's -> ok, upgraded ones -> bad 22:47 dcook "set null" instead of cascade 22:47 dcook 3.8 looks bad 22:47 dcook borrower's lists would be virtualshelves 22:47 wizzyrea virtualshelves 22:47 dcook patron lists isn't the right thing 22:46 dcook Ah, my bad 22:46 wizzyrea wonder when that was added. 22:46 dcook 3.14 looks ok 22:46 dcook No idea what patron_lists_patrons is.. 22:45 * dcook checks an older version.. 22:45 dcook for 3.17 22:45 dcook Yep, there's a cascade delete on borrowernumber for patrons_list 22:45 dcook Well, I can check the db right now for that 22:44 wizzyrea that's what I'm wondering, if the problem only manifests because older databases never got a cascade delete on upgrade, but new ones have it 22:44 dcook Crap...I don't have any records to test on.. 22:44 * dcook hasn't actually looked at the bug report 22:44 dcook If it's orphaning them, I imagine either there's a missing cascade delete in the DB or there's a code difference? 22:43 dcook Hmm, we're also using mariadb 22:43 wizzyrea another possible difference, I was testing on mariadb instead of mysql but... 22:42 dcook I should have a pristine database right here that I could quickly check.. 22:41 wizzyrea but another 3.12 does, but it was an upgrade one 22:41 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12838 minor, P5 - low, ---, fridolyn.somers, Needs Signoff , Deleting a borrower orphans that borrower's lists 22:41 dcook bug 12838 22:41 wizzyrea this ~3.12 era one doesn't seem to have the problem 22:41 wizzyrea on a pristine database, can you replicate 12838? Just realised that the bug may only be with upgraded ones 22:03 tcohen hola cait 21:54 cait hola 21:54 bag hola tcohen 21:51 wahanui bonjour, tcohen 21:51 tcohen hi 20:13 huginn 04Bug 7736: new feature, P5 - low, ---, colin.campbell, ASSIGNED , Edifact QUOTE and ORDER functionality 20:13 huginn bag: The operation succeeded. 20:13 bag @later tell ashimema heya ashimema do you all have any update on this http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7736 20:12 cait he shoudl have stopped working... 20:11 bag yeah I will @later thanks cait 20:11 cait bag: 21:00 here, he might have stopped working :) 20:08 huginn 04Bug 7736: new feature, P5 - low, ---, colin.campbell, ASSIGNED , Edifact QUOTE and ORDER functionality 20:08 bag heya ashimema do you all have any update on this http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7736 19:44 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12971 critical, P5 - low, ---, kyle, NEW , Printing member information lacks data 19:44 oleonard khall: Perhaps one solution to Bug 12971 would be to make it like slips: Have it use an html-formatted notice template? 19:10 cait he is probably happier that way :) 19:10 druthb Oh, no need for that, oleonard. wahanui has always been about half-mad. And doesn't seem to mind. 19:10 oleonard A term which comes from the film "Gaslight" which means doing stuff to make someone think they're going crazy 19:08 cait what? 19:08 * oleonard is gaslighting wahanui 19:05 wahanui :) 19:05 druthb wahanui: botsnack cookie 19:05 * druthb lols 19:04 wahanui oleonard is not really here. He said so. He did! 19:04 rangi heya oleonard 19:03 oleonard Hi rangi 19:01 khall np! 19:01 rangi ta 19:00 khall rangi: the current canonical source is https://bitbucket.org/libki-kms/ 19:00 rangi khall: is there somewhere other than libki.org i can get the code :) is the sourceforge git repo up to date? 18:55 druthb :) 18:52 cait druthb++ :) 18:48 druthb yah. In the box marked "Sex", they left of the "fe" at the first of the word… 18:47 barton goodness. 18:47 druthb yep. They left two very important letters off of my birth certificate, and it has taken me 46 *years* to get it fixed. 18:44 barton yeah bag, a birth certificate is definitely somewhere that you want to get the freaking spelling *right* ;-) 18:42 druthb thanks, bag! :D 18:42 bag freaking spelling 18:42 bag congrats on the birthcretifate change 18:41 bag hola druthb 18:40 druthb cait++ 18:39 jcamins barton: then stray no more! 18:36 bag cait: great news!!! 18:34 cait i got a bus ticket!! 18:27 barton heh. wrong window. 18:27 jcamins barton: they've been following the fold for 149 years. 17:53 barton what day did salvation army come on line? 17:42 larryb woohoo, debian.k-c.org is back online 17:41 cait do we have all the bugs linked to the main one? 17:40 oleonard svc/holds really spams the error logs... "Use of uninitialized value in string eq at svc/holds line 77" once for every hold 17:39 cait no chance now for the ticket :( 17:32 cait *grump* 17:32 bag ha oleonard that's funny 17:32 barton cait -- wow, why did they route the trains through the server room? ;-) 17:31 cait and it's my dad's birthday this weekend... and he told me yesterday to get a bus ticket 17:31 cait not sure that will work :( 17:31 oleonard cait: Ask gmcharlt to reboot it? 17:30 cait great.... train strike and now the website for the bus is dead :( 17:29 larryb bag, he says he can reboot it 17:29 larryb bag, I'm txting with gmcharlt now. He's still on the ground 17:25 larryb thanks 17:25 bag seeing if I can do that 17:25 bag yeah larryb I'd hop into #evergreen on freenode 17:24 larryb (sound of crickets chirping) 17:23 larryb hola equinox. does anyone here have access to the debian.k-c.org server? It may need a reboot. 17:23 bag phasefx: this is jason right? 17:23 bag larryb: there are equinox peeps here 17:22 larryb damn 17:22 bag ah there you go - larryb I think gmcharlt is on a plane to atantla 17:22 larryb according to the whois, the IP is registered to Equinox Software 17:21 bag Joubu: do you know who hosts debian.k-c.org? 17:21 bag ah no luck larryb cait is busy 17:21 cait still fihgting with booking a bus ticket... 17:21 cait sorry, have to read back later 17:21 bag cait++ 17:21 wahanui cait is probably happy about some example opacs :) 17:21 bag cait do you know? 17:21 bag maybe eythian controls that 17:21 larryb it appears to be down. 17:21 bag larryb: I think that's catalyst perhaps 17:20 larryb gmcharlt, do you have access to the debian.koha-community.org server? 17:20 larryb hello #koha 17:18 bag that's a pain eh 17:18 hbraum (because I have to maintain an offline backup…for 1 library) 17:18 bag heh hbraum - of course we shall see :D 17:18 gaetan_B bye! 17:17 hbraum not having to purge accountlines anymore will make me VERY happy. 17:17 hbraum well…our special purging…how’s that? 17:16 bag ummm heh - yes you do ;) 17:16 hbraum bag I can say that checkout IS much faster across the board…we may not even have to purge datatables any more! 17:15 hbraum bag I know :) I’ve been pulling along others as they’ve griped about it :) once I explain why that happened, and that it was part of the way to speed up checkout…people are much happier for now. 17:15 bag khall ^^^^ 17:14 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13196 normal, P5 - low, ---, oleonard, ASSIGNED , "Always show checkouts immediately" cookie should persist across sessions 17:14 oleonard Bug 13196 17:14 bag oleonard ^^^^ 17:14 bag hbraum: we have khall working on all those bugs :) we're going to bust our butts so that feature is nice and clean in 3.18 :) (backporting as much as we can too) 17:11 hbraum barton I just noticed that too. 17:02 barton can someone give wiki.koha-community.org a kick? 'tis hanging. 16:56 hbraum i’m admittedly not entirely happy about the setting…but checkouts are MUCH faster, so trying to live with it right now. 16:56 hbraum oleonard i just know what we’ve experienced with our libraries vs my computer. i don’t have the cache set to clear on chrome or firefox on my computer, and that always show setting holds, even when I have to log back in to Koha. But on all of our library computers, where the cache IS cleared on browser close, the libraries have to recheck that always show button on the next session 16:54 oleonard Based on the code I don't see how that can be true hbraum. The cookie is not set with an explicit expiration, so it is created as a session cookie. 16:48 hbraum oleonard we’ve found it’s set that way until you clear the browser cache….so if the cache is cleared on the browser closing, yep, it has to be set again after the next login. 16:41 oleonard Not the same definition of "always" that I work with 16:41 oleonard So it looks like "Always show checkouts immediately" option means "...until the next browser session" 16:31 huginn 04Bug 11944: major, P5 - low, ---, jonathan.druart, Passed QA , Cleanup Koha UTF-8 16:31 huginn bag: The operation succeeded. 16:31 bag @later tell gmcharlt http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11944 Is waiting for some feedback from you 16:22 reiveune bye 16:18 huginn 04Bug 12971: critical, P5 - low, ---, kyle, NEW , Printing member information lacks data 16:18 bag khall: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12971 16:17 ashimema I can't for the life of me get to it at the moment. 16:17 ashimema is anyone lese getting dns error for the wiki.. 16:17 huginn bag: Error: I have no notes for that nick. 16:17 bag @notes khall 15:38 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7904 enhancement, P5 - low, ---, colin.campbell, Needs Signoff , SIP modules handling of @INC is confused 15:38 ashimema bug 7904 15:37 huginn ashimema: The operation succeeded. 15:37 ashimema @later tell eythian Could you take a look at bug 7904 possibly.. I'd be interested to hear your view on how it may affect packages. 15:33 ashimema odd 15:33 ashimema hmm.. appears to just be me 15:33 ashimema is the wiki down? 13:10 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13194 trivial, P5 - low, ---, magnus, Needs Signoff , Tiny typo in POD for SetMessagingPreferencesFromDefaults 13:10 magnuse bug 13194 - easiest signoff evvah! 12:54 oleonard Hi #koha 12:50 fridolin hie all 12:31 Joubu cait: yep :) 12:28 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12851 normal, P5 - low, ---, jonathan.druart, In Discussion , order tags are not removed on claiming serials/orders 12:28 cait Joubu: i think we wrote a comment almost at the same time - bug 12851 12:27 cait hm hi tcohen... whenever you come back :) 12:24 tcohen hi cait 12:24 cait good morning tcohen :) 12:23 huginn tcohen: The current temperature in Cordoba Aerodrome, Argentina is 14.0°C (9:00 AM ART on November 04, 2014). Conditions: Scattered Clouds. Humidity: 36%. Dew Point: 3.0°C. Pressure: 30.11 in 1020 hPa (Rising). 12:23 tcohen @wunder cordoba, argentina 12:23 tcohen morning! 11:28 cait i think it's quite an evil one tho 11:27 khall ooh, that one is wicked difficult! I'll have to revisit it 11:26 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10382 critical, P5 - low, ---, kyle, Failed QA , collection not returning to null when removed from course reserves 11:26 cait bug 10382 11:26 khall sure! 11:25 cait khall: can I attack you with a bug fix wish? 11:24 khall morning cait! 11:24 cait morning khall! 11:23 khall mornin! 11:23 magnuse bonjour khall 10:49 cait well on the main repo, but not part of Koha is what i meant :) 10:49 cait and i alays want to use the most recent qa tool 10:49 cait becuse i am testing qa against various versions 10:48 cait I think i like it separate 10:47 ashimema thanks for the clarifications. 10:47 ashimema I see now... i was really getting wires corssed then.. 10:25 mtj Joubu: i mean merged into the koha.git repo - rather than hosted on the kc.org git server 10:22 Joubu mtj: it is: http://git.koha-community.org/gitweb/?p=qa-test-tools.git;a=summary 10:13 mtj people have mentioned that (at some stage) the qa-tool code might be merged into the koha repo itself 10:11 mtj ... but that was not what i was talking about before, (thats all) 10:10 mtj ashimema: fyi, i think getting the qa-tool to autorun on newly sumbitted patches is a great idea 10:08 mtj yep, thats it magnuse 10:01 magnuse i think mtj wants to add the line number feature, and is asking where he should be reporting that bug/enh? in bz or on github 09:58 ashimema just wondering as it sounds like an interesting idea :) 09:58 ashimema how does it relate to bz is my question.. 09:58 ashimema so your takling about he qa tool spitting out line numbers.. 09:58 ashimema It's for reviewing patches inline on bz.. 09:57 ashimema Sounds like you found it ;) 09:49 mtj basically, the ability for qa-tool to give line-numbers for its various errors 09:49 mtj ..that looks a bit different than what we are talking about here 09:48 mtj aah, ok 09:47 magnuse "Details | Diff | Splinter Review" 09:46 magnuse mtj: there is a link to the right of every patch on bz 09:46 mtj its something for bz? 09:45 mtj ashimema: btw whats 'Splinter Review',? i get no luck using google 09:44 mtj Joubu: i should take a look first - before i say how easy it will be! 09:42 mtj thanks for the explaination 09:41 mtj ...and see if i can make some improvements 09:41 mtj anyhoo Joubu... no need for you to explain to me - ill take a look myself 09:41 Joubu not sure :) 09:40 mtj we may get some false-positives, but thats worth it, for helpful line numbers 09:39 mtj but, yeah - it sounds do-able to compare the before/after errors 09:38 mtj sure, store them in a file - for starters? 09:38 Joubu I don't remember the structure we used 09:37 Joubu but maybe we can store them somewhere on the second pass 09:37 Joubu so the script removes the line numbers from the messages 09:36 Joubu we will warn it 09:36 Joubu but if the L1 is not L1 (the patches added/removed lines before the warn) 09:36 mtj so, we have a new YYY warn... 09:35 mtj *nod* 09:35 Joubu it's not a new one 09:35 Joubu we don't want to warn the XXX warning/error 09:35 Joubu we kept the error message (warn XXX at line L1 AND warn YYY at line L2) 09:35 Joubu after the patches applied, perl -wc file.pl 09:34 Joubu we kept the error message (warn XXX at line L1) 09:34 Joubu but quickly: we launch perl -wc (for instance) on file.pl, before the patches applied 09:34 mtj ok, no probs 09:33 Joubu hum, not sure I can explain you easily. 09:33 mtj perhaps i can fix that then 09:33 mtj hmm, really? but why not? 09:32 Joubu mtj: the problem is that we don't have the line numbers when we display le report 09:30 mtj so.. we should display that helpful info in the qa-tool's output 09:29 mtj i agree, its trival to find the line number of some errors 09:27 Joubu but if you think it's easy, go 09:26 Joubu mtj: not sure it's easy :) 09:26 Joubu mtj: it's quite trivial to find the line numbers, just run perl -wc and perlcritic and they will give us the ln 09:26 mtj some stuff will be easy, Joubu... like line numbers 09:26 ashimema that's what I use it for 09:26 ashimema Is that not what Splinter Review is for? 09:25 Joubu mtj: won't be easy to do 09:25 mtj that kind of stuff.. 09:25 mtj better descriptions of the FAILS, line numbers... 09:24 ashimema there are similar efforts out there though ;) 09:24 mtj Joubu: basically, more verbosity 09:23 ashimema rangi et al seems fairly set against moving too much workflow into github btw.. not being open soruce itself.. 09:23 Joubu what kind of stuffs do you want to add? 09:23 mtj ie; use bz's workflow to accept patches foe the qa-tool - rather than githubs issue-tracker 09:23 ashimema care to explain then? 09:22 mtj (just a suggestion) 09:21 mtj we can use github, but im suggesting to use bz instead 09:21 Joubu I think we can use github to do it 09:20 mtj no 09:20 ashimema integrating the qa tool into bz to autorun upon bug uploads or somthing like that? 09:20 ashimema What are you suggesting mtj... 09:18 mtj i understand its a bit more work... :/ but perhaps its worth it? 09:17 mtj perhaps the tool is critical enough now, that we should? 09:16 cait hi #koha 09:16 mtj Joubu: i was thinking of making some :) 09:16 Joubu mtj: Hi, why? :) I don't have a lot of request 09:15 bensinober we realize its 100% focus on qa and 3.18 now.. 09:15 bensinober please dont hesitate if you need us to test code or help in any other way 09:15 mtj hey Joubu, do you think we should start to use bugzilla for the qa-tool? 09:15 bensinober morning ashimema, still excited by the discussion on APIs from yesterday, we will continue on koha-restful but on the idea of migrating to Koha::Service in due course 09:14 mtj thanks for the links magnuse ^ 09:10 ashimema morning #koha 08:28 gaetan_B hello 08:07 huginn magnuse: The current temperature in Bodo, Norway is 2.0°C (8:50 AM CET on November 04, 2014). Conditions: Partly Cloudy. Humidity: 60%. Dew Point: -5.0°C. Windchill: -3.0°C. Pressure: 29.44 in 997 hPa (Rising). 08:06 magnuse @wunder boo 07:57 Joubu hello 07:57 alex_a bonjour 07:37 reiveune salut magnuse dcook and everybody 07:36 magnuse bonjour irma et reiveune 07:35 reiveune hello 07:28 magnuse mtj: https://metacpan.org/pod/Catmandu::Importer::XML -> https://metacpan.org/pod/Catmandu::Exporter::MARC 07:26 magnuse dcook: https://metacpan.org/pod/DBIx::Class::ResultSet#find_or_new ? 07:25 * magnuse waves at cait 07:25 * cait waves at magnuse 07:24 huginn magnuse: The operation succeeded. 07:24 magnuse @later tell bag HI 07:24 * magnuse waves 06:17 dcook Neato burrito in any case 06:17 dcook Identical content but there must be some difference... control characters or encoding or something... 06:14 dcook Interesting... I wonder how find_or_new works for DBIC... 06:08 dcook DBIC grrr 05:37 wajasu mtj: http://stackoverflow.com/questions/13317053/how-should-i-go-about-converting-xml-into-csv 05:32 wajasu mtj: maybe xmlstarlet can help convert your xml to csv http://www.joyofdata.de/blog/transforming-xml-document-into-csv-using-xmlstarlet/ 05:17 dcook Oh DBIC... 04:50 dcook Oh my... I didn't realize "update_dbix_class_files.pl" would refresh the whole thing... 04:39 dcook Yay! Now I can finally install Koha again... 04:37 dcook Hmm, probably not relevant to anyone else really.. 04:37 dcook fribidi? 04:36 dcook Had the fribidi package installed but not fribidi-devel 04:36 dcook Someone else figured it out for me :P 04:36 dcook Well, I lie 04:36 dcook I figured out my issue in the end as well 04:36 dcook :D 04:35 mtj i'll let you know how i get on 04:35 mtj hmm, ok - thanks for the suggestion guys 04:32 dcook That would also be heaps easy 04:32 dcook You could use LibXML to read the data and then write it out to a MARC::Record object 04:32 * dcook shrugs 04:32 mtj fwiw, ive played with xslt a bunch - i hate it 04:31 dcook XSLTs aren't that bad to write after you play around for a bit. 04:30 jcamins Eh. Well, find the MODS2MARCXML stylesheet that LC has. 04:29 wahanui mods is probably a zillion times more sane 04:29 jcamins mods? 04:29 wahanui hmmm... mods is a zillion times more sane 04:29 jcamins mods? 04:29 jcamins Well, yeah. If you want to take advantage of the structure of generic XML, there's no way around it. If you don't want to take advantage of the stucture, regular expressions would most likely be fine. 04:29 mtj do you know of any examples, using xslt, on the webs? 04:28 mtj jcamins: thanks for the reply 04:28 mtj i think i would have to write the xslt myself 04:27 mtj xslt sounds a bit... labour intensive 04:26 mtj ..but, i was curious if anyone else had a better way 04:26 mtj http://search.cpan.org/~sdowideit/AnyData-0.11/lib/AnyData.pm 04:26 jcamins Or, if the XML is actually equivalent to a CSV, use a regular expression. 04:26 mtj i've been using some homemade perl scripts, using anydata - with some success... 04:25 jcamins mtj: use XSLT. 04:18 mtj xml2csv.pl is an imaginary name of a perl script... that converts xml to csv 04:17 mtj so, if i can convert xml to csv - then i'm good 04:16 mtj but no workflow to convert xml to marc 04:16 mtj why?, i have a reliable workflow to convert csv to marc 04:15 mtj im looking thru this at the mo.. -> https://gitorious.org/koha-toolbox/koha-migration-toolbox 04:14 dcook Also, what's xml2csv.pl? :) 04:14 dcook Why would you want to do xml2csv? 04:14 dcook O_o 04:14 mtj hey, do peeps have a good suggestion for xml2csv.pl conversions, for koha 04:13 dcook I figured there would be an uproar if it didn't work on Debian ;) 04:13 dcook No worries :p 04:13 mtj sorry to torment you, dcook 04:10 dcook Oh, the perils of not using a Debian-based OS 04:10 mtj # apt-get install libtext-bidi-perl 04:10 dcook I figured it probably would on Debian :) 04:10 mtj seems to work ok on deb-stable, dcook 03:07 dcook Anyone else having issues installing Text::Bidi? 02:56 dcook Any FriBidi gurus around at the moment? 02:55 dcook Interesting...I can't install resolve some Perl dependencies when installing fresh... but it's not an issue when upgrading? :S 02:36 dcook Mmm, "oai_harvest" it is 02:35 dcook I guess we don't use CAPS so the last one is out 02:35 dcook "oai_harvest", "import_oai", "oai_queue", "OAIqueue" 02:34 dcook Wondering about terminology for this OAI harvester... 02:34 dcook I remember we had a custom Z39.50 thingo 02:34 dcook Hmm, definitely local then 02:34 * wizzyrea doesn't have that one 02:33 dcook And that's what I get for not using a clean DB 02:33 dcook Hmm, maybe that's a local thing 02:33 * dcook wonders what the "z3950queue" is... 01:59 wizzyrea \o/ 01:59 mtj (a bit off-topic) 01:59 mtj this looks interesting too... -> http://phantomjs.org/ 01:58 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12856 normal, P5 - low, ---, gmcharlt, Needs Signoff , koha-disable fails without disabling site 01:58 wajasu i'm going to plod through to test bug 12856 01:56 mtj yeah, good call wajasu - (or selenium) 01:56 wajasu maybe www mechanize ...? 01:55 mtj yeah, ive done that ok too 01:55 wizzyrea it seemed to work ok 01:55 wizzyrea i did, once, do an install of koha using lynx 01:54 wizzyrea nice for people to routinely check the web installer though 01:54 wajasu ok. 01:54 mtj would be a bummer to waste time testing on a glitched db :/ 01:54 wizzyrea that's what most people do 01:53 mtj that way, you know its correct 01:53 mtj probably saner to just do a web-install, then dump/load your db, for testing 01:51 mtj sysprefs, frameworks, branches 01:51 mtj youll be missing some stuff wajasu 01:49 wajasu i looked at the koha-upgrade-schema and it ran updatedatabase.sql and it only had 57 tables. so i ran mysqladmin ... < installer/data/mysql/kohastructure.sql first. 01:46 * dcook is also curious about how the DB works these days 01:45 wizzyrea I would hesitate on that, I'm not super clear (it's one of those things I should look into, honestly) on the details of how the database is built up these days, but it isn't as straight forward as it used to be as far as I can tell. 01:42 mtj hmm, but i dont think a default koha.sql exists in the repo - you might need to add one yourself 01:40 mtj yep, a thing to extend :) 01:37 mtj i guess its a oldish db - but can be updated with the koha-upgrade-schema script, after loading 01:36 wizzyrea hey, a thing to extend :) 01:36 mtj but, yeah - its a good start, afaik 01:35 mtj wizzyrea: populate-db does loads a default koha.sql file, but takes no options 01:33 wajasu this might be a quicker sandbox, since its using lxc. 01:33 wajasu i am runnign a laptop with wheezy amd64 and wheezy-backport linux kernel to get docker running. 01:29 dcook I occasionally think about learning more about building RPMS, but seeing as there are at least two different types of RPMs, I decided on a big nope 01:29 wajasu so i don't need a fakeroot, since i am in a docker root with a minimum debian squeeze. 01:28 wajasu once i tweak it, the pkg maintainer can take it and decide to run with it. i learned too much about package building. did not use pbuilder, but just dpkg-buildpackage. 01:26 dcook :/ 01:26 dcook Dinger, I wanted to do the Docker workshop at OSDC... 01:25 * wajasu time for dinner 01:24 wajasu gonna have to tweak and document this. will have to see if i can build ubunto too. 01:21 wajasu hooray! i built a koha package with passing tests. using docker! now i can build packages more easily, and test installs into fresh distributions more quickly. 01:13 wizzyrea it *seems* like it would do mostly what you're thinking of. 01:13 wizzyrea but I"m not sure what exactly it does. 01:13 wizzyrea well I mean I know you can 01:13 wizzyrea note I haven't tried it, can't you koha-create --populate-db <site> 01:12 dcook :) 01:12 dcook http://koha.1045719.n5.nabble.com/QA-Patches-with-database-changes-DBix-Class-td5779577.html 01:10 dcook Hmm, maybe I'll just find a sample patch for DBIC.. 01:09 dcook Or rangi maybe? 01:09 dcook tcohen, gmcharlt: I don't suppose either of you are around atm? 01:08 mtj ok, no probs 01:07 mtj i'm talking about a script to do the inital db configuration steps (that the web-installer currently handles) 01:06 dcook I don't use Debian at work, so I don't know much about the Debian scripts 01:05 dcook Probably :) 01:05 mtj koha-upgrade-schema assumes a pre-installed db, afaik 01:04 dcook Probably :) 01:04 mtj you could pass koha-create some args, or a config-file to make all the correct selections 01:03 dcook totes 01:03 mtj would be very handy to automate the initial web-install steps, from a script 01:02 * dcook just uses a clean db and dumps too usually 01:02 dcook Maybe not... maybe that's just for updates... 01:02 dcook mtj: I think that koha-upgrade-schema script works for Debian? 01:02 * dcook loves underdocumented CPAN modules 01:01 mtj its a bummer there is (afaik) no command-line equiv. of the web-installer 00:59 mtj (its what i do) 00:59 mtj ... other than prep a clean db, and dump it - for testing 00:58 mtj tho, having said that... i cant offer a better solution 00:57 dcook ^ 00:57 mtj ...you'll be missing some stuff from your db still 00:56 mtj hmm, i'm not sure that would work so well 00:48 wajasu found it. installer/debian/data/mysql/kohastructure.sql ;) 00:32 * wajasu trying 00:31 wizzyrea (for a package) 00:31 wizzyrea koha-upgrade-schema <site> 00:29 wajasu wanting to run the installer on the command line to get my db schema setup for t tests. i can't recall what script i can run. 00:04 dcook I guess that's an easy one to test 00:04 dcook Also trying to recall if we can import MARCXML into Koha... 00:01 dcook Trying to recall how to develop with DBIC when you're adding DB tables... :S