Re: [Koha] Name on the table Biblioitem

Hi Luis, maybe this SQL will help you to build your own query: SELECT ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code="a"]') AS f260a, ExtractValue(marcxml,'//datafield[@tag="651"]/subfield[@code="a"]') AS f651a FROM biblioitems HAVING f260a = f651a Regards, Radek Dne 06.02.17

Re: [Koha] Name on the table Biblioitem

Yes El feb 6, 2017 6:46 PM, "Joy Nelson" escribió: > Luis- > When you say "When user select the 260a fields" are you talking about > cataloging an item or searching for an item? > > joy > > > On Mon, Feb 6, 2017 at 2:14 PM, Luis Moises Rojas >

Re: [Koha] Name on the table Biblioitem

Luis- When you say "When user select the 260a fields" are you talking about cataloging an item or searching for an item? joy On Mon, Feb 6, 2017 at 2:14 PM, Luis Moises Rojas wrote: > Yes, more o less > > The 651a field is the biblioitems.place on the table > But, the

Re: [Koha] Name on the table Biblioitem

Yes, more o less The 651a field is the biblioitems.place on the table But, the 260a i can not find a fields on the table. This is 'cos we want to have this: When user select the 260a fields, that field must be 651a and have to be saved in the biblioitem,place field on the table On Mon, Feb 6,

Re: [Koha] Name on the table Biblioitem

If I'm understanding you correctly Luis, you want the value in the 651a to be found in the biblio.place field. You could adjust your Koha keyword mapping and/or frameworks to map the 651a to the biblio.place field. On Mon, Feb 6, 2017 at 2:03 PM, Luis Moises Rojas wrote:

[Koha] Name on the table Biblioitem

Hi, I want to know the name of this fields on the table. 260a I mean, if you see the fields 651a the name is place on biblioitems table. This is because we want make something like this 260a=651a So when a user select the Place of publication, have to be the geographic name. Any help? --

[Koha] Debugging Plugins

I did get ByWater Solutions kitchensink plugin to loadand run. So I must have it setup properly. I still can't get my DonorApp to load. I was missing some perl modules. They're now installed. I've set the DebugLevel to "lots of". When I do the uploadit comes back to the tools plugin page

[Koha] Name in the Database

Hi, I want to know the name of this fields on the table. 260a I mean, if you see the fields 651a the name is place on biblioitems table. Any help? -- *Luis Moisés Rojas P.* ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz

Re: [Koha] Need help in correcting migrated database

Hi Tanzeem, to migrate or correct bibliographic data into Koha you have to use MARC records - only changing the columns in the table biblio, biblioitems and items tables will not give you correct results. Koha stores the complete MARCXML record in biblioitems.marcxml so using the export and

Re: [Koha] To hide empty biblio records in OPAC

Joy is absolutely correct! My bad! I must have been half asleep when I replied... :-( -idg On Feb 6, 2017 8:12 PM, "Joy Nelson" wrote: > Lukasz- > OpacHiddenItems will not help you here. That system preference will only > work when you have items attached to the

Re: [Koha] To hide empty biblio records in OPAC

Lukasz- OpacHiddenItems will not help you here. That system preference will only work when you have items attached to the bibliographic record and the bibliographic record exists in the system (not deleted). It definitely sounds like you need to reindex your system. Once you have that done,