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
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-
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
[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 = '[%
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
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
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.
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
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 (
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
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
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
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
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
__
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
>
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
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
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
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
_
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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.
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`.
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.
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
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
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
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
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
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
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
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
> 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
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
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
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
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
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
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
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
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
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
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
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
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
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'
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::
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
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_
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
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
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
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
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
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
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
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
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
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
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
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
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
> > 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
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
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
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
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
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.
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)
___
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
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
>
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
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
>
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
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
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
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
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
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:
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
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
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
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 \
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
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
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
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 - 100 of 132 matches
Mail list logo