[Koha] How to clean Koha imported records?

[Jerwyn Fernandez]

Hi Layale,

Yes all records has itemnumber you may use that.

Regards,

- Jerwyn


On Sat, Apr 5, 2014 at 1:02 PM, Layale Bassil <lb26 at 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_fernandez at 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 <lb26 at 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: lb26 at 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.Fischer at bsz-bw.de]
>> Sent: Friday, April 04, 2014 4:18 PM
>> To: Layale Bassil; koha at 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-bounces at lists.katipo.co.nz] On Behalf Of
>> > Layale Bassil
>> > Sent: Friday, April 04, 2014 2:45 PM
>> > To: koha at 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 at lists.katipo.co.nz
>> > http://lists.katipo.co.nz/mailman/listinfo/koha
>> >
>>
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at 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