The catalog records for books are selected and exported. DBTextCatalog will convert them into MARC records,which can then be bulk imported into Koha. The MARC record will have a 952 field for each physical volume.
Field mapping
This is a list of fields in the DBText Catalog database and how they map to MARC 21 fields.
| Field | Present | Length | Crlf | Description | MARC Field |
|---|---|---|---|---|---|
| 0 | 100.0% | 5 | 0 | ID | 001 |
| 1 | 99.5% | 68 | 79 | Class | 050$a 952$o |
| 2 | 0.4% | 10 | 0 | Label Information | |
| 3 | 65.8% | 62 | 2 | Copy Management | |
| 4 | 99.9% | 111 | 12 | Title | 245$a |
| 5 | 48.8% | 315 | 6 | Subtitle | 245$b |
| 6 | 98.3% | 211 | 52 | Author | 100$a |
| 7 | 0.5% | 92 | 4 | Corporate Author | 110$a |
| 8 | 84.6% | 300 | 16 | Responsibility | 245$c |
| 9 | 32.1% | 243 | 5 | Edition | 250$a |
| 10 | 55.3% | 79 | 0 | Source | 040$a |
| 11 | 97.1% | 117 | 9 | Place | 260$a |
| 12 | 99.6% | 158 | 14 | Publisher | 260$b |
| 13 | 99.5% | 27 | 16 | Pub Date | 260$c |
| 14 | 97.6% | 268 | 22 | Physical Description | 300$a,b,c |
| 15 | 100.0% | 5 | 2 | Record Type | Book |
| 16 | 5.4% | 69 | 0 | Series | 440$a |
| 17 | 73.1% | 757 | 117 | Descriptors | 650$a |
| 18 | 1.9% | 1052 | 2 | Abstract | 520$a |
| 19 | 51.3% | 2467 | 139 | Notes | 500$a |
| 20 | 87.4% | 90 | 23 | ISBN | 020$a |
| 21 | 0.2% | 9 | 0 | ISSN | 022$a |
| 22 | 66.3% | 20 | 2 | When Cataloged | |
| 23 | 18.1% | 19 | 0 | When Approved | |
| 24 | 3.1% | 9 | 0 | Order Number | |
| 25 | 0.0% | 0 | 0 | Supplier Title No | |
| 26 | 0.0% | 0 | 0 | Internal Acct No | |
| 27 | 0.0% | 0 | 0 | Purchase Order | |
| 28 | 0.0% | 0 | 0 | Copies on Order | |
| 29 | 0.0% | 0 | 0 | Requestor | |
| 30 | 0.0% | 0 | 0 | Request Date | |
| 31 | 0.0% | 0 | 0 | Requestor Due Date | |
| 32 | 0.0% | 0 | 0 | Order Date | |
| 33 | 0.0% | 0 | 0 | Order Received | |
| 34 | 0.0% | 0 | 0 | Sent to Requestor | |
| 35 | 0.0% | 0 | 0 | Order Type | |
| 36 | 0.0% | 0 | 0 | Supplier | |
| 37 | 0.0% | 0 | 0 | Invoice Number | |
| 38 | 0.0% | 0 | 0 | List Price | |
| 39 | 0.0% | 0 | 0 | Actual Cost | 952$g |
| 40 | 0.0% | 0 | 0 | Order Notes | |
| 41 | 0.0% | 9 | 0 | Frequency | |
| 42 | 0.0% | 0 | 0 | Start Date | |
| 43 | 0.0% | 0 | 0 | Expiration Date | |
| 44 | 0.0% | 0 | 0 | Renewal Date | |
| 45 | 0.1% | 56 | 2 | Holdings | |
| 46 | 0.0% | 0 | 0 | Special Issues | |
| 47 | 0.0% | 0 | 0 | Indexed In | |
| 48 | 0.0% | 0 | 0 | Retention Policy | |
| 49 | 0.1% | 15 | 0 | Loan Policy | |
| 50 | 0.0% | 0 | 0 | Q1 Cost | |
| 51 | 0.0% | 0 | 0 | Q2 Cost | |
| 52 | 0.0% | 0 | 0 | Q3 Cost | |
| 53 | 0.0% | 0 | 0 | Q4 Cost | |
| 54 | 98.0% | 48 | 1822 | Bar Code | 952$p |
| 55 | 66.9% | 20 | 12 | LC Card | |
| 56 | 97.4% | 10 | 0 | Record Created | 952$d |
| 57 | 2.7% | 23 | 0 | Items Out | |
| 58 | 0.0% | 0 | 0 | URL | |
| 59 | 0.0% | 14 | 0 | Waiting List | |
| 60 | 2.3% | 67 | 0 | Provenance | 952$e |
| 61 | 0.7% | 17 | 0 | Dewey | 082$a |
| Fiction or Nonfiction | 952$a | ||||
| copy number | 952$t | ||||
| flflsla | 003 |