[Koha-bugs] [Bug 24572] New: Add books from mysql manually
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Mon Feb 3 21:10:10 CET 2020
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 at lists.koha-community.org
Reporter: chrs.markx86 at gmail.com
QA Contact: testopia at bugs.koha-community.org
CC: m.de.rooy at 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.
More information about the Koha-bugs
mailing list