- Koha - lists.katipo.co.nz

Koha 3.00 on UBUNTU 9.04 (LIVE CD)
by Mohamed Megahed 17 Nov '09

17 Nov '09

Hi to all I want to know how to installation koha 3.00 on UBUNTU from CD LIVE i had finished download it but can not run it if any body know how to work send me the steps thnks _________________________________________________________________ Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail you. http://www.microsoft.com/middleeast/windows/windowslive/see-it-in-action/so…

1 0

Re: [Koha] Koha Digest, Vol 49, Issue 59
by Amir Seni 17 Nov '09

17 Nov '09

-----Original Message----- From: koha-request(a)lists.katipo.co.nz Sent: Monday, November 16, 2009 19:47 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 49, Issue 59 Send Koha mailing list submissions to koha(a)lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. koha 2.2.8 + ubuntu (Kete Jourge) 2. Re: koha 2.2.8 + ubuntu (Chris Cormack) 3. Re: Acquisitions Vendor addresses (Paul Poulain) 4. Mitali P (phmitali(a)gmail.com) has sent you a private message (Mitali P) 5. Re: Importing barrowing information - answer (Agnes Rivers-Moore) 6. Re: Barcodes on Label Batches (Davita Janto) 7. DBD driver has not implemented the AutoCommit attribute Problem (DIMITRIOS A. KOUIS) ---------------------------------------------------------------------- Message: 1 Date: Sun, 15 Nov 2009 16:23:59 -0800 (PST) From: Kete Jourge <activekete(a)yahoo.com> Subject: [Koha] koha 2.2.8 + ubuntu To: koha(a)lists.katipo.co.nz Message-ID: <880638.79245.qm(a)web111919.mail.gq1.yahoo.com> Content-Type: text/plain; charset="us-ascii" hi i'm tried to install koha 2.2.8 on ubuntu and i finished installation and can't open opac or intranet give me this page .. any help thank's Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, admin@root and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. ________________________________

1 0

Rebuild Zebra and production mode -- trapped fatal error
by Chadwick, John, DCA 17 Nov '09

17 Nov '09

First, I have seen the production mode - trapped fatal error message during some testing. We are now working on the production server. The error, at least when I have seen it, is generated when you try to get opac details for a biblionumber that doesn't exist. This has been resolved for us when we load records and rebuild the zebra indexes. Which brings me to a second thing I would like to share. I have an easy shell script I created to facilitate the process with no errors. We will be hosting a second Koha install which is why we are doing some custom locations for the file directories rather than the default directories. #!/bin/bash export PERL5LIB=/koha/bbmkoha/lib/ perl /koha/bbmkoha/bin/migration_tools/rebuild_zebra.pl -b -r -v 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. ______________________________________________________________________ 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 using Webroot Email Security. ______________________________________________________________________

1 0

Fines Calculation not working
by nitesh rijal 16 Nov '09

16 Nov '09

Hello all. I am using Koha 3.0.3 on Debian Lenny. I have set up a running library but I'm having problems with fine calculation. I have set the due date to 2008 and maximum days for fine to 5 days, yet it is not calculating the fine. Here is how my settings look like: [image: ?ui=2&view=att&th=124fc7cf00034d81&attid=0.1&disp=attd&realattid=ii_124fc7cf00034d81&zw] [image: ?ui=2&view=att&th=124fc7d19223ae11&attid=0.1&disp=attd&realattid=ii_124fc7d19223ae11&zw] [image: ?ui=2&view=att&th=124fc7d403041c0a&attid=0.1&disp=attd&realattid=ii_124fc7d403041c0a&zw] This is how my crontab.example looks like: ************************************************************************************************************************************************************************** > ** PERL5LIB=/home/liblime/kohaclone* > *KOHA_CONF=/home/liblime/kohaclone/etc/koha-conf.xml* > > *# Some additional variables to save you typing* > *KOHA_CRON_PATH = /home/liblime/kohaclone/misc/cronjobs* > *#* > *# MULTIPLE KOHA SUPPORT:* > *# You can still run jobs for this user's additional koha installs,* > *# by manipulating those variables in the command.* > *#* > *# For example, on the same codebase:* > *# */10 * * * * KOHA_CONF=/home/liblime/koha-test/etc/koha-conf.xml > /home/liblime/kohaclone/misc/migration_tools/rebuild_zebra.pl -b -a -z > >/dev/null* > *#* > *# For example, on a separate codebase:* > *# */10 * * * * KOHA_CONF=/home/liblime/koha-test/etc/koha-conf.xml > PERL5LIB=/home/liblime/koha-test > /home/liblime/koha-test/misc/migration_tools/rebuild_zebra.pl -b -a -z > >/dev/null* > *#* > *# ADDITIONAL INFO:* > *# See the perldoc of individual scripts to determine what other options* > *# are available. Check the man page for crontab to understand the* > *# schedule syntax for your system.* > *#* > *# NOTE: Don't forget to keep the empty line at the bottom.* > *# Cron/crontab will choke without it.* > *#* > *# SCHEDULED JOBS:* > *# m h dom mon dow command* > > *# OVERDUE NOTICES* > *0 1 * * * $KOHA_CRON_PATH/overdue_notices.pl -t* > > *# FINES* > *5 1 * * * $KOHA_CRON_PATH/fines.pl* > > *# ADVANCE NOTICES* > *10 1 * * * $KOHA_CRON_PATH/advance_notices.pl -c* > > *# PROCESS LONG OVERDUES* > *# updates item status from available to longoverdue for items long > overdue* > *# 19 1 * * * $KOHA_CRON_PATH/longoverdue.pl --lost 90=1 --confirm* > > *# SEND EMAILS* > *15 * * * * $KOHA_CRON_PATH/process_message_queue.pl* > > *# Hourly holds queue updated* > *52 * * * * $KOHA_CRON_PATH/holds/build_holds_queue.pl >/dev/null 2>&1* > > *# ZEBRA INDEX UPDATES with -z option, incremental index updates > throughout the day* > *# for both authorities and bibs* > **/10 * * * * $KOHA_CRON_PATH/../migration_tools/rebuild_zebra.pl -b -a > -z >/dev/null* > > *# services_throttle -- resets the xISBN service* > *59 23 * * * $KOHA_CRON_PATH/services_throttle.pl > /dev/null 2>&1* > > *# ROTATE LOGS* > *# Obviously, one needs logrotate(8) to do this* > *# 20 1 * * * /usr/sbin/logrotate -s > /home/liblime/kohaclone/var/run/zebradb/logstatus > /home/liblime/kohaclone/etc/logrotate.conf* > * *************************************************************************************************************************************************************************** What else should I do to get the fines working???? Please Help ------- Nitesh Rijal BE IT http://niteshrijal.com.np +9779841458173

2 1

Re: [Koha] Importing barrowing information - answer
by Agnes Rivers-Moore 16 Nov '09

16 Nov '09

Forwarded solution Agnes et Bernardo, Because I so greatly appreciated your help getting this off the ground, I decided to write up the steps I took to import the currently borrowed book information from my old filemaker database into issues. First step: The only useful information I had from my Filemaker database was the borrower's First Name and the Barcode number for the book he has checked out. (BTW, if you are working with Linux, you can install the 30 day trial of Filemaker 10 no problem with wine to export all your data into CSV files.) Once I exported the data, I opened up the file in a OOCalc, fixed the formating of names, looked for different versions of the same person etc. I saved it as a tab file, and opened it in a simple text editor. Then I made sure to find/replace and remove any enclosing " or ' around string data, and saved it with tab delimiters. Second step: open mysql (mysql -uroot koha -p) Create a tempory table that will contain data agglomerated from your old database and tables: issues, items, and borrowers: mysql> create table borrowtemp ( barcode int(11), firstname text, borrowernumber, itemnumber); Import your tab delimited values file into the table: mysql> load data local infile 'borrower.tab' into table borrowtemp; Now, update borrowers with any borrower names that have checked out books but haven't been added to "Patrons": mysql> insert into borrowers (firstname, categorycode, branchcode) select distinct borrowtemp.firstname, 'FRERE' as categorycode, 'RIM' as branchcode from borrowers inner join borrowtemp on borrowers.firstname != borrowtemp.firstname order by borrowtemp.firstname; (note, 'FRERE' is a category of Patrons that must already exist, and 'RIM' is the library code for a library which must already be created) Now that the Patrons (borrowers) is populated and have all been assigned a borrowernumber, you can update your borrowtemp with that information: mysql> update borrowtemp, borrowers set borrowtemp.borrowernumber = borrowers.borrowernumber where borrowtemp.firstname = borrowers.firstname; Now, before we can get the barcodes of the books checked out to borrowernumber, we have to grab the itemnumber corresponding to the barcode in items: mysql> update borrowtemp, items set borrowtemp.itemnumber = items.itemnumber where borrowtemp.barcode = items.barcode; Finally, the issues table can be populated with the borrowed books: mysql> insert into issues (borrowernumber, itemnumber, date_due, branchcode) select borrowtemp.borrowernumber, borrowtemp.itemnumber, date_add(CURDATE(), interval 8 month) as date_due, 'RIM' as branchcode from borrowtemp; (As you can see, I set the date_due to eight months from the current date, which you can change as you see fit - our old system did not have due dates! And of course, once again 'RIM' is the Library code.) Thanks again for your help! I hope this can help someone who finds themselves in a similar migration situation! -BFT On Tue, Nov 10, 2009 at 5:21 AM, Agnes Rivers-Moore <arm(a)hanover.ca <mailto:arm@hanover.ca>> wrote: Hi I'm afraid I can't help with MySQL. This all depends so much on what data you have in your old system, and how it is stored. There is a summary at http://www.kohadocs.org/migrating_to_koha.html, for a much older version of Koha but the principles and main tables are still relevant. Many more useful notes at http://wiki.koha.org/doku.php A diagram of the tables with the field names on http://wiki.koha.org/doku.php?id=en:development:dbschema:3.01 and see others on the wiki. However, it will be up to you how to decide which piece of data from your old system should be mapped to which field of the new one. When you have all your borrowers and books in Koha, you will need to identify borrower by barcode, extract the borrowernumber, identify the book, extract the itemnumber, and insert those to the issues table with some kind of due date. HTH Agnes Br. Francis Therese Krautter wrote: Thank you for the reply... The only information I need is to attach a patron's name, or the inverse to a barcode to show that they currently have the book. You are talking about the different tables - the idea seems ok conceptually, but I have no idea how to go about doing it - as I am brand new to koha and have very limited experience with mysql. I am just starting to get comfortable with the marc system, though I still seem to be importing values for something (other than state) which cause books to become "missing" or lost, when they are not. Maybe you could point me to the references I need in order to make some progress with the tables thing. Your aide is greatly appreciated! -BFT On Mon, Nov 9, 2009 at 12:43 AM, Agnes Rivers-Moore <arm(a)hanover.ca <mailto:arm@hanover.ca> <mailto:arm@hanover.ca <mailto:arm@hanover.ca>>> wrote: This is a fairly complicated process, it depends how much of the circulation data you hope to transfer. You can add some of it to the 952 field in a MARC record - this can accommodate fields such as $l (letter l) number of times borrowed, and $q due date of item if currently checked out. If you can tell where this information resides in your old system, you can write a script to insert it to the MARC records and them the bulk MARC import process will include that in the item details. However this does not tell you who has each item. That would need to be imported to the issues table, as Chris says, and link to the borrowers table for the details of the person who has the item. Issues link to the borrower table through 'borrowernumber' and to the items table through 'itemnumber', and needs data such as branchcode, issuingbranch, date_due, issuedate, and timestamp. There is also oldissues, which holds the history of all completed checkouts. HTH Agnes Br. Francis Therese Krautter wrote: > Hello, > > I am still working on importing data into koha. We have a rather > large database and I am trying to move it over, most of it has moved > so far, but one major importation I can't figure out how do is all the > currently borrowed books. I can't find a marc field or a koha > variable that looks like it contains this information. There are over > 1000 books currently checked out, I really don't want to have to do it > by hand! > > -BFT > ------------------------------------------------------------------------ > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > ------------------------------------------------------------------------ > > This email was Anti Virus checked by Astaro Security Gateway. http://www.astaro.com -- Agnes Rivers-Moore Assistant Librarian Hanover Public Library -- Agnes Rivers-Moore Assistant Librarian Hanover Public Library

1 0

Mitali P (phmitali@gmail.com) has sent you a private message
by Mitali P 16 Nov '09

16 Nov '09

1 0

Re: [Koha] Acquisitions Vendor addresses
by nengard＠gmail.com 16 Nov '09

16 Nov '09

Silly phone didn't reply to all. In the US they are 2 different things. Many businesses have a box at the post office for letter and bills and a physical address should you want to ship a package back to them. That said, labeling them differently shouldn't cause problems - but a librarian should answer Nicole ------Original Message------ From: Colin Campbell Sender: koha-bounces(a)lists.katipo.co.nz To: koha(a)lists.katipo.co.nz Subject: [Koha] Acquisitions Vendor addresses Sent: Nov 13, 2009 12:42 PM Hi, Acquisitions vendor addresses come in two variants "physical" and "postal" addresses. Confronted by these generates a lot of confusion in new users (A postal address is a physical address? When do we use one and not the other?) They are also stored differently in the table but presented similarly to the user in edit operations. I'm not clear what functional difference these addresses should have, but I'd like to switch to less misleading labels. Even 'address' and 'alternative address' would be an improvement. Looking to see if their any insights, opinions etc from anyone using (or looking to use) acquisitions. Colin -- Colin Campbell Chief Software Engineer, PTFS Europe Limited Content Management and Library Solutions +44 (0) 208 366 1295 (phone) +44 (0) 7759 633626 (mobile) colin.campbell(a)ptfs-europe.com skype: colin_campbell2 http://www.ptfs-europe.com _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha Sent from my Verizon Wireless BlackBerry

3 2

How to set mail receiving option in koha 2.2.9 ?
by K.Dinesh 16 Nov '09

16 Nov '09

Dear all, I am trying to implement an online library in my organisation using koha 2.2.9. I need to receive mail when an user reserves and also issued a book. i had set a mail server in the server. In Overdue list, there is a option of email which asks me to sign into either gmail or yahoo. Please any one help me in setting this. Thanks in advance. Note : koha 3.x currently i cannot use. so, please help me with koha 2.2.9 -- Regards, K .Dinesh

1 0

Re: [Koha] Barcodes on Label Batches
by Davita Janto 16 Nov '09

16 Nov '09

Yes seems like it's barcode scaling issues as I tried different templates and dimensions and they are all oversized and their position are always the same - outside the guide box and spilled out on the right hand side. See the attached. Is there a quick way to fix this or should it be reported as a bug? Cheers Davita. --- On Fri, 13/11/09, Chris Nighswonger <cnighswonger(a)foundations.edu> wrote: From: Chris Nighswonger <cnighswonger(a)foundations.edu> Subject: Re: [Koha] Barcodes on Label Batches To: "Davita Janto" <davita.janto(a)yahoo.com.au> Cc: koha(a)lists.katipo.co.nz Received: Friday, 13 November, 2009, 1:01 AM On Thu, Nov 12, 2009 at 4:06 AM, Davita Janto <davita.janto(a)yahoo.com.au> wrote: > > Thank you for your reply. Attached is the layout settings. > > I have also tried "code 39 + modulo43" and "code39 + modulo10" for Choose Barcoding Type column and "barcode only", "biblio only", "biblio/barcode", "alternating labels" for Choose Layout Type column and they didn't seem to change the barcodes' size or position. > "Patron cards" option for the Choose Layout Type has barcodes printed inside the guide box but when I use the option it's picking up the data from patron batches. > Amir is right. There are potential barcode scaling issues in the 3.0.x label code and may still be a few in the HEAD label code for that matter. The algorithm for scaling the barcode dimensions based on the label size is probably not correct for every label size. What are the dimensions of your labels and are you using the "profile" feature on your template? Kind Regards, Chris __________________________________________________________________________________ Win 1 of 4 Sony home entertainment packs thanks to Yahoo!7. Enter now: http://au.docs.yahoo.com/homepageset/

2 2

koha 2.2.8 + ubuntu
by Kete Jourge 16 Nov '09

16 Nov '09

hi i'm tried to install koha 2.2.8 on ubuntu and i finished installation and can't open opac or intranet give me this page .. any help thank's Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, admin@root and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. ________________________________

2 1