[Koha] Hello / marc import problem

[Joel Cornuz]

Hi Chris

It happened again: made a fool of myself :-P

Looks like the importer needs UTF8 marc which somehow wasn't enabled in
bookwhere. The items aren't added and the unimport feature doesn't work but
these aren't crucial.

The SQL nitpicks I was mentionning are in ImportBatch.pl (sorry about the
confusion) where import_record_id would fail - replacing with
import_records.import_record_id did the trick, though.

Thanks for your help with that - it motivated me to fiddle around some more
until I stumble across the solution. With that, the next step is mass-import
and production.

You rock, guys.

Joel



On Thu, Nov 19, 2009 at 10:57 PM, Chris Nighswonger <
cnighswonger at foundations.edu> wrote:

> 2009/11/19 Joel Cornuz <jcornuz at gmail.com>:
> > Hi Chris,
> >
> > Thanks for your reply. bulkmarcimport has been tested and approved for
> the
> > migration :)
> >
> > Still, on a daily basis, I need to have the stage marc import working, so
> > our librarian can get his notices from bookwhere (as an mrc file) and
> import
> > them to Koha...
>
> I am assuming that you have tried to run a file from bookwhere through
> bulkmarcimport.pl and have success. But the same file will not import
> via the staff-client marc import tool.
>
> >
> > I don't think it is related, but I had a couple of SQL nitpicks in
> > BatchImport.pl - column ambiguous definition that wouldn't allow me to
> see
> > the table of to be imported records. Let me know if you want more info on
> > this...
>
> Sorry, I'm not familiar with BatchImport.pl. It does not appear to be
> in the main Koha git repo.
>
> >
> > Regarding stage import, is there anything else I can try?
>
> Silent fails are particularly hard to troubleshoot and the
> staff-client marc import tool fails silently.
>
> One thing that will make it fail is if the branch code contained in
> items attached to a bib is none existent. I believe the field is 952$a
> in a default Koha installation.
>
> There are several other bugs there as well. See here:
>
> http://tinyurl.com/ych7p68
>
> for a list of currently reported ones.
>
> Kind Regards,
> Chris
>
>
> > On Thu, Nov 19, 2009 at 10:02 PM, Chris Nighswonger
> > <cnighswonger at foundations.edu> wrote:
> >>
> >> Hi Joel,
> >>
> >> 2009/11/19 Joel Cornuz <jcornuz at gmail.com>:
> >> > Hi there,
> >> >
> >> > I am helping a school setting up Koha for their 6000 books library. We
> >> > are
> >> > nearing the stage of production with installation, labels,
> importation,
> >> > daily management etc under control, thanks to Koha. So KUDOS :)
> >>
> >> That's great. Congratulations!
> >>
> >> >
> >> > The last thing we need is to import records from Bookwhere (a Z ). I
> can
> >> > stage a batch of records, the records appear in the managing batch as
> >> > expected but no matter what, clicking on "import into catalogue" will
> >> > give
> >> > me a 0 number of records added, updated, ignored and the same for
> items.
> >> > Obviously, I don't find my records in the catalogue.
> >> >
> >> > I don't get any error message in koha_error-log, so I wonder if I am
> >> > missing
> >> > something obvious? btw, my koha version is 3.00.04.
> >>
> >> Maybe try using bulkmarcimport.pl in the migration_tools sub
> >> directory. Running  'perl bulkmarcimport.pl -h' should get you
> >> information on how to use it.
> >>
> >> Kind Regards,
> >> Chris
> >
> >
> >
> > --
> > __________________________________
> >
> > Merci de noter notre nouveau numéro de téléphone: 514 664 3494
> >
> > _______________________________________________
> > Koha mailing list
> > Koha at lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
> >
> >
>



-- 
__________________________________

Merci de noter notre nouveau numéro de téléphone: 514 664 3494
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20091120/d8b7c4d6/attachment-0001.htm