- Koha-devel - lists.koha-community.org

another usrlib.info note
by Pat Eyler 30 Apr '03

30 Apr '03

Art has added some great comments about xml and database mapping and has volunteered to do some work for us. It'd be good for interested developers to take a look at what he wrote (and the pointers to further information): http://usrlib.info/comments/2003/4/18/121844/847?pid=6#8 btw, he closed with the following: "Anyway, let me repeat that you and the rest of the koha folks are doing amazing work, it helps all of us when you show OSS is a valid option for even the trickiest of library systems." congrats to all of you. -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org

1 0

presentation opportunity
by Pat Eyler 30 Apr '03

30 Apr '03

If anyone is interested in heading to Sinagapore to talk about Koha, this may be your chance ... http://newsvac.newsforge.com/article.pl?sid=03/04/30/1534221 FIRST CALL FOR PAPERS Asian Enterprise Open Source Conference 2003 October 29th-31st, 2003 Singapore -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org

1 0

Re: [Koha-devel] z3950 support is in CVS & specific question
by Ingrid Lacis 30 Apr '03

30 Apr '03

Hi - I gave it a try. See bug 422. Ingrid > >For all those not following CVS commit... > >I've just commited MANY IMPORTANT things that MUST be tested... > >z3950 search and import seems to works fine. >Let me explain how : >* a "search z3950" button is added in the addbiblio template. >* when clicked, a popup appears and z3950/search.pl is called >* z3950/search.pl calls addz3950search in the DB >* the z3950 daemon retrieve the records and stores them in z3950results AND >in marc_breeding table. >* as long as there as searches pending, the popup auto refresh every 2 >seconds, and says how many searches are pending. >* when the user clicks on a z3950 result => the parent popup is called with >the requested biblio, and auto-filled > >Note : >* character encoding support : (It's a nightmare...) In the z3950servers >table, a "encoding" column has been added. You can put "UNIMARC" or >"USMARC" in this column. Depending on this, the char_decode in >C4::Biblio.pm replaces marc-char-encode by an iso 8859-1 encoding. Note >that in the breeding import this value has been added too, for a better >support. >* the marc_breeding and z3950* tables have been modified : they have an >encoding column and the random z3950 number is stored too for convenience >=> it's the key I use to list only requested biblios in the popup. > >************* >HOW TO TEST : >************* >* 1st, moddify a little your test-DB : >============================ >marc_breeding table must be : >----------------------------- >CREATE TABLE marc_breeding ( > id bigint(20) NOT NULL auto_increment, > file varchar(80) NOT NULL default '', > isbn varchar(20) NOT NULL default '', > title varchar(128) default NULL, > author varchar(80) default NULL, > z3950random varchar(40) default NULL, > marc blob NOT NULL, > encoding varchar(40) default NULL, > PRIMARY KEY (id), > KEY title (title), > KEY isbn (isbn) >) > >z3950servers must be : >---------------------- >CREATE TABLE z3950servers ( > host varchar(255) default NULL, > port int(11) default NULL, > db varchar(255) default NULL, > userid varchar(255) default NULL, > password varchar(255) default NULL, > name text, > id int(11) default NULL, > checked smallint(6) default NULL, > rank int(11) default NULL, > syntax varchar(40) default NULL >) TYPE=MyISAM; > >2nd, enter z3950 servers : >========================== >In France (an in French), I use : >INSERT INTO z3950servers VALUES ('bubase.univ-angers.fr', 210, 'ADVANCE', >'', '', 'ANGERS', NULL, 1, 1, 'USMARC'); >INSERT INTO z3950servers VALUES ('193.52.199.5', 21210, 'ADVANCE', '', '', >'LYON3', NULL, 1, 2, 'UNIMARC'); >INSERT INTO z3950servers VALUES ('138.231.48.2', 21210, 'ADVANCE', '', '', >'ens-cachan', NULL, 1, 4, 'UNIMARC'); > >3rd, launch "daemon" : >====================== >Open a console, go to koha/z3950/ and launch ./processz3950queue This >script should be launched by the daemon launcher, but it's a little bit >modified to loop every 5 seconds, without the SIG{HUP} method provided by >the true daemon. >You should see "starting loop" appearing every 5 seconds. > >4th, go to Koha : >================= >(CVS updated of course !) >* search for a biblio >* edit it >* look at the link "z3950 search" >* clic on it, the popup appear >* the popup auto-refresh. >* within 5 seconds, you should see log messages in the processz3950queue >console, telling that search begins/end... >* the popup should be filled with results. >* choose the biblio you want to "import", and... the popup disappear, and >the original biblio is updated with your z3950 record ! > >NOTES : >======= >1- This is alpha. Report bugs :-) >2- works only with ISBN in complete form at the moment (2-10-200014-1, not >2102000141) >3- If you experiment some strange accented characters, change your encoding >style for the server. (The sample servers works well for me) > >Please let me know what you experiment with this ! I would be happy to have >some success/failures before 1.9.3, which should occur on friday. > >*************** >SECOND QUESTION >*************** >Now, let's go for dinner, then bed-time... >And tomorrow, i'll work a little on a bulkmarcimport script :-) >bulkmarcimport will be used to migrate biblios from a previous ILS to Koha. >Nelsonville needs it, asked it, and nobody seems to be on the way to do it >! So i'll take care of it. >If you want me to do some tests for you, please send me a sample of a MARC >iso2709 file with ITEMS, and i'll use it for my tests. >PLEASE, if you send me one sample, send me a dump of a working marc >parameters table (USMARC ?) with it, or my tests won't work ! >Please (2nd) : if you send me a file, compress it, and no more than 50 >biblio (my mailbox is only 10MB !) > >-- >Paul POULAIN >Consultant indépendant en logiciels libres >responsable francophone de koha (SIGB libre http://www.koha-fr.org) > > > > >------------------------------------------------------- >This sf.net email is sponsored by:ThinkGeek >Welcome to geek heaven. >http://thinkgeek.com/sf >_______________________________________________ >Koha-devel mailing list >Koha-devel(a)lists.sourceforge.net >https://lists.sourceforge.net/lists/listinfo/koha-devel _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

1 0

[Bug 279] Import USMARC records
by bugzilla-daemon＠wilbur.katipo.co.nz 29 Apr '03

29 Apr '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=279 ------- Additional Comments From mwhansen(a)hmc.edu 2003-04-30 11:46 ------- What is the error that appears in your koha-error_log file? We need that in order to diagnose the problem. By USMARC, do you mean MARC21? ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 420] Modify category doesn't output category code
by bugzilla-daemon＠wilbur.katipo.co.nz 29 Apr '03

29 Apr '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=420 ------- Additional Comments From mwhansen(a)hmc.edu 2003-04-30 11:45 ------- I think the intention was that once you had a category, you would not want to accidentally change that category code (which would screw a lot of things up). If we really do want to be able to update the category code, reply to this and I will get that changed. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 419] Intranet homepage reports mouseover references non-existant reports
by bugzilla-daemon＠wilbur.katipo.co.nz 29 Apr '03

29 Apr '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=419 mwhansen(a)hmc.edu changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |LATER ------- Additional Comments From mwhansen(a)hmc.edu 2003-04-30 11:43 ------- I am not sure if those are going to be the only reports that will be included with 2.0. Plus, changing images is a bit more work than just changing text ;-] ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 421] Currency search page has wrong URL
by bugzilla-daemon＠wilbur.katipo.co.nz 29 Apr '03

29 Apr '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=421 mwhansen(a)hmc.edu changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 416] Nowhere to enter reserve fee amount mention on OPAC
by bugzilla-daemon＠wilbur.katipo.co.nz 29 Apr '03

29 Apr '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=416 Ilacis(a)chillco.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |INVALID ------- Additional Comments From Ilacis(a)chillco.com 2003-04-30 08:29 ------- I discovered where the reserve fees are set - in category administration. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

z3950 support is in CVS & specific question
by paul POULAIN 29 Apr '03

29 Apr '03

For all those not following CVS commit... I've just commited MANY IMPORTANT things that MUST be tested... z3950 search and import seems to works fine. Let me explain how : * a "search z3950" button is added in the addbiblio template. * when clicked, a popup appears and z3950/search.pl is called * z3950/search.pl calls addz3950search in the DB * the z3950 daemon retrieve the records and stores them in z3950results AND in marc_breeding table. * as long as there as searches pending, the popup auto refresh every 2 seconds, and says how many searches are pending. * when the user clicks on a z3950 result => the parent popup is called with the requested biblio, and auto-filled Note : * character encoding support : (It's a nightmare...) In the z3950servers table, a "encoding" column has been added. You can put "UNIMARC" or "USMARC" in this column. Depending on this, the char_decode in C4::Biblio.pm replaces marc-char-encode by an iso 8859-1 encoding. Note that in the breeding import this value has been added too, for a better support. * the marc_breeding and z3950* tables have been modified : they have an encoding column and the random z3950 number is stored too for convenience => it's the key I use to list only requested biblios in the popup. ************* HOW TO TEST : ************* * 1st, moddify a little your test-DB : ============================ marc_breeding table must be : ----------------------------- CREATE TABLE marc_breeding ( id bigint(20) NOT NULL auto_increment, file varchar(80) NOT NULL default '', isbn varchar(20) NOT NULL default '', title varchar(128) default NULL, author varchar(80) default NULL, z3950random varchar(40) default NULL, marc blob NOT NULL, encoding varchar(40) default NULL, PRIMARY KEY (id), KEY title (title), KEY isbn (isbn) ) z3950servers must be : ---------------------- CREATE TABLE z3950servers ( host varchar(255) default NULL, port int(11) default NULL, db varchar(255) default NULL, userid varchar(255) default NULL, password varchar(255) default NULL, name text, id int(11) default NULL, checked smallint(6) default NULL, rank int(11) default NULL, syntax varchar(40) default NULL ) TYPE=MyISAM; 2nd, enter z3950 servers : ========================== In France (an in French), I use : INSERT INTO z3950servers VALUES ('bubase.univ-angers.fr', 210, 'ADVANCE', '', '', 'ANGERS', NULL, 1, 1, 'USMARC'); INSERT INTO z3950servers VALUES ('193.52.199.5', 21210, 'ADVANCE', '', '', 'LYON3', NULL, 1, 2, 'UNIMARC'); INSERT INTO z3950servers VALUES ('138.231.48.2', 21210, 'ADVANCE', '', '', 'ens-cachan', NULL, 1, 4, 'UNIMARC'); 3rd, launch "daemon" : ====================== Open a console, go to koha/z3950/ and launch ./processz3950queue This script should be launched by the daemon launcher, but it's a little bit modified to loop every 5 seconds, without the SIG{HUP} method provided by the true daemon. You should see "starting loop" appearing every 5 seconds. 4th, go to Koha : ================= (CVS updated of course !) * search for a biblio * edit it * look at the link "z3950 search" * clic on it, the popup appear * the popup auto-refresh. * within 5 seconds, you should see log messages in the processz3950queue console, telling that search begins/end... * the popup should be filled with results. * choose the biblio you want to "import", and... the popup disappear, and the original biblio is updated with your z3950 record ! NOTES : ======= 1- This is alpha. Report bugs :-) 2- works only with ISBN in complete form at the moment (2-10-200014-1, not 2102000141) 3- If you experiment some strange accented characters, change your encoding style for the server. (The sample servers works well for me) Please let me know what you experiment with this ! I would be happy to have some success/failures before 1.9.3, which should occur on friday. *************** SECOND QUESTION *************** Now, let's go for dinner, then bed-time... And tomorrow, i'll work a little on a bulkmarcimport script :-) bulkmarcimport will be used to migrate biblios from a previous ILS to Koha. Nelsonville needs it, asked it, and nobody seems to be on the way to do it ! So i'll take care of it. If you want me to do some tests for you, please send me a sample of a MARC iso2709 file with ITEMS, and i'll use it for my tests. PLEASE, if you send me one sample, send me a dump of a working marc parameters table (USMARC ?) with it, or my tests won't work ! Please (2nd) : if you send me a file, compress it, and no more than 50 biblio (my mailbox is only 10MB !) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

discussion of our development plans
by Pat Eyler 29 Apr '03

29 Apr '03

I've posted some information about Koha post 2.0 to http://www.usrlib.info/story/2003/4/18/121844/847 There are some comments, suggestions, and questions popping up there. I'd encourage everyone to take a look and feel free to add their own comments. (Take a look around the site too, it's worth spending a bit of time at.) thanks, -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org

1 0