[Koha] Binding journals

that takes care of that? (and how does this work?) 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

[Koha] Help with a report query

e been asked to provide a mechanism to select the year to run this for (I would guess similar to the construct " DATE (b.dateexpiry) BETWEEN <> AND <>", except selecting only years) Is it possible to do this? And if so, how? With kind regards from the Dalton McCaugh

Re: [Koha] Help with a report query

e IN ('issue', 'renew') AND branch = <> GROUP BY month, type ORDER BY month(datetime) 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

[Koha] Koha installation woes

r: Pointing a browser to port 80 of the address gives us the Apache test page, and pointing to port 8080 gives us (on Chrome) error ERR_EMPTY_RESPONSE Can anyone point us to where we've gone wrong? With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey

Re: [Koha] Koha installation woes

Thank you very much! That seems to have done it. 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<mailto:libr...@dml.vic.edu

[Koha] Issue order

n reverse issue order (latest scanned first)? 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.d

Re: [Koha] Issue order

Merci Jonthan. Unfortunately that seems to sort by due date (at least in 18.11) rather than in scan order. 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

Re: [Koha] How to upgrade Koha from 17.05 to Latest stable release on Ubuntu 14.04

those packages (and their dependencies). 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 -Original Message- From

Re: [Koha] Difference Between MariaDB and MySQL

Related question: Is anyone working on porting the Koha database structure (and codebase) to Postgresql? (because of course everyone has unlimited time and energy) With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville

Re: [Koha] Difference Between MariaDB and MySQL

Thanks David. 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 -Original Message- From: dc...@prosentient.com.au

Re: [Koha] Cataloger Work File Isolation

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

[Koha] Courser reserves on OPAC

Hi folks Has anyone had any luck modifying columns on the OPAC Course Reserves display? (suppressing some columns, reordering others) If so, what was involved? (modifying the template? adding some JS? something else?) With kind regards from the Dalton McCaughey Library Team Carlos Lopez

Re: [Koha] Courser reserves on OPAC

Thanks Eric Brilliant! Something for me to play with while we're working from home 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<mai

[Koha] MARC modification templates question

look like this (assuming that we're looking for 'http://proxy.dml.vic.edu.au:2048/' and replacing it with 'https://proxy.dml.vic.edu.au/')? s/http\:\/\/proxy.dml.vic.edu.au\:2048\//https\:\/\/proxy.dml.vic.edu.au\//g With kind regards from the Dalton McCaughey Library Team Carlos Lo

Re: [Koha] MARC modification templates question

Hi all Never mind - it looks as though there is no need to escape : nor / when modifying strings with MARC modification templates. With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340

[Koha] Help with SQL script please

WHERE ExtractValue(marcxml, '//datafield[@tag="373"]/subfield[@code="a"]') LIKE "Jesuit%")) Can anyone spot where I've gone wrong? Or perhaps point me to an easier way of doing this? With kind regards from the Dalton McCaughey Library T

Re: [Koha] Help with SQL script please

VERTing my authids so that they're the same data type as the ExtractValue strings? Or am I doing this the wrong way? Is there a better way for me to list a set of itemnumbers from a known set of authids? With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton Mc

[Koha] some jQuery advice please?

is clicked typ(); tog(); }); }; }); } Unfortunately that doesn't work. I can see that the contents blocks look like while ISBNs look like (so really I should have used "#isbn" rather than ".isbn" but that didn't work either). How do I se

Re: [Koha] some jQuery advice please?

Thank you Eric! Very quick reply I'll try that out . 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<mailto:libr...@dml.vi

[Koha] Different rules for borrowers from different libraries based on library

ut setting up different itypes for both branches)? We're on version 20.05. 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<mailto:libr...@dml.v

[Koha] Problem with some SQL

) RenewedBorrowers FROM borrowers, categories WHERE borrowers.categorycode = categories.categorycode GROUP BY borrowers.categorycode Is something like what I'm trying to do even possible on Koha, or should I be happy with my 2 reports? With kind regards from the Dalton McCaughey Library Team Carl

Re: [Koha] Problem with some SQL

Thanks Sebastian but I'm afraid I'm still a little lost: How would you feed the same single expression (a user-supplied date range) to 2 separate fields? With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent,

[Koha] weird report behaviour or just bad SQL?

eports area on Koha restricts normal SQL functionality, or am I doing something wrong? 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<mailto:libr...@

Re: [Koha] convert from Handy Library Manager

to look at MARCEdit (https://marcedit.reeset.net/translating-excel-data-to-marc) to help massage your data into MARC). 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 | li

[Koha] List of serials SQL

to help us out with this? 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<mailto:libr...@dml.vic.edu.au> | library.dmlibrary.org.au ___

Re: [Koha] Bound withs

I'd love to hear about it (I'm looking at a couple of shelves' worth of bound pamphlets that I've been delaying action on) With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 93

[Koha] limits on canned OPAC searches

ve this by limiting results to a time range (preferably "last 6 months" or something like that)? And excluding material that is "Ordered"? With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORI

Re: [Koha] Need help with Koha instance that refuses to do checkouts

+with+a+pop+up+%5C%22Loading...you+may+continue+scanning.%5C%22%22&o=newest&f=1) that made the checkout window hang with a pop up window "Loading ... you may continue scanning" - does this sound like your problem? With kind regards from the Dalton McCaughey Library Team Carlos

Re: [Koha] Serials and Variable Frequencies

;d need to change the subscription frequency when it changed, but not keep historical frequencies. I hope this helps. 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.

Re: [Koha] Equals sign in a macro?

Hi Tasha We've also had trouble with equals signs in macros - I'd be interested to know if there was a fix for this. With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 ex

Re: [Koha] Ideas wanted for cataloging QA utilities

reports on invalid tag indicators). As you say, we can always write SQL reports to pull individual (repeated) errors, but it would be nice to spot these 'live' too. With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent,

[Koha] error checking in auth import?

rst. 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<mailto:libr...@dml.vic.edu.au> | library.

[Koha] adding elements to opac-user.pl?

essing a bunch of columns from there but it turned out we were hiding columns from the "Article requests" view instead. 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 |

Re: [Koha] adding elements to opac-user.pl?

I knew it! I knew I was being dense! Thanks Caroline - we'll try this out. 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.o

[Koha] Linking biblio records with 780s and 785s

s 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<mailto:libr...@dml.vic.edu.au> | library.dmlibrary.org.au ___ Koha mai

Re: [Koha] How to get sql report on patron additional attributes.

rrowernumber and ba2.code = "ROLE" LEFT JOIN categories c on c.categorycode = b.categorycode WHERE b.categorycode = <> order by b.surname, b.firstname I hope this helps! With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Cr

Re: [Koha] In House Use

gt; INNER JOIN items i USING (biblionumber) > LEFT JOIN statistics s USING (itemnumber) > WHERE s.type IN ('issue', 'renew', 'localuse') > GROUP BY itemnumber > ORDER BY i.homebranch, i.location, i.itemcallnumber, i.copynumber Good luck! With kind regards

Re: [Koha] Clearing of users

borrows who have a 'lost card' flag set. I don't know whether this will help directly, but it might give you some ideas. With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph

[Koha] Koha carousel on WordPress?

seen that there's a WordPress plugin (https://wordpress.com/plugins/library-bookshelves) that does something similar, but we've not yet had a chance to look at this properly. With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Cres

Re: [Koha] Koha carousel on WordPress?

Thanks Christopher - I did see that one on my searches but it's great to get confirmation about it! 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.e

Re: [Koha] Opac Customization

Wow! That looks great! 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 | https://library.dmlibrary.org.au -Original Message- From: Koha On

[Koha] 'Library Bookshelves' plugin for WordPress

Hi folks Is anyone using the 'Library Bookshelves' plugin for WordPress? We seem to be having some trouble configuring this for our Koha instance and would welcome any advice! With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 Colleg

Re: [Koha] Stage marc import do not import marc file

> Sent from: > http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html > ___ Koha mailing list > http://koha-community.org Koha@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha -- Carlos Lopez Cataloguer Dalton McCaug

[Koha] Auhorities with usage

Hi all I'm trying to come up with a query that will give me a listing of authority headings with the total number of bibliographic records that use that heading. Is such a thing possible? Any help would be greatly appreciated. We're on release 17.11 Regards, Carlos. -- Carlos Lopez

Re: [Koha] Replacement of information in an item field by batch

n/koha/tools/batchMod.pl Regards, Carlos. Carlos Lopez Cataloguer Dalton McCaughey Library 29 College Crescent Parkville, VIC 3052 AUSTRALIA Ph: +61 3 93408885 Fax: +61 3 86694418 clo...@dml.vic.edu.au -Original Message- From: Koha On Behalf Of Peter Lau Sent: Thursday, 14 February 2019

Re: [Koha] Koha system warning message

trons.html?highlight=staff%20permission#patron-permissions and they may help. Regards, Carlos. Carlos Lopez Cataloguer Dalton McCaughey Library 29 College Crescent Parkville, VIC 3052 AUSTRALIA Ph: +61 3 93408885 Fax: +61 3 86694418 clo...@dml.vic.edu.au -Original Message- From: Koha On

[Koha] Setting up autorenewals for a borrower category

loan period of 120 work days, with a possible further 30 days available after renewing manually. Is that not the case? We do not have an autorenewal notice set up. Would this make a difference? We're on version 18.05. With kind regards from the Dalton McCaughey Library Team Carlos Lop

Re: [Koha] Setting up autorenewals for a borrower category

Thanks Bob 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 -Original Message- From: Koha On Behalf Of Bob Birchall

Re: [Koha] Setting up autorenewals for a borrower category

Thanks Holger 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 -Original Message- From: Holger Meissner Sent

[Koha] COURSE and Course Reserves

alton 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 -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.http://www.mail

Re: [Koha] SQL for report on items Catalouged by each librarian per period

m 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 -Original Message- From: Koha On Behalf Of Akin Adigun (Akinomatics) Sent: Friday, 26

Re: [Koha] Koha loan table

Just make sure you don't have any rules higher up that might lead the system to ignore this. 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 | lib

Re: [Koha] Staff monitoring (catalogue)

Hi Yatheesh If you're working on Koha 18.05 or later you should be able to check your logs (if you have the cataloguing log turned on). With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03

Re: [Koha] Notify the borrower when a hold is placed

ber AND issues.date_due > (SELECT DATE_ADD(CURDATE(), INTERVAL 14 DAY)) ORDER BY borrowers1.surname, borrowers1.firstname With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Parkville, VICTORIA 3052 Ph: 03 9340 ext.

[Koha] Source of acquisition

this behaviour? Does anyone know whether this might be because of some setting we might have switched? We're on 18.05. 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.

Re: [Koha] Editing MARC Frameworks

that can be overwritten next upgrade). 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 -Original Message- From: Koha

Re: [Koha] Editing MARC Frameworks

right? 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 -Original Message- From: Koha On Behalf Of Katrin Fischer Sent

Re: [Koha] Source of acquisition

just in case. 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 -Original Message- From: Koha On Behalf Of Katrin

[Koha] Rancor macros

with a specific value in the 2nd indicator? (for example, 650 tags with indicators _7). 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.e

Re: [Koha] Fwd:Re: Koha Not calculating and charging overdue fines

ey 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 -Original Message- From: Koha On Behalf Of muirunyeri Sent: Thursday, 15 August 2019 5:56 AM To: koha@lists.ka

[Koha] Ejournal management?

issues to be entered?) 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 ___ Koha

Re: [Koha] Multiple problems in MARC download and import

Hi Elaine You could run unix2dos on the file (http://dos2unix.sourceforge.net/), or if you open the file in Notepad++ (https://notepad-plus-plus.org/) you can then go to 'Edit > EOL Conversion > Windows' and save the document. With kind regards from the Dalton McCaughey Libr

Re: [Koha] Error when adding new authorities record

Hi Keith From your description you didn't enter a value in 150. Is that right? If so this might be the cause of the problem (an authority record requires a 1XX tag). With kind regards from the Dalton McCaughey Library Team Carlos Lopez Dalton McCaughey Library | 29 College Crescent, Park