ain
> that in more detail?
>
> *Joel Coehoorn*
> Director of Information Technology
> *York University*
> Office: 402-363-5603 | jcoeho...@york.edu | york.edu
>
>
>
> On Thu, Jul 6, 2023 at 2:32 PM muiru james wrote:
>
>> Hello team,
>>
>&
Hello team,
Im trying to create a sql query that will return a count of books that will
have a datelastseen from a date picker and combine/add all books on loan
for the particular itemtype.
I have 2 different itemtypes and would like a count for each itemtype to
include those with a datelastseen
Hello,
I want to bulk import records with items via terminal and I want to match
records using title(245a) where if it exists to skip the incoming record
but add items.
How can I modify this script not to replace existing record with incoming
one?
perl bulkmarcimport.pl -framework BKS -b -file
Hello
I want to bulk import records with items via terminal and I want to match
records using title(245a) where if it exists to skip the incoming record
but add items.
How can I modify this script not to replace existing record with incoming
one?
perl bulkmarcimport.pl -framework BKS -b -file
t; Hope this helps,
>
> Katrin
>
> On 31.05.22 21:35, muiru james wrote:
> > Hello all,
> >
> > I have some records without the 942c itemtype but 952y has the data.
> > How can I bulk edit records or copy the data from 952y to 942c?
> >
> > Warm Regards
>
Hello all,
I have some records without the 942c itemtype but 952y has the data.
How can I bulk edit records or copy the data from 952y to 942c?
Warm Regards
James
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe:
ething else. If it only works from the computer you’re on, that is
> to be expected. Find the IP of the server and use that IP to replace
> 127.0.0.1. Note that this may only work from within your local network.
>
> Sent from ProtonMail for iOS
>
>
> On Wed, May 18, 2022 at
Hi,
I got interested in this discussion and tried to attach an a pdf to a
record in koha. (Followed bywater solutions video on
https://youtu.be/mbYgsodcPaU)
My pdf cannot however open. I get a request denied from 127.0.0.1. It opens
if I log in from the server but not from any other computer.
des to
> enter in the field (A, C, I, P, S or X), otherwise the report will not
> give any results.
>
> - As of version 21.05, there is an option to make a text field a text
> area for several values
> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27380
>
> Regards
Hi Owen and All,
Thank you for your quick reply and very good advice. I will follow your
idea on good documentation in the report.
I have no knowledge on runtime parameters but thanks for that pointer too.
If you can increase my knowledge on how to tell an authorized value or
where to look I'd
Hi team,
I am trying to create a report that allows me to get circulation statistics
based on the category_type from the categories table rather than
categorycode. Putting the values in the query e.g. I for organization
patrons, A for adults e.t.c. works well. However, I need to be able to
select
your results.
>
> Also just noticed that you're using biblioitems.publishercode as ISBN, I'm
> sure you know this, but there is also a biblioitems.isbn field that might
> be mapped more accurately for you to use for this purpose.
>
> Hope that helps!
>
> Aleisha
> On 2/08/21
Hello team,
I recently reinstalled koha 20.05 on Ubuntu 20. I'm running a complete
shelflist report with columns biblio.author, biblio.title. However for new
items added to the records, columns for author and title are blank. I have
tried to use the extractvalue from biblio_metadata and the
Hello,
Our server running koha 20.05 on ubuntu focal fossa cannot batch modify
items. After scanning the barcodes n clicking the continue button, it
returns the items details but after setting the date last seen and saving
the changes, the progress bar remains stuck at 0%. I have tried to use the
subfields of the 035 present in your data.
>
>
> Tasha Bales
> Business Support Team | Information Services
> Enterprise Services | Enterprise Operations, Finance and Sustainability
>
> -Original Message-
> From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Beha
Hi,
I've tried creating a new record matching rule to use tag 035a and despite
trying a lot of things its not working. Field 035a contains a four digit
arabic number (e.g. 1500).
Someone please help me create the rule.
Regards
James
___
Koha mailing
Hello all,
I have three different reports that give a count of books by DDC numbers.
- Books on shelves
- Books on loan
- Damaged books
I'm looking to combine the queries to give me one report with three columns
as under:
Books on shelves | Books on loan | Damaged Books
Is there a way to do
is should already be available in the standard export
> on the table itself. If it's not visible, maybe check the settings under
> Administration > Table configuration.
>
> Hope this helps,
>
> Katrin
>
> On 16.04.21 12:56, muiru james wrote:
> > Hi,
> >
> > I
Hi,
I'm using koha 20.05 on ubuntu 18.04.
I love using the export feature to download my bulk checkouts to excel. I
however wish to have a different column for title, barcodes and author at
the export point instead of editing the downloaded file.
Is it possible to define my columns and also add
not sure how to explain it well.
>
> Sorry!
>
> Katrin
> On 13.03.21 13:47, muiru james wrote:
>
> Thanks Katrin for your reply.
>
> Could you give me more details on how to go about it so that I can give it
> a try?
>
> Most appreciated
>
> Regards
> James
&g
t; interface/GUI. You could try and use SQL to do it server side. All
> reports can be found in the table saved_sql.
>
> Hope this helps,
>
> Katrin
>
> On 13.03.21 10:07, muiru james wrote:
> > Hi,
> >
> > Is there a way to add export reports from
Hi,
Is there a way to add export reports from one system and add them in bulk
to a new server?
Regards
James
___
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
: http://medstarauthors.org
>
> The important thing to remember is that it's never too late to learn, it
> just becomes increasingly pointless as you start to forget everything a few
> minutes after learning it.
> --Jeremy Hardy
>
> -Original Message-
> From: Koha On Behalf
Your koha-conf.xml had a blank .
On Fri, Mar 12, 2021 at 4:27 PM Tomas Cohen Arazi
wrote:
> What was it?
>
> El vie, 12 mar 2021 a las 10:17, muiru james ()
> escribió:
>
>> The backups issue was resolved.
>>
>> Thanks you
>>
>> On Wed, M
The backups issue was resolved.
Thanks you
On Wed, Mar 10, 2021 at 11:18 AM muiru james wrote:
> Hello team,
>
> I have a system that has no backups to download at the export data,
> backups in the tools module. The config file is well edited to allow for
> the backups via
Hi
I am installing koha on ubuntu v 20 and I am stcu at installing
mariadb-server.
I get this error
*The following packages have unmet dependencies: mariadb-server : Depends:
mariadb-server-10.5 (>= 1:10.5.9+maria~focal) but it is not going to be
installedE: Unable to correct problems, you
The folder is empty
On Wed, Mar 10, 2021 at 5:06 PM Indranil Das Gupta
wrote:
> That is what it is supposed to do. Check under /var/spool/koha/instance if
> files have been created.
>
>
> On Wed, 10 Mar, 2021, 6:37 pm muiru james, wrote:
>
> > Nothing seems to happe
>
> from the terminal and see if it works.
>
> On Wed, 10 Mar, 2021, 5:23 pm muiru james, wrote:
>
> > Hi
> >
> > The config file is enabled.
> >
> > Could it be that the installation was not done as root? Because when I
> > tried opening th
heck if a) koha-run-backups is actually generating the backup
> by ruining it manually from the command line, b) check if the cron job is
> running correctly.
>
> Hope this helps
> Indranil Das Gupta
> L2C2 Technologies.
>
> On Wed, 10 Mar, 2021, 1:49 pm muiru james, wrote:
Hello team,
I have a system that has no backups to download at the export data, backups
in the tools module. The config file is well edited to allow for the
backups via tools.
What could be the problem?
Koha version is 19.05
Ubuntu 16.04
Please help
Warm Regards
James
Hello
Thank you for finding time to reply to my question.
I have created a cron that runs at 1800hrs and executes a shell script i
have named badh.sh containg the syntax for doing a manual sql dump
(mysqldump -uroot -p /) which saves in the folder dropbox in the home
directory. This dropbox
Hi
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?
Please assist.
Thanks
Warm Regards
James
___
Koha mailing list
>
> On 27.11.20 08:07, muiru james wrote:
> > Hi,
> >
> > I marked some items as withdrawn and need to bulk edit to change the date
> > of withdrawal to an earlier date so that my report can give me accurate
> > data.
> >
> > How can I change/modi
use the datepicker to enter the dates!
>
> AND DATE(items.itemlost_on) BETWEEN <> AND
> <
> Hope this helps,
>
> Katrin
>
>
> On 27.11.20 10:25, muiru james wrote:
> > I have the below query which runs well without the date filter. On
> > including the
I have the below query which runs well without the date filter. On
including the date placeholder, it gives me zero results. What am I
missing? I need to be able to select a date range. Please help
SELECT biblio.author AS Author, biblio.title AS Title,
biblioitems.publishercode AS
Hi,
I marked some items as withdrawn and need to bulk edit to change the date
of withdrawal to an earlier date so that my report can give me accurate
data.
How can I change/modify the items.withdrawn_on date with a calendar pop
up/date picker?
Kindly help
Warm Regards
James
tegorycode, sex
>
>
> Marti Fuerst
> Systems Librarian
> Huntsville-Madison County Public Library
> 915 Monroe St, Huntsville, AL 35801
> http://hmcpl.org/ — mfue...@hmcpl.org
>
> On Nov 21, 2020, at 2:54 AM, muiru james wrote:
>
> Hello team,
>
> I need a report
Hello team,
I need a report that counts and sums new patrons registered within a
certain date range by gender for each category.
How can I enhance this report? I dont mind a different on delivering
results.
SELECT categorycode, COUNT(borrowernumber) AS 'new patrons'
FROM (SELECT borrowernumber,
--|
> 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 /
> Imprime
ours
> P Print only if absolutely necessary / Imprime solo si es necesario /
> Imprimez seulement si nécessaire
>
>
> Le mar. 17 nov. 2020 à 12:07, muiru james a écrit :
>
>> Hi Alvaro,
>>
>> It is not a new install. The server has been running for over an y
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 mar. 17 nov. 2020 à 07:58, muiru james a écrit :
>
>> Hello team,
>&g
Hello team,
I cannot connect to my instance even when I try logging in from the
production server itself.
The browsers response "Unable to connect: Firefox can’t establish a
connection to the server at 127.0.0.1:8080"
All the processes seem to be running
Im running koha 19.11 on ubuntu 16.04
Hospital Center
> fred.k...@medstar.net
> 202-877-6670
> ORCID -0001-5266-0279
> MedStar Authors Catalog: http://medstarauthors.org
>
> Suddenly virologists are cool. This is a bad sign.
> --Paul Offit
>
> -Original Message-
> From: Koha On Behalf Of muiru
Hello team,
My koha instance and opac are not loading. The page tries loading for
awhile then shows unable to connect message.
What could be wrong?
The server has been on but we have been closed since March so nothing has
been tampered with. We intend to resume operations come monday so this is
Hi Team,
I need to edit barcodes to replace a double hyphen (--) with a single
hyphen (-). The barcodes are many and will take long using the item editor
which allows me to edit one after the other.
Is there a SQL command I could use to edit from the terminal? I tried
running the query below. It
Hi Alvaro and hello team,
Thank you for your response on the above email subject.
I have tried to look at the eror section but have so far not been able to
resolve the issue.
If you or anybody else can point me closer, I'd greatly appreciate it.
The error in the about page is as under: -
rcode,biblio.author,biblio.title,items.price
>
> ...
>
>
> Hope this helps,
>
>
> Katrin
>
> On 29.05.20 14:20, muiru james wrote:
> > Hello Mark,
> >
> > Following up on this query, this is the whole SQL query
> >
> > SELECT CONCAT(' > additem.pl
Hello Mark,
Following up on this query, this is the whole SQL query
SELECT CONCAT('', itemnumber, '' ) AS
itemnumber,items.itemcallnumber,items.barcode,biblio.author,biblio.title,items.price
FROM items
LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber)
LEFT JOIN
N ALL SELECT * FROM old_issues) i
> JOIN items it ON it.itemnumber = i.itemnumber
> WHERE DATE(i.timestamp) BETWEEN '2020-02-01' AND '2020-02-29'
> GROUP BY 2 ORDER BY 2;
>
>
>
> On Thu, Mar 5, 2020 at 11:06 AM muiru james wrote:
>
>> Dear All,
>>
>> My li
Dear All,
My library uses DDC scheme of classification and we are looking for a
report that will count items checked out allowing us to select day(s) of
issue, select itemtype and group the statistics by DDC 10 broad classes.
*EXAMPLE*
IN a date range say 1st-31st March 2020.
*DDC Class | NO.
Hello,
I cannot access my system login page.
Reports the error below
mkdir ARRAY(0x3c90520): Permission denied at
/usr/lib/x86_64-linux-gnu/perl5/5.22/Template/Provider.pm line 388.
My Koha Version - 19.05 upgraded from 17.11 usiing debian packages
Kindly help me someone
Thanks
James
Hi team,
We have been editing our items and replacing the barcode field with a new
one. Over the last few days, the new barcode is not saving i.e. after
saving the old number is still showing instead of the new one.
This is really stressing us up.
Please help me resolve this.
Thanks in
Anyone please
On Wed, 21 Aug 2019 10:59 muirunyeri Hi,
>
> While Koha is now calculating fines, its only possible to see the fine
> after item checkin. Its only showing a user as having overdue items but no
> amount of fine accrued before checkin. What can be done to show on the
> screen the
Hi,
My system is now calculating overdue fines after setting the homelibrary
field but its only after checking in the overdue item that you can see the
amount of fine. On the patrons account, its only showing the user as having
overdue items but not showing what amount of fine has accrued. What
Hi,
I am using Koha Version 17.11.05.000 and Zebra Zebra 2.0.59.
I edited the Koha backend Maria DB table items and updated the Barcodes
field for about 3000 barcodes. The update was successful and searching the
barcodes using the browser the books are updated. Reports are also running
well nad
55 matches
Mail list logo