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

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

03 Feb '05

Hi All! I wanted to report that I believe I have achieved complete success in getting marc records imported to the desired locations for my two koha installations. With the help of individuals here I was able to get bulkmarcimport.pl to work the way I wished and I have also, by creating soft links, been able to move the actual mysql databases to a different physical drive. Thanks again! Mark > -----Original Message----- > From: koha-devel-admin(a)lists.sourceforge.net > [mailto:koha-devel-admin@lists.sourceforge.net] On Behalf Of > Paul POULAIN > Sent: Thursday, February 03, 2005 11:09 AM > To: koha-devel(a)lists.sourceforge.net > Subject: Re: [Koha-devel] request bulkmarcimport assistance > > > Joshua Ferraro a écrit : > > Mark, > > > > The path /var/lib/mysql/"anything" refers to the database > itself. 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). > > You'll also probably want to use a different admin account > for ease of > > administration (e.g., kohaadmin1, kohaadmin2). You will > also want to > > keep the koha paths different for those two installs (e.g., > > /usr/local/koha1, /usr/local/koha2), 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). > > > > 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. > > > > 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. > > you're right. > Just define KOHA_CONF to use one or the other DB setup. > > For example : > the test install is in /etc/koha_test.conf > the prod setup is in /etc/kohaprod.conf > > Do a export/SetEnv KOHA_CONF=/etc/kohaXXX.conf before running > what you want. You can have the same cgi/templates for many > installs, having just the > DB setup different. The DB contains template, language, > MARC,... so that > will work really fine. > > HTH. > > -- > Paul POULAIN > Consultant indépendant en logiciels libres > responsable francophone de koha (SIGB libre http://www.koha-fr.org) > > > ------------------------------------------------------- > 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

Requested feature (biblio title order)
by Paul POULAIN 03 Feb '05

03 Feb '05

Hi, In 2.2, when you order a search by title, stopwords at the beginning are still used in the ordering. "A simple software" will be ordered before "The last minute". In France (& I think in other countries it's the same), we are supposed to have "A" and "The" ignored at the beginning of the title having "(A) simple software" after "(the) last minute". To add this feature in Koha we could : * add a field in biblio.title. Call it biblio.titlenostopword (anybody a suggestion for a better name ;-) ?) * in Biblio.pm, in OLDnewbiblio / OLDmodbiblio => put the title with stopwords removed in this new field * don't order on biblio.title but on the new field. Quite simple to do, a day of work not more. Do we think it's an important feature that could be in 2.2.x or not ? I vote yes. the risk of unstability is really low, for a nice feature. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

3 6

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

03 Feb '05

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

4 3

re: Add biblio bug
by Harvey Lee 03 Feb '05

03 Feb '05

Hi Greg, There is a simple fix for this. The problem is in the template addbiblio.tmpl. In the lines that call the javascript function AddField(), change from: href="javascript:AddField()" to: href="javascript:AddField("")" I'm doing this from memory so I hope the placement of the quotes above is correct! This code needs to be fixed in 10 places (once per tab). What seems to be happening is that the tag value is being sent to the javascript function as an integer so leading zeros (as in the ISBN tag) are being stripped. Lee In addbiblio.pl.... I click on the + sign to add a seccond ISBN number for a biblio entry. Instead of adding a seccond ISBN field, it adds a new LCCN field. This bug has existed in earlier versions of KOHA as well, but I never got around to reporting it. To ensure the problem is not in my database, I did a clean insteall, and found this happened whilst adding my first biblio entry. Greg

2 1

MARC tags/subfields downloaded v/s displayed
by Harvey Lee 03 Feb '05

03 Feb '05

Hi all, I've got a question concerning the downloaded MARC tags/subfields from Z3950. If a certain MARC tag/subfield is present in the Z3950 downloaded record, but I choose not to display this tag/subfield in the MARC view (i.e., tab = - 1 or 'ignored'), is the tag/subfield supposed to be stored in marc_subfield_table? Maybe I misinterpreted what I read a while back, but I thought ALL of the MARC data was stored even though it may not be displayed. I'm finding that only those tag/subfields that are visible on download are stored. But AFTER the downloaded biblio is saved into the catalogue, I can then show/hide the subset of subfields that actually made it into the marc_subfield_table. I'm running Koha2.0.0. Is this design intent or is this a bug that there is a fix for already? Can anyone comment? Thanks, Lee

2 1

Subject maintenance?
by Rachel Hamilton-Williams 03 Feb '05

03 Feb '05

Hi ya, I'm just checking, but I'm having trouble working out where/how/if you do subject maintenance in 2.2? I've added some subjects to a biblio (using the edit biblio stuff in the MARC View) and so I see I could go and just edit all the subjects per biblio by hand - but that seems like a bit of a leap backwards. In 1.3 we had (well I think we did, HLT certainly do), the ability to get up a list of subjects, and then edit them, delete duplicates etc, and have it work for all the biblios. Is that functionalty in this version (and I'm just blind/using the wrong templates) OR is it not in this version (in which case I'll stop looking) Cheers R

2 1

Design Dilemas
by Rachel Hamilton-Williams 03 Feb '05

03 Feb '05

Hi guys, I've got a dilema, that I need some help resolving I think. As you know I've been doing some new concepts for the koha templates, and have (as per usual) inadvertantly done some things that I think involve more than just changing the CSS. Specifically, * on the opac homepage making the language options *not* a drop but instead clickable links * generally re-arranging the "order" things I've also added in some new functionality, but I'm happy to let that go :-) SO my question is a ground level "how do the templates work" If I think there are things "wrong" with the CSS templates, that can't be fixed in styles, what should I do? If I get changes made to the CSS template, what will break? Over the last couple of years there have been some specific aspects of the layout of the pages that clients have consistently wanted changed, and while we did make a version of templates that addressed those issues for 2.0, of course they don't work now with 2.2. There are some issues, which are essentially one of colour, font, size, etc and they are easily addressed. But other issues - where essentially I think something is in the "wrong place" or the "wrong sort of interface" - ie links not drop downs and vice versa - what should I do. I can get it coded into "katipo" templates, but as I understand it, unless Paul you adopt those changes to your templates, when we upgrade, it may all fall appart? Should I "bug" architecture issues with particular pages, and perhaps supply the soloutions? OR is everyone else basically happy with how they are? Help :-) cheers R

2 1

Reports patches
by Ernesto Silva - Webmaster 03 Feb '05

03 Feb '05

Paul, We are using apache2 and some of the paths (require directives) doesn't work. I've discovered a posible "bug" in intranet/cgi-bin/reports/manager.pl and this may be a patch. --- /usr/local/koha2/intranet/cgi-bin/reports/manager.pl 2005-01-19 10:09:02.315406544 -0300 +++ manager.pl 2005-01-25 16:21:29.159390944 -0300 @@ -41,7 +41,7 @@ }); $template->param(do_it => $do_it, report_name => $report_name); -my $plugin = "./".$report_name.".plugin"; +my $plugin = C4::Context->config('intranetdir')."/cgi-bin/reports/".$report_name.".plugin"; require $plugin; if ($do_it) { my $results = calculate(\@values); Regards Ernesto.

2 1

Add biblio bug
by Greg Kuhnert 03 Feb '05

03 Feb '05

In addbiblio.pl.... I click on the + sign to add a seccond ISBN number for a biblio entry. Instead of adding a seccond ISBN field, it adds a new LCCN field. This bug has existed in earlier versions of KOHA as well, but I never got around to reporting it. To ensure the problem is not in my database, I did a clean insteall, and found this happened whilst adding my first biblio entry. Greg

2 1

bar code not unique
by T & J Kotula 03 Feb '05

03 Feb '05

Hi, I remember reading on the list lately about the bar code not having to be unique. Well I would like to enforce it to be unique. I'm not a perl programmer, but I had a look in acqui.simple/additem.pl and I'm puzzled by the comment on line 81 saying "check for bar code # being unique". Could someone tell me what I need to do to make it verify the number being unique. Many thanks. tomasz kotula.

2 1