https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24572 Bug ID: 24572 Summary: Add books from mysql manually Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs@lists.koha-community.org Reporter: chrs.markx86@gmail.com QA Contact: testopia@bugs.koha-community.org CC: m.de.rooy@rijksmuseum.nl Hi everyone, I'm trying to bulk import book items into Koha database using a custom script that I have created (in python). Here are some of the mysql commands I use for it: insert into biblio (title, biblionumber, frameworkcode, datecreated) values('{}',{},'{}',NOW())".format(title, biblionumber, biblio_framework) so as to create a new book, and then insert into biblio_metadata (id, biblionumber, format, marcflavour, metadata) values ({},{},'{}','{}','{}')".format(id, biblionumber, "marcxml", "UNIMARC", meta) in order to attach metadata to it. The result is that the sql entries are successfully inserted however I cannot search the book from the basic search at http://192.168.1.12/cgi-bin/koha/opac-main.pl I guess that some more date need to be populated so as to have the books available from the search bar? Could you please point me which tables are required to be populated so as to have books listed in searches like the one I described above? Thank you in advance, C. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.