Re: [Koha] Unable to login

2011-04-21 Thread Magnus Enger
On 21 April 2011 06:50, wrote: > I am installing it on Ubuntu OS and hence following the installation steps > mentioned at >    http://wiki.koha-community.org/wiki/Koha_on_Ubuntu You will find the official guides to installing on Ubuntu in the source code or here: http://git.koha-community.org/g

[Koha] Records not being found

2011-04-21 Thread James Beaton
Good Afternoon I suspect that the question I am posing relates to an indexing function within Koha. We have recently installed the programme, and I have created and saved a number of records which I cannot then retrieve via the catalogue search. They also do not appear in the reservoir. I w

Re: [Koha] SQL statement for generating current checkouts

2011-04-21 Thread Church, Beverly
Hi Nabonita, Try this query. It looks for any items that are current checked out where the checkout date was on or before 2011-03-29, or the last renewal date was or before 2011-03-29. SELECT issues.issuedate, items.barcode, biblio.title, borrowers.firstname,borrowers.surname, borrowers.cardnumbe

Re: [Koha] Records not being found

2011-04-21 Thread Galen Charlton
Hi, On Apr 21, 2011, at 8:18 AM, James Beaton wrote: > We have recently installed the programme, and I have created and saved a > number of records which I cannot then retrieve via the catalogue search. They > also do not appear in the reservoir. I will be discussing this with the > systems per

[Koha] Koha: error in MARC Bibliographic Framework Test

2011-04-21 Thread Linda Culberson
Thanks to both Fridolyn and Beverly, we now have no errors in our frameworks. I did have links to tab 10 in the other subfields besides 952. I really appreciate everyone's help and patience as I learn about Koha. It's a wonderful community. Linda > Date: Thu, 21 Apr 2011 08:14:55 +0200 > From:

[Koha] Koha 3.4 OpacHiddenItems continued

2011-04-21 Thread Linda Culberson
I'm terribly sorry, we had an alarm go off, and I apparently hit send before I finished my message. We need to know about OpacHiddenItems in 3.4 because in 3.2 we are using Lost to hide items in the opac. We don't like having something marked "LOST" when we know it isn't and and are very deter

Re: [Koha] Unable to login

2011-04-21 Thread Peter Lorimer
Beaton The Library The National Piping Centre 30-34 McPhater Street Glasgow G4 0HW t. +44 (0) 141 353 0220 f. +44 (0) 141 353 1570 www.thepipingcentre.co.uk www.pipingfestival.co.uk The National Piping Centre Ltd. Registered in Scotland no. 139271, Charity no. 020391 The Piping Centr

[Koha] Report coming up short?

2011-04-21 Thread Paul
Would some kind librarian with more than 10,000 biblios please try running the following Mysql report. I works as expected, except that the csv output truncates at 10,000. If confirmed, I will attempt to post a bug. SELECT biblionumber, CONCAT('',title,'') AS Title FROM biblio ORDER BY biblio

Re: [Koha] Report coming up short?

2011-04-21 Thread Liz Rea
Paul, Try adding a LIMIT to the end of that report, and see if it works. Liz Rea NEKLS On Apr 21, 2011, at 12:57 PM, Paul wrote: > Would some kind librarian with more than 10,000 biblios please try running > the following Mysql report. I works as expected, except that the csv output > trunca

Re: [Koha] Report coming up short?

2011-04-21 Thread Magnus Enger
Hi! On 21 April 2011 19:57, Paul wrote: > Would some kind librarian with more than 10,000 biblios please try running > the following Mysql report. I works as expected, except that the csv output > truncates at 10,000.  If confirmed, I will attempt to post a bug. This sounds like a known bug, whi

Re: [Koha] Report coming up short?

2011-04-21 Thread Paul
At 01:29 PM 4/21/2011 -0500, Liz Rea wrote: >Paul, >Try adding a LIMIT reults> to the end of that report, and see if it works. Thank you Liz and Ian -- now functional Best regards - Paul >Liz Rea >NEKLS > >On Apr 21, 2011, at 12:57 PM, Paul wrote: > > > Would some kind librarian with more than

Re: [Koha] Report coming up short?

2011-04-21 Thread Bob Ewart
On 04/21/2011 01:57 PM, Paul wrote: > Would some kind librarian with more than 10,000 biblios please try running > the following Mysql report. I works as expected, except that the csv output > truncates at 10,000. If confirmed, I will attempt to post a bug. > > SELECT biblionumber, > CONCAT(' href

Re: [Koha] Report coming up short?

2011-04-21 Thread Paul
At 08:43 PM 4/21/2011 +0200, Magnus Enger wrote: >This sounds like a known bug, which will be fixed in 3.4: >http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6028 Thanks - as soon as I got the reply about a hard limit I grepped the code, found it in c4/records/guided.pm and modded it. I'm

[Koha] Changing output format for staff- and patron-generated lists

2011-04-21 Thread Joel
Is it possible to change the output format for lists generated in OPAC? Koha provides a link to email lists to other users, but, according to Koha, the lists are only viewable in ProCite, Reference Manager and EndNote. Is it possible to output these lists to other file formats, such as Excel or Acc

Re: [Koha] Report coming up short?

2011-04-21 Thread Ian Bays
Hi. There is a default "limit" of 1 on the sql reports. I believe that if you provide your own "limit" statement in your sql then you should get your choice of the limit rather than the default. So try adding "limit 9" to your sql perhaps. I hope it still works... Ian On 21/04/2011 18

[Koha] Can one get WYSIWYG interface for koha as a cms?

2011-04-21 Thread Robert Lyon
Hi I've added the changes to make koha as a CMS ( seen here: http://wiki.koha-community.org/wiki/Koha_as_a_CMS ) and I was wondering if anyone had made the Value field on the systempreferences.pl page use something like TinyMCE rather than a plain textarea box? Or if even that is possible? An