![https://matrix.org/_matrix/med[…]8289583327337.jpg](https://matrix.org/_matrix/media/v3/download/matrix.org/uZjMzCBkQWjzxQgbigLPVrVy/20230925_194530_4185528289583327337.jpg){kind=link}
![https://matrix.org/_matrix/med[…]MtmXxNw/image.png](https://matrix.org/_matrix/media/v3/download/matrix.org/pkMfJJKEoeVRcCWHPMtmXxNw/image.png){kind=link}
← 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