- Koha-devel - lists.koha-community.org

Some bugs maybe, or not understanding it right....
by Klaus Weidenbach 03 Feb '05

03 Feb '05

Heihei, I think there is a little bug that results in a dead link. If I open the "View Patron's Reading Record" I can click on its name on that page to get more info about this user, but it is a dead link to the not existing (404) file "/cgi-bin/koha/moremember.pl". I think it should be: "/cgi-bin/koha/members/moremember.pl". I have problems logging into the "Library Catalog", because I am getting always the error that my card number is invalid. Which card number do I have to enter there? I think it is bit strange or confusing if you can enter values for Card Number in "Update Patron Details" page that are not valid in the "Library Catalog" by the JavaScript "ValidateCode()" function. Which password and UserID do I change under the Patrons Detail page and "Change Password", btw? Are they used for the Koha Intranet only? Thank you very much! Regards, Klaus -- take care! xo,klaus

2 1

Where we should add this function ?
by Andrés Tarallo 03 Feb '05

03 Feb '05

Our Librarians discovered that: when you're in the OPAC Search, when you enter in the ISBD detail (at least in the OPAC) those fields that have authorized values aren't displayed propoerly. To clarify this: When you display a certain field that has an authorized valued you get the key, not the value. We developed a function that "notices" that a field has authorized values and returns the proper value or does nothing. We want to to contribute back this function to the project, In which module should we add this function? Thanks Andres PD: We'll be on leave till Janury 17th.

3 2

Re: [Koha-devel] General OPAC Inside page...
by Owen Leonard 03 Feb '05

03 Feb '05

All in all it looks great, Rachel. I want mention one quick thing right away, though: I think the 'clear' button form control is usually useless and often harmful. The aggravation of clearing a form you've painstakingly filled out far outweighs the convenience of being able to clear a form. I would recommend leaving it out of any future Koha template. Just my $.02, Owen

3 2

Plugin patches
by Ernesto Silva - Webmaster 03 Feb '05

03 Feb '05

Paul, 2 things: A) we had some troubles with plugins, specifically the paths. These may be two possible patches: /*******************************************************************************/ --- /usr/local/koha2/intranet/cgi-bin/acqui.simple/addbiblio.pl 2005-01-19 10:09:02.304408216 -0300 +++ addbiblio.pl 2005-01-24 17:40:36.637461064 -0300 @@ -179,7 +179,7 @@ $subfield_data{marc_value}="<input type=\"text\" name=\"field_value\" value=\"$value\" size=\"47\" maxlength=\"255\" DISABLE READONLY> <a href=\"javascript:Dopop('../authorities/auth_finder.pl?category=".$tagslib->{$tag}->{$subfield}->{authtypecode}."&index=$i',$i)\">...</a>"; # it's a plugin field } elsif ($tagslib->{$tag}->{$subfield}->{'value_builder'}) { - my $plugin="../value_builder/".$tagslib->{$tag}->{$subfield}->{'value_builder'}; + my $plugin=C4::Context->config('intranetdir')."/cgi-bin/value_builder/".$tagslib->{$tag}->{$subfield}->{'value_builder'}; require $plugin; my $extended_param = plugin_parameters($dbh,$rec,$tagslib,$i,$tabloop); my ($function_name,$javascript) = plugin_javascript($dbh,$rec,$tagslib,$i,$tabloop); @@ -495,4 +495,4 @@ frameworkcode => $frameworkcode, itemtype => $frameworkcode # HINT: if the library has itemtype = framework, itemtype is auto filled ! ); -output_html_with_http_headers $input, $cookie, $template->output; \ No newline at end of file +output_html_with_http_headers $input, $cookie, $template->output; /*******************************************************************************/ --- /usr/local/koha2/intranet/cgi-bin/plugin_launcher.pl 2005-01-19 10:09:02.315406544 -0300 +++ plugin_launcher.pl 2005-01-24 17:44:32.273638920 -0300 @@ -28,6 +28,6 @@ my $input = new CGI; my $plugin_name=$input->param("plugin_name"); -my $plugin_name="value_builder/".$input->param("plugin_name"); +my $plugin_name=C4::Context->config('intranetdir')."/cgi-bin/value_builder/".$input->param("plugin_name"); require $plugin_name; &plugin($input); /*******************************************************************************/ B) In "intranet/cgi-bin/acqui.simple/addbiblio.pl" there's this line(184): my $extended_param = plugin_parameters($dbh,$rec,$tagslib,$i,$tabloop); which I supouse is for sending extra parameters to the plugin, but the $extended_param variable isn't used anywhere else, any ideas? should I modify the line that generates the javascript link to plugin_launcher.pl and add the extra parameters? Regards Ernesto.

2 1

Bug-Fixes-improvment forContext.pm
by Andrés Tarallo 03 Feb '05

03 Feb '05

Today we'were fighting against a weird behaviour of our koha instalation. Finally we found what was hapenning: somebody change the owner of /etc/koha.conf. I've added a Warning that lets us guess were the problem cames from. Andres --- /usr/local/koha2/intranet/modules/C4/Context.pm 2005-01-19 10:09:02.365398944 -0300 +++ Context.pm 2005-01-24 16:40:37.043682496 -0300 @@ -19,8 +19,9 @@ # Revision History: # 2004-08-11 A. Tarallo: Added the function db_escheme2dbi, tested my bugfixes, # further details about them in the code. -# 2004-11-23 A. Tarallo, E. Silva: Bugfixes for running in a mod_perl environment. -# Clean up of previous bugfixes, better documentation of what was done. +# 2004-11-23 A. Tarallo, E. Silva: Bugfixes for running in a mod_perl +# environment.Clean up of previous bugfixes, better documentation of what was +# done. package C4::Context; use strict; @@ -226,6 +227,10 @@ # Load the desired config file. $self->{"config"} = &read_config_file($conf_fname); + # A. Tarallo 2005-01-24: You can work with an empty config. + # This warning might help you to find that this is the origin of + # many weird problems. + warn "read_config_file($conf_fname) returned undef" if !defined($self->{"config"}); return undef if !defined($self->{"config"}); $self->{"dbh"} = undef; # Database handle

2 1

RE: [Koha-devel] request bulkmarcimport assistance -- an answer, I think
by Bruffey, Mark 03 Feb '05

03 Feb '05

I believe I have at least part of the answer. Because I am using conf files named something other than /etc/koha.conf, the file context.pm needs to know the exact conf filename in line 97. Setting this parameter _appears_ to be sufficient to get the db files in the correct directory. Now I'll have to see if I can get the data stored where I want it by using a symbolic link for each data directory. Don't know if mysql will be too happy about that, but i will try it and report success or failure. Thanks again for all pointers. Mark > -----Original Message----- > From: koha-devel-admin(a)lists.sourceforge.net > [mailto:koha-devel-admin@lists.sourceforge.net] On Behalf Of > Bruffey, Mark > Sent: Wednesday, February 02, 2005 1:47 PM > To: Joshua Ferraro > Cc: Joshua Ferraro; koha-devel(a)lists.sourceforge.net > Subject: RE: [Koha-devel] request bulkmarcimport assistance > > > I did not choose to enable SELinux when I installed FC3, so I > think I can get around that issue. However, I suppose I could > make a soft link from /var/lib/mysql/csl and > /var/lib/mysql/cslr to the spot where I actually want the > data (for the curious, I want it on a different physical > drive--space issues). This still leaves me hoping > bulkmarcimport.pl will actually put the data in the correct > place. I'll try Stephen's suggestions. Mark > > [Apologies for my previous email reply syntax deviations.] > > > -----Original Message----- > > From: Joshua Ferraro [mailto:jferraro@athenscounty.lib.oh.us] > > Sent: Wednesday, February 02, 2005 1:27 PM > > To: Bruffey, Mark > > Cc: Joshua Ferraro; koha-devel(a)lists.sourceforge.net > > Subject: Re: [Koha-devel] request bulkmarcimport assistance > > > > > > On Wed, Feb 02, 2005 at 01:00:37PM -0600, Bruffey, Mark wrote: > > > Hi Joshua! I have tried to respond below so that you may > be able to > > > figure out where I am in the process. I have tried to be somewhat > > > detailed; I hope this is appropriate. > > Sure is ... the more detail the better ... one note though, > > standard reply syntax is to use > for the message you're > > replying to and nothing for your new comments fyi. This > > makes it a bit easier to parse through. See my comments below. > > > > > ### I understand. [I have /var/lib/mysql/csl and > > /var/lib/mysql/cslr > > > and wish to relocate them to /csl/anydir1 and /csl/anydir2 ; see > > > below] > > > > > > ### I have done this. [/etc/koha-csl.conf and > > /etc/koha-cslr.conf as > > > well as /etc/koha-httpd-csl.conf and > /etc/httpd-cslr.conf, pointing > > > properly, I think, since I can call up both user interfaces > > and both > > > admin interfaces on the net at the designated ip adddresses. > > > > > > ### I think I have gotten the initial dual setup done > > "properly" but, > > > as you say, some customization remains. For me this appears > > to entail > > > getting koha to import marc records to a dir specified by me > > > [/csl/anydir1 or /csl/anydir2] and getting and koha and/or mysql > > > (maybe just mysql?) to look for the data in the that location > > > specified by me, not in /var/lib/mysql/csl or > > /var/lib/mysql/cslr as > > > the case may be. There MUST be a config file with these paths or > > > variable to them somewhere; I'm just not sure where to look. > > Especially since you're running FC3 this is a bad idea (it > > will really > > annoy SElinux). In general, I'd recommend keeping the > > standard database directory that mysql uses. > > > > > > > > ### There's one other issue that I think is important. When > > I ran the > > > bulkmarcimport.pl from the /csl/koha/_"csl"_ directory, the > > data ended > > > up in the /var/lib/mysql/_"cslr"_ directory. "cslr" was the > > _second_ > > > of the two install routines I did, so this leads me to > believe that > > > bulkmarcimport.pl, no matter the dir in which it is executed, is > > > running in the same "context" [?]. What files does > > bulkmarcimport.pl > > > look at? > > I suspect that your second install overwrote or appended the > > path variables so a command like the one Stephen suggested > > might work. You should also make sure that your installation > > is actually using the right koha.conf file and not another > > one (check for /etc/koha.conf for instance). > > > > Joshua > > > > > > > > ### Sincere thanks for your assistance. Mark ### > > > > > > > > > For instance, afaik Koha will always put the koha.conf file > > in /etc. > > > Just copy that file to wherever you want to store it and > > update your > > > koha-httpd.conf accordingly. > > > > > > Hope that helps, > > > > > > Joshua > > > > > > On Wed, Feb 02, 2005 at 12:34:14PM -0500, Stephen Hedges wrote: > > > > Mark, I could be wrong about this (and if I am, I hope someone > > > > corrects me quickly!), but if you have two installs, I > > assume you have > > > > > > > two different paths to Koha: something like > /usr/local/koha and > > > > /usr/local/koha2. So if you change the PERL5LIB > > environment variable > > > > accordingly, you should be able to control where the data goes, > > > > because Koha will grab the appropriate "context" from the > > path you > > > > specify. You might do: # export > > > > PERL5LIB=/usr/local/koha/intranet/modules > > > > to load records in one install, and > > > > # export PERL5LIB=/usr/local/koha2/intranet/modules > > > > to load records into the other install. > > > > You'd need to take out any "use lib > > > "/usr/local/koha/intranet/modules";" > > > > statement that you might have added to bulkmarcimport.pl > > > > > > > > Stephen > > > > > > > > Bruffey, Mark said: > > > > > Thanks for your assistance Stephen. The routine ran fine, but, > > > > > since > > > > > > > > I have two installs I am trying to keep separate, I > > need a way to > > > > > designate where the data will go. It appears that the > data path > > > > > defaults to /var/lib/mysql/variablename. I need to > > designate two > > > > > separate data paths, preferably not as a subdir of > > /var/lib/mysql, > > > > > and have my two instances of KOHA be able to find the > > right set of > > > > > data. Is this possible? If so, what do I need to do to > > implement > > > > > this change? Sincere thanks, Mark > > > > > > > > > > -----Original Message----- > > > > > From: Stephen Hedges [mailto:shedges@skemotah.com] > > > > > Sent: Saturday, January 29, 2005 8:08 AM > > > > > To: Bruffey, Mark > > > > > Cc: koha-devel(a)lists.sourceforge.net > > > > > Subject: Re: [Koha-devel] request bulkmarcimport assistance > > > > > > > > > > > > > > > Mark, could it be that your perl can't find the Koha C4 > > directory? > > > > > (Although that usually produces a different error.) Try this: > > > > > > > > > > Before you run "./bulkmarcimport.pl", export the > > directory where > > > > > C4 > > > > > resides: # export PERL5LIB=/usr/local/koha/intranet/modules > > > > > (that's the normal directory for most installs, change > > it if yours > > > > > is > > > > > different.) > > > > > > > > > > Or if you use bulkmarcimport a lot, add this line to > the list of > > > > > "use" statements at the beginning of the script: use lib > > > > > "/usr/local/koha/intranet/modules"; > > > > > > > > > > Stephen > > > > > > > > > > Bruffey, Mark said: > > > > >> I'm getting the following error when attempting to run > > > > >> bulkmarcimport.pl: > > > > >> > > > > >> BEGIN failed--compilation aborted at > > ./bulkmarcimport.pl line 10. > > > > >> > > > > >> It seems like I had a similar problem when I imported records > > > > >> some > > > > >> months ago, but, of course, I do not appear to have > > documented the > > > > >> solution to it . . . . > > > > >> > > > > >> Sincere thanks for any assistance. > > > > >> > > > > >> Mark > > > > >> > > > > >> L. Mark Bruffey > > > > >> Director Library Services > > > > >> Central Baptist Theological Seminary > > > > >> 900 Forestview Lane N > > > > >> Plymouth MN 55441 > > > > >> 763 417 8264 > > > > >> > > > > >> mbruffey(a)centralseminary.edu > > > > >> <mailto:mbruffey@centralseminary.edu> > > > > >> > > > > >> Central Seminary www.centralseminary.edu > > > > >> <http://www.centralseminary.edu> Fourth Baptist Church > > > > >> www.fourthbaptist.org <http://www.fourthbaptist.org> > > WCTS Radio AM > > > > >> 1030 Online www.centralseminary.edu/wcts > > > > >> <http://www.centralseminary.edu/wcts> > > > > > > > > -- > > > > Stephen Hedges > > > > Skemotah Solutions, USA > > > > www.skemotah.com -- shedges(a)skemotah.com > > > > > > > > > > > > ------------------------------------------------------- > > > > This SF.Net email is sponsored by: IntelliVIEW -- Interactive > > > > Reporting Tool for open source databases. Create > > drag-&-drop reports. > > > > Save time by over 75%! Publish reports on the web. Export > > to DOC, XLS, > > > > > > > RTF, etc. Download a FREE copy at > > > > http://www.intelliview.com/go/osdn_nl > > > > _______________________________________________ > > > > Koha-devel mailing list > > > > Koha-devel(a)lists.sourceforge.net > > > > https://lists.sourceforge.net/lists/listinfo/koha-devel > > > > > > > > > ------------------------------------------------------- > > > This SF.Net email is sponsored by: IntelliVIEW -- Interactive > > > Reporting Tool for open source databases. Create > > drag-&-drop reports. > > > Save time by over 75%! Publish reports on the web. Export > > to DOC, XLS, > > > RTF, etc. Download a FREE copy at > > > http://www.intelliview.com/go/osdn_nl > > > _______________________________________________ > > > Koha-devel mailing list > > > Koha-devel(a)lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/koha-devel > > > > > > > > > ------------------------------------------------------- > > > This SF.Net email is sponsored by: IntelliVIEW -- Interactive > > > Reporting Tool for open source databases. Create > > drag-&-drop reports. > > > Save time by over 75%! Publish reports on the web. Export > > to DOC, XLS, > > > RTF, etc. Download a FREE copy at > > > http://www.intelliview.com/go/osdn_nl > > > _______________________________________________ > > > Koha-devel mailing list > > > Koha-devel(a)lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/koha-devel > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IntelliVIEW -- Interactive > Reporting > Tool for open source databases. Create drag-&-drop reports. Save time > by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. > Download a FREE copy at http://www.intelliview.com/go/osdn_nl > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/koha-devel >

2 1

How delete records?
by Bruffey, Mark 03 Feb '05

03 Feb '05

I want to delete all the records from the database with which I'm experimenting. How do I do that? Thanks, Mark

3 2

RE: [Koha-devel] request bulkmarcimport assistance
by Bruffey, Mark 02 Feb '05

02 Feb '05

I did not choose to enable SELinux when I installed FC3, so I think I can get around that issue. However, I suppose I could make a soft link from /var/lib/mysql/csl and /var/lib/mysql/cslr to the spot where I actually want the data (for the curious, I want it on a different physical drive--space issues). This still leaves me hoping bulkmarcimport.pl will actually put the data in the correct place. I'll try Stephen's suggestions. Mark [Apologies for my previous email reply syntax deviations.] > -----Original Message----- > From: Joshua Ferraro [mailto:jferraro@athenscounty.lib.oh.us] > Sent: Wednesday, February 02, 2005 1:27 PM > To: Bruffey, Mark > Cc: Joshua Ferraro; koha-devel(a)lists.sourceforge.net > Subject: Re: [Koha-devel] request bulkmarcimport assistance > > > On Wed, Feb 02, 2005 at 01:00:37PM -0600, Bruffey, Mark wrote: > > Hi Joshua! I have tried to respond below so that you may be able to > > figure out where I am in the process. I have tried to be somewhat > > detailed; I hope this is appropriate. > Sure is ... the more detail the better ... one note though, > standard reply syntax is to use > for the message you're > replying to and nothing for your new comments fyi. This > makes it a bit easier to parse through. See my comments below. > > > ### I understand. [I have /var/lib/mysql/csl and > /var/lib/mysql/cslr > > and wish to relocate them to /csl/anydir1 and /csl/anydir2 ; see > > below] > > > > ### I have done this. [/etc/koha-csl.conf and > /etc/koha-cslr.conf as > > well as /etc/koha-httpd-csl.conf and /etc/httpd-cslr.conf, pointing > > properly, I think, since I can call up both user interfaces > and both > > admin interfaces on the net at the designated ip adddresses. > > > > ### I think I have gotten the initial dual setup done > "properly" but, > > as you say, some customization remains. For me this appears > to entail > > getting koha to import marc records to a dir specified by me > > [/csl/anydir1 or /csl/anydir2] and getting and koha and/or mysql > > (maybe just mysql?) to look for the data in the that location > > specified by me, not in /var/lib/mysql/csl or > /var/lib/mysql/cslr as > > the case may be. There MUST be a config file with these paths or > > variable to them somewhere; I'm just not sure where to look. > Especially since you're running FC3 this is a bad idea (it > will really > annoy SElinux). In general, I'd recommend keeping the > standard database directory that mysql uses. > > > > > ### There's one other issue that I think is important. When > I ran the > > bulkmarcimport.pl from the /csl/koha/_"csl"_ directory, the > data ended > > up in the /var/lib/mysql/_"cslr"_ directory. "cslr" was the > _second_ > > of the two install routines I did, so this leads me to believe that > > bulkmarcimport.pl, no matter the dir in which it is executed, is > > running in the same "context" [?]. What files does > bulkmarcimport.pl > > look at? > I suspect that your second install overwrote or appended the > path variables so a command like the one Stephen suggested > might work. You should also make sure that your installation > is actually using the right koha.conf file and not another > one (check for /etc/koha.conf for instance). > > Joshua > > > > > ### Sincere thanks for your assistance. Mark ### > > > > > > For instance, afaik Koha will always put the koha.conf file > in /etc. > > Just copy that file to wherever you want to store it and > update your > > koha-httpd.conf accordingly. > > > > Hope that helps, > > > > Joshua > > > > On Wed, Feb 02, 2005 at 12:34:14PM -0500, Stephen Hedges wrote: > > > Mark, I could be wrong about this (and if I am, I hope someone > > > corrects me quickly!), but if you have two installs, I > assume you have > > > > > two different paths to Koha: something like /usr/local/koha and > > > /usr/local/koha2. So if you change the PERL5LIB > environment variable > > > accordingly, you should be able to control where the data goes, > > > because Koha will grab the appropriate "context" from the > path you > > > specify. You might do: # export > > > PERL5LIB=/usr/local/koha/intranet/modules > > > to load records in one install, and > > > # export PERL5LIB=/usr/local/koha2/intranet/modules > > > to load records into the other install. > > > You'd need to take out any "use lib > > "/usr/local/koha/intranet/modules";" > > > statement that you might have added to bulkmarcimport.pl > > > > > > Stephen > > > > > > Bruffey, Mark said: > > > > Thanks for your assistance Stephen. The routine ran fine, but, > > > > since > > > > > > I have two installs I am trying to keep separate, I > need a way to > > > > designate where the data will go. It appears that the data path > > > > defaults to /var/lib/mysql/variablename. I need to > designate two > > > > separate data paths, preferably not as a subdir of > /var/lib/mysql, > > > > and have my two instances of KOHA be able to find the > right set of > > > > data. Is this possible? If so, what do I need to do to > implement > > > > this change? Sincere thanks, Mark > > > > > > > > -----Original Message----- > > > > From: Stephen Hedges [mailto:shedges@skemotah.com] > > > > Sent: Saturday, January 29, 2005 8:08 AM > > > > To: Bruffey, Mark > > > > Cc: koha-devel(a)lists.sourceforge.net > > > > Subject: Re: [Koha-devel] request bulkmarcimport assistance > > > > > > > > > > > > Mark, could it be that your perl can't find the Koha C4 > directory? > > > > (Although that usually produces a different error.) Try this: > > > > > > > > Before you run "./bulkmarcimport.pl", export the > directory where > > > > C4 > > > > resides: # export PERL5LIB=/usr/local/koha/intranet/modules > > > > (that's the normal directory for most installs, change > it if yours > > > > is > > > > different.) > > > > > > > > Or if you use bulkmarcimport a lot, add this line to the list of > > > > "use" statements at the beginning of the script: use lib > > > > "/usr/local/koha/intranet/modules"; > > > > > > > > Stephen > > > > > > > > Bruffey, Mark said: > > > >> I'm getting the following error when attempting to run > > > >> bulkmarcimport.pl: > > > >> > > > >> BEGIN failed--compilation aborted at > ./bulkmarcimport.pl line 10. > > > >> > > > >> It seems like I had a similar problem when I imported records > > > >> some > > > >> months ago, but, of course, I do not appear to have > documented the > > > >> solution to it . . . . > > > >> > > > >> Sincere thanks for any assistance. > > > >> > > > >> Mark > > > >> > > > >> L. Mark Bruffey > > > >> Director Library Services > > > >> Central Baptist Theological Seminary > > > >> 900 Forestview Lane N > > > >> Plymouth MN 55441 > > > >> 763 417 8264 > > > >> > > > >> mbruffey(a)centralseminary.edu > > > >> <mailto:mbruffey@centralseminary.edu> > > > >> > > > >> Central Seminary www.centralseminary.edu > > > >> <http://www.centralseminary.edu> Fourth Baptist Church > > > >> www.fourthbaptist.org <http://www.fourthbaptist.org> > WCTS Radio AM > > > >> 1030 Online www.centralseminary.edu/wcts > > > >> <http://www.centralseminary.edu/wcts> > > > > > > -- > > > Stephen Hedges > > > Skemotah Solutions, USA > > > www.skemotah.com -- shedges(a)skemotah.com > > > > > > > > > ------------------------------------------------------- > > > This SF.Net email is sponsored by: IntelliVIEW -- Interactive > > > Reporting Tool for open source databases. Create > drag-&-drop reports. > > > Save time by over 75%! Publish reports on the web. Export > to DOC, XLS, > > > > > RTF, etc. Download a FREE copy at > > > http://www.intelliview.com/go/osdn_nl > > > _______________________________________________ > > > Koha-devel mailing list > > > Koha-devel(a)lists.sourceforge.net > > > https://lists.sourceforge.net/lists/listinfo/koha-devel > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by: IntelliVIEW -- Interactive > > Reporting Tool for open source databases. Create > drag-&-drop reports. > > Save time by over 75%! Publish reports on the web. Export > to DOC, XLS, > > RTF, etc. Download a FREE copy at > > http://www.intelliview.com/go/osdn_nl > > _______________________________________________ > > Koha-devel mailing list > > Koha-devel(a)lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/koha-devel > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by: IntelliVIEW -- Interactive > > Reporting Tool for open source databases. Create > drag-&-drop reports. > > Save time by over 75%! Publish reports on the web. Export > to DOC, XLS, > > RTF, etc. Download a FREE copy at > > http://www.intelliview.com/go/osdn_nl > > _______________________________________________ > > Koha-devel mailing list > > Koha-devel(a)lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/koha-devel >

1 0

RE: [Koha-devel] request bulkmarcimport assistance
by Bruffey, Mark 02 Feb '05

02 Feb '05

Hi Joshua! I have tried to respond below so that you may be able to figure out where I am in the process. I have tried to be somewhat detailed; I hope this is appropriate. -----Original Message----- From: koha-devel-admin(a)lists.sourceforge.net [mailto:koha-devel-admin@lists.sourceforge.net] On Behalf Of Joshua Ferraro Sent: Wednesday, February 02, 2005 11:59 AM To: koha-devel(a)lists.sourceforge.net Subject: Re: [Koha-devel] request bulkmarcimport assistance Mark, The path /var/lib/mysql/"anything" refers to the database itself. ### I understand. [I have /var/lib/mysql/csl and /var/lib/mysql/cslr and wish to relocate them to /csl/anydir1 and /csl/anydir2 ; see below] The way to distinguish between two koha installs (provided that you want the database to be different for them) is to specify a different database name for each of them (for instance, koha1 and koha2). ### I have done this. [csl and cslr] You'll also probably want to use a different admin account for ease of administration (e.g., kohaadmin1, kohaadmin2). ### I have done this. You will also want to keep the koha paths different for those two installs (e.g., /usr/local/koha1, /usr/local/koha2), ### I have done this. [/csl/koha/csl and /csl/koha/cslr] as well as have a seperate koha.conf file for each of them (e.g., /usr/local/koha1/etc/koha.conf, /usr/local/koha2/etc/koha.conf). ### I have done this. [/etc/koha-csl.conf and /etc/koha-cslr.conf as well as /etc/koha-httpd-csl.conf and /etc/httpd-cslr.conf, pointing properly, I think, since I can call up both user interfaces and both admin interfaces on the net at the designated ip adddresses. The fastest way to do this is during the initial installation of Koha, when it asks you those specific questions, though it would be possible to set it up later on. Of course, the install is not really setup to handle multiple installations so you'll still need to customize some things once you have run both installations. ### I think I have gotten the initial dual setup done "properly" but, as you say, some customization remains. For me this appears to entail getting koha to import marc records to a dir specified by me [/csl/anydir1 or /csl/anydir2] and getting and koha and/or mysql (maybe just mysql?) to look for the data in the that location specified by me, not in /var/lib/mysql/csl or /var/lib/mysql/cslr as the case may be. There MUST be a config file with these paths or variable to them somewhere; I'm just not sure where to look. ### There's one other issue that I think is important. When I ran the bulkmarcimport.pl from the /csl/koha/_"csl"_ directory, the data ended up in the /var/lib/mysql/_"cslr"_ directory. "cslr" was the _second_ of the two install routines I did, so this leads me to believe that bulkmarcimport.pl, no matter the dir in which it is executed, is running in the same "context" [?]. What files does bulkmarcimport.pl look at? ### Sincere thanks for your assistance. Mark ### For instance, afaik Koha will always put the koha.conf file in /etc. Just copy that file to wherever you want to store it and update your koha-httpd.conf accordingly. Hope that helps, Joshua On Wed, Feb 02, 2005 at 12:34:14PM -0500, Stephen Hedges wrote: > Mark, I could be wrong about this (and if I am, I hope someone > corrects me quickly!), but if you have two installs, I assume you have > two different paths to Koha: something like /usr/local/koha and > /usr/local/koha2. So if you change the PERL5LIB environment variable > accordingly, you should be able to control where the data goes, > because Koha will grab the appropriate "context" from the path you > specify. You might do: # export > PERL5LIB=/usr/local/koha/intranet/modules > to load records in one install, and > # export PERL5LIB=/usr/local/koha2/intranet/modules > to load records into the other install. > You'd need to take out any "use lib "/usr/local/koha/intranet/modules";" > statement that you might have added to bulkmarcimport.pl > > Stephen > > Bruffey, Mark said: > > Thanks for your assistance Stephen. The routine ran fine, but, since > > I have two installs I am trying to keep separate, I need a way to > > designate where the data will go. It appears that the data path > > defaults to /var/lib/mysql/variablename. I need to designate two > > separate data paths, preferably not as a subdir of /var/lib/mysql, > > and have my two instances of KOHA be able to find the right set of > > data. Is this possible? If so, what do I need to do to implement > > this change? Sincere thanks, Mark > > > > -----Original Message----- > > From: Stephen Hedges [mailto:shedges@skemotah.com] > > Sent: Saturday, January 29, 2005 8:08 AM > > To: Bruffey, Mark > > Cc: koha-devel(a)lists.sourceforge.net > > Subject: Re: [Koha-devel] request bulkmarcimport assistance > > > > > > Mark, could it be that your perl can't find the Koha C4 directory? > > (Although that usually produces a different error.) Try this: > > > > Before you run "./bulkmarcimport.pl", export the directory where C4 > > resides: # export PERL5LIB=/usr/local/koha/intranet/modules > > (that's the normal directory for most installs, change it if yours > > is > > different.) > > > > Or if you use bulkmarcimport a lot, add this line to the list of > > "use" statements at the beginning of the script: use lib > > "/usr/local/koha/intranet/modules"; > > > > Stephen > > > > Bruffey, Mark said: > >> I'm getting the following error when attempting to run > >> bulkmarcimport.pl: > >> > >> BEGIN failed--compilation aborted at ./bulkmarcimport.pl line 10. > >> > >> It seems like I had a similar problem when I imported records some > >> months ago, but, of course, I do not appear to have documented the > >> solution to it . . . . > >> > >> Sincere thanks for any assistance. > >> > >> Mark > >> > >> L. Mark Bruffey > >> Director Library Services > >> Central Baptist Theological Seminary > >> 900 Forestview Lane N > >> Plymouth MN 55441 > >> 763 417 8264 > >> > >> mbruffey(a)centralseminary.edu <mailto:mbruffey@centralseminary.edu> > >> > >> Central Seminary www.centralseminary.edu > >> <http://www.centralseminary.edu> Fourth Baptist Church > >> www.fourthbaptist.org <http://www.fourthbaptist.org> WCTS Radio AM > >> 1030 Online www.centralseminary.edu/wcts > >> <http://www.centralseminary.edu/wcts> > > -- > Stephen Hedges > Skemotah Solutions, USA > www.skemotah.com -- shedges(a)skemotah.com > > > ------------------------------------------------------- > This SF.Net email is sponsored by: IntelliVIEW -- Interactive > Reporting Tool for open source databases. Create drag-&-drop reports. > Save time by over 75%! Publish reports on the web. Export to DOC, XLS, > RTF, etc. Download a FREE copy at > http://www.intelliview.com/go/osdn_nl > _______________________________________________ > Koha-devel mailing list > Koha-devel(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/koha-devel ------------------------------------------------------- This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting Tool for open source databases. Create drag-&-drop reports. Save time by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc. Download a FREE copy at http://www.intelliview.com/go/osdn_nl _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-devel

2 1

RE: [Koha-devel] request bulkmarcimport assistance
by Bruffey, Mark 02 Feb '05

02 Feb '05

-----Original Message----- From: Stephen Hedges [mailto:shedges@skemotah.com] Sent: Wednesday, February 02, 2005 11:34 AM To: Bruffey, Mark Cc: koha-devel(a)lists.sourceforge.net Subject: RE: [Koha-devel] request bulkmarcimport assistance Mark, I could be wrong about this (and if I am, I hope someone corrects me quickly!), but if you have two installs, I assume you have two different paths to Koha: something like /usr/local/koha and /usr/local/koha2. ### This is correct. This gives me two bulkmarcimport.pl files, each in a different directory. So if you change the PERL5LIB environment variable accordingly, you should be able to control where the data goes, because Koha will grab the appropriate "context" from the path you specify. You might do: # export PERL5LIB=/usr/local/koha/intranet/modules to load records in one install, and # export PERL5LIB=/usr/local/koha2/intranet/modules to load records into the other install. ### Or, perhaps I could place the correct ../modules statement in each of my two separate bulkmarcimport.pl scripts, and run the desired script for the desired database? However, it appears to me that when bulkmarcimport.pl runs, even if the modules directory is identified correctly, something is causing the data to go to /var/lib/mysql/"anydir" whereas I want it to go somewhere else of my choosing. How do I set that path and how do I enable koha to locate it? You'd need to take out any "use lib "/usr/local/koha/intranet/modules";" statement that you might have added to bulkmarcimport.pl Stephen Bruffey, Mark said: > Thanks for your assistance Stephen. The routine ran fine, but, since I > have two installs I am trying to keep separate, I need a way to > designate where the data will go. It appears that the data path > defaults to /var/lib/mysql/variablename. I need to designate two > separate data paths, preferably not as a subdir of /var/lib/mysql, and > have my two instances of KOHA be able to find the right set of data. > Is this possible? If so, what do I need to do to implement this > change? Sincere thanks, Mark > > -----Original Message----- > From: Stephen Hedges [mailto:shedges@skemotah.com] > Sent: Saturday, January 29, 2005 8:08 AM > To: Bruffey, Mark > Cc: koha-devel(a)lists.sourceforge.net > Subject: Re: [Koha-devel] request bulkmarcimport assistance > > > Mark, could it be that your perl can't find the Koha C4 directory? > (Although that usually produces a different error.) Try this: > > Before you run "./bulkmarcimport.pl", export the directory where C4 > resides: # export PERL5LIB=/usr/local/koha/intranet/modules > (that's the normal directory for most installs, change it if yours is > different.) > > Or if you use bulkmarcimport a lot, add this line to the list of "use" > statements at the beginning of the script: use lib > "/usr/local/koha/intranet/modules"; > > Stephen > > Bruffey, Mark said: >> I'm getting the following error when attempting to run >> bulkmarcimport.pl: >> >> BEGIN failed--compilation aborted at ./bulkmarcimport.pl line 10. >> >> It seems like I had a similar problem when I imported records some >> months ago, but, of course, I do not appear to have documented the >> solution to it . . . . >> >> Sincere thanks for any assistance. >> >> Mark >> >> L. Mark Bruffey >> Director Library Services >> Central Baptist Theological Seminary >> 900 Forestview Lane N >> Plymouth MN 55441 >> 763 417 8264 >> >> mbruffey(a)centralseminary.edu <mailto:mbruffey@centralseminary.edu> >> >> Central Seminary www.centralseminary.edu >> <http://www.centralseminary.edu> Fourth Baptist Church >> www.fourthbaptist.org <http://www.fourthbaptist.org> WCTS Radio AM >> 1030 Online www.centralseminary.edu/wcts >> <http://www.centralseminary.edu/wcts> -- Stephen Hedges Skemotah Solutions, USA www.skemotah.com -- shedges(a)skemotah.com

1 0