Would an SQL Update statement be more effective here? Like:
UPDATE biblio SET author =
ExtractValue(marcxml,'//datafield[@tag="100"]/subfield[@code>="a"]') WHERE
author IS NULL
On Wed, Oct 31, 2012 at 1:00 PM, Paul wrote:
> At 08:09 PM 10/29/2012 +0100, you wrote:
>
>> Hi Paul,
>>>
>> [snip]
>
Another option would be a tool, similar to the Keywords to MARC Mapping
tool in the Administration section.
On Wed, Oct 31, 2012 at 11:26 AM, Mathieu Saby wrote:
> Hello
>
> Currently, facets are defined in perl code.
> This is not good for unimarc libraries : a recent improvement is specific
>
Some have suggested the debian.k-c.org repo, which is good.
I'm running Ubuntu 12.04 Desktop 64-bit, and my package list includes good
versions of the three perl modules you've listed. Looks like they come
from the Universe repo.
On Wed, Aug 8, 2012 at 9:34 AM, Tomas Cohen Arazi wrote:
> On Wed
We can do something similar in Koha currently, which is to have a custom
css and search limit in an apache virtual host for each library. I see in
etc/koha-httpd.conf these lines in the opac virtualhost:
# Repeat this virtualhost stanza changing the following environment vars
to
# create multi
I think there is not a more forgiving parser. The ISO2709 spec breaks when
a record reaches 10 octets. I don't see any way around that in the
parser. The best solution I can come up with, if you want to hold to the
spec, is to create a seperate ISO2709 blob with a logical link to the first
w
gt; http://wiki.koha-community.org/wiki/SQL_Reports_Library#Active_Patrons
>
> Thanks!
>
> Liz Rea
> l...@nekls.org
>
>
>
>
> On Jan 9, 2012, at 2:36 PM, Mike Hafen wrote:
>
> > SELECT YEAR(issuedate), MONTH(issuedate), categorycode, COUNT(DISTINCT
> borrower
FROM issues
) AS all_issues
LEFT JOIN borrowers USING (borrowernumber)
GROUP BY YEAR(issuedate), MONTH(issuedate), categorycode
On Mon, Jan 9, 2012 at 1:31 PM, Galen Charlton wrote:
> Hi,
>
>
> On 01/09/2012 03:30 PM, Mike Hafen wrote:
>
>> I've seen UNION used to join th
I've seen UNION used to join those two tables in queries. I'm imaginning
something like:
SELECT YEAR(issuedate), MONTH(issuedate), categorycode, COUNT(DISTINCT
borrowernumber)
FROM (
SELECT issuedate,categorycode,borrowernumber FROM old_issues
UNION ALL
SELECT issuedate,categorycode,borrower
I was just thinking about the permissions. You're right about having to do
every language though, that wouldn't be practical.
On Fri, Dec 9, 2011 at 2:47 PM, Chris Cormack wrote:
>
> On 10 Dec 2011 09:44, "Mike Hafen" wrote:
> >
> > So it is not pos
So it is not possible to have TT pre-compile the files?
On Fri, Dec 9, 2011 at 1:04 PM, Chris Cormack wrote:
> On 10 December 2011 08:57, Chris Nighswonger
> wrote:
> > On Fri, Dec 9, 2011 at 2:52 PM, Chris Cormack
> > wrote:
> >>
> >>
> >> But for CGI, then the compiling is useful also, so we
Perhaps the way to overcome permissions would be to host the pre-compiled
template files in git, or create them just before creating the archives for
releases.
2011/12/9 Chris Nighswonger
> Nice work Paul!
>
> I think this is worth at least a try to see what improvement may be gained.
>
> I wond
> Linda
>
>
> On 11/8/2011 1:47 PM, Mike Hafen wrote:
>
>> Some of my libraries are doing something similar to this with the items
>> url tag (952$u) for online e-books. It shows the url in the staff and
>> OPAC interfaces. Is that what you are talking about?
>&
Some of my libraries are doing something similar to this with the items url
tag (952$u) for online e-books. It shows the url in the staff and OPAC
interfaces. Is that what you are talking about?
On Tue, Nov 8, 2011 at 12:00 PM, Linda Culberson
wrote:
> All,
> In the discussion of links in Koha,
Dear Sir/Madam,
You seem to have confused an open source community for a software vendor.
There are a number of vendors who do provide support for the Koha software
though. I'm sure they would be happy to be contacted by you. On the koha
community web site there is a handy list of these compani
Looks like you are selecting from the wrong table here... borrowers should
be items
On Mon, May 16, 2011 at 1:30 AM, Chris Cormack wrote:
> From: Srdjan Jankovic
>
> This patch fixes rows in the issues table that have null borrower or item
> numbers
> And stops this being able to happen in the
Yeah, that's a good option too. Make the changes to the items table in the
database, and that script will take care of the marc records.
Thanks Chris.
2011/4/7 Chris Nighswonger
> 2011/4/6 Charl
>
>> Good day
>>
>> I need advice please. I have converted a Koha installation from 2 to Koha
>>
a batch procedure?
> The item record is not a problem, but I am not sure how to edit the barcode
> in the marc record (biblioitems).
>
> Thanks again for your help.
>
> - Original Message -
>
> *From:* Mike Hafen
> *To:* Charl
> *Cc:* koha-devel@lists.ko
The Item Type in Koha 3 has been moved to the items table, with the Item
Type in the biblioitems table being a default for new items.
It wouldn't be difficult to make a command line script to copy the Item Type
from the biblioitems table to the items table, that may be the best way to
go in this c
I have a shell script that sets certain environment variables then runs the
perl debugger. With that I can step through the script.
I have to log in first, so that I have a valid session, and get the session
id from the browser.
Basically it's like this:
#!/bin/bash
export KOHA_CONF=/usr/local
I think that you probably don't want that 'die ...' in there.
On Tue, Mar 22, 2011 at 12:08 AM, Srdjan Jankovic wrote:
> diff --git a/misc/cronjobs/advance_notices.pl b/misc/cronjobs/
> advance_notices.pl
> index 6a408e4..eb5071a 100755
> --- a/misc/cronjobs/advance_notices.pl
> +++ b/misc/cronjo
Merge conflict marker snuck in there.
On Tue, Mar 15, 2011 at 6:44 PM, Chris Cormack wrote:
> See http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5872 for
> details
> ---
>
> diff --git a/C4/Reserves.pm b/C4/Reserves.pm
> index 2dd2688..12756ee 100644
> --- a/C4/Reserves.pm
> +++ b/C4/Re
You probably don't want that merge conflict marker in there.
On Fri, Mar 4, 2011 at 5:17 AM, Salvador Zaragoza Rubio <
salv...@masmedios.com> wrote:
> Modification of the intranet cataloguing plugin for 006/008 fields to allow
> select a type of material and change the positions available to ente
I had an idea about this recently. Perhaps it is possible to have in the
items table a MARCXML column which stores the MARC just for the items, and
have that be seperate from the biblio's MARCXML. Then we the record is sent
to the zebra server combine the two, so that zebra still has all the
info
Did you mean to remove the Curriculum index which was recently added by
someone at PTFS?
On Thu, Dec 9, 2010 at 7:46 AM, wrote:
> From: Savitra Sirohi
>
> ---
> etc/zebradb/biblios/etc/bib1.att|4 +---
> etc/zebradb/ccl.properties |4 ++--
> etc/zeb
Changes to both files are necessary, but there is a problem with the way you
are changing updatedatabase.pl.
I thing to know is that sysprefs have to exist in the database, unless I'm
mistaken since the new syspref editor. The
data/mysql/en/mandatory/sysprefs.sql change is necessary to add the
li
On Thu, Nov 18, 2010 at 10:03 PM, Koustubha Kale wrote:
>Also this itemBarcodeInputFilter is specifically meant for libraries
>doing retrospective conversion from a ILS product called Libsuit8 AND
>if they are stuck with barcodes already printed and attached to
>items..
Yes, I am aware of that. J
Ah, I see you already got the second suggestion. One comment about that
though, my libraries all have branch codes that are numbers. So this filter
would be broken in that case.
On Thu, Nov 18, 2010 at 7:12 AM, Koustubha Kale wrote:
...
> diff --git a/C4/Circulation.pm b/C4/Circulation.pm
> ind
Two suggestions.
First, perhaps the users branch could be used, like from
C4::Branch::mybranch()
Then you wouldn't need to add the branch parameter to the sub
Second, perhaps instead of splitting the barcode string you should do
something like s/(.*)0+(.*)/$1$2/
That should strip out all the zero
On Tue, Nov 2, 2010 at 10:18 PM, Koustubha Kale wrote:
> >just make the data loaded in Koha match the printed barcodes.
>
> I would just love to be able to do that.
>
> But Its not possible to exactly match barcodes in Koha with printed
> barcodes because :
>
> 1) No report from the old software h
Why can't you correct the barcodes during the migration?
If you are going from MS-SQL to MySQL you should be able to add another step
in the middle to populate the barcode from the available information in the
database.
If you are going from MARC into Koha you should be able to populate the
barco
that it doesn't
>> connect to any other systems, but only to your other mailserver.
>>
>> --Joe
>>
>> 2010/10/1 Nitesh Rijal
>>
>> Thanks,
>>>
>>> I was wondering whether it is possible to use koha server in one server
>>>
sh Rijal wrote:
> Thanks,
>
> I was wondering whether it is possible to use koha server in one server and
> use existing mail server from another server. So, if possible, please guide
> me through the steps.
>
> Regards.
>
>
> On Thu, Sep 30, 2010 at 8:05 PM, Mike Hafen wrote:
Koha relies a lot on the mail functions of the server. For example I have
my server running postfix and set to send email through another mail server.
As far as Koha itself, a lot of the mail functionality runs from cron.
There are a couple perl scripts, most notably in this case the following:
o
rs to look for.
>
> Cheers,
>
> Christopher Curry
> Assistant Technical Librarian / Assistant IT Officer
>
> American Philosophical Society
> 105 South Fifth Street
> Philadelphia, PA 19106-3386
> Tel. (215) 599-4299
>
> ccu...@amphilsoc.org
> Main Library num
Sorry to hear you are having problems with your failover server. I've had
problems with failovers servers and backups before, it's not fun.
Have you checked the memory and hard drive of the failover server? (the
host) That would be my first guess. Also, it may be the filesystem on
either the h
That error is generated by the Carp Perl module. It is placed in the
browser for you instead of in a log file. The only way to change the error
is to change the code, in addbiblio.pl line 878, so that it checks the
biblio loaded properly before calling the title function. There, if the
biblio di
Looks good. I see a couple of warn's though.
On Wed, Nov 4, 2009 at 8:02 AM, Nahuel ANGELINETTI <
nahuel.angeline...@biblibre.com> wrote:
> This patch fix some problems with dates, and itemtypes level.
> And it improve some sql queries.
> ---
> reports/borrowers_out.pl | 26 +++--
The maxItemsInSearchResults is a feature that I worked on. I didn't know
how much interest there was, so I didn't put it in the updatedatabase.pl.
Looks like the rest of the work is done.
This feature controls how many items are shown per status in the search
results page. The default is one ite
Funny you should mention this now. I was just thinking about removing MARC
from Koha and dropping in DC. Switching to all XML is a much better idea.
The reason I was thinking about this is because some people I work with want
to use Koha for Asset Management and Inventory. I have a few libraria
This will have to be done in two parts as you got it setup. First is to
update the items table, then there is a command line script to update the
marc and zebra.
First:
update db1.items cross join tempdb.items using ( itemnumber ) set
db1.items.barcode = tempdb.items.barcode;
That should take c
Quite right in both cases. Both of these features are two patches, and the
first contains the update to en/mandatory/sysprefs.sql. My lack of French
prevents me from adding the SQL to the other file. If someone would be so
kind as to translate the two strings for me I will correct and re-submit.
41 matches
Mail list logo
