I liked your idea, it made sense. I found the only difference in items was cn_source and itype. However, changing these does not solve my problem. Alas. I tried and failed. But it hasn't all been in vain. Playing around I noticed that the Edit Items radio button (from the Details page) returns this url; http://debian:8080/cgi-bin/koha/cataloguing/additem.pl?biblionumber=4796 (I cannot really do anything on this page, except deleting the item) and the route through the barcode from the Details page brings me to Item Details to edit Items (the one under the barcode, not the radio button) returns this url; http://debian:8080/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=4796&itemnumber=4796 But on this page I have an "Edit item #4796" I still cannot do anything with the existing item, except delete it, but all the needed fields are present below it, and clicking on save changes will work. Also still wondering; where does it get the itype information? I am not yet pulling my hair out, but it's not far away... So close, but yet so far, sigh Thanks for all your help, Marty --- On Thu, 3/11/10, Owen Leonard <oleonard@myacpl.org> wrote: From: Owen Leonard <oleonard@myacpl.org> Subject: Re: [Koha] no item type and Not Renewable To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Thursday, March 11, 2010, 8:22 AM
Now I have 2 lines with items showing at the top of the page. I can delete the first one (which is wrong anyway), and after doing a rebuild_zebra -b -w it all shows up fine and working.
So the item which *doesn't* work is one which you imported into Koha? If the duplicate created by Koha works (can be placed on hold) then it sounds like there must be some difference between the two which you could discern. I would query the items table for the data on the original and the duplicate and see how they differ. You might be able to do a bulk update on the existing items without doing your duplication process. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org __________________________________________________________________ Yahoo! Canada Toolbar: Search from anywhere on the web, and bookmark your favourite sites. Download it now http://ca.toolbar.yahoo.com.
Still searching, but it seems that the marcxml field in biblioitems is incomplete for the items that do not work, I seem to be missing some subfields, and some subfields that are filled in wrong match the wrong items showing up on the edit item page. Now I have to find a way to change these --- On Thu, 3/11/10, Marty <ontariowolf64@yahoo.com> wrote: From: Marty <ontariowolf64@yahoo.com> Subject: Re: [Koha] no item type and Not Renewable To: "Owen Leonard" <oleonard@myacpl.org> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Thursday, March 11, 2010, 4:54 PM I liked your idea, it made sense. I found the only difference in items was cn_source and itype. However, changing these does not solve my problem. Alas. I tried and failed. But it hasn't all been in vain. Playing around I noticed that the Edit Items radio button (from the Details page) returns this url; http://debian:8080/cgi-bin/koha/cataloguing/additem.pl?biblionumber=4796 (I cannot really do anything on this page, except deleting the item) and the route through the barcode from the Details page brings me to Item Details to edit Items (the one under the barcode, not the radio button) returns this url; http://debian:8080/cgi-bin/koha/cataloguing/additem.pl?op=edititem&biblionumber=4796&itemnumber=4796 But on this page I have an "Edit item #4796" I still cannot do anything with the existing item, except delete it, but all the needed fields are present below it, and clicking on save changes will work. Also still wondering; where does it get the itype information? I am not yet pulling my hair out, but it's not far away... So close, but yet so far, sigh Thanks for all your help, Marty --- On Thu, 3/11/10, Owen Leonard <oleonard@myacpl.org> wrote: From: Owen Leonard <oleonard@myacpl.org> Subject: Re: [Koha] no item type and Not Renewable To: "Marty" <ontariowolf64@yahoo.com> Cc: "koha koha" <koha@lists.katipo.co.nz> Received: Thursday, March 11, 2010, 8:22 AM
Now I have 2 lines with items showing at the top of the page. I can delete the first one (which is wrong anyway), and after doing a rebuild_zebra -b -w it all shows up fine and working.
So the item which *doesn't* work is one which you imported into Koha? If the duplicate created by Koha works (can be placed on hold) then it sounds like there must be some difference between the two which you could discern. I would query the items table for the data on the original and the duplicate and see how they differ. You might be able to do a bulk update on the existing items without doing your duplication process. -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail -----Inline Attachment Follows----- _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha __________________________________________________________________ Looking for the perfect gift? Give the gift of Flickr! http://www.flickr.com/gift/
Still searching, but it seems that the marcxml field in biblioitems is incomplete for the items that do not work
Is this a job for misc/maintenance/sync_items_in_marc_bib.pl ? "./sync_items_in_marc_bib.pl: synchronize item data embedded in MARC bibs Replaces the item data embedded in the MARC bib records (for indexing) with the authoritative item data as stored in the items table. If Zebra is used, run rebuild_zebra.pl -b -r after running this script." -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org
Hi, On Mar 17, 2010, at 9:09 AM, Owen Leonard wrote:
Still searching, but it seems that the marcxml field in biblioitems is incomplete for the items that do not work
Is this a job for misc/maintenance/sync_items_in_marc_bib.pl ?
"./sync_items_in_marc_bib.pl: synchronize item data embedded in MARC bibs
Replaces the item data embedded in the MARC bib records (for indexing) with the authoritative item data as stored in the items table.
If Zebra is used, run rebuild_zebra.pl -b -r after running this script."
Yes, that will likely do it. Regards, Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc@esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web: http://www.esilibrary.com/
Thanks all, I will try when I get back again next weekend and let you know whether it works. I appreciate all your help! (I am currently in Winnipeg, MB where it is cold and windy instead of Newmarket, ON where it is nice and warm...) --- On Wed, 3/17/10, Galen Charlton <gmc@esilibrary.com> wrote: From: Galen Charlton <gmc@esilibrary.com> Subject: Re: [Koha] no item type and Not Renewable To: "Owen Leonard" <oleonard@myacpl.org> Cc: "Marty" <ontariowolf64@yahoo.com>, "koha koha" <koha@lists.katipo.co.nz> Received: Wednesday, March 17, 2010, 9:13 AM Hi, On Mar 17, 2010, at 9:09 AM, Owen Leonard wrote:
Still searching, but it seems that the marcxml field in biblioitems is incomplete for the items that do not work
Is this a job for misc/maintenance/sync_items_in_marc_bib.pl ?
"./sync_items_in_marc_bib.pl: synchronize item data embedded in MARC bibs
Replaces the item data embedded in the MARC bib records (for indexing) with the authoritative item data as stored in the items table.
If Zebra is used, run rebuild_zebra.pl -b -r after running this script."
Yes, that will likely do it. Regards, Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc@esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web: http://www.esilibrary.com/ __________________________________________________________________ Connect with friends from any web browser - no download required. Try the new Yahoo! Canada Messenger for the Web BETA at http://ca.messenger.yahoo.com/webmessengerpromo.php
Excellent, finally, after many trials and errors. I have a working version of Koha WITH Zebra. running sync_items_in_marc_bib.pl did work, I only had to do some mysql magic to get my itype in items. but it finally works as supposed to. Thanks! --- On Wed, 3/17/10, Galen Charlton <gmc@esilibrary.com> wrote: From: Galen Charlton <gmc@esilibrary.com> Subject: Re: [Koha] no item type and Not Renewable To: "Owen Leonard" <oleonard@myacpl.org> Cc: "Marty" <ontariowolf64@yahoo.com>, "koha koha" <koha@lists.katipo.co.nz> Received: Wednesday, March 17, 2010, 9:13 AM Hi, On Mar 17, 2010, at 9:09 AM, Owen Leonard wrote:
Still searching, but it seems that the marcxml field in biblioitems is incomplete for the items that do not work
Is this a job for misc/maintenance/sync_items_in_marc_bib.pl ?
"./sync_items_in_marc_bib.pl: synchronize item data embedded in MARC bibs
Replaces the item data embedded in the MARC bib records (for indexing) with the authoritative item data as stored in the items table.
If Zebra is used, run rebuild_zebra.pl -b -r after running this script."
Yes, that will likely do it. Regards, Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: gmc@esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web: http://www.esilibrary.com/ __________________________________________________________________ Looking for the perfect gift? Give the gift of Flickr! http://www.flickr.com/gift/
participants (3)
-
Galen Charlton -
Marty -
Owen Leonard