- Koha - lists.katipo.co.nz

Re: [Koha] Follett to Koha 3 Migration
by Doug Dearden 12 Feb '09

12 Feb '09

>>> Ed Roche <edward_roche(a)solanco.k12.pa.us> 2/11/2009 9:55:11 AM >>> Good Morning/Afternoon All Anyone who has migrated from Follett to Koha, would you happen to have documented how you did it? If so would you be willing to share? Thanks Ed Edward J. Roche Network Administrator Solanco School District -- View this message in context: http://www.nabble.com/Follett-to-Koha-3-Migration-tp21958260p21958260.html Sent from the Koha - Discuss mailing list archive at Nabble.com. _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha Hi Ed, I recently did a migration from Follett, and can give you some broad stroke guide lines. Install Koha. If you haven't done this yet, take a look at the wiki for links to some installation guides. I used Debian Etch, and since the server I was setting up on did not have hardware raid, I set up software raid using this guide: http://www.howtoforge.com/linux_software_raid . If you aren't intimate with Linux, you have a pretty steep learning curve here. You need to get a base Linux install done, then download the latest stable koha release and unwrap it. Look at the INSTALL.debian file and follow all of those instructions to get the prerequisites installed and a base koha installation done, or use one of the installation guides in the wiki if you are installing on a different Linux distro. I installed SSH and phpmyadmin so I could work easily from my desktop computer. You probably want to review some of the installation guides on the wiki just to get a feel for the process and the potential snags. I installed this on a test computer to begin with, then did it again on the server it is running on. I started over from scratch more than once, and found that getting all of the Perl modules that koha needs installed to be my biggest hurdle. Again, some tricks in the install guides on the wiki helped. Once you have koha installed and working, get with your librarian and go through all of the System Preferences and set those. I think you will find a link on kohadocs.org to a setup guide that will help. You pretty much have to read the online manual about the different options and make decisions that fit your situation. Also, get a look at the frameworks, and make sure you understand how the "hidden" field controls the display in the OPAC and the staff client. Take a look at all of the other options in the staff client and get those set. Migrating the patrons was pretty straight forward. The import patrons page has a sample csv file you can download, I exported the patrons from Follett, imported them into excel and then did a cut and paste of columns into the csv file, saved it and imported it into koha. With the size of our library, we did not have to migrate circulation records, so that one you get to figure out. We also didn't migrate authorities, as our librarian wanted to build those anew. For the biblio records, export from Follett (we use marc 21). If I remember right you do that from the cataloging screen. The Follett records are in pretty good shape, with a couple of exceptions. If you haven't used marc edit, download it from here: http://oregonstate.edu/~reeset/marcedit/html/index.php . This utility will take a marc file, break it out so it is readable, and after editing put it back into the machine readable format. It also has a script generator. This all runs on Windows, the script generator creates VB Script. If you haven't worked with marc files before, your cataloging librarian will be happy to talk about it. A lot. Follett exports the holding info into the 852 record, including a $x field that has a string of stuff delimited by @ signs. I used the script generator to create a basic script, then modified it to read that line and manipulate the data into the correct fields for koha. In addition our librarian wanted to move a couple of other fields around that had been misused in the past. I will attach my modified script to this with the caveat that it is extremely kludgy, as I kept revising it to handle this and that issue. You may want to generate a script from Marc Edit and start from scratch. You are free to use, modify, no guarantees, no support provided, etc. Once you get the Follett records converted into the koha format (mainly getting the item info into the 952 record), you can use the import tool in the staff client to bring them in. I would suggest breaking them into smaller pieces using marc breaker/maker, and importing those. The import can take a while and if it chokes on a particular record part way through you won't have one giant file to deal with. I wound up with a couple of records that didn't want to import, so removed them from the file and redid the import. I think we had to recatalog three records manually. (I could have done the troubleshooting, but it was quicker just to catalog them in). All in all this is pretty straight forward as migrations go. This project did take me weeks though, as I had limited experience with Linux and spent a lot of time getting up to speed on it. We also are running multiple databases, so I had to do a bit of work figuring that out (Merci Henri) and did a minor bit of customization to the look of things. My big hurdle though was getting the server set up with the basic koha install done. I did not install the zebra engine, as we have a small collection, so if you are doing that you have another layer of complexity. Good luck Ed. Best, Doug Note to list - The mail list server refused to post this because of the attached script file (good security). I am posting to the list without the attachment, if someone else wants a copy of the script email me with "Follett/Koha script" in the subject line and I will send it to you . Doug Dearden dearden(a)sarsf.org

1 0

PromptCat spine labels
by Rachel Hollis 11 Feb '09

11 Feb '09

Greetings colleagues, is anyone printing spine labels received via PromptCat in Koha? Would it be okay to talk to you about the process off-list? Thank you, Rachel Hollis, librarian Stevens-Henager College, Boise Idaho Campus This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.

1 0

Follett to Koha 3 Migration
by Ed Roche 11 Feb '09

11 Feb '09

Good Morning/Afternoon All Anyone who has migrated from Follett to Koha, would you happen to have documented how you did it? If so would you be willing to share? Thanks Ed Edward J. Roche Network Administrator Solanco School District -- View this message in context: http://www.nabble.com/Follett-to-Koha-3-Migration-tp21958260p21958260.html Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

9XX tags
by Cab Vinton 11 Feb '09

11 Feb '09

Hi, All -- We're still doing in the midst of our recon project & I'd like to do some batch editing of our MARC records before importing them into Koha. A few questions: What's the purpose of the 994 tag? Here are a few examples from existing records: 994 \\ $aX0 $bHSA 994 \\ $aC0 $bHSA 994 \\ $aE0 $bHSA Re: 952 subfields: I'm planning to omit data for the $0, $1, $4, & $7 subfields on the assumption that Koha will automatically leave these blank (or set to 0). Is this a safe assumption? The Item edit interface does not list the $6, $9 or $r subfields. Can someone explain the purpose of these, & whether it would be important/ helpful for me to do something with these before importing the records into Koha? Finally, I'm also assuming that Koha does not care about the order of the various subfields in each MARC record. Thank you, Cab Vinton, Director Sanbornton Public Library Sanbornton, NH

1 1

Re: [Koha] Import .mrc records
by Nicole Engard 11 Feb '09

11 Feb '09

If you want to change your Koha install to use Marc21 instead you just need to change the marcflavour system preference https://sites.google.com/a/liblime.com/koha-manual/Home/Table-of-Contents/a… --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com http://blogs.liblime.com/open-sesame/ On Tue, Feb 10, 2009 at 11:06 PM, Laura Johnson <lauraj(a)tcoek12.org> wrote: > Hello Nicole, > Thanks for giving me the information. After a little research, I realized > that my records are in Marc21,(see sample below) and I have installed Koha > using the Unimarc system. > > =LDR 00733ngm 2200169 4500 > =005 20030703081938.0 > =007 vuucuuuuu > =008 991123s1989\\\\\\\030 > =050 \\$bVC3193$c0 > =245 \\$aReading Rainbow: Dinosaur Bob and His Adventures With The Family > Lazardo$hVC > =260 \\$bGPN$c1989 > =300 \\$a30$bcol$e1 > =520 \\$aTells the story of how the Lazardo family befriends a baseball > playing dinosuar while on safari in Africa. Levar visits the Oakland > Athletics' spring training camp in Phoenix, Arizona, where he picks up > baseball tips from the pros. > =521 \\$aPrimary > =650 \\$aPHYSICAL EDUCATION > =650 \\$aLANGUAGE AND LITERATURE-CHILDREN'S LITERATURE > =999 \\$pVC319301$cMain Library$k01$r0.00$a01/01/1980$b12/31/2022$yVC3193 > > What is the best procedure to fix this issue? I have installed MarcEdit to > help convert the data. > > Thank you for your help! > Sincerely, > > Laura > -----Original Message----- > From: koha-bounces(a)lists.katipo.co.nz > [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Nicole Engard > Sent: Friday, January 30, 2009 4:25 AM > To: Laura Johnson > Cc: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Import .mrc records > > Looks to me like something didn't import right - or that the index > isn't fulling finished re-indexing. I'll leave answering your > import/search questions to the experts :) but I can point you to the > Koha 3.0 manual for training others to use Koha: > https://sites.google.com/a/liblime.com/koha-manual/ > > --- > > Nicole C. Engard > Open Source Evangelist, LibLime > (888) Koha ILS (564-2457) ext. 714 > nce(a)liblime.com > AIM/Y!/Skype: nengard > > http://liblime.com > http://blogs.liblime.com/open-sesame/ > > > > On Thu, Jan 29, 2009 at 5:41 PM, Laura Johnson <laura(a)tcoek12.org> wrote: >> Hello, >> >> >> >> I have installed Koha 3.00 on SUSE 10.3. I used the "staged records for >> import" tool and imported approximately 7,000 records (mainly Video >> Cassettes) on the web interface tools section. Then I clicked on the > "import >> records" button to import the records. >> >> >> >> When I type in a keyword under the search tool, I get the following > results. >> (below my questions) >> >> >> >> Is this typical response? >> >> >> >> Shouldn't I see the titles? >> >> >> >> Did I miss a step when importing the records? >> >> >> >> The records came from another library system called Media Minder that > lived >> on Win2000, but no longer in business. I have access to a .txt file and >> excel file, but thought the .mrc would be the best for importing. I used > the >> nonZebra program when installing Koha. >> >> >> >> Is there more information that I need to give you to help me with this? I > am >> fairly new linux and mysql. I do have some background with the Follett >> library software. >> >> >> >> What is the best document to use when training other people using koha? >> >> >> >> Thank you for your help. >> >> 5 result(s) found for 'robot'. (only copied 2 results for this email) >> >> >> Results >> >> Location >> >> 1. >> >> Description: >> >> ... Traces man's evolving, sometimes imaginative theories of Mars from its >> discovery centuries ago, all the way up to the soft landing of the Viking >> robot. ... >> >> No holds allowed >> >> No items >> >> 2. >> >> Description: >> >> ... USING MATHEMATICS: MATHEMATICS AND ROBOTICS ... Demonstrates how using >> geometry, estimation & calculation, helps us walk down busy streets > without >> running into others: and looks at the challenge of creating robots that > are >> able to use these same "human-like" skills. Looks at a new generation of >> robot users. ... >> >> No holds allowed >> >> >> >> >> >> >> >> Sincerely, >> >> >> >> Laura Johnson >> >> System Administrator and Health Assistant >> >> Trinity County Office of Education >> >> 201 Memorial Dr. >> >> P.O. Box 1256 >> >> Weaverville, CA 96093 >> >> www.tcoek12.org >> >> (530) 623-2861 ext236 >> >> (530 ) 623-4489 FAX >> >> >> >> _______________________________________________ >> Koha mailing list >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >> > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > >

1 0

importing mrc records
by Laura Johnson 11 Feb '09

11 Feb '09

Hello, I seem to be having a little trouble sending this email. Please confirm that you received this email. I am wondering if something is wrong with my email server at the office. Thank you! Hello Nicole, Thanks for giving me the information. After a little research, I realized that my records are in Marc21,(see sample below) and I have installed Koha using the Unimarc system. =LDR 00733ngm 2200169 4500 =005 20030703081938.0 =007 vuucuuuuu =008 991123s1989\\\\\\\030 =050 \\$bVC3193$c0 <file:///\\$bVC3193$c0> =245 \\$aReading <file:///\\$aReading> Rainbow: Dinosaur Bob and His Adventures With The Family Lazardo$hVC =260 \\$bGPN$c1989 <file:///\\$bGPN$c1989> =300 \\$a30$bcol$e1 <file:///\\$a30$bcol$e1> =520 \\$aTells <file:///\\$aTells> the story of how the Lazardo family befriends a baseball playing dinosuar while on safari in Africa. Levar visits the Oakland Athletics' spring training camp in Phoenix, Arizona, where he picks up baseball tips from the pros. =521 \\$aPrimary <file:///\\$aPrimary> =650 \\$aPHYSICAL <file:///\\$aPHYSICAL> EDUCATION =650 \\$aLANGUAGE <file:///\\$aLANGUAGE> AND LITERATURE-CHILDREN'S LITERATURE =999 \\$pVC319301$cMain <file:///\\$pVC319301$cMain> Library$k01$r0.00$a01/01/1980$b12/31/2022$yVC3193 What is the best procedure to fix this issue? I have installed MarcEdit to help convert the data. Thank you for your help! Sincerely, Laura -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Nicole Engard Sent: Friday, January 30, 2009 4:25 AM To: Laura Johnson Cc: koha(a)lists.katipo.co.nz Subject: Re: [Koha] Import .mrc records Looks to me like something didn't import right - or that the index isn't fulling finished re-indexing. I'll leave answering your import/search questions to the experts :) but I can point you to the Koha 3.0 manual for training others to use Koha: https://sites.google.com/a/liblime.com/koha-manual/ --- Nicole C. Engard Open Source Evangelist, LibLime (888) Koha ILS (564-2457) ext. 714 nce(a)liblime.com AIM/Y!/Skype: nengard http://liblime.com <http://liblime.com/> http://blogs.liblime.com/open-sesame/ On Thu, Jan 29, 2009 at 5:41 PM, Laura Johnson <laura(a)tcoek12.org> wrote: > Hello, > > > > I have installed Koha 3.00 on SUSE 10.3. I used the "staged records > for import" tool and imported approximately 7,000 records (mainly > Video > Cassettes) on the web interface tools section. Then I clicked on the "import > records" button to import the records. > > > > When I type in a keyword under the search tool, I get the following > results. (below my questions) > > > > Is this typical response? > > > > Shouldn't I see the titles? > > > > Did I miss a step when importing the records? > > > > The records came from another library system called Media Minder that > lived on Win2000, but no longer in business. I have access to a .txt > file and excel file, but thought the .mrc would be the best for > importing. I used the nonZebra program when installing Koha. > > > > Is there more information that I need to give you to help me with > this? I am fairly new linux and mysql. I do have some background with > the Follett library software. > > > > What is the best document to use when training other people using > koha? > > > > Thank you for your help. > > 5 result(s) found for 'robot'. (only copied 2 results for this email) > > > Results > > Location > > 1. > > Description: > > ... Traces man's evolving, sometimes imaginative theories of Mars from > its discovery centuries ago, all the way up to the soft landing of the > Viking robot. ... > > No holds allowed > > No items > > 2. > > Description: > > ... USING MATHEMATICS: MATHEMATICS AND ROBOTICS ... Demonstrates how > using geometry, estimation & calculation, helps us walk down busy > streets without running into others: and looks at the challenge of > creating robots that are able to use these same "human-like" skills. > Looks at a new generation of robot users. ... > > No holds allowed > > > > > > > > Sincerely, > > > > Laura Johnson > > System Administrator and Health Assistant > > Trinity County Office of Education > > 201 Memorial Dr. > > P.O. Box 1256 > > Weaverville, CA 96093 > > www.tcoek12.org > > (530) 623-2861 ext236 > > (530 ) 623-4489 FAX > > > > _______________________________________________ > Koha mailing list > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha Sincerely, Laura Johnson System Administrator and Health Assistant Trinity County Office of Education 201 Memorial Dr. P.O. Box 1256 Weaverville, CA 96093 www.tcoek12.org (530) 623-2861 ext236 (530 ) 623-4489 FAX

1 0

error when install koha 3.0 in ubuntu
by sahruddin sahari 10 Feb '09

10 Feb '09

hi, i already download koha 3.0 when i try to install by refer to http://www.blazingmoon.org/guides/k3-on-u810-5.html, the error was out like this : /build/koha-3.00.00/INSTALL bash: /build/koha-3.00.00/INSTALL: Permission denied

3 2

Re: [Koha] Setting up a machine as a lone station and searching by reading levels
by savitra sirohi 10 Feb '09

10 Feb '09

Darla, I don't believe Tag 521 is zebra searchable by default. Read this to see how to add make specific tags searchable. http://lists.katipo.co.nz/public/koha/2008-October/015763.html Regards, Savitra Sirohi Nucsoft OSS Labs www.osslabs.biz > > On Tue, Feb 10, 2009 at 12:41 AM, Rachel Hollis > <Rachel.Hollis(a)stevenshenager.edu> wrote: >> As a one-time cataloger providing public service through library biblios, I know that it is possible to set up a field so that it is searchable and/or a link. When I did it, I asked the systems librarian to make it happen. There's no systems librarian here; in Koha I believe you would go to your MARC Frameworks and edit subfields constraints for 521. Under display more constraints, there is a checkbox for "is a URL" and that should make your reading levels clickable to other biblios with the same text string. You could get fancy and use Authorized Values so that your staff have text strings from which to choose, this would also provide uniformity to that field. I hope this helps, >> >> Rachel Hollis, librarian >> Stevens-Henager College, Boise Idaho Campus >> >> -----Original Message----- >> From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of Darla Grediagin >> Sent: Friday, February 06, 2009 3:11 PM >> >> <snip> >> Second questions, I would like to have my reading levels be searchable. >> Can I set up MARC line 521 to be searchable or would I need to put these >> levels in as subject headings? >> >> These questions have become much too big for me and my little brain to >> think about for a Friday. I appreciate any help/insite someone would >> like to give. >> >> Have a good weekend >> >> Darla -- Who will be updating MARC records from now until the cows come >> Home. >> >> This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. >> _______________________________________________ >> Koha mailing list >> Koha(a)lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha >> >

1 0

Zebra indexing
by Lenora Oftedahl 09 Feb '09

09 Feb '09

Currently set to OFF is this correct? The description is a bit confusing. Also, what do others have in the NoZebraIndexes field? Or is this necessary if I'm using Zebra? Thanx. Lenora StreamNet Regional Librarian Columbia River Inter-Tribal Fish Commission

5 4

Unhiding subfields in a MARC framework
by Owen Leonard 09 Feb '09

09 Feb '09

I'm trying to edit one of our custom frameworks and I can't figure out how to ensure that one of the subfields is always visible. Right now 942$n only displays if there is data in it. I have to click the tag name to expand it. In the "Tag 942 Subfield Constraints" form under "Advanced constraints" it has hidden:0 which seems correct based on the online help: 0 => OPAC Intranet Editor !Collapsed But it is collapsed in the editor. Am I doing something wrong or is this a bug? Thanks, Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

3 4