- Koha - lists.katipo.co.nz

Re: [Koha] Patron import
by Nicole Engard 13 Feb '11

13 Feb '11

Ann, I have used Excel without problems before ... I'm including the list in the reply in case others have an idea. Nicole On Sun, Feb 13, 2011 at 4:12 PM, Ann Murphy <amurphy(a)katikaticollege.school.nz> wrote: > Hi Nicole > Thanks for your reply. I downloaded the .csv file, opened it in Excel and > copied and pasted the data under the relevant headings. My techie wants to > know if the problem is in Excel. I am off to use BBEdit to see if that > solves my problem. > > Cheers > > On Mon, Feb 14, 2011 at 9:13 AM, Nicole Engard <nengard(a)gmail.com> wrote: >> >> Ann, >> >> My first question would be - do you have a header row? The import >> patron tool in Koha and the manual both show you what the header >> should read. That error says that it understand the header row in >> your file which makes me think that you don't have one. >> >> Nicole >> >> 2011/2/12 Ann Murphy <amurphy(a)katikaticollege.school.nz>: >> > Hi Everyone >> > Our school has installed Koha as our LIS and I think I have a handle on >> > migrating the data. However I am >> > totally failing to understand the import patron process. Can someone >> > point >> > me to more comprehensive instructions than the Koha manual. >> > >

1 0

Re: [Koha] commonInfo.abs
by Thomas Krichel 11 Feb '11

11 Feb '11

Robin Sheat writes > sudo -u "library-koha" -H env PERL5LIB="/usr/share/koha/lib/" > KOHA_CONF="/etc/koha/sites/library/koha-conf.xml" /usr/share/koha/bin/migration_tools/rebuild_zebra.pl -a -b -r -v Setting the KOHA_CONF enviroment sorted out my immediate issue. > where this presumes that you created a library called 'library'. But these words suggested to me I had probably veered off the path that the righteous take to salvation. So I started again and used the Debian/koha way as much I could figure out how to do. I believe it was a success, zebra works on my installation to find bib items. After two days of sweat, here is a report on how easy it actually is http://openlib.org/home/krichel/courses/lis9012/doc/koha_installation.html You and Lars have done a phantastic job but it is less than phantastically documented. The page above is my humble attempt to contribute something that common mortals can follow. I will try to unleash this on a bunch of MSLIS students on Saturday. I will probably find some more things to tweak on the page. Thanks and cheers, Thomas Krichel http://openlib.org/home/krichel http://authorclaim.org/profile/pkr1 skype: thomaskrichel

4 6

label PDF encrypted and requires password
by masabai 11 Feb '11

11 Feb '11

Running a new setup of Koha 3.2 on Ubuntu 10.10. When I try to export a batch of labels and download as a .pdf it is opened or downloaded as encrypted and requires a password...which I don't have! any help greatly appreciated. masabai @ My Library Luang Prabang, Laos www.thelanguageproject.org

1 1

Converting to Koha
by Sue McMillan 10 Feb '11

10 Feb '11

Hello everyone, South Taranaki District Libraries are converting to Koha next month. We are really excited about the move and see it as a positive step forward. We are wondering if anyone has a test plan they used when converting that we could use as a starting point for developing our own test plan. Any advice or tips would also be welcome. Regards Susan McMillan Acquisitions and Systems Librarian South Taranaki District Libraries 06 278 0555 or freecall 0800 111 323 ext 8706 ,sue.mcmillan(a)stdc.govt.nz http//:www.southtaranaki.com This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorised and may be illegal. Please note that this communication does not designate an information system for the purposes of the Electronic Transactions Act 2002. <p><b>CAN'T OPEN ATTACHMENTS?</b></p> The Council has upgraded to Microsoft office 2007 suite. This may mean you cannot open attachments if you have older versions of office. <a href="http://www.microsoft.com/downloads/details.aspx?familyid=941B3470-3AE9-4AEE…"> Click here to access Microsoft Office 2007's compatibility website.<a/>

3 2

Purging patron records
by Cab Vinton 10 Feb '11

10 Feb '11

Many libraries purge their patron records on a regular basis so that records don't exist for folks who've died, moved out of town, etc. My question is whether deleting a patron's record affects any circulation statistics attached to that record, so that future reports based on those stats could become inaccurate. If so, would it make sense to have the ability to "Withdraw" a patron, in the same way that items can be withdrawn instead of deleted? Cab Vinton, Director Sanbornton Public Library Sanbornton, NH

1 0

Basics of report writing
by Buster 10 Feb '11

10 Feb '11

Hello. We are investigating Koha for our next automation system and I have a couple of questions. First, is there a basic manual or help file out there for the novice? Maybe something that lists all of the possible terms and syntax structures, as well as tells you how to get to the report writing area? Second, we have a couple of supervisors with marginal computer expertise (I'm sure that comes off as ironic from someone who would ask the first question) who want to write their own reports. I'm nervous because in our current system (Dynix Classic), a lot of damage can be done when one is at the level for creating such reports, or has the security level to even get there. Is that something to be concerned about with Koha? Thanks for any help you can provide. --Jim Maroon

3 2

Allowing holds across libraries
by Peel Lisa 10 Feb '11

10 Feb '11

Hello again ! We have two campuses and I need to set up holds so that patrons from either library can place holds on items which are held at the other - these items can be checked out or available. (We previously had holds set so borrowers could only place holds on items at their library which were checked out) I have changed the most obvious system parameters but still when I try to place a hold on an item from the other library I get the 'Cannot place hold' message. What am I missing? I have: AllowOnShelfHolds set to ON Canreservefromotherbranches set to ON IndependentBranches set to ON Regards Lisa Lisa Peel Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel(a)ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/> 25 Year "César Ritz" Colleges Switzerland

2 4

Re: [Koha] Vote for Koha Con 2011
by mohan pradhan 10 Feb '11

10 Feb '11

Hello All, I have updated the information at http://wiki.koha-community.org/wiki/KohaCon2011_Proposals for Kathmandu, Nepal. Also thanks to Thomas Dukleth for updating some information.. With Regards, Sincerely yours, Mohan Raj Pradhan General Secretary DlnetSA On Thu, Feb 3, 2011 at 9:43 PM, <koha-request(a)lists.katipo.co.nz> wrote: > 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. Re: Trouble getting zebra to work (Chris Nighswonger) > 2. Re: [Koha-devel] Vote for KohaCon 2011 (Koustubha Kale) > 3. Logging of fines (Olugbenga Adara) > 4. Advice needed on fixing zebra issues resulting from upgrade > (Olugbenga Adara) > 5. Re: Koha Digest, Vol 64, Issue 8 (mohan pradhan) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 2 Feb 2011 18:42:33 -0500 > From: Chris Nighswonger <cnighswonger(a)foundations.edu> > Subject: Re: [Koha] Trouble getting zebra to work > To: Doug Dearden <dearden(a)sarsf.org> > Cc: Koha <Koha(a)lists.katipo.co.nz> > Message-ID: > <AANLkTi=4a8awhAUZwq8qM0GBm+yZmYoWzuP+JW=UpVCE(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hi Doug, > > > 2011/2/2 Doug Dearden <dearden(a)sarsf.org> > > > Hello all, > > > > > > > > I am having some trouble getting searches to work using zebra, and am > > suspicious that I may have caused my problems as I was going through the > > setup. I have set up a test server on Debian Lenny, using git to > download > > koha. I am planning on doing some work that I hope to contribute back so > > chose a dev install when I was setting up. The files are in > > /home/doug/kohaclone and /home/doug/koha-dev . I was logged in as root > when > > I ran the install routine, then changed ownership on all the files to the > > koha user later. After that, I restored one of my databases from my > > production server, copied the default koha-conf.xml and edited it to > point > > to the correct database (named ?image?). I did the same with the > > koha-httpd.conf file, copying it and editing it where needed. While > logged > > in as ?koha?, I would get an error when I tried to run rebuild_zebra.pl. > > I logged in as root and ran it that way and it didn?t throw the error, > but > > searches aren?t finding anything. I then figured out that the new config > > files I created had root as the owner. I changed those to have koha as > the > > owner. The rebuild_zebra.pl script would then run without throwing the > > error. I then read a post that indicated being logged in as root when > > running rebuild_zebra.pl would mess things up, as certain log files and > > lock files would get created with root as the owner and koha would not be > > able to access them. > > > > > > > > Any idea where I would find these files? I have several files in > > /home/doug/koha-dev/var/lock/zebradb/biblios but they are all owned by > koha, > > not root. There is no koha directory in /var/log . > > > > > > > > Check also files under /home/doug/koha-dev/etc/zebradb. > > Koha logs are in /home/doug/koha-dev/var/log > > > > I don?t know what to expect from rebuild_zebra.pl . I am setting the > > KOHA_CONF and PERL5LIB variables. If I run ?rebuild_zebra.pl ?z ?a ?b? > > > > /home/doug/zlog.txt the script appears to run (the cursor blinks for a > bit, > > then the command prompt returns), and a 0 byte file named zlog.txt is > > created. > > > > > > > > try './rebuild_zebra.pl -a -b -r -v' for verbose output and to completely > rebuild the indexes. > > > > If I change the system preferences setting to use the no zebra option, > then > > run rebuild_nozebra.pl the indexes are built and searches work. > Returning > > the system preferences to use zebra breaks things again. > > > > > > > > nozebra is basically deprecated and unsupported at this point in Koha > history. Avoid it like the plague. > > > > I have a feeling this is an ownership/permissions problem somewhere, > either > > on some files or maybe relating to MySQL. I?m just not sure where to > look > > or how to troubleshoot. > > > > > Probably permissions. Something here may be useful too: > http://koha-community.org/documentation/faq/searching/#18 > > Kind Regards, > Chris >

5 5

Help with report
by Peel Lisa 10 Feb '11

10 Feb '11

Hello Apologies for showing my complete ignorance of sql but I need to create a report which lists catalogue records between two specific call numbers (for example, 641.5 to 641.6) - I need it to list author, title, edition and call number. Is there anything I can follow on the report wizard which will help me create this report or is anyone kind enough to give me the sql which would create this report? Thanks in advance Lisa Lisa Peel Librarian César Ritz Colleges Switzerland 1897 Le Bouveret - Switzerland Tel: +41 24 482 82 82 Fax: +41 24 482 82 80 E-mail: lisa.peel(a)ritz.edu<mailto:hortense.hofer@ritz.edu> http://www.ritz.edu<http://www.ritz.edu/> - http://www.culinaryarts.ch<http://www.culinaryarts.ch/> 25 Year "César Ritz" Colleges Switzerland

2 2

Another report request -- Active Cardholders
by Cab Vinton 09 Feb '11

09 Feb '11

There is a promising report on the Koha wiki (List Active Patrons by Category for a Specific Month). However, it doesn't seem to be providing valid results, even after changing "old_issues" to "issues". (The latter change produces counts in the single digits.) We're looking for a count of active borrowers between two dates, broken down by categorycode. ("Active" meaning at least one checkout between the two dates.) Appreciate any help! Cab Vinton, Director Sanbornton Public Library Sanbornton, NH

3 4