IRC log for #koha, 2023-09-25

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
01:41 khall joined #koha
04:36 wahanui joined #koha
04:37 kohalogbot joined #koha
06:35 cait joined #koha
06:54 fridolin joined #koha
07:06 cait joined #koha
07:49 cait tuxayo: the follow-up on bug 34833 - not sure htat is right
07:49 huginn 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=34833 trivial, P5 - low, ---, katrin.fischer, Failed QA , "order number" untranslatable when editing estimated delivery date
07:49 cait we need a space
07:50 th eorder number appears after some other text - it't not standalone information
07:50 oooh I see it now
07:50 I miss a delete functio here for senseless first thing in the morning comments :) you ARE right! tuxayo++
08:03 * cait has tea now, it might help
08:16 ashimema lol
08:24 PedroAmorim[m] \o
08:34 cait welcome back PedroAmorim[m]
08:34 cn you take over for me now?
09:13 thibaud_g joined #koha
10:07 khall joined #koha
10:22 oleonard joined #koha
10:23 oleonard o/
10:56 magnuse \o
11:00 * cait waves at magnuse and oleonard
11:22 kidclamp joined #koha
11:25 tcohen[m] o/
11:34 * cait waves
11:34 anke_b[m] cait: 👋
11:35 (still getting used to the app...)
11:36 * cait waves back (I don't see some smileys in my client, but assume it was a wave) :)
11:52 anke_b[m] It was :-)
11:53 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:54 cait the invoicenumber is in aqorders - if the invoice is empty (no linked orders) you shoudl beok
11:55 hm invoice adjustments, I think, will delete automatically with the invoice (maybe something to check)
11:57 bug 34904
11:57 huginn 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=34904 minor, P5 - low, ---, oleonard, NEW , Shelf browser not accessible when record has a subscription
12:02 thibaud_g joined #koha
12:37 khall joined #koha
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.[…]ables/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?
12:54 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.
13:04 cait aw-bib[m]: interesting about the renewals
13:05 especially since the GUI probably allows like 999 - maybe worth writing a bug
13:08 emlam joined #koha
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:09 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: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:17 ? I know that was kind of bad pseudo code
13:18 All that I want to keep^
13:19 cait sorry Shane-NP[m] you confused me a bit there
13:19 what doy ou want to do?
13:19 Batch delete?
13:19 caroline 942$c is generally mapped to biblioitems.itemtype and it's the code that you have to use
13:19 Shane-NP[m] Remove EVERYTHING except the few items with 942c field with Laptop Computer or Tablet Device as the type
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:22 Dyrcona joined #koha
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:24 cait I hink i would not remove with SQL
13:24 but use the ebatch delete feature
13:24 caroline IIRC, if you delete the biblio, it will cascade down to biblioitems and items
13:24 cait make a list of biblionumbers
13:25 using a report  and then batch delete from there.
13:25 caroline ^ that is definitely the safest way to do it, but may require more than one batch
13:26 cait eah, about 1000 each go and some patience
13:27 aroussos left #koha
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:28 It was very resource intensive because of the multiple selects... probably not the best way to do it, but it worked so...
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:30 caroline a list of biblionumbers, one per line
13:31 Shane-NP[m] alright, so can I get a list from Koha, or use SQL for that?
13:31 I have no idea WHAT numbers there are, just that we have about 5000 books in here I no longer need
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:33 Shane-NP[m] Okay, let me try that...select biblionumber from biblioitems where itemtype = 'Book' gave me a nice list in Maria
13:33 However, no clue what 1 and 9 even are :P
13:43 cait the biblionumber is the internal primary key
13:43 all your records will have that
13:43 do you have items on the records?
13:43 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 Shane-NP[m] hmm...Books6672 via Reports on item types, but my SQL only returned 4591 rows, guessing the items on the records
13:44 afr4z[m] joined #koha
13:44 Shane-NP[m] my SQL was on biblio
13:44 so I guess I will have to start with items
13:47 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:48 caroline hm yeah I don't think there is an export option for that one... :/
13:50 cait you could do it from the item search
13:50 i think that exports a nice barcode list and can also limit on checouts
13:51 Shane-NP[m] let me see cause https://wiki.koha-community.or[…]L_Reports_Library is not listing anything when I searched "no check"
13:51 cait go to Koha > item search (from the start page)
13:51 and then at the bottom of the form
13:51 set the checkouts to 0
13:52 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:52 onloan = currently checked out have a date
13:52 and old_issues for previous checkouts
13:52 Shane-NP[m] I like GUI...I can just do SQL if need be :P
13:52 cait btw we urgently need column configuraiton on the item search table
13:53 so try the item search one, export barcode list - use that with the item batch delete feature
13:53 caroline is there a bug for that?
13:54 cait caroline: I bet sec
13:54 23565
13:55 caroline it seems to be blocked...
13:57 cait hm odd
13:57 oh, not the bug, but the feature?
13:57 caroline I don't know oleonard says it's more complicated than it seems
13:58 not "BLOCKED" status, just blocked :)
13:58 cait probably because it's server side... but doesn't it work on ILL now?
13:58 and patron search?
13:58 so maybe we got some examples now
13:58 hm this is not API driven...
13:58 so different I guess thant he other 2
14:14 afr4z[m] magnuse: where do we change the date_renewed of borrowers?
14:15 cait it changes utomatically to today's date when a membership is renewed - it cannot be edited from within Koha
14:15 afr4z[m] no i was referencing a bug
14:15 uhm
14:15 * afr4z[m] uploaded an image: (155KiB) < https://matrix.org/_matrix/med[…]8289583327337.jpg >
14:15 afr4z[m] do i just run tht command on the mysql?
14:16 im on koha 23.05.03
14:17 and when i blank search patrons to get all patrons i get a "500 Internal server error : Month out of range" error
14:22 cait ah, you'd need to run that command in the sql client on your server
14:22 you can't do updates from within Koha
14:24 afr4z[m] ok cool thanks
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:28 emlam caroline - what do you mean by removed? like, from where?
14:28 caroline from my git
14:29 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: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 I mean the koha git, not the ktd git
14:30 It interferes with the translation script and I have to manually delete it everytime in order to run gulp po:update bla bla
14:30 I feel like that isn't normal...
14:31 emlam oh, I see
14:31 yeah, that's not great
14:33 sorry, I'm not sure :(
14:33 caroline no worries, I was asking in case someone knew
14:34 I'm a ktd newbie and don't use it that much in favor of my regular install
14:37 emlam yeah, it's definitely a learning curve
14:37 I think Joubu did the how-to stuff, so I'd ask him when he's around
14:39 Shane-NP[m] so when do enqueued job start?
14:41 emlam usually immediately, unless they get backed up
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:42 * Shane-NP[m] uploaded an image: (39KiB) < https://matrix.org/_matrix/med[…]MtmXxNw/image.png >
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:45 emlam hmmm...as far as I know the background job workers should be running automatically
14:46 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:46 and check the About page for system status / errors as a starting point
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:49 would time zone not being set affect it?
14:50 cait hm maybe the thing for long background jobs is not running
14:50 can you try a koha-common restart?
14:51 Shane-NP[m] I just did a full server restart
14:54 how do I get back to jobs...I don't see it under admin or reports
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:55 the jobs should be under Administration > Jobs
14:56 Shane-NP[m] somehow I missed that
14:56 ty, and they are listed as finished now
14:56 let me try a new one
14:56 cait if they are listed as isnished - maybe check if they did work after all?
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
15:01 new job worked
15:21 will batch deletion jobs slow the server down a lot?
15:24 never mind on that question issue was WiFi cut out
15:28 So items batch deletion can I overide if the item is checked out?
15:31 cait no, you need to return first
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 caroline There is a new option in batch modification to return them in batch
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 oooh right
15:31 new thing
15:31 wahanui well, new thing is hte name showing, right?
15:32 emlam ooh neat! I didn't know about that
15:32 caroline I think it's new from 23.05
15:35 Shane-NP[m] Ah okay Thank you, just a few lingering items, I down to 50 from 6.6K
15:37 hmm..2 left but batch deletion says barcode not found
15:38 emlam joined #koha
15:38 caroline are there spaces before or after the barcode maybe?
15:38 you could maybe feed them into the tool with the itemnumber instead of the barcode
15:50 Shane-NP[m] I just manually went to each one, deleted the items and then deleted the record after
15:57 bag joined #koha
15:59 cait caroline++ Shane-NP++
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.
16:05 caroline So you're the IT dept and loan out computers and other materials is that it?
16:07 cait hm search should not be slow with more
16:07 not with your numbers at least
16:10 Shane-NP[m] Yep, this is best method I have found
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: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 speaking of...I have to adjust the barcode length.....not sure if it reset with the migration
16:13 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:14 I have been doing Koha since...well...I think it was version 3 or 4 before you went to the yearly version model
16:14 caroline yes 3.16 I think?
16:15 cait there never was a 4 - we switched to the year versions before that
16:16 caroline I started just after the switch, with 16.05
16:17 cait not quite 3.2 for me
16:17 Shane-NP[m] well I just know it was before packages, and then you had packages, and then the version changed.
16:18 cait the first library we migrated started on a dev version a bit before it was released as 3.2
16:18 it was an adventure ;)
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: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:19 we also looked at both at the beginning, the help I got here also helped a lot :) trying to pay that back since
16:20 but time to leave for now :) bye!
16:20 cait left #koha
16:20 cait joined #koha
16:20 cait left #koha
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:22 caroline the last of which never happens of course! lol
16:41 magnuse joined #koha
16:52 kivilahtio Joubu: thanks! <3
17:10 cait joined #koha
17:43 fridolin joined #koha
17:43 fridolin yellow
18:35 tcohen[m] hi fridolin
18:44 * fridolin waves
18:49 fridolin tcohen any idea on Jenkins Koha_23.05_D11 ?
18:49 i really dont know how this works ;)
18:49 tcohen[m] oh, right
18:50 selenium tests are fragile to UI changes
18:50 I haven't looked at that specific failure
18:50 D11 is the only 23.05 task on jenkins that runs jenkins
18:50 that runs Selenium tests I think
18:51 master is not failing for that particular test
18:51 so I guess you're missing a follow-up or smth
18:51 do you pick commits from master, or from BZ?
18:59 fridolin from master
19:00 gi tcherry-pick
19:00 tcohen[m] ok
19:00 I cannot check right now
19:00 fridolin no pb
19:00 tcohen[m] and master has its own selenium failure
19:00 fridolin i'll try to monitor it
19:00 tcohen[m] is it random?
19:01 fridolin looks like note
19:01 not
19:49 caroline joined #koha
19:49 bag joined #koha
20:24 bag joined #koha
20:30 fridolin joined #koha
20:32 fridolin left #koha

← Previous day | Today | Next day → | Search | Index

koha1