Hello, I am able to solve the problem (thanks to Kaitrin) but i am not able to prevent it, how can i prevent "holding branch" getting null values at item table, i think this is happing to every new items created in the koha database. I am not a librarian myself, does this have to do how our librarian coleagues are creating the items, am i missing any configuration set up parameter? +----------------+---------+---------------+------------+ | itemcallnumber | barcode | holdingbranch | homebranch | +----------------+---------+---------------+------------+ | 9349/M | 9349/M | NULL | BACOSTA | | 23623/M | 23623/M | NULL | BACOSTA | | 23624/M | 23624/M | NULL | BACOSTA | | 23625/M | 23625/M | NULL | BACOSTA | | 23626/M | 23626/M | NULL | BACOSTA | | 23627/M | 23627/M | NULL | BACOSTA | | 23628/M | 23628/M | NULL | BACOSTA | | 23629/M | 23629/M | NULL | BACOSTA | | 23630/M | 23630/M | NULL | BACOSTA | | 23631/M | 23631/M | NULL | BACOSTA | +----------------+---------+---------------+------------+ Best regards, Paulo Neto DSIGA / DPGI Tel. (+351) 21 844 2228 http://www.dgadr.gov.pt
Hi Paulo, please check if you have hidden the homebranch (952$a) and holdingbranch (952$b) in your frameworks. If you have only one branch, you can use a default value, if you have multiple, make them visible again and they will be automtically pre-set with the homebranch of the cataloger. Hope this helps, Katrin On 30.10.23 17:05, Paulo Neto wrote:
Hello,
I am able to solve the problem (thanks to Kaitrin) but i am not able to prevent it, how can i prevent "holding branch" getting null values at item table, i think this is happing to every new items created in the koha database. I am not a librarian myself, does this have to do how our librarian coleagues are creating the items, am i missing any configuration set up parameter?
+----------------+---------+---------------+------------+ | itemcallnumber | barcode | holdingbranch | homebranch | +----------------+---------+---------------+------------+ | 9349/M | 9349/M | NULL | BACOSTA | | 23623/M | 23623/M | NULL | BACOSTA | | 23624/M | 23624/M | NULL | BACOSTA | | 23625/M | 23625/M | NULL | BACOSTA | | 23626/M | 23626/M | NULL | BACOSTA | | 23627/M | 23627/M | NULL | BACOSTA | | 23628/M | 23628/M | NULL | BACOSTA | | 23629/M | 23629/M | NULL | BACOSTA | | 23630/M | 23630/M | NULL | BACOSTA | | 23631/M | 23631/M | NULL | BACOSTA | +----------------+---------+---------------+------------+
Best regards,
Paulo Neto DSIGA / DPGI Tel. (+351) 21 844 2228 http://www.dgadr.gov.pt
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hello Katrin, Thank you for your answer. We dont have any marc reference for the holding branch defined on the bibliographic model as far as i have checked so in terms of the database this makes sense for the null value Showing up, wehave a record for the home branch but we wont have a record for the holding branch. Paulo Neto DSIGA / DPGI Tel. (+351) 21 844 2228 http://www.dgadr.gov.pt -----Mensagem original----- De: Koha <koha-bounces@lists.katipo.co.nz> Em Nome De Katrin Fischer Enviada: 30 de outubro de 2023 16:53 Para: koha@lists.katipo.co.nz Assunto: Re: [Koha] null values Hi Paulo, please check if you have hidden the homebranch (952$a) and holdingbranch (952$b) in your frameworks. If you have only one branch, you can use a default value, if you have multiple, make them visible again and they will be automtically pre-set with the homebranch of the cataloger. Hope this helps, Katrin On 30.10.23 17:05, Paulo Neto wrote:
Hello,
I am able to solve the problem (thanks to Kaitrin) but i am not able to prevent it, how can i prevent "holding branch" getting null values at item table, i think this is happing to every new items created in the koha database. I am not a librarian myself, does this have to do how our librarian coleagues are creating the items, am i missing any configuration set up parameter?
+----------------+---------+---------------+------------+ | itemcallnumber | barcode | holdingbranch | homebranch | +----------------+---------+---------------+------------+ | 9349/M | 9349/M | NULL | BACOSTA | | 23623/M | 23623/M | NULL | BACOSTA | | 23624/M | 23624/M | NULL | BACOSTA | | 23625/M | 23625/M | NULL | BACOSTA | | 23626/M | 23626/M | NULL | BACOSTA | | 23627/M | 23627/M | NULL | BACOSTA | | 23628/M | 23628/M | NULL | BACOSTA | | 23629/M | 23629/M | NULL | BACOSTA | | 23630/M | 23630/M | NULL | BACOSTA | | 23631/M | 23631/M | NULL | BACOSTA | +----------------+---------+---------------+------------+
Best regards,
Paulo Neto DSIGA / DPGI Tel. (+351) 21 844 2228 http://www.dgadr.gov.pt
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Paulo, your Koha won't function correctly if you are missing homebranch, holdingbranch or itemtype in your items. If you removed the MARC reference, you should restore it. For MARC21 the default mappings are: 952$a homebranch 952$b holdingbranch 952 $y itype If you are using UNIMARC, you'll need to check a standard Koha for the correct defaults. Hope this helps, Katrin On 02.11.23 17:45, Paulo Neto wrote:
Hello Katrin,
Thank you for your answer. We dont have any marc reference for the holding branch defined on the bibliographic model as far as i have checked so in terms of the database this makes sense for the null value Showing up, wehave a record for the home branch but we wont have a record for the holding branch.
Paulo Neto DSIGA / DPGI Tel. (+351) 21 844 2228 http://www.dgadr.gov.pt
-----Mensagem original----- De: Koha <koha-bounces@lists.katipo.co.nz> Em Nome De Katrin Fischer Enviada: 30 de outubro de 2023 16:53 Para: koha@lists.katipo.co.nz Assunto: Re: [Koha] null values
Hi Paulo,
please check if you have hidden the homebranch (952$a) and holdingbranch (952$b) in your frameworks. If you have only one branch, you can use a default value, if you have multiple, make them visible again and they will be automtically pre-set with the homebranch of the cataloger.
Hope this helps,
Katrin
On 30.10.23 17:05, Paulo Neto wrote:
Hello,
I am able to solve the problem (thanks to Kaitrin) but i am not able to prevent it, how can i prevent "holding branch" getting null values at item table, i think this is happing to every new items created in the koha database. I am not a librarian myself, does this have to do how our librarian coleagues are creating the items, am i missing any configuration set up parameter?
+----------------+---------+---------------+------------+ | itemcallnumber | barcode | holdingbranch | homebranch | +----------------+---------+---------------+------------+ | 9349/M | 9349/M | NULL | BACOSTA | | 23623/M | 23623/M | NULL | BACOSTA | | 23624/M | 23624/M | NULL | BACOSTA | | 23625/M | 23625/M | NULL | BACOSTA | | 23626/M | 23626/M | NULL | BACOSTA | | 23627/M | 23627/M | NULL | BACOSTA | | 23628/M | 23628/M | NULL | BACOSTA | | 23629/M | 23629/M | NULL | BACOSTA | | 23630/M | 23630/M | NULL | BACOSTA | | 23631/M | 23631/M | NULL | BACOSTA | +----------------+---------+---------------+------------+
Best regards,
Paulo Neto DSIGA / DPGI Tel. (+351) 21 844 2228 http://www.dgadr.gov.pt
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Katrin, There was a missing marc reference -> koha database we are not using MArc we are using Unimarc it was the 995$c it was not linked to items.holdingbranch the others that you mentioned were ok (itemtype & homebranch) Thank you for your precious help. Best regards, Paulo Neto DSIGA / DPGI Tel. (+351) 21 844 2228 http://www.dgadr.gov.pt -----Mensagem original----- De: Koha <koha-bounces@lists.katipo.co.nz> Em Nome De Katrin Fischer Enviada: 2 de novembro de 2023 17:50 Para: koha@lists.katipo.co.nz Assunto: Re: [Koha] null values Hi Paulo, your Koha won't function correctly if you are missing homebranch, holdingbranch or itemtype in your items. If you removed the MARC reference, you should restore it. For MARC21 the default mappings are: 952$a homebranch 952$b holdingbranch 952 $y itype If you are using UNIMARC, you'll need to check a standard Koha for the correct defaults. Hope this helps, Katrin On 02.11.23 17:45, Paulo Neto wrote:
Hello Katrin,
Thank you for your answer. We dont have any marc reference for the holding branch defined on the bibliographic model as far as i have checked so in terms of the database this makes sense for the null value Showing up, wehave a record for the home branch but we wont have a record for the holding branch.
Paulo Neto DSIGA / DPGI Tel. (+351) 21 844 2228 http://www.dgadr.gov.pt
-----Mensagem original----- De: Koha <koha-bounces@lists.katipo.co.nz> Em Nome De Katrin Fischer Enviada: 30 de outubro de 2023 16:53 Para: koha@lists.katipo.co.nz Assunto: Re: [Koha] null values
Hi Paulo,
please check if you have hidden the homebranch (952$a) and holdingbranch (952$b) in your frameworks. If you have only one branch, you can use a default value, if you have multiple, make them visible again and they will be automtically pre-set with the homebranch of the cataloger.
Hope this helps,
Katrin
On 30.10.23 17:05, Paulo Neto wrote:
Hello,
I am able to solve the problem (thanks to Kaitrin) but i am not able to prevent it, how can i prevent "holding branch" getting null values at item table, i think this is happing to every new items created in the koha database. I am not a librarian myself, does this have to do how our librarian coleagues are creating the items, am i missing any configuration set up parameter?
+----------------+---------+---------------+------------+ | itemcallnumber | barcode | holdingbranch | homebranch | +----------------+---------+---------------+------------+ | 9349/M | 9349/M | NULL | BACOSTA | | 23623/M | 23623/M | NULL | BACOSTA | | 23624/M | 23624/M | NULL | BACOSTA | | 23625/M | 23625/M | NULL | BACOSTA | | 23626/M | 23626/M | NULL | BACOSTA | | 23627/M | 23627/M | NULL | BACOSTA | | 23628/M | 23628/M | NULL | BACOSTA | | 23629/M | 23629/M | NULL | BACOSTA | | 23630/M | 23630/M | NULL | BACOSTA | | 23631/M | 23631/M | NULL | BACOSTA | +----------------+---------+---------------+------------+
Best regards,
Paulo Neto DSIGA / DPGI Tel. (+351) 21 844 2228 http://www.dgadr.gov.pt
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Katrin Fischer -
Paulo Neto