Time Nick Message 19:01 fridolin not 19:01 fridolin looks like note 19:00 tcohen[m] is it random? 19:00 fridolin i'll try to monitor it 19:00 tcohen[m] and master has its own selenium failure 19:00 fridolin no pb 19:00 tcohen[m] I cannot check right now 19:00 tcohen[m] ok 19:00 fridolin gi tcherry-pick 18:59 fridolin from master 18:51 tcohen[m] do you pick commits from master, or from BZ? 18:51 tcohen[m] so I guess you're missing a follow-up or smth 18:51 tcohen[m] master is not failing for that particular test 18:50 tcohen[m] that runs Selenium tests I think 18:50 tcohen[m] D11 is the only 23.05 task on jenkins that runs jenkins 18:50 tcohen[m] I haven't looked at that specific failure 18:50 tcohen[m] selenium tests are fragile to UI changes 18:49 tcohen[m] oh, right 18:49 fridolin i really dont know how this works ;) 18:49 fridolin tcohen any idea on Jenkins Koha_23.05_D11 ? 18:44 * fridolin waves 18:35 tcohen[m] hi fridolin 17:43 fridolin yellow 16:52 kivilahtio Joubu: thanks! <3 16:22 caroline the last of which never happens of course! lol 16:20 Shane-NP[m] for a do it all admin like me, packages are a life saver, I COULD dive deep...but I never have the time, I am more a get it working, bandage what I can, hope and pray the damn don't break, and then hope I have downtime to circle back and fix the cracks. 16:20 cait but time to leave for now :) bye! 16:19 cait we also looked at both at the beginning, the help I got here also helped a lot :) trying to pay that back since 16:19 cait Shane-NP[m]: packages were quite a great innovation - we had all different versions of installing Koha there is I think, but very happy with thepackages now 16:18 Shane-NP[m] I was trying to get Evergreen and Koha up and Everygreen worked first, but it required a windows client, Koha was all web-based...so I kept at it and this IRC chat helped me the most :) so I have been on Koha since 16:18 cait it was an adventure ;) 16:18 cait the first library we migrated started on a dev version a bit before it was released as 3.2 16:17 Shane-NP[m] well I just know it was before packages, and then you had packages, and then the version changed. 16:17 cait not quite 3.2 for me 16:16 caroline I started just after the switch, with 16.05 16:15 cait there never was a 4 - we switched to the year versions before that 16:14 caroline yes 3.16 I think? 16:14 Shane-NP[m] I have been doing Koha since...well...I think it was version 3 or 4 before you went to the yearly version model 16:13 Shane-NP[m] Nice software our there called Snipe-IT its open source, but its dependencies made it hard for me to install...and then trying to collect 300-400 devices in 2-3 days is not easy. I hear it got easier with a bulk option but at this point Koha works fine for me. 16:11 Shane-NP[m] speaking of...I have to adjust the barcode length.....not sure if it reset with the migration 16:11 Shane-NP[m] Other either have too much information or they can't bulk check in and out with a barcode. They can do a file, but I put a patron barcode on the back along with a serial number as the barcode and it works great 16:11 caroline I have one or two clients who do this also, they don't complain so I assume everything is going well 16:10 Shane-NP[m] Yep, this is best method I have found 16:07 cait not with your numbers at least 16:07 cait hm search should not be slow with more 16:05 caroline So you're the IT dept and loan out computers and other materials is that it? 16:03 Shane-NP[m] Yeah! I have a library with no books! How odd to have that, but hopefully the searching will now be bit faster with only 1500 items. 15:59 cait caroline++ Shane-NP++ 15:50 Shane-NP[m] I just manually went to each one, deleted the items and then deleted the record after 15:38 caroline you could maybe feed them into the tool with the itemnumber instead of the barcode 15:38 caroline are there spaces before or after the barcode maybe? 15:37 Shane-NP[m] hmm..2 left but batch deletion says barcode not found 15:35 Shane-NP[m] Ah okay Thank you, just a few lingering items, I down to 50 from 6.6K 15:32 caroline I think it's new from 23.05 15:32 emlam ooh neat! I didn't know about that 15:31 wahanui well, new thing is hte name showing, right? 15:31 cait new thing 15:31 cait oooh right 15:31 cait a way to do returns is setting it to lost in batch edit - but your lost configuration needs to be so that it gets returned when batch edited 15:31 caroline There is a new option in batch modification to return them in batch 15:31 emlam .nope - that's something we've been wanting too. If it's only a few items you can check them in manually 15:31 cait no, you need to return first 15:28 Shane-NP[m] So items batch deletion can I overide if the item is checked out? 15:24 Shane-NP[m] never mind on that question issue was WiFi cut out 15:21 Shane-NP[m] will batch deletion jobs slow the server down a lot? 15:01 Shane-NP[m] new job worked 15:01 Shane-NP[m] Seems to have worked, the few barcodes I put in do not return the book's title, and a search for the title returns similar titles not the exact title 14:56 cait if they are listed as isnished - maybe check if they did work after all? 14:56 Shane-NP[m] let me try a new one 14:56 Shane-NP[m] ty, and they are listed as finished now 14:56 Shane-NP[m] somehow I missed that 14:55 caroline the jobs should be under Administration > Jobs 14:55 caroline I think you'll have to relaunch the tasks after the daemons or workers or whatever are started... afaik they don't go check in the db for incomplete jobs 14:54 Shane-NP[m] how do I get back to jobs...I don't see it under admin or reports 14:51 Shane-NP[m] I just did a full server restart 14:50 cait can you try a koha-common restart? 14:50 cait hm maybe the thing for long background jobs is not running 14:49 Shane-NP[m] would time zone not being set affect it? 14:48 Shane-NP[m] nothing else comes up, and about has no errors, just warning about no Fast Add framework and no encryption key in koha.conf 14:46 emlam and check the About page for system status / errors as a starting point 14:46 emlam I'd uncheck "current jobs only" and "only include jobs..." at the top, to see everything and get a sense of whether nothing's running or if Koha is just backed up 14:45 emlam hmmm...as far as I know the background job workers should be running automatically 14:44 Shane-NP[m] Maybe a setting or service I have a change or enable? New Install of 23 last week, and I migrated the DB from 18 14:42 * Shane-NP[m] uploaded an image: (39KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/pkMfJJKEoeVRcCWHPMtmXxNw/image.png > 14:41 Shane-NP[m] I am trying to get these books deleted, but my jobs just say NULL/999, NULL/348, and NULL/748, the 999 was first one I did 14:41 emlam usually immediately, unless they get backed up 14:39 Shane-NP[m] so when do enqueued job start? 14:37 emlam I think Joubu did the how-to stuff, so I'd ask him when he's around 14:37 emlam yeah, it's definitely a learning curve 14:34 caroline I'm a ktd newbie and don't use it that much in favor of my regular install 14:33 caroline no worries, I was asking in case someone knew 14:33 emlam sorry, I'm not sure :( 14:31 emlam yeah, that's not great 14:31 emlam oh, I see 14:30 caroline I feel like that isn't normal... 14:30 caroline It interferes with the translation script and I have to manually delete it everytime in order to run gulp po:update bla bla 14:29 caroline I mean the koha git, not the ktd git 14:29 emlam oh! I don't think it's supposed to be removed from your repository...in fact I *think* they might have made it a permanent part of KTD recently, though I'm not 100% sure 14:29 caroline it isn't part of the koha git as far as I know and it's added when I do `ktd up`, but hen it's not removed when I do `ktd down` 14:28 caroline from my git 14:28 emlam caroline - what do you mean by removed? like, from where? 14:25 caroline the how-to page isn't removed when I do `ktd down` is that normal or am I doing something wrong? 14:24 afr4z[m] ok cool thanks 14:22 cait you can't do updates from within Koha 14:22 cait ah, you'd need to run that command in the sql client on your server 14:17 afr4z[m] and when i blank search patrons to get all patrons i get a "500 Internal server error : Month out of range" error 14:16 afr4z[m] im on koha 23.05.03 14:15 afr4z[m] do i just run tht command on the mysql? 14:15 * afr4z[m] uploaded an image: (155KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/uZjMzCBkQWjzxQgbigLPVrVy/20230925_194530_4185528289583327337.jpg > 14:15 afr4z[m] uhm 14:15 afr4z[m] no i was referencing a bug 14:15 cait it changes utomatically to today's date when a membership is renewed - it cannot be edited from within Koha 14:14 afr4z[m] magnuse: where do we change the date_renewed of borrowers? 13:58 cait so different I guess thant he other 2 13:58 cait hm this is not API driven... 13:58 cait so maybe we got some examples now 13:58 cait and patron search? 13:58 cait probably because it's server side... but doesn't it work on ILL now? 13:58 caroline not "BLOCKED" status, just blocked :) 13:57 caroline I don't know oleonard says it's more complicated than it seems 13:57 cait oh, not the bug, but the feature? 13:57 cait hm odd 13:55 caroline it seems to be blocked... 13:54 cait 23565 13:54 cait caroline: I bet sec 13:53 caroline is there a bug for that? 13:53 cait so try the item search one, export barcode list - use that with the item batch delete feature 13:52 cait btw we urgently need column configuraiton on the item search table 13:52 Shane-NP[m] I like GUI...I can just do SQL if need be :P 13:52 cait and old_issues for previous checkouts 13:52 cait onloan = currently checked out have a date 13:52 cait but if you want to do SQL... something like select * from items where onloan is NULL and itemnumber not in (select itemnumber from old_issues) 13:51 cait set the checkouts to 0 13:51 cait and then at the bottom of the form 13:51 cait go to Koha > item search (from the start page) 13:51 Shane-NP[m] let me see cause https://wiki.koha-community.org/wiki/SQL_Reports_Library is not listing anything when I searched "no check" 13:50 cait i think that exports a nice barcode list and can also limit on checouts 13:50 cait you could do it from the item search 13:48 caroline hm yeah I don't think there is an export option for that one... :/ 13:47 Shane-NP[m] I did items with no checkouts...that is a long list...but I can't seem to find a export to csv or anything so I can isolate the barcodes 13:44 Shane-NP[m] so I guess I will have to start with items 13:44 Shane-NP[m] my SQL was on biblio 13:43 Shane-NP[m] hmm...Books 6672 via Reports on item types, but my SQL only returned 4591 rows, guessing the items on the records 13:43 cait then you mght want to use the batch item delete first... and it can also delete the record with the item, but I think you can't batch delet the record with the items 13:43 cait do you have items on the records? 13:43 cait all your records will have that 13:43 cait the biblionumber is the internal primary key 13:33 Shane-NP[m] However, no clue what 1 and 9 even are :P 13:33 Shane-NP[m] Okay, let me try that...select biblionumber from biblioitems where itemtype = 'Book' gave me a nice list in Maria 13:31 caroline either. I usually go in reports and do select biblionumber from biblio where ... and download the results (or you can delete right from the reports module) 13:31 Shane-NP[m] I have no idea WHAT numbers there are, just that we have about 5000 books in here I no longer need 13:31 Shane-NP[m] alright, so can I get a list from Koha, or use SQL for that? 13:30 caroline a list of biblionumbers, one per line 13:30 Shane-NP[m] okay so it is asking for a file or list...is the file SQL or just a list a biblio numbers? 13:28 caroline It was very resource intensive because of the multiple selects... probably not the best way to do it, but it worked so... 13:28 caroline Here's one that I used in the past delete from biblio where biblionumber in (select biblionumber from biblioitems where itemtype = 'XYZ') and biblionumber not in (select biblionumber from issues left join items using (itemnumber)); 13:26 cait eah, about 1000 each go and some patience 13:25 caroline ^ that is definitely the safest way to do it, but may require more than one batch 13:25 cait using a report and then batch delete from there. 13:24 cait make a list of biblionumbers 13:24 caroline IIRC, if you delete the biblio, it will cascade down to biblioitems and items 13:24 cait but use the ebatch delete feature 13:24 cait I hink i would not remove with SQL 13:22 Shane-NP[m] Okay....and I am getting pulled away...I will be back to ask how in there ie record or item, or both 13:20 caroline If you remove directly from the database, I think you'd have to reindex too... If you remove from the interface that is done for you 13:19 Shane-NP[m] Remove EVERYTHING except the few items with 942c field with Laptop Computer or Tablet Device as the type 13:19 caroline 942$c is generally mapped to biblioitems.itemtype and it's the code that you have to use 13:19 cait Batch delete? 13:19 cait what doy ou want to do? 13:19 cait sorry Shane-NP[m] you confused me a bit there 13:18 Shane-NP[m] All that I want to keep^ 13:17 Shane-NP[m] ? I know that was kind of bad pseudo code 13:17 Shane-NP[m] Not sure how to do this...and I am fine making an SQL line...just not sure where this would originate...so basically, I want to remove ALL non-computers from the Koha DB. I have about 6000 entries, and about 1500 of those are laptops or tablets. When I check the mark records the laptops all have 942c field "Laptop Computers" or "Tablet Devices". Any starting point on how I can do something like remove * from x,y,z, where 942c!="" or 942c!="" 13:09 aw-bib[m] for the koc: I am not sure if it is only the number of items in the list it starts running but no page ever shows up. it may just be that creating it takes to long and gets killed. (but I admit, I threw some 15k at it. most likely beyond the specs of offline circulation ;) 13:09 aw-bib[m] as of now we just have no limit on renewals. but indeed I'll have to check into this. maybe there is somethign fishy on the old system. 13:05 cait especially since the GUI probably allows like 999 - maybe worth writing a bug 13:04 cait aw-bib[m]: interesting about the renewals 12:54 aw-bib[m] btw: @cait wrt `koc` as discussed the other day - this is no path indeed, as it basically kills the systems ui. and if I'dd have to write some cli to it, sql is easier indeed. 12:54 aw-bib[m] Hi! I am currently migrating loan data and run into an issue with `renewals_count` from https://schema.koha-community.org/23_05/tables/issues.html I see this is defined as `TINYINT` and it seems to be signed tiny int. Now we have a pretty liberal loan policy (stuff does keep coming back) here on campus so I have a number of items with > 127 renewals... any idea how to handle that? 11:57 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34904 minor, P5 - low, ---, oleonard, NEW , Shelf browser not accessible when record has a subscription 11:57 cait bug 34904 11:55 cait hm invoice adjustments, I think, will delete automatically with the invoice (maybe something to check) 11:54 cait the invoicenumber is in aqorders - if the invoice is empty (no linked orders) you shoudl beok 11:53 anke_b[m] Now for a question re Koha: Are parts or traces of invoices somewhere else than in aqinvoices? (I have to remove some test invoices directly from the database; had a similar issue with orders recently.) 11:52 anke_b[m] It was :-) 11:36 * cait waves back (I don't see some smileys in my client, but assume it was a wave) :) 11:35 anke_b[m] (still getting used to the app...) 11:34 anke_b[m] cait: 👋 11:34 * cait waves 11:25 tcohen[m] o/ 11:00 * cait waves at magnuse and oleonard 10:56 magnuse \o 10:23 oleonard o/ 08:34 cait cn you take over for me now? 08:34 cait welcome back PedroAmorim[m] 08:24 PedroAmorim[m] \o 08:16 ashimema lol 08:03 * cait has tea now, it might help 07:50 cait I miss a delete functio here for senseless first thing in the morning comments :) you ARE right! tuxayo++ 07:50 cait oooh I see it now 07:50 cait th eorder number appears after some other text - it't not standalone information 07:49 cait we need a space 07:49 huginn 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34833 trivial, P5 - low, ---, katrin.fischer, Failed QA , "order number" untranslatable when editing estimated delivery date 07:49 cait tuxayo: the follow-up on bug 34833 - not sure htat is right