- Koha - lists.katipo.co.nz

loading serial holdings
by john 12 Dec '08

12 Dec '08

I loaded a number of marc records extracted from our ILS into a test koha system. The item creation from 952 tags seems to go pretty well. But I have not been able to find documentation on loading serial holding statements, whether summary holdings from say an 866 field or more detailed marc holdings from 853/863 tagging? Any pointers to how to configure an incoming marc record for this? Thanks, John Rutherford

1 0

Re: [Koha] Koha Digest, Vol 38, Issue 38 koha search option
by Iago Lorenzo Salgueiro 12 Dec '08

12 Dec '08

Hi! I installed koha in Fedora 9 and I have sent the installation steps to the list two weeks ago. Now, I have the same problem that Sunita Barve, and I tested a solution posted in another message: in console, I go to the path: cd /path/to/koha/lib and I run the command: perl ../bin/migration_tools/rebuild_zebra.pl -b -a -reset all succesfull! my new elements appear in koha opac but the problem is that, the librarian (not I) can't do this manually every time he needs add new elements (MARC records). This process must be automatically, or with a 'koha intranet web-option', it's posible?? Iago Lorenzo Salgueiro -----Mensaje original----- De: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] En nombre de R N Pandya Enviado el: viernes, 12 de diciembre de 2008 5:23 Para: koha(a)lists.katipo.co.nz CC: sunitabarve(a)gmail.com Asunto: Re: [Koha] Koha Digest, Vol 38, Issue 38 koha search option Congratulations for installing KOHA on fedora. pl send me the installation steps. Probably you need to rebuild zebra to enable search in OPAC for newly added items. for changing default currency from $ to Rs. I think you need to modify few records in currency table in mysql. Ravindra Pandya IIMA ------------------------------ Message: 5 Date: Thu, 11 Dec 2008 03:54:54 -0800 (PST) From: sbarve <sunitabarve(a)gmail.com> Subject: [Koha] koha search option To: koha(a)lists.katipo.co.nz Message-ID: <20954056.post(a)talk.nabble.com> Content-Type: text/plain; charset=us-ascii I have installed koha on Fedora Core 7 OS. Can anyone help me to answer to the following questions. 1. I have added few records from z39.50 service in my database and have saved them. I have got record number 2 as well. But when I try to search the database I dont see any records in OPAC. How to make this in working. 2. When we add vendors in koha it selects only one currency for the vendor and its bydefault is $. Can we change this to Rs. or some other value. 3. Is there an extensive documentation available for koha. I am trying to find such documentation but I saw zip files and they are not very extensive. 4. How to set branch library. It asks only new library. I didnt find any branch library option. Thanks, Sunita Barve Library-In-Charge NCRA, Pune -- View this message in context: http://www.nabble.com/koha-search-option-tp20954056p20954056.html Sent from the Koha - Discuss mailing list archive at Nabble.com. ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 38, Issue 38 ************************************

2 1

MARC Framework
by Iago Lorenzo Salgueiro 12 Dec '08

12 Dec '08

Hi! I need do changes in the 'tags' of the MARC Framework. I do it in Koha-Intranet, and then I try to add a MARC record, but my changes don't work 'fully': - delete a 'tag' works - modify a 'tag' don't work - add a 'tag' don't work - I want use a 'tag' that already exist but not appear in 'Add MARC record', What I must do it? I try to rebuild de zebra-index (with bin/migration_tools/rebuild_zebra.pl -b -a -reset), all ok, but the changes don't work. What happen? Iago Lorenzo Salgueiro

1 0

Re: [Koha] Koha Digest, Vol 38, Issue 38 koha search option
by R N Pandya 12 Dec '08

12 Dec '08

Congratulations for installing KOHA on fedora. pl send me the installation steps. Probably you need to rebuild zebra to enable search in OPAC for newly added items. for changing default currency from $ to Rs. I think you need to modify few records in currency table in mysql. Ravindra Pandya IIMA > ------------------------------ > > Message: 5 > Date: Thu, 11 Dec 2008 03:54:54 -0800 (PST) > From: sbarve <sunitabarve(a)gmail.com> > Subject: [Koha] koha search option > To: koha(a)lists.katipo.co.nz > Message-ID: <20954056.post(a)talk.nabble.com> > Content-Type: text/plain; charset=us-ascii > > > I have installed koha on Fedora Core 7 OS. Can anyone help me to answer to > the following questions. > > 1. I have added few records from z39.50 service in my database and have > saved them. I have got record number 2 as well. But when I try to search > the > database I dont see any records in OPAC. How to make this in working. > > 2. When we add vendors in koha it selects only one currency for the vendor > and its bydefault is $. Can we change this to Rs. or some other value. > > 3. Is there an extensive documentation available for koha. I am trying to > find such documentation but I saw zip files and they are not very > extensive. > > 4. How to set branch library. It asks only new library. I didnt find any > branch library option. > > Thanks, > > Sunita Barve > Library-In-Charge > NCRA, Pune > -- > View this message in context: > http://www.nabble.com/koha-search-option-tp20954056p20954056.html > Sent from the Koha - Discuss mailing list archive at Nabble.com. > > > > ------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 38, Issue 38 > ************************************ >

1 0

imported bad marc record? or...?
by Ella Delaney 12 Dec '08

12 Dec '08

Has anyone encountered this who can provide guidance? A marc record I imported (marc 8, KOHA version 3) is irretrievable, rendering everything else in my catalog with those title words ("film" and "art") also irretrievable, and I can't remove it with the "manage staged..." tool. Here's the error message I'm getting when I try to search for it: Error: Can't call method "as_usmarc" on an undefined value at /usr/local/lib/C4/Search.pm line 2133. Ella Delaney Head Librarian Flashpoint Academy ella.delaney(a)flashpointacademy.com (312)506-0645

2 1

Koha 3.00.00 on Debian Sid - Install Report.
by Mahesh T. Pai 12 Dec '08

12 Dec '08

First, I am not subscribed, So any questions should be cc'ed to me. And apologies for cross posting - I cannot figure out which list this should be sent to. I got the system at around 6 PM last Saturday, and finished the job today (11th) morning - around 11 AM. OS install + Koha configuration took a mere 5 days. The OS installation was a battle, which ended only on Tuesday morning. I will not bother the list with details. Suffice it to say that the fault certainly was not Debian's. My ISP was corrupting the .iso files I was downloading. :-( The OS was Debian Sid/Unstable amd64 on a Intel D processor. That is all I needed to know about the hardware. Pristine install using debootstrap, and other packages added after rebooting from that install. Koha debian packages came from git.debian.org, (see the comments on http://blog.bigballofwax.co.nz/2008/08/05/koha-3-packaging/) "deb http://apt.workbuffer.org/ intrepid all" Is the line I had to add to /etc/apt/sources.lst. The packaging was buggy, but they got the dependencies right. Every dependency was fixed properly. The .debs failed to create sub directories under /etc/koha/ - a serious problem. I had to create the directories manually, and then do a "dpkg -i /var/cache/apt/archive/koha-<whatever>.deb" manually. Easy, eh?? It took me 3 days to sort out problems reaching the koha web-install page. I had the following lines in /etc/hosts 127.0.0.1 localhost library 127.0.0.2 librarian.koha 127.0.0.3 catalog.koha. "Catalog" is easier to remember than "OPAC", right? Since it was intended to be a stand alone system, I was tempted to leave out port 8080 part in apache2 configuration, but decided that the people who use it (there is a strong community of librarians here who are well aware of koha) may get confused with absence of 8080 in the URL. All the problems have been already reported on this (or -devel) lists, and googling was quick to give answers. But that it took 3 days means there were several problems. First was failure of the install scripts to put the table's names, user name, and password into the /etc/koha/koha-config.xml file. And there is some directive in koha-config.xml which put the "method to access the database as "sql". It ought to have been "mysql". Once this was sorted out, the catalog page would load, saying that the server is down for maintenance. But the web install refused to come up, complaining of some fatal error. This meant I had to manually install CGI::session from the tarball on cpan, as already mentioned in one of the lists. CGI::session I manually installed was same as the version in Debian. Guess this should go int INSTALL.debian file. Except the database configuration, I guess everything else in that file could be handled by debian installer, IMHO. Rounded off the install with a simple index page in /var/www/ with links to http://librarian.koha:8080 and http://catalog.koha. Further problems with the debian packages (snd some with koha itself). 1. Cid not create the cron jobs. (I did not realise it, till after I handed over the system. What are the consequences?) 2. I guess Debian packages does not create the appropriate files in /etc/init.d/ for the idzebra daemon. The koha-zebraqueue--ctl.sh is invoking the "daemon" binary, but debian uses start-stop-daemon binary. Hope things will run. I installed koha-idzebra-server package; not the koha-basic one. The work around was to NOT specify to use zebra for indexing. 3. What is the difference between marc21 and unimarc? Librarians would know it; but not poor souls like me, who would be doing the software installation. A description of both in the web installer would help; I chose marc21. 4. What happens if I abort the webinstaller? Some clues on the web installer pages would be nice. BTW, I did this free as in "free beer" for a friend of mine, at a law school with a mere 5K volumes. ;-) And I will write about the OS install elsewhere. -- Mahesh T. Pai || http://paivakil.blogspot.com REVOLUTION, n. An abrupt change in the form of misgovernment.

4 3

Error translate using tmpl_process3.pl
by projecto final 11 Dec '08

11 Dec '08

Hi, when i run the script tmpl_process3.pl it return "Create FAILED". I run "./tmpl_process3.pl create -r -i ../../koha-tmpl/intranet-tmpl/prog/en/ -s po/css_staff_pt_PT.po" inside misc/translation directory When i click enter i see on screen: "Warning: Can't determine original templates' charset, defaulting to UTF-8 Warning: Charset Out defaulting to UTF-8 Removing empty file po/css_staff_pt_PT.po I UTF-8 O UTF-8 at ./tmpl_process3.pl line 296." and after a while show "Create FAILED." Can someone help. tk's gonçalo

1 0

ISBD Default - Koha 3.01.X Manual
by 毛慶禎 11 Dec '08

11 Dec '08

Hi, ISBD Default setting at Koha 3.01.X Manual is for MARC21 only. Could someone post your UNIMARC setting for us? Welcome > Table of Contents > Administration > Global Preferences > Global Preferences: Cataloging > Cataloging: ISBD Default http://tinyurl.com/6mfssc or the longer one http://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/ad… -- Wishing you all the best. . . . Anthony Mao +886 2 29052334(voice) +886 2 29017405(fax)

2 2

Printing Receipts in Koha 3.01
by Nora Blake 11 Dec '08

11 Dec '08

Greetings all. We are a consortium of libraries using Koha 3.01 and one of my libraries is having trouble printing receipts. Whenever they print a circulation receipt they get an extra form feed at the end of the receipt, so the printer spits out another 12 inches or so of blank paper. Has anyone else experienced this problem and been able to fix it? Can you tell me how? The site is using a Star Micronics printer (I do not have the exact model information) with a generic/plain text driver. I would appreciate any help that anyone can give. NORA ________________________ Nora Blake MassCat Manager P.O. Box 241 South Deerfield, MA 01373-0241 Toll Free in MA: 866-MASSCAT (627-7228) Local Phone: 413-665-5511 Fax: 413-665-6776 Email: nblake(a)masscat.org Website: http://www.masscat.org AIM: vegancatwoman Skype: veganlibrarian Skype: nora.blake

2 1

Upgrading from 2.2 to 3.0, not so smooth...
by PasiK 11 Dec '08

11 Dec '08

We tried to upgrade our Koha system from 2.2 to 3.0. Installation went ok, but data-conversion failed completely. Here's the error-log from update22to20.pl: Adding textmessaging field to deletedborrowers table... DBD::mysql::st execute failed: Unknown column 'faxnumber' in 'deletedborrowers' at ./update22to30.pl line 3071. **Error : DBI::st=HASH(0x88f6500)->errstr altering borrowers zipcode to zipcode altering deletedborrowers zipcode to zipcode altering deletedborrowers homezipcode to B_zipcode DBD::mysql::db do failed: Duplicate column name 'B_zipcode' at ./update22to30.pl line 3104. removing some unused fields... alter or create notify_id in accountlines alter or create notify_level in accountlines alter or create accountno in accountlines alter or create booksellerid in aqbasket alter or create bookfundid in aqbookfund alter or create branchcode in aqbookfund alter or create id in aqbooksellers DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl line 3271. Error while executing: alter table aqbooksellers change `id` `id` int(11) NOT NULL PRIMARY KEY auto_increment at ./update22to30.pl line 3271. alter or create currency in aqbooksellers alter or create listprice in aqbooksellers alter or create invoiceprice in aqbooksellers alter or create invoicedisc in aqbooksellers alter or create bookfundid in aqbudget alter or create bookfundid in aqorderbreakdown alter or create ordernumber in aqorderdelivery alter or create currency in aqorders alter or create authtypecode in auth_header alter or create datecreated in auth_header alter or create origincode in auth_header alter or create authtypecode in auth_subfield_structure alter or create tagfield in auth_subfield_structure alter or create tagsubfield in auth_subfield_structure alter or create liblibrarian in auth_subfield_structure alter or create libopac in auth_subfield_structure alter or create authorised_value in auth_subfield_structure alter or create value_builder in auth_subfield_structure alter or create seealso in auth_subfield_structure alter or create kohafield in auth_subfield_structure alter or create frameworkcode in auth_subfield_structure alter or create authtypecode in auth_tag_structure alter or create tagfield in auth_tag_structure alter or create liblibrarian in auth_tag_structure alter or create libopac in auth_tag_structure alter or create authorised_value in auth_tag_structure alter or create auth_tag_to_report in auth_types alter or create summary in auth_types alter or create category in authorised_values alter or create authorised_value in authorised_values alter or create lib in authorised_values alter or create frameworkcode in biblio alter or create frameworkcode in biblio_framework alter or create frameworktext in biblio_framework alter or create itemtype in biblioitems alter or create dewey in biblioitems alter or create publicationyear in biblioitems alter or create collectiontitle in biblioitems alter or create collectionissn in biblioitems alter or create collectionvolume in biblioitems alter or create editionstatement in biblioitems alter or create editionresponsibility in biblioitems alter or create shelfname in bookshelf alter or create owner in bookshelf alter or create category in bookshelf alter or create cardnumber in borrowers alter or create surname in borrowers alter or create branchcode in borrowers alter or create categorycode in borrowers alter or create address in borrowers alter or create city in borrowers alter or create sex in borrowers alter or create branchcode in branches alter or create branchname in branches alter or create branchcode in branchrelations alter or create categorycode in branchrelations alter or create frombranch in branchtransfers alter or create tobranch in branchtransfers alter or create category_type in categories alter or create categorycode in categories DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl line 3271. Error while executing: alter table categories change `categorycode` `categorycode` varchar(10) NOT NULL PRIMARY KEY default '' at ./update22to30.pl line 3271. alter or create frameworkcode in deletedbiblio alter or create itemtype in deletedbiblioitems alter or create dewey in deletedbiblioitems alter or create itemtype in deletedbiblioitems alter or create branchcode in deletedborrowers alter or create categorycode in deletedborrowers alter or create B_zipcode in deletedborrowers alter or create zipcode in deletedborrowers alter or create address in deletedborrowers alter or create city in deletedborrowers alter or create surname in deletedborrowers alter or create streetnumber in deletedborrowers alter or create streettype in deletedborrowers alter or create sex in deletedborrowers alter or create borrowernumber in issues alter or create itemnumber in issues alter or create return in issues alter or create categorycode in issuingrules alter or create branchcode in issuingrules alter or create itemtype in issuingrules alter or create homebranch in items alter or create holdingbranch in items alter or create itemtype in itemtypes DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl line 3271. Error while executing: alter table itemtypes change `itemtype` `itemtype` varchar(10) NOT NULL PRIMARY KEY default '' at ./update22to30.pl line 3271. alter or create description in itemtypes alter or create summary in itemtypes alter or create marc in marc_breeding alter or create defaultvalue in marc_subfield_structure alter or create authtypecode in marc_subfield_structure alter or create tagfield in marc_subfield_structure alter or create tagsubfield in marc_subfield_structure alter or create authorised_value in marc_subfield_structure alter or create seealso in marc_subfield_structure alter or create tagfield in marc_tag_structure alter or create liblibrarian in marc_tag_structure alter or create libopac in marc_tag_structure alter or create authorised_value in marc_tag_structure alter or create frameworkcode in marc_tag_structure alter or create expirationdate in opac_news alter or create printername in printers alter or create printqueue in printers alter or create printtype in printers alter or create reservedate in reserveconstraints alter or create constrainttype in reserves alter or create branchcode in reserves alter or create planneddate in serial alter or create notes in serial alter or create branch in statistics alter or create datetime in statistics alter or create startdate in subscription alter or create histstartdate in subscriptionhistory alter or create enddate in subscriptionhistory removing some unused data... DELETE FROM userflags where bit = 8 synch'ing borrowers and deletedborrowers synch'ing items and deleteditems synch'ing biblio and deletedbiblio synch'ing biblioitems and deletedbiblioitems Updating publisheddate Checking for data required in table userflags... Checking for data required in table systempreferences... Checking for data required in table authorised_values... Adding row to authorised_values: authorised_value => Not enough budget lib => This book it too much expensive category => SUGGEST insert into authorised_values (authorised_value,lib,category) values (?,?,?)Checking for index required... Creating index borrowernumber in borrowers DBD::mysql::db do failed: Multiple primary key defined at ./update22to30.pl line 3408. Error alter table borrowers ADD PRIMARY KEY (borrowernumber) : DBI::db=HASH(0x885d484)->err Checking for foreign keys required... Creating foreign key items in accountlines Creating foreign key aqbookfund in aqorderbreakdown Creating foreign key biblio in aqorders Creating foreign key branches in borrowers Creating foreign key branchcategories in branchrelations Creating foreign key items in branchtransfers Creating foreign key items in issues Creating foreign key branches in items Creating foreign key branches in items DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`Koha/#sql-a58_52`, CONSTRAINT `#sql-a58_52_ibfk_5` FOREIGN KEY (`holdingbranch`) REFERENCES `branches` (`branchcode`) ON UPDATE CASCADE) at ./update22to30.pl line 3442. ==================== An error occured during : alter table items ADD FOREIGN KEY holdingbranch (holdingbranch) REFERENCES branches (branchcode) on update CASCADE on delete RESTRICT It probably means there is something wrong in your DB : a row (items.holdingbranch) refers to a value in branches.branchcode that does not exist. solve the problem and run updater again (or just the previous SQL statement). You can find those values with select items.* from items where holdingbranch not in (select branchcode from branches) ==================== Creating foreign key biblio in reserves Creating foreign key items in reserves Creating foreign key branches in reserves Creating foreign key bookshelf in shelfcontents DBD::mysql::db do failed: Can't DROP 'borrowernumber'; check that column/key exists at ./update22to30.pl line 3531. upgrade to Koha 3.0 done At the moment we are able to access Koha via browser, but there's nothing there. Ideas for fixing this? -- View this message in context: http://www.nabble.com/Upgrading-from-2.2-to-3.0%2C-not-so-smooth...-tp20933… Sent from the Koha - Discuss mailing list archive at Nabble.com.

2 2