[Koha] Need Documentation Help with new OAI Page

[Nicole Engard]

There is a new page in Koha 3.8 for OAI Sets, but I have never used
OAI and I don't know how to document this section.

The bug is here: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6440

And I welcome any help in documenting this section. You can submit a
documentation patch or just type in the email and I'll put it in the
manual for you.

Thanks a bunch!

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Advanced Pattern for Serials Help

[Nicole Engard]

Just another nudge - anyone out there any good at serials? Cause I'm
obviously not!

Nicole

On Fri, Mar 9, 2012 at 1:25 PM, Nicole Engard  wrote:
> Any ideas from the community? I could really use some help on this one.
>
> Nicole
>
> On Wed, Feb 29, 2012 at 8:27 PM, Nicole Engard  wrote:
>> I have this serial that comes every other month and is number like
>> this Vol 1 Num 1/2, Vol 1 Num 3/4.  I have this pattern in place, but
>> it's not quite working.
>>
>> See the screenshots here: http://screencast.com/t/exxF7ekCw
>>
>> And the pattern I used is here:
>>
>> Values for X
>> Add : 1
>> once every: 6
>> other values should be ok
>>
>> Values for Y
>> Add : 2
>> oncer every : 1
>> When more than 12
>> Set back to 1
>>
>> Values for Z
>> Add : 2
>> oncer every : 1
>> When more than 12
>> Set back to: 2
>>
>>
>> Any ideas on this? I've been working on it for ages now and have had
>> no luck - I don't know why it's not working.
>>
>> Thanks in advance!
>>
>> Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Serials Advanced Pattern Help

[Nicole Engard]

Reader's Digest is similar to this and I tested this pattern given to
me years ago: 
http://manual.koha-community.org/3.6/en/sampleserialsapp.html#readersdigestsample
and it doesn't work.  Any ideas welcome! I'm guessing that this worked
in 2008 when I added it ... but I can't remember.

Nicole

On Fri, Mar 9, 2012 at 1:25 PM, Nicole Engard  wrote:
> I need some serials help.  Everyday with Rachel Ray is published 10
> times a year and the number never sets back to 1 so - January/February
> 2012 is Vol 7., No. 59  The magazine is published monthly except in
> July/August and January/February.
>
> Any help setting up an advanced pattern would be welcome!
>
> Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Fines Column in OPAC

[Nicole Engard]

On Mon, Mar 26, 2012 at 9:21 AM, Owen Leonard  wrote:
> Does anyone know other situations in which accountlines would have an
> entry tied to an itemnumber? Should the scope of what kind of charges
> are display here be expanded to include rental charges?

You can enter a barcode on any manual invoice so I think that there
are many other instances where you could have a charge tied to an item
number ...

I'm going to do some manual invoice testing because I've never seen
anything but 'No' there.

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Fines Column in OPAC

[Nicole Engard]

Does the Fines column on the My Summary page in the OPAC ever show
anything other than 'No'?  Does it show the fine amount? Or is it
broken at this time?

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] HELP: Patron import

[Nicole Engard]

You need a cardnumber and a patron category for each patron. I think
that might be all that's required by the upload - but I could be
wrong.

Nicole

On Tue, Mar 20, 2012 at 8:32 AM, ZUULU COOPER  wrote:
> Dear Group members,
>
> I am new to Koha and I am trying to set up my first system. I downloaded
> the patron.csv file and follow directions in Nicole Engard Youtube video
> except that I enter only last name and first names as a test. When I
> uploaded the file I received the error *invalid data for "category...".* Do
> I need to enter the data for all the fields before  I upload the patron
> file?
>
> --
> Zuulu Cooper
> Founder & Executive Director
> Libraries for Liberia Foundation
>  5919 Dakar Road West
> Suite 100
> Westerville, OH 43081
>  614 270 3464
> Skype: Shaka_zu00
>
>  website : http://librariesforliberiafoundation.com  email:
> i...@librariesforliberiafoundation.com
>
>
>  *“Cause change and lead, accept change and survive, resist change and die.”
> *
>
> Ray Noorda - 1924-2006, technology pioneer, Novell Corporation CEO.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Computers in Libraries

[Nicole Engard]

As already stated I'll be there. I have 2 talks and a workshop to give.

Nicole

On Thu, Mar 15, 2012 at 11:20 AM, Ian Walls  wrote:
> The conference also overlaps with the Marseilles Hackfest, so lots of our
> international community members will be out that way.  So long as I've got
> connectivity, I'll try to be on IRC, so we can stay virtually connected.
>
>
> -Ian
>
> On Thu, Mar 15, 2012 at 11:06, G. Laws  wrote:
>
>> I might have been inclined to go, but it coincides exactly with the
>> MOREnet Spring Connections conference, and I'm presenting there this year.
>>
>> --
>>
>> Greg Lawson
>> Rolling Hills Consolidated Library
>> 1912 N. Belt Highway
>> St. Joseph, MO 64506
>>
>> --
>>
>> On 03/15/2012 12:31 AM, Stacy Pober wrote:
>> > Computers in Libraries
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL statement

[Nicole Engard]

That didn't work right! try this instead:


SELECT concat(b.title, ' ', ExtractValue(( SELECT marcxml FROM
biblioitems b2 WHERE b.biblionumber = b2.biblionumber),
'//datafield[@tag="245"]/subfield[@code="b"]')) AS title, b.author,
i.itemcallnumber FROM biblio b LEFT JOIN items i ON
(i.biblionumber=b.biblionumber) where
i.homebranch=<> AND i.location='LIB'

On Tue, Mar 13, 2012 at 4:13 PM, Nicole Engard  wrote:
> I think this is all you need:
>
> SELECT concat(b.title, ' ', ExtractValue(( SELECT marcxml FROM
> biblioitems b2 WHERE b.biblionumber = b2.biblionumber),
> '//datafield[@tag="245"]/subfield[@code="b"]')) AS title, b.author,
> i.itemcallnumber FROM biblio b LEFT JOIN items i ON
> (i.biblionumber=b.biblionumber) and
> i.homebranch=<> AND i.location='LIB'
>
>
> Nicole
>
> On Tue, Mar 13, 2012 at 4:00 PM, Rachel Hollis
>  wrote:
>> Greetings friends, I have two SQL statements that I would like to combine 
>> but I don't know SQL well enough to do it myself. Could someone help me?
>>
>> I want to get a list of titles (245a and 245b), authors, and call number 
>> along with home-branch and library location.
>> Below is what I have, probably from the wiki:
>> SELECT concat(b.title, ' ', ExtractValue(( SELECT marcxml FROM biblioitems 
>> b2 WHERE b.biblionumber = b2.biblionumber), 
>> '//datafield[@tag="245"]/subfield[@code="b"]')) AS title, b.author, 
>> i.itemcallnumber FROM biblio b LEFT JOIN items i ON 
>> (i.biblionumber=b.biblionumber)
>>
>> And from another report:
>> WHERE items.homebranch=<> AND items.location='LIB'
>>
>> Copy and paste didn't work for me. ;-)
>>
>> Rachel Hollis, librarian
>> Stevens-Henager College, Boise & Nampa Idaho
>>
>> 
>>
>> This message is for the designated recipient only and may contain 
>> privileged, proprietary, or otherwise private information. If you have 
>> received it in error, please notify the sender immediately and delete the 
>> original. Any other use of the email by you is prohibited.
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] SQL statement

[Nicole Engard]

I think this is all you need:

SELECT concat(b.title, ' ', ExtractValue(( SELECT marcxml FROM
biblioitems b2 WHERE b.biblionumber = b2.biblionumber),
'//datafield[@tag="245"]/subfield[@code="b"]')) AS title, b.author,
i.itemcallnumber FROM biblio b LEFT JOIN items i ON
(i.biblionumber=b.biblionumber) and
i.homebranch=<> AND i.location='LIB'


Nicole

On Tue, Mar 13, 2012 at 4:00 PM, Rachel Hollis
 wrote:
> Greetings friends, I have two SQL statements that I would like to combine but 
> I don't know SQL well enough to do it myself. Could someone help me?
>
> I want to get a list of titles (245a and 245b), authors, and call number 
> along with home-branch and library location.
> Below is what I have, probably from the wiki:
> SELECT concat(b.title, ' ', ExtractValue(( SELECT marcxml FROM biblioitems b2 
> WHERE b.biblionumber = b2.biblionumber), 
> '//datafield[@tag="245"]/subfield[@code="b"]')) AS title, b.author, 
> i.itemcallnumber FROM biblio b LEFT JOIN items i ON 
> (i.biblionumber=b.biblionumber)
>
> And from another report:
> WHERE items.homebranch=<> AND items.location='LIB'
>
> Copy and paste didn't work for me. ;-)
>
> Rachel Hollis, librarian
> Stevens-Henager College, Boise & Nampa Idaho
>
> 
>
> This message is for the designated recipient only and may contain privileged, 
> proprietary, or otherwise private information. If you have received it in 
> error, please notify the sender immediately and delete the original. Any 
> other use of the email by you is prohibited.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Report help

[Nicole Engard]

I'm looking to alter this report
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Total_Collection_Size_by_Date
to give me the count of items that were in the collection on that date
- that means checking the deleted items to see what was added and
deleted on the date that's entered and that's where my math gets a bit
rusty.

Thanks in advance!
Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Advanced Pattern for Serials Help

[Nicole Engard]

Any ideas from the community? I could really use some help on this one.

Nicole

On Wed, Feb 29, 2012 at 8:27 PM, Nicole Engard  wrote:
> I have this serial that comes every other month and is number like
> this Vol 1 Num 1/2, Vol 1 Num 3/4.  I have this pattern in place, but
> it's not quite working.
>
> See the screenshots here: http://screencast.com/t/exxF7ekCw
>
> And the pattern I used is here:
>
> Values for X
> Add : 1
> once every: 6
> other values should be ok
>
> Values for Y
> Add : 2
> oncer every : 1
> When more than 12
> Set back to 1
>
> Values for Z
> Add : 2
> oncer every : 1
> When more than 12
> Set back to: 2
>
>
> Any ideas on this? I've been working on it for ages now and have had
> no luck - I don't know why it's not working.
>
> Thanks in advance!
>
> Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Serials Advanced Pattern Help

[Nicole Engard]

I need some serials help.  Everyday with Rachel Ray is published 10
times a year and the number never sets back to 1 so - January/February
2012 is Vol 7., No. 59  The magazine is published monthly except in
July/August and January/February.

Any help setting up an advanced pattern would be welcome!

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Deleting duplicate biblios and biblios without items

[Nicole Engard]

You can only do it from the command line.  I would back up your
database and then to delete the bibs without items run these three
commands in MySQL:

INSERT into deletedbiblio (SELECT * FROM biblio where biblionumber NOT
IN (SELECT biblionumber from items));
INSERT into deletedbiblioitems (SELECT * FROM biblioitems where
biblionumber NOT IN (SELECT biblionumber from items));
DELETE FROM biblio where biblionumber NOT IN (SELECT biblionumber from items);

For duplicates, there are reports to help you find duplicates but not
to delete them:
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Duplicate_titles

Nicole

On Tue, Feb 28, 2012 at 9:02 AM,   wrote:
> We have a number of duplicate entries in our database and also biblios
> without items. I would like to know how how one can bulk delete duplicate
> records and all the biblios with no items attached. Thanks in advance
>
> Ephraim Makeke
>
> 
> This message was sent using IMP, the Internet Messaging Program.
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Advanced Pattern for Serials Help

[Nicole Engard]

I have this serial that comes every other month and is number like
this Vol 1 Num 1/2, Vol 1 Num 3/4.  I have this pattern in place, but
it's not quite working.

See the screenshots here: http://screencast.com/t/exxF7ekCw

And the pattern I used is here:

Values for X
Add : 1
once every: 6
other values should be ok

Values for Y
Add : 2
oncer every : 1
When more than 12
Set back to 1

Values for Z
Add : 2
oncer every : 1
When more than 12
Set back to: 2


Any ideas on this? I've been working on it for ages now and have had
no luck - I don't know why it's not working.

Thanks in advance!

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Updating ebook records in Koha - what happens to adjusted biblio records?

[Nicole Engard]

You don't want to be reverting your imports.  The ISBN match is a
string match so if the strings in the 020 field match each other then
they will match the records.  If Safari uses another field for a
identifying number you could create a matching rule to use that field
instead of the ISBN so that you get more accurate matches. I know that
some ebook vendors do that.

Nicole

On Tue, Feb 21, 2012 at 3:52 PM, Hartman, David W. - GBTS Library
 wrote:
> My library subscribes to Books24x7 and Safari Books online.  When  I update 
> my collection to have the latest book records from these providers, I assume 
> I should REVERT the last batch input and IMPORT the latest records.
>
> If I took an existing Safari biblio record and added a print (second copy) to 
> this existing record, would the print item (second copy) and biblio record 
> disappear when I REVERT the Safari record, or would the biblio and item 
> record remain for the one print copy?
>
> Let me know .. I do not want to start the updating process without 
> understanding its impact to revert and import updates.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Novelist

[Nicole Engard]

That was submitted to Koha 3.6 by a ByWater Solutions partner - Los
Gatos Public Library.  You can see it in action on their system:
http://catalog.losgatosca.gov/

Nicole C. Engard
ByWater Solutions

On Tue, Feb 21, 2012 at 8:27 PM, v...@scls.lib.wi.us  
wrote:
> Hi,
>
> Is any library using the Novelist integration that was included with the
> 3.6.0 Koha upgrade?   I would like to see what this looks like.
>
> Vicki
>
> --
> Vicki Teal Lovely
>
> Helping our 53 member libraries provide the best possible service to the
> public.
>
> ILS Project Manager
> South Central Library System
> Madison, WI
> v...@scls.lib.wi.us
> (608)242-4713
> ILS Help Desk (608)242-4720
> Twitter: vickiteal
> Blog: http://scls.typepad.com/link2koha/
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] items that are lost, fees assessed, and then found

[Nicole Engard]

Lori,

They are refunded the replacement price for the book, but not the fines.

Nicole

On Fri, Feb 17, 2012 at 10:06 PM, Lori Bowen Ayre  wrote:
> If a patron has lost an item and paid a fine. What happens when they then
> return the lost item? Is there a slick way to figure out how much they
> should be refunded based on the fine assessed and the late fee that would
> apply?
>
> Lori
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Hold limit per item

[Nicole Engard]

There is a feature request for this:
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7398

Nicole

2012/2/16 Przemek Sztuczyński :
> On 15.02.2012 15:11, Nicole Engard wrote:
>>
>> Oh! That can't be done.  The next person to place a hold will be put
>> second on the list to receive the item so it won't knock the person
>> who had the hold first off the list.
>>
>> Nicole
>
>
> Ok. Is there any way to at least inform patrons that item is already on
> hold?
>
>
> --
> Przemysław Sztuczyński
> UKSW
> http://uksw.edu.pl
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Hold limit per item

[Nicole Engard]

Oh! That can't be done.  The next person to place a hold will be put
second on the list to receive the item so it won't knock the person
who had the hold first off the list.

Nicole

2012/2/15 Przemek Sztuczyński :
> On 14.02.2012 15:05, Nicole Engard wrote:
>>
>> The circulation and fine rules are set on a per item type basis if you
>> want: http://manual.koha-community.org/3.6/en/patscirc.html#circfinerules
>>
>> Nicole
>>
>> 2012/2/14 Przemek Sztuczyński:
>>>
>>> Hi,
>>>
>>> is there any way to set maximum number of holds for item? Or for all
>>> items?
>
>
>
> If i understand this correctly, this allows me to set maximum number of
> holds for user - ie user type "x" can hold 3 items of type "books"
>
> I need a setting that will block holds on reserved item, so after someone
> puts an item on hold, others will not be able to reserve it.
>
> --
> Przemysław Sztuczyński
> UKSW
> http://uksw.edu.pl
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Hold limit per item

[Nicole Engard]

The circulation and fine rules are set on a per item type basis if you
want: http://manual.koha-community.org/3.6/en/patscirc.html#circfinerules

Nicole

2012/2/14 Przemek Sztuczyński :
> Hi,
>
> is there any way to set maximum number of holds for item? Or for all items?
>
>
> regards
> --
> Przemysław Sztuczyński
> Centrum Systemów Informatycznych
> Uniwersytet Kardynała Stefana Wyszyńskiego
> tel. (22)561-89-21 (wew. 321)
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Placing holds on ordered items

[Nicole Engard]

Bonnie,

You need to attach an item for it to allow holds.  There is a 'not for
loan' status of 'ordered' that you apply to the item record so that
patrons know it's not available yet and so that they can place holds
on them.

Nicole C. Engard
ByWater Solutions

On Mon, Feb 6, 2012 at 5:16 PM, Wolf, Bonnie  wrote:
> Our library is new to Koha (currently version 3.6). We are just
> beginning to order materials, and it seems that the records created upon
> order will not allow holds on the title because no items exist. Does
> anyone know of a way to makes titles "holdable" before items are
> actually received?
>
> I'd appreciate any insights you may have.
>
> Bonnie Wolf
> Washoe County Library
> Technical Services
> 775-327-8331
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] excel format to koha

[Nicole Engard]

Instructions can be found in the manual:
http://manual.koha-community.org/3.6/en/marceditexcel.html

Nicole

2012/2/3  :
> please send me an excel format (eg,) to convert excel data to koha (via marc 
> editor).
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Problem with new functionnality Hard Due Dates

[Nicole Engard]

I believe there is a development in the works to make it so that you
can edit rules in the Circulation and Fines matrix, but I can't seem
to find the bug link for you.  Maybe someone else can provide the link
to the bug/enhancement that talks about making it so that you can edit
the circulation rules instead of recreating them.

Nicole

2012/1/23 Laquerre, Anthony :
> Hi all,
>
> I would like to share our experience with 3.6 regarding this new
> functionality of Hard Due Date:
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5548
> Please let me know if I need to put this comment elsewhere..
>
> I would like to see with you what kind of workaround I can use :-)
>
> Basically, globalduedate and ceilingduedate has been removed and
> automatically fill the circ. rule instead.
> Look's great at first but, our libraries are all "school type" and we were
> modifying  the ceilingdue at least 3 times each year.
> We we putting the "End of session" as the max return date.
> You also need to know that most of the libraries have a lot for circ. rule.
> ( From 50 to up to 200 ).
>
> In the current state, we need to ask our librarians to manually update all
> the rules each time they want to specify a new ceiling due date.
> We can't only modify circ. rule so we need to redo them from scratch...
> So you can now see that this new feature is a big regression for us.
> Maybe not a regression, but error prone / time consuming problem.
>
> Is there any way to batch update an entire set of circ. rule to a new Hard
> due date ?
> Any other idea you can share to help us ?
>
> Thanks,
> Anthony
>
>
>
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Holds/Transfer Limit Question

[Nicole Engard]

Thanks Kyle,

I guess we'll have to do some testing and see if what they want is
possible with a combo of this feature and the holds rules on the circ
matrix.

Nicole

On Fri, Jan 20, 2012 at 12:45 PM, Kyle Hall  wrote:
> I wrote this feature, but it's been awhile so things may have changed.
> As far as I am aware, this should be allowed by the system. However, I
> don't recall writing in anything to limit a patron from selecting a
> different branch for pickup. This may result in a situation where
> Library A cannot transfer books to Library B, but the patron reserved
> a Library A book for pickup at Library B. Again, it's been a long time
> since I wrote the code, so I could be wrong.
>
> Kyle
>
> http://www.kylehall.info
> Mill Run Technology Solutions ( http://millruntech.com )
> Crawford County Federated Library System ( http://www.ccfls.org )
> Meadville Public Library ( http://www.meadvillelibrary.org )
>
>
>
> On Fri, Jan 20, 2012 at 12:05 PM, Nicole Engard  wrote:
>> I got this question today from a library about to go live with Koha
>> and I'm not exactly sure how to answer it.
>>
>> "Our system is a collection of four sites.  One of them (Library A)
>> has a severe restriction: Books from its collection cannot be
>> transferred to the other sites.  They can be put on hold by patrons at
>> any of the branches, but must be picked up at Library A."
>>
>> Is this possible? Will the Library Transfer Limits do this?  I'm
>> thinking that if holds are allowed there is no way that they can stop
>> the transferring, but I could be wrong and would love to hear from any
>> of you who are using Library Transfer Limits or some such similar
>> feature/rule.
>>
>> Thanks a bunch,
>> Nicole C. Engard
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Holds/Transfer Limit Question

[Nicole Engard]

I got this question today from a library about to go live with Koha
and I'm not exactly sure how to answer it.

"Our system is a collection of four sites.  One of them (Library A)
has a severe restriction: Books from its collection cannot be
transferred to the other sites.  They can be put on hold by patrons at
any of the branches, but must be picked up at Library A."

Is this possible? Will the Library Transfer Limits do this?  I'm
thinking that if holds are allowed there is no way that they can stop
the transferring, but I could be wrong and would love to hear from any
of you who are using Library Transfer Limits or some such similar
feature/rule.

Thanks a bunch,
Nicole C. Engard
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Patrons blocked after turning in overdues

[Nicole Engard]

Jim,

There are a few possibilities.  You might have set the Suspension in Days
on the Circulation and Fines Matrix in Administration (
http://manual.koha-community.org/3.6/en/patscirc.html#circfinerules).  The
other option is that you have it set to restrict patrons when they get
overdue notices and you can stop this by going to Tools > Overdue Notice
Status/Triggers and unchecking the box under 'restrict' (
http://manual.koha-community.org/3.6/en/noticetriggers.html).

Let me know if those work for you.

Nicole C. Engard
ByWater Solutions

2012/1/19 Jim Maroon 

> At some point we turned on a setting that apparently punishes patrons for
> having had overdue items. Depending on the severity of the overdue, it
> blocks them for X number of days, and staff have no way overriding it. This
> is for patrons who have already turned in the overdue items and do not have
> or have already paid fines.
>
> Where is this setting and how do I turn it off?
>
>
> Thanks.
>
> --Jim
>
>
> --
>
> ==
> "The man, who, by his own and his family's labour, can provide a
> sufficiency of food and raiment and a comfortable dwelling place, is not a
> poor man." --William Cobbett, *Cottage Economy*, 1826.
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Acquisitions questions regarding invoicing in Koha version 3.6

[Nicole Engard]

Maureen,

Some answers in line below:

Thanks
Nicole C. Engard
ByWater Solutions

2012/1/18 McElroy, Maureen :
> To the collective brain…..
>
> Our library system is new to Koha. We’ve recently migrated to version 3.6
> and are trying to organize/set up our acquisitions workflow.
>
> Is it possible to invoice in Koha? (Create an invoice; charge received
> orders to the invoice; pay the invoice, charging down related funds.)
>

Not in the way you are referring to here.

>
> Is it possible to  print out some sort of invoice summary or voucher listing
> the subtotals of each account charged down, within an invoice?
>

If you add your basket to a basket group when you close it it will
prompt you to generate a Purchase Order - that is a PDF of your order.
The problem here is that there are some hardcoded French strings in
the PDF: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6394

>
> How would we include shipping charges and processing charges in an invoice?
>

This is being fixed right now, but is not yet in Koha:
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6504

>
> Any info. would be greatly appreciated!
>
> Maureen McElroy
> Manager Technical Services Dept.
> Washoe County Library
> 301 S Center St.
> Reno, NV 89501
> 775 327-8330
> mailto:mmcel...@washoecounty.us
>
> www.washoecountylibrary.us
>
> “Most important of all, perhaps, a library within a community stands as a
> testimonial to its values, its belief in universal access to literature and
> knowledge.” Scott Turow
>
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Serials Planning Help

[Nicole Engard]

Okay, that seems to work for the first issue, but not when you go to
receive the next.  Any other ideas?

Nicole

On Fri, Jan 6, 2012 at 4:09 PM, Nicole Engard  wrote:
> Thanks for this! I'll give it a whirl.
>
> Nicole
>
> On Fri, Jan 6, 2012 at 3:52 PM, Eric Bégin  wrote:
>> Nicole,
>>
>> I would use a X, Y, Z numbering pattern (Volume, number, Issue. Starting
>> Volume at 42, starting Number at 7 and Issue at 8.
>> Numbering formula is Volume {X} #{Y}/{Z}
>>
>> The trick is that you will have to use the Advanced Pattern since Y and Z
>> must increment by 2 every time you receive an issue
>>
>> Values for X
>> Add : 1
>> once every: 6
>> other values should be ok
>>
>> Values for Y
>> Add : 2
>> oncer every : 1
>> When more than 12
>> Set back to 1
>>
>> Values for Z
>> Add : 2
>> oncer every : 1
>> When more than 12
>> Set back to: 2
>>
>> I didn't try it but I'm pretty confident that it should work.
>>
>> Hope that helps,
>>
>> Eric Bégin
>> www.inLibro.com
>>
>>
>>
>>
>> On 2012-01-06 13:47, Nicole Engard wrote:
>>
>> I have a strange Serial planning question. American Libraries
>> publishes 6 issue a year, and number them like this:
>>
>> Volume 42 #7/8
>> Volume 42 #9/10
>> Volume 42 #11/12
>>
>> Can anyone come up with a way to enter this in to  Koha to allow for
>> this type of numbering? All I can come up with (and it's way sloppy)
>> is to tell Koha that it's 12 issues a year and then delete every other
>> issue and manually edit the volume/number field to show 7/8 or 9/10
>> etc.
>>
>> Thanks in advance for any tips you can provide.
>>
>> Nicole
>>
>> PS. I am still looking for serials planning examples from all types of
>> journals/magazines so that I can share them in the manual and save new
>> Koha librarians time!
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Placing holds on multiple volumes that are on a single bib record

[Nicole Engard]

Cecil,

Just FYI more on this can be found on the wiki here:
http://wiki.koha-community.org/wiki/Holds_Rewrite_RFC

Nicole C. Engard
ByWater Solutions

On Thu, Jan 12, 2012 at 3:16 PM, Nicole Engard  wrote:
> Cecil,
>
> At this time it is not possible to place more than one copy of a title
> on hold for a single patron.  This development is in the works but is
> not yet in Koha.
>
> Nicole C. Engard
> ByWater Solutions
>
> 2012/1/12 Hillyard, Cecil :
>> Hi all,
>>
>> We are having a hard time placing multiple holds on bib records that have
>> multiple volumes on the same bibliographic records.  Some DVD sets have the
>> discs individually  cataloged/barcoded or Serial records that have
>> circulating items.  We get the message: Cannot place hold. Patron already
>> has a hold on this item.  This shows up even when the next available copy
>> box has been unchecked.
>>
>> Is it possible to place holds for a single patron on multiple volumes/items
>> of a single bibliographic record?
>>
>> Thanks,
>>
>> __
>>
>> Cecil Hillyard
>>
>> Cataloger
>>
>> Washoe County Library Technical Services
>>
>> P.O. Box 2151
>>
>> 301 S. Center St.
>>
>> Reno, NV 89505
>>
>> tel.: 775-327-8330
>>
>> fax: 775-327-8334
>>
>> www.washoecountylibrary.us
>>
>>
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Placing holds on multiple volumes that are on a single bib record

[Nicole Engard]

Cecil,

At this time it is not possible to place more than one copy of a title
on hold for a single patron.  This development is in the works but is
not yet in Koha.

Nicole C. Engard
ByWater Solutions

2012/1/12 Hillyard, Cecil :
> Hi all,
>
> We are having a hard time placing multiple holds on bib records that have
> multiple volumes on the same bibliographic records.  Some DVD sets have the
> discs individually  cataloged/barcoded or Serial records that have
> circulating items.  We get the message: Cannot place hold. Patron already
> has a hold on this item.  This shows up even when the next available copy
> box has been unchecked.
>
> Is it possible to place holds for a single patron on multiple volumes/items
> of a single bibliographic record?
>
> Thanks,
>
> __
>
> Cecil Hillyard
>
> Cataloger
>
> Washoe County Library Technical Services
>
> P.O. Box 2151
>
> 301 S. Center St.
>
> Reno, NV 89505
>
> tel.: 775-327-8330
>
> fax: 775-327-8334
>
> www.washoecountylibrary.us
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Need SQL for a report

[Nicole Engard]

PS. The ticket system is back up if you want to enter the answers to
my question there.

Nicole

On Thu, Jan 12, 2012 at 9:48 AM, Nicole Engard  wrote:
> Lesley,
>
> Thanks for bringing this to our attention, we are rebooting our server
> right now and it should be back up soon.
>
> What do you need to see on the report you're asking for?  Names,
> addresses or something else?  What are the 4 patron categories? Do you
> want to limit on a specific branch/category?
>
> Nicole C. Engard
> ByWater Solutions
>
> 2012/1/12 Lesley Kimball :
>> Hi everyone,
>>
>>   I'm having trouble getting onto ByWater Solutions's ticketing system and I
>> didn't find this report in the SQL Reports Library so I thought I would ask
>> the general brain…
>>
>>
>>
>> I need a report to get a list of patrons from 4 different Patron
>> Categories.  Has anyone already created something like this?  We are using
>> 3.4.
>>
>>
>>
>> Thanks!
>>
>> Lesley Kimball
>>
>>
>>
>> ~~
>> You see, I don't believe that libraries should be
>> drab places where people sit in silence, and that's
>> been the main reason for our policy of employing
>> wild animals as librarians.
>>    -- Monty Python, "Gorilla Librarian" sketch
>> ~~~
>> Lesley Kimball
>> Director
>> Wiggin Memorial Library
>> Stratham, NH
>> direc...@wigginml.org
>>
>>
>>
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Need SQL for a report

[Nicole Engard]

Lesley,

Thanks for bringing this to our attention, we are rebooting our server
right now and it should be back up soon.

What do you need to see on the report you're asking for?  Names,
addresses or something else?  What are the 4 patron categories? Do you
want to limit on a specific branch/category?

Nicole C. Engard
ByWater Solutions

2012/1/12 Lesley Kimball :
> Hi everyone,
>
>   I'm having trouble getting onto ByWater Solutions's ticketing system and I
> didn't find this report in the SQL Reports Library so I thought I would ask
> the general brain…
>
>
>
> I need a report to get a list of patrons from 4 different Patron
> Categories.  Has anyone already created something like this?  We are using
> 3.4.
>
>
>
> Thanks!
>
> Lesley Kimball
>
>
>
> ~~
> You see, I don't believe that libraries should be
> drab places where people sit in silence, and that's
> been the main reason for our policy of employing
> wild animals as librarians.
>    -- Monty Python, "Gorilla Librarian" sketch
> ~~~
> Lesley Kimball
> Director
> Wiggin Memorial Library
> Stratham, NH
> direc...@wigginml.org
>
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Serials Planning Help

[Nicole Engard]

Thanks for this! I'll give it a whirl.

Nicole

On Fri, Jan 6, 2012 at 3:52 PM, Eric Bégin  wrote:
> Nicole,
>
> I would use a X, Y, Z numbering pattern (Volume, number, Issue. Starting
> Volume at 42, starting Number at 7 and Issue at 8.
> Numbering formula is Volume {X} #{Y}/{Z}
>
> The trick is that you will have to use the Advanced Pattern since Y and Z
> must increment by 2 every time you receive an issue
>
> Values for X
> Add : 1
> once every: 6
> other values should be ok
>
> Values for Y
> Add : 2
> oncer every : 1
> When more than 12
> Set back to 1
>
> Values for Z
> Add : 2
> oncer every : 1
> When more than 12
> Set back to: 2
>
> I didn't try it but I'm pretty confident that it should work.
>
> Hope that helps,
>
> Eric Bégin
> www.inLibro.com
>
>
>
>
> On 2012-01-06 13:47, Nicole Engard wrote:
>
> I have a strange Serial planning question. American Libraries
> publishes 6 issue a year, and number them like this:
>
> Volume 42 #7/8
> Volume 42 #9/10
> Volume 42 #11/12
>
> Can anyone come up with a way to enter this in to  Koha to allow for
> this type of numbering? All I can come up with (and it's way sloppy)
> is to tell Koha that it's 12 issues a year and then delete every other
> issue and manually edit the volume/number field to show 7/8 or 9/10
> etc.
>
> Thanks in advance for any tips you can provide.
>
> Nicole
>
> PS. I am still looking for serials planning examples from all types of
> journals/magazines so that I can share them in the manual and save new
> Koha librarians time!
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Serials Planning Help

[Nicole Engard]

I have a strange Serial planning question. American Libraries
publishes 6 issue a year, and number them like this:

Volume 42 #7/8
Volume 42 #9/10
Volume 42 #11/12

Can anyone come up with a way to enter this in to  Koha to allow for
this type of numbering? All I can come up with (and it's way sloppy)
is to tell Koha that it's 12 issues a year and then delete every other
issue and manually edit the volume/number field to show 7/8 or 9/10
etc.

Thanks in advance for any tips you can provide.

Nicole

PS. I am still looking for serials planning examples from all types of
journals/magazines so that I can share them in the manual and save new
Koha librarians time!
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Download a list of titles and ISBNs in CSV export

[Nicole Engard]

The CSV profile is used for downloading lists and carts and individual
records. So if you go in to a list you'll see the download option and under
there you'll see your CSV Profile.  The same for the Cart and on the
individual record it's under 'Save' I think.

Nicole

2011/12/27 Hartman, David W. - GBTS Library 

> Hello all,
>
> ** **
>
>   I want to download a list of all my item titles (245 marc field) and
> ISBN (020 marc field).  That’s all .. just these two fields in a CSV format.
> 
>
> ** **
>
>   I have created a CSV export format with these two fields within Koha but
> I do not see an export/download command where I can use this CSV format?**
> **
>
> ** **
>
>   What is the command I need to download these two fields? 
>
> ** **
>
>   
>
> ** **
>
> *David W. Hartman*
> Global Business Technology Strategy Library
> Team Disney 336N
> 407 828 4250 (8-222)
> FAX 407 828 4868
>
> FOLLOW MY RESEARCH on Backlot   &   
> Yammer
> !
> Learn about our research partners in the 2011 IT Research Competency
> Center  
> GBTS CAST can click to request AV 
> Equipment,
> Books ,  & 
> Research
> WATCH the GBTS Library (Video) Update !
> CLICK for the GBTS VIRTUAL LIBRARY portal
> site!!
>
> "This communication is confidential, intended only for the named
> recipients above and may contain trade secrets or other information that is
> exempt from disclosure under applicable law. Any use, dissemination,
> distribution or copying of this communication by anyone other than the
> named recipients is strictly prohibited. If you have received this
> communication in error, please immediately notify us by calling (407)
> 828-4250. Thank you."
>
> [image: cid:075452218@28012009-07E4]*Please consider your environmental
> responsibility before printing this e-mail* *[image:
> cid:075452218@28012009-07EB]*
>
> *Think Environmentality!  Reduce!  Reuse!  Recycle!*
>
>  
>
> ** **
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
<>___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] 100 field

[Nicole Engard]

Estel,

You need to alter your BiblioAddsAuthorities system preference that's
controlling that field.  (
http://manual.koha-community.org/3.6/en/administration.html#BiblioAddsAuthorities
)

More info here:
http://manual.koha-community.org/3.6/en/catfaq.html#authorityfaq

Nicole

2011/12/22 Estel Porras 

> Hi I am a cataloger in California and I just have a quick question. I
> basically do copy-cataloging for a small Library in Northern CA. There are
> times, though, that I do have to generate an original record [for local
> history, self published, etc.]. When this happens I am unable to fill in
> the personal name field. It is grayed out and I cannot type anything there.
> I thought this could be changed by "authorizing" me to use this field, but
> cannot find how to turn this "on". I have tried to go to administration,
> but cannot seem to find the answer. Any input would be appreciated. Happy
> Holidays to all!
>
>  Have a great day, ~*Estel*~
> Orland Free Library
> 333 Mill St.
> Orland CA. 95963
> [530]865-1640
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Searching Tips in the Manual

[Nicole Engard]

Hello all,

I got a question recently about what fields were searched for the language
filter on the advanced search and I was going to add the answer to the
manual only to find that none of the fields are defined:
http://manual.koha-community.org/3.6/en/searchguide.html#searchguide-advanced

Do we know if there is documentation on this in zebra anywhere? Or does
anyone know (in a way that's quick and easy to answer) enough to tell me so
I can put something in the manual?

The searching guide that is in there was written for 3.0 and I honestly
never changed it because there is way too much about the search engine I
don't know and didn't know how to research.

Anyway, if you have some tips, places I should look, or information you
want to share please do!  You can just reply to all here or I also welcome
patches to the manual - but if you'd rather write it in a document or text
file go right ahead. I will credit you for the parts you write of course!

Thanks in advance,
Nicole

PS. I'm looking for tips that will help the users like the fact that the
language index populates from 008 (chars 35-37), and 041adej
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Regarding the book entry

[Nicole Engard]

This might help with cataloging:
http://bywatersolutions.com/2010/09/15/copy-cataloging-in-koha-3-2/

And these manual pages will help with Z39 & Zotero:

http://manual.koha-community.org/3.6/en/opacenhancedcontent.html#zotero
http://manual.koha-community.org/3.6/en/additionaladmin.html#z3950admin

Nicoe

2011/12/8 dawit.aya...@tabyengineering.com 

> **
> Dear sure,
>
> I can't manage to insert book to the koha library and also connect the
> z3950 it would be great if you guys give me small examples and steps to be
> done. Thanks!!!   I also tried zotero to perform this task but I can't
> manage to get it work with koha ILS.
>
>
>
> Best Regards,
> --
> * Dawit Ayalew
>
> Software Development
> TABY Engineering P.L.C. at GIZ IS
>
> Bole Road, TK International Building No. 2
> 5th Floor Room No. 502
> Addis Ababa, Ethiopia
>
> T: +251 11 662 22 60 Ext. 5024
>+251 11 618 38 50
> M: +251 91 180 07 08
> E: dawit.aya...@tabyengineering.com
> I: www.tabyengineering.com
>
> *
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Primary & secondary email addresses

[Nicole Engard]

I signed off :)

On Tue, Dec 6, 2011 at 10:20 AM, Fischer, Katrin
wrote:

> Hi, 
>
> ** **
>
> I have done a patch to ‘unlump’ them that is waiting for sign off:
>
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6302
>
> ** **
>
> I have also done some work on renaming AutoEmailPrimaryAddress to
> EmailPrimaryAddress. But it needs a database update, so I am waiting for
> this discussion to be resolved.
>
> ** **
>
> Katrin
>
> ** **
>
> *From:* koha-boun...@lists.katipo.co.nz [mailto:
> koha-boun...@lists.katipo.co.nz] *On Behalf Of *Nicole Engard
> *Sent:* Tuesday, December 06, 2011 3:50 PM
> *To:* Ian Walls
> *Cc:* koha@lists.katipo.co.nz
> *Subject:* Re: [Koha] Primary & secondary email addresses
>
> ** **
>
> Those preferences need to be un-lumped together to prevent this kind of
> confusion.
>
> Nicole
>
> 2011/12/6 Ian Walls 
>
> Cab,
>
>
> The system preference text is misleading; AutoEmailPrimaryAddress applies
> to more than just new account messaging.  Notices also use this preference
> to find the right email address field.
>
>
> -Ian
>
> ** **
>
> On Tue, Dec 6, 2011 at 9:42 AM, Cab Vinton  wrote:
>
> In our version of Koha the AutoEmailPrimaryAddress preference reads:
>
> "Send/ Don't send an email to newly created patrons with their account
> details at their alternate/ etc. email address".
>
> So, presumably would not apply to notices?
>
> From searching this preference on bugzilla
> (http://bugs.koha-community.org), it looks like there's some work
> being done in this area, however.
>
> Will have to remember to search the system prefs & bugzilla before posting!
> 
>
>
> Cheers,
>
> Cab Vinton, Director
> Sanbornton Public Library
> Sanbornton, NH
>
> "Politeness and consideration for others is like investing pennies and
> getting dollars back." Thomas Sowell
>
>
> 
>
> 2011/12/6 Ian Walls :
>
> > There is a system preferenece, AutoEmailPrimaryAddress, that determines
> > which email is used to send notices.  One of the options, "first valid",
> > checks the emails in the order: primary, secondary, alternate.  The first
> > field that is populated with a valid email address (on a per-user basis)
> is
> > used to send the notices.
> >
> > I recommend you verify that setting first, then proceed from there.
> >
> > Cheers,
> >
> >
> > -Ian
> >
> >
> > On Tue, Dec 6, 2011 at 2:27 AM, R Sunil Kumar <
> sunil.ku...@ecoleglobal.com>
> > wrote:
> >>
> >> Dear All,
> >>
> >> I am also facing the same problem for email notices. Notices are only
> >> received by member who has given the primary email id for Koha 3.04
> >>
> >> My problem is that, email are not send to all the patron who's email id
> is
> >> given in the primary section, email is going to only ONE patron.
> >> Eventhough
> >> primary email id are given in some accounts. Secondly majority of the
> >> email
> >> id is given in the secondary email ID section and koha is not picking
> the
> >> secondary email id for sending the reminder.
> >>
> >> Can anybody have a solution/suggestion.
> >>
> >> Thanks and Regards
> >>
> >> R Sunil Kumar
> >> Library Technologist
> >> +91-9686576695
> >>
> >> -Original Message-
> >> From: koha-boun...@lists.katipo.co.nz
> >> [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of
> >> koha-requ...@lists.katipo.co.nz
> >> Sent: 06 December 2011 04:30
> >> To: koha@lists.katipo.co.nz
> >> Subject: Koha Digest, Vol 74, Issue 12
> >>
> >> Send Koha mailing list submissions to
> >>koha@lists.katipo.co.nz
> >>
> >> To subscribe or unsubscribe via the World Wide Web, visit
> >>http://lists.katipo.co.nz/mailman/listinfo/koha
> >> or, via email, send a message with subject or body 'help' to
> >>koha-requ...@lists.katipo.co.nz
> >>
> >> You can reach the person managing the list at
> >>koha-ow...@lists.katipo.co.nz
> >>
> >> When replying, please edit your Subject line so it is more specific
> >> than "Re: Contents of Koha digest..."
> >>
> >>
> >> Today's Topics:
> >>
> >>   1. Re: Problems with Apache when trying to access Koha Admin
> >>  (culiforge)
&g

Re: [Koha] Primary & secondary email addresses

[Nicole Engard]

Those preferences need to be un-lumped together to prevent this kind of
confusion.

Nicole

2011/12/6 Ian Walls 

> Cab,
>
>
> The system preference text is misleading; AutoEmailPrimaryAddress applies
> to more than just new account messaging.  Notices also use this preference
> to find the right email address field.
>
>
> -Ian
>
>
> On Tue, Dec 6, 2011 at 9:42 AM, Cab Vinton  wrote:
>
>> In our version of Koha the AutoEmailPrimaryAddress preference reads:
>>
>> "Send/ Don't send an email to newly created patrons with their account
>> details at their alternate/ etc. email address".
>>
>> So, presumably would not apply to notices?
>>
>> From searching this preference on bugzilla
>> (http://bugs.koha-community.org), it looks like there's some work
>> being done in this area, however.
>>
>> Will have to remember to search the system prefs & bugzilla before
>> posting!
>>
>> Cheers,
>>
>> Cab Vinton, Director
>> Sanbornton Public Library
>> Sanbornton, NH
>>
>> "Politeness and consideration for others is like investing pennies and
>> getting dollars back." Thomas Sowell
>>
>>
>>
>> 2011/12/6 Ian Walls :
>> > There is a system preferenece, AutoEmailPrimaryAddress, that determines
>> > which email is used to send notices.  One of the options, "first valid",
>> > checks the emails in the order: primary, secondary, alternate.  The
>> first
>> > field that is populated with a valid email address (on a per-user
>> basis) is
>> > used to send the notices.
>> >
>> > I recommend you verify that setting first, then proceed from there.
>> >
>> > Cheers,
>> >
>> >
>> > -Ian
>> >
>> >
>> > On Tue, Dec 6, 2011 at 2:27 AM, R Sunil Kumar <
>> sunil.ku...@ecoleglobal.com>
>> > wrote:
>> >>
>> >> Dear All,
>> >>
>> >> I am also facing the same problem for email notices. Notices are only
>> >> received by member who has given the primary email id for Koha 3.04
>> >>
>> >> My problem is that, email are not send to all the patron who's email
>> id is
>> >> given in the primary section, email is going to only ONE patron.
>> >> Eventhough
>> >> primary email id are given in some accounts. Secondly majority of the
>> >> email
>> >> id is given in the secondary email ID section and koha is not picking
>> the
>> >> secondary email id for sending the reminder.
>> >>
>> >> Can anybody have a solution/suggestion.
>> >>
>> >> Thanks and Regards
>> >>
>> >> R Sunil Kumar
>> >> Library Technologist
>> >> +91-9686576695
>> >>
>> >> -Original Message-
>> >> From: koha-boun...@lists.katipo.co.nz
>> >> [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of
>> >> koha-requ...@lists.katipo.co.nz
>> >> Sent: 06 December 2011 04:30
>> >> To: koha@lists.katipo.co.nz
>> >> Subject: Koha Digest, Vol 74, Issue 12
>> >>
>> >> Send Koha mailing list submissions to
>> >>koha@lists.katipo.co.nz
>> >>
>> >> To subscribe or unsubscribe via the World Wide Web, visit
>> >>http://lists.katipo.co.nz/mailman/listinfo/koha
>> >> or, via email, send a message with subject or body 'help' to
>> >>koha-requ...@lists.katipo.co.nz
>> >>
>> >> You can reach the person managing the list at
>> >>koha-ow...@lists.katipo.co.nz
>> >>
>> >> When replying, please edit your Subject line so it is more specific
>> >> than "Re: Contents of Koha digest..."
>> >>
>> >>
>> >> Today's Topics:
>> >>
>> >>   1. Re: Problems with Apache when trying to access Koha Admin
>> >>  (culiforge)
>> >>   2. Primary & secondary email addresses (Cab Vinton)
>> >>   3. Re: Improving permissions on lists (virtual shelves) (Robin Sheat)
>> >>   4. Re: Search by copy number not working properly (Marijana Glavica)
>> >>
>> >>
>> >> --
>> >>
>> >> Message: 1
>> >> Date: Mon, 5 Dec 2011 10:59:48 -0800 (PST)
>> >> From: culiforge 
>> >> To: koha@lists.katipo.co.nz
>> >> Subject: Re: [Koha] Problems with Apache when trying to access Koha
>> >>Admin
>> >> Message-ID: <1323111588693-5049780.p...@n5.nabble.com>
>> >> Content-Type: text/plain; charset=us-ascii
>> >>
>> >> I found this post and it's exactly the issue I'm having.
>> >> the problem is... I'm new to Linux, koha and mysql and therefore don't
>> >> quite
>> >> know how to follow through on the solution given.
>> >>
>> >> speak slowly and use small words and I will be grateful.
>> >>
>> >> cul
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> >>
>> http://koha.1045719.n5.nabble.com/Problems-with-Apache-when-trying-to-access
>> >> -Koha-Admin-tp5037373p5049780.html
>> >> Sent from the Koha-general mailing list archive at Nabble.com.
>> >>
>> >>
>> >> --
>> >>
>> >> Message: 2
>> >> Date: Mon, 5 Dec 2011 16:46:59 -0500
>> >> From: Cab Vinton 
>> >> To: Koha list 
>> >> Subject: [Koha] Primary & secondary email addresses
>> >> Message-ID:
>> >>
>> >>  
>> >> Content-Type: text/plain; charset=ISO-8859-1
>> >>
>> >> Does anyone know how Koha (3.04.02) handles emailed notices when there
>> >> is a second

Re: [Koha] Improving permissions on lists (virtual shelves)

[Nicole Engard]

On Mon, Dec 5, 2011 at 8:19 AM, Marcel de Rooy wrote:

>  ** **
>
> ** **
>
> 1  Do not allow to create a public list in the OPAC. (Only private lists.)
>  Public lists are only created by staff users in the staff client.
>
>
> I think this should be a preference that the librarians can choose from
> the following options :
>
>1. Allow anyone to create public lists without moderation
>2. Allow patrons to create public lists with moderation
>3. Allow only staff (with permission) to create public lists
>  
>
> Brooke came up with an idea where the patron asks staff to upgrade a
> private list to a public list or so..
>

That would be the same as my 'moderation' request - except that the staff
get to choose whether they moderate lists at all. It's more work for the
staff, so they should have a say in the matter. Like with the patron
submitting edits to their account - librarians can turn this option off if
it's too much work for them (or if they have other reasons).

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Improving permissions on lists (virtual shelves)

[Nicole Engard]

Comments in line below:

On Mon, Dec 5, 2011 at 5:42 AM, Marcel de Rooy wrote:

> Hi all,
>
> Still hoping to get some feedback on this subject, I would now propose the
> following. Please respond to the list, if you agree or disagree.
>
> 1  Do not allow to create a public list in the OPAC. (Only private lists.)
>  Public lists are only created by staff users in the staff client.
>

I think this should be a preference that the librarians can choose from the
following options :

   1. Allow anyone to create public lists without moderation
   2. Allow patrons to create public lists with moderation
   3. Allow only staff (with permission) to create public lists


> 2  Add three permission options to any list: a) Allow adding entries b)
> Allow deleting your own entries (that you added)  and c) Allow deleting
> entries that someone else added.
>   This makes the distinction between public list and open list no longer
> needed and adds some refinement in lists management.
>   Only the owner of the list can change these permissions.
>

In addition I'd say we need general staff list permissions which we don't
have right now.


> 3  Add a new (opac) feature to private lists: Share a list (with another
> patron).
>   Let the user share access to a list by Koha sending an email with a URL
> including some (temporary) invitation key. When the invited patron clicks
> that URL (when logged in) he gains access (in accordance with the described
> permission options for that specific list).
>   The invited patron can always 'delete' the shared list, i.e. delete the
> share.
>   The owner can 'unshare' the list and remove all shares for that list.
>

I like!


> 4  With respect to user privacy, a feature may be added in staff client to
> moderate shared list names.
>

Right now patron names don't show on lists at all - not sure if we need
them really.


> 5  Possibly, libraries do not want patrons sharing lists. So the option
> could be disabled with a preference. In that case points 2 and 3 still
> apply.
>

Yes, preferences to turn things off are always good.


>
> Note that the shared private list concept makes report 7281 (Hiding some
> lists) obsolete.
> Bug 7310 will be used for this feature.
>
> Your comments are very welcome!
>
> Marcel
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] how to restore deleted marc record/items

[Nicole Engard]

Tanzeem,

You'll need to know the biblionumbers you want to restore. And then you
need to move them out of the deleted tables and in to the original tables.
So if you want to restore biblionumber 100 you'd do something like this:

insert into biblio (select * from deletedbiblio where biblionumber=100);
delete from deletedbiblio where biblionumber=100;
insert in to items (select * from deleteditems where biblionumber=100);
delete from deleteditems where biblionumber=100;
insert in to biblioitems (select * from deletedbiblioitems where
biblionumber=100);
delete from deletedbiblioitems where biblionumber=100;

Of course you want to back up your database before doing anything like
that, but right now there is no way to restore records in the GUI, so you
have to do it in the DB.

Nicole

On Wed, Nov 23, 2011 at 1:49 AM, tanzeem  wrote:

> Hi
>
> I want to restore some of the already deleted records
> I am currently tinkering with the koha database tables-
> deletedbiblio,deleteditms,deletedbiblioitems
> Can anyone guide me in the currect path to do the restore properly
>
> thanks in advance
>
> --
> View this message in context:
> http://koha.1045719.n5.nabble.com/how-to-restore-deleted-marc-record-items-tp5015705p5015705.html
> Sent from the Koha-general mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Address or location on Koha routing list

[Nicole Engard]

Right now this isn't possible, but there is a development to make all slips
customizable - I'm not sure it will include the Routing slips, but it's a
step in the direction you're looking for.

Nicole C. Engard

2011/11/23 Hartman, David W. - GBTS Library 

> ** **
>
> Hello!
>
> ** **
>
>   I am using the Koha serials module and was wondering if there was any
> way to add a location or address next to the patron name?  I’d love to be
> able to put a floor number/location next to it, if possible.
>
> ** **
>
>   As always, thanks to you all!!!
>
> *David W. Hartman*
> Global Business Technology Strategy Library
> Team Disney 336N
> 407 828 4250 (8-222)
> FAX 407 828 4868
>
> FOLLOW MY RESEARCH on Backlot   &   
> Yammer
> !
> Learn about our research partners in the 2011 IT Research Competency
> Center  
> GBTS CAST can click to request AV 
> Equipment,
> Books ,  & 
> Research
> WATCH the GBTS Library (Video) Update !
> CLICK for the GBTS VIRTUAL LIBRARY portal
> site!!
>
> "This communication is confidential, intended only for the named
> recipients above and may contain trade secrets or other information that is
> exempt from disclosure under applicable law. Any use, dissemination,
> distribution or copying of this communication by anyone other than the
> named recipients is strictly prohibited. If you have received this
> communication in error, please immediately notify us by calling (407)
> 828-4250. Thank you."
>
> [image: cid:075452218@28012009-07E4]*Please consider your environmental
> responsibility before printing this e-mail* *[image:
> cid:075452218@28012009-07EB]*
>
> *Think Environmentality!  Reduce!  Reuse!  Recycle!*
>
>  
>
> ** **
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
<>___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] Plea for help from Horowhenua Library Trust re: Koha

[Nicole Engard]

Joann,

In addition to money, if you think a petition signed by members of the
community from around the world will help with your appeal then maybe there
is a way we can all e-sign one for you.

I'm so sorry you're having to deal with this :(

Nicole

2011/11/21 Joann Ransom 

> Hi everyone,
>
> Thank you so much for your speedy and supportive replies ... I'm feeling a
> little less despairing now :)
>
> I have set up a PayPal account for gathering funds towards mounting a
> legal challenge. It is a separate account from the HLT
>  operating accounts and I am very happy to give a community representative
> access to the records etc.
>
> So here it is:
> https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=FQ6JH3L48LV5Y
>
> And thanks :)
>
> Cheers Jo.
>
>
> On 22 November 2011 12:09, Christopher Nighswonger <
> chris.nighswon...@gmail.com> wrote:
>
>> By all means setup a donations page... quick! :-)
>>
>> Kind Regards,
>> Chris
>>
>>
>> 2011/11/21 Liz Rea 
>>
>>> It is so sad to see the gift you gave us all fall into unfriendly hands.
>>>
>>> Do please let us know when the kitty is opened up for donations.
>>>
>>> Liz Rea
>>> l...@nekls.org
>>>
>>>
>>>
>>>
>>> On Nov 21, 2011, at 3:31 PM, Joann Ransom wrote:
>>>
>>> > As I am sure most of you are aware, Horowhenua Library Trust is the
>>> birth place of Koha and the longest serving member of the Koha community.
>>> Back in 1999 when we were working on Koha, the idea that 12 years later we
>>> would be having to write an email like this never crossed our minds. It is
>>> with tremendous sadness that we must write this plea for help to you, the
>>> other members of the Koha community.
>>> >
>>> > The situation we find ourselves in, is that after over a year of
>>> battling against it, PTFS/Liblime have managed to have their application
>>> for a Trademark on Koha in New Zealand accepted. We now have 3 months to
>>> object, but to do so involves lawyers and money. We are a small semi rural
>>> Library in New Zealand and have no cash spare in our operational budget to
>>> afford this, but we do feel it is something we must fight.
>>> >
>>> > For the library that invented Koha to now have to have a legal battle
>>> to prevent a US company trademarking the word in NZ seems bizarre, but it
>>> is at this point that we find ourselves.
>>> >
>>> > So, we ask you, the users and developers of Koha, from the birth place
>>> of Koha, please if you can help in anyway, let us know.
>>> >
>>> > Regards,
>>> >
>>> > Jo.
>>> >
>>> > --
>>> > Joann Ransom RLIANZA
>>> > Head of Libraries,
>>> > Horowhenua Library Trust.
>>> >
>>> > ___
>>> > Koha-devel mailing list
>>> > koha-de...@lists.koha-community.org
>>> > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>> > website : http://www.koha-community.org/
>>> > git : http://git.koha-community.org/
>>> > bugs : http://bugs.koha-community.org/
>>>
>>>
>>> ___
>>> Koha-devel mailing list
>>> koha-de...@lists.koha-community.org
>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>> website : http://www.koha-community.org/
>>> git : http://git.koha-community.org/
>>> bugs : http://bugs.koha-community.org/
>>>
>>
>>
>
>
> --
> Joann Ransom RLIANZA
> Head of Libraries,
> Horowhenua Library Trust.
>
>
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Holds to Pull

[Nicole Engard]

Liz,

But what content is showed on the holds queue?  Is it only holds that are
available in the library right now? or all holds on items that are
available and checked out?

Nicole

On Thu, Nov 17, 2011 at 10:14 AM, Liz Rea  wrote:

> This is NEKLS experience as well.
>
> The hold queue does a few things.
>
> 1. It has a cron job that runs periodically, regenerating the list.
> 2. The list is weighted based on a couple of system preferences. This
> becomes important in consortia where you might want one library to be
> preferred over another (to, say, keep a small library with a great
> collection from being utterly inundated with hold requests, for example)
> 3. The layout is a little nicer.
>
> Holds to Pull does the following:
> 1. Shows every hold across all libraries
> 2. Shows which libraries have copies of an item that can fill a hold
> (unlike the hold queue, which picks a specific library's item)
> 3. Is useful, but not in the same way as the hold queue.
>
> If it helps you frame it, in Sirsi the Hold Queue was similar
> functionality to the Pick List.
>
> If you accept the default cron job, the build_holds_queue cron will run
> every hour. NEKLS chooses (for various reasons) to run it only 3 times a
> day. We use the holds queue exclusively for managing our holds.
>
> I hope this helps.
>
> Liz Rea
> l...@nekls.org
>
>
> On Nov 16, 2011, at 1:42 PM, Nora Blake wrote:
>
> Nicole,
> ** **
> I know nothing of the code of Koha but what you describe for Holds to Pull
> and Holds Queue is exactly the opposite of our experience.  In our shared
> Koha when we look at “Hold to Pull” we see every blessed hold request that
> is open.  When we go to “Holds Queue” and select a library from that list
> we see only the open holds that site has to fill.
> ** **
> But again, I can’t point to code to support this.
> ** **
> Nora
> 
>
> Nora Blake
> MassCat Manager
> Massachusetts Library System
> P.O. Box 609
> South Deerfield, MA 01373-0241
> 508-357-2121 x123
> 866-627-7228
> Email: nbl...@masslibsystem.org
> AIM: noraatmls
> ** **
> *From:* koha-boun...@lists.katipo.co.nz [mailto:
> koha-boun...@lists.katipo.co.nz] *On Behalf Of *Nicole Engard
> *Sent:* Wednesday, November 16, 2011 12:20 PM
> *To:* NCRL Support
> *Cc:* koha@lists.katipo.co.nz
> *Subject:* Re: [Koha] Holds to Pull
> ** **
>
> I'm here with Barb and to those of you who replied to her saying to use
> the Holds Queue, it's my understanding that the Holds Queue is showing you
> titles that are for pickup at the branch you choose - can someone who knows
> the code please tell me what branch the Holds Queue is looking at.  I wrote
> a report (
> http://wiki.koha-community.org/wiki/SQL_Reports_Library#Holds_to_Pull_at_Branch)
> to show the holds to pull list based on books owned by the library and it's
> on the wiki and it's what most people I train are using because the way I
> understand things is this:
>
> - Holds Queue is all holds (regardless of whether they're checked out or
> on the shelf) that need to be picked up at the branch
> - Holds to Pull should be a list of all items on the shelf at your library
> that have holds on them that you need to pull to trigger the hold
>
> In addition to helping Barbara, your answer will help me fix the manual to
> make it clearer for all.
>
> Nicole
> 2011/11/15 NCRL Support 
> I would first like to say hello to everyone as this is my first post. We
> are currently training with Nicole and have a go live date set for January
> 9th. 
> ** **
> We are a multi-branch library system and would like to know how other
> libraries are handling the "holds to pull" report.  
>
> ** **
> Barbara Walters
> North Central Regional Library  
> bwalt...@ncrl.org | 509.679.5550
> ** **
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
> ** **
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
<>___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] letterlog question

[Nicole Engard]

The LetterLog preference says 'Log/Don't log' when an automatic claim
notice is sent.

My question is does this log only track claim notices? or all
letters/notices?

Thanks
Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Holds to Pull

[Nicole Engard]

I'm here with Barb and to those of you who replied to her saying to use the
Holds Queue, it's my understanding that the Holds Queue is showing you
titles that are for pickup at the branch you choose - can someone who knows
the code please tell me what branch the Holds Queue is looking at.  I wrote
a report (
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Holds_to_Pull_at_Branch)
to show the holds to pull list based on books owned by the library and it's
on the wiki and it's what most people I train are using because the way I
understand things is this:

- Holds Queue is all holds (regardless of whether they're checked out or on
the shelf) that need to be picked up at the branch
- Holds to Pull should be a list of all items on the shelf at your library
that have holds on them that you need to pull to trigger the hold

In addition to helping Barbara, your answer will help me fix the manual to
make it clearer for all.

Nicole

2011/11/15 NCRL Support 

> I would first like to say hello to everyone as this is my first post. We
> are currently training with Nicole and have a go live date set for January
> 9th.
>
> We are a multi-branch library system and would like to know how other
> libraries are handling the "holds to pull" report.
>
>
> Barbara Walters
> North Central Regional Library
> bwalt...@ncrl.org | 509.679.5550
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Barcodes in OPAC Display

[Nicole Engard]

Parjeesh,

This isn't exactly what you want, but here is how to show patrons the
barcodes of the items they have checked out:

http://manual.koha-community.org/3.6/en/faqs.html#opacbarcodesfaq

Nicole

2011/11/11 Prajeesh 

> If anyone know how to include Barcodes in OPAC display, please tell me.
>
> In my OPAC, holdings are diplaying with following elements- Item Type,
> Location, Call Number, Status, Due Date.
>
> --
> With Regards
>
> Prajeesh Bhaskaran
> Mahatma Gandhi University Library
> Kerala.
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Acquisition module

[Nicole Engard]

James,

That won't do the trick - but this will:

SELECT name from aqbooksellers order by name asc

And you're right about not being able to delete.

Nicole

2011/11/7 James Ghiorzi 

>  Hi Massimo,
>
> I believe that there is currently no way to delete a vendor using the
> client interface (there might be a way using SQL, but I wouldn't know how
> to do it).
>
> The list of vendors here is my amateurish stab at it:
>
>
> SELECT v.name AS vendor
> FROM aqorders o
> Order by v.name ASC
>
> Hope that helps,
>
> James Ghiorzi
> Library Assistant II
> San Benito County Free Library
> 470 Fifth ST.
> Hollister, CA 95023
>
>
>
>  --
> *From:* koha-boun...@lists.katipo.co.nz [koha-boun...@lists.katipo.co.nz]
> On Behalf Of Massimo Plevani [max_pl...@hotmail.it]
> *Sent:* Monday, November 07, 2011 8:19 AM
> *To:* koha@lists.katipo.co.nz
> *Subject:* [Koha] Acquisition module
>
>   Dear all,
> I started to work with acquisition module. I have some questions:
>
>  1. How can I delete a vendors?
> 2. Can I see the list of vendors (e.g Alphabeticaly ordered)?
>
>  Thanks you for your help. All the best.
>
>  Massimo Plevani
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Staged marc import and 952 field

[Nicole Engard]

On Sat, Nov 5, 2011 at 5:14 AM, Marijana Glavica  wrote:

> In Koha 3.6 you don't have filed 952 any more in MARC record at biblio
> level.


It should be noted that while this field isn't in the MARC anymore, it is
still used on the MARC import tool as the item record. So if you're
importing records that have a 952 Koha will use that as the item record
still - it will just take the data out of the 952 and put it in to the
items table in the database.

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Acquisitions Question - Order from Staged

[Nicole Engard]

Thank you!

On Tue, Nov 1, 2011 at 4:29 PM, Liz Rea  wrote:

> I believe it's the 020$c. There's a bug when you have multiple prices in
> there (say, US and CAN).
>
> Liz Rea
> l...@nekls.org
>
>
>
>
> On Nov 1, 2011, at 2:18 PM, Nicole Engard wrote:
>
> > When you order from a staged file in acquisitions if you choose to
> Import All the records in the staged file at once it puts in pricing
> information. Can someone tell me what field it's pulling this pricing
> information from?
> >
> > Nicole
> > ___
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Acquisitions Question - Order from Staged

[Nicole Engard]

When you order from a staged file in acquisitions if you choose to Import
All the records in the staged file at once it puts in pricing information.
Can someone tell me what field it's pulling this pricing information from?

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Documentation - another slight change

[Nicole Engard]

Tom,

There is a category for documentation bugs in bugzilla:
http://bugs.koha-community.org if you'd like to remove the problems as you
find them.

I also accept any and all help in updating the manual :) There isn't much on
the wiki about that but there is a page:
http://wiki.koha-community.org/wiki/Editing_the_Koha_Manual and I can help
you if you want to get involved.

Nicole

PS. I'm finding out about this preference, but note that it does not work if
you're using Zebra.

2011/10/6 Tom Hanstra 

> **
> Nicole,
>
> Another thing I noticed.  In
>
>   1.13.1.6. QueryRemoveStopwords
>  it looks like the functionality in the current version has changed
> slightly from what you have in the docs.
>
> Tom
>
> --
>
>
> -
>  Tom Hanstra  Systems Administrator
>  Hesburgh Libraries of Notre Dame Phone: (574)631-4686
>  213 Hesburgh Library Email: t...@nd.edu
>  Notre Dame, IN  46556
>
>  Every day, from here to there, funny things are everywhere.
>  Dr. Seuss
> -
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Ceiling due date

[Nicole Engard]

Oops,
Okay I'll add it  to the manual.

Nicole

On Thu, Oct 6, 2011 at 12:56 PM, Tom Hanstra  wrote:

> Sorry, yes.  Typo.
>
> Tom
>
>
> On 10/06/2011 12:47 PM, Owen Leonard wrote:
>
>> I also noticed that the Circulation-Interface option "UseTablesoftForCirc"
 is not in the documentation.

>>> UseTablesortForCirc ?
>>
>>   -- Owen
>>
>>
> --
>
>
> --**--**
> -
> Tom Hanstra  Systems Administrator
> Hesburgh Libraries of Notre Dame Phone: (574)631-4686
> 213 Hesburgh Library Email: t...@nd.edu
> Notre Dame, IN  46556
>
> Every day, from here to there, funny things are everywhere.
> Dr. Seuss
> --**--**
> -
>
> __**_
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/**mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Ceiling due date

[Nicole Engard]

Tom,

Remember to reply to all so the list can help.

I've never seen that preference. Are you on an official Koha release?

Nicole

On Thu, Oct 6, 2011 at 12:35 PM, Tom Hanstra  wrote:

> **
> Nicole,
>
> Thanks for this info.
>
> I also noticed that the Circulation-Interface option "UseTablesoftForCirc"
> is not in the documentation.  Is that new, overlooked, or documented
> elsewhere?
>
> Thanks,
> Tom
>
>
> On 10/06/2011 11:34 AM, Nicole Engard wrote:
>
> Oops, I think that was moved to the circulation matrix in 3.4 and I forgot
> to remove it from the manual. Can someone on 3.4 please confirm for me so I
> can update the manual.
>
> Tom go to Admin > Circulation & Fine Rules and you'll see the Hard Due Date
> column.
> http://manual.koha-community.org/3.4/en/patscirc.html#circfinerules
>
> Nicole
>
> 2011/10/6 Tom Hanstra 
>
>>  In the Koha 3.4 documentation, there is mention of a Circulation option:
>>
>>   1.5.1.6. ceilingDueDate
>>  But I don't actually see that in our installation of Koha 3.4.5.  Did I
>> miss something on install?  We think this would actually be a useful setting
>> here.
>>
>> Thanks,
>> Tom
>>
>> --
>>
>>
>> -
>>  Tom Hanstra  Systems Administrator
>>  Hesburgh Libraries of Notre Dame Phone: (574)631-4686
>>  213 Hesburgh Library Email: t...@nd.edu
>>  Notre Dame, IN  46556
>>
>>  Every day, from here to there, funny things are everywhere.
>>  Dr. Seuss
>> -
>>
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
>
> --
>
>
> -
>  Tom Hanstra  Systems Administrator
>  Hesburgh Libraries of Notre Dame Phone: (574)631-4686
>  213 Hesburgh Library Email: t...@nd.edu
>  Notre Dame, IN  46556
>
>  Every day, from here to there, funny things are everywhere.
>  Dr. Seuss
> -
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Ceiling due date

[Nicole Engard]

Oops, I think that was moved to the circulation matrix in 3.4 and I forgot
to remove it from the manual. Can someone on 3.4 please confirm for me so I
can update the manual.

Tom go to Admin > Circulation & Fine Rules and you'll see the Hard Due Date
column.  http://manual.koha-community.org/3.4/en/patscirc.html#circfinerules

Nicole

2011/10/6 Tom Hanstra 

> **
> In the Koha 3.4 documentation, there is mention of a Circulation option:
>
>   1.5.1.6. ceilingDueDate
>  But I don't actually see that in our installation of Koha 3.4.5.  Did I
> miss something on install?  We think this would actually be a useful setting
> here.
>
> Thanks,
> Tom
>
> --
>
>
> -
>  Tom Hanstra  Systems Administrator
>  Hesburgh Libraries of Notre Dame Phone: (574)631-4686
>  213 Hesburgh Library Email: t...@nd.edu
>  Notre Dame, IN  46556
>
>  Every day, from here to there, funny things are everywhere.
>  Dr. Seuss
> -
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Fwd: Open Source Research Help Needed Please!

[Nicole Engard]

I did comment on that in the final question and said that many open source
projects use the model we do (mailing list/Irc).

Nicole

On Wed, Oct 5, 2011 at 8:45 AM, Owen Leonard  wrote:

> > We are requesting approximately 15 minutes of your time to participate in
> > our survey.
> > Survey link:
> http://survey.utk.edu/mrIWeb/mrIWeb.dll?I.Project=FORUMLEARN
>
> I find it strange that Koha is included on this list, since the
> questions are specifically about web-based forums as might be powered
> by vBulletin or phpBB--*not* mailing lists. Many questions are about
> the usefulness of functions specific to that kind of software.
>
> Also, start counting up all your posts to the mailing list if you want
> to answer accurately ;)
>
>  -- Owen
>
> --
> Web Developer
> Athens County Public Libraries
> http://www.myacpl.org
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Fwd: Open Source Research Help Needed Please!

[Nicole Engard]

This came across the Bugzilla list and I thought some of you might be
interested in it.

-- Forwarded message --
From: Lila Holt 
Date: Tue, Oct 4, 2011 at 8:49 PM
Subject: Open Source Research Help Needed Please!
To: support-bugzi...@lists.mozilla.org


Hello!

We are asking you for some help from the Open Source communities.

As researchers at the University of Tennessee we are interested in
discovering more about learning and interactions of members of the open
source forums.   This research is conducted through the University of
Tennessee and is in no way associated with any forum organization.  To
further our research we would like input from forum members.  The responses
are very important to us so we can better understand what tools help forum
members learn and have a productive experience in participation.

There are two ways you can help:

1.   Take a survey about the tools you use in the forum.

We are requesting approximately 15 minutes of your time to participate in
our survey.
Survey link:  http://survey.utk.edu/mrIWeb/mrIWeb.dll?I.Project=FORUMLEARN



*As a thank you, upon exiting the survey you will be given an opportunity to
submit information to be entered in a drawing for a tablet computer (iPad).
 *



2.  Have a one on one interview talking about the forums, how you learn,
and tools used.  *As a thank you for your interview you will be sent a
$25.00 gift card. * Email lh...@utk.edu for more information.





You may do either or both of the above.  Please be assured that your answers
will be confidential.  No individual’s answers will ever be identified in
any report. Should you have any questions about the project or our interest
in using the results, we encourage you to contact Lila Holt, at
lh...@utk.edu) or Vandana Singh at vand...@utk.edu.




Contact information you provide for the drawing is completely separate from
your survey answers and there will be no way to identify participants in the
actual survey responses. Nor will contact information be used for any other
purpose. The odds of being selected will depend on the number of respondents
to this survey.


Thank you so much!
___
support-bugzilla mailing list
support-bugzi...@lists.mozilla.org
https://lists.mozilla.org/listinfo/support-bugzilla
PLEASE put support-bugzi...@lists.mozilla.org in the To: field when you
reply.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Customizing Koha Staff client: how to remove News, Welcome to koha message and What's next messages

[Nicole Engard]

Learn more about News here:
http://manual.koha-community.org/3.6/en/tools.html#newstool

On Tue, Oct 4, 2011 at 3:11 PM, Owen Leonard  wrote:

> > How do i remove the welcome to koha paragraph from the main page of koha
> > staff client
>
> Try clicking the "delete" link at the bottom of the paragraph.
>
>  -- Owen
>
> --
> Web Developer
> Athens County Public Libraries
> http://www.myacpl.org
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Sopac2

[Nicole Engard]

I had a copy of the SOPAC installation guide from BibLibre and
translated it to English (the best I could) for the manual:
http://manual.koha-community.org/3.6/en/sopac.html if that helps.

Nicole

On Wed, Sep 21, 2011 at 4:13 AM, LAURENT  wrote:
> Le 20/09/2011 21:09, Luís Díaz a écrit :
>> Hello all,
>> someone have already install SOPAC2 with Koha??
>> Thanks a lot
>>
>
> Hi
> we successfully installed Sopac2.
> We had to hack the code in order to make it work and the install is
> rather painful.
> But we did.
>
> --
> Henri-Damien LAURENT
> BibLibre
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Checked In Status on Reports

[Nicole Engard]

On Thu, Sep 1, 2011 at 8:57 PM, Chris Cormack  wrote:
> SELECT title,author,barcode FROM biblio,items WHERE
> biblio.biblionumber=items.biblionumber AND items.itype ='you item type
> goes here' AND (items.onloan is NULL or items.onloan = '')
>
> Thats two ' not one " :)

Or you can do this:

SELECT title,author,barcode FROM biblio,items WHERE
biblio.biblionumber=items.biblionumber AND items.itype = <> AND (items.onloan is NULL or items.onloan = '')


So that it asks you for an item type and you don't have to edit again later.

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha - permission to do overdue.pl

[Nicole Engard]

I agree with Linda,

I think that all circ staff should be able to run the circ reports on
the circulation page without reports permissions - otherwise why are
those reports not with the other reports - why are they listed on the
circulation page?

Nicole

On Tue, Aug 30, 2011 at 1:15 PM, Linda Culberson
 wrote:
> Liz,
> I actually do have an opinion because  I do need the overdue report  to be
> available to all circulation staff.  But then we don't have the "Large
> number of overdues" that is  would make it "resource intensive" as it states
> in the warning.  And no, I'd rather the circulation staff not have access to
> all reports.
> I had done a php script that would be available to all, but the librarians
> really prefer the functionality to be within Koha.
>
> Thanks for asking!
> Linda
>
> On 8/30/2011 11:00 AM, Liz Rea wrote:
>>
>> I'm curious, do you feel that this particular report should be available
>> to circulation staff with "regular" circulation permissions, or is it ok
>> that your circ staff has access to all of reports? If so, it might be a good
>> idea to file a bug about that.
>>
>> I'm not sure I have an opinion about that, but maybe you do. :)
>>
>> Liz Rea
>> l...@nekls.org
>>
>>
>>
>>
>>
>>
>> On Aug 30, 2011, at 10:09 AM, Linda Culberson wrote:
>>
>>> Sorry all, I didn't explain myself very well.  I meant that from the page
>>> in the staff client that is  cgi-bin/koha/circ/circulation-home.pl, it is
>>> the link for "Overdues"  that goes to overdue.pl
>>> Without the reports permissions, they get sent back to the login screen
>>> with the message:
>>> "Error: You do not have permission to access this page. Click to log out"
>>>     Anyway, the permissions needed seem to be for reports - I think, though
>>> I'm not sure.
>>>
>>> Linda
>>>
>>> On 8/30/2011 9:38 AM, Nicole Engard wrote:
>>>>
>>>> What do you mean by 'do overdue.pl'?  Overdues are sent automatically
>>>> by Koha using the cron job - your circulation staff shouldn't have to
>>>> touch anything related to that.
>>>>
>>>> Nicole
>>>>
>>>> On Tue, Aug 30, 2011 at 10:20 AM, Linda Culberson
>>>>    wrote:
>>>>>
>>>>> Ian,
>>>>> They have that one, but can't do the overdues. Â It appears to be the
>>>>> reports
>>>>> one maybe?
>>>>> Thanks!
>>>>> Linda
>>>>>
>>>>> On 8/30/2011 9:07 AM, Ian Walls wrote:
>>>>>>
>>>>>> Linda,
>>>>>>
>>>>>>
>>>>>> It's the "Circulation: Remaining Permissions" permission, at this
>>>>>> time.Â
>>>>>>
>>>>>>
>>>>>> -Ian
>>>>>>
>>>>>> On Tue, Aug 30, 2011 at 10:02 AM, Linda Culberson
>>>>>> mailto:lcul...@mdah.state.ms.us>>   wrote:
>>>>>>
>>>>>> Â  Â All,
>>>>>>   Â Where is the permission to do overdue.pl<http://overdue.pl>? Â
>>>>>> We
>>>>>> Â  Â need our circulation staff the ability to do that and I can't
>>>>>> figure
>>>>>> Â  Â where it is.
>>>>>>
>>>>>> Â  Â Thanks!
>>>>>> Â  Â --
>>>>>>   Â Linda Culberson   Â  Â lcul...@mdah.state.ms.us
>>>>>> Â  Â<mailto:lcul...@mdah.state.ms.us>
>>>>>> Â  Â Archives and Records Services Division
>>>>>> Â  Â Ms. Dept. of Archives&   History
>>>>>> Â  Â P. O. Box 571
>>>>>> Â  Â Jackson, MS 39205-0571
>>>>>>   Â Telephone: Â 601/576-6873 Â  Fax: Â 601/576-6824
>>>>>>
>>>>>> Â  Â __ _
>>>>>>   Â Koha mailing list  http://koha-community.org
>>>>>> Â  Â Koha@lists.katipo.co.nz<mailto:Koha@lists.katipo.co.nz>
>>>>>> Â  Â http://lists.katipo.co.nz/ mailman/listinfo/koha
>>>>>> Â  Â<http://lists.katipo.co.nz/mailman/listinfo/koha>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Ian Walls
>>>>>> Lead Development 

Re: [Koha] Koha - permission to do overdue.pl

[Nicole Engard]

What do you mean by 'do overdue.pl'?  Overdues are sent automatically
by Koha using the cron job - your circulation staff shouldn't have to
touch anything related to that.

Nicole

On Tue, Aug 30, 2011 at 10:20 AM, Linda Culberson
 wrote:
> Ian,
> They have that one, but can't do the overdues.  It appears to be the reports
> one maybe?
> Thanks!
> Linda
>
> On 8/30/2011 9:07 AM, Ian Walls wrote:
>>
>> Linda,
>>
>>
>> It's the "Circulation: Remaining Permissions" permission, at this time.Â
>>
>>
>> -Ian
>>
>> On Tue, Aug 30, 2011 at 10:02 AM, Linda Culberson
>> mailto:lcul...@mdah.state.ms.us>> wrote:
>>
>>    All,
>>    Where is the permission to do overdue.pl ? Â We
>>    need our circulation staff the ability to do that and I can't figure
>>    where it is.
>>
>>    Thanks!
>>    --
>>    Linda Culberson   Â  Â lcul...@mdah.state.ms.us
>>    
>>    Archives and Records Services Division
>>    Ms. Dept. of Archives & History
>>    P. O. Box 571
>>    Jackson, MS 39205-0571
>>    Telephone: Â 601/576-6873 Â  Fax: Â 601/576-6824
>>
>>    __ _
>>    Koha mailing list  http://koha-community.org
>>    Koha@lists.katipo.co.nz 
>>    http://lists.katipo.co.nz/ mailman/listinfo/koha
>>    
>>
>>
>>
>>
>> --
>> Ian Walls
>> Lead Development Specialist
>> ByWater Solutions
>> Phone # (888) 900-8944
>> http://bywatersolutions.com
>> ian.wa...@bywatersolutions.com 
>> Twitter: @sekjal
>
> --
> Linda Culberson      lcul...@mdah.state.ms.us
> Archives and Records Services Division
> Ms. Dept. of Archives & History
> P. O. Box 571
> Jackson, MS 39205-0571
> Telephone:  601/576-6873   Fax:  601/576-6824
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report Help

[Nicole Engard]

Thanks a bunch! This appears to work.  I'll post this to the wiki in
your name so that you get credit for the work and so that others can
benefit from this.

Nicole

2011/8/17 Msgr. Marion J. Makarewicz :
> SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber,
>
> i.barcode, i.datelastborrowed, i.issues as totalcheckouts,
>
> i.dateaccessioned
>
> FROM items i
>
> LEFT JOIN issues
>
> USING (itemnumber)
>
> LEFT JOIN biblio b
>
> USING (biblionumber)
>
> WHERE i.itemnumber NOT IN (SELECT issues.itemnumber FROM issues) AND
> YEAR(NOW())-YEAR(i.datelastborrowed) > 5
>
> UNION SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber,
>
> i.barcode, i.datelastborrowed, i.issues as totalcheckouts,
>
> i.dateaccessioned
>
> FROM items i
>
> LEFT JOIN issues
>
> USING (itemnumber)
>
> LEFT JOIN biblio b
>
> USING (biblionumber)
>
> WHERE i.itemnumber NOT IN (SELECT old_issues.itemnumber FROM old_issues) AND
> YEAR(NOW())-YEAR(i.datelastborrowed) > 5;
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha - cataloging statistics

[Nicole Engard]

I'd also like to hear from you (Linda) and the community about why
it's not recommended? Linda have you noticed slowness?  I asked this a
while ago on list but didn't get an answer from anyone about why it
had that note attached to it.

Nicole

On Tue, Aug 23, 2011 at 1:23 PM, Linda Culberson
 wrote:
> All,
> We are required to keep detailed cataloging statistics for performance
> standards reporting.  So I have cataloging logging turned on, even though it
> is not recommended. I've written php scripts that query by a range of dates
> to return the number of biblios added, biblios modified, and items added by
> each cataloger.  My problem is with item modification, since Koha seems to
> mark an item as modified in the action_logs in the cataloguing module when
> it is simply checked in and out.  I have modified my queries to filter those
> out (I think), but was wondering if anyone else has a similar requirement
> and has already come up with a better solution.
>
> Thanks!
> --
> Linda Culberson      lcul...@mdah.state.ms.us
> Archives and Records Services Division
> Ms. Dept. of Archives & History
> P. O. Box 571
> Jackson, MS 39205-0571
> Telephone:  601/576-6873   Fax:  601/576-6824
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] importing Library of Congress authority records

[Nicole Engard]

I haven't done it personally, but I can tell you that it can only be
done via the command line at this time.  There is a feature request to
bring this function to the staff client, but it hasn't been done as of
yet: http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=2060

Nicole

On Mon, Aug 22, 2011 at 11:37 AM, Linda Culberson
 wrote:
> All,
> Has anyone tried importing Library of Congress authorities into Koha?  We
> are considering purchasing the retrospective subject authorities, so while
> it would be a great many records (353,000 records), it wouldn't be the full
> database.
>
> --
> Linda Culberson      lcul...@mdah.state.ms.us
> Archives and Records Services Division
> Ms. Dept. of Archives & History
> P. O. Box 571
> Jackson, MS 39205-0571
> Telephone:  601/576-6873   Fax:  601/576-6824
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] report help

[Nicole Engard]

Can someone help me out here. I need to alter this to show only titles
that haven't circulated in X number of years.


SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber,
i.barcode, i.datelastborrowed, i.issues as totalcheckouts,
i.dateaccessioned
FROM items i
LEFT JOIN issues
USING (itemnumber)
LEFT JOIN biblio b
USING (biblionumber)
WHERE i.itemnumber NOT IN (SELECT issues.itemnumber FROM issues)
UNION
(SELECT b.title, b.author, b.copyrightdate, i.itemcallnumber,
i.barcode, i.datelastborrowed, i.issues as totalcheckouts,
i.dateaccessioned
FROM items i
LEFT JOIN issues
USING (itemnumber)
LEFT JOIN biblio b
USING (biblionumber)
WHERE i.itemnumber NOT IN (SELECT old_issues.itemnumber FROM old_issues))
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Acquisitions Fields

[Nicole Engard]

On Wed, Aug 17, 2011 at 11:23 AM, Colin Campbell
 wrote:
> Confused, you will be.
>
> C.

Yes very! Because some prices don't seem to be stored at all ... all
very confusing.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] Kohacon11 : Last date of paper submission extended till August 30 2011

[Nicole Engard]

I won't be able to make it this year, so I won't be submitting
anything, but for future conferences, I don't finish my presentations
until the night before, so I won't be able to submit full papers or
finished presentations ahead of time. We work with technology and it's
changing hourly, so a presentation written this month is not always
valid in October ... just my 2 cents.

Nicole

2011/8/16 Paul Nielsen :
> Hi Koustubha,
>
>
>
> Just following up on my suggestion on IRC the other week about accessing the
> video of the two Koha presentations at LIANZA conference in NZ during
> Kohacon11.
>
> Cath Sheard, Chris C and I are holding a demo session and Shelley Gurney is
> doing a breaking down the barriers to Koha type of session. Both sessions
> are on the Tuesday and all conference papers and presentations will be
> uploaded to the LIANZA Online Library at the end of each day
> http://lianza.org.nz/publications/ . That should make them available for
> either Monday or Tuesday viewing at Kohacon. I thought this might be a good
> chance for the community to see how we are promoting Koha downunder and also
> to see feedback from our audiences.
>
>
>
> So, not a paper submission either I’m afraid, more an offer for something a
> bit different to fill a slot for you.
>
>
>
> Thanks
>
>
>
> Paul Nielsen  |  Library Manager
> ddi: (07) 862 5064  |  email: pa...@hauraki-dc.govt.nz
>
> Hauraki District Council  |  William Street Paeroa 3600  |  PO Box 17 Paeroa
> 3640  |  NZ
> ph: (07) 862 8609 or 0800 734 834 (from within district)  |  fax: (07) 862
> 8607
> web: www.hauraki-dc.govt.nz  |  email: i...@hauraki-dc.govt.nz  |  HDC
> Libraries
> P Please consider the environment before printing this email
>
>
>
> 
>
> From: koha-devel-boun...@lists.koha-community.org
> [mailto:koha-devel-boun...@lists.koha-community.org] On Behalf Of Koustubha
> Kale
> Sent: Tuesday, 16 August 2011 6:12 a.m.
> To: Koha list; koha-de...@lists.koha-community.org
> Subject: [Koha-devel] Kohacon11 : Last date of paper submission extended
> till August 30 2011
>
>
>
> Hi All,
> We have extended the last date of paper submission ( which was today 15th
> August ) till 30th August 2011.
>
> Request all of you who would like to present at Kohacon111 to step forward
> and submit an abstract at
> http://kohacon11.vpmthane.org/ocs/index.php/k/k11/schedConf/cfp  for review.
>
> Also request all of you whose abstracts have been accepted to hurry up and
> submit the full papers / presentations..
>
> Regards,
> Koustubha Kale
> Anant Corporation
>
> Contact Details :
> Address  : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka,
> Thane (w),
>                 Maharashtra, India, Pin : 400601.
> TeleFax  : +91-22-21720108, +91-22-21720109
> Mobile     : +919820715876
> Website  : http://www.anantcorp.com
> Blog : http://www.anantcorp.com/blog/?author=2
>
>
>
> 
> DISCLAIMER:
> This e-mail message and accompanying data may contain information that is
> confidential and subject to privilege.
> If you are not the intended recipient, you are notified that any use,
> dissemination, distribution or copying of this message or data is
> prohibited.
> If you have received this e-mail in error please notify the sender or
> Hauraki District Council at mailmars...@hauraki-dc.govt.nz immediately and
> delete all material pertaining to this e-mail.
> 
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Acquisitions Fields

[Nicole Engard]

Can someone tell me what the  unitprice, rrp, and ecost  fields in the
aqorders table are? Which field is for which price field?

Thanks
Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] git bz setup question

[Nicole Engard]

I have followed the instructions on the wiki, but every time I restart
my virtual machine I need to repeat the path line before git bz will
work. Is there a way to have tat path figured out automatically?

nengard@debian:~/kohaclone$ git bz attach -e 6716 HEAD
git: 'bz' is not a git command. See 'git --help'.

Did you mean one of these?
am
gc
mv
rm
nengard@debian:~/kohaclone$ PATH=$PATH:/usr/sbin:/usr/bin:/usr/local/bin
nengard@debian:~/kohaclone$ git bz attach -e 6716 HEAD

Thanks in advance
Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Label Creator Question

[Nicole Engard]

I have been looking for a way to limit the space the title prints to
one line on my barcode labels.  Is this possible? I have a library
that said they did this, but don't remember how ...

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Duplicates not being caught

[Nicole Engard]

Okay I have tested on my system and have found what I think is a bug:
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6713

Nicole

On Thu, Aug 11, 2011 at 11:55 AM, Nicole Engard  wrote:
> I got this via personal email and when David tried to send to list he
> got a message saying he's not on the list - but he has sent emails
> before so we're confused. Anyway, if you have ideas please reply to
> all:
>
> 
>
>   I am stuck again … I imported my copy 1s successfully a few weeks ago
>
> I am importing 545 duplicate records ALL  of which are copy 2s.
> Every single one.
>
> I am using the 020$a field to match by ISBN but Koha is not matching
> any of them and considers them to be 545 unique records…
>
> =LDR  0nam a220Ia 45e0
> =008  00049764
> =020  \\$a671506196
> =082  \\$a158.1 C28
> =100  \\$aCarnegie, Dale
> =245  \\$aHow to stop worrying and start living
> =245  \\$cDale Carnegie
> =260  \\$aNY
> =260  \\$c1984
> =490  \\$v1
> =650  \\$a1. WORRY
> =650  \\$a2. SUCCESS
> =952  \\$bFL$o158.1 C28$p00049764$yBK
>
> =LDR  0nam a220Ia 45e0
> =008  1501
> =020  \\$a1
> =082  \\$a005.101 S995
> =245  \\$aSystem management methodology, custom software baseline
> =250  \\$aversion 2
> =260  \\$c1989
> =490  \\$v1
> =650  \\$a1. METHODS (COMPUTER SYSTEM)
> =650  \\$a2. SYSTEMS PROGRAMMING (COMPUTER SCIENCE)
> =952  \\$bFL$o005.101 S995$p1501$yBK
>
> =LDR  0nam a220Ia 45e0
> =008  00046896
> =020  \\$a139376992
> =082  \\$a005.43 UNIX K39
> =100  \\$aKernighan, Brian W.
> =245  \\$aThe UNIX programming environment
> =245  \\$cBrian W. Kernighan
> =260  \\$aEnglewood Cliffs, NJ
> =260  \\$c1984
> =490  \\$v1
> =650  \\$a1. UNIX (COMPUTER OPERATING SYSTEM)
> =952  \\$bFL$o005.43 UNIX K39$p00046896$yBK
>
>
> any suggestions?
> I hope you can help me.
> David W. Hartman Global Business Technology Strategy Library 407 828
> 4250 (8-222) FAX 407 828 4868
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Duplicates not being caught

[Nicole Engard]

I got this via personal email and when David tried to send to list he
got a message saying he's not on the list - but he has sent emails
before so we're confused. Anyway, if you have ideas please reply to
all:



  I am stuck again … I imported my copy 1s successfully a few weeks ago

I am importing 545 duplicate records ALL  of which are copy 2s.
Every single one.

I am using the 020$a field to match by ISBN but Koha is not matching
any of them and considers them to be 545 unique records…

=LDR  0nam a220Ia 45e0
=008  00049764
=020  \\$a671506196
=082  \\$a158.1 C28
=100  \\$aCarnegie, Dale
=245  \\$aHow to stop worrying and start living
=245  \\$cDale Carnegie
=260  \\$aNY
=260  \\$c1984
=490  \\$v1
=650  \\$a1. WORRY
=650  \\$a2. SUCCESS
=952  \\$bFL$o158.1 C28$p00049764$yBK

=LDR  0nam a220Ia 45e0
=008  1501
=020  \\$a1
=082  \\$a005.101 S995
=245  \\$aSystem management methodology, custom software baseline
=250  \\$aversion 2
=260  \\$c1989
=490  \\$v1
=650  \\$a1. METHODS (COMPUTER SYSTEM)
=650  \\$a2. SYSTEMS PROGRAMMING (COMPUTER SCIENCE)
=952  \\$bFL$o005.101 S995$p1501$yBK

=LDR  0nam a220Ia 45e0
=008  00046896
=020  \\$a139376992
=082  \\$a005.43 UNIX K39
=100  \\$aKernighan, Brian W.
=245  \\$aThe UNIX programming environment
=245  \\$cBrian W. Kernighan
=260  \\$aEnglewood Cliffs, NJ
=260  \\$c1984
=490  \\$v1
=650  \\$a1. UNIX (COMPUTER OPERATING SYSTEM)
=952  \\$bFL$o005.43 UNIX K39$p00046896$yBK


any suggestions?
I hope you can help me.
David W. Hartman 
Global Business Technology Strategy Library 
407 828
4250 (8-222) 
FAX 407 828 4868
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] OpacHiddenItems being ignored?

[Nicole Engard]

Richard,

This is a known bug and have been reported here:
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6488

Nicole

On Tue, Aug 9, 2011 at 10:07 PM, Richard Hills - TechnologyWise
 wrote:
> Hi,
>
> I am hoping someone can help me with this setting as so far no matter what I
> set here I am unable to exclude results from the front end search system.
>
> I have set the value of OpacHiddenItems as follows:
> restricted: [1]
>
> However restricted items are still coming through in results.
>
> I have also tried the value "restricted: [1,2,3]" incase it was an issue
> with a single item being passed through.
>
> My Koha version is: 3.4.02
>
> Thank you.
>
> --
> Richard Hills
> TechnologyWise Ltd, Tauranga, NZ
> rich...@tw.co.nz
> www.technologywise.co.nz
> ph: +64 (0)7 571 1060
> fax: +64 (0)7 571 1061
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Patron Image display on Koha OPAC interface

[Nicole Engard]

This is not a patch, but a request for someone to write some code to
do what you want.

Always remember to reply to all so the the entire community gets the
reply and can help you out.

Nicole

On Mon, Aug 8, 2011 at 8:32 AM, R Sunil Kumar
 wrote:
> Dear Nicole,
>
> Can you please guide me how to use this patch and where to install the same.
>
>
> Thanks and Regards
>
> R Sunil Kumar
> Library Technologist
> +91-9686576695
>
> -Original Message-
> From: Nicole Engard [mailto:neng...@gmail.com]
> Sent: 08 August 2011 17:29
> To: sunil.ku...@ecoleglobal.com
> Cc: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Patron Image display on Koha OPAC interface
>
> There is an enhancement request for this very feature:
> http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3516
>
> Nicole
>
> 2011/8/8 R Sunil Kumar :
>> Hi,
>>
>>
>>
>> Anybody tried to display of patron image on OPAC interface of Koha.
>>
>>
>>
>> If so please share the details.
>>
>>
>>
>> Thanks and Regards
>>
>>
>>
>> R Sunil Kumar
>>
>> Library Technologist
>>
>>
>>
>> Ecole Solutions Pvt Ltd
>>
>> Level 15  Concorde Towers  UB City  1 Vittal Mallya Road
>>
>> Bangalore 560001,India
>>
>> Mobile: +91 9686576695  Fax: +91 80 40300400
>>
>> eMail: sunil.ku...@ecoleglobal.com  Web: www.ecoleglobal.com
>>
>>
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>>
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Patron Image display on Koha OPAC interface

[Nicole Engard]

There is an enhancement request for this very feature:
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3516

Nicole

2011/8/8 R Sunil Kumar :
> Hi,
>
>
>
> Anybody tried to display of patron image on OPAC interface of Koha.
>
>
>
> If so please share the details.
>
>
>
> Thanks and Regards
>
>
>
> R Sunil Kumar
>
> Library Technologist
>
>
>
> Ecole Solutions Pvt Ltd
>
> Level 15  Concorde Towers  UB City  1 Vittal Mallya Road
>
> Bangalore 560001,India
>
> Mobile: +91 9686576695  Fax: +91 80 40300400
>
> eMail: sunil.ku...@ecoleglobal.com  Web: www.ecoleglobal.com
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Manual Help - Library Groups

[Nicole Engard]

Hello all,

One of our manual translators emailed me to ask me for some help today
and I unfortunately can't help.

> I am trying to translate in french the manual Koha. And I would like more
> information on the role of the category 'propierties' under the code group
> of sites.
> What is it? A there a link with the traffic rules or system preferences?..

My answer was basically that when I asked on list ages ago that was
the answer I got, I'd love more information for both the English and
the French (and all other languages as they come) manuals.  Any and
all info is helpful!

Thanks
Nicole C. Engard
Documentation Manager
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Self Checkout multiple locations

[Nicole Engard]

If you have the auto signing in off then you will have to log in the
first time you load up the self check window on the machine - and may
have to log in again throughout the day sometimes depending on the
machine.

Nicole

On Sun, Aug 7, 2011 at 2:42 PM, WTC  wrote:
> Hi Nicole
>
> Thank you for the suggestion.
>
>
> Nicole Engard-2 wrote:
>>
>> Why not set up a log in for each branch for self check out and use
>> that one to log in to the self checkout machines at the different
>> locations?
>
> I had set the staff account in the Circulation preferences
> AutoSelfCheckAllowed/AutoSelfCheckID/AutoSelfCheckPass. Should I change this
> setting to Don't allow? How do I get the Self Checkout to be signed in? Is
> it just a case of signing in to the OPAC on that PC with the location's
> staff account?
>
> --
> View this message in context: 
> http://koha.1045719.n5.nabble.com/Self-Checkout-multiple-locations-tp4675388p4675524.html
> Sent from the Koha - Discuss mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Self Checkout multiple locations

[Nicole Engard]

Why not set up a log in for each branch for self check out and use
that one to log in to the self checkout machines at the different
locations?

Nicole

On Sun, Aug 7, 2011 at 1:51 PM, WTC  wrote:
> Hello
> We wanted to use the Self Checkout for our students. We have nine locations
> and the staff account for the Self Checkout is registered to one of the
> locations. This means that when a student at a different location uses the
> Self Checkout it is as if they borrowed the book from a different library.
> This causes a problem when returning the item as it thinks it needs to be
> returned at the home library - which isn't the home of the staff account.
> Is there any way around this? Is there a setting for circulation that I have
> set incorrectly or a circulation rule I need to amend?
> Do any of you use the Self Checkout and Check in with multiple locations?
> Any help much appreciated.
>
> --
> View this message in context: 
> http://koha.1045719.n5.nabble.com/Self-Checkout-multiple-locations-tp4675388p4675388.html
> Sent from the Koha - Discuss mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Brainstorm Help - Improve Reporting

[Nicole Engard]

Woo Hoo!!  I am the one who put that in the manual and didn't remember
that :) I still think we need a way from the build from sql page to
view values easily ... still thinking of how to make it look good.

Nicole

On Sun, Aug 7, 2011 at 8:56 AM, Eric Bégin  wrote:
> Nicole,
>
> You can put your authorized value category code as your runtime parameters
> in order to get their list of values when executing your report.
>
> A simple example : SELECT * FROM borrowers WHERE sort1 = < sort 1 value|Bsort1>>
>
> In green, the message you want to display to the user at runtime.
> In blue, the authorized value category code.
>
> Other than the category codes, you can have le list of branches (branches),
> the patron category (categorycode), type of documents (itemtype).
>
> http://manual.koha-community.org/3.4/en/reportsfaq.html
>
> Regards,
>
> --
> Eric Bégin
> inLibro
>
> On 2011-08-06 10:32, Nicole Engard wrote:
>
> Hello all,
>
> I'm the 'report guru' at work and while I love writing reports I'm
> trying to think of ways to save me some work.  One thing that I often
> do is open up two tabs in my browser so that I have the authorized
> values open in one and the report in another. I'm looking for some
> brainstorming help on a way to make the pertinent values accessible
> right from the reporting module (shelving locations, patron
> categories, item types, collection codes, etc etc).   I'm sure there
> is some fancy way for us to embed links to important values or lists
> of the important values on the create from SQL page ... or maybe just
> one page with the values you'll need to query often.
>
> Another option is to update the runtime parameters function to allow
> for more pull down menus (right now it only has a pull down for
> branches - that I know of).
>
> Sorry for my jumbled thoughts, but that's what brainstorming is about :)
>
> Nicole
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Brainstorm Help - Improve Reporting

[Nicole Engard]

Hello all,

I'm the 'report guru' at work and while I love writing reports I'm
trying to think of ways to save me some work.  One thing that I often
do is open up two tabs in my browser so that I have the authorized
values open in one and the report in another. I'm looking for some
brainstorming help on a way to make the pertinent values accessible
right from the reporting module (shelving locations, patron
categories, item types, collection codes, etc etc).   I'm sure there
is some fancy way for us to embed links to important values or lists
of the important values on the create from SQL page ... or maybe just
one page with the values you'll need to query often.

Another option is to update the runtime parameters function to allow
for more pull down menus (right now it only has a pull down for
branches - that I know of).

Sorry for my jumbled thoughts, but that's what brainstorming is about :)

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Adding patron photos

[Nicole Engard]

David,

That feature is for you to add patron images, right now the patrons
cannot add their own images.

http://manual.koha-community.org/3.4/en/administration.html#patronimages
 - when it says on the staff client that means you can do it.

See the 4th bullet here:
http://manual.koha-community.org/3.4/en/editpatrons.html

Nicole

2011/8/4 Hartman, David W. - GBTS Library :
> I have enabled patrons to add their own photos but I do not see WHERE the
> patron can add in their photos on the OPAC.  Can you help?  That sounds like
> a great feature!
>
>
>
> David W. Hartman
> Global Business Technology Strategy Library
> Team Disney 336N
> 407 828 4250 (8-222)
> FAX 407 828 4868
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Does anyone know how to delete patrons in bulk?

[Nicole Engard]

David,

The only way to do a bulk delete is to go into the MySQL database and
run the delete command.  I think Chris gave you that command in
another email.  But if you want all the patrons deleted you can use
this:

delete * from borrowers;

Nicole

2011/8/4 Hartman, David W. - GBTS Library :
> Koha 3.05 is the version.
>
>
>
> I entered my patron list yesterday 8/3 and there was an error with the
> patron number (leading zeros were ignored by EXCEL).
>
>
>
> I have tried to delete using the admin command by date of last items (today
> 8/4) but it won’t let me delete any patron records.
>
>
>
> I need to delete and reload with correct numbers.
>
>
>
> David W. Hartman
> Global Business Technology Strategy Library
> Team Disney 336N
> 407 828 4250 (8-222)
> FAX 407 828 4868
>
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] (no subject)

[Nicole Engard]

It sure can.  Give this a whirl:
http://wiki.koha-community.org/wiki/SQL_Reports_Library#Count_of_Circ_by_Alpha_Call_Number_Prefix

Nicole

2011/8/3 Rista Bigha- Kavora :
> Community,
>
> Is koha able to give me the report of how many titles are there in a
> particular dewey class?
>
> Regards
>
> --
> Rista Bigha-Kavora
> Librarian 1/cataloguing & classification section
> SICHE Library.
>
> "I may not be an explorer, or an adventurer, or a treasure-seeker, or a
> gun-fighter, or Mr. O'Connell, but Iam proud of what Iam.. I am a
> librarian!" Evelyn, in The Mummy.
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Database upgrade funniness

[Nicole Engard]

Nevermind - it was a patch that I was testing (not the fetch) and that
patch has an updatedatabase with a real number in it - that should not
happen!

Nicole

On Wed, Aug 3, 2011 at 9:07 AM, Nicole Engard  wrote:
> I just did a fetch on my install of master and got the upgrade db
> page.  But this time the page said something funny:
>
> "We are upgrading from Koha 3.05.00.004 to 3.05.00.004, you must
> update your database"
>
> There is no difference in those versions and nothing was actually
> changed (at least not according to the screen).  Is there a typo that
> was pushed? Or did I have a problem in my system?
>
> Nicole
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Database upgrade funniness

[Nicole Engard]

I just did a fetch on my install of master and got the upgrade db
page.  But this time the page said something funny:

"We are upgrading from Koha 3.05.00.004 to 3.05.00.004, you must
update your database"

There is no difference in those versions and nothing was actually
changed (at least not according to the screen).  Is there a typo that
was pushed? Or did I have a problem in my system?

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Creating Library Patron in Koha 3.4

[Nicole Engard]

At this time there is not, I'll see if we can come up with a place to
put them, but I am out of town and won't be able to get to it this
week.

Nicole

On Mon, Aug 1, 2011 at 10:29 PM, R Sunil Kumar
 wrote:
> Dear Nicole,
>
> Thanks for your quick reply.
>
> I tried to see/open the video file but could not able to, there is some 
> dependencies to be downloaded to see the video file.
>
> Is there any other location where I can see/download the video.
>
> Thanks and Regards
>
> R Sunil Kumar
> Library Technologist
> +91-9686576695
>
>
> -Original Message-
> From: Nicole Engard [mailto:neng...@gmail.com]
> Sent: 02 August 2011 10:22
> To: sunil.ku...@ecoleglobal.com
> Cc: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Creating Library Patron in Koha 3.4
>
> These might help you out:
>
> http://manual.koha-community.org/3.4/en/patrons.html#addnewpatron
> http://bywatersolutions.com/2011/04/27/importing-patrons-into-koha-3-4/
> http://bywatersolutions.com/2010/11/10/adding-an-adult-patron-in-koha-3-2/
> http://bywatersolutions.com/2010/11/17/adding-a-child-patron-in-koha-3-2/
> http://bywatersolutions.com/2010/12/29/adding-a-staff-patron-in-koha-3-2/
> http://blip.tv/bywater-solutions-tv/creating-patron-cards-in-koha-3-4-5390994
>
> Thanks
> Nicole C. Engard
>
> On Mon, Aug 1, 2011 at 9:31 PM, R Sunil Kumar
>  wrote:
>> Dear All,
>>
>> Can anybody share the patron creation process in Koha 3.4
>>
>> Following basic information need to be displayed on the card
>>
>> Library Name
>> Institute Name
>> Communication Address
>> Email
>> Phone
>>
>> Patron Name
>> Category
>> Expire Date
>> Communication Address
>> Email
>> Phone
>>
>>
>>
>> Thanks and Regards
>>
>> R Sunil Kumar
>> Library Technologist
>> +91-9686576695
>>
>>
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Creating Library Patron in Koha 3.4

[Nicole Engard]

These might help you out:

http://manual.koha-community.org/3.4/en/patrons.html#addnewpatron
http://bywatersolutions.com/2011/04/27/importing-patrons-into-koha-3-4/
http://bywatersolutions.com/2010/11/10/adding-an-adult-patron-in-koha-3-2/
http://bywatersolutions.com/2010/11/17/adding-a-child-patron-in-koha-3-2/
http://bywatersolutions.com/2010/12/29/adding-a-staff-patron-in-koha-3-2/
http://blip.tv/bywater-solutions-tv/creating-patron-cards-in-koha-3-4-5390994

Thanks
Nicole C. Engard

On Mon, Aug 1, 2011 at 9:31 PM, R Sunil Kumar
 wrote:
> Dear All,
>
> Can anybody share the patron creation process in Koha 3.4
>
> Following basic information need to be displayed on the card
>
> Library Name
> Institute Name
> Communication Address
> Email
> Phone
>
> Patron Name
> Category
> Expire Date
> Communication Address
> Email
> Phone
>
>
>
> Thanks and Regards
>
> R Sunil Kumar
> Library Technologist
> +91-9686576695
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report Help - Extracting XML

[Nicole Engard]

:) No problem! I actually had to remove them to test on the command line anyway.

You are right! It does work :) thanks - will share on the wiki with a
dual credit :)

Nicole

On Thu, Jul 28, 2011 at 8:21 PM, Grobani, Daniel
 wrote:
> Hmm, it works fine for me. It looks like it might have choked on the first 
> tab--try replacing all the tabs I introduced to spaces.
>
> Thanks for your reminder about the <<>> and sorry I removed them. I remember 
> reading about that now, but because that works differently in our, um, 
> flavor, it didn't stick.
>
> Daniel
>
> -Original Message-
> From: Nicole Engard [mailto:neng...@gmail.com]
> Sent: Thursday, July 28, 2011 5:02 PM
> To: Grobani, Daniel
> Cc: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Report Help - Extracting XML
>
> Okay - this:
>
>
> select count(statistics.datetime) as circs, CONCAT(' href=\"/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'\">',biblio.title,'')
> AS Title, CONCAT(' href=\"http://catalog.mysiteca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'\">http://catalog.mysiteca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'')
> as URL, biblio.author, items.location,
> extractValue(biblioitems.marcxml,"collection/record/datafield[@tag='520'][1]/subfield[@code='a']")
> FROM            statistics
> JOIN            items ON (items.itemnumber=statistics.itemnumber)
> LEFT JOIN       biblio ON (biblio.biblionumber=items.biblionumber)
> LEFT JOIN       biblioitems ON (biblioitems.biblioitemnumber =
> items.biblioitemnumber)
> WHERE           DATE(statistics.datetime) BETWEEN '2011-01-01' AND 
> '2011-07-01'
>                       AND statistics.itemnumber IS NOT NULL
>                       AND location = 'Shelving Location Code'
> GROUP BY        biblio.biblionumber
> ORDER BY        circs DESC
> LIMIT           10
>
> Gets this:
>
> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
> that corresponds to your MySQL server version for the right syntax to use 
> near '       statistics JOIN            items ON (items.itemnumber=statistic' 
> at line 4
>
>
> Also, a tip - those <<>> sections I had in there are runtime parameters for 
> Koha (a neat trick that is documented on the wiki and in the manual - in case 
> you removed them cause you didn't know what they were).
>
>
> On Thu, Jul 28, 2011 at 7:41 PM, Daniel Grobani  
> wrote:
>> Try this (I also did some light cleanup):
>>
>> SELECT          COUNT(statistics.datetime) AS circs,
>>                CONCAT(' \"/cgi- ',biblio.title,' ') AS Title,
>>                CONCAT(' \"http://mycatalogv/cgi-
>> http://catalog.losgatosca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'
>> ') AS URL,
>>                biblio.author,
>>                items.location,
>>
>> extractValue(biblioitems.marcxml,"collection/record/datafield[@tag='52
>> 0'][1]/subfield[@code='a']")
>> FROM            statistics
>> JOIN            items ON (items.itemnumber=statistics.itemnumber)
>> LEFT JOIN       biblio ON (biblio.biblionumber=items.biblionumber)
>> LEFT JOIN       biblioitems ON (biblioitems.biblioitemnumber =
>> items.biblioitemnumber)
>> WHERE           DATE(statistics.datetime) BETWEEN '-mm-dd' AND 
>> '-mm-dd'
>>                        AND statistics.itemnumber IS NOT NULL
>>                        AND location = 'Shelving Location Code'
>> GROUP BY        biblio.biblionumber
>> ORDER BY        circs DESC
>> LIMIT           10
>>
>>
>> -
>> Cheers,
>> Daniel Grobani
>> Library Technology Specialist
>> John A. Graziano Memorial Library
>> Samuel Merritt University
>>
>> --
>> View this message in context:
>> http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604
>> p4644634.html Sent from the Koha - Discuss mailing list archive at
>> Nabble.com.
>> ___
>> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report Help - Extracting XML

[Nicole Engard]

Okay - this:


select count(statistics.datetime) as circs, CONCAT('',biblio.title,'')
AS Title, CONCAT('http://catalog.mysiteca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'\">http://catalog.mysiteca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'')
as URL, biblio.author, items.location,
extractValue(biblioitems.marcxml,"collection/record/datafield[@tag='520'][1]/subfield[@code='a']")
FROMstatistics
JOINitems ON (items.itemnumber=statistics.itemnumber)
LEFT JOIN   biblio ON (biblio.biblionumber=items.biblionumber)
LEFT JOIN   biblioitems ON (biblioitems.biblioitemnumber =
items.biblioitemnumber)
WHERE   DATE(statistics.datetime) BETWEEN '2011-01-01' AND '2011-07-01'
   AND statistics.itemnumber IS NOT NULL
   AND location = 'Shelving Location Code'
GROUP BYbiblio.biblionumber
ORDER BYcircs DESC
LIMIT   10

Gets this:

ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '       statistics
JOIN            items ON (items.itemnumber=statistic' at line 4


Also, a tip - those <<>> sections I had in there are runtime
parameters for Koha (a neat trick that is documented on the wiki and
in the manual - in case you removed them cause you didn't know what
they were).


On Thu, Jul 28, 2011 at 7:41 PM, Daniel Grobani
 wrote:
> Try this (I also did some light cleanup):
>
> SELECT          COUNT(statistics.datetime) AS circs,
>                CONCAT(' \"/cgi- ',biblio.title,' ') AS Title,
>                CONCAT(' \"http://mycatalogv/cgi-
> http://catalog.losgatosca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'
> ') AS URL,
>                biblio.author,
>                items.location,
>
> extractValue(biblioitems.marcxml,"collection/record/datafield[@tag='520'][1]/subfield[@code='a']")
> FROM            statistics
> JOIN            items ON (items.itemnumber=statistics.itemnumber)
> LEFT JOIN       biblio ON (biblio.biblionumber=items.biblionumber)
> LEFT JOIN       biblioitems ON (biblioitems.biblioitemnumber =
> items.biblioitemnumber)
> WHERE           DATE(statistics.datetime) BETWEEN '-mm-dd' AND 
> '-mm-dd'
>                        AND statistics.itemnumber IS NOT NULL
>                        AND location = 'Shelving Location Code'
> GROUP BY        biblio.biblionumber
> ORDER BY        circs DESC
> LIMIT           10
>
>
> -
> Cheers,
> Daniel Grobani
> Library Technology Specialist
> John A. Graziano Memorial Library
> Samuel Merritt University
>
> --
> View this message in context: 
> http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604p4644634.html
> Sent from the Koha - Discuss mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] ILS open sources

[Nicole Engard]

Jonson,

I have an incomplete list bookmarked in Delicious:
http://www.delicious.com/nengard/opensource+ils

Nicole

2011/7/28 Jonson philip :
> hi
> i'm going to create a document about Integrated Library Systems in open
> sources  , any one can helps me by official list of  open sources ILS .
> thank's
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report Help - Extracting XML

[Nicole Engard]

If you don't mind, put your two pieces in to my report in the right
places - my problem is that I'm not sure the Join goes where I would
normally put it.

Nicole

On Thu, Jul 28, 2011 at 12:45 PM, Grobani, Daniel
 wrote:
> How about LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber = 
> items.biblioitemnumber)?
>
> Daniel
>
> -Original Message-
> From: Nicole Engard [mailto:neng...@gmail.com]
> Sent: Thursday, July 28, 2011 4:36 AM
> To: Grobani, Daniel
> Cc: koha@lists.katipo.co.nz
> Subject: Re: [Koha] Report Help - Extracting XML
>
> Daniel,
>
> That part I knew :) it was getting it in to the query (the joining) I was 
> having trouble with :)
>
> Nicole
>
> On Wed, Jul 27, 2011 at 8:00 PM, Daniel Grobani  
> wrote:
>> Nicole,
>>
>> This should give you the 520a:
>>
>> extractValue(biblioitems.marcxml,
>> "collection/record/datafield[@tag='520'][1]/subfield[@code='a']")
>>
>> Of course, you'll have to do a join on biblioitems.
>>
>>
>> -
>> Cheers,
>> Daniel Grobani
>> Library Technology Specialist
>> John A. Graziano Memorial Library
>> Samuel Merritt University
>>
>> --
>> View this message in context:
>> http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604
>> p4640701.html Sent from the Koha - Discuss mailing list archive at
>> Nabble.com.
>> ___
>> Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Problems Column in Inventory

[Nicole Engard]

That's interesting because I did an upload of a file that had a
barcode that was not in Koha and I didn't get that screen at all, what
I got was a message saying that the barcode was not found and a
confirmation that the date was updated on the other items in the file.
 That list only shows if you enter criteria in the form (not if you
upload a text file).

See here: http://screencast.com/t/XgGKtYGm

Nicole

On Thu, Jul 28, 2011 at 6:36 PM, Chris Cormack  wrote:
> On 29 July 2011 10:21, Nicole Engard  wrote:
>> Can anyone tell me what the last column that shows on the shelf
>> listing for the inventory tool is for? It is labeled as 'Problems' but
>> I have never seen anything but 'None' under that - and I've tested on
>> a lot of systems.  What would a problem be? What is being reported by
>> this column?
>
> The template tells me
>
>  [% IF ( loo.notfoundbarcode ) %]
>                     Not found among
> barcodes in barcodes file.
>                 [% ELSIF ( loo.notfoundkoha ) %]
>                     Not found in koha.
>                 [% ELSE %]
>                     None
>                 [% END %]
>
> So, 3 choices, none, or barcode not in Koha, or not in the file you uploaded.
>
> Chris
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Problems Column in Inventory

[Nicole Engard]

Can anyone tell me what the last column that shows on the shelf
listing for the inventory tool is for? It is labeled as 'Problems' but
I have never seen anything but 'None' under that - and I've tested on
a lot of systems.  What would a problem be? What is being reported by
this column?

Nicole
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Report Help - Extracting XML

[Nicole Engard]

Daniel,

That part I knew :) it was getting it in to the query (the joining) I
was having trouble with :)

Nicole

On Wed, Jul 27, 2011 at 8:00 PM, Daniel Grobani
 wrote:
> Nicole,
>
> This should give you the 520a:
>
> extractValue(biblioitems.marcxml,
> "collection/record/datafield[@tag='520'][1]/subfield[@code='a']")
>
> Of course, you'll have to do a join on biblioitems.
>
>
> -
> Cheers,
> Daniel Grobani
> Library Technology Specialist
> John A. Graziano Memorial Library
> Samuel Merritt University
>
> --
> View this message in context: 
> http://koha.1045719.n5.nabble.com/Report-Help-Extracting-XML-tp4640604p4640701.html
> Sent from the Koha - Discuss mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Seeking Koha Newsletter Editor

[Nicole Engard]

I think I'll be out of town for the meeting but Daniel has my vote if
he wants the job :)

Nicole

On Wed, Jul 27, 2011 at 7:49 PM, Daniel Grobani
 wrote:
> Hi,
>
> I volunteer to serve as newsletter editor. I don't know the qualifications
> but can offer these tidbits:
>
> 1. I have experience editing newsletters and currently edit one for a
> community organization.
>
> 2. I've participated in the Koha community for two years, online and at two
> KohaCons.
>
> 3. I keep up on what's happening in the community--I read the main and
> developer lists regularly and subscribe to two dozen Koha-related RSS feeds.
>
> I plan to attend the IRC meeting on August 2 (well, August 1 here).
>
> -
> Cheers,
> Daniel Grobani
> Library Technology Specialist
> John A. Graziano Memorial Library
> Samuel Merritt University
>
> --
> View this message in context: 
> http://koha.1045719.n5.nabble.com/Seeking-Koha-Newsletter-Editor-tp4636279p4640667.html
> Sent from the Koha - Discuss mailing list archive at Nabble.com.
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Report Help - Extracting XML

[Nicole Engard]

Hello all,

I need some report assistance. I want to add the summary (520a) to this report:


select count(statistics.datetime) as circs, CONCAT('',biblio.title,'')
AS Title, CONCAT('http://mycatalogv/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'\">http://catalog.losgatosca.gov/cgi-bin/koha/opac-detail.pl?biblionumber=',biblio.biblionumber,'')
as URL, biblio.author, items.location from statistics join items on
(items.itemnumber=statistics.itemnumber) left join biblio on
(biblio.biblionumber=items.biblionumber) where
DATE(statistics.datetime) Between <> and
<> and statistics.itemnumber is not NULL and
location = <> group by biblio.biblionumber
order by circs DESC Limit 10



Can someone make some suggestions?
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Catalogue statitistics by Catataloguer Name

[Nicole Engard]

Admire,

I'm pretty sure that info is tracked in the action_logs table if you
have the cataloging log turned on:
http://manual.koha-community.org/3.4/en/administration.html#CataloguingLog

Nicole

2011/7/27 amutsikiwa :
> Hi
>
> Hope I find you well.   I have a super librarian who  has four cataloguers
> and is interested in establishing the number of items catalogued by each
> cataloguer on a weekly and monthly basis. Is there anyone who have  come up
> with such a query. Or alternatively, can someone formulate the query for me,
> for I am at a loss.
>
>
>
> Regards,
>
>
>
> Admire Mutsikiwa
>
> University of Zimbabwe
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha