Hi Layale, Yes all records has itemnumber you may use that.
Regards, - Jerwyn On Sat, Apr 5, 2014 at 1:02 PM, Layale Bassil <l...@aub.edu.lb> wrote: > Hello Jerwyn, > > Thanks a lot for your help! In fact we are importing data from many > sources which are not consistent, so not all items have barcodes... Do you > suggest that I use the itemnumber? Will all items have an itemnumber when > imported? Is it generated by Koha? > > On another hand, I read in the wiki that I need to truncate the following > tables: > > > - bibio > - biblioitems > - items > - auth_header > - sessions > - zebraqueue > > > What do you suggest? > > Many Thanks, > Regards. > > On Apr 5, 2014, at 2:46 AM, "Jerwyn Fernandez" < > jerwyn_fernan...@southville.edu.ph> wrote: > > 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> 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 | M: +961 (03) 929876 >> E: 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] >> Sent: Friday, April 04, 2014 4:18 PM >> To: Layale Bassil; 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] On Behalf Of >> > Layale Bassil >> > Sent: Friday, April 04, 2014 2:45 PM >> > To: 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 >> > http://lists.katipo.co.nz/mailman/listinfo/koha >> > >> >> _______________________________________________ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > > > -- > Jerwyn G. Fernadez > Basic Education Librarian > Southville International School and Colleges > > -- 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