[Koha] Circulation and Fine Rules

Dear Friends, I am testing latest version of koha for my library, I have set five item types for different courses and five different patron categories of these courses. I have set same course patron category with item type so that patrons cannot get books of other courses. but it is not working an

Re: [Koha] Circulation and Fine Rules

ode+s1045719n5790215...@n5.nabble.com> wrote: > Holger Meissne is correct. You need to define different circulation rules. > > Vikram Zadgaonkar > > > On Tue, Mar 11, 2014 at 2:21 PM, Holger Meissner < > [hidden email] <http://user/SendEmail.jtp?type=node&node=5790215&a

[Koha] Sorting of accession numbers

Dear Friends, I have used alphabets in barcode numerbers for different item types, now when i have generated the accession register sorted by barcode it sort like A1, A11, A12, A21.. etc instead of A1,A2,A3,A4. Please help! Manoj Kumar Misra -- View this message in context: http://koha.1

Re: [Koha] Sorting of accession numbers

> > Step 4 > > Go to *Data* and sort your column to A - Z > > Step 5 > > Make a new column beside the barcode column > > then type ="A"&(the column with the number 1) then press enter > > and then drag the formula to put A back > > Regards,

[Koha] Report Help

Dear Friends, I am looking for a report which has list of titles(biblio) their number of copies(items) by item type and collection code. -- View this message in context: http://koha.1045719.n5.nabble.com/Report-Help-tp5793161.html Sent from the Koha-general mailing list archive at Nabble.com.

Re: [Koha] Report Help

Dear Arslan, I could not find it there *Regards!* *Manoj Kumar Misra* M.Phil., M.L.I.Sc., B.L.I.Sc., M.Sc.(Phy), B.Sc. (P.C.M.) Deputy Librarian SRMGPC Lucknow Mob. No.: 09415422579 Alternate E-mail: manojmisrasrm...@gmail.com On Sat, Apr 5, 2014 at 12:39 AM, arslan [via Koha] < ml-node+s10457

Re: [Koha] Report Help

e FROM biblio b JOIN items i USING(biblionumber) GROUP BY > b.biblionumber > > If it works you can add it to the report library. ;) > > Cheers, > Liz Rea > Catalyst IT > > On 05/04/14 21:31, manoj382093 wrote: > > > Dear Friends, > > I am looking for a repo

Re: [Koha] Report Help

er,'') > > AS biblionumbers, >biblio.author, biblio.title, > COUNT(items.itemnumber) AS ItemCount, ccode, itype > FROM items > LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) > GROUP BY items.biblionumber HAVING (COUNT(*)>=1) > ORDER BY ItemCount D

Re: [Koha] Report Help

> Washington, DC 20011 > (202) 387-0309 x1745 > [hidden email] <http://user/SendEmail.jtp?type=node&node=5793778&i=0> > http://www.ccpcs.org/library/ > > > On Fri, Apr 11, 2014 at 3:47 AM, manoj382093 <[hidden > email]<http://user/SendEmail.jtp?type=node&