- Koha - lists.katipo.co.nz

Breeding Resevoir/Migration Puzzle
by Bo Schafers 24 May '07

24 May '07

Hi again! The way I currently understand the data migration process in Koha is thus: - Create a compatible Marc21 file with the entries mapped to the MARC structure defined in Koha. This would- in our case- involve taking CSV data based data pulled out of Postgres and using a program called MarcEdit (found on the Net) to create one large Marc21 file. - This file can then be imported using bulkimport.pl on the server's command line or the 'Marc Aquisiton System' available in the Intranet. The data, when imported, is stored in the so-called 'resevoir'. - One then does a 'search exisisting records' by title or ISBN and can then click on 'add biblio' to import the item into Koha proper. This is how one proceeds with 1000's of records of a typical library? There seems to be no way one can actually browse the Breeding Resevoir /non biblio items to keep track of what's in there there, other than going into the database table directly via phpmyadmin? Have I understood this correctly? Just trying to get my head around the process. Sorry if it's in the documentation somewhere, but I have tried to read most of what's available on kohadocs.org and the above describes how I have interpreted the process, based on my situation. Do I have it all straight, before I proceed? Or have I misunderstood something? Any comments, hints,pointers MOST welcome! Bo

1 0

1.2.3->2.0->2.2.8
by Timothy R.Butler 22 May '07

22 May '07

Hi everyone, I posted a message last night, but it did not seem to make it on here, so I'll repost it abridged. Someone was kind enough to send me a copy of 2.0.0, and with it I was able to import the 1.2.3 data and I could actually see the books when I searched. I then upgraded from 2.0.0->2.2.8, and the search results are now blank once again (just as they were when going straight from 1.2.3->2.2.8). The only place I can see the books in 2.2.8's interface is in the catalogue by type report, which does show the tallies of different items. I cannot see the preferences page in 2.2.8 to change any settings (both the drop down menu for preferences and the actual preferences page have no settings /links to settings displayed on them). Also, Koha2marc.pl worked fine in 2.0.0, but continues to produce an error for each entry in 2.2.8: ---- Processing 121 DBD::mysql::st execute failed: Column 'frameworkcode' cannot be null at /home/stpauls/koha/ intranet/modules/C4/Biblio.pm line 343. Processing 122 DBD::mysql::st execute failed: Column 'frameworkcode' cannot be null at /home/stpauls/koha/ intranet/modules/C4/Biblio.pm line 343. Processing 123 DBD::mysql::st execute failed: Column 'frameworkcode' cannot be null at /home/stpauls/koha/ intranet/modules/C4/Biblio.pm line 343. Processing 124 DBD::mysql::st execute failed: Column 'frameworkcode' cannot be null at /home/stpauls/koha/ intranet/modules/C4/Biblio.pm line 343. Processing 125 DBD::mysql::st execute failed: Column 'frameworkcode' cannot be null at /home/stpauls/koha/ intranet/modules/C4/Biblio.pm line 343. Processing 126 DBD::mysql::st execute failed: Column 'frameworkcode' cannot be null at /home/stpauls/koha/ intranet/modules/C4/Biblio.pm line 343. ---- Any ideas? Thanks, Tim

1 0

Koha Virtual Appliance
by Jim Kronebusch 22 May '07

22 May '07

Does anyone have a koha installation built that could be used as a Virtual Appliance? With all of the installation problems I see it sure would be nice if someone could build a default koha installation with a default domain and users that could be distributed as a package to run under VMware. Jim Kronebusch Cotter Tech Department 453-5188 -- This message has been scanned for viruses and dangerous content by the Cotter Technology Department, and is believed to be clean.

4 3

KOHA VIRTUAL APPLIANCE -II
by Piet Slaghekke 22 May '07

22 May '07

Hello, We are trying to get KOHA at our school but don't have the $$ in our budget to get it set up or the know to do it our selves. I was wondering if there is a KOHA virtual appliance that would run with vmware. If there is not there is a site that will allow you to create an appliance called rbuilder: http://www.rpath.com/rbuilder/ It would be awesome if there was a KOHA appliance like this which would be easy to install and run. I would be willing to help any way I can, though I do not have the expertise to implement this project. Thanks, Piet Slaghekke -- View this message in context: http://www.nabble.com/KOHA-VIRTUAL-APPLIANCE--II-tf3797016.html#a10740190 Sent from the Koha - Discuss mailing list archive at Nabble.com.

1 0

Re: [Koha] Install on Mac OS X
by Chris Cormack 22 May '07

22 May '07

On 23/05/2007, at 12:07 AM, Dominic O'Toole wrote: > Chris - thanks for your swift response! > > I have tried with 2.2.8 and have downloaded 2.2.9 to see if it > makes a difference - but it doesn't! > > I have tried to install ZOOM from the NEt-Z3950-Zoom-1.18 - and get > the error message > > ERROR: Unable to call script: yaz-config > If you are using a YAZ installation from the Debian package "yaz", you > will also need to install "libyaz-dev" in order to build this module. > > Yet libyz-dev is a Debian file - and I am not sure how/if I can > install on OS X (10.4.9) Ah ha Yep you need ZOOM installed. The Debian bit is if you are installing on debian, since you aren't you can ignore that bit. What you need to do is get the source files for yaz from the indexdata.dk site and compile and install them. Then try installing the ZOOM perl module instead. Chris -- Chris Cormack chris.cormack(a)liblime.com VP Research and Development www.liblime.com LibLime +64 21 542 131

2 1

Install on Mac OS X
by Dominic O'Toole 22 May '07

22 May '07

I have tried installing Koha -but keep on getting the same error - even after downloading the perl files and installing them. Has anyone any ideas how I might get around this? Thanks You are missing some Perl modules required by Koha. Please run this again after installing them. They may be installed by finding packages from your operating system supplier, or running (as root) the following commands: perl -MCPAN -e 'install "ZOOM"' perl -MCPAN -e 'install "You will need PDF::Reuse::Barcode for the new barcode generator"' perl -MCPAN -e 'install "You will need Net::LDAP if you want to authentify patrons through a LDAP"'

2 1

Help exporting inventory to excel or access please
by Sandra Brook 21 May '07

21 May '07

Could anyone tell me if there is a way to export records from KOHA 2.2.5 to excel or access. I am the librarian at a (currently) small K-12 school in Cairo, Egypt, and am using KOHA 2.2.5 system and my assistant and I are generally quite happy with the system though we have 2 major problems, the first is in the inventory and stocktaking function. At the end of each school year we need to check our inventory, and this must be done manually. All of our almost 4000 records and 8000 items are added to the KOHA database... we need a solution to export the essential fields of Title, Author, Classification, Barcode, and Price to either excel or access. We do not as yet have a functioning bar code reader so entering each barcode will be extremely tedious. The second problem we face is the overdue item reports. We have a MAIN branch, and GUIDED READING branch, the report only gives the MAIN branch so so far we have had to manually check each of 300+ members individually! Is there a solution to this problem. Our IT department is Arabic speaking, if help can be given in Arabic it would be ideal - though assistance in English will also be very welcome. Many thanks in advance Sandra Brook

2 1

Continued 1.2.3 -> 2.x Migration Woes
by Timothy R.Butler 20 May '07

20 May '07

Hi everyone, I'm still trying to figure out how to get an old 1.2.3 database into a current version of Koha. I cannot locate 2.0.x anywhere, so I'm still working with 2.2.7. I'd be happy to go with a 2.0.x release if that would help and someone could point me to where that might be (it does not appear to be on SourceForge any longer). The problem is that while database updater seemed to run fine, and in reports, Koha shows 1,800+ books, it cannot bring them up when searching, whether by title, author, barcode, etc. I'm at a loss to what to do to get our data into some kind of usable form. I'd appreciate any insight someone might be able to give me. Thanks, Tim

4 6

upgrading Koha
by Robert Polidoro 20 May '07

20 May '07

Hello, Im trying to update Koha from 1.2.3 to 2.2.8, does anyone have any ideas on the best way to do this? I have already installed 2.2.8 on debian machine just for testing and i got it working fine, when i tried migrating the database over I ran into problems as my old 1.2.3 database was not complete enough for the 2.2.8 koha even when following an updating koha page (http://www.kohadocs.org/Updating_Koha.html#d0e285) Am I right in guessing that this is to big of a upgrade and that I should be going from 1.2.3 to something like 2.0? thanks, Robert Polidoro Judicial Commission of NSW This Message is intended for the addressee named and may contain confidential information. If you are not the intended recipient, please delete it and notify the sender. Views expressed in this message are those of the individual sender and not necessarily the views of the Judicial Commission of NSW.

2 1

Help! Error creating a new non-marc record
by Maneesh Sharma 20 May '07

20 May '07

hi, I just installed koha on windows. When I go to add my first book into the catalog (I've enabled non-marc) , I get the following error in the log (500 internal server error) [Mon May 21 11:17:58 2007] [error] [client 127.0.0.1] Premature end of script headers: additem-nomarc.pl, referer: http://intranet/cgi-bin/koha/acqui.simple/addbiblio-nomarc.pl?isbn=97801402… [Mon May 21 11:17:58 2007] [error] [client 127.0.0.1] HTML::Template->new() : Cannot open included file acquisitions-bottom.inc : file not found. at C:/usr/site/lib/HTML/Template.pm line 2264., referer: http://intranet/cgi-bin/koha/acqui.simple/addbiblio-nomarc.pl?isbn=97801402… The file acquisitions-bottom.inc is definitely there where it is supposed to be. can someone help me in identifying what the problem is! I am new to koha & installed it just 30 minutes back & have run into this problem. Need help please regards Maneesh

1 0