How to Link Calibre to Koha

 Two steps are involved in linking Calibre with Koha

Exporting books from Calibre Software.

    1. Calibre > Convert books > Create a catalog of the books in your calibre library

 2. Export the file as 'CSV'.

 3. Choose the following columns: author_sort, authors, formats, isbn, id, languages, pubdate, publisher, series, tags, title, title_sort

 4. id transform as 

        [URL]+[#book_id=]+[id]+[&library_id=Calibre_Library&panel=book_details]  e.g

        http://192.168.10.6:8080/#book_id=6&library_id=Calibre_Library&panel=book_details

  5. author_sort break into principal, 2nd and 3rd authors columns

  6. Arrange columns as isbn, author_sort, 2nd auth, 3rd Auth, authors, title, publisher, pubdate, tags,id,LibraryName, Library Name

Mapping 

with marc Tags by marcedit using  as follows:    

1. isbn > 020
2. author_sort > 100$a
3. 2nd auth > 700$a
4. 3rd Auth >700$a 
5. authors > 245$c
6. title >245$a
7. publisher > 260$b
8. pubdate > 260$c
9. tags > 650$a
10. click to view > 856$3
11. id > 856$u
12. Available within Campus>856$z
13. LibraryName > 952$a
14. Library Name >952$b

 and finally, Import it into Koha by Bulkmarc or Marc stage.

______________________________________________________________