date:20210215

Re: [Koha] Run batch_delete_records.pl on server?

2021-02-15 Thread Jonathan Druart

I should have added that the following bug report will put the
deletion in a background task and will allow large deletion:
Bug 26080 - Use the task queue for the batch delete records tool
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26080

Le lun. 15 févr. 2021 à 16:32, Jonathan Druart
 a écrit :
>
> Hello Tasha,
>
> The entire request will be processed on the server anyway, but you
> won't get summary screen.
>
> I would recommend you to raise the timeout value of the webserver.
>
> If you don't want to, or cannot, you can still write a script that
> does what the tools script does, but that's not trivial.
>
> Regards,
> Jonathan
>
>
> Le ven. 12 févr. 2021 à 16:34, Bales (US), Tasha R
>  a écrit :
> >
> > I'm new to Koha and am having issues with web timeouts when using "Batch 
> > record deletion", either when uploading a list, or when carrying out the 
> > actual deletion of records in a loaded list.  When I realized 10K records 
> > might be too many, I decreased to less than 5K.  In one test, about 1/3 of 
> > my records were deleted by the time the timeout occurred.  I'm not positive 
> > if the delete job is still running in the background, despite the web 
> > timeout.
> >
> > I'd like to ask, couldn't the batch deletion be performed by FTP'ing my 
> > list to the server, and then running batch_delete_records.pl with 
> > parameters in order to circumvent the web interface entirely?  Maybe at 
> > some point, I'll have time to figure this out on my own.  Until then, if 
> > anyone has figured this out, please let me know.
> >
> > Certainly, I could perform this operation with SQL, but I'm not yet fluent 
> > or familiar enough with Koha to know how to make sure I do this correctly 
> > for items, bibs, holds.
> >
> > Thanks for your time,
> >
> >
> > Tasha R. Bales
> >
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Koha API

2021-02-15 Thread Tomas Cohen Arazi

Hi, you can point you browser to your Koha instance appending /api/v1/.html

You will see the available API routes on your instance.

El lun., 15 feb. 2021 6:38, Mr. Sitali C. S.  escribió:

> Greetings,
>
> I would like to know if there exists a Koha API with a parameter
> that returns all parameters for the student like when a book was borrowed.
> This API is for integrating with  student information system
> Any pointers folks will be appreciated.
>
> Kind regards
>
> Sitali CS
>
>
> --
> Charles Lwanga College of Education,
> P. O. Box 660193,
> Monze,
> ZAMBIA.
>
> Mobile: +26 0979 869471
> +26 0966 869471
> SKYPE: Libsitali
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Koha API

2021-02-15 Thread Katrin Fischer


Hi,

you can find a list of protocols and APIs Koha supports in the wiki:

https://wiki.koha-community.org/wiki/APIs_and_protocols_supported_by_Koha

Besides the JSON reports API Alvaro mentioned the REST API might also be
something to look at.

Hope this helps,

Katrin


On 15.02.21 18:16, Alvaro Cornejo wrote:

Hi

Indeed Koha has an API but don't know about its details. Maybe someone else
can clarify that. Have you checked koha wiki & documentation?

However, depending on what info you need, you might use reports module. You
can create a report, make it "public" and run it from your external
system.  Koha will return the info in JSON format that you can process as
needed.

Hope this helps.

Regards,

Alvaro


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


Le lun. 15 févr. 2021 à 04:38, Mr. Sitali C. S.  a
écrit :


Greetings,

I would like to know if there exists a Koha API with a parameter
that returns all parameters for the student like when a book was borrowed.
This API is for integrating with  student information system
Any pointers folks will be appreciated.

Kind regards

Sitali CS


--
Charles Lwanga College of Education,
P. O. Box 660193,
Monze,
ZAMBIA.

Mobile: +26 0979 869471
 +26 0966 869471
SKYPE: Libsitali
___

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


___

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

___

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

Re: [Koha] Koha API

2021-02-15 Thread Alvaro Cornejo

Hi

Indeed Koha has an API but don't know about its details. Maybe someone else
can clarify that. Have you checked koha wiki & documentation?

However, depending on what info you need, you might use reports module. You
can create a report, make it "public" and run it from your external
system.  Koha will return the info in JSON format that you can process as
needed.

Hope this helps.

Regards,

Alvaro


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


Le lun. 15 févr. 2021 à 04:38, Mr. Sitali C. S.  a
écrit :

> Greetings,
>
> I would like to know if there exists a Koha API with a parameter
> that returns all parameters for the student like when a book was borrowed.
> This API is for integrating with  student information system
> Any pointers folks will be appreciated.
>
> Kind regards
>
> Sitali CS
>
>
> --
> Charles Lwanga College of Education,
> P. O. Box 660193,
> Monze,
> ZAMBIA.
>
> Mobile: +26 0979 869471
> +26 0966 869471
> SKYPE: Libsitali
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

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

Re: [Koha] Run batch_delete_records.pl on server?

2021-02-15 Thread Jonathan Druart

Hello Tasha,

The entire request will be processed on the server anyway, but you
won't get summary screen.

I would recommend you to raise the timeout value of the webserver.

If you don't want to, or cannot, you can still write a script that
does what the tools script does, but that's not trivial.

Regards,
Jonathan


Le ven. 12 févr. 2021 à 16:34, Bales (US), Tasha R
 a écrit :
>
> I'm new to Koha and am having issues with web timeouts when using "Batch 
> record deletion", either when uploading a list, or when carrying out the 
> actual deletion of records in a loaded list.  When I realized 10K records 
> might be too many, I decreased to less than 5K.  In one test, about 1/3 of my 
> records were deleted by the time the timeout occurred.  I'm not positive if 
> the delete job is still running in the background, despite the web timeout.
>
> I'd like to ask, couldn't the batch deletion be performed by FTP'ing my list 
> to the server, and then running batch_delete_records.pl with parameters in 
> order to circumvent the web interface entirely?  Maybe at some point, I'll 
> have time to figure this out on my own.  Until then, if anyone has figured 
> this out, please let me know.
>
> Certainly, I could perform this operation with SQL, but I'm not yet fluent or 
> familiar enough with Koha to know how to make sure I do this correctly for 
> items, bibs, holds.
>
> Thanks for your time,
>
>
> Tasha R. Bales
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Br Raphael

2021-02-15 Thread Jonathan Druart

Hello,
Are you familiar with perl?
You can create a simple script to generate 1 item per biblio:

"""
use Modern::Perl;
use Koha::Biblios;
use Koha::Items;

my $biblios = Koha::Biblios->search;
my $branchcode = 'CPL';
while ( my $biblio = $biblios->next ) {
Koha::Item->new(
{
biblionumber  => $biblio->biblionumber,
homebranch=> $branchcode,
holdingbranch => $branchcode,
barcode   => "barcode_" . $biblio->biblionumber,
itype=> $biblio->biblioitem->itemtype,
}
)->store;
}
"""

Replace your branchcode in the script and run it.
It will create 1 item per bibliographic record with a barcode
"barcode_" suffixed by the biblionumber.
Please run it in a test environment and confirm it works as you expect
before running it on your production server :)

Regards,
Jonathan

Le lun. 15 févr. 2021 à 14:46,  a écrit :
>
> Ian,
>
> The answer to you questions is true. I just need to have the right
> syntax for mysql to add books to the items. I have the means of making
> the whole collection get barcodes within a few minutes. The only
> problem is that the barcode thing only does those items that are
> connected to a record.
>
> I just need to make all the items connect to a record.
>
> Br Raphael
>
>
> Quoting Ian Bays :
>
> > Hello
> >
> > Am I right in guessing that the majority of the books (titles) only
> > have a single copy?  Also am I right in thinking most of the actual
> > books (items) have no computer-readable numbers such as barcodes?
> >
> > If both the above are true and if you have access to the
> > command-line to run some SQL, then we could come up with a simple
> > SQL command to add a single item for each title.  These items would
> > have no barcodes to identify them.  They would have to have a branch
> > and an item type (and usually a location but that is optional).
> >
> > If many titles have multiple items or the items do have identifying
> > numbers then is this information held in a spreadsheet somewhere?
> > If so there may be better ways to get the items created.
> >
> > Can I ask why you want to add the items?  Is it so that the books
> > can be issued to borrowers?  If so I think they may need an
> > identifying number.
> >
> > Can you say what version of Koha you have as that might determine
> > what tools are available for some of the other options.
> >
> > One is never too old to learn!  I'm sure you will get help from the
> > community.
> >
> > Best regards.
> > Ian
> >
> > On 14/02/2021 14:07, libr...@princeofpeaceabbey.org wrote:
> >>
> >> I am Br Raphael of Prince of Peace Abbey. I have been learning Koha
> >> for the past year. I have become the librarian of the Abbey along
> >> with a few other jobs. The library has about 40K volumes. I also
> >> have four other libraries to merge into the main.
> >>
> >> I have to thank all who have helped in the past. Now my biggest
> >> problem is that the librarian before me, God rest his soul, did not
> >> attach Items to those 40K books. Beside doing it the hard way. That
> >> is one by one. I hope there is a faster way to do that. I am not a
> >> programmer so I need step by step instructions. I think I am doing
> >> good with me being 74 years of age. I might be the oldest librarian
> >> using Koha.
> >>
> >>
> >>
> >> ___
> >>
> >> Koha mailing list  http://koha-community.org
> >> Koha@lists.katipo.co.nz
> >> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> >>
> >>
> >
> > --
> > Ian Bays
> > Director, PTFS Europe Limited
> > Content Management and Library Solutions
> >
> > ___
> >
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Br Raphael

2021-02-15 Thread library


Ian,

The answer to you questions is true. I just need to have the right  
syntax for mysql to add books to the items. I have the means of making  
the whole collection get barcodes within a few minutes. The only  
problem is that the barcode thing only does those items that are  
connected to a record.


I just need to make all the items connect to a record.

Br Raphael


Quoting Ian Bays :


Hello

Am I right in guessing that the majority of the books (titles) only  
have a single copy?  Also am I right in thinking most of the actual  
books (items) have no computer-readable numbers such as barcodes?


If both the above are true and if you have access to the  
command-line to run some SQL, then we could come up with a simple  
SQL command to add a single item for each title.  These items would  
have no barcodes to identify them.  They would have to have a branch  
and an item type (and usually a location but that is optional).


If many titles have multiple items or the items do have identifying  
numbers then is this information held in a spreadsheet somewhere?   
If so there may be better ways to get the items created.


Can I ask why you want to add the items?  Is it so that the books  
can be issued to borrowers?  If so I think they may need an  
identifying number.


Can you say what version of Koha you have as that might determine  
what tools are available for some of the other options.


One is never too old to learn!  I'm sure you will get help from the  
community.


Best regards.
Ian

On 14/02/2021 14:07, libr...@princeofpeaceabbey.org wrote:


I am Br Raphael of Prince of Peace Abbey. I have been learning Koha  
for the past year. I have become the librarian of the Abbey along  
with a few other jobs. The library has about 40K volumes. I also  
have four other libraries to merge into the main.


I have to thank all who have helped in the past. Now my biggest  
problem is that the librarian before me, God rest his soul, did not  
attach Items to those 40K books. Beside doing it the hard way. That  
is one by one. I hope there is a faster way to do that. I am not a  
programmer so I need step by step instructions. I think I am doing  
good with me being 74 years of age. I might be the oldest librarian  
using Koha.




___

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




--
Ian Bays
Director, PTFS Europe Limited
Content Management and Library Solutions

___

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




___

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

[Koha] Koha API

2021-02-15 Thread Mr. Sitali C. S.

Greetings,

I would like to know if there exists a Koha API with a parameter
that returns all parameters for the student like when a book was borrowed.
This API is for integrating with  student information system
Any pointers folks will be appreciated.

Kind regards

Sitali CS


-- 
Charles Lwanga College of Education,
P. O. Box 660193,
Monze,
ZAMBIA.

Mobile: +26 0979 869471
+26 0966 869471
SKYPE: Libsitali
___

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

Re: [Koha] Koha installation puzzles

2021-02-15 Thread Jonathan Druart

Hello Fred,

I have no idea what means the "is transient or generated." error. But
you should make sure koha-common is started.

The wiki is wrong (I will edit it). There is no more --use-memcached
option (to koha-create), it's mandatory now.

Do you manage to access the interface? If so, go to the about page and
confirm there that memcached is configured correctly.

Regards,
Jonathan

Le dim. 14 févr. 2021 à 23:26, King, Fred  a écrit :
>
> Esteemed colleagues,
>
> I'm running into some bumps while I'm setting up a Koha installation. I'm 
> using:
>An Ubuntu server from Digital Ocean, 20.04. (In Toronto, if that makes any 
> difference.)
>Koha 20.11x
>Using packages from mirrors.digitalocean.com
>
> While I'm installing koha-common, right before the end, this happens:
>The following plugins have been enabled:
>   rabbitmq_stomp
>started 1 plugins
> [that's normal, but then nothing happens for a couple of minutes, and I get 
> this:]
>Failed to enable unit: Unit 
> /run/systemd/generator.late/koha-common.service is transient or generated.
> [then setup returns to normal]
>
> I've never seen this before, and I've done a LOT of Koha installations. Any 
> ideas of what's happening?
>
>
> I also want to add Memcached. (If it matters, I've also installed plack.) The 
> instructions at 
> https://wiki.koha-community.org/wiki/Koha_on_ubuntu_-_packages say:
>If you want to use memcached:
>This may need to be installed first with: sudo apt-get install 
> memcached
>Include --use-memcached
> [then the next line is:]
>sudo koha-create --create-db library
>
> Problem is, I can't figure where to include -use-memcached. All right, I have 
> a bad case of Basement Brain. Could someone un-confuse me?
>
>
> And finally, when I try to install a language with
>Sudo koha-translate -install fr-FR
> for example, I get the warning
>connection to '__MEMCACHED_SERVERS___' failed
> and warnings that performance will suffer greatly.
> Then when I try to install another language such as es_ES, de_DE, or am_ETHI, 
> I get a message that the language is not available. Later in the installation 
> I get the option to use FR, so it seems to have been installed.
> The Memcached settings in /etc/koha/sites/library/koha-conf.xml appear to be 
> correct.
>
> It's dinnertime here in North American Eastern Time, but I'll be back on 
> Monday. Thanks to anyone who can point me in the right direction.
>
> Fred King, MSLS, AHIP
> Medical Librarian, MedStar Washington Hospital Center
> fred.k...@medstar.net
> 202-877-6670
> ORCID -0001-5266-0279
> MedStar Authors Catalog: http://medstarauthors.org
>
> The hardest job I ever had was that of door-to-door front door salesman. I'd 
> knock on someone's front door and when they answered I'd say "Could I 
> interest you in a-wait a minute, you already have one."
> --Bill Bailey
>
> --
> MedStar Health is a not-for-profit, integrated healthcare delivery system, 
> the largest in Maryland and the Washington, D.C., region. Nationally 
> recognized for clinical quality in heart, orthopedics, cancer and GI.
>
> IMPORTANT: This e-mail (including any attachments) may contain information 
> that is private, confidential, or protected by attorney-client or other 
> privilege. If you received this e-mail in error, please delete it from your 
> system without copying it and notify sender by reply e-mail, so that our 
> records can be corrected... Thank you.
>
> Help conserve valuable resources - only print this email if necessary.
>
>
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

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

Re: [Koha] Run batch_delete_records.pl on server?

Re: [Koha] Koha API

Re: [Koha] Koha API

Re: [Koha] Koha API

Re: [Koha] Run batch_delete_records.pl on server?

Re: [Koha] Br Raphael

Re: [Koha] Br Raphael

[Koha] Koha API

Re: [Koha] Koha installation puzzles

9 matches

Site Navigation

Mail list logo

Footer information