Hi all, I just imported a collection (from Winnebago-Spectrum) to Koha for one of my schools. I have noticed that we seem to have quite a few biblios / records that we have "no items available" for. ie: one item will show as: Availability: No items available: The (seemingly) same book will show right below it as : Availability: *Copies available:* Alma High School (1), for an example http://198.111.156.193/cgi-bin/koha/opac-search.pl?q=buddy We have the entire collection turned in for the summer, so we do not have any checked out, and we cleaned up the Winnebago-Spectrum system (as best we could) before the export. I am having our librarian look over the system now, to make sure that it looks correct. But I'm starting to wonder if there is a way to remove the records that show "No items available" ?? Is there a way to clean this up, and only display items that we have available with copies in our collection ?? thanks for any advise on this. -S
Hi, I think its data mapping issue. On 10-Jun-2015 7:09 PM, "Scott Owen" <sowen@edzone.net> wrote:
Hi all,
I just imported a collection (from Winnebago-Spectrum) to Koha for one of my schools.
I have noticed that we seem to have quite a few biblios / records that we have "no items available" for.
ie: one item will show as: Availability: No items available: The (seemingly) same book will show right below it as : Availability: *Copies available:* Alma High School (1),
for an example http://198.111.156.193/cgi-bin/koha/opac-search.pl?q=buddy
We have the entire collection turned in for the summer, so we do not have any checked out, and we cleaned up the Winnebago-Spectrum system (as best we could) before the export.
I am having our librarian look over the system now, to make sure that it looks correct.
But I'm starting to wonder if there is a way to remove the records that show "No items available" ??
Is there a way to clean this up, and only display items that we have available with copies in our collection ??
thanks for any advise on this.
-S _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Scott Owen schreef op wo 10-06-2015 om 09:36 [-0400]:
ie: one item will show as: Availability: No items available: The (seemingly) same book will show right below it as : Availability: *Copies available:* Alma High School (1),
Can you give a bit more info on how you actually did your migration? What looks like has happened is that you have somehow duplicated the biblio record/MARC record (depending on how you did it), but only one of those duplicates has an item. The simple solution would be to use a report that tells you things with no items, and delete them, however that has the potential to be risky as you might have things that legitimately have no items, and it's probably worth knowing what went wrong in the first place. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
I think I found my issue, and have a fix for it. When I imported data from another school to a second Koha server, I did things slightly different, and that import looks to be much better. I cleared the existing data from the tables (using the Heidi SQL client ), then restarted the server before I ran the migration tools rebuild_nozebra.pl script. The script ran in a couple seconds, effectively telling me there was no data, and it completed without errors. I then used the admin wen GUI to import my records, and everything looks great. No extra records etc..... On my first attempt, ( the one I have issues with) I didn't restart the server after I cleared the data, and the rebuild script didn't seem to complete as quickly and threw up some errors. I'm guessing that the restart somehow helps the MySQL instance kind of reset and do some house cleaning of it's own allowing the rebuild script to run correctly and cleanly. I'm going to try the same process on the first server tomorrow. I'm guessing everything will straighten out. The collections are rather small (8-10k) so re-importing isn't a huge issue. Thanks to everyone for the help, and I'll report how things go. -S On Wednesday, June 10, 2015, Robin Sheat <robin@catalyst.net.nz> wrote:
Scott Owen schreef op wo 10-06-2015 om 09:36 [-0400]:
ie: one item will show as: Availability: No items available: The (seemingly) same book will show right below it as : Availability: *Copies available:* Alma High School (1),
Can you give a bit more info on how you actually did your migration?
What looks like has happened is that you have somehow duplicated the biblio record/MARC record (depending on how you did it), but only one of those duplicates has an item.
The simple solution would be to use a report that tells you things with no items, and delete them, however that has the potential to be risky as you might have things that legitimately have no items, and it's probably worth knowing what went wrong in the first place.
-- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
Scott Owen schreef op wo 10-06-2015 om 20:25 [-0400]:
On my first attempt, ( the one I have issues with) I didn't restart the server after I cleared the data, and the rebuild script didn't seem to complete as quickly and threw up some errors. I'm guessing that the restart somehow helps the MySQL instance kind of reset and do some house cleaning of it's own allowing the rebuild script to run correctly and cleanly.
There should never be a situation where you have to restart the server for koha related things. In my environment, I've never done it except for OS patching, and I actually can't restart the MySQL server as it's managed directly by our sysadmins and I don't have a login to it. Essentially my point is that if you have to do that, something else is wrong. Linux ain't Windows :) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
participants (3)
-
Robin Sheat -
Scott Owen -
vikram zadgaonkar