[Koha] SQL report for duplicate items

[Nicole Engard]

You might want to list your report request here:
http://wiki.koha.org/doku.php?id=sql_library  And when you get an
answer make sure you share it with all of us on that page :)

---

Nicole C. Engard
Open Source Evangelist, LibLime
(888) Koha ILS (564-2457) ext. 714
nce at liblime.com
AIM/Y!/Skype: nengard

http://liblime.com
http://blogs.liblime.com/open-sesame/



2009/7/23 Banks, Joy M <jbanks at flsouthern.edu>:
> Hi everyone-
>
>
>
> We’re a hosted Koha library using whatever the most recent release of the
> product is. I’ve been asked if I can generate a report through Koha that
> would tell us all the duplicate items in the collection. Try as I might, I
> can’t seem to figure out a simple way of doing this without pulling a report
> of every single item, sorting by call number, and sifting through the tens
> of thousands of items. Has anyone generated a report like this? It wouldn’t
> be enough to pull titles that have more than one record because then we’ll
> get multi-volume sets too. And there isn’t a single identifying entry in the
> call number (e.g. pt. or c.) because there hasn’t been any consistency with
> our tracking of duplicate items. If anyone has ideas, please let me know.
> I’ll only be able to copy/paste generated SQL into the Report Wizard. We
> have no access to the backend of the system.
>
>
>
> Thank you!
>
>
>
> ~Joy
>
>
>
> Joy M. Banks
>
> Catalog Librarian
>
> Roux Library
>
> Florida Southern College
>
> 111 Lake Hollingsworth Dr.
>
> Lakeland, FL 33801
>
> (863)680-4736
>
> jbanks at flsouthern.edu
>
>
>
>
>
> _______________________________________________
> Koha mailing list
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>