[Koha] Mass updating a field

[Joe Atzberger]

You should also investigate the T-prefix option in systempreference
"itemBarcodeInputFilter".

Basically, Follett had intentional divergence between the data represented
in the database as the barcode and the printed form.  A tranformation was
used to make one match the other when scanned.  This is a serious pain for
migration purposes.

--Joe

On Fri, Mar 6, 2009 at 1:23 PM, Roche III, Edward <
edward_roche at solanco.k12.pa.us> wrote:

>  Good Afternoon All
>
> I am in need of a SQL statement to update my barcode field in the items
> table. When we exported our catalog from Follett it removed a space that was
> in out barcodes so now when we try to scan an item it is not being found
> because the barcode field in Koha is missing the space. What I have done so
> far:
>
> 1)      Export from the items table: itemnumber and barcode
>
> 2)      Added the space back into the barcode field
>
> 3)      Created a temp table in the koha db
>
> 4)      Imported the data into the temp table
>
>
>
> I now need to move the data from the temp table over to the items table to
> update the barcode field.
>
>
>
> Any thoughts?
>
>
>
> Thanks
>
> Ed
>
>
>
> Edward J. Roche
>
> Network Administrator
>
> Solanco School District
>
> 717.786.2151 x2437
>
>
>
>
>
> "At the End of the Day, Did You Play to Win or Not to Lose?"
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20090306/ec8add13/attachment.htm