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@foundations.edu> wrote:
Hi Chris,
Thanks for your reply. bulkmarcimport has been tested and approved for
2009/11/19 Joel Cornuz <jcornuz@gmail.com>: 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:
for a list of currently reported ones.
Kind Regards, Chris
On Thu, Nov 19, 2009 at 10:02 PM, Chris Nighswonger <cnighswonger@foundations.edu> wrote:
Hi Joel,
2009/11/19 Joel Cornuz <jcornuz@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@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