Hello again dear Jerwyn, I realized that the items were not imported into Koha. In fact I was checking the mappings under: Administration > Koha to MARC mapping, I realized that the items use the Tag = 952 while we are exporting them under Tag = 945. Do you think this is the reason? What should be done to fix this issue and be able to import the items when importing the records?
Thanks in advance, Regards. From: Jerwyn Fernandez [mailto:jerwyn_fernan...@southville.edu.ph] Sent: Saturday, April 05, 2014 2:47 AM To: Layale Bassil Cc: Fischer, Katrin; koha@lists.katipo.co.nz Subject: Re: [Koha] How to clean Koha imported records? Hi Layale, There are a lot of ways you can delete your records in KOHA, what Fischer just told you is one option. You may also delete your records manually by generating this SQL script to be run in "Create report from SQL" SELECT items.itemnumber,items.barcode,biblio.title,items.itemcallnumber FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) ORDER BY items.itemnumber asc When you were able to generate the report, go to Batch Item Deletion and paste the "barcode" of your item or from a blank sheet with the itemnumber of your record you can delete it as well. Regards, - Jerwyn On Fri, Apr 4, 2014 at 9:19 PM, Layale Bassil <l...@aub.edu.lb<mailto:l...@aub.edu.lb>> wrote: Hello Katrin, Thanks a lot for the quick response. It is very helpful for me to know how to import later on in case an error occurred during the import. Can you please tell me what are the tables that need to be cleaned? I don't want to delete the frameworks or the initial data that comes when installing koha. Many thanks, Regards. Layale Bassil Software Engineer - Business Analyst IT Solutions Delivery Department American University of Beirut Office of Information Technology P.O.Box 11-0236 Riad El-Solh, Beirut 1107 2020, Lebanon T: +961 (1) 350000 x 3649<tel:%2B961%20%281%29%20350000%20x%203649> | M: +961 (03) 929876<tel:%2B961%20%2803%29%20929876> E: l...@aub.edu.lb<mailto:l...@aub.edu.lb> W . Fb . Fl . T . Y . L . IT Think Green... Keep it on the Screen... Save a Tree... -----Original Message----- From: Fischer, Katrin [mailto:katrin.fisc...@bsz-bw.de<mailto:katrin.fisc...@bsz-bw.de>] Sent: Friday, April 04, 2014 4:18 PM To: Layale Bassil; koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> Subject: RE: [Koha] How to clean Koha imported records? Hi Layale, 'clean' has a bit different meaning here. It will clean the information about your import, but not the records from the catalog. To do that, you can go to the batch detail page and there is a button to undo the import into the catalog. But once you have cleaned the batch, that is no longer possible. Probably easiest now would be to delete the records from the database using SQL. Hope this helps, Katrin > -----Original Message----- > From: Koha > [mailto:koha-boun...@lists.katipo.co.nz<mailto:koha-boun...@lists.katipo.co.nz>] > On Behalf Of > Layale Bassil > Sent: Friday, April 04, 2014 2:45 PM > To: koha@lists.katipo.co.nz<mailto:koha@lists.katipo.co.nz> > Subject: [Koha] How to clean Koha imported records? > Importance: High > > Hello, > > I am running Koha 3.14. I imported several batches for testing > purposes, but I need to delete those records so I go to "Manage staged > MARC records" and press on "Clean". When I search the OPAC, I can > still see those records as if they were not deleted! I rebuilt zebra > as well as restarted the zebra index but still in vain. > > I need to delete all the previously imported records and start a fresh > clean catalogue. Any suggestions would be greatly appreciated. > > Regards. > _______________________________________________ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> > http://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz> http://lists.katipo.co.nz/mailman/listinfo/koha -- Jerwyn G. Fernadez Basic Education Librarian Southville International School and Colleges _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
