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

[Koha] INVENTORY SQL

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

[Koha] Koha inventory and bibliotheca Mobile DLA

Our library is just starting out with our first inventory using Koha with bibliotheca's Mobile DLA wand. Are there any other Koha users out there using this device and willing to share your local processes? Thanks so much for any advice you can share! -- Joelle Hannert Library Technical Services

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

[Koha] Inventory Help

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'Malley ___ Koha mailing list http://koha-community.org Koha

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

[Koha] Inventory changed?

Hi all Has the inventory changed radically? It works very differently as it used to. I have my call numbers in the form of: "1/ 1, 1" (the first digit beeing the group, the second the shelf, the third a serial number). When I used "4/43, 1" and "4/43,99" as limits of the search I got a list like

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

[Koha] Inventory lists incorrectly sorted

Hi all, Has anyone had a problem where the lists generated by the inventory tool don't seem to be sorted correctly? I received reports of this and during my investigation I found https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19021 but that didn't seem to solve the root problem,

Re: [Koha] Koha Inventory

nz Subject: Re: Koha Inventory On 30/07/18 16:55, [ hira.ak...@almusnet.com ]( mailto:hira.ak...@almusnet.com ) wrote: Hi, I am trying to use koha inventory feature but when I upload a text file with barcodes and click on submit, it shows me the message " no valid barcodes! " Can

Re: [Koha] Koha Inventory

On 30/07/18 16:55, hira.ak...@almusnet.com wrote: Hi, I am trying to use koha inventory feature but when I upload a text file with barcodes and click on submit, it shows me the message " no valid barcodes! " Can anyone please urgently tell me what I am doing wrong or need

[Koha] Koha Inventory

Hi, I am trying to use koha inventory feature but when I upload a text file with barcodes and click on submit, it shows me the message " no valid barcodes! " Can anyone please urgently tell me what I am doing wrong or need to do to correctly perform this

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 __

[Koha] inventory interface

Good afternoon! I have very few options in the Web interface for Inventory the library catalog. I'm sending a photo to compare with the demo version. What is the problem and how can it be solved? -- Sent from: http://koha.1045719.

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

[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] 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

[Koha] Inventory: Compare barcodes option

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 understand this is the feature that tells you what books are misshelved. I have everything else working, and as long as

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

[Koha] Inventory/ shelf-reading

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 & some rather tedious data clean-up to get

Re: [Koha] Koha Inventory tool 3.14.4

Thank you for your reply. In the end I was being optimistic as there is no 'date last seen' field to change. However our tech support came through and upgraded us to 3.16. Regards Ann Murphy On Tue, Nov 25, 2014 at 6:49 PM, Karam Qubsi wrote: > Hi , > If you can change them in a batch 'the date

Re: [Koha] Koha Inventory tool 3.14.4

Hi , If you can change them in a batch 'the date last seen', then I think there will not be any problems . Regards . On Mon, Nov 24, 2014 at 8:35 AM, library wrote: > Hi > > I have come against the Inventory tool bug 7684 (I think) and it will take > me a while to get our technical support to

[Koha] Koha Inventory tool 3.14.4

Hi I have come against the Inventory tool bug 7684 (I think) and it will take me a while to get our technical support to apply the patch. Can anyone tell me of any pitfalls if I just use the Batch Item Modification tool and mark the 'Date Last seen ' field as the inventory date. Regards Ann Mur

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

[Koha] Inventory Workaround

Hi everyone, I see that a bug has already been filed for the weirdness going on with the inventory tool and datelastseen: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12329 We need to get inventory done now, though, since it's the end of the school year. I don't see an option to set

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

[Koha] Inventory Problems Column

Hi all, I'm wondering what kinds of things might show in the 'Problems' column on the inventory report? I've only ever seen it say 'None'. This comes from a comment on one of my tutorial videos: http://bywatersolutions.com/2012/05/30/inventory-in-koha-3-8/#comment-10075so feel free to reply there

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

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

Dear Friends, We have 5 records in Koha 3.8.6. For trying stock taking , we input accession numbers in a csv file (45000 records) and uploaded in stock taking module. We got the following error. Gateway Time-out The gateway did not receive a timely response from the upstream server or applic

[Koha] Inventory : barcode limit ?

Hello, For those of you already using the inventory module in Koha 3.2 : how are you dealing huge files of barcodes ? Have you experienced problems ? I plan to upload batches of 5000 barcodes each, does it sound acceptable for you ? Or have you performed with bigger batches ? Many thanks in advan

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

[Koha] Inventory/Stocktaking Functions in Koha 3.02.06

Good afternoon, If anyone has used the Inventory/Stocktaking feature in Koha 3.02.06, I have a few questions: - First of all, I loaded a same sample of 52 item barcodes using MS Notepad. The load went fine, and the “Date Last Seen” updated to the current date. - However, all that happens is