[Koha] new import

[Scott Owen]

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 at 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
>