Importing MARC21 file leaves out Items information
We are currently trying to import a marc file, it imports the records, however the item information does not get imported... location, status, date Due, last Seen, barcode etc (all blank) When importing them I got an error message saying Access denied for user 'kohaadmin'@'localhost' to database 'koha' referring to line 333 within modules/C4/Biblio.pm Anybody know why the item details are not appearing - everything else does cheers s -- View this message in context: http://www.nabble.com/Importing-MARC21-file-leaves-out-Items-information-tf3... Sent from the Koha - Discuss mailing list archive at Nabble.com.
We are currently trying to import a marc file, it imports the records, however the item information does not get imported... location, status, date Due, last Seen, barcode etc (all blank)
When importing them I got an error message saying Access denied for user 'kohaadmin'@'localhost' to database 'koha' referring to line 333 within modules/C4/Biblio.pm
Anybody know why the item details are not appearing - everything else does You should check the biblio frameworks to make sure the items fields are set up to be identical to the records you're importing. If you are importing records that have items in 852 fields, but your Koha frameworks use 952, the items data won't be linked to
----- "essjay_d12" <essjay_d12@hotmail.com> wrote: the items fields in Koha. Hope that helps. Cheers, -- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS
We have set the items up and they are all the same. There is one exception that may be causing this error... for the marc structure to be right koha needed us to enter a holding branch - without it the marc check throws an error. With it its fine. But the item structure from our old library db does not have that field. Would this be causing the error, if it is, how do we go about getting around this? cheers Joshua M. Ferraro wrote:
We are currently trying to import a marc file, it imports the records, however the item information does not get imported... location, status, date Due, last Seen, barcode etc (all blank)
When importing them I got an error message saying Access denied for user 'kohaadmin'@'localhost' to database 'koha' referring to line 333 within modules/C4/Biblio.pm
Anybody know why the item details are not appearing - everything else does You should check the biblio frameworks to make sure the items fields are set up to be identical to the records you're importing. If you are importing records that have items in 852 fields, but your Koha frameworks use 952, the items data won't be linked to
----- "essjay_d12" <essjay_d12@hotmail.com> wrote: the items fields in Koha.
Hope that helps.
Cheers,
-- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Importing-MARC21-file-leaves-out-Items-information-tf3... Sent from the Koha - Discuss mailing list archive at Nabble.com.
we are having the exact same problem, we had to include a holding branch (which we don't really need) is it this field that is preventing the items information from being imported? anybody know/ help? cheers essjay_d12 wrote:
We have set the items up and they are all the same. There is one exception that may be causing this error... for the marc structure to be right koha needed us to enter a holding branch - without it the marc check throws an error. With it its fine. But the item structure from our old library db does not have that field. Would this be causing the error, if it is, how do we go about getting around this?
cheers
Joshua M. Ferraro wrote:
We are currently trying to import a marc file, it imports the records, however the item information does not get imported... location, status, date Due, last Seen, barcode etc (all blank)
When importing them I got an error message saying Access denied for user 'kohaadmin'@'localhost' to database 'koha' referring to line 333 within modules/C4/Biblio.pm
Anybody know why the item details are not appearing - everything else does You should check the biblio frameworks to make sure the items fields are set up to be identical to the records you're importing. If you are importing records that have items in 852 fields, but your Koha frameworks use 952, the items data won't be linked to
----- "essjay_d12" <essjay_d12@hotmail.com> wrote: the items fields in Koha.
Hope that helps.
Cheers,
-- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE President, Technology migration, training, maintenance, support LibLime Featuring Koha Open-Source ILS jmf@liblime.com |Full Demos at http://liblime.com/koha |1(888)KohaILS _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- View this message in context: http://www.nabble.com/Importing-MARC21-file-leaves-out-Items-information-tf3... Sent from the Koha - Discuss mailing list archive at Nabble.com.
hi, s, How exactly are you trying to import your records into Koha? If I recall correctly, using the web interface for importing records into the reservoir does delete holdings/item information. The only way I've found for getting my records into Koha while keeping holdings/item information is to use the bulkmarcimport.pl script. You'll have to consult with others whether there are any potential problems with using this script in your case. In other words, proceed with caution. If you do choose to go this route then here's what I do on Debian Etch with a standard install: # Make sure the Koha modules are a part of your path. I accomplish this by adding "export PATH=/usr/local/koha/intranet/modules" without the quotes to my .bashrc (or add the path to /etc/profile for the root user). # perl /usr/local/koha/intranet/scripts/misc/migration_tools/bulkmarcimport.pl -v -file /path/to/marc-file.mrc This has worked for me to get holdings information into my catalog, but I may be overlooking something important. Please let me know if your results are different. --Jason Ronallo On 6/18/07, essjay_d12 <essjay_d12@hotmail.com> wrote:
We have set the items up and they are all the same. There is one exception that may be causing this error... for the marc structure to be right koha needed us to enter a holding branch - without it the marc check throws an error. With it its fine. But the item structure from our old library db does not have that field. Would this be causing the error, if it is, how do we go about getting around this?
cheers
Joshua M. Ferraro wrote:
We are currently trying to import a marc file, it imports the records, however the item information does not get imported... location, status, date Due, last Seen, barcode etc (all blank)
When importing them I got an error message saying Access denied for user 'kohaadmin'@'localhost' to database 'koha' referring to line 333 within modules/C4/Biblio.pm
Anybody know why the item details are not appearing - everything else does You should check the biblio frameworks to make sure the items fields are set up to be identical to the records you're importing. If you are importing records that have items in 852 fields, but your Koha frameworks use 952, the items data won't be linked to
----- "essjay_d12" <essjay_d12@hotmail.com> wrote: the items fields in Koha.
Hope that helps.
Cheers,
-- Joshua Ferraro SUPPORT FOR OPEN-SOURCE SOFTWARE
Jason Ronallo wrote:
If you do choose to go this route then here's what I do on Debian Etch with a standard install: # Make sure the Koha modules are a part of your path. I accomplish this by adding "export PATH=/usr/local/koha/intranet/modules" without the quotes to my .bashrc (or add the path to /etc/profile for the root user).
Might I suggest that you should make the Koha modules are a part of your PERL5LIB instead: export PERL5LIB=/usr/local/koha/intranet/modules Remember: PATH is for program executables. PERL5LIB is for libraries. cheers rickw -- _________________________________ Rick Welykochy || Praxis Services Any belief that can't stand up to objective scrutiny is hardly worth having. -- LJ McIntyre
participants (5)
-
essjay_d12 -
Jason Ronallo -
Joshua M. Ferraro -
pemcol -
Rick Welykochy