Some (possibly) helpful hints in converting DBTextworks to Marc records.
We have cracked the problem I had with converting the DBTextwork file I had created (which looked fine until the Marcedit was run over it and all the fields just ran into each other)) by doing the following in Marcedit
We did the patron and loans conversions and went live about a month ago. The staff have all been enthusiastic about Koha. So far,we’ve done two custom modifications:Membership cards and labels and full Gaylord book labels.
I will post the Koha training manual here in draft until I have time to review it next week with key folks to insure we get the right information posted. Unfortunately,the only Koha documentation available is web based,so I am converting their web documentation to .pdf files,so that they can be customized and printed [...]
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.
The DBText borrower database needs to be converted into a comma delimited file in the proper format to be loaded into Koha via Import Patrons in the Tools menu. Most of the fields can be mapped into the corresponding Koha fields. The branch code and an initial password need to be added. We have added [...]
Koha is a full-featured open-source ILS. Developed initially in New Zealand by Katipo Communications Ltd and first deployed in January of 2000 for Horowhenua Library Trust,it is currently maintained by a team of software providers and library technology staff from around the globe. More information can be found at the Koha web site
DBTextCheck will check exported borrower,catalog or loans files for blank records or missing required fields. The name of the file to be checked is the only required parameter. Blank record output defaults to DBTblanks.csv. Records missing required fields will be written to DBTinvalid.csv.
DBTextCheck will produce a summary of each field showing the field [...]
These are the various categories and codes used by Koha to describe patrons and items in the catalog.
DBText originally didn’t differentiate borrowers;as long as their expiration date hadn’t passed,they could take out books. I added a select-code field into which we could put various tags such as:IND,FAM,BoD,Vol,PUB [...]
We have been running DBText for Libraries for about seven years. During that time a lot of garbage has accumulated in the database. There are three areas of concern. I will be covering them and my solutions later.