Or... "StoryCollection"? $bPRBHS$bStoryCollection Le mar. 4 juil. 2023 à 12:16, Jonathan Druart <jonathan.dru...@bugs.koha-community.org> a écrit :
> > Hi, > > The error message (from the DBMS) is cut, please provide the full message. > My guess is that the branchcode ("PRBHS") does not exist in the DB. > > Regards, > Jonathan > > Le ven. 30 juin 2023 à 19:20, Furst, Kevin <kfu...@prbschools.org> a écrit : > > > > Hello, > > > > TL;DR = When importing MARC records, items don't import and fail. > > > > I am transitioning from Follett Destiny to Koha. After doing a MARC export > > from Follett, I noticed that when staging records for import, Koha would > > parse the biblio records fine but wouldn't find any item records. After > > searching past messages in this list, I found that Follett has item records > > as 852 instead of 952. I used MARCedit to change those to 952 and also > > added a and b records to match the libraries listed in Koha. After doing > > that and trying again, item records were then found during staging. > > > > However when I import the staged records, it just fails and gives me > > nothing in the detailed messages in the UI. If I remove the 952 records, it > > works fine and imports all the other records thus I know something is wrong > > with my 952 entries. I have checked that there are p barcodes and a and b > > home and current libraries. > > > > In the Koha logs on the server, this is the only error message I get when I > > try to run an import and it fails. To me it seems like a FK is missing on > > import but I don't know what. Looking at the schema example, I'm wondering > > if I'm supposed to be importing things to 942 and 999 along with 952. I do > > not know if, when importing MARC records, Koha creates its own enumerated > > ids for biblio, item number, etc. if that stuff isn't in the import file... > > or if it isn't there, will it fail? > > > > BIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st > > execute failed: Cannot add or update a child row: a foreign key constraint > > fails (`koha_library`.`items`, CONSTRAINT `items_ibfk_> > > > > Broken FK constraint at > > /usr/share/koha/lib/Koha/BackgroundJob/MARCImportCommitBatch.pm line 91. > > > > Here are a couple of 952 records from the Follett export to Koha import > > file to see if something simple is wrong. I'm hoping it's something simple > > on these lines. > > > > > > =952 \\$p34517100010472$aPRBHS$bPRBHS$bStory > > Collection$v10.00USD$x14441$eaRegular@c20060929@fTransfer from PRB Elem.@j > > @j@j@i@i@i$hSC Otf$x1127380 > > > > =952 \\$p3333300007200O$aPRBHS$bPRBHS$v20.00USD$x17292$eaRegular@c20050604 > > @j@j@j@i@i@i$hR 639 Can pb$x527111 > > > > > > (Beyond that, I haven't really tinkered with anything in the default MARC > > framework settings in admin. > > Here is my version : > > *Koha version:22.11.05.000 Rosalie* > > > > I would really appreciate any help, I've been working on this for over a > > week now. > > > > *Kevin Furst* > > Technology Director > > Pine River-Backus Schools > > o | 218.587.8030 > > @ | kfu...@prbschools.org > > > > Technology Office/Help Desk: 218-587-8510 > > > > *Confidentiality Notice: This E-mail message, including any attachments, is > > for the sole use of the intended recipient(s) and may contain confidential > > and privileged information. Any unauthorized review, use, disclosure or > > distribution is prohibited. If you are not the intended recipient, please > > contact the sender by reply E-mail and destroy all copies of the original > > message.* > > _______________________________________________ > > > > Koha mailing list http://koha-community.org > > Koha@lists.katipo.co.nz > > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha