Re: [Koha] Importing records into Koha - smaller batches per year of catalogization?

2023-06-19 Thread Alvaro Cornejo 
Hi

You don't need to sort your records for importing. I usually only split it
by a number of record blocks. I use 10K records at once for easy handle and
control, but it is possible to do more at a time. I might depend on the
hardware you have your koha installation on.

Regards,

Alvaro
.
||
 Stay safe / Cuídate/  Reste sécurisé
*7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
mesure.
 *q *Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario /
Imprimez seulement si nécessaire


Le lun. 19 juin 2023 à 07:36, libr...@ssst.edu.ba  a
écrit :

> Hello all,
>
> If I may add this breakdown of fields I've tried to map, could someone let
> me know if I'm on the right track or if I need to go back to the study
> board? Thank you in advance!
>
> https://i.ibb.co/YR6g4yt/in-house-cat-vs-koha-marc21.png
>
>
>
> Best regards
>
> Aida Đikić
>
>
> -Original Message-
> From: libr...@ssst.edu.ba
> Sent: Monday, June 19, 2023 12:50 PM
> To: koha@lists.katipo.co.nz
> Subject: Importing records into Koha - smaller batches per year of
> catalogization?
>
> Hello all,
>
> (my messages don't seem to be visible on the mailing list, only replies to
> them are)
>
> I have finally received the export from our developers; they have provided
> me with an .xls file which I'll need to prepare for MarcEdit (check for
> errors and consistency such as uniform names of publishers, authors,
> duplicate or skipped inventory numbers etc.). There's a total of 9326
> copies, so I was wondering if the best way to import the records would be
> to break up the file into several smaller ones, separated by the year in
> which they were cataloged?
>
> I could sort them by inventory number; the format we used for them is
> B0001/20## for books. I currently have the barcode in Koha set to
> -0001 format (though I'm wondering whether it's better to use the EAN
> barcode format. Are there any preferences re: barcodes here in the list?
>
> Finally, when it comes to the mapping of the fields we had in our system
> and what's available in Koha, our fields were the following:
>
> In-house catalogExample title
> Title   Preservation and restoration of tooth structure /
> edited by Graham J. Mount, Wyatt R. Hume, Hien C. Ngo, Mark S. Wolff
> Authors Graham J. Mount; Wyatt R. Hume; Hien C. Ngo; Mark
> S. Wolff;
> TypeTextbook
> Binding Hardcover
> Languages   English;
> Publishers  Wiley-Blackwell;
> Year2016
> Publication & manufacture   Chichester : Wiley-Blackwell, 2016
> Edition
> Physical Description312p., 28cm.
> Notes   Accompanied by companion website:
> http://www.wiley.com/go/mount/preservation which includes interactive
> multiple-choice questions for each
> chapter and Powerpoints of all figures from the
> book for downloading.
> Includes bibliographical references at the end of
> each chapters and index.
> Pages
> ISBN 10
> ISBN 13 9781118766590
> Series
> Volume name
> Volume number
> UDC (categories)(616.31) Stomatology. Oral cavity. Mouth. Diseases
> of the mouth and teeth. Including: Odontology. Diseases of the teeth.
> Dentistry. Orthodontics;
> Subject headingsDental caries Prevention Dental Caries prevention
> & control Dental Caries therapy Dental therapeutics Dentistry, Operative
> Dentistry,
> Operative methods MEDICAL Surgery General Oral &
> maxillofacial surgery Preventive dentistry Tooth Diseases Tooth Diseases
> prevention & control
> Tooth Diseases therapy
> Summary Combining the approaches of preventative and restorative
> dentistry, this is a revised and updated guide to the clinical techniques
> and procedures
> necessary for managing tooth disorders and
> disease. Introduces minimally invasive dentistry as a model to control
> dental disease and then restore
> the mouth to optimal form, function, and
> aesthetics. Contains several student-friendly features, including a new
> layout, line drawings and clinical
> photographs to illustrate key concepts. Covers
> fundamental topics, including the evolutionary biology of the human oral
> environment; caries
> management and risk assessment; remineralization;
> principles of cavity design; lifestyle factors; choices between restorative
> materials and
> restoration management. Includes a companion
> website with self-assessment exercises for students and a downloadable
> image bank for
> instructors.--Publisher.
> Catalog Entry   MOUNT, Graham J.
> Pr

Re: [Koha] Local covers and the Coverflow plugin

2023-06-19 Thread Alvaro Cornejo 
Hi

You need to "discard" items with no covers from your query.

We use this:

SELECT DISTINCT biblio.title, biblio.biblionumber, c.imagenumber AS
localcover
FROM items i
LEFT JOIN biblioitems USING (biblioitemnumber)
LEFT JOIN biblio ON (i.biblionumber=biblio.biblionumber)
LEFT JOIN biblioimages c ON (i.biblionumber=c.biblionumber)
  WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= i.dateaccessioned AND
biblioitems.isbn IS NOT NULL  AND c.imagenumber != ''
  ORDER BY rand()
LIMIT  50

Hope helps

Regards

Alvaro


||
 Stay safe / Cuídate/  Reste sécurisé
*7* Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
mesure.
 *q *Recycle always / Recicla siempre / Recyclez toujours
 P Print only if absolutely necessary / Imprime solo si es necesario /
Imprimez seulement si nécessaire


Le lun. 19 juin 2023 à 02:16, libr...@ssst.edu.ba  a
écrit :

> Hello Alvaro,
>
> I don't know how to do that, since I never even touched SQL before. I can
> copy and paste code from the SQL list, but don’t really understand what it
> does and how to change it to do what I need.
>
> I just checked the report, it is public. The code I'm using is from the
> plugin configuration:
>
> SELECT b.biblionumber, SUBSTRING_INDEX(m.isbn, ' ', 1) AS isbn, b.title
>   FROM items i
>   LEFT JOIN biblioitems m USING (biblioitemnumber)
>   LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber)
>   WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= i.dateaccessioned AND
> m.isbn IS NOT NULL AND m.isbn != ''
>   GROUP BY biblionumber
>   HAVING isbn != ""
>   ORDER BY rand()
>   LIMIT 30
>
> The instructions then go on to say:
>
> Note: You can add an additional column 'localcover' - this should be blank
> if the biblio doesn't have a localcover and can contain any other data if
> it does. If this column is populated a local cover will be used. Example
> below:
>
> SELECT DISTINCT biblio.title, biblio.biblionumber,
> SUBSTRING_INDEX(biblioitems.isbn, ' ', 1) AS isbn, c.imagenumber AS
> localcover
> FROM items
> LEFT JOIN biblioitems USING (biblioitemnumber)
> LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber)
> LEFT JOIN cover_images c ON (items.biblionumber=c.biblionumber)
> WHERE biblioitems.isbn IS NOT NULL AND biblioitems.isbn !=''
> ORDER BY RAND()
> LIMIT 15;
>
>
> But when I tried replacing the first code with the second, I didn't get
> any results. Right now I'm back to the original code, and have turned the
> local covers option off, so I have several "No image available" images.
> Where do I change what to get local covers?
>
> Best regards
>
> Aida Đikić
>
>
> From: Alvaro Cornejo 
> Sent: Friday, June 16, 2023 4:27 PM
> To: libr...@ssst.edu.ba
> Cc: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Local covers and the Coverflow plugin
>
> Hi Aida
>
> You only need to change/edit the report that pulls information for
> coverflow. Also remember to define the report as public.
>
> Regards
>
> Alvaro
>
>
> ||
>  Stay safe / Cuídate/  Reste sécurisé
>  Switch off as you go / Apaga lo que no usas /  Débranchez au fur et à
> mesure.
>   Recycle always / Recicla siempre / Recyclez toujours
>   Print only if absolutely necessary / Imprime solo si es necesario /
> Imprimez seulement si nécessaire
>
>
> Le ven. 16 juin 2023 à 03:41, mailto:libr...@ssst.edu.ba  libr...@ssst.edu.ba> a écrit :
> Hello again,
>
> I'm trying to find a way to have local covers show in the Coverflow plugin
> on the OPAC page for titles not added via Z39.50.
>
> I had originally set it up using the first example in the configuration
> (items added in the last 30 days), but going back I see there's another
> example for adding additional columns. Since it said, "you can add an
> additional column" I thought I was supposed to paste it below the already
> existing code. That... ended up with an error yeah :) So I replaced it and
> ran the report but could not get a local cover.
>
> What am I doing wrong this time? I uploaded the cover in the holdings
> area. Is there another location I should do it instead? I checked old posts
> on the mailing list, but could not find any solutions for this. I would
> also like to work out a way to show covers of our collections (e.g. CS
> textbooks, ECON textbooks, donated books etc.) but for that I need to
> figure out lists??
>
> I'm on Koha 23.05.00 and Ubuntu 22.04.2 LTS.
>
> Best regards
>
> Aida Đikić
> ___
>
> Koha mailing list  http://koha-community.org
> mailto: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] SQL reports in Koha 23.05

2023-06-19 Thread Isabel Pineda 
Hi.

I installed Koha 23.05 today and noticed that I cannot edit my SQL reports 
anymore. The changes don't get saved. What can I do?

Thank you.
Isabel Pineda

___

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

Re: [Koha] SQL reports in Koha 23.05

2023-06-19 Thread Himanshu Aggarwal 
Hello Isabel does it show any error after you update the SQL reports?

On Tue, Jun 20, 2023 at 3:04 AM Isabel Pineda 
wrote:

> Hi.
>
> I installed Koha 23.05 today and noticed that I cannot edit my SQL reports
> anymore. The changes don't get saved. What can I do?
>
> Thank you.
> Isabel Pineda
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
Assistant Librarian,
Confucius Institute Scholar 13-14,
R.D. National College,
Bandra (W.)
___

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

Re: [Koha] SQL reports in Koha 23.05

2023-06-19 Thread Katrin Fischer 

Hi Isabel,

you've probably run into this bug:

*Bug 33966*
 -
"Update and run SQL" for non-English templates

Please try switching to English for editing until this is fixed.

Hope this helps,

Katrin

On 19.06.23 23:34, Isabel Pineda wrote:

Hi.

I installed Koha 23.05 today and noticed that I cannot edit my SQL reports 
anymore. The changes don't get saved. What can I do?

Thank you.
Isabel Pineda

___

Koha mailing listhttp://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] Enquiry for Withdrawn

2023-06-19 Thread Himanshu Aggarwal 
If I want to add a Withdrawn Date which is the previous year date or some
other date then how can we do it. Also if I added additional X in the items
how to get the report for it.

-- 
Assistant Librarian,
Confucius Institute Scholar 13-14,
R.D. National College,
Bandra (W.)
___

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