Re: [Koha] INVENTORY SQL

1, 0 AS count2, items.datelastborrowed AS datelastborrowed , items.dateaccessioned AS dateaccessioned, items.location AS Location, CASE WHEN items.itemlost=2 THEN 'Long overdue (lost)' WHEN items.itemlost=3 THEN 'Lost & paid for' WHEN items.ite

Re: [Koha] INVENTORY SQL

Hello Joel Thank you for your email. I need books that have been since that date and after (>=) but the date should be picked from a date picker. Then add all books on loan for that particular item type. So that the total at a particular date shall be all books after that datelastseen plus all bo

Re: [Koha] INVENTORY SQL

Do you need to match the exact date last seen, books that have been seen since that date, or books that haven't been seen since before that date? Also, the part about combining books on loan is not clear. Can you explain that in more detail? *Joel Coehoorn* Director of Information Technology *Yor

Re: [Koha] Inventory Help

Hi, What all details do you need? On Thu, 18 Jun, 2020, 8:37 PM Doug O'Malley, wrote: > Hi Guys, > > I can't get my KOHA to generate an inventory report that's accurate. It > keeps generating either a blank report, or a list of every book in our > collection. > > Any advice? > > Thanks, > Doug O

Re: [Koha] Inventory changed?

Hi Beda, if you are using 18.11, this might have caused the change: *Bug 19915* - Inventory tool doesn't use cn_sort for callnumber ranges First thing I would check is if it works better with another 'callnumber classificaton sch

Re: [Koha] Inventory lists incorrectly sorted

Librarian Prosentient Systems 72/330 Wattle St Ultimo, NSW 2007 Australia Office: 02 9212 0899 Direct: 02 8005 0595 From: Sebastian Hierl [mailto:s.hi...@aarome.org] Sent: Friday, 28 September 2018 7:11 PM To: dc...@prosentient.com.au Cc: Koha Devel ; koha Subject: Re: [Koha

Re: [Koha] Inventory lists incorrectly sorted

Hi, Katrin: Thank you! Yes, this helps a lot and we have been using the items.cn_sort column in some of our reports and should include them in all or where we can, as for some reports we are running into problems and the ' items.cn_sort' is not recognized. I will have to review the select report

Re: [Koha] Inventory lists incorrectly sorted

Hi Sebastian, if you are using LOC callnumbers you could try to include the items.cn_sort column in your reports and try sorting on that. Koha generates cn_sort as a sortable form of the callnumber for LOC and DDC if the $2 in the item is set to the correct classification. Hope this helps,

Re: [Koha] Inventory lists incorrectly sorted

Thank you for raising this issue, David. We sort the reports we generate from Koha in Excel with the following formula by Lee Ann Nolan and Jameson Conley: https://scholarsphere.psu.edu/concern/generic_works/qv33rw719 The formula is a big help, but it doesn't work for call numbers starting three l

Re: [Koha] inventory interface

Hi, the options in those filters should be drawn from lists of authorised values (administration > authorised values > LOST, WITHDRAWN, DAMAGED,...) . Is only inventory affected or are the add/edit item forms as well? Hope this helps, Katrin On 21.09.2017 13:33, dobriivoin wrote:

Re: [Koha] inventory interface

> I'm sending a photo to compare with the demo This mailing list does now allow attachments, so you'll have to post the images to a web site somewhere and share a link to that. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org __

Re: [Koha] Inventory

We have been using a laptop and simply checking in on Koha, rather than using the barcode file method. That way, staff see any issues with lost status or items that seem to be checked out. After all items in the section are checked in, we run a report that shows only the items that have not be

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] Inventory: Compare barcodes option

On 13 August 2015 at 01:59, Caitlin Kleinpaste wrote: > Additional info: I'm using version 3.20.02.000. > > On Wed, Aug 12, 2015 at 9:27 AM, Caitlin Kleinpaste > wrote: > >> I'm trying to use the "Compare barcodes list to results" feature of >> inventory/stocktaking? We are preparing for our fir

Re: [Koha] Inventory: Compare barcodes option

Additional info: I'm using version 3.20.02.000. On Wed, Aug 12, 2015 at 9:27 AM, Caitlin Kleinpaste wrote: > I'm trying to use the "Compare barcodes list to results" feature of > inventory/stocktaking? We are preparing for our first inventory since > switching to Koha, and from what I can under

Re: [Koha] Inventory/ shelf-reading

> It's not clear to me what you are finding that's out of order. Is it the > books on the shelf or the listing in the catalog? The books on the shelf are out of order. > If the books, why is there a challenge to relocating them? No challenge, but this slows down the barcode scanning process rema

Re: [Koha] Inventory/ shelf-reading

On 12/16/2014 01:35 PM, Cab Vinton wrote: Koha's inventory utility is handy but seems to be missing one critical element, namely the ability to flag items out of call number order. The utility also does not generate a downloadable file. This means copying & pasting the results into a spreadsheet

Re: [Koha] Inventory Workaround

We are in the middle of an inventory right now. Our student workers are going through the shelves with a laptop and a barcode scanner and just scanning the barcodes as they go. If you pretend you're checking in the book, you'll get a message saying it was not checked out, but the date last seen wi

Re: [Koha] Inventory Workaround

Thanks, Karen! That's what I was afraid we'd have to do (so I'll keep an ear out for any additional suggestions). We have a definite lag time with check-in, so it's much easier to use batch files. Is there any way to set a future date for check-in? I like to use one consistent weekend date for inv

Re: [Koha] Inventory Problems Column

Hi Nicole, What I have seen, that the Inventory tools seems to ignore items selection, when generating the list. Even items which I set as withdrawn comes up on the inventory, and the problem field never changes from None. This is annoying as, you have to check each item to see if it is lost

Re: [Koha] Inventory / Stock taking: Gateway Time-out

"Vimal Kumar V." > The gateway did not receive a timely response from the upstream server or > application. > > Whats the meaning of this error? > Anybody tried stock taking of huge number of records? That error means that it took too long to process the upload and the gateway server (not a requ

Re: [Koha] Inventory / Stock taking: Gateway Time-out

Greetings, We got the following error. Gateway Time-out The gateway did not receive a timely response from the upstream server or application. Whats the meaning of this error? The problem is that sometimes a process takes a particularly long time. It isn't that it isn't working, but rather

Re: [Koha] Inventory/Stocktaking Functions in Koha 3.02.06

Hi Darcy We scan the barcodes into a notepad, saving every 1/2 hour to an hour (so the file isn't too big). Then put the file name into the barcode file (set inventory date if you want too, I just use the current date), scroll down to the bottom of the screen and click submit and it gives th

Re: [Koha] Inventory/Stocktaking Functions in Koha 3.02.06

Hi there, we are ploughing through a stocktake now using 3.2. I'll flicjk this to Larissa who is leading the process to explain what we are doing. Cheers Jo. On 3 May 2011 09:15, Chris Cormack wrote: > 2011/5/3 Darcy Gullacher : > > Good afternoon, > > > > If anyone has used the Inventory/Stoc

Re: [Koha] Inventory/Stocktaking Functions in Koha 3.02.06

2011/5/3 Darcy Gullacher : > Good afternoon, > > If anyone has used the Inventory/Stocktaking feature in Koha 3.02.06, I have > a few questions: > Hi Darcy Is the manual any help? http://koha-community.org/documentation/3-2-manual/?ch=x6513 I havent used the feature, so I cant be much more help t