[Koha] Cataloger Work File Isolation

[Decka David]

Dear Koha Team,

One of our library's cataloguing staff is seeking clarity if Koha system
can be able to cater to provide and protect individual logged cataloguing
records and without other cataloguer staff to work on the same record/item.

It's a bit confusing if I can run koha librarian activity report to
identify his/her activity for different periods of time.

Can anyone kindly clarifies how I can help protect cataloguers work
files/activity?
Thank you for every support of guide and advice

*Decka David*
Matheson Library | PNG University of Technology | PMB | Lae, 411 | Morobe
Province | PAPUA NEW GUINEA
Alternate E: decka.da...@gmail.com | P: 657 4734353 <%28657%29%20473-4353>
| F: 675 4374363
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Search in not working

[Vanesa E. Berasa]

Hi,

In the administration interfaz koha advanced search, authorities search and
periodicals search is not working. Just give me a page in blank with the
words not found  (like dont found the page not the term).

It works in koha opac.

Any idea about what is happening?




-- 
*Lic. Vanesa E. Berasa*
Biblioteca Central
Facultad de Agronomía
Universidad de Buenos Aires (UBA)
-
Av. San Martin 4453
Ciudad de Buenos Aires - Argentina
tel. (005411) 5287-0422 - (005411) 5287-0307 Biblioteca Arata
Correo Electrónico:* ber...@agro.uba.ar *

*Biblioteca Central*
Sitio Web: http://www.agro.uba.ar/biblioteca
Catálogo Ceiba: http://ceiba.agro.uba.ar/
FAUBA Digital http://ri.agro.uba.ar/

Estamos en Facebook: http://www.facebook.com/BibliotecaCentralFauba
*Biblioteca Arata*
Sitio Web: http://www.agro.uba.ar/biblioteca/arata/
Catálogo Arata: http://catalogobiblioteca.agro.uba.ar/Arata/arata.asp
Facebook: http://www.facebook.com/ArataBiblio
2020 - Año Internacional de la Sanidad Vegetal

2020 -  Año del General Manuel Belgrano

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Delete Biblio if no matching items found?

[Owen Leonard]

> I have imported a MARC file 2-3 times with the same records, getting errors
> some times so fixed and imported the same again and again.

Have you tried using the "Clean" option in Administration -> Manage
staged MARC records? This will undo a problematic import.

  -- Owen

-- 
Web Developer
Athens County Public Libraries
(740) 737-6006
https://www.myacpl.org
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Delete Biblio if no matching items found?

[Katrin Fischer]

Hi,

please be careful using 'clean' as it removes information about the
changes the import made from your database.

In order to undo, click on the file name and then use the 'Undo import
into catalog' button.

If that's successful and you are happy with results, you can use clean.

Hope that helps,

Katrin

On 19.03.20 18:43, Owen Leonard wrote:

I have imported a MARC file 2-3 times with the same records, getting errors
some times so fixed and imported the same again and again.

Have you tried using the "Clean" option in Administration -> Manage
staged MARC records? This will undo a problematic import.

   -- Owen


___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Cataloger Work File Isolation

[Carlos Lopez]

Hi Decka

Not sure I really understand your question. Do you mean to ask whether 
individual records can be accessible to a single user? I don't think that's how 
the system works. Once the records are IN the system, they are there for all 
(staff) users to see and potentially edit. You can limit cataloguing staff 
privileges by editing staff permissions so that they won't be able to edit 
records, but then they won't be able to edit ANY records.

Or have I completely misunderstood your question?


With kind regards from the Dalton McCaughey Library Team



Carlos Lopez



Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052

Ph: 03 9340  ext.1 | libr...@dml.vic.edu.au 
| library.dmlibrary.org.au



From: Koha  on behalf of Decka David 

Sent: Thursday, 19 March 2020 8:07 PM
To: Koha list 
Subject: [Koha] Cataloger Work File Isolation

Dear Koha Team,

One of our library's cataloguing staff is seeking clarity if Koha system
can be able to cater to provide and protect individual logged cataloguing
records and without other cataloguer staff to work on the same record/item.

It's a bit confusing if I can run koha librarian activity report to
identify his/her activity for different periods of time.

Can anyone kindly clarifies how I can help protect cataloguers work
files/activity?
Thank you for every support of guide and advice

*Decka David*
Matheson Library | PNG University of Technology | PMB | Lae, 411 | Morobe
Province | PAPUA NEW GUINEA
Alternate E: decka.da...@gmail.com | P: 657 4734353 <%28657%29%20473-4353>
| F: 675 4374363
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] [KOHA] SQL CIRCULATION REPORT

[muirunyeri]

Hi Rogan,
After following your advice to have same filters for both queries, I now are 
able to get the results I desire.
I also removed the join for biblioitems and indeed it was not necessary.
No words can express my sincere appreciation for the time you took to help me 
out. I can only say a big big thank you.
Thank you to everyone who tried in their own ways in finding me a solution.
Warm RegardsJames Original message From: rogan.ha...@gmail.com 
Date: 18/03/2020  15:53  (GMT+03:00) To: muirunyeri  Cc: 
Koha  Subject: Re: [KOHA] SQL CIRCULATION REPORT- how 
to SUM 
Hi James,
A few thoughts from skimming it.
1) I don't see where you're using biblioitems anywhere in the report unless I'm 
just not seeing it so you probably don't need it for a join.  I don't think 
it'll hurt anything other than slow the report less than  you'll even notice 
but still ... if not needed I'd cut it out.
2) you're going to want the same filters in the second query as the first to 
make sure you get the same numbers
3) you are using a SUM on the statistics type but you can only sum numbers you 
probably want a COUNT there, which you do in the first query but not the second
On Sun, Mar 15, 2020 at 12:38 AM muirunyeri  wrote:
Hi Rogan,
I reintroduced two filters date abd itemtype. So that i can sekect any date be 
it weekly monthly or quarterly etc. I also have different itemtypes sone of 
which do not start wih a digit and I need to filter them out yo get accurate 
results. (Your advice on whether the filters might be sn issue is verywelcome)
Below is my query.

SELECT CONCAT(SUBSTRING(itemcallnumber,1,1), '00') AS "CLASS", 
count(statistics.type) AS 'NUMBER'
FROM borrowers
  LEFT JOIN statistics ON (statistics.borrowernumber=borrowers.borrowernumber)
  LEFT JOIN items ON (items.itemnumber = statistics.itemnumber)
  LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = 
items.biblioitemnumber)
WHERE statistics.type IN ('issue', 'renew')
AND date(datetime) BETWEEN <> AND <>
AND items.itype = <>
GROUP BY SUBSTRING(itemcallnumber,1,1)
UNION ALL
SELECT "TOTAL" AS "CLASS", SUM(statistics.type) AS 'NUMBER'
FROM borrowers
  LEFT JOIN statistics ON (statistics.borrowernumber=borrowers.borrowernumber)
  LEFT JOIN items ON (items.itemnumber = statistics.itemnumber)
  LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = 
items.biblioitemnumber)
WHERE statistics.type IN ('issue', 'renew')

Sent from my Samsung Galaxy smartphone. Original message From: 
rogan.ha...@gmail.com Date: 15/03/2020  00:48  (GMT+03:00) To: muiru james 
, Koha  Subject: Re: [KOHA] SQL 
CIRCULATION REPORT- how to SUM 
Hi James,
The query I posted worked with my quick test.  Could you post your query as it 
is now?


On Sat, Mar 14, 2020 at 9:52 AM muiru james  wrote:
Hi Rogan and All,

I cant thank you enough for the tremendous effort you have put towards helping 
me solve my problem.
You do indeed understand well what I need.
The UNION ALL is working well by adding a new row below the last class group. 
However the SUM function is returning a 0 (zero). It seems its not adding up 
the numbers.
Please dont give up but help me find out the last remaining bit. We are almost 
there.
Most appreciated
James





On Thu, Mar 12, 2020 at 2:57 PM  wrote:
Hi James,
If I'm understanding correctly you want an additional row giving a sum of all 
the numbers in addition to the per class one?  The simplest way  it occurs to 
me to do that is with a UNION ALL statement.  I've taken some filters out for 
brevity but this illustrates the approach:
SELECT CONCAT(SUBSTRING(itemcallnumber,1,1), '00') AS "CLASS", 
count(statistics.type) AS 'NUMBER'
FROM borrowers
  LEFT JOIN statistics ON (statistics.borrowernumber=borrowers.borrowernumber)
  LEFT JOIN items ON (items.itemnumber = statistics.itemnumber)
  LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = 
items.biblioitemnumber)
WHERE statistics.type IN ('issue', 'renew')
GROUP BY SUBSTRING(itemcallnumber,1,1)
UNION ALL
SELECT "All Classes" AS "CLASS", SUM(statistics.type) AS 'NUMBER'
FROM borrowers
  LEFT JOIN statistics ON (statistics.borrowernumber=borrowers.borrowernumber)
  LEFT JOIN items ON (items.itemnumber = statistics.itemnumber)
  LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = 
items.biblioitemnumber)
WHERE statistics.type IN ('issue', 'renew')

Basically with UNION ALL you can create other queries that don't have to be 
tied to the data of the previous queries so long as the columns line up.  


On Thu, Mar 12, 2020 at 3:04 AM muiru james  wrote:
Hi Rogan and Team,
I really appreciate your assistance towards my problem. The query does indeed 
work to answer my need. Another query was also pushed to me towards the same. 
I'm now looking for a way to SUM my answer to get the total number of books 
issued. Any suggestions would be most welcome for any of the 2 queries. The 
other SQL query is as below: -
SELECT CONCAT(SUBSTRING(itemcallnumber,1,1), '00') AS "CLASS", 
count(