Home Branch/Holding Branch Problem 3.0.6
Hello; I have upgraded to 3.0.6 am having issues with many of my items do not have the holding branch or home branch, which shows items unavailable in the OPAC but still can check them out in the admin. (This may have been a carry over from an earlier upgrade because I am finding and solving issues with my zebra record.abs and MARC framework.) I examined the items table and found these fields empty. Populated the fields with SQL commands to match working records, re-indexed and still nothing. The only why I have found is to go to each record, click Edit, edit items, edit the item - fill in the info (most times it is there) and hit save. After the cron job re-index they show up fine in the OPAC. There are a lot of records involved - is there a batch way to accomplish the same thing? In the items table, homebranch and holdingbranch are already populated like the other working items. Thank you. -- Paul Davis
2010/9/3 Paul Davis <ped811@gmail.com>:
Hello; I have upgraded to 3.0.6 am having issues with many of my items do not have the holding branch or home branch, which shows items unavailable in the OPAC but still can check them out in the admin. (This may have been a carry over from an earlier upgrade because I am finding and solving issues with my zebra record.abs and MARC framework.) I examined the items table and found these fields empty. Populated the fields with SQL commands to match working records, re-indexed and still nothing. The only why I have found is to go to each record, click Edit, edit items, edit the item - fill in the info (most times it is there) and hit save. After the cron job re-index they show up fine in the OPAC.
There are a lot of records involved - is there a batch way to accomplish the same thing? In the items table, homebranch and holdingbranch are already populated like the other working items.
Hi Paul Yes you can run the script misc/maintenance/sync_items_in_marc_bib.pl from the commandline Chris
Thanks for the quick response. I should have mentioned I did that and it gets to record 1500 and throws a NULL error - I don't have it in front of me - but like oversized on NULL operation. I'm thinking I have a bad entry in a NULL field. Anyway to locate it without eyeballing a few hundred records? Thanks Paul Davis On Thu, Sep 2, 2010 at 2:00 PM, Chris Cormack <chris@bigballofwax.co.nz>wrote:
Hello; I have upgraded to 3.0.6 am having issues with many of my items do not have the holding branch or home branch, which shows items unavailable in the OPAC but still can check them out in the admin. (This may have been a carry over from an earlier upgrade because I am finding and solving issues with my zebra record.abs and MARC framework.) I examined the items table and found these fields empty. Populated the fields with SQL commands to match working records, re-indexed and still nothing. The only why I have found is to go to each record, click Edit, edit items, edit the item - fill in the info (most times it is there) and hit save. After the cron job re-index they show up fine in the OPAC.
There are a lot of records involved - is there a batch way to accomplish
2010/9/3 Paul Davis <ped811@gmail.com>: the
same thing? In the items table, homebranch and holdingbranch are already populated like the other working items.
Hi Paul
Yes you can run the script misc/maintenance/sync_items_in_marc_bib.pl from the commandline
Chris
-- Paul
Here is the error: Wide character in null operation at /usr/local/share/perl/5.10.0/MARC/Charset/Table.pm line 96. This is after 1500 records processed. Is there a force or skip so I can get past the bad record? Thanks again! Paul Davis On Thu, Sep 2, 2010 at 2:12 PM, Paul Davis <ped811@gmail.com> wrote:
Thanks for the quick response.
I should have mentioned I did that and it gets to record 1500 and throws a NULL error - I don't have it in front of me - but like oversized on NULL operation. I'm thinking I have a bad entry in a NULL field. Anyway to locate it without eyeballing a few hundred records?
Thanks
Paul Davis
On Thu, Sep 2, 2010 at 2:00 PM, Chris Cormack <chris@bigballofwax.co.nz>wrote:
Hello; I have upgraded to 3.0.6 am having issues with many of my items do not have the holding branch or home branch, which shows items unavailable in the OPAC but still can check them out in the admin. (This may have been a carry over from an earlier upgrade because I am finding and solving issues with my zebra record.abs and MARC framework.) I examined the items table and found these fields empty. Populated the fields with SQL commands to match working records, re-indexed and still nothing. The only why I have found is to go to each record, click Edit, edit items, edit the item - fill in the info (most times it is there) and hit save. After the cron job re-index they show up fine in the OPAC.
There are a lot of records involved - is there a batch way to accomplish
2010/9/3 Paul Davis <ped811@gmail.com>: the
same thing? In the items table, homebranch and holdingbranch are already populated like the other working items.
Hi Paul
Yes you can run the script misc/maintenance/sync_items_in_marc_bib.pl from the commandline
Chris
-- Paul
-- Paul
I am running the perl script in debug mode and when it kicks out it gives me enough info to search for the offending records. Had a few records that imported with strange letters that utf-8 obviously didn't care for - an L with a diagonal slash and a nice "A" with extra markings. Sorry for my ignorance of world languages but after cleaning those out of the records the sync_items... script is now running through! Oops, just hit one after record 8000, back to debug... Paul Davis On Thu, Sep 2, 2010 at 2:00 PM, Chris Cormack <chris@bigballofwax.co.nz>wrote:
Hello; I have upgraded to 3.0.6 am having issues with many of my items do not have the holding branch or home branch, which shows items unavailable in the OPAC but still can check them out in the admin. (This may have been a carry over from an earlier upgrade because I am finding and solving issues with my zebra record.abs and MARC framework.) I examined the items table and found these fields empty. Populated the fields with SQL commands to match working records, re-indexed and still nothing. The only why I have found is to go to each record, click Edit, edit items, edit the item - fill in the info (most times it is there) and hit save. After the cron job re-index they show up fine in the OPAC.
There are a lot of records involved - is there a batch way to accomplish
2010/9/3 Paul Davis <ped811@gmail.com>: the
same thing? In the items table, homebranch and holdingbranch are already populated like the other working items.
Hi Paul
Yes you can run the script misc/maintenance/sync_items_in_marc_bib.pl from the commandline
Chris
-- Paul
participants (2)
-
Chris Cormack -
Paul Davis