[Koha] Koha-16.05.01 installation

[vijay kumar]

Dear all,
I have installed koha-16.05.01 on Ubuntu 16.04 with all required perl
modules having no error by using old stable koha repository
echo deb http://debian.koha-community.org/koha oldstable main | sudo tee
/etc/apt/sources.list.d/koha.list

Earlier getting errors, using koha-repository for stable version mention
below
echo deb http://debian.koha-community.org/koha squeeze main | sudo tee
/etc/apt/sources.list.d/koha.list


With regards,
Vijay Kumar
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Need help to open a staff patron

[Mahmudul Hasan]

Dear All

I am new here. So, I have read the manual and seen nothing to solve
this problem. According to manuual whenever i am going to add a new
patron. It can not.

At the first time when i was logged in following warning message shows
and that is

"You are logged in as the database administrative user. This is not
recommended because some parts of Koha will not function as expected
when using this account.

Please log in instead with a regular staff account. To create a staff
account, create a library, a patron category 'Staff' and add a new
patron. Then give this patron permissions from 'More' in the toolbar."


According to the message i went to the top of the site to set library
from there i chose the canterville. After that i clicked on create
patron>new patron and from drop down menu choose staff. There a
message came that is "can not add patron. please add a patron
category." So i clicked on the patron category. There i add a new
patron category named College Staff. Again i continued but again this
message comes. At last i went to tools>patron list> new patron> create
a new patron list> Give name "Staff">save and following message comes.


Software error:

Can't call method "patron_list_id" on an undefined value at
/usr/share/koha/intranet/cgi-bin/patron_lists/add-modify.pl line 55.

For help, please send mail to the webmaster ([no address given]),
giving this error message and the time and date of the error.


How can i fix it? I have no idea. Please help me. Even i can not open
the list. There also show same type message.

By the way I have installed on the following

Koha version-16.05.00.000
server platform- ubuntu 16.04 LTS amd64
method of installation-marc21

Thanks in advance.

Regards

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

Re: [Koha] OCLC Connexion users on Mac OS

[Eric Phetteplace]

Thanks, MJ. I tried converting an OCLC export to MARCXML using both
marc2xml and a custom pymarc script, both imports choked and failed in
Koha. I'm not sure where the issue lies, if it was just an artifact of one
of the records I chose in testing.

For the list's benefit, we're trying out a workflow that looks like this:

- use the "export to a file" option to download a MARC-8 file locally
- use the Stage MARC Records for Import tool to import from the file
- choose MARC-8 encoding in that tool's options

It worked in my initial tests but we'll see how well staff take to it, and
if the records have encoding problems. It's definitely a lot more work than
simply exporting directly into the ILS.

Best,
Eric Phetteplace
Systems Librarian
California College of the Arts
libraries.cca.edu | vault.cca.edu
510.594.3660
2>/dev/null

On Mon, Jun 27, 2016 at 10:47 AM, MJ Ray  wrote:

> On 24 June 2016 00:00:19 CEST, Eric Phetteplace 
> wrote:
> >learned today that the website's export function, which worked fine
> >with
> >our prior ILS Millennium, only exports records in MARC8 encoding and
> >not
> >UTF-8, so Koha doesn't work with it.
>
> It's been a while since I supported Mac OS X but I'm pretty sure that the
> marc2xml terminal tool should be installable on it. That should convert
> MARC 8 files to MARC XML ones that koha can import.
>
> Hope that helps!
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Round the World Koha Speaking Tour

[Eric Bégin]

Hi Joann,

I feel like you'll have to add a few weeks to your trip :)

Let me know if (and when) you could pass by Montréal, Canada before 
going south in the US, we'll be happy to set something up.


Cheers,

Eric Begin
Solutions inLibro inc.

On 2016-06-27 13:36, Esmael Wan wrote:

Hi Joann,

I'm from malaysia and on behalf Koha Community of Malaysia we are very pleased to 
receive you as a guest to convey information on Koha. We have several sites Koha in 
academic and public libraries around kuala lumpur and georgetown & we can 
prepare meeting/presenting/talking to the koha's libraries.  As our guest we would 
like to provide accommodation, travel costs and daily remuneration during their 
stay. Please let know more details about planning.
Regards
Esmael
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


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

Re: [Koha] OCLC Connexion users on Mac OS

[MJ Ray]

On 24 June 2016 00:00:19 CEST, Eric Phetteplace  wrote:
>learned today that the website's export function, which worked fine
>with
>our prior ILS Millennium, only exports records in MARC8 encoding and
>not
>UTF-8, so Koha doesn't work with it.

It's been a while since I supported Mac OS X but I'm pretty sure that the 
marc2xml terminal tool should be installable on it. That should convert MARC 8 
files to MARC XML ones that koha can import.

Hope that helps!

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Round the World Koha Speaking Tour

[Esmael Wan]

Hi Joann,

I'm from malaysia and on behalf Koha Community of Malaysia we are very pleased 
to receive you as a guest to convey information on Koha. We have several sites 
Koha in academic and public libraries around kuala lumpur and georgetown & we 
can prepare meeting/presenting/talking to the koha's libraries.  As our guest 
we would like to provide accommodation, travel costs and daily remuneration 
during their stay. Please let know more details about planning. 
Regards
Esmael
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Round the World Koha Speaking Tour

[Christopher Davis]

Jo,

When do you plan on traveling in the U.S.A.? There are a number of
Koha libraries (both community Koha, and LibLime Koha) around my
region who probably would be interested in a little conference like
this.

Thank you,

Christopher Davis, MLS
Systems & E-Services Librarian
Uintah County Library
cgda...@uintah.utah.gov
(435) 789-0091 ext.261
uintahlibrary.org
basinlibraries.org
facebook.com/uintahcountylibrary
instagram.com/uintahcountylibrary


On Sun, Jun 26, 2016 at 5:52 AM, Mike D.  wrote:
> Hi Joann,
> Whole Czech Koha community together will be proud participate on Your
> visit. We hope that we can prepare meeting with our developers and
> libraries which use Koha. Please let know more details about plan.
> Especially about date of visit.
>
> Mike Denar
> Www.koha.cz
> Czech Republic
>
> ne 26. 6. 2016 v 11:21 odesílatel Joann Ransom 
> napsal:
>
>> Hi everyone,
>>
>>
>>
>> I have a few months available and am planning a round the world speaking
>> tour starting late  August this year – so really soon!
>>
>>
>>
>> I would love to visit as many countries as I can with strong Koha presences
>> and I am looking for partners to help make this a viable proposition.
>>
>>
>>
>> What I am seeking your help with is libraries, vendors or individuals who
>> would be willing to ‘host’ me ie accommodation, domestic travel, a bit of
>> hospitality. I don’t need posh – happy to homestay J In exchange I would
>> love to speak on Koha origins, Koha community or Te Takere (which is a
>> truly awesome public library / community centre I have developed over the
>> last 4 years) and / or mix and mingle in gatherings. I’m basically happy to
>> sing for my supper in any way that is required J.
>>
>>
>>
>> My draft itinerary is set out below and if anyone is able to help make this
>> happen personally or by passing this email on to someone who can help that
>> would be awesome. I’m so excited at the thought of meeting many of you in
>> this great global Koha family that we have created.
>>
>>
>>
>> Many thanks
>>
>>
>>
>> Jo.
>>
>>
>>
>> Draft itinerary:
>>
>>
>>
>> (I need to travel in one direction around the globe)
>>
>>
>>
>> Philippines, Malaysia, India, Turkey, Greece, France, Germany, Austria,
>> Czech Republic, Sweden, Norway, UK, Ireland, USA, Colombia, Chile,
>> Argentina.
>>
>>
>>
>> *Joann Ransom*
>>
>> *Chief Executive Officer*
>>
>>
>>
>> *DDI* 06 366 0841  |  *Mobile* 027 320 6923
>>
>> jran...@tetakere.org.nz
>>
>>
>>
>> *Ph.* 06 368 1953
>>
>> *www.tetakere.org.nz* 
>>
>>
>> Chief Executive
>> Te Horowhenua Trust.
>> ___
>> Koha mailing list  http://koha-community.org
>> Koha@lists.katipo.co.nz
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] SQL problem- showing results when they are zero.

[Raymund Delahunty]

We have a quite complex budget and funds structure which is making writing 
reports somewhat challenging. For example, we have struggled at modify the 
report below, to have it show lines when both Expenditure AND Commitments are 
zero. When both are zero, the line is simply omitted from the result. We have 
not seen any results where Expenditure is zero, but where Commitments is not (a 
possible scenario, of course), so we are not sure if it is the Expenditures 
being zero that is the underlying problem. For example running the query of the 
CSM College library shows only 36 lines of results rather than the expected 44. 
So 8 have zero in both Exp / Comms. Can someone suggest how we might add in the 
missing 8 lines.

SELECT budget_name AS 'Fund Name', sort1 as 'Subject Fund', 
FORMAT(sum(valSpent),2) AS 'Expenditure', FORMAT(sum(valOnOrder),2) AS 
'Commitments'
FROM
(SELECT b.budget_name, o.sort1, sum(o.unitprice*o.quantity) AS valSpent, 0 AS 
valOnOrder
FROM aqorders o
LEFT JOIN aqbudgets b USING (budget_id)
WHERE o.datereceived IS NOT NULL
AND o.sort1 IN ('CSM Act & Direct','CSM Animation','CSM Architecture','CSM 
CCC','CSM Ceramic Design','CSM Charges','CSM Collab Perf','CSM Enterprise','CSM 
Fashion','CSM Film','CSM Fine Art','CSM Foundation','CSM Graphic Design','CSM 
Innov & Imagin','CSM Jewellery','CSM PDP','CSM Photography','CSM Pro & Indu 
Des','CSM Qref & General','CSM Replacements','CSM Samples','CSM Textiles','CSM 
Journals','CSM e-Act & Direct','CSM e-Animation','CSM e-Architecture','CSM 
e-CCC','CSM e-Ceramic Design','CSM e-Charges','CSM e-Collab Perf','CSM 
e-Enterprise','CSM e-Fashion','CSM e-Film','CSM e-Fine Art','CSM 
e-Foundation','CSM e-Graphic Design','CSM e-Innov & Imagin','CSM 
e-Jewellery','CSM e-PDP','CSM e-Photography','CSM e-Pro & Indu Des','CSM e-Qref 
& General','CSM e-Replacements','CSM e-Samples','CSM e-Textiles','CSM 
e-Journals')
GROUP BY o.sort1
UNION ALL
SELECT b.budget_name, o.sort1, 0 AS valSpent, sum(o.listprice*o.quantity) AS 
valOnOrder
FROM aqorders o
LEFT JOIN aqbudgets b USING (budget_id)
WHERE o.sort1 IN ('CSM Act & Direct','CSM Animation','CSM Architecture','CSM 
CCC','CSM Ceramic Design','CSM Charges','CSM Collab Perf','CSM Enterprise','CSM 
Fashion','CSM Film','CSM Fine Art','CSM Foundation','CSM Graphic Design','CSM 
Innov & Imagin','CSM Jewellery','CSM PDP','CSM Photography','CSM Pro & Indu 
Des','CSM Qref & General','CSM Replacements','CSM Samples','CSM Textiles','CSM 
Journals','CSM e-Act & Direct','CSM e-Animation','CSM e-Architecture','CSM 
e-CCC','CSM e-Ceramic Design','CSM e-Charges','CSM e-Collab Perf','CSM 
e-Enterprise','CSM e-Fashion','CSM e-Film','CSM e-Fine Art','CSM 
e-Foundation','CSM e-Graphic Design','CSM e-Innov & Imagin','CSM 
e-Jewellery','CSM e-PDP','CSM e-Photography','CSM e-Pro & Indu Des','CSM e-Qref 
& General','CSM e-Replacements','CSM e-Samples','CSM e-Textiles','CSM 
e-Journals')
and o.datereceived IS NULL and o.orderstatus<>'cancelled'
GROUP BY o.sort1) AS CSMorders
GROUP BY sort1
ORDER BY budget_name ASC

Many thanks.

Ray Delahunty
r.delahu...@arts.ac.uk
University of the Arts London




.
This email and any attachments are intended solely for the addressee and may 
contain confidential information. If you are not the intended recipient of this 
email and/or its attachments you must not take any action based upon them and 
you must not copy or show them to anyone. Please send the email back to us and 
immediately and permanently delete it and its attachments. Where this email is 
unrelated to the business of University of the Arts London or of any of its 
group companies the opinions expressed in it are the opinions of the sender and 
do not necessarily constitute those of University of the Arts London (or the 
relevant group company). Where the sender's signature indicates that the email 
is sent on behalf of London Artscom Limited the following also applies: London 
Artscom Limited is a company registered in England and Wales under company 
number 02361261. Registered Office: University of the Arts London, 272 High 
Holborn, London WC1V 7EY
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] After upgrade to 16.5.00.000 - OPAC/Staff Client not showing results

[Mark Tompsett]

Greetings,

If you are running Ubuntu, you should be at version 14.04 LTS, not 12.04 
LTS. There are issues with Ubuntu 16.04 LTS, and 14.04 is the recommended 
version of Ubuntu.

GPML,
Mark Tompsett

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