Time Nick Message 10:48 kados :-) 10:48 paul 2.2.0RC1 will be here when you come back 10:48 paul no 10:47 kados I've got to head out for about an hour or so ... any other questions before I go? 10:46 paul should I remove npl templates from official release ? 10:45 paul another question : 10:42 kados :-) 10:42 paul I definetly don't remember... 10:42 paul or maybe it's to have a fresh & working install for later tests... 10:42 paul and auth_*_structure tables 10:42 paul it's to have your marc_*_structure 10:41 paul maybe 10:41 kados ok ... if you still need it let me know :-) 10:41 kados great! 10:41 kados let me know what it is and I'll do it 10:41 paul uploading Koha 2.2.00RC1 ;-) 10:41 kados stephen said you need a mysql dump? 10:40 paul yes 10:40 kados paul still around? 05:21 paul good evening 05:20 paul hello rach 21:32 tungsten thanks 21:31 chris so youd probably have to write one that makes a series of inserts into the borrowers table 21:31 chris because every system stores their borrower data differently 21:30 chris there is no koha tool for importing borrower data 21:29 tungsten what tool would you suggest 21:29 tungsten I can't at the moment think how to put all the nulls in between what I need but more importanly what I have data for 21:27 tungsten ok 21:27 chris changing the structure of tables will mean u will have to change scripts 21:27 chris yep thats fine 21:27 tungsten I'd end up with a ton of null defines 21:27 chris not really 21:26 tungsten rather than reor my data wouldn't be easier to get rid of every thing I don't need in koha? 21:26 chris i dont think those columns are used 21:25 tungsten http://www.cs.auckland.ac.nz/~ewan/koha/koha.mysql/borrowers.txt 21:25 tungsten I need around seven items to track not the or forty in the table 21:25 chris they do? 21:24 tungsten I see that borrowers have select,insert,update,references as priv 21:24 tungsten I'm ready to put patron data in 21:23 chris yes? 21:23 tungsten chris 20:40 chris no worries 20:40 kados thanks for the help chris 20:40 chris :) 20:39 kados now I'll need to package that in a nice <a href= and we've got a proof of concept :-) 20:39 kados http://66.213.78.101/cgi-bin/koha/opac-detail.pl?bib=147478 20:38 kados hehe I added the tmplvar and it worked: 20:36 chris ahh might have to make one, see if that works 20:35 kados I haven't checked but there's no WEB itemtype 20:34 chris is there a <TMPL_VAR NAME="url"> anywhere in the template? 20:33 chris might be just a template thing 20:29 kados hmmm, no errors 20:28 kados sigh ... add item type seems not to be working ... /me goes and checks the log 20:24 kados right 20:23 chris ull need the itemtype set up in itemtypes as well i guess 20:23 chris yep 20:23 kados biblioitem, right? 20:22 chris try making it itemtype='WEB' perhaps 20:22 chris that might do it 20:22 kados I didn't set the itemtype dou! 20:22 chris ahh what itemtype is it? 20:21 kados boy, adding that to the book bag would be interesting :-) 20:21 chris could be 20:21 kados but there's no url displaying is that a template problem? 20:21 kados that's one of the records (I used a reduced set) 20:20 kados http://66.213.78.101/cgi-bin/koha/opac-detail.pl?bib=147456 20:20 kados well it seems to have worked 20:19 chris :) 20:19 kados I forgot to reload mysql :-) 20:19 kados seems to have worked now 20:18 chris then mysqladmin reload 20:18 kados hmmm that's giving me an error 20:18 chris im old school and just go update db set lock_tables_priv='Y' where username='kohaadmin'; 20:16 chris or just grant lock_tables perhaps 20:16 chris that oughta do it 20:16 kados something like "Grant all on Koha to kohaadmin@localhost identified by ""; 20:14 chris u just need to jump into the mysql db and fix it 20:14 chris yep 20:14 chris and Install.pm doesnt give the kohaadmin user lock_tables priv 20:14 kados I may be able to fix it manyally in mysql table right? 20:13 chris C4::Biblio makes a lock tables call 20:13 kados ahh 20:13 chris its not setting the mysql privileges properly 20:13 chris in Install.pm 20:13 chris ahh this is a bug 20:13 kados DBD::mysql::db do failed: Access denied for user: 'kohaadmin@localhost' to database 'Koha' at /build/koha/C4/Biblio.pm line 332. 20:13 kados that's strange 20:06 kados thanks 20:06 kados ahh that's easy 20:05 chris then call newbiblioitem in C4::Biblio 20:05 chris and have url => "somethign" 20:05 chris so u make ur biblioitem ref 20:04 chris you can do it with newbiblioitems 20:04 kados do you know of a routine to do it or should I write one? 20:03 kados great ... thanks 20:03 chris ahh, biblioitem url 20:03 chris sup? 20:03 chris doing koha training for a new koha using library 20:02 kados chris are you still about? 19:35 JYL57 I already reused and learned from it in my work here 19:34 JYL57 yes owen, Paul has already proposed some pre-defined mapping I think 19:32 owen It's a real barrier to success for people trying out Koha for the first time 19:31 owen MARC mapping is a real pain. There must be an easier way to do it. 19:28 JYL57 Ok, he will surely answer me later... Thanks for your support 19:28 owen ...and Paul wrote that too 19:27 JYL57 But that doesn't seem to break the DB or block the import anyway... 19:27 JYL57 It's more related to existing koha intranet Check Marc function 19:27 JYL57 the problem isn't linked to the bulkmarcimport which is doing is job quite good now 19:26 kados JyL57: perhaps it's best to ask your question to the list ... paul would be your best bet since he wrote the bulkmarcimport script 19:24 JYL57 what do you mean chris ?! any idea ?! 19:23 kados I'm sure I'll have some questions :-) 19:23 kados thanks chris ... I'll see what I can hack together 19:23 chris right off to do koha training 19:23 JYL57 all fields of the items table in the mapping 19:22 JYL57 no problem Unimarc or marc21 should be treated same way by the control script 19:22 kados what is always linked to 995? 19:22 JYL57 It is always linked to 995 Tag 19:22 JYL57 I can copy here the Koha to Unimarc mapping ! 19:21 kados and it seems that perhaps your items fields aren't all mapped to the same tag ... 19:21 kados ok I think the 10 (items) tab will be in your marc mappings (on the KOha intramet) 19:20 kados hmmm 19:20 kados ok thanks 19:20 JYL57 That the copy from my IE browser ! 19:19 JYL57 OK itemtypes table filled with at least 1 value 19:19 JYL57 19:19 JYL57 and they must all be in the 10 (items) tab 19:19 JYL57 be mapped to the same tag, 19:19 JYL57 item fields ALL items fields MUST : 19:19 JYL57 OK itemnum : the field itemnumber is mapped to a field in tab -1 19:19 JYL57 Test Result 19:19 kados I don't know that screen too well ... 19:19 JYL57 the message is as said on the second line of the checkmarc screen 19:18 kados well there's always the list (might be better anyway since paul's not around ) 19:18 JYL57 Not that easily cause my proxy config fails to let ksirc working 19:17 kados s/print/paste/ 19:17 JYL57 I'm adjusting my mapping to Koha DB fields using bulkmarcimport 19:17 kados could you print the entire message? 19:17 JYL57 But what is the 10 tab 19:16 JYL57 1) be mapped to the same tag (995 I'm presuming...) 19:16 JYL57 ALL items fields MUST : 19:16 JYL57 items fields 19:16 kados that may help :-) 19:15 JYL57 Yes 19:15 kados do you have info on the ... ? 19:15 JYL57 What does it mean ?! 19:15 JYL57 The message says : '...must all be in the 10 (items) tab' 19:14 JYL57 Hello koha world, needing assistance for a 'MARC Check' message that I don't understand... 19:08 chris yep 19:08 kados and additional titles (it happens) 19:07 chris we'd probably want to get the additional authors in as well 19:07 chris $biblionumber = &newbiblio($biblio); 19:07 kados right :-) 19:07 chris } 19:07 chris author => $author 19:07 chris title => $title, 19:07 chris my $biblio = { 19:06 chris sorry it should be 19:06 kados I"m not quite groking that third line 19:05 chris thats pretty much how to get them into the db 19:05 chris $biblioitemnumber = &newbiblioitem($biblioitem); 19:04 chris just building some hashes 19:04 kados :-) 19:04 kados hmmm, a loopdeeloop 19:04 chris }; 19:04 chris ... 19:04 chris biblionumber => $biblionumber, 19:04 chris my $biblioitem = { 19:03 chris $biblionumber = &newbiblio($biblio); 19:03 chris author => $author, 19:03 chris title => $title 19:03 chris my $biblio = { 19:03 chris well we need to do something like this 19:03 kados so what scripts do you have already written? 19:01 chris sounds fine to me 19:01 kados I'm thinking of just adding on to that script and replacing the last while with our stuff ... sound good? 19:01 chris from various text files, into koha 19:01 kados http://www.gutenberg.org/feeds/rdf-parse-example.pl 19:01 chris i have written a few scripts to munge data 19:01 kados here's the parser script: 19:01 chris yep 19:00 kados so I reckon most of the routines are written in C4::Biblio ... 19:00 chris yep 19:00 kados yea the smallest spelling difs can screw things up :-) 18:59 chris ie "sometitle" matches these 3 biblios .. which one is it 18:59 chris im not sure how well it will work .. but if it logs what it does we can use that to figure out if we need to get it to prompt for human input too 18:58 kados now I get it 18:58 kados right 18:58 chris it just makes a biblioitem and attaches that 18:58 kados since we've only got title and author 18:58 chris so if the biblio already exists 18:58 kados well that may be easier than messing with marc 18:57 chris oh i was just thinking to write a script that will load into an existing db 18:57 kados why was it important to query koha first chris? 18:56 chris thatd work 18:56 kados and then importing into any marc21 koha using pauls handy bulkmarcimport 18:55 kados exporting in marc21 18:55 kados building biblio and biblioitem 18:55 kados cause if we do I'm thinking of just starting with a fresh database 18:55 kados do we have a marc21 export function? 18:53 chris but its probably best to query koha with the title to see if it exists 18:52 chris now if we wanted to we could just build a biblio and biblioitem and use the routines in C4::Biblio to get them in 18:52 chris joshua: yep 18:51 kados where the top line (or variable) is the etext number and we can easily build a url string from that ... 18:51 chris right 18:51 owen Maybe that's too much work, though. The trouble is that MARCdetail.pl buries the individual tag data in a bunch of loops so you can't access the 245 tag directly. 18:51 kados author: Sewell, J. W. (James Witt) 18:51 kados author: Baskervill, W. M. (William Malone) (1850-1899) 18:51 kados title: An English Grammar 18:51 kados 14006 18:51 kados it's coming out as : 18:50 kados so chris any thoughts on how best to insert the data into Koha? 18:50 owen What I was trying to do was get biblio.title to show up in MARCdetail.pl, so I was trying adding the bibdata() subroutine. 18:50 chris sweet joshua 18:49 chris yep 18:49 owen I guess it was the $dat (rather than the %dat) that was throwing me off in the first place. 18:49 chris it just means perl has to work harder 18:49 chris so its not any harder for the programmer 18:49 chris and we could get to the elements as $dat{'addiotional'} note the no -> (thats a dereference) 18:48 chris my %dat=bibdata($biblionumber); 18:47 chris and then line 47 would look like this 18:47 chris youd go return (%hash); 18:46 owen And to pass the whole hash around you'd have to specify each element like $dat->{'additional'} = "something", etc. 18:46 chris we could just return the hash if we wanted 18:46 chris and then return a reference to it 18:45 chris so in the bibdata subroutine, we will create a hash, populate it 18:45 chris past=pass 18:45 chris sorta, we could pass the whole hash around .. but its more efficient to just past the address of where it lives in memory (the reference) instead 18:44 owen So the hash itself is a bunch of stuff in memory that can't be talked about (in its entirety) except through a reference 18:43 chris i hope that is some help, rather than just more confusing :) 18:43 chris $dat->{'additional'} 18:43 chris eg 18:43 chris then we can dereference it, to get the data 18:41 chris so we pass something that points (references) that hash instead 18:41 chris we dont want to have to pass that around between subroutines 18:41 chris which might be quite big 18:41 chris so we might have a hash 18:40 chris i think of them as a variable that points to something 18:40 chris they are like pointers in C .. if that helps 18:40 owen Not well enough :) 18:40 chris do you understand references owen? 18:39 chris it was a reference to a hash 18:39 owen ...and before it wasn't an array, it was a hash? 18:39 chris expects to be passed a reference to an array 18:39 chris this is because a <TMPL_LOOP in html::template 18:38 chris and making $dat be the first item of the array 18:38 chris well its making an array results 18:38 chris pretty much yep 18:38 owen What is going on here? Some kind of conversion between two different kind of structures? 18:38 chris yep 18:37 owen Then further down it says: my @results; $results[0]=$dat; 18:37 chris yep 18:36 owen Can I ask a Perl question? I'm looking at detail.pl, line 47: my $dat=bibdata($biblionumber); 18:36 kados it installed find on my sarge machine ... strange 18:32 chris thats helpful :) 18:32 kados nope 18:31 chris do they tell you what version works? 18:30 kados hehe 18:30 kados Don't send patches! 18:30 kados Don't report errors!!! 18:30 kados Don't expect XML::LibXML to build or work correctly. 18:30 kados 18:30 kados The installed version was tested and prooved not as stable 18:30 kados 18:30 kados The installed version of libxml2 is known not to work. 18:30 kados perl -MCPAN -e install XML::LibXML 18:30 kados hehe 18:19 chris im sure my wife would absolutely love a resource like that, for when she is teaching art history 18:18 chris tis true 18:18 owen Sure. The trouble with my idea is that most everything is owned by institutions that want to profit from the reproduction of that art. 18:16 chris hmm ones out of copyright .. like an art version of project gutenberg? 18:14 chris :) 18:14 kados chris: yea I did see that (and I'm subscribed ;-)) good idea ... 18:12 chris joshua, did you see there is an rss feed from project gutenberg with the recently added books .. so we could set up a cron job to fetch that and load the data every couple of days .. (after we do the initial population) 17:58 kados huh I'm getting 80% packet loss ... something's up 17:56 kados huh ... my script is saying that it's down ... 17:56 owen If it was down you'd know because I wouldn't be able to answer :) 17:55 owen Crawling. 17:55 kados owen is your internet down? 17:54 kados yea that's about as far as I got last time I looked at things 17:54 chris well, i downloaded the rdf and the parser script and thought about how to do it, but havent done anything yet 17:53 kados I'll get to it then 17:53 kados righto 17:53 chris nope not yet 17:53 kados I could do some this afternoon if chris hasn't 17:53 kados I haven't worked on Gutenberg yet has chris? 17:53 owen yes 17:52 kados owen still around? 17:52 kados hi everyone 17:50 rosa Hi 17:49 rach morning rosalie 17:49 rosa Chris, even 17:49 rosa morning CHrias 17:47 chris morning rosalie 17:01 owen chris, did you find out if Joshua had done any work on the Gutenburg idea? 16:46 rach hi tim 16:46 tim Hi everyone 16:46 rach that is true 16:45 rach she doesn't like the nail guns, and is being a big scardey pants 16:45 rach my big dog olive is helping me type this mroning 16:43 chris just dogs 16:43 owen chirs must have builders too :) 16:43 chris morning all 16:42 rach so not sure yet if I'm live 16:42 rach ah right :-) 16:40 rach and paul and all :-) 16:40 rach hi owen & tim 16:40 owen hi rach, hi tim