Lars, Yes I am able to import data from a z3950 server. I'm very new to Koha and library software in general so my experience is limited. I tried about a half dozen different things and I don't remember everything I did. Of those things I'm sure only 1-2 had anything to do with my success! One change I remember making is setting the MARC type field for the LOC server to USMARC (it defaults to a NULL value). You may want to try doing this if you haven't already. For the record, here is what I get in the processz3950queue log file after a successful lookup : LOC ==> USMARC at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. LOC ==> answered : 1 found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 170. Processing isbn="0201648652" at LOC z3950.loc.gov:7090 voyager USMARC (1 forks) z3950.loc.gov:7090 done. If I decide to do a clean install again I will try to document exactly what I do to get things to run and send you the info. However I'm probably going to set this project aside for a little while and wait for a future release of Koha. I hope things work out for you! Chris On Fri, 2003-07-18 at 02:50, Lars Anderson wrote:
On Thu, Jul 17, 2003 at 12:39:02, Krzysztof Michalak wrote:
Hi Krzysztof,
I have expirienced exactly the same as you have described below, only I cannot seem to get the result into Koha, are you successfully importing data via Z3950?
When I do a search I can se the following in my log:
LOC ==> at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 156. LOC ==> answered : 1 found at /usr/local/koha/intranet/scripts/z3950daemon/processz3950queue line 170. Processing isbn="0201896842" at LOC z3950.loc.gov:7090 voyager (1 forks) z3950.loc.gov:7090 done.
But after that nothing happens.
I would love to hear how you got it working.
Best wishes, Lars
Thanks Jerome,
I actually did add the z3950random column to the table after posting my message yesterday. I did not add an encoding column, I guess I should do that too.
One other source of the problem I identified was that when a z3950 server has a space in it's name the script gets confused. This is particularly a problem since the default install has a server named "Library of Congress". To fix the problem I simply renamed it to LOC. I guess the problem arises from line 99 of processz3950queue :
foreach $serverinfo (split(/\s+/, $servers)) {
Things seem to work ok now.
Chris
On Wed, 2003-07-16 at 23:32, Jerome Vizcaino wrote:
On Wed, 2003-07-16 at 22:04, Krzysztof Michalak wrote:
Sorry to reply to my own message, but I wanted to add that I also get the following errors in the koha log :
[Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] search.pl : / / / at /usr/local/koha/intranet/cgi-bin/z3950/search.pl line 52.
The / / / means that the page failed to send the parameters (isbn/title/author if I remember correctly) to the z3950 script.
[Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] Q : Select id,file,isbn,title,author from marc_breeding where z3950random = "378733019.883843" at /usr/local/koha/intranet/modules/C4/Search.pm line 2429. [Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] DBD::mysql::st execute failed: Unknown column 'z3950random' in 'where clause' at /usr/local/koha/intranet/modules/C4/Search.pm line 2431.
This is due to an error in the database script creation. You'll have to add the z3950random column to your marc_breeding table.
In case I give you the command : ALTER TABLE marc_breeding ADD COLUMN z3950random varchar(30);
Also it seems the "encoding" column is missing too : ALTER TABLE marc_breeding ADD COLUMN encoding varchar(40);
[Wed Jul 16 13:01:10 2003] [error] [client 127.0.0.1] DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at /usr/local/koha/intranet/modules/C4/Search.pm line 2432.
Invalid SQL syntax => execute failed...
Hope that helps. Good luck.
Jerome
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha