IRC log for #koha, 2023-08-17

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

All times shown according to UTC.

Time Nick Message
00:17 Penggu dcook__: 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! Thanks for your help!
00:18 dcook__ Penggu: No worries!
00:18 With the conversion, was the problem that it was slow or was it creating an error?
00:19 Penggu creating an error
00:20 dcook__ Hmm could you raise a ticket with that information on Bugzilla? That would be good to share
00:20 Penggu after the mysql client library downgrade, it progressed through some steps, but then hung on those index issues.
00:20 i'll see if i still have some material to make the bug report useful
00:20 dcook__ What version were you upgrading to?
00:20 Thanks :)
00:21 Penggu we're now on 23.05.02.000, according to the UI. The offending upgrade script was 230501003.pl.
00:22 there are no entries in db_revs that create the index. so it must've come from way back...
00:24 dcook__ Yeah it would be an old old index
00:42 dcook_ joined #koha
00:58 Penggu https://bugs.koha-community.or[…]_bug.cgi?id=34548
00:58 huginn 04Bug 34548: major, P5 - low, ---, koha-bugs, NEW , Upgrade failed on conversion of publishercode from varchar to text on biblioitems and deletedbiblioitems due to existing indexes
01:02 Penggu adios!
01:39 edveal[m] So for those in Helsinki, I hope you are enjoying the conference.  I think have the perl group and our Koha community together is a great thing. I am waiting for Montreal dates so I can book my travel.
01:42 dcook_ <3
01:42 edveal[m] Can't wait for Montreal!
02:18 edveal joined #koha
02:21 edveal Ok, I am leaning Element on my phone and at work but not liking it. Now that I am back on an IRC program proper, is there a way to link them so I don't have two nicks?
02:30 @later tell bag Any chance that BWS might be able to provide me any assistance to me for attending Kohacon24 in Montreal. As soon as the dates are set Janet and I are going to be making plans to attend. The problem is that the city of McKinney wont pay for anything out of the country so it will be completely out of pocket. I know this is a bit forward but you can't say yes if I don't ask. LOL I would be glad to work on a formal presentation if that helps.
02:30 Either way I hope to see you there!
02:30 huginn edveal: The operation succeeded.
03:02 edveal_ joined #koha
04:39 dolf joined #koha
05:07 fridolin joined #koha
05:46 reiveune joined #koha
05:49 reiveune hello
06:33 oleonard_ joined #koha
06:34 oleonard_ o/
06:41 dcook_ \o
07:01 davidnind I'm assuming no live streams today and tomorrow for KohaCon 8-(
07:01 ashimema I don't think so
07:02 I'm doing mine over zoom right now
07:02 but from what I'm told it doesn't look like any of the workshops are setup for streaming at the moment.
07:03 davidnind Happy to do any sign offs, just going to have some tea first
07:04 ashimema We're working through bugs attached to Bug 23003 - Accessibility improvements
07:04 huginn 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=23003 enhancement, P5 - low, ---, oleonard, NEW , Accessibility improvements
07:04 ashimema and I'm sure other workshops will be doing their own.
07:04 dcook_ I don't have anything to add at the moment but *waves* and *runs away from his desk*
07:04 davidnind great stuff there for accessibility, lots to do ....
07:20 ebegin joined #koha
07:28 ebegin joined #koha
07:37 matts_ joined #koha
07:39 NadeemSohail[m] joined #koha
07:40 NadeemSohail[m] Hello... (full message at <https://matrix.org/_matrix/med[…]LGOzdLNbsoWCDszld>)
07:42 paulderscheid[m] morning #koha
07:42 ebegin Does sandboxes support ES ?
07:46 oleonard_ WAVE accessibility extension: https://addons.mozilla.org/en-[…]cessibility-tool/
07:46 ashimema They should ebegin
07:46 I believe we run the container for ES, so you should just need to change the system preference
07:47 Another accessibility extension I've had recommended is https://chrome.google.com/webs[…]nindnejefpokejbdd
07:48 aude_c[m] joined #koha
07:48 aude_c[m] Matt mentioned siteimprove https://www.siteimprove.com/in[…]owser-extensions/
07:52 fridolin1 joined #koha
07:55 oleonard_ We do have a QA test for this one but only in the OPAC I think: https://bugs.koha-community.or[…]_bug.cgi?id=25166
07:55 huginn 04Bug 25166: enhancement, P5 - low, ---, oleonard, CLOSED FIXED, Add aria-hidden = "true" to Font Awesome icons in the OPAC
07:56 oleonard_ That is supposed to prevent screen readers from trying to speak the icon
07:58 NadeemSohail[m] Hello !... (full message at <https://matrix.org/_matrix/med[…]DFcIfQvIbvkOzyWTg>)
08:01 aude_c[m] Lund University Opac accessibility statement https://www.ub.lu.se/accessibility-lubcat (Opac at https://lubcat.lub.lu.se/?language=en)
08:07 ashimema Nadeem Sohail: There are a few ways you can do this.. using a feed into Koha's CSV patron import tool, using the RESTful API's.. or perhaps even just using LDAP/SAML2 along with it's autocreation options.
08:13 aude_c[m] Workshop on accessibility statement - see new wiki page https://wiki.koha-community.or[…]ibility_Statement
08:13 dolf After upgrading my Koha from 21.05.00-1 to 23.05.02-1 yesterday, my search results don't look right: https://library.refstudycentre[…]sort_by=relevance The MARC data seems to be there, but the "normal view" is also empty https://library.refstudycentre[…]iblionumber=35948 . Yikes
08:17 NadeemSohail[m] <ashimema> "Nadeem Sohail: There are a few..." <- Dear Ashimema, Thank you for your reply
08:20 aude_c[m] davidnind Still around? We're looking for help with getting new Wiki logins for people at kohacon please :D
08:20 oleonard_ dolf: Are you using a custom XSLT stylesheet?
08:21 dolf: That problem is most often because of a broken XSLT stylesheet
08:21 dolf oleonard_: Not that I know of, but it's not impossible. This Koha instance was first installed back in 2011.
08:22 oleonard_ dolf: Check system preferences for xslt-related prefs
08:23 davidnind aude_c: I am - there is a problem I think with email going out (I think tcohen was having a look at it) - I can see several waiting for approval. Do you know if they got a message to confirm their request?
08:23 NadeemSohail[m] <NadeemSohail[m]> "Dear Ashimema, Thank you for..." <- ashimema: how we can you LDAP/SAML2 along with it's autocreation options
08:24 ashimema Thanks for adding that new page aude_C
08:24 s/aude_C/aude\_c/
08:24 dolf oleonard_: Most of the xlst settings are empty, but two of them are set to "default". Should they all be "default"?
08:24 oleonard_ Yes
08:24 dolf xlst should be xslt
08:25 ashimema NadeemSohail[m]: https://koha-community.org/man[…]otocols.html#ldap
08:26 ashimema: for Shibboleth/SAML2 there's examples in the koha-conf.xml too
08:26 ashimema: https://wiki.koha-community.or[…]eth_Configuration
08:27 ashimema: is some documentation around saml2
08:27 davidnind aude_c: I approved one for Andrew - it is supposed to send him an email with a temporary password - do you know if he has received it?
08:28 aude_c[m] davidnind: Åsa and Andrew just got an email! Sophie is going to request a new one
08:28 davidnind++
08:28 ashimema nice one
08:28 * ashimema just poked Tomas, but sounds like it got fixed before I did
08:28 aude_c[m] Thank you for your help David :)
08:29 davidnind aude_c: looks like tcohen fixed things! Sophie's is waiting for approval, so I'll just approve it and she should get a temporary password.
08:30 aude_c[m] Brilliant!
08:31 davidnind aude_c: Sophie's was waiting from the 20th July! I'll also approve the one waiting for Gladys as well.
08:31 dolf oleonard_: Thanks for the help. Where it says Enter "default" for the default stylesheet I entered "default". Where it says Empty. No XSLT will be applied (default) I left it empty. I clicked all of the "save" buttons. AuthorityXSLTResultsDisplay I left empty because it does not say what the default should be. I also searched for "stylesheet", found  opaclayoutstylesheet had a value, and cleared it. No difference. Is there a cache I should clear?
08:32 davidnind tcohen++ for fixing the Wiki account request email sending
08:32 oleonard_ dolf: I think you may need to restart some services but I'm not sure which
08:33 dolf: I recall that testing XSLT customizations can be tedious because of that
08:33 dolf OK, will do. I'll just reboot the VM, since it's a dedicated Koha VM.
08:33 oleonard_ dolf: Are you using Koha Testing Docker?
08:33 dolf No, I have a `apt install koha-common` on Debian 12 (updated from Debian 10 yesterday)
08:34 Caroline joined #koha
08:35 fridolin1 left #koha
08:36 dolf No difference after the reboot :(
08:36 ebegin joined #koha
08:37 caroline joined #koha
08:38 dolf I wonder whether this has anything to do with the "ALTER TABLE foo ROW_FORMAT=DYNAMIC;" queries I ran yesterday (mentioned above in IRC).
08:40 dcook__ joined #koha
08:43 caroline joined #koha
08:53 aude_c[m] davidnind I'm sorry to bother you again. Sophie and Laurence say they didn't receive any emails... They tried both in July and today to set up a new account on the Wiki and reset password, and nothing. Any ideas, please?
09:00 ashimema wiki email is 'fun'
09:01 oleonard_ :D
09:01 * ashimema is going through the coding guidelines and adding proper syntax highlighting to all the blocks missing it.
09:01 oleonard_ Nice, I'm really glad we have that option now
09:02 davidnind aude_c: I was just going to suggest they try a password reset, but since that didn't work it must be something with the email again! (Their accounts are created https://wiki.koha-community.or[…]er_talk:Smeynieux and https://wiki.koha-community.or[…]User_talk:Lrault)
09:03 aude_c: if tcohen is around, could you ask him to have a look again? Unless ashimema has access...
09:04 aude_c[m] Thanks! We'll ask.
09:04 davidnind Thanks!
09:04 ashimema I sort of have access.. but it's one of the places I don't have the knowledge.. I will get him to talk me through the fix some time so I can help when needed in the future.
09:05 tcohen[m] we really need a reliable SMTP
09:05 Theke's work
09:05 s
09:05 but it gets banned from time to time by major providers (google, microsoft, etc)
09:06 ashimema ptfs-e has their own email server too.. might be able to wangle using that if it helps?
09:06 tcohen[m] sure
09:06 please do
09:06 there's a configuration file in /srv/wiki
09:06 with an SMTP config
09:06 NadeemSohail[m] <ashimema> "is some documentation around..." <- Thank You very much sir, I am obliged you have share a wonderfull docomentations on my query. Stay blessed .
09:06 tcohen[m] you can always back it up
09:06 and try
09:08 oleonard_ joined #koha
09:08 ashimema cool.. may need to wait for Jake to get home as he's the king of that particular castle here at the moment 😜
09:08 tcohen[m] so, SMTP configs, and then look for the sender email address in a bunch of places in that file, and replace it with something that works for your server
09:09 oleonard_ Lunch time in Helsinki, devs please don't forget to eat :D
09:57 oleonard_ joined #koha
09:58 davidnind dolf: I added the record you linked to to my testing environment, and it displayed as expected (your page was missing the HTML markup for displaying the normal view details)
09:59 If I add the record to the cart, the title etc displays OK
09:59 do you have any custom JavaScript or CSS for the OPAC?
09:59 dolf davidnind: Thanks, but I'm not sure I understand. Are you saying that you verified that the problem is not with my MARC data?
10:00 With the help of oleonard above, I removed all custom CSS, and saw no difference. I think there is a tiny bit of JS which just redirects the front page to the advanced search page, but I can remove that and see if it helps.
10:02 davidnind dolf: that was what I was testing, so it doesn't seem to be a problem with the MARC record
10:03 dolf Cool. That is expected, since no staff member has touched the site since I upgraded it yesterday, and everything was displaying nicely before the upgrade.
10:03 (I'm also getting 504 timeouts when doing Catalog searches, which did not happen before the upgrade. Probably unrelated, but I must look into that next)
10:05 davidnind very frustrating!
10:05 dolf This is the only custom JS in sight: https://pastebin.com/vACkhaFj
10:08 Oh, I had some OPACUserCss too, from long ago, for elements that don't exist. I removed both OPACUserCss and OPACUserJs. Saved. CTRL+F5 on OPAC. No difference yet.
10:08 davidnind dolf: I just tried the mJS, and it works OK - so that isn't interferring
10:09 mJS s/be JS
10:09 dolf Here are the last few lines from my opac-error.log https://pastebin.com/RfgMgLkM I don't understand the messages, but I get them repeatedly.
10:11 davidnind not something that makes sense to me either 8-(
10:12 I'm not sure whether you would have to do a full reindex after an upgrade or not - hopefully someone on here can say whether this is what they would do or not
10:14 sorry, I've got to the limit of my limited expertise...
10:14 oleonard_ dolf: The ZOOM error is concerning, and presumably why you're having problem with searches
10:15 dolf: But I don't know how to diagnose and fix. You need someone who knows about Zebra configuration.
10:20 davidnind dolf: not sure whether an upgrade would replace the XSLT files or leave what was there - I think the XSLT files are in koha-tmpl/opac-tmpl/bootstrap/en/xslt - maybe comparing them to what is in master to identify any differences
10:22 dolf Good idea! I'll ook into zebra reindexing and xslt file differences. I also noticed an e-mail saying "run-parts: /etc/cron.daily/koha-common exited with return code 1" so I have yet another thing to investigate. Hopefully all related.
10:23 Is the output of /etc/cron.daily/koha-common logged somewhere?
10:31 Nevermind, /etc/cron.daily/koha-common failing was an unrelated issue, which is sorted now. I appended a line to that script, and my line was failing. The rest of /etc/cron.daily/koha-common is running fine.
10:44 khall joined #koha
11:10 magnuse joined #koha
11:19 cait1 joined #koha
11:34 oleonard joined #koha
11:55 dolf What is the character set supposed to be in the Koha database for most or all tables? latin1? utfmb4?
11:55 And the collation?
12:04 In my DB, the collation is utf8mb4_unicode_ci for all tables, except patron_consent which is latin1_swedish_ci for some reason. Would it be safe to convert patron_consent to utf8mb4_unicode_ci ?
12:09 cait joined #koha
12:12 magnuse joined #koha
12:26 cait1 joined #koha
12:30 cait2 joined #koha
12:38 cait joined #koha
12:41 cait left #koha
12:46 Dyrcona joined #koha
12:49 ashimema any chance of you casting your more artistic eye over Bug 34275 - Add a button to easily toggle between advanced/basic cataloging editors  oleonard
12:49 huginn 04Bug https://bugs.koha-community.or[…]_bug.cgi?id=34275 enhancement, P5 - low, ---, lucas, Signed Off , Add a button to easily toggle between advanced/basic cataloging editors
12:50 oleonard Sure ashimema
12:50 ashimema cheers dude
12:50 right.. I don't think I can put off bookings any longer.. I've got the QA queue moving again and thorough enjoyed the accessability workshop and future of koha talk this afternoon
12:50 time to get on with the hard work again.. haha
12:50 oleonard XD
12:50 ashimema hope your all still enjoying KohaCon
12:51 LibraryHU[m] can anyone help in getting accession register report from KOHA
13:11 dolf oleonard: Do you mean here? https://github.com/Koha-Commun[…]pl/opac-tmpl/xslt There is only one file, and it looks the same as my folder at /usr/share/koha/opac/htdocs/opac-tmpl/xslt
13:11 davidind: previous msg is for you too :)
13:12 I also ran the commands from https://koha-community.org/man[…]t-the-zebra-index but I can't see a difference. Not sure if I'm supposed to run another command to re-index stuff after that?
13:12 The indexer daemon should do that eventually, I guess.
13:13 * ashimema thinks he just scared oleonard away.
13:16 dolf hahaha
13:31 ebegin joined #koha
13:31 caroline joined #koha
13:31 aude_c[m] Emoji test for @ebg 😅
13:45 jalway joined #koha
13:52 dolf What is plack? I can't find any docs on what it does or why I need it. I only see how to install it, here: https://wiki.koha-community.or[…]ebian#Setup_plack
14:00 jalway https://en.wikipedia.org/wiki/Plack_(software)
14:01 khall joined #koha
14:01 jalway khall, Are you Kyle Hall? I found a minor error in the Patron Importer plugin.
14:01 dolf jalway: Thanks, I read that, but it's a bit over my head. I was hoping for a simple explanation of what it does for Koha, and whether it's optional or not.
14:02 jalway dolf, I would highly suspect that it's not.
14:02 dolf, Plack is likely baked into Koha.
14:02 khall jalway can you file an issue on the github page for that and link it here?
14:02 jalway I can do that from the web interface, yes?
14:07 https://github.com/bywatersolu[…]importer/issues/1
14:08 dolf Another question (please tell me if I'm being annoying): I'm trying to use koha-restore on a backup that was made with koha-run-backups (automatically). But I'm getting an erro "No database selected", as if the backup was made with "koha-dump --without-db-name". Is there a way to specify the name on the command line? Or is it a bug in koha-restore or in koha-run-backups?
14:10 jalway dolf, Assuming that was directed at me, I have no idea. I hope you're testing your backup and not just hoping that your untested backup will save you.
14:11 dolf Directed at anyone that would listen :) Yes, I'm testing a backup on a test VM at the moment. No success in restoring thus far.
14:11 jalway dolf, That is definitely the best place to be at in that situation. xD
14:13 dolf, You're using the newest version of Koha?
14:14 dolf, Hmm..., maybe you're running into this: https://bugs.koha-community.or[…]_bug.cgi?id=15664 ?
14:14 huginn 04Bug 15664: enhancement, P5 - low, ---, gmcharlt, NEW , koha-restore: Allow database dump to be restored to another Koha instance
14:15 dolf Yes, I just installed Ubuntu 22 (I could test with Debian also, but it's very very similar) on a fresh test VM, then followed https://wiki.koha-community.or[…]ki/Koha_on_Debian exactly. I have Koha 23.05.02-1 with zero instances, and trying to restore one instance from a .sql.gz and a .tar.gz file.
14:16 wait... I commented on that issue in 2019 hahaha
14:16 I'm Rudolf Byker
14:16 jalway Ah. XD
14:20 dolf In that issue, the problem was that the database name was hardcoded into the sql dump. But it looks like my sql dumps (which come from koha-run-backups on version 21.something) already omit the "CREATE DATABASE" and "USE DATABASE" statements, so it should work? (My message above was confusing – I thought the database name should be in the sql dump, but I see that it's derived from the filename in the koha-restore script)
14:20 jalway You're not trying to overwrite and instance, right?
14:21 *an
14:21 dolf No. There are no instances on this machine. I just installed Ubuntu a few minutes ago.
14:22 Is restoring a backup from 21.* on 23.* unsupported, maybe?
14:23 jalway That's entirely possible.
14:24 There's a bug for 17.x / 16.x, but that's when the biblio_metadata table was introduced.
14:25 Not sure, if there were changes to the database structure between 21.x and 22.x
14:27 dolf There would be, but I was assuming that it's upgradable using the same script that runs after you do "apt upgrade". I'm installing 21.05 now, to try and restore to that.
14:49 jalway khall, I forked the repository, edited the line in question, and pushed it.
14:50 khall jalway did you push it to a github repo?
14:59 lukeg joined #koha
14:59 lukeg hi
15:06 khall jalway fixed!
15:09 jalway khall, Cool, thanks. :-)
15:09 khall np!
15:09 jalway khall, Do you have any documentation on how to use the Patron Importer?
15:09 khall, For whatever reason we're still unable to actually get it to work. :-(
15:10 khall jalway do you have the nightly plugin cronjob enabled? You can run that manually for testing as well
15:12 jalway khall, Pretty sure that's working. Was given a log showing that X num had been processed, but all entries were "invalid".
15:12 khall jalway Also, a big question: Have you become the koha-user and manually connected to the SFTP server? That will accept the key and verify you can connect to it
15:12 it has to be done from koha-shell
15:12 jalway khall, I've run the test and it shows a successful test?
15:12 khall, I've definitely not done that.
15:13 khall jalway give that a try
15:13 it could be failing because the public key hasn'
15:13 hasn't been accepted for that user
15:14 reiveune bye
15:14 reiveune left #koha
15:52 Dyrcona joined #koha
16:14 jalway khall, That wasn't the issue, but it did prompt a phone call. We're on the right track, I believe.
16:14 khall, Apparently the dateenrolled that we're supplying isn't in the expected format. xD
16:28 khall joined #koha
17:03 dolf I managed to restore from backup at last. I had to modify the .sql.gz file and add CREATE DATABASE ... and USE ... statements, OR modify koha-restore to create the database before importing the sql file and to set the database name on the command line when importing the sql file.
17:04 Now I just can't get the search results working. The OPAC search always gives me 0 results. I already did "koha-rebuils-zebra --full instance" (but this is done at the end of koha-restore anyway) and I did "koha-indexer --start rsc". Search results are still empty. I can access the individual books by biblio number in the URL without problems.
18:09 Mimir9090 joined #koha
18:09 Mimir9090 I think one thing I severely misunderstand is how networking for Koha works - I can't even log in on the local network from a different PC than the server is running on, let alone access the OPAC externally
19:00 khall_ joined #koha
19:03 dolf Mimir9000: Koha does not do anything special with regards to networking. It uses Apache2 as a web server. If you follow the guide at https://wiki.koha-community.or[…]ki/Koha_on_Debian you will see that it asks you to modify some variables in /etc/koha/koha-sites.conf . This is used to generate /etc/apache2/sites-enabled/foo.conf when you create a new Koha instance called 'foo'. Inside that are two VirtualHosts. A VirtualHost uses the domain
19:03 name from the URL in the browser to decide which website to serve, so that you can serve more than one website from the same machine through the same port (port 80 by default). Do some reading on how VirtualHost works in Apache2. Also make sure port 80 is open in the firewall, if there is a firewall. I hope this helps.
19:05 In principle: If you have a DNS setting or routing or any kind of network setup which causes a request for http://foo.example.com to end up at the IP on which your Apache2 is running, it will look for a VirtualHost with a ServerName of foo.example.com and try to serve that.
19:18 Mimir9090 I do wonder if there's a firewall in the way
19:18 I asked a technician who said I may need to do port forwarding
19:21 Currently using MarcEdit to search my ISBNs - it's working, but most of them have a match on 1 out of 6 servers which makes me think I need to track down a couple more specialized servers to sure up my records
19:21 Presumably it's because this is mostly textbooks
19:28 davidnind Mimir9090: Many organisations block non-standard ports/traffic from accessing the internet, such as those used by Z39.50 - for example, one of the Library of Congress servers is at lx2.loc.gov:210
19:39 khall joined #koha
20:35 jalway joined #koha
21:31 Mimir909 Holy cow it's working
21:31 I did a batch ISBN lookup with Marc Edit, downloaded the results as a Marc, staged it for import and I now finally have a catalog
21:37 It's a working marc file too, it's all there (as much as could be gotten) and the records will do me fine for now.  How do I go about adding them into the catalog of my defined library?
21:51 Ah, I see the problem - The job keeps failing
21:52 jalway Mimir909, Are you using the compiled marc format or Marc Edit's broken apart, but human readable format?
21:53 Mimir909, Koha will only understand the standard marc format.
21:53 Mimir909 It says it's a 'MARC binary' file
21:53 jalway Mimir909, That should be correct, then.
21:53 Mimir909 the staging seems successful because it has 5000 ish records, but it fails when importing them to catalog
21:57 jalway Did you check for item record data? I'm assuming you've not setup items?
21:58 Mimir909 When I installed Koha, it set a bunch of defaults for items, if that's what you mean
21:58 Or shall I look at the file directly and check?
21:58 jalway Unless you added items to your records, you won't have items. Just the records.
21:59 Mimir909 Ooooooh, like one field that says "this many of this exist", or...?
22:00 jalway Mimir909, You can export items with your marc record. In our old system it was a specific MARC field. In Koha, I think it's a bit more complicated, but you can get the items exported in a specific MARC field. Koha's MARC item field is 952, I believe.
22:01 Mimir909 The MARC file was prepared with MarcEdit, if that helps
22:01 jalway Mimir909, Yeah, so all you got were the bibliographic records. You have no item fields.
22:01 Mimir909 I used its z39 client to make the records then just output them as a marc.  So it can probably also set items
22:02 jalway Mimir909, Just wondering, if that's causing your issue. Or perhaps you chose the incorrect encoding?
22:02 They staged properly, though?
22:02 You can click Manage Staged Records and there's a boat load of them?
22:03 Mimir909, How did you record multiple copies of an item in your spreadsheet?
22:04 Mimir909 Well, what i've done here is take my spreadsheet of ISBNS and converted them to TXT for the z39 client, then looked them all up in a batch, then exported a marc file from that
22:04 The staged record showed no errors and has records for all the items, but they are not showing in the actual catalog and importing them fails
22:05 jalway Mimir909, Yeah, that is cool. Do the books that you have on the shelf have barcodes and/or call numbers associated with them?
22:05 As in phsyical labels on the books.
22:05 *physical
22:05 Mimir909 Not yet - We were using a different software which had a bespoke nonsense number system
22:05 jalway Mimir909, That's actually kind of good.
22:05 Mimir909 They have unique identifiers but the catalog they existed in is totally wrecked and no barcodes either.  Just labels.
22:06 So this initial inventory was done by hand by me
22:06 jalway Mimir909, How did you record how many of X book that you have?
22:06 Mimir909 For each copy, the ISBN or entry is just duplicated
22:06 (many do not have ISBNs, that's a whole other issue)
22:07 jalway Mimir909, You could do a new search by title using MARCEdit, but that would be error prone.
22:07 I.E. The same way you did the ISBN data gathering.
22:08 Mimir909, Are you proficient in any computer languages or actually able to do things like create scripts to manipulate lines of data?
22:08 Mimir909 I mean, the items without ISBNs are few enough to be manually corrected later
22:09 I know enough to understand lines of data and a script if I'm reading it, but haven't coded much
22:09 I can do formulas in Excel pretty okay.
22:09 jalway Mimir909, I highly suggest that you come up with a barcode system that you would like to use.
22:10 Mimir909 That's in the works - For now I guess I need to determine how to tell Koha '1 of this exists' so the import works
22:10 jalway Mimir909, In our library, we typically use a 6 digit number padded with zeros, if necessary.
22:10 Mimir909, You just need to tell the import to not look for item records, I think.
22:11 Mimir909 Just having the catalog in any form will save me a lot of immediate agony in what I'm doing, and polishing it to a proper library setup can wait a little while
22:11 jalway Mimir909, If you just want to upload the records into the catalog.
22:11 When you're staging the records.
22:13 Mimir909 Hmmmmmm.  i don't fully understand this and will have to leave shortly if I'm going to make it to the gym on time to keep my date with my SO.  Is it possible to message directly and arrange for later contact?
22:13 These more in-depth guidances are really helping me get my mind around all this for work.
22:14 I never got super into IRC to know if/how anything like that works
22:18 jalway Uh, not really. Here's a video, though: https://youtu.be/0fJpIqYVMLs?t=568
22:19 Found one that goes through the steps, but I'm not sure that you're having issues with using it or if something's wrong with some of your records or what. xD
22:21 I'm out for now as well, hope you get it figured out!

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

koha1