This is why I suggested modifying the touch_all_items script. It uses the C4::Items::ModItem subroutine which changes the database and the marc records stored in the biblioitems table. Editing these directly is difficult at best, and nearly impossible in my opinion. Along with modifying a copy of touch_all_items for your item type conversion, you could also add code to strip the alpha characters from the end of the barcode. Do all the work in one go. You'll have to change the SQL in that script, but you will have to do that anyway to update the item type. On Thu, Apr 7, 2011 at 10:09 AM, Charl <charl@prograbiz.com> wrote:

Thank you Mike

This should help me sort out this issue.

Another issue that I am trying to sort out: Alpha characters appear after the barcode in both the marc and item record.

How should I go about removing those alpha characters as a batch procedure? The item record is not a problem, but I am not sure how to edit the barcode in the marc record (biblioitems).

Thanks again for your help.

----- Original Message -----

*From:* Mike Hafen <mdhafen@tech.washk12.org> *To:* Charl <charl@prograbiz.com> *Cc:* koha-devel@lists.koha-community.org *Sent:* Thursday, April 07, 2011 5:50 PM *Subject:* Re: [Koha-devel] Technical question

The Item Type in Koha 3 has been moved to the items table, with the Item Type in the biblioitems table being a default for new items.

It wouldn't be difficult to make a command line script to copy the Item Type from the biblioitems table to the items table, that may be the best way to go in this case. It looks like maintenance/touch_all_items.pl would be a good place to start on such a script.

2011/4/6 Charl <charl@prograbiz.com>

...

Good day

I need advice please. I have converted a Koha installation from 2 to Koha 3. Now there is a "syncronization" problem between the items table and the marc record in bibioitems.

To make a long story short, the itemtype appears in the marc record, but not in the items table. Is there a procedure how to syncronize those 2 "fields"?

Thanks for any advice!

_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/

------------------------------

No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.449 / Virus Database: 271.1.1/3557 - Release Date: 04/07/11 10:01:00