items table has more records than in biblio table and biblioitems tables !!
After doing an import, the items table in koha is having 7 more records than in biblio and biblioitems tables. How does this happen? How to fix this? -With Thanks & Regards Tanzeem M.B
biblio and biblioitems table have a 1-1 relation as they both hold bibliographic records descriptions. The items table contains holdings information, which tends to differ from bíblios because: - some bibliographic records don't have items (analytics, electronic resources, etc) - some bibliographic records have more than one holdings So it is no surprise that they don't match, it is the most likely situation. El mar., 24 de ene. de 2017 5:57 AM, Tanzeem M.B <tanzeem.mb@gmail.com> escribió:
After doing an import, the items table in koha is having 7 more records than in biblio and biblioitems tables.
How does this happen? How to fix this?
-With Thanks & Regards
Tanzeem M.B _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F
On Jan 24, 2017 3:52 PM, "Tomas Cohen Arazi" <tomascohen@gmail.com> wrote: <snipped>
So it is no surprise that they don't match, it is the most likely situation.
What Tomas said! As long as you don't have a biblionumber in your items table that is not present in your biblio and biblioitems tables, you don't have a problem per se. cheers, -idg
El mar., 24 de ene. de 2017 5:57 AM, Tanzeem M.B <tanzeem.mb@gmail.com> escribió:
After doing an import, the items table in koha is having 7 more records than in biblio and biblioitems tables.
How does this happen? How to fix this?
-With Thanks & Regards
Tanzeem M.B _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ✆ +54 9351 3513384 GPG: B2F3C15F _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Good day, How do you do to know all your catalogs items? Thanks for help Rosalie Ndejuru ________________________________ De : Koha <koha-bounces@lists.katipo.co.nz> de la part de Indranil Das Gupta <indradg@gmail.com> Envoyé : 24 janvier 2017 05:27 À : Tomas Cohen Arazi Cc : koha; tanzeem Objet : Re: [Koha] items table has more records than in biblio table and biblioitems tables !! On Jan 24, 2017 3:52 PM, "Tomas Cohen Arazi" <tomascohen@gmail.com> wrote: <snipped>
So it is no surprise that they don't match, it is the most likely situation.
What Tomas said! As long as you don't have a biblionumber in your items table that is not present in your biblio and biblioitems tables, you don't have a problem per se. cheers, -idg
El mar., 24 de ene. de 2017 5:57 AM, Tanzeem M.B <tanzeem.mb@gmail.com> escribió:
After doing an import, the items table in koha is having 7 more records than in biblio and biblioitems tables.
How does this happen? How to fix this?
-With Thanks & Regards
Tanzeem M.B _______________________________________________ Koha mailing list http://koha-community.org Official Website of Koha Library Software<http://koha-community.org/> koha-community.org Koha Library Software The world's first free and open source library system Koha is a fully featured, scalable library management system. Development is sponsored by ...
Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha Koha --Discussion list for the Koha Library system<https://lists.katipo.co.nz/mailman/listinfo/koha> lists.katipo.co.nz To see the collection of prior postings to the list, visit the Koha Archives. Using the Koha Mailing List: To post a message to all the list ...
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ? +54 9351 3513384 GPG: B2F3C15F _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Hi Rosalie Ndejuru, Go to report module and click on "*catalog by item type" *under Other to run the report for all your catalogued items. On Fri, Jan 27, 2017 at 2:51 PM, Rosalie Ndejuru <lapleni@hotmail.com> wrote:
Good day,
How do you do to know all your catalogs items? Thanks for help
Rosalie Ndejuru
________________________________ De : Koha <koha-bounces@lists.katipo.co.nz> de la part de Indranil Das Gupta <indradg@gmail.com> Envoyé : 24 janvier 2017 05:27 À : Tomas Cohen Arazi Cc : koha; tanzeem Objet : Re: [Koha] items table has more records than in biblio table and biblioitems tables !!
On Jan 24, 2017 3:52 PM, "Tomas Cohen Arazi" <tomascohen@gmail.com> wrote: <snipped>
So it is no surprise that they don't match, it is the most likely situation.
What Tomas said! As long as you don't have a biblionumber in your items table that is not present in your biblio and biblioitems tables, you don't have a problem per se.
cheers, -idg
El mar., 24 de ene. de 2017 5:57 AM, Tanzeem M.B <tanzeem.mb@gmail.com> escribió:
After doing an import, the items table in koha is having 7 more records than in biblio and biblioitems tables.
How does this happen? How to fix this?
-With Thanks & Regards
Tanzeem M.B _______________________________________________ Koha mailing list http://koha-community.org Official Website of Koha Library Software<http://koha-community.org/> koha-community.org Koha Library Software The world's first free and open source library system Koha is a fully featured, scalable library management system. Development is sponsored by ...
Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha Koha --Discussion list for the Koha Library system<https://lists.katipo. co.nz/mailman/listinfo/koha> lists.katipo.co.nz To see the collection of prior postings to the list, visit the Koha Archives. Using the Koha Mailing List: To post a message to all the list ...
-- Tomás Cohen Arazi Theke Solutions (https://theke.io <http://theke.io/>) ? +54 9351 3513384 GPG: B2F3C15F _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Adetomiwa Basiru (CLN), FORCE 2016 FELLOW Librarian I Redeemer's University (RUN), P. M. B. 230, Ede Osun State. Nigeria. Mobile: +234-8067098922, +234-7052367200 http://goo.gl/Vd9p3 http://www.bignigeria.com/ -- <https://run.edu.ng/christmas.html> FOLLOW US ON : <https://www.facebook.com/redeemersuniversity> <https://www.twitter.com/runversity> <http://www.youtube.com/runversity>
participants (5)
-
BASIRU ADETOMIWA -
Indranil Das Gupta -
Rosalie Ndejuru -
Tanzeem M.B -
Tomas Cohen Arazi