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

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

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

28 Apr '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=421 Summary: Currency search page has wrong URL Product: Koha Version: 1.9.2 Platform: PC OS/Version: All Status: NEW Severity: minor Priority: P2 Component: Parameters AssignedTo: paul.poulain(a)free.fr ReportedBy: Ilacis(a)chillco.com QAContact: koha-devel(a)lists.sourceforge.net /cgi-bin/koha/admin/currency.pl When you search on currencies the search goes to: /cgi-bin/koha/admin/<TMP_VAR%20NAME=script_name> ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

[Bug 207] Display of institutional member's info gives strange information
by bugzilla-daemon＠wilbur.katipo.co.nz 28 Apr '03

28 Apr '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=207 Ilacis(a)chillco.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|FIXED | ------- Additional Comments From Ilacis(a)chillco.com 2003-04-29 07:46 ------- Add institutional member (cgi-bin/koha/imemberentry.pl?type=Add) only asks for postal address not street address (which maybe different for some institutions like the company I work for)and for contact name it asks for a day phone number as opposed to just a phone number for the company. The real problems are on the membership record (cgi-bin/koha/moremember.pl? bornum=13) and update member details (cgi-bin/koha/memberentry.pl )which are the regular individual members forms. All the forms need to reflect an institutional member. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

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

28 Apr '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=420 Summary: Modify category doesn't output category code Product: Koha Version: 1.9.2 Platform: PC OS/Version: All Status: NEW Severity: minor Priority: P2 Component: Parameters AssignedTo: paul.poulain(a)free.fr ReportedBy: Ilacis(a)chillco.com QAContact: koha-devel(a)lists.sourceforge.net cgi-bin/koha/admin/categorie.pl?op=add_form&categorycode= Modify category doesn't output category code It used to output the code - but not in an updateable format. ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0

Re: [Koha-devel] Reserves
by Owen Leonard 28 Apr '03

28 Apr '03

I posted some questions about opac reserves the other day, and Paul answered some of them, but I'm still in the dark about others. The default template for opac-reserve.pl shows options for choosing 'reserve on this date' and 'end reserve on this date' values. But it doesn't look like those values are required, and even if they're specified, the data is entered into the database. Is this just old/unused stuff in the template? The vanilla template doesn't have those options. I wrote: > >It looks like a patron can't cancel or amend > their own reserves. Is there a > >place in the intranet for librarians to view > reserves (by title or patron), and > >make changes? I see in the vanilla template that patrons are advised to ask a staff member to cancel reserves. But I don't see in the intranet where a staff member would go to do that. Thanks, Owen Nelsonville Public Library Koha 1.9.2

2 1

Koha bugs changed in last 2 days
by chris＠wilbur.katipo.co.nz 25 Apr '03

25 Apr '03

31 bugs found. ID Sev Pri Plt Owner State Result Summary 130 nor P2 All paul.poulain(a)free.fr NEW Branch data entry form has unlabelled check box 169 nor P2 PC mwhansen(a)hmc.edu REOP dateformat not used anywhere 204 nor P2 PC chris(a)katipo.co.nz REOP Can't add organization member 218 nor P2 PC paul.poulain(a)free.fr REOP Home/street address not showing or showing postal address in 237 min P5 PC paul.poulain(a)free.fr NEW Can request to reserve a book with an end reserve date in t 254 nor P2 PC paul.poulain(a)free.fr REOP Next link goes to the wrong page 258 nor P3 PC paul.poulain(a)free.fr NEW Budget treats a comma as a period. 293 maj P5 PC paul.poulain(a)free.fr NEW Error Issuing Book - 1 338 min P2 PC paul.poulain(a)free.fr REOP Confirm record shows fields for info not output 353 min P4 PC paul.poulain(a)free.fr REOP Am unable to eliminate the GST charge 354 nor P1 All paul.poulain(a)free.fr REOP Acquisitions Link in Menu always goes to full (normal) acqui 375 min P3 PC chris(a)katipo.co.nz NEW When placing a reserve, item claims to have one reserve alre 394 nor P2 PC paul.poulain(a)free.fr NEW Reserve process doesn't require pickup branch 395 nor P2 PC paul.poulain(a)free.fr NEW Category Page Clean-up 396 min P2 PC paul.poulain(a)free.fr NEW Menu Bars - top and bottom should match 401 nor P2 PC paul.poulain(a)free.fr NEW Aquisitions - Incorrect instructions 402 tri P2 PC chris(a)katipo.co.nz REOP Opac - userupdate typos 404 nor P2 PC paul.poulain(a)free.fr NEW Confirm child page only has title - nothing else 405 enh P2 PC paul.poulain(a)free.fr NEW Guarantees do show name but just library card number 407 min P2 PC paul.poulain(a)free.fr NEW Shopping Basket - save changes button goes no where 408 nor P2 PC paul.poulain(a)free.fr NEW Shopping basket - nowhere to enter Authorised by 409 nor P2 PC paul.poulain(a)free.fr NEW Supplier Search Results - no staff output 411 min P2 PC paul.poulain(a)free.fr NEW Supplier ID referenced on Search page but shown no where 412 min P2 PC paul.poulain(a)free.fr NEW Sample data in members outputs "incorrect" data 413 min P2 PC paul.poulain(a)free.fr NEW Aquistion - Budget & bookfund money should line up on decima 414 nor P2 PC paul.poulain(a)free.fr NEW Order details - instructions aren't correct 415 nor P2 PC paul.poulain(a)free.fr NEW User flags work only partially 416 nor P2 PC chris(a)katipo.co.nz NEW Nowhere to enter reserve fee amount mention on OPAC 417 nor P2 PC tonnesen(a)cmsd.bc.ca NEW installer.pl wants root 418 min P2 PC paul.poulain(a)free.fr NEW Intranet home page needs to be updated to reflect only MARC 419 min P2 PC paul.poulain(a)free.fr NEW Intranet homepage reports mouseover references non-existant 31 bugs found. Long Format Query Page Enter New Bug Change columns Edit this query

1 0

Test of MJR's bugzilla summary script
by Chris Cormack 25 Apr '03

25 Apr '03

Hi All In a couple of minutes there should be a post coming to the list, which is me testing a script to summarise the bugs recently added at bugs.koha.org If it works, and people like it, let me know and ill set it up to run as a cron job. And switch off the devel list as the initial QA contact, thus reducing the traffic on the list. Much thanks to MJ Ray for this script. Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris(a)katipo.co.nz www.katipo.co.nz

1 0

Bugzilla summary for the last 3 days
by chris＠wilbur.katipo.co.nz 25 Apr '03

25 Apr '03

Bugzilla version 2.14.2 Bug List Sat Apr 26 12:42:59 NZT 2003 _________________________________________________________________ [1]We learn from history that we learn nothing from history -- George Bernard Shaw _________________________________________________________________ 34 bugs found. [2]ID [3]Sev [4]Pri [5]Plt [6]Owner [7]State [8]Result [9]Summary [10]130 nor P2 All paul.poulain(a)free.fr NEW Branch data entry form has unlabelled check box [11]169 nor P2 PC mwhansen(a)hmc.edu REOP dateformat not used anywhere [12]204 nor P2 PC chris(a)katipo.co.nz REOP Can't add organization member [13]218 nor P2 PC paul.poulain(a)free.fr REOP Home/street address not showing or showing postal address in [14]237 min P5 PC paul.poulain(a)free.fr NEW Can request to reserve a book with an end reserve date in t [15]254 nor P2 PC paul.poulain(a)free.fr REOP Next link goes to the wrong page [16]256 enh P2 PC paul.poulain(a)free.fr REOP Budget and bookfund order should be swapped in parameters. [17]258 nor P3 PC paul.poulain(a)free.fr NEW Budget treats a comma as a period. [18]293 maj P5 PC paul.poulain(a)free.fr NEW Error Issuing Book - 1 [19]338 min P2 PC paul.poulain(a)free.fr REOP Confirm record shows fields for info not output [20]353 min P4 PC paul.poulain(a)free.fr REOP Am unable to eliminate the GST charge [21]354 nor P1 All paul.poulain(a)free.fr REOP Acquisitions Link in Menu always goes to full (normal) acqui [22]365 tri P2 PC tonnesen(a)cmsd.bc.ca REOP On the parameters page, 'stopwords' appears twice [23]375 min P3 PC chris(a)katipo.co.nz NEW When placing a reserve, item claims to have one reserve alre [24]393 tri P2 PC paul.poulain(a)free.fr NEW Budget amounts should be lined up at decimal point. [25]394 nor P2 PC paul.poulain(a)free.fr NEW Reserve process doesn't require pickup branch [26]395 nor P2 PC paul.poulain(a)free.fr NEW Category Page Clean-up [27]396 min P2 PC paul.poulain(a)free.fr NEW Menu Bars - top and bottom should match [28]401 nor P2 PC paul.poulain(a)free.fr NEW Aquisitions - Incorrect instructions [29]402 tri P2 PC chris(a)katipo.co.nz REOP Opac - userupdate typos [30]404 nor P2 PC paul.poulain(a)free.fr NEW Confirm child page only has title - nothing else [31]405 enh P2 PC paul.poulain(a)free.fr NEW Guarantees do show name but just library card number [32]407 min P2 PC paul.poulain(a)free.fr NEW Shopping Basket - save changes button goes no where [33]408 nor P2 PC paul.poulain(a)free.fr NEW Shopping basket - nowhere to enter Authorised by [34]409 nor P2 PC paul.poulain(a)free.fr NEW Supplier Search Results - no staff output [35]411 min P2 PC paul.poulain(a)free.fr NEW Supplier ID referenced on Search page but shown no where [36]412 min P2 PC paul.poulain(a)free.fr NEW Sample data in members outputs "incorrect" data [37]413 min P2 PC paul.poulain(a)free.fr NEW Aquistion - Budget & bookfund money should line up on decima [38]414 nor P2 PC paul.poulain(a)free.fr NEW Order details - instructions aren't correct [39]415 nor P2 PC paul.poulain(a)free.fr NEW User flags work only partially [40]416 nor P2 PC chris(a)katipo.co.nz NEW Nowhere to enter reserve fee amount mention on OPAC [41]417 nor P2 PC tonnesen(a)cmsd.bc.ca NEW installer.pl wants root [42]418 min P2 PC paul.poulain(a)free.fr NEW Intranet home page needs to be updated to reflect only MARC [43]419 min P2 PC paul.poulain(a)free.fr NEW Intranet homepage reports mouseover references non-existant 34 bugs found. Long Format [44]Query Page [45]Enter New Bug [46]Change columns [47]Edit this query Actions: [48]New | [49]Query | Find bug # ______ | [50]Reports [51]New account | [52]Log in References Visible links 1. http://bugs.koha.org/cgi-bin/bugzilla/quips.cgi 2. http://bugs.koha.org/cgi-bin/bugzilla/buglist.cgi?bug_status=NEW&bug_status… 3. http://bugs.koha.org/cgi-bin/bugzilla/buglist.cgi?bug_status=NEW&bug_status… 4. http://bugs.koha.org/cgi-bin/bugzilla/buglist.cgi?bug_status=NEW&bug_status… 5. http://bugs.koha.org/cgi-bin/bugzilla/buglist.cgi?bug_status=NEW&bug_status… 6. http://bugs.koha.org/cgi-bin/bugzilla/buglist.cgi?bug_status=NEW&bug_status… 7. http://bugs.koha.org/cgi-bin/bugzilla/buglist.cgi?bug_status=NEW&bug_status… 8. http://bugs.koha.org/cgi-bin/bugzilla/buglist.cgi?bug_status=NEW&bug_status… 9. http://bugs.koha.org/cgi-bin/bugzilla/buglist.cgi?bug_status=NEW&bug_status… 10. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=130 11. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=169 12. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=204 13. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=218 14. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=237 15. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=254 16. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=256 17. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=258 18. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=293 19. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=338 20. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=353 21. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=354 22. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=365 23. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=375 24. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=393 25. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=394 26. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=395 27. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=396 28. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=401 29. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=402 30. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=404 31. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=405 32. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=407 33. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=408 34. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=409 35. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=411 36. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=412 37. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=413 38. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=414 39. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=415 40. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=416 41. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=417 42. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=418 43. http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=419 44. http://bugs.koha.org/cgi-bin/bugzilla/query.cgi 45. http://bugs.koha.org/cgi-bin/bugzilla/enter_bug.cgi 46. http://bugs.koha.org/cgi-bin/bugzilla/colchange.cgi?bug_status=NEW&bug_stat… 47. http://bugs.koha.org/cgi-bin/bugzilla/query.cgi?bug_status=NEW&bug_status=A… 48. http://bugs.koha.org/cgi-bin/bugzilla/enter_bug.cgi 49. http://bugs.koha.org/cgi-bin/bugzilla/query.cgi 50. http://bugs.koha.org/cgi-bin/bugzilla/reports.cgi 51. http://bugs.koha.org/cgi-bin/bugzilla/createaccount.cgi 52. http://bugs.koha.org/cgi-bin/bugzilla/query.cgi?GoAheadAndLogIn=1 Hidden links: 53. http://www.koha.org/

1 0

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

25 Apr '03

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=419 Summary: Intranet homepage reports mouseover references non- existant reports Product: Koha Version: CVS Platform: PC OS/Version: All Status: NEW Severity: minor Priority: P2 Component: Reports AssignedTo: paul.poulain(a)free.fr ReportedBy: Ilacis(a)chillco.com QAContact: koha-devel(a)lists.sourceforge.net cgi-bin/koha/mainpage.pl The mouseover over Accounts & Reports says: "All the system reports, webserver reports and financial reports." The only reports that I've seen are the till reconciliations for yesterday and today. Perhaps just write "Till Reconcilations" or "Reports" ------- You are receiving this mail because: ------- You are the QA contact for the bug, or are watching the QA contact.

1 0