[Koha-bugs] [Bug 24572] New: Add books from mysql manually

[bugzilla-daemon at bugs.koha-community.org]

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.