Time Nick Message
18:46 JasonGreene[m] thanks
18:41 caroline JasonGreene[m], yes, it's now in the Cataloging module
18:39 JasonGreene[m] looking for a link to Koha 23 import data.. I can only find older version and I can't find the "Stage MARC record Management" link , has it changed?
18:35 davidnind Jason Greene: The various log files for Koha are normally located under /var/log/koha/instancename (in a development environment anyway)
16:21 caroline lol!
16:17 JasonGreene[m] no, I walked away and stopped yelling at it so then it could relax and start working.
15:58 reiveune bye
15:58 caroline Someone must have looked at it with angry eyes and it decided to work ;) I have colleague that I called to come look at my computer issues with angry eyes and suddenly it works like a charm
15:57 JasonGreene[m] sorry for the strange issue. and thanks for the help
15:57 JasonGreene[m] however when I click on the "New Category" link it goes to a live page that works.... weird,
15:57 JasonGreene[m] I don't know if anything happened,
15:52 caroline no idea... if you redo the action does it add anything?
15:50 JasonGreene[m] [Fri Feb 16 00:00:01.451658 2024] [core:notice] [pid 23932] AH00094: Command line: '/usr/sbin/apache2'
15:50 JasonGreene[m] [Fri Feb 16 00:00:01.451619 2024] [mpm_prefork:notice] [pid 23932] AH00163: Apache/2.4.57 (Ubuntu) mpm-itk/2.4.7-04 configured -- resuming normal operations
15:50 JasonGreene[m] tail /var/log/apache2/error.log
15:47 caroline what about error.log?
15:47 JasonGreene[m] tail /var/log/apache2/access.log is empty
15:46 oleonard-away JasonGreene[m]: Also, if you want, you can use https://paste.koha-community.org/ for longer messages like that
15:45 JasonGreene[m] ok. thanks, I'll look at that
15:45 caroline I usually go to the apache log when I see that
15:44 caroline ugh that is the most useless message, I hate it
15:44 JasonGreene[m] It shows this in the log file... any ideas... (full message at <https://matrix.org/_matrix/media/v3/download/matrix.org/rRaesiDrHodWwaSvuGWnTyma>)
14:40 caroline ok let us know if it works!
14:40 RamiKaram[m] :)
14:40 RamiKaram[m] i will try that and get back to you
14:40 RamiKaram[m] thank you so much Caroline for the help
14:39 RamiKaram[m] ah perfect
14:39 caroline those are the mandatory fields for the items
14:39 caroline Make sure to add 952$a and 952$b with your branchcode and 952$y with your itemtype too while you're there
14:39 caroline when you change the excel to mrc, map that column to 952$p
14:39 caroline In that case, yes I think generating an incremental barcode in your excel file would be fine
14:38 RamiKaram[m] since i am generating the barcode now, they didnt exist before, i will create them, print them and label the books
14:37 RamiKaram[m] but i can add a field in excel having the barcode value...
14:37 RamiKaram[m] so there is no barcode yet
14:37 RamiKaram[m] i created this mrc file, it was an excel and i converted it using marcedit software
14:35 oleonard RamiKaram[m]: Does your mrc file have barcode stored in another place?
14:35 RamiKaram[m] it does not work right?
14:35 RamiKaram[m] if i use import option
14:35 RamiKaram[m] but this needs to be done manually for each record
14:34 RamiKaram[m] you mean here last item
14:34 caroline yes that is the screen for the items
14:34 * RamiKaram[m] uploaded an image: (44KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/hQBXuydrYHVAOUZwdnUvRsRp/image.png >
14:34 RamiKaram[m] ah i found it now
14:33 caroline if the record is already saved, you can click Add (or New) > Add new item
14:33 caroline it's not in the same screen
14:33 RamiKaram[m] only up to 942
14:32 RamiKaram[m] i still cannot find the field 952
14:32 RamiKaram[m] i have records saved already, when ii edit them
14:32 caroline you should have it after you save the record
14:32 oleonard RamiKaram[m]: Is your barcode stored in another field?
14:32 RamiKaram[m] my problem is that i dont have that field
14:32 oleonard RamiKaram[m]: I don't advise trying to work around using barcode in 952$p
14:31 RamiKaram[m] i see
14:31 caroline out of the box, barcode search only searches in 952$p
14:31 caroline if you use elasticsearch as the searchengine, you can view and modify the mappings in Administration > Search engine configuration
14:30 RamiKaram[m] or is it possible to save a value in another field, and link it when doing search by barcode?
14:29 RamiKaram[m] this is the only place that stores the barcode number?
14:29 RamiKaram[m] 952$p?
14:29 RamiKaram[m] another question to better understand, when you try to search koha using barcode scan, it will search in which field for that number?
14:28 RamiKaram[m] i see
14:21 oleonard Does that make sense RamiKaram[m] ?
14:16 oleonard Or add them one by one to the mrc file
14:16 caroline *your
14:16 caroline You'll have to import you .mrc, and then add the barcodes individually
14:15 caroline I'm not sure it's possible to insert a barcode in the import process in a batch.
14:14 RamiKaram[m] i am still new with koha and trying to understand how barcode works and how to assign them
14:13 RamiKaram[m] how can i enter data to the field 952$p using import
14:12 RamiKaram[m] i have a .mrc file containing information (title, author, publication,...) that i want to upload to koha database, and i want to assign barcode to each record so i can print it and label them
14:12 oleonard When you fill out all the fields you want on that page, submit the form and you should be taken to the item entry form where you will fill out item-level information like barcode.
14:11 * RamiKaram[m] uploaded an image: (58KiB) < https://matrix.org/_matrix/media/v3/download/matrix.org/nAxrIPpJfAjDpsRezsigqNWZ/image.png >
14:11 RamiKaram[m] in the cataloging page, new marc record
14:10 oleonard RamiKaram[m]: Do you mean you only see up to 942 in the MARC editor?
14:10 RamiKaram[m] anyone has an idea about it?
14:09 RamiKaram[m] but i only have fields up to 942
14:09 RamiKaram[m] i am trying to understand how barcode works with koha, i found the field 952$p to insert barcode information
14:08 oleonard Hi RamiKaram[m]
14:03 RamiKaram[m] hi
13:58 oleonard :)
13:57 Joubu oleonard: great follow-ups, thanks!
11:25 huginn` Joubu: The operation succeeded.
11:25 Joubu @later tell marcelr some fun on 36102 comment 8
11:21 oleonard Hi #koha
11:13 magnuse ah!
11:12 Joubu memcached
11:12 magnuse i'm trying to get some more logging from the REST api. changed to "log4perl.logger.api = DEBUG, API" and "log4perl.logger.plack-api = DEBUG, PLACKAPI" in /etc/koha/sites/mykoha/log4perl.conf + restarted plack, but that does not seem to make a lot of difference. is there something else that needs to be done?
10:52 PedroAmorim[m] o/
10:06 magnuse \o/
09:45 paulderscheid[m] morning #koha
07:36 reiveune hello
07:22 Joubu dcook: around?
07:06 marcelr o/
01:57 Arued I then did a restore of the server while waiting for the definitive migration, I can't understand what may have changed in the meantime. Anyone have any suggestions? Thank you!
01:55 Arued the strange thing is that a few months ago I had done exactly the same procedure on the same server and with the same database and everything was successful...
01:53 Arued Hi, i'm tring to migrate from Koha 17.11.02 to 22.11.12. I have dump the old database and restored. However when i run "koha-upgrade-schema instacename", i get the following error: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'type': used in a foreign key constraint 'koha_opacbts/account_offsets_ibfk_t' of table 'koha_opacbts/account_offsets' at /usr/share/perl5/DBIx/Class/Schema.pm line 1118. DBI