[Koha] KOHA INTERGRATION

[MASTeR Library]

KOHA ALL SQL REPORTS Visit: https://youtu.be/scuXS7wVFdM

On Mon, 1 Nov 2021, 10:36 pm Lennon Mazonde, <lennon at kohasupport.com> wrote:

> Hi Steve,
>
> Koha has two fields where you can store an item's value - 952$g
> (purchase price) and 952$v (replacement price). You can create an SQL
> report in the reports module to total the value of these fields, which
> would give you the total value of your collection (assuming that you
> added the required field data to all of your items). Here's an SQL
> statement you could try - you can modify it better suit your needs (I
> recommend using the Guided Reports module unless you're comfortable with
> writing SQL statements):
>
>         SELECT sum(items.replacementprice),sum(items.price),
>
> items.itemnumber,items.barcode,items.itemcallnumber,biblioitems.isbn,biblio.title,items.replacementprice,items.price
>
>
>         FROM items LEFT JOIN biblioitems on
>         (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN
>         biblio on (biblioitems.biblionumber=biblio.biblionumber)
>
>         GROUP BY items.replacementprice,items.price
>
>         ORDER BY biblio.title asc
>
> Now, the more difficult question is what to do with your board? I don't
> have any magic answers for that but perhaps you could start by creating
> a list of pros/cons for/against Koha or integrated school management
> system (it would be helpful to know the name). It may even turn out that
> the board is right  - I have my doubts, in my experience bundled systems
> tend to be Jacks of all trades and masters of none, but it's better if
> you do the research.
>
> I hope this helps and all the best with your board!
>
> Lennon Mazonde
> www.kohasupport.com
> lennon at kohasupport.com
> WhatsApp @ (+1) 717.489.0195
>
> On 11/1/21 5:27 PM, Steve Austin wrote:
> > Hi team..
> >
> > I am having a challenge. Am in a school library using KOHA but the
> > directors want to have an integrated school management system including a
> > library module. They are specifically concerned with being able to know
> the
> > total value of the resources in the library.
> >
> > Is there a way I can defend myself and still have KOHA give them the
> > opportunity to view to total value of library collection integrated into
> > their school managememt system?
> >
> > Or are there ways of generating reports giving the total value of our
> > library collection?
> >
> > Regards
> > Steve.
> > _______________________________________________
> >
> > Koha mailing listhttp://koha-community.org
> > Koha at lists.katipo.co.nz
> > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>