[Koha-devel] itemBarcodeInputFilter or Client side JS?

[Tomas Cohen Arazi]

2010/11/2 Mike Hafen <mdhafen at tech.washk12.org>:
> Why can't you correct the barcodes during the migration?
>
> If you are going from MS-SQL to MySQL you should be able to add another step
> in the middle to populate the barcode from the available information in the
> database.
>
> If you are going from MARC into Koha you should be able to populate the
> barcode once the data is in Koha and update the MARC and Zebra from there.
>
> Is it not possible to do one of these two?

I think they are asking for the proper way of modifying the script
that generates barcodes in koha for NEW items, preserving the
semantics of the current system they're using.

To+



> On Tue, Nov 2, 2010 at 7:31 AM, Koustubha Kale <kmkale at anantcorp.com> wrote:
>>
>> Hi All,
>> We are implementing Koha at a college. They have a existing software
>> for library. They have barcoded all their collection of about 150000
>> books with this software.
>> The peculiar thing about the software and the barcode it generates is this
>> :
>>
>> The barcode related data stored in the database of the software
>> backend ( MS SQL) is the item's accession number & item type. The
>> actual barcode is not stored anywhere.
>> The printed barcodes are like this B011364, B011436, AR011346,
>> AR011436,AR018100,AR018103,AR018104,AR018105. ( Note the duplicate
>> accession numbers)
>> The first alphabets correspond to the itemtype code stored in a table.
>> The remaining numbers are the accession number stored in a table
>> without the leading zeros. This causes a problem while migrating this
>> data to Koha due to the missing leading zeros and arbitrary length of
>> the string and the fact that accession numbers are same for different
>> item types.
>> While generating a barcode for a new item the software takes the
>> itemtype and the accession number and prints out a barcode label in
>> the required format.
>> When the barcode is read back in the softwares circulation module by a
>> barcode reader, a asp script on the server separates the item type and
>> the accession number, strips the leading zeros from the numeric part
>> and does a search on the database by means of a join on the two
>> tables.
>>
>> As the college has stuck these barcode labels on all items, we have to
>> figure out how to emulate this functionality in Koha. (Post migration
>> we will generate & print barcodes from Koha; so we dont have to
>> emulate this logic in the barcode generation for Koha). I was thinking
>> we could store the barcode in Koha as itemtype-accession_number  (
>> without the leading zeros e.g. AR-18100) retrieved from the old
>> softwares database and when reading it in circulation in Koha we
>> convert the barcode from for example AR018100 to AR-18100.
>>
>> I see two options to acchieve this..
>> options :
>> 1) Create another filter for itemBarcodeInputFilter and modify the sub
>> barcodedecode  in C4/Circulation.pm
>> 2) write a client side javascript to do it.
>>
>> I would like to know is
>> 1) What is the better way to acchive this?
>> 2) Is there way for us to avoid a patch to Koha which will probably be
>> useless to anybody not migrating from this particular software. By
>> using opacuserjs perhaps..
>>
>>
>> Regards,
>> Koustubha Kale
>> Anant Corporation
>>
>> Contact Details :
>> Address  : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes
>> Naka, Thane (w),
>>                 Maharashtra, India, Pin : 400601.
>> TeleFax  : +91-22-21720108, +91-22-21720109
>> Mobile     : +919820715876
>> Website  : http://www.anantcorp.com
>> Blog : http://www.anantcorp.com/blog/?author=2
>> _______________________________________________
>> Koha-devel mailing list
>> Koha-devel at 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/
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at 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/
>