Mass updating a field
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?"
UPDATE items i, temptable t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber James Winter 215.517.2588 From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Roche III, Edward Sent: Friday, March 06, 2009 1:24 PM To: koha@lists.katipo.co.nz Subject: [Koha] Mass updating a field 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?"
I get this error: Output from SQL command UPDATE items i, temp t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber .. No data returned Just about everything I tried so far gives me this error. 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?" From: Winter, James [mailto:WinterJ@arcadia.edu] Sent: Friday, March 06, 2009 1:26 PM To: Roche III, Edward; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field UPDATE items i, temptable t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber James Winter 215.517.2588 From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Roche III, Edward Sent: Friday, March 06, 2009 1:24 PM To: koha@lists.katipo.co.nz Subject: [Koha] Mass updating a field 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?"
How are you connecting to MySQL? Through ODBC or through the MySQL administrator, or running commands directly in the command line? James Winter 215.517.2588 From: Roche III, Edward [mailto:edward_roche@solanco.k12.pa.us] Sent: Friday, March 06, 2009 1:32 PM To: Winter, James; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field I get this error: Output from SQL command UPDATE items i, temp t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber .. No data returned Just about everything I tried so far gives me this error. 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?" From: Winter, James [mailto:WinterJ@arcadia.edu] Sent: Friday, March 06, 2009 1:26 PM To: Roche III, Edward; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field UPDATE items i, temptable t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber James Winter 215.517.2588 From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Roche III, Edward Sent: Friday, March 06, 2009 1:24 PM To: koha@lists.katipo.co.nz Subject: [Koha] Mass updating a field 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?"
Through the webmin. It is a web based mysql admin. 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?" From: Winter, James [mailto:WinterJ@arcadia.edu] Sent: Friday, March 06, 2009 1:37 PM To: Roche III, Edward; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field How are you connecting to MySQL? Through ODBC or through the MySQL administrator, or running commands directly in the command line? James Winter 215.517.2588 From: Roche III, Edward [mailto:edward_roche@solanco.k12.pa.us] Sent: Friday, March 06, 2009 1:32 PM To: Winter, James; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field I get this error: Output from SQL command UPDATE items i, temp t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber .. No data returned Just about everything I tried so far gives me this error. 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?" From: Winter, James [mailto:WinterJ@arcadia.edu] Sent: Friday, March 06, 2009 1:26 PM To: Roche III, Edward; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field UPDATE items i, temptable t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber James Winter 215.517.2588 From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Roche III, Edward Sent: Friday, March 06, 2009 1:24 PM To: koha@lists.katipo.co.nz Subject: [Koha] Mass updating a field 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?"
This is funny. I tried everything to updates this field. I tried the import file and sql statements. It didn't update then I go back about 15 minutes later and the field is updated. The time I didn't get an error was when I did the import but after I ran the import the field wasn't changed. Would the import continues to run even if I navigated away from that page? 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?" From: Winter, James [mailto:WinterJ@arcadia.edu] Sent: Friday, March 06, 2009 1:37 PM To: Roche III, Edward; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field How are you connecting to MySQL? Through ODBC or through the MySQL administrator, or running commands directly in the command line? James Winter 215.517.2588 From: Roche III, Edward [mailto:edward_roche@solanco.k12.pa.us] Sent: Friday, March 06, 2009 1:32 PM To: Winter, James; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field I get this error: Output from SQL command UPDATE items i, temp t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber .. No data returned Just about everything I tried so far gives me this error. 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?" From: Winter, James [mailto:WinterJ@arcadia.edu] Sent: Friday, March 06, 2009 1:26 PM To: Roche III, Edward; koha@lists.katipo.co.nz Subject: RE: [Koha] Mass updating a field UPDATE items i, temptable t SET i.barcode = t.barcode WHERE i.itemnumber = t.itemnumber James Winter 215.517.2588 From: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Roche III, Edward Sent: Friday, March 06, 2009 1:24 PM To: koha@lists.katipo.co.nz Subject: [Koha] Mass updating a field 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?"
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@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@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (3)
-
Joe Atzberger -
Roche III, Edward -
Winter, James