{"id":50,"date":"2009-06-05T15:54:43","date_gmt":"2009-06-05T19:54:43","guid":{"rendered":"http:\/\/ewart.homelinux.net\/?p=50"},"modified":"2010-08-14T12:54:24","modified_gmt":"2010-08-14T16:54:24","slug":"book-catalog-conversion","status":"publish","type":"post","link":"https:\/\/www.bobsown.net\/?p=50","title":{"rendered":"Book Catalog Conversion"},"content":{"rendered":"

The catalog records for books are selected and exported.\u00a0 DBTextCatalog<\/a> will convert them into MARC records, which can then be bulk imported into Koha.\u00a0 The MARC record will have a 952 field for each physical volume.<\/p>\n

<\/p>\n

Field mapping<\/strong><\/p>\n

This is a list of fields in the DBText Catalog database and how they map to MARC 21 fields.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Field<\/th>\nPresent<\/th>\nLength<\/th>\nCrlf<\/th>\nDescription<\/th>\nMARC Field<\/th>\n<\/tr>\n
0<\/td>\n100.0%<\/td>\n5<\/td>\n0<\/td>\nID<\/td>\n001<\/td>\n<\/tr>\n
1<\/td>\n99.5%<\/td>\n68<\/td>\n79<\/td>\nClass<\/td>\n050$a
\n952$o<\/td>\n<\/tr>\n
2<\/td>\n0.4%<\/td>\n10<\/td>\n0<\/td>\nLabel Information<\/td>\n<\/td>\n<\/tr>\n
3<\/td>\n65.8%<\/td>\n62<\/td>\n2<\/td>\nCopy Management<\/td>\n<\/td>\n<\/tr>\n
4<\/td>\n99.9%<\/td>\n111<\/td>\n12<\/td>\nTitle<\/td>\n245$a<\/td>\n<\/tr>\n
5<\/td>\n48.8%<\/td>\n315<\/td>\n6<\/td>\nSubtitle<\/td>\n245$b<\/td>\n<\/tr>\n
6<\/td>\n98.3%<\/td>\n211<\/td>\n52<\/td>\nAuthor<\/td>\n100$a<\/td>\n<\/tr>\n
7<\/td>\n0.5%<\/td>\n92<\/td>\n4<\/td>\nCorporate Author<\/td>\n110$a<\/td>\n<\/tr>\n
8<\/td>\n84.6%<\/td>\n300<\/td>\n16<\/td>\nResponsibility<\/td>\n245$c<\/td>\n<\/tr>\n
9<\/td>\n32.1%<\/td>\n243<\/td>\n5<\/td>\nEdition<\/td>\n250$a<\/td>\n<\/tr>\n
10<\/td>\n55.3%<\/td>\n79<\/td>\n0<\/td>\nSource<\/td>\n040$a<\/td>\n<\/tr>\n
11<\/td>\n97.1%<\/td>\n117<\/td>\n9<\/td>\nPlace<\/td>\n260$a<\/td>\n<\/tr>\n
12<\/td>\n99.6%<\/td>\n158<\/td>\n14<\/td>\nPublisher<\/td>\n260$b<\/td>\n<\/tr>\n
13<\/td>\n99.5%<\/td>\n27<\/td>\n16<\/td>\nPub Date<\/td>\n260$c<\/td>\n<\/tr>\n
14<\/td>\n97.6%<\/td>\n268<\/td>\n22<\/td>\nPhysical Description<\/td>\n300$a,b,c<\/td>\n<\/tr>\n
15<\/td>\n100.0%<\/td>\n5<\/td>\n2<\/td>\nRecord Type<\/td>\nBook<\/td>\n<\/tr>\n
16<\/td>\n5.4%<\/td>\n69<\/td>\n0<\/td>\nSeries<\/td>\n440$a<\/td>\n<\/tr>\n
17<\/td>\n73.1%<\/td>\n757<\/td>\n117<\/td>\nDescriptors<\/td>\n650$a<\/td>\n<\/tr>\n
18<\/td>\n1.9%<\/td>\n1052<\/td>\n2<\/td>\nAbstract<\/td>\n520$a<\/td>\n<\/tr>\n
19<\/td>\n51.3%<\/td>\n2467<\/td>\n139<\/td>\nNotes<\/td>\n500$a<\/td>\n<\/tr>\n
20<\/td>\n87.4%<\/td>\n90<\/td>\n23<\/td>\nISBN<\/td>\n020$a<\/td>\n<\/tr>\n
21<\/td>\n0.2%<\/td>\n9<\/td>\n0<\/td>\nISSN<\/td>\n022$a<\/td>\n<\/tr>\n
22<\/td>\n66.3%<\/td>\n20<\/td>\n2<\/td>\nWhen Cataloged<\/td>\n<\/td>\n<\/tr>\n
23<\/td>\n18.1%<\/td>\n19<\/td>\n0<\/td>\nWhen Approved<\/td>\n<\/td>\n<\/tr>\n
24<\/td>\n3.1%<\/td>\n9<\/td>\n0<\/td>\nOrder Number<\/td>\n<\/td>\n<\/tr>\n
25<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nSupplier Title No<\/td>\n<\/td>\n<\/tr>\n
26<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nInternal Acct No<\/td>\n<\/td>\n<\/tr>\n
27<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nPurchase Order<\/td>\n<\/td>\n<\/tr>\n
28<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nCopies on Order<\/td>\n<\/td>\n<\/tr>\n
29<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nRequestor<\/td>\n<\/td>\n<\/tr>\n
30<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nRequest Date<\/td>\n<\/td>\n<\/tr>\n
31<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nRequestor Due Date<\/td>\n<\/td>\n<\/tr>\n
32<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nOrder Date<\/td>\n<\/td>\n<\/tr>\n
33<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nOrder Received<\/td>\n<\/td>\n<\/tr>\n
34<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nSent to Requestor<\/td>\n<\/td>\n<\/tr>\n
35<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nOrder Type<\/td>\n<\/td>\n<\/tr>\n
36<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nSupplier<\/td>\n<\/td>\n<\/tr>\n
37<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nInvoice Number<\/td>\n<\/td>\n<\/tr>\n
38<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nList Price<\/td>\n<\/td>\n<\/tr>\n
39<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nActual Cost<\/td>\n952$g<\/td>\n<\/tr>\n
40<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nOrder Notes<\/td>\n<\/td>\n<\/tr>\n
41<\/td>\n0.0%<\/td>\n9<\/td>\n0<\/td>\nFrequency<\/td>\n<\/td>\n<\/tr>\n
42<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nStart Date<\/td>\n<\/td>\n<\/tr>\n
43<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nExpiration Date<\/td>\n<\/td>\n<\/tr>\n
44<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nRenewal Date<\/td>\n<\/td>\n<\/tr>\n
45<\/td>\n0.1%<\/td>\n56<\/td>\n2<\/td>\nHoldings<\/td>\n<\/td>\n<\/tr>\n
46<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nSpecial Issues<\/td>\n<\/td>\n<\/tr>\n
47<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nIndexed In<\/td>\n<\/td>\n<\/tr>\n
48<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nRetention Policy<\/td>\n<\/td>\n<\/tr>\n
49<\/td>\n0.1%<\/td>\n15<\/td>\n0<\/td>\nLoan Policy<\/td>\n<\/td>\n<\/tr>\n
50<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nQ1 Cost<\/td>\n<\/td>\n<\/tr>\n
51<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nQ2 Cost<\/td>\n<\/td>\n<\/tr>\n
52<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nQ3 Cost<\/td>\n<\/td>\n<\/tr>\n
53<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nQ4 Cost<\/td>\n<\/td>\n<\/tr>\n
54<\/td>\n98.0%<\/td>\n48<\/td>\n1822<\/td>\nBar Code<\/td>\n952$p<\/td>\n<\/tr>\n
55<\/td>\n66.9%<\/td>\n20<\/td>\n12<\/td>\nLC Card<\/td>\n<\/td>\n<\/tr>\n
56<\/td>\n97.4%<\/td>\n10<\/td>\n0<\/td>\nRecord Created<\/td>\n952$d<\/td>\n<\/tr>\n
57<\/td>\n2.7%<\/td>\n23<\/td>\n0<\/td>\nItems Out<\/td>\n<\/td>\n<\/tr>\n
58<\/td>\n0.0%<\/td>\n0<\/td>\n0<\/td>\nURL<\/td>\n<\/td>\n<\/tr>\n
59<\/td>\n0.0%<\/td>\n14<\/td>\n0<\/td>\nWaiting List<\/td>\n<\/td>\n<\/tr>\n
60<\/td>\n2.3%<\/td>\n67<\/td>\n0<\/td>\nProvenance<\/td>\n952$e<\/td>\n<\/tr>\n
61<\/td>\n0.7%<\/td>\n17<\/td>\n0<\/td>\nDewey<\/td>\n082$a<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\nFiction or Nonfiction<\/td>\n952$a<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\ncopy number<\/td>\n952$t<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/td>\nflflsla<\/td>\n003<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

The catalog records for books are selected and exported.\u00a0 DBTextCatalog will convert them into MARC records, which can then be bulk imported into Koha.\u00a0 The MARC record will have a 952 field for each physical volume.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"footnotes":""},"categories":[16],"tags":[],"class_list":["post-50","post","type-post","status-publish","format-standard","hentry","category-conversion-to-koha"],"_links":{"self":[{"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/posts\/50","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=50"}],"version-history":[{"count":4,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/posts\/50\/revisions"}],"predecessor-version":[{"id":95,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=\/wp\/v2\/posts\/50\/revisions\/95"}],"wp:attachment":[{"href":"https:\/\/www.bobsown.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=50"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=50"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bobsown.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=50"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}