Hi Gianfranco, please find my answers in-line.
On Tue, Jun 16, 2015 at 5:57 PM, Gianfranco Nicola/MFP <gianfranco.nic...@museoferroviariopiemontese.com> wrote: > Hi Robin, > > Thank you for your answer. In fact, i am just going to extract > as much data as possible from the legacy database (which is > SQL Server) as a CSV file, then I will try convert it as a MARC > file. In Italy, National Libraries use UNIMARC, so I configured > my Koha instance that way. I'll try to answer some of your queries. First off, I've never worked with UNIMARC, rather with MARC21. So I'm going to refer to MARC21. Having said that, UNIMARC is a flavour of MARC so, there are enough similarities in the concepts. > For example: the old program associates each book with one > or more topics (like "steam engines"; "steam locomotive boiler > parts"; "signalling"; "traffic control", and so on); where are to be > stored these topics in koha? In MARC21, these would go into "subject heading"s i.e. under tag no 650 - http://www.loc.gov/marc/bibliographic/bd650.html > But right now I am wondering if these informations _should_ > ever be transferred, because - if I understand right - these topics > relates to "classify" a book, whereas registering it in the catalog > is just that: "cataloguing" it. And , if I am right, Koha catalogues > pre-classified books, and doesn't allow to classify a a book from > scratch. Is that right? If not, how to do that? No, Koha does allows a book to be cataloged from scratch. You would need to define the authority files ahead or else go on defining them as you go along. Either is possible. > Another question is, in the old database books and authors > are linked by a many-to-many relation; so, when extracting > records, this gives multiple rows in the CSV, each with a > different author; the same with publishers. How can I handle this? The way I would do it would be stage these into mysql tables. Write a perl script that accesses these tables, and extracts the JOINed data and finally save it a a MARC record using some of the same MARC modules that Koha uses. Then run a final check on the created MARC files using an utility like MarcEdit. And finally when satisfied with the same, do a bulk import into Koha. hope that helps -indranil -- Indranil Das Gupta L2C2 Technologies INDIA Phone : +91-98300-20971 / +91-9874580971 / +91-33-2443-0187 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
