Re: [Koha] Report help needed - lost items

2019-08-23 Thread Mark Alexander
Excerpts from Elaine Bradtke's message of 2019-08-23 11:32:44 -0700: > I've got the following adapted from one in the reports library. But I need > to limit it by item type, or not return everything that doesn't have an > item record attached. We've got lots of components in our catalogue that > d

Re: [Koha] Creating Lists of Item Numbers

2019-10-14 Thread Mark Alexander
Excerpts from Charles Kelley's message of 2019-10-14 18:18:16 +0900: > Can someone help me? Is there a tutorial on compiling item lists, bib. > record lists, patron lists, etc.? I believe that generating of lists is usually done with reports. See this section of the Koha manual: https://koha-

Re: [Koha] Problem with browser

2019-11-10 Thread Mark Alexander
Excerpts from Davide Spanu's message of 2019-11-10 09:58:08 +0100: > I have a problem with my koha server. I realized that after > importing a record (so before entering the copy data) the window of > some browsers closes automatically (Chrome and Firefox). Before this > problem did not occur (and

Re: [Koha] R: Problem with browser

2019-11-10 Thread Mark Alexander
[I'm copying the mailing list in case the real experts have better advice.] Excerpts from Davide Spanu's message of 2019-11-10 11:52:27 +0100: > I have seen that to solve the problem I have to modify a file, > eliminating the lines from 6 to 10 and add, in their place, the line > "var popup = '[%

[Koha] Cataloging tables, chairs, etc.

2019-12-26 Thread Mark Alexander
Our little library is planning to lend out things like folding tables, folding chairs, cake pans, tools, and all sorts of other equipment. I'm trying to figure out the best way to set up circulation rules for these things. My initial thought was to minimize the number of items types, and hence c

Re: [Koha] Cataloging tables, chairs, etc.

2020-01-01 Thread Mark Alexander
Many thanks to all who offered suggestions! I've forwarded them to our librarians (who are not on the mailing list). ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Printing overdue letters

2020-01-04 Thread Mark Alexander
My librarian has asked me to make Koha do something that doesn't sound easy to me. She'd like to be able to generate letters to each patron having overdues more than N days (where N is a variable). The letter would be then be printed, stuffed into an envelope, and mailed with the postal service.

Re: [Koha] Printing overdue letters

2020-01-05 Thread Mark Alexander
Excerpts from Mark Alexander's message of 2020-01-04 20:27:31 -0500: > I think this might work, except that I can't figure out how to get a > patron's list of overdue books into the generated letter. The SQL > would need to produce a CSV file with a single row for each patron, > containing the pat

Re: [Koha] Printing overdue letters

2020-01-06 Thread Mark Alexander
Excerpts from SATISH's message of 2020-01-06 17:34:26 +0530: > To overcome this problem, I have complied separate Library Dues Management > System using PHP and MySQL. Interesting. I was thinking of doing something along these lines using a Koha plugin. I find plugins really difficult to debug (

Re: [Koha] need help with accessing koha from outside via DynDNS

2020-02-06 Thread Mark Alexander
Excerpts from Heinz-Jürgen Oertel's message of 2020-02-06 13:32:34 +0100: > I can reach my network vi something.dnshome.de > With a port forwarding 80 -> 80 in the network router I can reach the test > page of the apache server. > How can I reach the koha server It's possible that Koha is lis

Re: [Koha] Using Koha on Android devices for revision

2020-02-20 Thread Mark Alexander
Excerpts from asakov...@hmcpl.org's message of 2020-02-11 16:20:11 -0600: > We’ve been evaluating the Tera Barcode Scanner Wireless 1D/2D/QR 2-in-1 unit > from Tera Digital (Germany). Thank you for this recommendation. I ordered the cheaper version of this scanner that works only with 1D scancod

[Koha] Mark a batch of items as missing?

2020-03-26 Thread Mark Alexander
After doing some inventory in our library, I obtained a list of the barcodes of a few dozen lost items. Now I'd like use the batch item modification tool to change the "lost status" for that set of items. But I don't see a way to do that with this tool. Is there another way? I'd like to avoid h

Re: [Koha] Mark a batch of items as missing?

2020-03-26 Thread Mark Alexander
Excerpts from Katrin Fischer's message of 2020-03-26 16:28:05 +0100: > check the settings for the subfield in your bibliographic frameworks and > make sure it's not hidden. Thank you for this hint. It turns out that in the default bibliographic framework in our installation (upgraded to 19.05.04

Re: [Koha] [koha] Barcode as a link report

2020-05-18 Thread Mark Alexander
Excerpts from muirunyeri's message of 2020-05-18 13:05:56 +0300: > I'm looking to create a report with barcode as a link that when will clicked > will open the edit items page. There are some examples here that might help: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Links_by_item __

Re: [Koha] Barcode as a link report

2020-05-19 Thread Mark Alexander
Excerpts from muirunyeri's message of 2020-05-19 11:10:33 +0300: > However if anybody would help me understand why I get an error (biblionumber > is ambiguous) after adding any field from biblio table I'd be really > grateful. This after correctly adding a left join for the biblios table using >

Re: [Koha] Report help needed

2020-05-27 Thread Mark Alexander
Excerpts from Michael Sutherland's message of 2020-05-27 16:59:50 -0400: > CASE SUBSTR(metadata,282,2) I tried this myself, and it does seem to work. But I worry that the 282 value might not be correct in the future, should the XML format of the metadata change even slightly. In particular, the

[Koha] Error staging MARC records

2020-06-05 Thread Mark Alexander
I recently upgraded our Koha from 19.05 to 19.11.06, and upgraded the underlying OS from Debian 8 to Debian 9. I'm now getting an error when I try to stage MARC records for import. The upload seems to work correctly, and I see the uploaded file in /tmp/koha_rpl_upload/, but Koha says the file doe

Re: [Koha] Error staging MARC records

2020-06-05 Thread Mark Alexander
It turned out that the configuration issue was a missing tmp_path entry in koha-conf.xml. There was some information about this in bugzilla 20428; it seems the Debian 9 has issues with /tmp. Here are the relevant entries in my fixed koha-conf.xml: /var/lib/koha/rpl/uploads /var/lib/koha/rpl/tm

Re: [Koha] General Query

2020-07-19 Thread Mark Alexander
Excerpts from Sanjay Uchcharia's message of 2020-07-19 19:56:45 +0530: > How would I find/see my Koha z39.50 target? This might help: https://wiki.koha-community.org/wiki/Setting_up_the_Z39.50_and_SRU_Server and: https://wiki.koha-community.org/wiki/Troubleshooting_Koha_as_a_Z39.50_server _

Re: [Koha] SQL edit for Non-circulating items report

2020-07-31 Thread Mark Alexander
Excerpts from David Sale's message of 2020-07-31 19:12:13 +: > However, adding "b.isbn" to the SELECT list (as with "b.title", "b.author", > etc.) breaks the report and renders it non-functional. You might find this page useful, since it does provide some isbn examples: https://wiki.koha-com

[Koha] Holds and quarantine

2020-09-15 Thread Mark Alexander
I've tried to search my Koha mailing list archives, and studied the 19.05 manual for a solution to the following problem, but I'm either overlooking something or the problem hasn't been discussed. Our little library has a pandemic protocol where books that are returned (in a drop box) are checked

Re: [Koha] Holds and quarantine

2020-09-16 Thread Mark Alexander
Excerpts from mik's message of 2020-09-16 19:27:46 +0200: > Maybe the section "How will this help libraries?" of the following > how-to will give you more ideas: > > https://bywatersolutions.com/education/new-system-preference-for-trapping-holds Excellent, thank you! I missed this, and I believ

Re: [Koha] SIP2 and telnet.

2020-10-18 Thread Mark Alexander
Excerpts from sam aikins's message of 2020-10-18 03:09:06 +0800: > Has anyone been able to telnet to SIP2 successfully. It works for me, and I also wrote a couple of Ruby scripts that use telnet to test the SIP2 connection. Here's one of those with the library, username, and password anonymized.

Re: [Koha] Koha and Kanopy integration via SIP2

2020-11-04 Thread Mark Alexander
Excerpts from Steve Nickerson's message of 2020-11-04 12:16:45 -0500: > Does anyone have experience getting Koha "connected" to Kanopy via SIP2? I have done this, and it was not a trivial task. Our library decided that the use of Kanopy should be enabled or disabled for each patron, and not globa

Re: [Koha] Plugin Administration and Installation

2020-11-24 Thread Mark Alexander
Excerpts from mik's message of 2020-11-20 11:36:44 +0100: > You will also have to activate Koha system preference "UseKohaPlugins". > > Then you'll find the plugin option in Koha menu "Tools". > > This is all described in the fine Koha manual: > > * https://koha-community.org/manual/20.05/en/htm

Re: [Koha] Plugin Administration and Installation

2020-11-24 Thread Mark Alexander
Excerpts from Tomas Cohen Arazi's message of 2020-11-24 17:24:21 -0300: > Did you restart memcached as well? The changes to the koha-conf.xml file > are cached. I just tried that, and it had no effect. This problem occurred before I made any attempts to change koha-conf.xml, which was already set

Re: [Koha] Autodelete backups older than 5days

2020-12-05 Thread Mark Alexander
Excerpts from muiru james's message of 2020-12-05 13:10:56 +0300: > I have my Koha instance backing up automatically to dropbox through a bash > script. I need to automatically delete archives older than 5 days. How do I > do it? If you're using rsync to send the backups from your Koha server to d

Re: [Koha] Koha 20.11 Plugins

2020-12-17 Thread Mark Alexander
Excerpts from Nelson Mwirigi's message of 2020-12-17 09:51:27 +0300: > Thank you. I had installed Koha 19.05. So when I installed koha 20.11 and > restored backup from Koha 19.05, I am not able to see the plugin option > under "Tools" so I cannot even add plugin. This confused me for a couple of

Re: [Koha] Barcode's continued

2021-02-18 Thread Mark Alexander
Excerpts from library's message of 2021-02-18 10:22:59 -0600: > I tried the perl that Jonathan sent but the Internet did not give good > advise on how to run the perl. Here is what I typed: When I compare Jonathon's script with yours, I see some typos in yours: holingbranch =>$b

Re: [Koha] Upgrade OS - Ubuntu 18.04 to 20.04

2021-06-25 Thread Mark Alexander
Excerpts from Alvaro Cornejo's message of 2021-06-25 18:25:51 -0500: > We also use a VPS provider (Linode) for the koha hosting. > > What we do when migrating to a major version is to create a new VPS, > install everything from scratch, move the DB from the old system to the new > one, do the DB c

Re: [Koha] Reason to define Koha item type in 942

2021-10-15 Thread Mark Alexander
Excerpts from Bales (US), Tasha R's message of 2021-10-14 19:13:14 +: > I recall reading (in the Koha manual?) the explanation for why it is > advantageous to define Koha item type in the bib 942 field. I believe it has > to do with exporting records, or the scope of records that is included

Re: [Koha] Migrate checkouts with koc file

2021-12-14 Thread Mark Alexander
Excerpts from Bales (US), Tasha R's message of 2021-12-10 17:46:06 +: > In short, is there a way to make my own .koc file from scratch by supplying > the extension, necessary columns, and required header? Thanks for your time, Yes, you can do this. I did this as part of a migration from Man

Re: [Koha] software error while batch editing records

2022-01-02 Thread Mark Alexander
Excerpts from Mathieu Saby's message of 2022-01-02 12:52:34 +0100: > Template process failed: undef error - unexpected end of string while > parsing JSON string, at character offset 65535 (before "(end of > string)") at .../Koha/BackgroundJob.pm line 182. That 65535 (0x in hex) is pretty suspi

[Koha] Importing encrypted patron passwords

2022-02-05 Thread Mark Alexander
I'm in the process of upgrading a library's Debian 7/Koha 3.16 setup. This installation is so old that an in-place upgrade can't be done. My plan is to first create a test VM with Debian 10 and the latest stable koha-common. Then after manually setting up various admin things (library, item types

Re: [Koha] Importing encrypted patron passwords

2022-02-05 Thread Mark Alexander
Excerpts from Alvaro Cornejo's message of 2022-02-05 19:40:08 -0500: > I'll however suggest you do the backup load/upgrade before configuring the > server since some of the data uses DB indexes to be identified. Let me see if I understand this. Is this the order of steps you're recommending? 0.

Re: [Koha] Importing encrypted patron passwords

2022-02-06 Thread Mark Alexander
Thanks for the help. The koha-upgrade-schema step went well until this: Upgrade to 3.19.00.037 done (Bug 13810: Change collate for tagsubfield (utf8_bin)) {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Incorrect datetime value: '-00-00 00:00:00' for column `koha_cfl`.`virtualshelves`.

Re: [Koha] Importing encrypted patron passwords

2022-02-06 Thread Mark Alexander
I've managed to get the database upgrade to succeed, but it failed at four different places: * 3.19.00.037 * 3.21.00.027 * 3.23.00.041 * 16.06.00.050 The fixes involved manual updates to the database, or commenting out lines in updatedatabase.pl, or both. Thanks to all those who offered help.

[Koha] koha-z3950-responder and item status

2022-02-13 Thread Mark Alexander
I've been fighting with the Z3950 responder for several years now. In particular, I want get it to respond with a 952$k field that gives an item status as "Available" or "Checked out". In the past (prior to 19.11) I've had to install my own version of ByWater's Z3950 responder, and invoked it wi

Re: [Koha] koha-z3950-responder and item status

2022-02-13 Thread Mark Alexander
Excerpts from Mark Alexander's message of 2022-02-13 12:08:33 -0500: > Now it seems that in recent Koha, you're supposed to start the Z3950 responder > with /usr/sbin/koha-z3950-responder. But this script doesn't seem to > offer any equivalent to --add-item-status=k. I was in a hurry, so I patche

Re: [Koha] Problem with the Koha Upgradation

2022-03-08 Thread Mark Alexander
Excerpts from Shiva Kumara's message of 2022-03-07 12:57:51 +0530: > {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate column name > 'letternumber' at /usr/share/perl5/DBIx/Class/Schema.pm line 1118. I ran into this problem recently when I upgraded Koha 3.16 to the latest stable Koha

[Koha] Multiple simultaneous connections to SIP2

2022-06-21 Thread Mark Alexander
We have a content provider, Lyrasis, attempting to use a SIP2 connection to our Koha server to do user authentication. Lyrasis claims that our SIP2 server is not able to handle multiple simultaneous connections, but but I could not reproduce the problem with my own test scripts. I was wondering

Re: [Koha] How To Add OCLC in Koha Z39.50 Server.

2023-05-05 Thread Mark Alexander
I'm not an expert on this, but it appears that zcat.oclc.org requires you to provide your OCLC user name and password, as mentioned in the message mentioned previously: https://www.mail-archive.com/koha@lists.katipo.co.nz/msg25554.html Here is what happened when I tried to connect using yaz-clien

Re: [Koha] Regarding Installation of KOHA in window 1o

2017-03-27 Thread Mark Alexander
Excerpts from Lalit Thakur's message of 2017-03-27 13:47:13 +0530: > How can install KOHA Live DVD in window 10. I am trying but I am not > success. So kindly guide me. Koha is best installed on Debian 8. If you really must use Windows, you could run Debian in a virtual machine; VMware Workstatio

Re: [Koha] Import staged MARC records with ElasticSearch engine

2017-04-17 Thread Mark Alexander
Excerpts from Abdulsalam Yousef's message of 2017-04-17 11:04:58 +0300: > - Importing MARC records into catalog form (Manage staged MARC records) in > staff client GUI using ElasticSearch engine is very slow and accidentally > stops after importing some hundreds of records, That we may spend 3 days

Re: [Koha] zebra - item-level_itypes errors

2017-04-19 Thread Mark Alexander
Excerpts from Tom Hanstra's message of 2017-04-19 12:13:30 -0400: > item-level_itypes set but no itemtype set for item (item#) at > /usr/share/koha/lib/Koha/Schema/Result/Item.pm line 698 Our installation has item-level_itypes enabled, but all of our item records (imported from another ILS) have t

Re: [Koha] Koha slowed down by Google indexing?!

2017-05-03 Thread Mark Alexander
> When I searched for who is 66.249.64.32 I saw this IP addresse belongs > to Google. This does seem to be the Google indexer: % nslookup 66.249.64.32 ... 32.64.249.66.in-addr.arpa name = crawl-66-249-64-32.googlebot.com. I haven't seen this problem (yet), but perhaps that is because I

Re: [Koha] Koha slowed down by Google indexing?!

2017-05-03 Thread Mark Alexander
Excerpts from Michael Kuhn's message of 2017-05-03 16:14:55 +0200: > # ufw status > Status: active > > To Action From > -- -- > 22/tcp ALLOW Anywhere > 80/tcp ALLOW An

Re: [Koha] Koha Digest, Vol 139, Issue 14

2017-05-09 Thread Mark Alexander
Excerpts from Ghulam Mustafa Zaman's message of 2017-05-09 07:15:05 -0200: > i am new koha user and recently i have applied koha software in my college > library so i need help in few functions like how to create backup of Data . This should help: https://wiki.koha-community.org/wiki/Backing_up_K

Re: [Koha] Slow Koha OPAC login process

2017-05-09 Thread Mark Alexander
Excerpts from Michael Kuhn's message of 2017-05-09 19:57:51 +0200: > With my poor Perl knowledge I have now measured the execution time of > the various parts of script "opac-user.pl". As I found out everything is > always very fast (using less than 1 second execution time) except the > very las

Re: [Koha] Status lost for items

2017-06-22 Thread Mark Alexander
Excerpts from Søren Hovmand's message of 2017-06-22 14:03:15 +: > To my question - apologies if it should be obvious: Where do I mark > an item lost? I can find documentation on where it should be (Item > Statuses/Edit item) but not find the option anywhere in our test > installation (version 1

Re: [Koha] Searching capability dies every few days - Zebra problem?

2017-07-31 Thread Mark Alexander
Excerpts from mpw's message of 2017-07-31 06:24:49 -0700: > I set up Koha a few months ago and we're still learning the system. One > thing we've noticed that presumably is not normal is that every few days the > searching capability dies for some reason or other. My guess is that it has > somethin

Re: [Koha] Patron Club feature

2017-08-09 Thread Mark Alexander
Excerpts from Krishna K's message of 2017-07-30 06:02:15 +: > We recently upgraded to 17.05.01 from 16.11.05. When we try to use the > clubs feature by clicking on Tools-> Patron Clubs link, we are getting 404 > error. We dont seem to be having the clubs.pl file. What should we do ? > Appreciat

[Koha] Import holds?

2017-08-11 Thread Mark Alexander
Our little (24K items) library has successfully moved from Mandarin to Koha as of Tuesday. I was able to import the catalog, patrons, and checkouts (issues) from Mandarin by writing scripts to convert Mandarin-generated data to Koha-compatible data. The one missing thing is holds (reserves). I'm

Re: [Koha] Import holds?

2017-08-15 Thread Mark Alexander
Excerpts from Katrin Fischer's message of 2017-08-15 12:47:45 +0200: > holds information is stored differently in every ILS and at the moment > there exists no generic tool to import holds into Koha. For a migration > you could try to map the data you get out of Mandarin to the columns in > Koha

Re: [Koha] How to import loans data into Koha?

2017-08-15 Thread Mark Alexander
Excerpts from Chris Brown's message of 2017-08-15 21:06:52 +0100: > We are migrating records from a few small community libraries (currently > held as a fancy spreadsheet) into Koha 17.05. I have figured out how to > migrate the biblio records, items and patron data but I was wondering if > there i

Re: [Koha] How to import loans data into Koha?

2017-08-15 Thread Mark Alexander
Excerpts from Mark Alexander's message of 2017-08-15 19:03:46 -0400: > Excerpts from Chris Brown's message of 2017-08-15 21:06:52 +0100: > > [...] but I was wondering if > > there is a way to import data on current issues (loans)? All we really > > need to import is the item ID, the patron ID and

Re: [Koha] Koha 16.11.04 - Setting a template cache directory

2017-08-27 Thread Mark Alexander
Excerpts from Prof. Lisandro Laura's message of 2017-08-26 11:05:34 -0300: > Could anyone please point me to a simple step by step instruction to > set entry in my koha-conf.xml file? As I mentioned in my earlier email, I created the cache directory as follows: mkdir -p /var/cache/koha/INSTANC

Re: [Koha] 4 Perl Modules Not Installed on Koha 17.05.03.000

2017-09-05 Thread Mark Alexander
Excerpts from Mark Tompsett's message of 2017-09-05 03:57:06 +: > > WebService::ILS (0.07) > > On newer versions this is the only one that you will probably care about. Can you explain what this module is used for in Koha? It was missing in my installations of 17.05.03, but Koha seemed happy

Re: [Koha] 4 Perl Modules Not Installed on Koha 17.05.03.000

2017-09-05 Thread Mark Alexander
Excerpts from Mark Tompsett's message of 2017-09-05 14:10:59 +: > The major problem with cpan'ing your modules is that if you cpan them, and > then a newer version comes out with a fix/enhancement, the search paths used > by Perl will more likely find your CPAN'd versions rather than the DEB'

[Koha] Kitchen sink plugin and GetBranchName

2017-09-13 Thread Mark Alexander
In order to learn how to write a plugin, I installed the Kitchen sink plugin: https://github.com/bywatersolutions/koha-plugin-kitchen-sink into stock Koha 17.05. When I ran the plugin's report tool, I got this error: Undefined subroutine &Koha::Plugin::Com::ByWaterSolutions::KitchenSink::

Re: [Koha] Data not found

2017-09-15 Thread Mark Alexander
Excerpts from Luis Moises Rojas's message of 2017-09-15 09:23:17 -0400: > Everyday in the morning, i have to run this script: > Koha-rebuild-zebra -f -v -b -r {Koha instance} > > if i do not do this: we can not see any data, not search is found, etc. > Why? It could be that the zebra server is no

Re: [Koha] Hide MARC View separator

2017-09-17 Thread Mark Alexander
Excerpts from | dalmeida |'s message of 2017-09-16 18:57:03 +0100: > Does anyone know how to hide MARC View separator on book Details page? I'd > like to have only Normal View and ISBD View. I used the following as a hint: https://wiki.koha-community.org/wiki/JQuery_Library#Hide_Marc_.26_ISBD_

[Koha] Z39.50, ILL, and 952$r

2017-09-21 Thread Mark Alexander
Our little state (hint: starts with "V") has implemented an interlibrary loan system that seems to be unable to use Z39.50 correctly to query Koha in order to determine an item's availability. I'll try to describe the problem and then ask if there's a workaround in Koha. The state ILL system, cal

Re: [Koha] Z39.50, ILL, and 952$r

2017-09-21 Thread Mark Alexander
I made a silly mistake in my previous message: I meant 952$q (onloan), not 952$r (datelastseen). ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Z39.50, ILL, and 952$r

2017-09-21 Thread Mark Alexander
Excerpts from Jason Robb's message of 2017-09-21 16:53:16 -0500: > Along with the other systems that use Koha in Kansas, we have worked with > ByWater on this. You can see the details here: https://bugs.koha- > community.org/bugzilla3/show_bug.cgi?id=13937. The basic idea is that > whenever a z39.5

Re: [Koha] Z39.50, ILL, and 952$r

2017-09-22 Thread Mark Alexander
Excerpts from Tomas Cohen Arazi's message of 2017-09-21 23:44:56 +: > Wow. I hadn't noticed that new feature! I applied the patches to our Koha installation and it does seem to work when I invoke the server as follows: koha-shell cd /usr/share/koha perl bin/z3950_responder.pl --add-ite

[Koha] Regexp in MARC modification action

2017-11-22 Thread Mark Alexander
I'm trying to use a MARC modification template to fix the 952$d field in MARC records we receive from our library supply house. This field is supposed to be the acquisition date, but is coming to us in the format /MM/DD instead of the required -MM-DD. So I needed to find a way to replace

Re: [Koha] OAI-PMH Set Question

2017-11-22 Thread Mark Alexander
Excerpts from Alphie Garcia's message of 2017-11-22 09:56:03 -1000: > When I'm in Linux and type: > > perl /usr/share/koha/bin/migration_tools/build_oai_sets.pl > > > I get the following error: > > Can't locate C4/Context.pm in @INC (you may need to install the C4::Context > module) (@INC conta

Re: [Koha] Regexp in MARC modification action

2017-11-27 Thread Mark Alexander
Excerpts from Jonathan Druart's message of 2017-11-26 16:45:08 +: > The "ig" in the modifiers input is a placeholder, not the default. > It is displayed as it to let you know 'i' and/or 'g' are possible modifiers. > Please try again explicitly specifying "ig" in the input box and it should > wo

Re: [Koha] koha not sending email notices for Check in, Check out, Overdue etc.

2017-12-01 Thread Mark Alexander
Excerpts from Javed Sahil's message of 2017-12-01 12:36:37 +0500: > *# PERL5LIB="/usr/share/koha/lib"# > KOHA_CONF="/etc/koha/sites/library/koha-conf.xml"# cd > /usr/share/koha/bin/cronjobs* > > above commands go fine but when i try the following command, > > *# ./*process_message_queue.pl > > i

Re: [Koha] Email status changes failed from pending

2017-12-04 Thread Mark Alexander
Excerpts from Javed Sahil's message of 2017-12-03 16:05:23 +0500: > 5../process_message_queue.pl > > this error message appears: > > connect to localhost failed (Connection refused) This sounds to me like a postfix configuration problem. What happens when you try this? telnet localhost 2

Re: [Koha] Can't run auth_show_hidden_data.pl script

2017-12-06 Thread Mark Alexander
Excerpts from Prof. Lisandro Laura's message of 2017-12-06 11:41:57 -0300: > perl ./usr/share/koha/bin/maintenance/auth_show_hidden_data.pl > > But I get the following error: > > "Can't locate Koha/Authorities.pm in @INC (you may need to install the > Koha::Authorities module) (@INC contains: /et

Re: [Koha] SQL help please

2017-12-11 Thread Mark Alexander
Excerpts from Pedro Amorim's message of 2017-12-11 14:18:08 -0100: > This should work: > > Select title, author, i.itemcallnumber from biblio b > Left join biblioitems bi on b.biblionumber=bi.biblionumber > Left join items i on bi.biblionumber=i.biblionumber > where i.barcode IN ("BARCODE1", "BARC

Re: [Koha] ILS Z39.50 server information where to look for?

2017-12-15 Thread Mark Alexander
Excerpts from Bustillos, Corina's message of 2017-12-15 19:20:55 +: > I was wondering if anyone knows where I can find the following information > within KOHA. > IP address of the ILS Z39.50 server > Port that Ze9.50 searches use > Database name. By default the Z39.50 server has the same IP a

Re: [Koha] Import of .KOC file into Koha 17.11 hangs

2017-12-28 Thread Mark Alexander
Excerpts from Chris Brown's message of 2017-12-27 17:03:17 +: > Using a fresh install of Koha 17.11.00 (from Debian packages) I have > successfully loaded our patron data, our catalog and our items. However > when I try to import an offline circulation (.koc) file, nothing happens. > The progre

Re: [Koha] Can't locate LangInstaller.pm in @INC

2017-12-30 Thread Mark Alexander
> > root@srv2:/usr/share/koha/misc/translator# perl > > -I/usr/share/koha/misc/translator translate install it-IT > > Can't locate TmplTokenizer.pm in @INC (you may need to install the > > TmplTokenizer module) (@INC contains: /usr/share/koha/lib /etc/perl > > /usr/local/lib/x86_64-linux-gnu/per

Re: [Koha] Problems adding new members in 17.11

2018-01-02 Thread Mark Alexander
Excerpts from Tim McMahon's message of 2018-01-02 16:26:39 -0600: > I'm testing 17.11 (package upgrade from 17.05.02) and when I try to > enter a new patron, the Password and Confirm password fields in the > OPAC/Staff login section near the bottom of the form will get labeled > "This field is r

Re: [Koha] SQL help

2018-01-09 Thread Mark Alexander
Excerpts from Elaine Bradtke's message of 2018-01-09 11:06:16 -0800: > "Unknown column 'place' in 'field list'" > Here's the report - what field name do I need to replace place?: > select > b.biblionumber, author, title, > ExtractValue(metadata, '//datafield[@tag="245"]/subfield[@code="b"]') as

Re: [Koha] Export from one library, Import to another?

2018-01-15 Thread Mark Alexander
Excerpts from Alvin W.'s message of 2018-01-15 16:43:12 -0500: > Basically, I don't care about the content, I just want a verified file that > I was able to Import correctly, to serve as a baseline for the actual > collection when I load it, so that if errors occur, it should be easier to > figure

[Koha] DDoS attack on memcached

2018-02-28 Thread Mark Alexander
Apparently, a bug in memcached (which we use in Koha) causes it to be used an intermediary in a DDoS attack: https://arstechnica.com/information-technology/2018/02/in-the-wild-ddoses-use-new-way-to-achieve-unthinkable-sizes/ I'm not an expert on this kind of thing by any means, but judging from t

Re: [Koha] Out of memory

2018-03-19 Thread Mark Alexander
Excerpts from Rubeno Fernández's message of 2018-03-19 07:12:29 +0100: > How much memory do you need to run Koha? > I run a database with about 22000 records on a virtual server on Digital > Ocean > with 1GB memory and very low usage, but the server is crashing very often. We're running Koha 17.

Re: [Koha] Koha Performance

2018-03-20 Thread Mark Alexander
Excerpts from Narcis Garcia's message of 2018-03-20 10:38:26 +0100: > 1. What is the concrete indicator that Plack is enabled and running or not? In the "About Koha" page, immediately after the "Apache version:" line, you should see a line that looks like this: PSGI: Plack (deployment) ___

Re: [Koha] Zebra stops every day

2018-04-04 Thread Mark Alexander
Excerpts from Javed Sahil's message of 2018-04-04 17:44:23 +: > I am using Koha17.11, I moved my old DB which was working fine in koha16.11, > > But now my zebra server stops daily or after two or three days, actually > i have not noted exact duration. It might be this problem: https://bugs

Re: [Koha] added new library branch -- lost all collections

2018-04-11 Thread Mark Alexander
Excerpts from Jack Boulier's message of 2018-04-11 04:25:23 +: > I have ubuntu xenial and koha 17.11.04. I added a new library to the database > and added some books to that library. When I did a search for the text I > could not find them as a superuser. The search would always query the >

Re: [Koha] Importing MARC records with items

2018-04-18 Thread Mark Alexander
Excerpts from Sean Carte's message of 2018-04-18 10:44:45 +0200: > I have records that I have exported from SirsiDynix Symphony that I'm > trying to import into a new instance of Koha. The bib records load, but the > items are not added. >[...] > 952 > > *_a*657 GAA V.1 This doesn't look quite ri

Re: [Koha] Fwd: OPAC Page not available and login credentials don't work

2018-05-29 Thread Mark Alexander
Excerpts from Bedanta Borah's message of 2018-05-28 10:45:54 -0700: > 2) In case of koha livedvd, all features were doing fine untill I updated > the system and the koha-common packages. After the update, my root user and > password (koha_library & koha123) stopped working. But I can login with >

Re: [Koha] ssl for koha login

2018-06-05 Thread Mark Alexander
Excerpts from Alvaro Cornejo's message of 2018-06-04 21:18:57 -0500: > I´m trying to setup a ssl connection to Koha (using letsEncrypt certs ) so > my users, admin and opac can have a secure connection. > > I´ve folllowed letsEncrypt & certbot instrucctions but neither opac nor > admin pages work

Re: [Koha] SQL Report not populating

2018-06-12 Thread Mark Alexander
I tried your query with the WHERE clause slightly simplified to give a non-empty result on my test installation of 18.05: WHERE (TO_DAYS(curdate())-TO_DAYS(date_due)) >= '' I was then able to download the CSV file and read it into LibreOffice Calc with no problems. So your query looks good; ma

Re: [Koha] Migration from Mandarin to Koha

2018-06-15 Thread Mark Alexander
Excerpts from Mr Mutsikiwa Admire's message of 2018-06-15 16:55:38 +0200: > I want to migrate bibliographic records from a Mandarin to Koha. > Currently, I am guided by the resource > http://www.bloovis.com/2017/08/09/mandarin-to-koha.html. I am wondering > if there are any generic resources tha

Re: [Koha] zebra shutting down - no search

2018-06-21 Thread Mark Alexander
Excerpts from Scott Owen's message of 2018-06-21 09:16:56 -0400: > I still seem to be having some issues with logrotate and the zebra service > starting up > > I have tried both of the options discussed in bug # > https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16885 I was able to s

Re: [Koha] 18.05.01 up gradation login access denied

2018-07-16 Thread Mark Alexander
Excerpts from Arshad Iqbal's message of 2018-07-16 17:59:22 +0500: > I have upgraded koha version 16.05 to 18.05.01. After upgraded i am trying > to login with master username and password but access denied to login error > facing. This is described in the release notes for 18.05: https://koha-c

Re: [Koha] Reservoir records deletion

2018-08-09 Thread Mark Alexander
Excerpts from Hira Akram's message of 2018-08-09 17:30:07 +0500: > I want to delete all biblio records from my koha but they are still appearing > in reservoir. How to remove them? I have deleted them from catalogue and they > are not imported so I cant clean the batch. This is how I did it:

Re: [Koha] Matric Number and Barcode not Showing on Library Card

2018-11-07 Thread Mark Alexander
Excerpts from olufunmilayo favour's message of 2018-11-07 08:01:57 +: > I configured my university's koha library card and it works > perfectly for the undergraduate students whose matriculation numbers > are in this format AAA/12345678 and varchar was selected for the type > at PHPMyAdmin. Ho

[Koha] OPAC holdings table in 18.11 shows   instead of blank

2018-12-22 Thread Mark Alexander
I've just upgraded one of my Koha VMs from 18.05 to 18.11, and also created a new install of 18.11 in another VM, and both exibit a new issue: In the OPAC, when looking at the MARC view for an item, there is a table at the bottom of the page showing some holding information. Those table fields th

Re: [Koha] OPAC holdings table in 18.11 shows   instead of blank

2018-12-24 Thread Mark Alexander
Excerpts from Mark Alexander's message of 2018-12-22 11:56:33 -0500: > In the OPAC, when looking at the MARC view for an item, there is a > table at the bottom of the page showing some holding information. > Those table fields that used to be blank in 18.05 are now displaying > as " " (without the

Re: [Koha] Koha Duplicating Items

2019-02-12 Thread Mark Alexander
Excerpts from Myriam Torres's message of 2019-02-12 11:22:18 +0200: > [...] The problem is that instead of creating a single item with > all the information it creates many items with different information. This > is my mrc file: > [...] > =952 \\$aAKL > =952 \\$bAKL > =952 \\$o005.265 > =952 \

Re: [Koha] Koha importing biblio with items error

2019-02-13 Thread Mark Alexander
Excerpts from Dorothy Chong's message of 2019-02-12 20:14:48 +0800: > Our library is hoping to transfer into Koha but has so far had issues with > staging the records with items. Without the 952 field it works fine, and it > also worked fine when it was just 952$a, $b, and $y. Whenever I try to s

Re: [Koha] New OPAC design

2019-04-01 Thread Mark Alexander
This is wonderful work. We're going to adopt it at our little rural library, since most of our patrons are over 50, and we need to encourage more young people to visit. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://list

Re: [Koha] Koha 18.11

2019-04-19 Thread Mark Alexander
Excerpts from Luisa Korodrau's message of 2019-04-19 08:12:05 +1200: > 1. uploading photos for patrons record. The photo uploading icon is not > there. Where can I find it and how is it done Have you set the "patronimages" system preference to "allow"? There is some information here: https://ko

[Koha] Hello from Vermont

2016-08-28 Thread Mark Alexander
Hi all, I'm a retired software geek, now living in a small town in Vermont after many years in Silicon Valley. I've been using Linux on my own computers for 20 years, and have hacked on everything from microkernels in assembly language to web apps in Ruby on Rails. I also spent a year in NZ as a

  1   2   >