Additional Biblio Information from excel

Help
2012-05-01
2013-05-30
  • Shamim Reza
    Shamim Reza
    2012-05-01

    We want to automate our library by OpenBiblio. We have register books which has the written information about the books. We already entry the data in excel by outsourcing. I want to import the books information in Openbiblio Databse. It is possible to import data to “biblio” table by using MarcEdit 5.8.
    But “biblio_field” table’s data (year, price etc) is not possible for me to import from excel.
    Please help us.

     
  • David G
    David G
    2012-05-01

    The way I did this was import a few records in to OB and then edit the excel to match the mysql format and then use mysql workbench to import the text file (csv) to OB. Was trial and error method but worked for me. I also imported all my students the same way rather than entry by entry.

    BR
    Goose

     
  • Haven't used MarcEdit myself a lot, but I think it should be possible to produce a MARC file with the tags/subfields that correspond to year, price, etc. If these tags (260 $c, 020 $c or 541 $h, etc.) are in the MARC file produced by MarcEdit, then OpenBiblio should be able to import these data.

    The MarcEdit Delimited Text Translator allows users to custom define the field/subfield relationship, indicators and ending termination of the field/subfield for each delimited data cell.

    http://people.oregonstate.edu/~reeset/marcedit/html/help/marcedit4_5/html/tbMainAbout.html

    (you can forget about indicators when importing into OpenBiblio 0.7.1 or older - not suported)

     


Anonymous


Cancel   Add attachments