Time Nick Message 10:17 kados and in the msg I asked tumer about it 10:17 kados ok, committed 10:14 kados (based on reading in Biblio.pm) 10:14 kados (I think it is though) 10:14 kados we should ask tumer if marc_biblio is deprecated 10:13 kados in fact, I'm not 100% sure it's correct either 10:13 paul ok, I was not sure it was not something from me, I wanted to avoid breaking dev_week ;-) 10:13 kados maybe we should commit it :-) 10:09 cm yep, there's data in the iso2709 file now. now I can get on with the show. Thanks! 10:08 cm it's working. :D 10:06 cm ok 10:06 kados and it should work 10:06 kados select biblionumber from biblioitems order by biblionumber 10:06 kados use: 10:06 kados select bibid from marc_biblio order by bibid 10:06 kados instead of: 10:05 cm ok. 10:05 kados ok, all you need to do is change export.pl 10:05 cm at least something's in there. ;) 10:05 kados sweet 10:05 cm 4 rows. 10:04 kados (make sure you've got biblionumbers in the first place) 10:04 kados select biblionumber from biblioitems limit 4; 10:04 kados try this: 10:03 cm good. :) 10:03 kados just a sec 10:03 kados should be a pretty quick fix 10:03 cm yikes. 10:03 kados in dev_week 10:03 kados that marc_biblio is deprecated 10:02 kados I think the problem is 10:01 cm okay... 10:01 kados so basically, it calls NEWnewbiblio and NEWnewitem 10:00 kados hmmm ... 09:59 kados ahh ... just looking at bulkmarcimport 09:58 cm yep. empty set again 09:58 kados seems like maybe marc_biblio is empty :-) 09:58 kados select * from marc_biblio limit 3; 09:58 kados try: 09:58 kados interesting 09:58 cm empty set! 09:57 kados select bibid from marc_biblio order by bibid limit 3; 09:57 kados try this in mysql: 09:56 kados so that means that you're not getting a list of bibids 09:56 cm didn't give me any warnings. 09:56 kados yep 09:56 cm it's in there. try it again? 09:54 kados my ( $dbh, $bibid ) = @_; 09:54 kados right after the 09:54 kados warn "BIBID".$bibid; 09:54 cm sure 09:54 kados cm: can you throw a warn in MARCgetbiblio for me 09:53 cm yeah. 09:53 kados weird it's not working 09:53 kados well ... I've been passing it through MARC::File::XML and back 09:52 cm how do I do that? 09:52 cm nope, same diff. 09:51 kados so all your special characters will be mangled 09:50 kados otherwise, it'll be in MARC-8 format, and no browser understands that 09:50 kados I'd highly recommend transforming your data to utf-8 09:49 kados cuz it'll look in empty marc_subfield_table 09:49 kados yea, if you're using the old C4, it won't work 09:49 kados sounds good 09:49 cm lemme try it again, with perl -I /path/to/modules. 09:47 cm ah 09:47 kados 00264nam a2200109u 09:47 kados if they were utf-8 it would be: 09:47 kados your leader is 00264nam 2200109u 09:46 cm why wouldn't they be utf-8? 09:46 cm the minimality is expected...those are rotating collection ones, and they are pretty barebones 09:45 kados but that shouldn't affect export 09:45 kados s/no/not/ 09:45 kados and they're also no utf-8 encoded 09:45 kados well ... those are _very_ minimal records 09:45 cm thought so. 09:45 kados looks normal 09:45 kados yep 09:44 cm did you get it? 09:41 cm looks fairly normal, AFAIK. I'll email you the output. 09:39 kados see if it looks like valid MARC strings 09:39 kados select marc from biblioitems limit 3; 09:38 kados maybe try to do it manually 09:38 cm huh. yep, my Biblio.pm has that line. weird!! 09:34 kados so if you have biblioitems.marc data, it should work :( 09:33 kados pulls that raw data out, turns it into a MARC::Record object, and returns it 09:33 kados my $sth = $dbh->prepare("select marc from biblioitems where biblionumber=? " ); 09:33 kados it basically just does: 09:33 kados you'll see the MARCgetbiblio subroutine 09:33 kados if you look in C4/Biblio.pm 09:32 kados how strange 09:32 kados so the export runs, and finishes, and produces an empty iso2709 file ... 09:31 kados same date on mine 09:31 cm s'okay. I'll be back in a few. 09:31 kados sorry ... damn phone 09:27 cm kados: what's the creation date on your export.pl. Mine's March 31. I don't seem to have revision info in the file. 09:26 kados sec 09:25 cm no other errors. 09:25 cm but...now I have an iso2709 file, but it's empty 09:25 cm nevermind. didn't have records directory 09:23 cm No such file or directory at export/export.pl line 16. 09:23 cm i just got this: 09:22 kados seems to be working for me 09:21 cm ok. just a moment. 09:21 kados I'm trying it too 09:20 kados export/export.pl /path/to/zebradb/records/ccfls.iso2709 09:20 kados cd /path/to/dev_week/repo/koha 09:20 kados export KOHA_CONF=/path/to/koha.xml 09:19 kados try this (i know, you've probably done it before): 09:19 kados all export.pl does is run MARCgetbiblio 09:19 kados ok ... so now we need to figure out why you can't export it ... 09:19 cm i have data in biblioitems.marc 09:18 kados ie, that the MARC records are actually getting into Koha 09:18 kados cm: can you verify that when you do it that way, it's importing into biblioitems.marc? 09:18 paul ok, sorry 09:18 cm thanks, paul. I was wondering if there was a way to stop it from exporting into zebra. 09:18 kados but she's having trouble exporting the MARC 09:18 paul you'll get many many zbera errors, but no zebra time either ;-) 09:18 kados yep 09:17 paul cm : note that, if I don't mind, you just could stop zebrasrv & run bulkmarcimport without it. 09:16 cm hmm...I think that's what I was using. 09:14 kados cm: if you use the dev_week repo and koha.xml and a dev_week install (with MARC records in biblioitems.marc) it should work 09:14 paul ok. 09:13 kados paul: also the self-checkout is severely deprecated ... not even NPL uses it 09:13 paul ok, i'll take care of it then 09:13 kados paul: we didn't do a template/includes yet 09:13 cm I couldn't get export.pl to work. 09:13 kados paul: I checked with ryan and I was wrong 09:13 kados cm: should take about 4 hours tops 09:13 kados cm: you can import into zebra, then use export.pl to export the marc and index in zebra 09:10 paul you also once told me you had a self checkout somewhere. Am I missing something ? 09:10 paul you told me libLime did something about template/includes choosing in dev_week, but I don't remember seeing anything about that. 09:09 paul kados around ? 09:03 cm ok. I really need it to take less time. We have to migrate Meadville over a weekend. 09:02 paul you'll have to wait for kados answer ;-) 09:02 cm that would be *really* nice. :) 09:02 paul I don't know if it's done. 09:02 paul tumer & kados planned to have a system preference to commit just at the end of the bulkmarcimport. 09:01 cm yeah. without zebra it took about 3 hours 09:01 paul (zebra commit every time you import something & that's quite long...) 09:01 cm what do you mean? 09:01 paul isn't it a commit problem cm ? 09:00 cm kados: hi...zebra is working, but it seems that bulkmarcimport is going to take 3 days to import all our data now. :/ 08:45 owen So kados, what are we going to do about opac-main? 08:38 kados hehe 08:38 owen Did I missing anything by going home and sleeping? 08:38 owen Hi 08:38 kados morning owen 08:33 kados cm: any progress with zebra? 07:48 paul yep 07:48 kados paul: you around? 07:41 kyle It should work fine with any barcode scanners that already work with koha. 07:40 kyle It's just a new window with three tabs, check in, check out, and process (for uploading to koha). It stores the barcodes in a list box, until they are moved to an array. 07:39 kados I haven't had a chance to check it out yet 07:38 kyle It could sync with the server every morning. 07:38 kyle it doesn't *work* yet, but it does collect data. And I wouldn't mind some constructive criticism. Kados: how about having it store a list of debarred patrons, and perhaps reserves data. 07:37 kyle http://www.ccfls.org/koha/ 07:37 paul nope. 07:37 kyle thanks. Have either of you checked out the offline circulation extension yet? 07:36 paul (usually) 07:36 paul alaurin 07:35 kyle what is his IRC nick? 07:34 paul (it's arnaud laurin that works on fines, iirc) 07:34 paul and don't expect too many ppl before sept, 2nd or something like that 07:34 kyle more holidays ; ) 07:34 kyle I thought they were working on fines : ) 07:34 paul the only "problem" being that they are in holiday for instance. 07:33 kados :-) 07:33 paul hehe... I won ;-) 07:33 kados heh 07:33 kados you may want to check with SAN 07:33 paul kyle : if you have some time to solve this, you should bug the SAN 07:33 kados hmmm 07:33 kyle That is, a new version that only checks and processes a single barcode. 07:33 kyle kados: John & the librarians want fines calculated immediately upon a book being checked in. I figured I'd try to copy and modify fines2.pl to this end, and then a call to it could be made for it each time a book is checked in. 07:31 kados paul: good news 07:31 kados paul: no, I didn't see that 07:31 kados currently fines are calculated via a cron job 07:31 paul did you see that toins announced having a head search working with zebra (this morning) ? 07:30 kyle I was wondering what the current state of fines calculation was. 07:30 kyle hey paul. 07:30 kados hi paul 07:30 paul hi kados (& kyle) 07:30 kados kyle: yep 07:07 kyle kados: you around? 02:37 toins hi all ! 02:37 paul hi hdl 02:37 hdl hi paul and toins 17:31 chris cool 17:30 thd chris: When you become interested I can supply you with links to implementation documents. Reading the NISO standard is not enough. 17:28 thd chris: I guess it is not important if there was no issue about doing something with OpenURL but it does not have an elaborate formal query language. 17:27 chris it was just a throwaway remark 17:26 chris just talking about the format a form passes information to a cgi script as 17:25 thd chris: I was confused about the context or the reason it came up. 17:25 chris just mentioned it in passing 17:24 chris not really 17:24 thd chris: were you partially discussing OpenURL with kados yesterday? 17:22 chris partially 17:21 thd chris: are you there? 15:03 Burgwork right 15:03 kados Burgwork: ask owen, he's the interface guy :-) 15:02 Burgwork kados, cool. Anything else I can do to help on that? 15:01 kados hdl_away: ok ... thanks :-) 15:00 kados Burgwork: yea, owen's working on the template 15:00 hdl of course. 15:00 hdl koha-fr... 15:00 hdl kados : My wife is mad at me... So I will read you. (lurking here or by mail henridamien at koha dot org ) 14:59 Burgwork kados, are you in the middle of a rework of zoomopac? 14:58 kados I will check manual itemization now 14:58 kados ? 14:58 kados do I need to re-checkin for the fix to apply> 14:58 kados that's a previously checked in serial 14:58 kados http://opac.smfpl.org/cgi-bin/koha/opac-detail.pl?bib=59614 14:57 hdl And adding a manual issue itemization. 14:57 hdl 1140 : three LATEST serials should be shown in OPAC. 14:56 kados in the commit message it's 1144 adn 1140 14:56 kados hdl: can you clarify which bugs are fixed? 14:55 hdl Indeed, when you use a sub that creates a row into a table, one SHOULD ALWAYS return a value, an id so that we can use that for further progress. 14:54 hdl This comes from a missing codingguideline. 14:54 hdl But. 14:54 hdl A) To my mind it is not THAT stable a solution. (it uses LAST_INSERT_ID) and some time can pass and therefore this value can be mistaken. 14:53 hdl I should have warned that : 14:52 kados hdl: I'll update and test immediately 14:52 hdl kados : 1140 and 1145 should be fixed now. 14:45 hdl Atm, I am not sure Koha is supposed to be working only for mysql50. 14:44 hdl owen : mysql5.0.... 14:27 owen http://mysql.com/doc/refman/5.0/en/getting-unique-id.html ? 14:26 kados max(timestamp) maybe? 14:25 hdl kados : is there a mysql hack to get the id of the latest record created ? 14:20 kados hi hdl 14:12 hdl back 14:05 qiqo good morning 14:05 qiqo thanks 14:04 thd qiqo: http://www.gseis.ucla.edu/faculty/bates/ 14:04 qiqo thank you kados for the big help 14:04 qiqo i really appreciate your views 14:03 qiqo thakyou very much for the insights 14:03 qiqo ei i hafta sleep now 14:03 qiqo :) 14:03 qiqo ill be a librarian 14:02 thd qiqo: what is your job? 14:02 qiqo i really dont want to loose my job 14:02 thd qiqo: Read Marcia Bates. 14:01 thd qiqo: I expect that Google and other full text only systems like it will always be influential but I hope that a centuries of library systems are not lost on the next generation of information access tools that succeeds in the market. 14:01 qiqo it will help me in my thesis 14:01 qiqo ei thd thank you for that 13:59 qiqo let me log that 13:59 qiqo wow 13:59 qiqo hmm 13:58 thd qiqo: That is a function of the size of Google's index and not an indication that full text indexing is a more valuable technique than using a controlled vocabulary. 13:56 thd qiqo: The trouble is that since any arbitrary query is liable to find something in Google people assume that is always sufficient. 13:55 thd qiqo: Even the concept of fielded indexing and searching is almost completely lost on them. 13:54 thd qiqo: the real problem with Google is that it succeeded in the market where librarians failed. They merely index full text and do not understand or give any public showing of an interest in any other means of accessing information. 13:51 thd qiqo: If Google does not settle that lawsuit adversely, I hope they do not loose too much for everyone else in court. 13:48 thd qiqo: there is a chance that the lawsuit over the Google Books library programme will end in a bad way for everyone concerned with information except for the short term goal of giving a copyright holder maximum control over content restriction for cases that ought to be fair use under US law. 13:47 slef no more to libraries than the rest of the internet :) 13:45 qiqo do you think that google is big threat to libraries and librarians? 13:45 thd qiqo: that also 13:44 qiqo i mean without the restrictions? 13:44 qiqo ahh you mean relative to googlebooks? 13:43 thd qiqo: in the future library systems will find what you want to read for you instead of merely interpreting queries. 13:41 qiqo .. experts etc.. 13:41 qiqo i need to listen to insights of other people.. 13:41 qiqo the future of library systems.. trends etc.. 13:41 thd qiqo: I do not understand what you mean to ask? 13:41 qiqo its a 5 year plan 2006-2011 13:40 qiqo because my thesis is the Information Systems Strategic Plan of our College 13:39 qiqo i have a question,, what is your vision on library systems and library school 13:39 thd qiqo: UNESCO has always been underfunded in general but I suspect the effect of politics upon funding choices is more difficult over time. 13:38 qiqo hm 13:35 thd qiqo: it is likely to atrophy in favour of MARC 21 or UNIMARC in the face of free software systems supporting MARC. 13:35 qiqo unesco wont fund us anymore, they have been our partners for the longest period of time 13:34 qiqo last thing i heard, theyll be going opensource 13:33 qiqo ahh ok.. 13:33 thd qiqo: My understanding is that there is not enough investment in keeping ISIS up to date with improvements in electronic distribution of information. 13:33 qiqo did UNESCO abandon it? 13:29 qiqo but winisis is not doing well 13:29 qiqo BTW we are an authorized distributor of WINISIS here.. 13:28 qiqo we have a library course: B. Library and Information Science 13:27 qiqo it's UP... basically its the premier university 13:27 thd qiqo: good that you have public spirited publishers. 13:26 qiqo but still collection development would still be followed when it comes to honoring gifts 13:25 qiqo however,, some of the publisher here give copies to our library for free 13:25 qiqo only the national library has the rights to have a copy of anything published 13:24 thd qiqo: Does your library have a depository right to copies of anything published in the Philippines or does that right rest only with the national library? 13:23 qiqo http://ilib.upd.edu.ph/ 13:22 qiqo UP library is larger than our national library 13:21 qiqo The UP college of law library is the largest law library in asia 13:21 qiqo The University of the Philippines Main Library is the largest library in the Philippines containing millions of monographs.. 13:20 thd kados: USMARC evolved into MARC 21 with the convergence of CANMARC and others. 13:20 qiqo which is in java 13:20 qiqo but at our university. which is the University of the PHilippines, we programmed our own ILS.. 13:19 qiqo yes CDS ISIS 13:19 qiqo then some consolidated and formed MARC21 which part is US MARC 13:19 thd qiqo: There is no formal standards documents describing what is used at the Philippines national library? Are most Philippine libraries still using CDS/ISIS? 13:18 qiqo my professor told me that in the 60s or 70s almost all countries have had their own version of MARC 13:18 kados thd: you could tell us best, but isn't USMARC a subset of MARC21? 13:18 qiqo they still stick wit the traditional card catalog/aacr 13:17 qiqo most of the libraries here dont even know marc... hehe 13:16 qiqo they say that its a hybrid USMARC/MARC21 13:16 qiqo we really have no standard when it comes to mark.. 13:15 thd qiqo: do you have a quick link to the version of USMARC used in the Philippines? 13:15 kados thd: yea, forgot about that :_) 13:15 kados hehe 13:11 thd kados: even rocket engineers forget which units they are using in a dangerous way 13:10 owen I don't think rockets come into the picture until version 5 or 6 13:10 thd kados: as long as librarians are not building rockets we should be safe from the worst effects of a non-standard conception of standards 13:04 qiqo cool its 2am here 13:04 kados in Ohio it's 2:00pm 13:03 qiqo what is the time there? 12:59 qiqo i wont bother to use ranganathans colon classification if i only knew it hehe :) 12:59 kados where no standard is standardized :-) 12:59 qiqo haha 12:58 kados welcome to the world of libraries 12:58 kados :-) 12:58 qiqo and so he tells us that cataloguing in the philippines is not holistically based on LC's 12:58 kados yep 12:58 qiqo but according to my professor USMARC is different from MARC21 12:57 qiqo actually marc from the philiipines is same as USMARC 12:57 kados yep 12:57 qiqo yes,, specially with marc.. 12:57 kados qiqo: but a library system in the phillipines is quite different than a world-wide library system ... as katipo discovered with version 1 of Koha 12:57 qiqo its the phpmylib 12:57 Burgwork kados, I suspect is that the issue is small pool of people who a) are talented and b) are interested 12:57 kados qiqo: more power to him 12:56 kados thd: there is that 12:56 qiqo and he's earning a little from it 12:56 thd kados: there is also the possibility that a Koha foundation could be well funded. 12:56 qiqo hmm i really dont know,, a student from our university (still undergraduate) has created a library system 12:55 kados it's just one of those strange market things 12:55 kados and with library software, I can tell you, volunteers just don't cut it 12:55 kados I've been with the project for a while now 12:54 kados in the end, you either need to have libraries with staff pitching in development time, or libraries willing to sponsor development 12:54 qiqo hehe 12:54 kados as I suspect you're discovering with the barodes :-) 12:53 kados of course ... but being free is worthless if it doesn't work 12:53 qiqo as being stipulated on the site.. hehe 12:53 qiqo i would still stick with the original philosophy of koha: it should be free forever 12:52 qiqo ahh well 12:52 kados qiqo: simple economics :-) 12:52 kados qiqo: things don't stay free if there's no market to support them 12:52 kados qiqo: only if the community supports it 12:51 kados thd: thx 12:51 thd kados: you should have my message now 12:51 kados I'm ok with corporatization if it gets something done 12:51 qiqo i hope koha will be free forever 12:51 kados well more power to them 12:51 qiqo but too much corporatization 12:51 qiqo ah well it seemed to be a good distro 12:50 kados qiqo: haven't followed linspire much 12:50 kados qiqo: naw ... 12:48 qiqo have you seen the screenies? 12:48 qiqo anyway 12:43 qiqo hard sell? 12:43 kados slef: hard sell? 12:42 slef kados: are you short of customers? you seem to be giving qiqo the hard sell 12:42 qiqo hehe 12:42 qiqo basically its the free version of linspire foremerly know as lindows because they have been sued by microsoft 12:42 slef ta 12:42 qiqo www.freespire.org 12:42 slef url for freespire? 12:40 qiqo even library systems,, they cost too much 12:39 qiqo i really dont know why people here overcharge on the prices of notebooks 12:39 qiqo macbooks are way too expensive here 12:38 kados love it 12:38 kados yay ... I use a macbook as my desktop 12:38 qiqo i guess im going to have my macbook next week so i could just use that one for the inputs 12:37 qiqo because we only have one PC here for the library 12:37 qiqo i have to use one 12:36 kados none of my systems even have X installed :-) 12:36 kados I don't use the gui :-) 12:36 qiqo i really like the gui of freespire / a debian based distro 12:36 kados I've not tried it, but I imagine so 12:36 qiqo will it run on a freespire box? 12:35 dewey really are quite different 12:35 qiqo really? 12:34 kados yea, just use debian, everything works :-) 12:34 qiqo im using slackware... 12:34 qiqo actually i really suspect that its my operating system which makes my work hard 12:33 kados np 12:33 qiqo :) i really appreciate the big help 12:32 kados I'm a bit too busy at the moment to be of much help I'm afraid 12:32 qiqo okie.. 12:32 qiqo actually next week i will deploy koha as a marc entering tool for our computer laboratory 12:32 kados explain what you did, what the log error messages are, etc. 12:32 kados well, you could try your luck on the koha-devel list 12:31 kados cool 12:31 qiqo im a library science student 12:31 kados ahh 12:31 qiqo here in the philippines 12:31 qiqo for a non government organization 12:31 kados qiqo: what library do you work for? 12:31 qiqo ill still try to dig out 12:30 qiqo hmm 12:30 qiqo ohh.. 12:30 kados you could hire someone to fix your install :-) 12:30 kados working fine for me 12:30 kados well, don't know what else to tell ya 12:29 qiqo using mysqlcc 12:29 qiqo already did 12:29 kados using the labels sql in the barcodes dir? 12:29 qiqo yup 12:29 qiqo im using the new one based on the cvs i download 12:29 kados did you update the database? 12:29 qiqo yup 12:29 kados you are useing the new barcodes manager, not the old one? 12:28 qiqo already done the steps with the updating koha manual 12:28 kados qiqo: yep 12:28 qiqo anyone who could help me? 12:27 qiqo ermmm 12:26 qiqo i still cant make the barcode generator run efficiently though i already downloaded from cvs 12:25 dewey rumour has it there is a minor diff in <div>s, that I missed 12:25 qiqo kados: still there?