[Koha] Generating a barcode list of records created by a particular user in a given time frame

Hi I am interested in generating a barcode list of records created by a given user ( as a function of borrower number) in a given time frame. I will appreciate an SQL statement that will enable me to achieve this. Kind Regards, Admire Mutsikiwa (Mr) ICT Manager Libraries University o

Re: [Koha] [ByWater Partners] ISBN search results

Joy, Thank you for your help...you offered a great explanation. -- Christopher Davis, MLS Systems & E-Services Librarian Uintah County Library cgda...@uintah.utah.gov (435) 789-0091 ext.261 uintahlibrary.org basinlibraries.org facebook.com/uintahcountylibrary instagram.com/uintahcountylibrary

Re: [Koha] [ByWater Partners] OT: Makerspaces and soldering

Hi, On Mon, Jun 6, 2016 at 9:20 AM, Christopher Davis wrote: > You might want to float your query at > , > , or > . And for a forum focused

Re: [Koha] Removing Boolean searching from OPAC.

Hi to all, Il 07/06/2016 11:12, Raymund Delahunty ha scritto: Thanks for this. I added the JQuery to the Bywater Solutions database but I still don't see this search acting as an old fashioned "left anchored" title search. If search on ART on a title search I expect the items returned will ALL

Re: [Koha] Generating a barcode list of records created by a particular user in a given time frame

I think that the simplest query for this would be a modification of https://wiki.koha-community.org/wiki/SQL_Reports_Library#Track_In_House_Use Replace count(*) with barcode, and modify the WHERE clause to search for 'isssue' instead of 'localuse'. SELECT count(*) FROM statistics WHERE type='loca

[Koha] SQL reports - Fine generating with itemtype filter

Dear all, I need help in generating a report related to fines. Using the below report iam able to generate the fines. I would like to add a filter to this report "itemtype" for fine report as our circulation rules are slightly different for books and journals and the complete fine reports sometim

Re: [Koha] LOC Z39.50 Connection configuration setup

Hi, On Mon, Jun 6, 2016 at 10:42 PM, Decka David wrote: > I tried yaz-client lx2.loc.gov/LCDB and the result was > > Connecting..error = System (lower-layer) error: connection time out > > What could have been the problem? > I also tried Z> f @attr 1=4 "special relativity" and shows Not conne

[Koha] Inventory

We recently acquired a new portable barcode scanner, and want to start using the file matching feature in koha for inventory. In looking at this, I have two questions. First, we are able to create the barcode files. However, when doing the compare, the results we're seeing are not helpful. With a

Re: [Koha] LOC Z39.50 Connection configuration setup

At 09:42 AM 6/7/2016 -0400, G.C. wrote: [snip] So, one possibility is that there is a firewall blocking the LC Z39.50 server outright, or just your ability to access port 210. To distinguish, you could try the following command: curl http://lx2.loc.gov That will always give 2.0//EN">403 Forbi

Re: [Koha] Inventory

Joel, My institution is currently running an inventory on our collections. The way we do our inventory is to collect item barcodes, submit them using the inventory tool found at Koha>Tools>Inventory>Use a barcode file (the *first* time that you run this tool, you will need to record the date found

Re: [Koha] Generating a barcode list of records created by a particular user in a given time frame

Admire, Is your interest in knowing who has cataloged a particular item? Barton's SQL would appear to show who has checked out a particular item, not who created it. If you want to know who added an item you would need to have the Cataloguing Log turned on and query that table (action_logs). Thi

Re: [Koha] Generating a barcode list of records created by a particular user in a given time frame

Hi I have written two scripts to print spine labels and due date slips based on the batchMod.pl which takes a list of barcodes to print the spine labels and the date slips. What I want is for each cataloguer to be able to print the spine labels and date slips of books that they would have cat

Re: [Koha] LOC Z39.50 Connection configuration setup

Hi, On Tue, Jun 7, 2016 at 12:44 PM, Paul A wrote: > At 09:42 AM 6/7/2016 -0400, G.C. wrote: >> curl http://lx2.loc.gov > > That will always give 2.0//EN">403 Forbidden etc, etc Well no, it will not give that response if it turns out that the entire host is blocked, not just port 80. > Try usi

Re: [Koha] Kohacon 2017

The wiki page can be found here: https://wiki.koha-community.org/wiki/KohaCon17_Proposals Please add your proposals to host Kohacon 2017. -- Mirko -- Mirko Tietgen mi...@abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de signature.asc Description: OpenPGP digital signatur

Re: [Koha] Generating a barcode list of records created by a particular user in a given time frame

Hi I have written two scripts to print spine labels and due date slips based on the batchMod.pl which takes a list of barcodes to print the spine labels and the date slips. What I want is for each cataloguer to be able to print the spine labels and date slips of books that they would have cat