- Koha - lists.katipo.co.nz

More encoding issues
by Chadwick, John, DCA 13 Dec '08

13 Dec '08

Quick question concerning the following wiki page on encoding: http://wiki.koha.org/doku.php?id=encodingscratchpad. Some of the information in the wiki seems to be more applicable to MySQL 4.1 instead of 5.x Also, some of the suggested changes to modify tables seem to refer to tables that are not in Koha 3.0.1. Specifically, there is no table called marc_subfield_table. There is a marc_subfield_structure. There is no abstract in the table biblioitems. -- Convert the database default encoding to UTF-8 and default collate to utf8 ALTER DATABASE kohawipofinal DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci; -- change the table encoding type (varchar -> binary -> varchar ) for MARC Data alter table marc_subfield_table modify subfieldvalue BINARY(255); alter table marc_subfield_table modify subfieldvalue VARCHAR(255) CHARACTER SET utf8; -- change the table encoding type (text -> blob -> text ) for Koha Tables alter table biblio modify title BLOB; alter table biblio modify title TEXT CHARACTER SET utf8; alter table biblio modify author BLOB; alter table biblio modify author TEXT CHARACTER SET utf8; alter table biblio modify unititle BLOB; alter table biblio modify unititle TEXT CHARACTER SET utf8; alter table biblio modify notes BLOB; alter table biblio modify notes TEXT CHARACTER SET utf8; alter table biblio modify seriestitle BLOB; alter table biblio modify seriestitle TEXT CHARACTER SET utf8; alter table biblio modify abstract BLOB; alter table biblio modify abstract TEXT CHARACTER SET utf8; alter table biblioitems modify abstract BLOB; alter table biblioitems modify abstract TEXT CHARACTER SET utf8; That should do it for now. John +----------------------------------------------------------------------- -----+ John Chadwick, Ed.D. Information Technology Manager New Mexico State Library 1209 Camino Carlos Rey Santa Fe, NM 87507 Phone: 505-476-9740 Cell: 505-629-8116 Fax: 505-476-9761 john.chadwick(a)state.nm.us http://www.nmstatelibrary.org Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.

1 0

loading serial holdings
by john 13 Dec '08

13 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 13 Dec '08

13 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 12 Dec '08

12 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 毛慶禎 12 Dec '08

12 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 12 Dec '08

12 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