[Koha] How to clean Koha imported records?

Mon Apr 7 20:20:52 NZST 2014

Hello Jerwyn,

Thanks a lot for the continuous support. In fact when I ran the below SQL script after creating the report, I got 0 results. It seems the items were not imported to the items table. I modified the query, I realized that the items are in the biblio and biblioitems table but not in the items table.

SELECT  biblio.title, biblioitems.biblionumber, items.itemnumber, items.barcode FROM biblio LEFT JOIN biblioitems on (biblioitems.biblionumber=biblio.biblionumber) LEFT JOIN items on items.biblioitemnumber=biblioitems.biblioitemnumber order by biblio.biblionumber asc

This one returned all the records I imported but with itemnumber and barcode empty. They are not in the items table.

Why is that? What can I do in this case?

Maybe the only left solution is the clear the below 6 tables.

Please advise,
Regards.

From: Jerwyn Fernandez [mailto:jerwyn_fernandez at southville.edu.ph]
Sent: Sunday, April 06, 2014 8:33 AM
To: Layale Bassil
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] How to clean Koha imported records?

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<mailto: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<mailto: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<mailto: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<tel:%2B961%20%281%29%20350000%20x%203649> | M: +961 (03) 929876<tel:%2B961%20%2803%29%20929876>
E: lb26 at aub.edu.lb<mailto: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<mailto:Katrin.Fischer at bsz-bw.de>]
Sent: Friday, April 04, 2014 4:18 PM
To: Layale Bassil; koha at lists.katipo.co.nz<mailto: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<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<mailto: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<mailto: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<mailto: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