gmail.com← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:31 | khall joined #koha | |
| 01:44 | khall joined #koha | |
| 03:28 | khall joined #koha | |
| 03:52 | dcook joined #koha | |
| 03:52 | dcook | FYI for any Ubuntu users: https://github.com/perl5-dbi/DBD-mysql/issues/354 |
| 03:52 | khall joined #koha | |
| 04:11 | khall joined #koha | |
| 04:39 | tcohen[m] | Awesome |
| 04:39 | Ha ha | |
| 04:54 | dcook | Ikr |
| 04:54 | Like I needed this today haha | |
| 05:36 | khall joined #koha | |
| 05:59 | reiveune joined #koha | |
| 06:02 | reiveune | hello |
| 06:02 | oleonard joined #koha | |
| 06:02 | oleonard | o/ |
| 06:07 | magnuse joined #koha | |
| 06:07 | * dcook | waves to folks |
| 06:07 | magnuse | hiya dcook |
| 06:09 | khall joined #koha | |
| 06:10 | magnuse | kia ora khall |
| 06:10 | dcook | btw I'm planning to try downgrading that mysql client to see if that fixes the issue |
| 06:11 | magnuse | i have been working a bit on the protected patrons thingy. hope to have something to test this week |
| 06:34 | magnuse joined #koha | |
| 06:36 | oleonard_ joined #koha | |
| 06:36 | oleonard__ joined #koha | |
| 06:37 | oleonard_ left #koha | |
| 06:37 | oleonard__ joined #koha | |
| 06:38 | magnuse joined #koha | |
| 06:38 | oleonard__ | https://snipboard.io/CQ1P5F.jpg |
| 06:38 | davidnind | nice! |
| 06:39 | dcook | oleonard__ Could throw in Lebanon as well there |
| 06:39 | We've got one library there using English/Arabic/French | |
| 06:39 | And the struggle is real with indexing... | |
| 06:39 | oleonard__ | Yeah I don't know how the speaker collected the numbers |
| 06:40 | cait joined #koha | |
| 06:42 | ashimema | interesting |
| 06:43 | magnuse joined #koha | |
| 06:57 | magnuse joined #koha | |
| 06:58 | thibaud_g joined #koha | |
| 07:02 | tuxayo | UEA counted with only 11 libraries? The speaker would be pleased to know that there at like 1100 more 🤯 |
| 07:02 | https://hea.koha-community.org/ | |
| 07:02 | https://hea.koha-community.org[…]raries-by-country | |
| 07:03 | Here we can see that it seems there have Koha on many (all?) of there schools from kindergarden to secondary | |
| 07:07 | That's super cool. | |
| 07:07 | Maybe the speaker or someone else from the middle east at the KohaCon could have lead to help reach there ministry of education library department? Having contributions from UAE would be very nice. | |
| 07:20 | Ah, I new I missed something silly a few weeks ago. | |
| 07:20 | « paulderscheid : Just thought that tuxayo might get enraged that we recommend Microsoft stuff :D» | |
| 07:20 | lol | |
| 07:23 | Thanks for thinking about mentioning VSCodium/Code though 👍️ | |
| 07:27 | dolf joined #koha | |
| 07:33 | tuxayo | And for the contribution to the wiki. |
| 07:33 | khall joined #koha | |
| 07:34 | dolf | Hi Kohaphiles, I recently did an update from 21.05.00-1 to 23.05.02-1 (we were two years behind!) and I got an error during the database upgrades, but the `apt upgrade` command still exited with code 0. Full outout at https://pastebin.com/04B2Dhdp . Is there a way to fix this, or should I roll back my VM and try something else? |
| 07:35 | The error is: ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT | |
| 07:35 | or BLOBs at /usr/share/koha/lib/C4/Installer.pm line 741 | |
| 07:45 | thibaud_g joined #koha | |
| 07:49 | tuxayo | dolf: what is your database software? |
| 07:50 | oleonard joined #koha | |
| 07:50 | dolf | MariaDB 10.3.39 (running on the same VM) |
| 07:51 | tuxayo | "I got an error during the database upgrades" |
| 07:51 | "but the `apt upgrade` command still exited with code 0" | |
| 07:51 | I'm not sure the script upgrade script in the deb package is taking into account the res | |
| 07:51 | *result of the DB upgrade. Maybe yes and then it's a bug. | |
| 07:51 | "MariaDB 10.3.39" | |
| 07:51 | ok, nothing weird here | |
| 07:54 | That's the version in Debian 10 and our CI tests it and it's indeed using MariaDB 10.3.39 | |
| 07:55 | dolf | Thanks for your time so far! (I'm thinking hard this side as well...) |
| 07:56 | tuxayo | dolf: you definitely should rollback your VM, at least keep the back preciously |
| 07:57 | During the time you examine your DB | |
| 07:57 | davidnind | Bug 28267 has some of the errors mentioned, such as "Row size too large", but it is a bit too complicated for me to make any sense of.... |
| 07:57 | huginn | 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=28267 critical, P1 - high, ---, jonathan.druart+koha, Pushed to stable , Older databases fail to upgrade due to having a row format other than "DYNAMIC" |
| 07:59 | tuxayo | davidnind: good find! |
| 07:59 | dolf: the ticket mentions this: https://wiki.koha-community.or[…]tabase_row_format | |
| 08:01 | So I guess could check the row format you have | |
| 08:02 | And if it's wrong, rollback the VM, fix the row format and re run the upgrade. | |
| 08:05 | Does anyone know why it's this upgrade that git a problem about row size? https://git.koha-community.org[…]revs/210600041.pl | |
| 08:05 | It doesn't seem related | |
| 08:06 | And it's not the package upgrade script that doesn't seems to handle the error. It's updatedatabase.pl itself, right? Maybe it also exposes a bug there. | |
| 08:07 | (when looking at the output https://pastebin.com/04B2Dhdp) | |
| 08:13 | aroussos joined #koha | |
| 08:18 | dolf | Thanks for the advice!! Do you need any more info from my broken VM before I roll back? |
| 08:27 | davidnind | Joubu++ for presentation |
| 08:30 | dolf | The row format seems to be "compact" rather than "dynamic" :) I'll try to change it! |
| 08:30 | oleonard__ joined #koha | |
| 08:36 | thibaud_g joined #koha | |
| 08:40 | thibaud_g joined #koha | |
| 08:40 | dolf | `show table status where row_format <> "dynamic";` gives me 202 rows. Would it be safe to blindly run ALTER TABLE on all of them to convert them to dynamic, or should I focus on specific tables? |
| 08:44 | I can generate the ALTER TABLE query strings using: SELECT CONCAT('ALTER TABLE `', table_schema, '`.`', table_name, '` ROW_FORMAT=DYNAMIC;') FROM information_schema.tables WHERE table_schema = 'koha_rsc' and row_format <> 'Dynamic'; | |
| 08:50 | tuxayo | > The row format seems to be "compact" rather than "dynamic" :) I'll try to change it! |
| 08:50 | dolf ah great! | |
| 08:52 | > Would it be safe to blindly run ALTER TABLE on all of them to convert them to dynamic, or should I focus on specific tables? | |
| 08:52 | likely: https://bugs.koha-community.or[…].cgi?id=28267#c20 | |
| 08:53 | huginn | 04Bug 28267: critical, P1 - high, ---, jonathan.druart+koha, Pushed to stable , Older databases fail to upgrade due to having a row format other than "DYNAMIC" |
| 08:53 | dolf | I'm testing that now. |
| 08:56 | tuxayo | If you are very very careful you could diff a dbdump before and after that. |
| 08:56 | If you are not, just rely on the update script working and Koha basic usage working afterwards. | |
| 08:58 | dolf | I'm not that careful :P (I also have nightly mysqldumps, so if all else fails I'll just re-install and restore, or even build a new VM) |
| 08:59 | khall joined #koha | |
| 09:14 | dolf | Would this https://pastebin.com/5ujqW3H0 be worthy of adding to https://wiki.koha-community.or[…]tabase_row_format ? |
| 09:15 | oleonard joined #koha | |
| 09:23 | davidnind | dolf: definitely worth adding! (assuming it worked for you) |
| 09:24 | If you don't have an account on the Wiki, I can add it. | |
| 09:24 | dolf | I requested a wiki account, but still waiting for the e-mail |
| 09:25 | davidnind | dolf: it still pending, but I can approve anyway! (I find most often that the request confirmation email goes into people's SPAM folders... |
| 09:25 | dolf | Just waiting for my VM provider to perform the rollback, than I'll do the final test to verify if it works. |
| 09:27 | Thanks :) | |
| 09:27 | Nothing in spam yet (unless it was blocked on the outgoing server or on Google's servers, in which case there is a big problem with the mail delivery) | |
| 09:34 | davidnind | Let me know if you don't receive anything relatively soon - there may be something wrong the email (it's not something I look after, so will have to raise a bug!) |
| 09:57 | eythian | @seen drojf |
| 09:57 | huginn | eythian: drojf was last seen in #koha 4 years, 37 weeks, 3 days, 14 hours, 43 minutes, and 0 seconds ago: <drojf> -s |
| 09:59 | ashimema | no-one has heard form him in years eythian |
| 10:04 | eythian | I know, I was looking up how long years was, for a conversation :) |
| 10:04 | dolf | davidnind Nothing yet. Did I make a typo? rudolfbykergmail.com |
| 10:07 | ashimema | I see |
| 10:08 | davidnind | dolf: that's what was entered, so looks like something is up with the email 😦 ... Your account is activated - you may be able to do a forgotten password reset, but this may not work either |
| 10:13 | @later tell thd Could you look at the Wiki setup to check whether emails are being generated? New user dolf didn't receive confirmation request or notification when approved (has checked SPAM folders) | |
| 10:13 | huginn | davidnind: The operation succeeded. |
| 10:14 | davidnind | @later tell tcohen Could you look at the Wiki setup to check whether emails are being generated? New user dolf didn't receive confirmation request or notification when approved (has checked SPAM folders) |
| 10:14 | huginn | davidnind: The operation succeeded. |
| 10:14 | khall joined #koha | |
| 10:22 | dolf | davidnind: The reset password e-mail also did not reach me |
| 10:35 | davidnind | dolf: thanks for letting me know - KohaCon23 is on at the moment, so those that can look at it are likely to be busy... |
| 10:38 | jac joined #koha | |
| 10:38 | jac | Hello |
| 10:40 | Guest9049 | We would like to know more about the Koha Library Software, any sales or contact in Hong Kong that we could reach? |
| 10:45 | cait joined #koha | |
| 10:53 | Guest9049 | OK, I'll try to contact them for more details. Thank you! |
| 10:57 | cait left #koha | |
| 11:27 | dolf | I'm trying to upgrade Debian 10 to Debian 11 on my Koha VM (Koha is already at the latest version), but after changing the release in /etc/apt/sources.list from buster to bullseye and running `apt update` and `apt upgrade`, rabbitmq-server fails to start. Is rabbitmq-server used by Koha, or can I simply remove it and move along? |
| 11:42 | davidnind | dolf: rabbitmq-server is used by Koha - it now runs some the queued tasks. But I don't know how it works - there have been messages on the mailing list about this in the past, so maybe searching the archive will help... |
| 11:43 | tcohen[m] | we need a reliable SMTP server for community services |
| 11:46 | dolf | I just did `systemctl stop rabbitmq-server && systemctl disable rabbitmq-server` and re-ran `apt upgrade` and it worked. Then `apt full-upgrade`. This automatically re-enabled rabbitmq-server, and it started without issues this time. |
| 11:47 | tcohen: Google Workspace for Non-Profits works very well for us. Is Koha Community a non-profit? | |
| 12:33 | khall joined #koha | |
| 12:48 | paulderscheid[m] | @tuxayo concerning the dev workflow w/ ktd it is possible to get this working w/ the oss solutions but it’s much more complicated and we have yet to document it so it’s easy to understand for new devs |
| 12:48 | huginn | paulderscheid[m]: I'll give you the answer as soon as RDA is ready |
| 12:48 | wahanui | i already had it that way, huginn. |
| 12:49 | paulderscheid[m] | we also need to mention devcontainers.json |
| 13:08 | matts_ joined #koha | |
| 13:09 | Dyrcona joined #koha | |
| 13:41 | khall_ joined #koha | |
| 14:08 | dcook_ joined #koha | |
| 15:11 | reiveune | bye |
| 15:11 | reiveune left #koha | |
| 15:40 | kidclamp joined #koha | |
| 16:01 | khall joined #koha | |
| 16:34 | khall_ joined #koha | |
| 17:41 | fridolin joined #koha | |
| 19:23 | Mimir909 | woah that's crazy |
| 19:23 | seeing someone named huginn is a coincidence for me. haha | |
| 19:33 | fridolin joined #koha | |
| 19:37 | khall_ joined #koha | |
| 19:52 | jalway joined #koha | |
| 19:52 | davidnind | Mimir909: higinn is one of the "helpful" bot accounts we have on the channel... |
| 19:52 | Mimir909 | oh cool |
| 19:52 | davidnind | Minmir909: That should be huginn! |
| 19:52 | Mimir909 | I really need help understanding the basics of Koha for work. Hahaha |
| 19:53 | I've subsribed to the mailing list, pounded my head against the documentation, and even reached out to an active user listed on the site. | |
| 19:53 | davidnind | It's probably not that helpful 8-) |
| 19:53 | jalway | Mimir909, What would you call your level of technical expertise? |
| 19:55 | Mimir909 | I understand how programming works but have never really coded anything of major complexity. I can write HTML partially from memory or understand its working parts to use tools to put it together. |
| 19:55 | I consider myself 'moderate' where 'expert' is so many leagues beyond it, but I can't say I'm a total beginner either, just not super in-depth, haha | |
| 19:55 | jalway | Mimir909, Have you used Linux? |
| 19:56 | Mimir909 | Until this, no - But I've gotten through Koha setup to the point where I was able to perform web installation and see the configuration options |
| 19:56 | jalway | Mimir909, Hmm..., that's a nice starting point! |
| 19:57 | Mimir909, Have you been able to login? | |
| 19:57 | Mimir909 | Yep, logged in and looking at admin panel. |
| 19:57 | jalway | Mimir909, Okay, so the hard part is doing all of the fiddly bits. xD |
| 19:57 | Mimir909 | I can see settings are a series of named variables which can be modified through a menu, which is cool. The main thing I am trying to do right now is I have a big ol' list of ISBNs and I want to add them and get the zebra search to do its thing to them |
| 19:58 | jalway | Mimir909, There is a boat load of settings, etc. that you need to configure to get a "functional" library setup in Koha. |
| 19:59 | Mimir909 | If I can just get our base inventory up and running, the defaults should help quite a bit |
| 19:59 | jalway | Mimir909, Probably the best way to start is to create a user, a book, and check-out the book to that user. |
| 19:59 | Mimir909, Uh, you already imported everything? | |
| 19:59 | Mimir909 | The import is what I'm trying to figure out |
| 19:59 | I have MARC and CSV and it doesn't seem to take either and won't tell me why | |
| 20:00 | jalway | Mimir909, You are doing this without a support company like ByWater Solutions, yes? |
| 20:02 | Mimir909 | We absolutely cannot afford the |
| 20:02 | I am the most technically inclined guy in the school I work for and just need to figure this out enough to make use of the software for tracking purposes for now, the actually functional library can come later | |
| 20:03 | jalway | Mimir909, Have you defined your collections? |
| 20:03 | Mimir909 | Well, currently it looks like my setup started with the defaults - Fiction, Non-Fiction, and Reference |
| 20:06 | Which works for me for now | |
| 20:09 | jalway | So, what you want to do is use the Cataloging interface to stage records for import. |
| 20:10 | More->Cataloging->Stage records for import | |
| 20:11 | Mimir909 | Cool, I've looked at that, and this is where I get a roadblock - When I upload my file (I have it in both MARC and CSV format, as mentioned) it says it starts the job but doesn't actually seem to do anything |
| 20:11 | And my best guess there is that I just don't have the file configured the way it wants | |
| 20:11 | jalway | Have you clicked on the Manage staged records button? |
| 20:11 | Mimir909 | Hmmm, let me look (: |
| 20:12 | It says 'No records have been staged' | |
| 20:12 | I've tried to upload multiple times and it seems to go nowhere, so far | |
| 20:13 | jalway | Hmm... |
| 20:13 | Mimir909, I would suggest using this tool to verify that your records are valid. https://marcedit.reeset.net/ | |
| 20:13 | Mimir909 | So far what I've theorized is just that my format is missing something so it's not taking it properly |
| 20:13 | Ooooh that sounds fun lemme try | |
| 20:14 | Ah, okay, this is the MarcEdit software - I downloaded that and tried using it to get my initial MARC file | |
| 20:14 | I may also not be doing that part correctly. | |
| 20:15 | jalway | Mimir909, Can you use marcbreaker to break the marc file into a human readable format? .mrk vs .mrc? |
| 20:16 | In the event that it's throwing errors, then you have bad data. | |
| 20:16 | Mimir909, Where did you get your MARC file? | |
| 20:19 | khall_, You are the Kyle Hall, yes? I found a typo in the Patron Importer plugin. | |
| 20:19 | Mimir999 joined #koha | |
| 20:19 | Mimir999 | Hello, jumped onto the windows PC where my MarcEdit lives |
| 20:19 | I got the MARC file by taking a spreadsheet of our catalog and trying to convert it using MarcEdit | |
| 20:20 | jalway | Ah, nice, so no room for error, then. xD |
| 20:21 | What system are you pulling your catalog data from? | |
| 20:21 | There's no way to get an actual marc file exported? | |
| 20:22 | Mimir999 | Well, the catalog is hand-assembled. I went through every item in the building and noted its ISBN in the spreadsheet |
| 20:22 | * paxed | boggles |
| 20:22 | jalway | Mimir999, I think my brain started bleeding there. |
| 20:23 | Mimir999, What datapoints do you have? | |
| 20:23 | Mimir999 | That means we're on the right track |
| 20:23 | In the base catalog, just ISBNs and some questionable titles. | |
| 20:24 | For context, they were using an utterly busted library software that is online only but stopped being supported by developers, so several basic functions broke down and no one knows when but everything kept going | |
| 20:24 | jalway | Mimir999, Is that what the MARC records consist of? |
| 20:24 | Mimir999 | The MARC file will be whatever MarcEdit spat out when I attempted to convert it, assuming I even did it correctly |
| 20:25 | jalway | Mimir999, MARC is not a magic ball. Did you you only give it a questionable title and an ISBN? |
| 20:25 | Mimir999, Or do you have complete records? | |
| 20:27 | Mimir999 | The complete records exist in the form of a wildly inaccurate catalog |
| 20:28 | From the old software I can pull something more in-depth, but it also will list 100 copies of something we only had 40 of, and has tons of other data errors. | |
| 20:28 | The catalog I made is just titles and ISBNs | |
| 20:29 | jalway | Mimir999, Please see here: https://www.loc.gov/marc/bibli[…]hic/examples.html |
| 20:29 | Mimir999, Those are examples of full MARC standard records. | |
| 20:30 | Mimir999, How many records are we talking about? 1k, 2k, 30k? | |
| 20:30 | Mimir999 | Around 3000 |
| 20:30 | A piddly library of textbooks for students of an independent magnet school, but one which I am the only person able to really do anything with | |
| 20:31 | jalway | Mimir999, The easiest solution may be to manually pull records for every book using Z39.50 from within Koha. |
| 20:31 | Mimir999 | Right, that's what I'm hoping to do |
| 20:32 | But the actual doing it is not totally understood either | |
| 20:32 | jalway | Mimir999, Click Z39.50 in the Administration module. |
| 20:32 | Mimir999 | I talked to Paul over at the Naval Archives in Ontario who is a Koha 3 user and he suggested coding a script that manually catalogs stuff 1 by 1. |
| 20:32 | Checking there now (: | |
| 20:32 | jalway | More->Administration->Z39.50/SRU servers administration |
| 20:33 | Mimir999, You'd possibly spend more time coding a script to do it imperfectly than you would just searching for all the records manually. | |
| 20:34 | Mimir999, What libraries do you have listed in the Z39.50/SRU servers? | |
| 20:34 | Mimir909 | Library of Congress (there is 4 of them) and a library in France |
| 20:34 | Checking with Paul, I determined I had correct settings for connection under these, as they seemed to be configured default | |
| 20:36 | jalway | Here's a couple more that will be helpful: |
| 20:36 | LINK - CALIFORNIA,csul.iii.com:210,INNOPAC,No,0,USMARC,utf8,0,Bibliographic | |
| 20:37 | OHIOLINK,olc1.ohiolink.edu:210,INNOPAC,No,0,USMARC,utf8,0,Bibliographic | |
| 20:38 | SAN FRANCISCO PUBLIC LIBRARY,sflib1.sfpl.org:210,innopac,No,0,USMARC,MARC-8,0,Bibliographic | |
| 20:38 | Mimir909 | What do 'No' and '0' refer to, before the 'USMARC' setting? |
| 20:39 | jalway | That's just preselected and rank, stuff that you can decide on yourself. |
| 20:40 | The keys are the name of the where you're getting your record, the host:port,database name, syntax, and encoding. | |
| 20:41 | Err..., also, whether you're trying to pull bibliographic/authorities records. | |
| 20:41 | We just use Library of Congress for our Authorities. | |
| 20:42 | All the rest of the Z39.50 servers that we use are for bibliographic records. | |
| 20:43 | Mimir909, What I highly suggest is that you just manually catalog everything. It will take a significant amount of time. | |
| 20:44 | More->Cataloging->New from Z39.50/SRU | |
| 20:44 | Once you have all of those Z39.50 Servers setup. | |
| 20:44 | Then, just do a search via ISBN | |
| 20:45 | Import record that looks good and click save. | |
| 20:45 | Repeat, 3000 times. | |
| 20:45 | I highly recommend you add a column to your QuestionableTitle,ISBN spreadsheet. Add, ImportedToKoha. | |
| 20:46 | Then, you will have 3k known good records. | |
| 20:46 | Mimir909 | Hmmmmmm, cool |
| 20:47 | How should ISBN be formated to get matches? | |
| 20:47 | jalway | You can fiddle with the items after you get all of the records in the system. As the items are how you check-out a book associated with that record. |
| 20:47 | 10digit or 13digit. Koha doesn't like the dashes. | |
| 20:47 | Mimir909 | Also, are those Z servers or SRU servers? |
| 20:48 | jalway | Mimir909, The ones I listed are Z39.50 servers. |
| 20:49 | Mimir909 | Cool. I may have made a typo in one because it's getting timeouts, so I'll double check that |
| 20:49 | jalway | Which one is timing out? |
| 20:50 | Mimir909 | California |
| 20:51 | Also, I have a match! That's cool. Though, it didn't match the first one I tried which is perplexing. | |
| 20:51 | jalway | Hmm.., yeah, they're all working on my config, so not sure what I can tell you about that. xD |
| 20:51 | Mimir909, Textbooks are stupid like that. I hate cataloging textbooks. | |
| 20:52 | Mimir909 | Yeeeaaaaah. Hahaha |
| 20:52 | Hey, I notice there's an item type called 'Continuing Resources' - What is this intended for? | |
| 20:53 | jalway | Continuing Resources == Serials == Periodicals == Magazines, etc. |
| 20:53 | Theoretically, it could be a more book like thing that is also a serial, but doesn't look like a magazine. | |
| 20:54 | Mimir909 | Interesting. |
| 20:54 | jalway | LINK-California is a consortium of libraries, the OHIOLINK catalog is also a consortium of libraries, and the SF Public is just a great place to get records for DVDs, etc. |
| 20:55 | SF Public just has some nice records, too. | |
| 20:55 | Quality wise. | |
| 20:58 | I got started cataloging by cataloging serials, because we were paying something like $3k a year for a dumb tracker we only used internally. | |
| 20:58 | Which is where Koha came in for us. | |
| 20:58 | We just made the switch from our cataloging system of 20 years, to Koha, fully. | |
| 21:02 | Mimir909 joined #koha | |
| 21:02 | Mimir909 | Whoops, crashed my Linux. |
| 21:05 | Great time to practice the actual server side commands for Koha - Which thing in the terminal will actually start the server back up? | |
| 21:06 | jalway | Mimir909, That's what I have IT people for. xD |
| 21:06 | Mimir909, I can probably find it somewhere, been a while though. xD | |
| 21:08 | Mimir909 | Ah, I have to start Apache |
| 21:12 | Crap. Server went down in the crash and I need to figure out how to get it up again. Lol | |
| 21:21 | Okay, it's back up - Is there an easy way to just check the catalog directly? Or do I have to run a report and such? | |
| 21:23 | jalway | Mimir909, You mean to see if a record is in the system? |
| 21:23 | Mimir909, Click Cataloging at the top and just do a search in the text box given. | |
| 21:23 | up at the top | |
| 21:24 | Mimir909, You should also have an OPAC view, but I have no idea how to tell you how to get to that. xD | |
| 21:25 | Mimir910 joined #koha | |
| 21:25 | jalway | Mimir910, Actually, once you have an item up in the cataloging search, there is an Open in OPAC view. |
| 21:26 | "OPAC view: Open in new window." Once you have clicked on an item that you've cataloged. | |
| 21:26 | Mimir910 | Hey, cool - I exported catalog data and then opened it in MarcEditor |
| 21:26 | jalway | That's your "public" Catalog view. I have no idea how you have Koha setup, so I have no idea, if it's public or not. |
| 21:27 | From Koha or from your old system? | |
| 21:27 | davidnind | You can list all records in the system - in the staff interface, from the dropdown list next to Search in the top header select Advanced search, then select the Item types you have and click on Search. |
| 21:28 | Mimir910 | From Koha |
| 21:28 | jalway | Mimir910, Cool, yeah, Koha is nice like that. Once you have your data in Koha, you can still get your data out of Koha. ;-) |
| 21:30 | davidnind | I'll put together a list of resources that may help, but I can't do that until the weekend. In the meantime, here are some to get you started (bearing in mind that some things may not be up-to-date with the version you are using (assuming Koha 23.05.x). |
| 21:31 | ByWater Solutions learning resources: https://koha.bywatersolutions.com/ | |
| 21:32 | koha-US learning resources: https://koha-us.org/learn/ | |
| 21:33 | (bonus with koha-US - the special interest groups are really useful to attend, depending on your area of interest, and are open to anyone) | |
| 21:34 | jalway | Nice. :-) |
| 21:35 | davidnind | Koha Geek - lost of useful tips and quick tutorials: https://kohageek.blogspot.com/ |
| 21:37 | RAFLIMITS - I haven't watched many of these, but they seem great (more in-depth tutorials/instructions): https://www.youtube.com/@RAFLIMTS | |
| 21:40 | And there is the Koha Community manual - it's always a work in progress, and we've never managed to have it 100%up-to-date! https://koha-community.org/man[…]n/html/index.html | |
| 21:41 | Probably something useful for you - Implementation check list (https://koha-community.org/man[…]n-checklist-label) and Cataloguing (https://koha-community.org/man[…]/cataloging.html) | |
| 21:42 | jalway | You can also click the help button on a page in Koha to be taken to the manual. |
| 21:42 | davidnind | I'll see if I can find a more recent tutorial on importing your data - there are a lot around, but some a quite dated - unless anyone else beats me to it! |
| 21:43 | Mimir910 | Oh snap |
| 21:43 | MarcEdit has a z.50 client | |
| 21:44 | jalway | davidnind, Part of the trouble is the data. Mimir910, Has 2 datapoints, QuestionableTitle+ISBN. |
| 21:45 | Mimir910, Yes, it's a little finicky, but it is usable. | |
| 21:45 | Mimir910 | Any way I can do this bulk is ideal, haha |
| 21:45 | One day just getting a bunch up on my Koha at once will speed up the rest of the actual work I need to do | |
| 21:46 | jalway | Mimir910, I used the MARCEdit Z39.50 client some. You can add those Z39.50 servers to the server list in MARCEdit as well. |
| 21:47 | Mimir910, Hmm..., looks like you could do a batch search form a file with a list of ISBNs. | |
| 21:48 | Mimir910, Using MARCEdit. | |
| 21:48 | Then, you could download those records and stage those for import in Koha. | |
| 21:49 | At which point you'll be trying to import probably good records. | |
| 21:51 | Mimir910 | God yes this is what I need. Hahaha |
| 21:51 | This is all helping me understand how this stuff works but I got orders to fill and was hoping to use a backing of a working catalog for it | |
| 21:51 | To prevent this becoming a mess again in the future, because it's a huuuuge mess they handed me and asked me to fix | |
| 21:55 | davidnind | You need to make sure that your MARC records have the required information for Koha, such as the item type codes, and the codes you use for things like collections, library location, etc. - these need to match what you have setup in Koha. I will try to find a good resource about this for you. |
| 21:58 | If you aim for a minimal record - such as title, author, ISBN, etc. ; and item information, such as barcodes, etc., - you can always enhance later on either with updating individual records using Z39.50 search or exporting, using MARCEdit for Z39.50, and then updating the records in Koha. | |
| 21:59 | jalway | Mimir910, Yeah, you can batch search / save marc records via a list of ISBNs. Using the batch search feature in MARCEdit. |
| 22:01 | Mimir910, I just tested it, I didn't get any hits, but it seemed to function correctly. I just grabbed 3 random ISBNs and searched a random small library. So, it's not surprising that I didn't get any hits. | |
| 22:01 | davidnind | Hope we are not overwhelming you here! 8-) Start slowly, get the import of a representative sample of records and items working, then rinse and repeat. |
| 22:07 | jalway | Oof, the documentation for MARCEdit is helplessly out-of-date, but the Z39.50 batch search by ISBN seems to be functional. |
| 22:11 | I'm out. Have a good one. o/ | |
| 22:11 | jalway left #koha | |
| 22:15 | Mimir910 | As a person who's worked in kitchens, I don't really do 'overwhelmed' |
| 22:15 | But I do live in a perpetual state of struggling against a new, higher level of understanding and performance. Haha | |
| 23:39 | Penggu joined #koha | |
| 23:39 | Penggu | Hi. Anyone come across "WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version." errors that prevent the installer from succeeding? |
| 23:40 | dcook_ | Penggu: That should be a warning rather than an error |
| 23:40 | It shouldn't be preventing the installer from working | |
| 23:40 | Penggu | On the web: Updating database structure /Update errors : / WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. / [Try again] |
| 23:40 | dcook_ | Interesting.. |
| 23:41 | In any case, I suggest looking at https://github.com/perl5-dbi/DBD-mysql/issues/354 | |
| 23:41 | You'll most likely want to downgrade libmysqlclient21 | |
| 23:41 | Penggu | log files don't shine any light. Same line in /var/log/koha/site/updatedatabase-error.....log |
| 23:41 | dcook_ | The latest client has been wreaking havoc on the Internet the past 24 hours or so |
| 23:41 | Penggu | ok thanks for the pointer |
| 23:42 | dcook_ | No worries. Unfortunately, it's the only real option at the moment until DBD::mysql release an update to their Perl module not to set MYSQL_OPT_RECONNECT (even as false) |
| 23:42 | This comment specifically will help you the most: https://github.com/perl5-dbi/D[…]omment-1679677264 | |
| 23:43 | Penggu | perfect - thanks |
| 23:43 | i've got other upgrade errors now (progress!) | |
| 23:43 | dcook_ | Hehe |
| 23:44 | You're in Victoria, yes? At a library or a company? | |
| 23:45 | Penggu | yes - a k12 school |
| 23:46 | dcook_ | Ah very cool |
| 23:47 | I'm in NSW so I'm around if you have questions/issues | |
| 23:47 | Penggu | thank you |
| 23:58 | Had to delete a couple of publishercode indexes on biblioitems and deletedbiblioitems because the upgrade script was trying to convert the column to text from varchar(255). Finally finished the upgrade! | |
| 23:59 | dcook__ joined #koha |
← Previous day | Today | Next day → | Search | Index
