Re: [Koha] Koha 3.4.0 released

2011-04-25 Thread ISM KIS
I did upgrade our demo version 3.2.7 to 3.4.0

Installation was ok but rebuild_zebra gave following error:
 
perl rebuild_zebra.pl -a -r -b
 problem with :23 : Cannot decode string with wide characters at
/usr/lib/perl5/5.12.1/i586-linux-thread-multi/Encode.pm line 174.
 
?xml version=1.0 encoding=UTF-8?
record
xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance;
xsi:schemaLocation=http://www.loc.gov/MARC21/slim
http://www.loc.gov/ standards/marcxml/schema/MARC21slim.xsd
xmlns=http://www.loc.gov/MARC21/slim;

  leader00809cam a2200193ui 4500/leader
  controlfield
tag=00152FC5867B9E011D7B3810050BF2CB47C/controlfield
  controlfield tag=00519971124154250.0/controlfield
  controlfield tag=008760415c19691968nyu   000 1 eng
d/controlfield
  datafield tag=020 ind1=  ind2= 
subfield code=a0449232239/subfield
  /datafield
  datafield tag=035 ind1=  ind2= 
subfield code=alss02627231 /subfield
  /datafield
  datafield tag=100 ind1=1 ind2= 
subfield code=aAsimov, Isaac,/subfield
subfield code=d1920-/subfield
  /datafield
  datafield tag=245 ind1=1 ind2=0
subfield code=aAsimov's mysteries //subfield
subfield code=cIsaac Asimov./subfield
  /datafield
  datafield tag=260 ind1=  ind2= 
subfield code=aGreenwich,/subfield
subfield code=bFawcett Crest Book.,/subfield
subfield code=c1968./subfield
  /datafield
  datafield tag=300 ind1=  ind2= 
subfield code=a255 p. ;/subfield
subfield code=c18 cm./subfield
  /datafield
  datafield tag=490 ind1=0 ind2= 
subfield code=aA Dell book/subfield
  /datafield
  datafield tag=505 ind1=0 ind2= 
subfield code=aThe singing bell.--The talking stone.--What's in
a name?--The dying night.--Pate de foie gras.--The dust of death.--A
loint of paw.--I'm in Marsport without Hilda.--Marooned off
Vesta.--Anniversary.--Obituary.--Star light.--The key.--The billiard
ball./subfield
  /datafield
  datafield tag=900 ind1=  ind2= 
subfield code=aF ASI/subfield
  /datafield
  datafield tag=999 ind1=  ind2= 
subfield code=c23/subfield
subfield code=d23/subfield
  /datafield
  datafield tag=952 ind1=  ind2= 
subfield code=70/subfield
subfield code=pT0005028/subfield
subfield code=40/subfield
subfield code=00/subfield
subfield code=6F_ASI/subfield
subfield code=924/subfield
subfield code=bHS/subfield
subfield code=yBK/subfield
subfield code=10/subfield
subfield code=oF ASI/subfield
subfield code=d2009-07-14/subfield
subfield code=aHS/subfield
  /datafield
/record
Can't call method field on an undefined value at
/opt/kohaclone/C4/Biblio.pm l

Anything I can do about this?

Rudy Wuthrich
Kodaikanal International School
 

The Koha development team is happy to announce the release of Koha
3.4.0.

Koha 3.4.0 is a major feature release that contains major changes to
underlying architecture (adoption of Template::Toolkit for templating)
and performance enhancements (removal of item data from biblio
records). 

These changes, in addition to the inclusion of many new features, mean
a
lot of new strings for translators to translate.

For these reasons we recommend that people who are already running
Koha
in
production delay their upgrade until 3.4.1, due May 22, to give the
translators
time to finish, and for the removing of item data to be streamlined.
If
you do wish to upgrade please make sure you read the UPGRADE section
of
the INSTALL document. 

The development team would like to thank all the people who have made
this release possible. Please take time to read the release notes.

RELEASE NOTES FOR KOHA 3.4.0 - 22 April 2011


Koha is the first free and open source software library automation
package 
(ILS). Development is sponsored by libraries of varying types and
sizes, 
volunteers, and support companies from around the world.  
The website for the Koha project is 

http://koha-community.org/ 


Koha 3.4.0 is released in memoriam of Elizabeth Mae Gallagher-Mitchell
December 20, 2010 - March 10, 2011.
Haere. Mōu tai ata; mōku tai ahiahi 

Koha 3.4.0 can be downloaded from:

http://download.koha-community.org/koha-3.04.00.tar.gz 

Installation instructions can be found at:

http://wiki.koha-community.org/wiki/Installation_Documentation 

OR in the INSTALL files that come in the tarball

Koha 3.4.0 is a major feature release.

New features in 3.4.0
==

  ACQUISITIONS:
* Can filter budgets by active status and date on the acquisitions
  homepage
* Freetext field added to specify one-off delivery
* addresses/comments
* Can create multiple orders from a staged MARC file
* New cronjob to delete old suggestions
* Warning when ordering from an external source when a catalogue
  record already exists
* Currency can be set when ordering

  ADMINISTRATION
* Many additional granular permissions are added
* Ability to replace the favicon 

Re: [Koha] Koha 3.4.0 released

2011-04-25 Thread Chris Cormack
On 25 April 2011 21:20, ISM KIS i...@kis.in wrote:
 I did upgrade our demo version 3.2.7 to 3.4.0

 Installation was ok but rebuild_zebra gave following error:

 perl rebuild_zebra.pl -a -r -b
  problem with :23 : Cannot decode string with wide characters at
 /usr/lib/perl5/5.12.1/i586-linux-thread-multi/Encode.pm line 174.

And you followed all the instructions, including the script to remove
item information from the biblio records?

Usually this error means you have a corrupt record, with bad character
encoding. It is very unlikley this was introduced with the upgrade,
this is probably the first time you have done a full reindex in a
while.

Finding the corrupt record and fixing it is probably the only way forward.

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


[Koha] Special 3.4 Issue: Official Koha Newsletter: Volume 2, Issue 4: April 2011

2011-04-25 Thread Nicole Engard
Official Koha Newsletter (ISSN 2153-8328)
Volume 2, Issue 4: April 2011

Special Issue Table of Contents
Introduction
Koha 3.4
Koha 3.4 Released
Koha 3.4 Statistics
Koha 3.4 Documentation
Koha 3.4 Release Notes


Introduction
by Nicole C. Engard

In honor of the timely release of Koha 3.4 and the amazing community
who made it happen this issue of the Koha Newsletter will focus on the
release. The following articles will provide you with all of the
information you’ll need to learn about Koha 3.4. Please read the
entire newsletter on the official Koha site at:
http://koha-community.org/koha-newsletter-volume-2issue-4-april-2011/




Newsletter edited by Nicole C. Engard, Koha Documentation Manager.
Please send future story ideas to me.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Koha 3.4 on Ubuntu

2011-04-25 Thread Tomas Cohen Arazi
Please, create a new mail thread for each topic you want to discuss,
with a proper subject, so people interested in that specific topic
knows in its mailbox what it is about.

regards
To+

On Mon, Apr 25, 2011 at 11:29 AM,  aj...@maxenna.com wrote:
 Hi All,

  Thanks to everyone for the support so far.

  I have successfully installed Koha3.4.0 on Ubuntu.

  I have a query. Is there a starter's guide available(any links or pdf's).
 Like how to start using Koha step by step. Something that might be a
 little simpler than
  http://koha.org/documentation/manual/3.2


  Basically I am using Koha for evaluation purpose[we are trying to
 integrate an RFID midrange reader with Koha software] and would like to
 read about
  # How books are issued using Koha ie. the steps
  # How the hardware communicates with the Koha software
    # more specifically - which perl script handles these functions - if
 somebody could let me know this.


 Thanks  Regards
 Ajesh

 On Sun, Apr 24, 2011 at 4:03 AM, aj...@maxenna.com wrote:

 Initially I added the following lines to ports.conf.

 Listen 80
 Listen 8080
 NameVirtualHost*:80
 NameVirtualHost*:8080

 Spaces are needed between 'NameVirtualHost' and the rest of the lines
 (i.e. *:80)

 NameVirtualHost *:80
 NameVirtualHost *:8080

 To+



 ___
 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 Setting the Renewal Field on Item Types

2011-04-25 Thread Kyle Noakes
Thank you for your ideas.  My apologies for not including the version of Koha I 
am running.  I am currently at 3.02.06.  
 
When I go to the Circulation Rules and Fines area, I am unable to add an 
issuing rule.  I am able to save the setting for Total Current Checkouts 
Allowed (middle option on the page), but am unable to save the area with Fine 
Amount, Fine Days, Fine Grace Period, etc.  After I select the library fill in 
the various fields, and click add, everything on the page resets to Default and 
blank fields without adding a record.  Any more ideas would be greatly 
apprciated.
 
I also have the System Preference for AllowRenewalLimitOverride set to On, 
which does give me the checkbox for overriding renewals on a patrons issues 
tab.  After checking the Override Renewal Limit box and selecting the Renew box 
for the item, I click Renew or Return Checked Items.  The page then refreshes 
and gives a Renewal Error for the item.
 
Although I am skeptical that it would have helped, I would have updated to 3.4 
over the weekend if I had noticed the message go out about it just to see if 
that did anything.  
 
Thank you,
 
Kyle Noakes
Manager of Information Systems
East Grand Rapids Public Schools
 
 Liz Rea l...@nekls.org 4/20/2011 12:49 PM 
I believe a recent change to Koha moved the renewals out of the item type 
definition, and into the circulation rules. The rules for renewals by item type 
are now located in the circulation rules (where they properly belong, imo) and 
can be edited through that interface.

This tripped us up on a recent upgrade as well, so you're not alone. :)

You didn't say which version you were running, so I can't be totally sure about 
this. If this seems wrong, holler back and we'll try to troubleshoot more.

Liz Rea
NEKLS

On Apr 20, 2011, at 8:49 AM, Kyle Noakes wrote:



Hello,
 
I am unable to edit existing item types to allow them to be renewable.  I am 
also unable to add a new item type with the Renewals field set.  Does anyone 
have any ideas of why this particular field would not save, but other fields in 
Item Types Administration would?
 
In the past I have had a similar situation with saving something in 
Administration.  When it happened previously, I was able to locate the table 
and field in Mysql and update it manually.  I am unable to find where the 
Renewals field is in the database as it is not located in the itemtypes 
table.  Any help on the location of the Renewals field would be greatly 
appreciated.
 
Thank you,
 
 
 
Kyle Noakes
Manager of Information Systems
East Grand Rapids Public Schools
___
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 - copying frameworks continued

2011-04-25 Thread Linda Culberson
Never mind, I just found Nicole's video!

On 4/25/2011 10:59 AM, Linda Culberson wrote:
 All,
 We have two instances of Koha. I finally found all of my errors my
 frameworks in one instance (it is in 3.2) and now want to copy those
 corrected frameworks over to my second instance which we just upgraded
 to 3.4. How is the easiest way to do that? Dumping the whole database
 seems overkill, but I'm not sure what tables are involved besides
 biblio_framework and marc_subfield_structure.

 Is there a relatively simple way of doing this?

 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
Facsimile:  601/576-6824

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


Re: [Koha] Koha - copying frameworks ongong

2011-04-25 Thread Linda Culberson
Sorry, that doesn't help because it is a different version. It would 
work from 3.4 to 3.4 but not from 3.2 to 3.4.  So I still need help on 
how to get from 3.2. to 3.4.

Thanks.

On 4/25/2011 11:04 AM, Linda Culberson wrote:
 Never mind, I just found Nicole's video!

 On 4/25/2011 10:59 AM, Linda Culberson wrote:
 All,
 We have two instances of Koha. I finally found all of my errors my
 frameworks in one instance (it is in 3.2) and now want to copy those
 corrected frameworks over to my second instance which we just upgraded
 to 3.4. How is the easiest way to do that? Dumping the whole database
 seems overkill, but I'm not sure what tables are involved besides
 biblio_framework and marc_subfield_structure.

 Is there a relatively simple way of doing this?

 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
Facsimile:  601/576-6824

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


Re: [Koha] Koha - copying frameworks ongong

2011-04-25 Thread Jared Camins-Esakov
Linda,

I'd suggest dumping biblio_framework, marc_subfield_structure, and
marc_tag_structure and then just reloading them in the other system.

Regards,
Jared

On Mon, Apr 25, 2011 at 12:27 PM, Linda Culberson
lcul...@mdah.state.ms.uswrote:

 Sorry, that doesn't help because it is a different version. It would
 work from 3.4 to 3.4 but not from 3.2 to 3.4.  So I still need help on
 how to get from 3.2. to 3.4.

 Thanks.

 On 4/25/2011 11:04 AM, Linda Culberson wrote:
  Never mind, I just found Nicole's video!
 
  On 4/25/2011 10:59 AM, Linda Culberson wrote:
  All,
  We have two instances of Koha. I finally found all of my errors my
  frameworks in one instance (it is in 3.2) and now want to copy those
  corrected frameworks over to my second instance which we just upgraded
  to 3.4. How is the easiest way to do that? Dumping the whole database
  seems overkill, but I'm not sure what tables are involved besides
  biblio_framework and marc_subfield_structure.
 
  Is there a relatively simple way of doing this?
 
  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
 Facsimile:  601/576-6824

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




-- 
Jared Camins-Esakov
Freelance bibliographer, C  P Bibliography Services, LLC
(phone) +1 (917) 727-3445
(e-mail) jcam...@cpbibliography.com
(web) http://www.cpbibliography.com/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Koha - copying frameworks

2011-04-25 Thread Linda Culberson
All,
We have two instances of Koha.  I finally found all of my errors  my 
frameworks in one instance (it is in 3.2) and now want to copy those 
corrected frameworks over to my second instance which we just upgraded 
to 3.4. How is the easiest way to do that?  Dumping the whole database 
seems overkill, but I'm not sure what tables are involved besides 
biblio_framework and marc_subfield_structure.

Is there a relatively simple way of doing this?

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
Facsimile:  601/576-6824

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


Re: [Koha] Koha - copying frameworks ongong

2011-04-25 Thread Tomas Cohen Arazi
On Mon, Apr 25, 2011 at 1:27 PM, Linda Culberson
lcul...@mdah.state.ms.us wrote:
 Sorry, that doesn't help because it is a different version. It would
 work from 3.4 to 3.4 but not from 3.2 to 3.4.  So I still need help on
 how to get from 3.2. to 3.4.


 Thanks.

 On 4/25/2011 11:04 AM, Linda Culberson wrote:
 Never mind, I just found Nicole's video!

 On 4/25/2011 10:59 AM, Linda Culberson wrote:
 All,
 We have two instances of Koha. I finally found all of my errors my
 frameworks in one instance (it is in 3.2) and now want to copy those
 corrected frameworks over to my second instance which we just upgraded
 to 3.4. How is the easiest way to do that? Dumping the whole database
 seems overkill, but I'm not sure what tables are involved besides
 biblio_framework and marc_subfield_structure.

 Is there a relatively simple way of doing this?

 Thanks!

Try creating a shell script named dump_framework.sh with this content
(that between code/code):

code
#!/bin/bash

# Informacion de nuestra instalacion
DBNAME=YOURDB
DBUSER=YOURDBUSER
DBPASS=YOURDBUSERPASS

# Tablesstoring the frameworks
TABLES=marc_tag_structure marc_subfield_structure biblio_framework

# Commands
MYSQLDUMP=/usr/bin/mysqldump
MYSQLDUMPOPTS=--no-create-info

FRAMEWORKNAME=$1

for TABLE in $TABLES
do
$MYSQLDUMP $MYSQLDUMPOPTS -u$DBUSER -p$DBPASS $DBNAME $TABLE
--where=frameworkcode='$FRAMEWORKNAME'  $TABLE-$FRAMEWORKNAME.sql
done

/code

Change its permissions :

# chmod u+x dump_framework.sh

Then you can run it like this:

# ./dump_framework.sh BKS

to dump the framework identified by BKS (code).
You'll end up with three files that can be inserted in your other DB.

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


Re: [Koha] Koha - copying frameworks ongong

2011-04-25 Thread Magnus Enger
Hi!

There is a recepie for getting one specific MARC framework out of the
database here:
http://wiki.koha-community.org/wiki/Mysqldump_Library#A_specific_MARC_framework

Best regards,
Magnus Enger
libriotech.no

On 25 April 2011 18:27, Linda Culberson lcul...@mdah.state.ms.us wrote:
 Sorry, that doesn't help because it is a different version. It would
 work from 3.4 to 3.4 but not from 3.2 to 3.4.  So I still need help on
 how to get from 3.2. to 3.4.

 Thanks.

 On 4/25/2011 11:04 AM, Linda Culberson wrote:
 Never mind, I just found Nicole's video!

 On 4/25/2011 10:59 AM, Linda Culberson wrote:
 All,
 We have two instances of Koha. I finally found all of my errors my
 frameworks in one instance (it is in 3.2) and now want to copy those
 corrected frameworks over to my second instance which we just upgraded
 to 3.4. How is the easiest way to do that? Dumping the whole database
 seems overkill, but I'm not sure what tables are involved besides
 biblio_framework and marc_subfield_structure.

 Is there a relatively simple way of doing this?

 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
 Facsimile:  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] reports function

2011-04-25 Thread Liz Rea

On Apr 25, 2011, at 1:06 PM, Caitlin McGurk wrote:

 When commanding a report to run, Koha asks me to Enter parameters for
 report Cataloged Books:, with a bar below it that says itype: and
 has an empty scroll bar with no choices to pick from. When I click
 run, nothing happens. Anyone know what this means or how to fix it?
 
 Also, is there a way to export reports in any format other than a .csv
 or .tab? Neither of these are viewable on my machine.
 
 Thanks!
 Caitlin McGurk
 
 --
 Caitlin McGurk
 Librarian
 The Schulz Library
 The Center for Cartoon Studies
 mcg...@cartoonstudies.org
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

Caitlin,
Can you paste us the sql of the report you are trying to run?

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


Re: [Koha] reports function

2011-04-25 Thread Caitlin McGurk
This is the SQL I'm trying to run and export in something other than
.tab or .csv:
SELECT  
borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.email,
FROM borrowers   WHERE borrowers.branchcode='H25C'

This is the SQL I'd like to run for cataloged books:
SELECT 
sum(items.barcode),sum(biblio.title),sum(biblio.author),sum(biblio.datecreated),
items.barcode,biblio.title,biblio.author,biblio.datecreated FROM items
LEFT JOIN biblioitems on
(items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
items.itype=itype|itemtype GROUP BY
items.barcode,biblio.title,biblio.author,biblio.datecreated ORDER BY
items.barcode asc,biblio.title asc,biblio.author
asc,biblio.datecreated asc

Regards,
CM

On Mon, Apr 25, 2011 at 2:15 PM, Liz Rea l...@nekls.org wrote:

 On Apr 25, 2011, at 1:06 PM, Caitlin McGurk wrote:

 When commanding a report to run, Koha asks me to Enter parameters for
 report Cataloged Books:, with a bar below it that says itype: and
 has an empty scroll bar with no choices to pick from. When I click
 run, nothing happens. Anyone know what this means or how to fix it?

 Also, is there a way to export reports in any format other than a .csv
 or .tab? Neither of these are viewable on my machine.

 Thanks!
 Caitlin McGurk

 --
 Caitlin McGurk
 Librarian
 The Schulz Library
 The Center for Cartoon Studies
 mcg...@cartoonstudies.org
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha

 Caitlin,
 Can you paste us the sql of the report you are trying to run?

 Liz Rea
 NEKLS




-- 
Caitlin McGurk
Librarian
The Schulz Library
The Center for Cartoon Studies
mcg...@cartoonstudies.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Installation/upgrade questions

2011-04-25 Thread Tom Hanstra
Thanks, Galen.

As it turns out, no, not all files did get the substitution.

I tracked down those which did not and updated and things look better.

Thanks!

Tom

On 04/25/2011 02:13 PM, Galen Charlton wrote:
 Hi,

 On Apr 25, 2011, at 1:14 PM, Tom Hanstra wrote:

 What am I missing?  Why is the system version of perl being called in
 some cases?
  
 Did you update the shebang line for all of the CGI scripts to point to your 
 custom Perl interpreter path?


   And what are the C4 errors which I am seeing?
  
 The C4 errors per se are noise - they ultimately all stem from the Perl 
 interpreter failing to compile and load the ZOOM dependency due to whatever 
 is causing the Perl interpreter vs. Perl modules mixup.

 Regards,

 Galen
 --
 Galen Charlton
 VP, Data Services
 Equinox Software, Inc. / Your Library's Guide to Open Source
 email:  g...@esilibrary.com
 direct: +1 352-215-7548
 skype:  gmcharlt
 web:http://www.esilibrary.com/



-- 


-
  Tom Hanstra  Systems Administrator
  Hesburgh Libraries of Notre Dame Phone: (574)631-4686
  213 Hesburgh Library Email: t...@nd.edu
  Notre Dame, IN  46556

Any idiot can face a crisis, it is this day-to-day living that wears
you out.
 Anton Chekhov
-

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


Re: [Koha] reports function

2011-04-25 Thread Liz Rea
For the 1st, a CSV/tab delimited file is viewable in any text editor or 
spreadsheet program. I really like using Libre Office 
(http://www.libreoffice.org) for that as it's pretty smart about dealing with 
CSV and Tab delimited files. You can use MS Excel if you File - Open the file, 
but it's not quite as slick as LO.

As for your 2nd question, I believe you have your parameter set up incorrectly. 
Try this: 

 SELECT 
 sum(items.barcode),sum(biblio.title),sum(biblio.author),sum(biblio.datecreated),
 items.barcode,biblio.title,biblio.author,biblio.datecreated FROM items
 LEFT JOIN biblioitems on
 (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
 on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
 items.itype=Item Type|itemtypes GROUP BY
 items.barcode,biblio.title,biblio.author,biblio.datecreated ORDER BY
 items.barcode asc,biblio.title asc,biblio.author
 asc,biblio.datecreated asc

You were missing an 's' on your itemtypes parameter declaration. :)

Liz Rea
NEKLS

On Apr 25, 2011, at 1:37 PM, Caitlin McGurk wrote:

 This is the SQL I'm trying to run and export in something other than
 .tab or .csv:
 SELECT  
 borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.email,
 FROM borrowers   WHERE borrowers.branchcode='H25C'
 
 This is the SQL I'd like to run for cataloged books:
 SELECT 
 sum(items.barcode),sum(biblio.title),sum(biblio.author),sum(biblio.datecreated),
 items.barcode,biblio.title,biblio.author,biblio.datecreated FROM items
 LEFT JOIN biblioitems on
 (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio
 on (biblioitems.biblionumber=biblio.biblionumber)   WHERE
 items.itype=itype|itemtype GROUP BY
 items.barcode,biblio.title,biblio.author,biblio.datecreated ORDER BY
 items.barcode asc,biblio.title asc,biblio.author
 asc,biblio.datecreated asc
 
 Regards,
 CM
 
 On Mon, Apr 25, 2011 at 2:15 PM, Liz Rea l...@nekls.org wrote:
 
 On Apr 25, 2011, at 1:06 PM, Caitlin McGurk wrote:
 
 When commanding a report to run, Koha asks me to Enter parameters for
 report Cataloged Books:, with a bar below it that says itype: and
 has an empty scroll bar with no choices to pick from. When I click
 run, nothing happens. Anyone know what this means or how to fix it?
 
 Also, is there a way to export reports in any format other than a .csv
 or .tab? Neither of these are viewable on my machine.
 
 Thanks!
 Caitlin McGurk
 
 --
 Caitlin McGurk
 Librarian
 The Schulz Library
 The Center for Cartoon Studies
 mcg...@cartoonstudies.org
 ___
 Koha mailing list  http://koha-community.org
 Koha@lists.katipo.co.nz
 http://lists.katipo.co.nz/mailman/listinfo/koha
 
 Caitlin,
 Can you paste us the sql of the report you are trying to run?
 
 Liz Rea
 NEKLS
 
 
 
 
 -- 
 Caitlin McGurk
 Librarian
 The Schulz Library
 The Center for Cartoon Studies
 mcg...@cartoonstudies.org

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


Re: [Koha] Index build - even without zebra?

2011-04-25 Thread Galen Charlton
Hi,

On Apr 25, 2011, at 3:57 PM, Tom Hanstra wrote:
 OK, I have loaded some data from another database into my local Koha.  I 
 don't have Zebra up and going yet, but I thought I could get a jump start by 
 changing the parameters so that it would not use Zebra.

NoZebra mode is deprecated in 3.4.0 and is not necessarily well-supported 
before then.

 But, there must be some other data rebuild or step I've missed.  I know that 
 there are records out there because there are some pre-created lists which 
 produce results.  But every search I do results in no records found, 
 including a basic wildcard search.
 
 No Result found!
 
 No results match your search for “kw,wrdl: * ”

Maybe run rebuild_nozebra.pl?  But ultimately, the real answer is to go ahead 
and finish getting Zebra up and running.

Regards,

Galen
--
Galen Charlton
VP, Data Services
Equinox Software, Inc. / Your Library's Guide to Open Source
email:  g...@esilibrary.com
direct: +1 352-215-7548
skype:  gmcharlt
web:http://www.esilibrary.com/

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


Re: [Koha] Index build - even without zebra?

2011-04-25 Thread Tom Hanstra
What exactly are the C4 modules?  Both rebuild_nozebra.pl and 
rebuild_zebra.pl call for C4 modules, so it seems that neither will work 
until I resolve these perl modules.

I'll work on my Zebra setup, but it seems like I also have to resolve 
these errors.

Thanks,
Tom

On 04/25/2011 05:25 PM, Galen Charlton wrote:
 Hi,

 On Apr 25, 2011, at 3:57 PM, Tom Hanstra wrote:

 OK, I have loaded some data from another database into my local Koha.  I 
 don't have Zebra up and going yet, but I thought I could get a jump start by 
 changing the parameters so that it would not use Zebra.
  
 NoZebra mode is deprecated in 3.4.0 and is not necessarily well-supported 
 before then.


 But, there must be some other data rebuild or step I've missed.  I know that 
 there are records out there because there are some pre-created lists which 
 produce results.  But every search I do results in no records found, 
 including a basic wildcard search.

 No Result found!

 No results match your search for “kw,wrdl: * ”
  
 Maybe run rebuild_nozebra.pl?  But ultimately, the real answer is to go ahead 
 and finish getting Zebra up and running.

 Regards,

 Galen
 --
 Galen Charlton
 VP, Data Services
 Equinox Software, Inc. / Your Library's Guide to Open Source
 email:  g...@esilibrary.com
 direct: +1 352-215-7548
 skype:  gmcharlt
 web:http://www.esilibrary.com/



-- 


-
  Tom Hanstra  Systems Administrator
  Hesburgh Libraries of Notre Dame Phone: (574)631-4686
  213 Hesburgh Library Email: t...@nd.edu
  Notre Dame, IN  46556

Any idiot can face a crisis, it is this day-to-day living that wears
you out.
 Anton Chekhov
-

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


Re: [Koha] Index build - even without zebra?

2011-04-25 Thread Chris Cormack
On 26 Apr 2011 10:05, Tom Hanstra t...@nd.edu wrote:

 What exactly are the C4 modules?  Both rebuild_nozebra.pl and
 rebuild_zebra.pl call for C4 modules, so it seems that neither will work
 until I resolve these perl modules.

 I'll work on my Zebra setup, but it seems like I also have to resolve
 these errors.

The C4 modules are what everything in Koha uses, so they will be there. If
you are getting an error it will be because you haven't defined the path to
the modules on the command line.

You can do this lots of ways, the INSTALL file lists a few, but its probably
easiest to run
export PERL5LIB=/path/to/where/the/C4/dir
export KOHA_CONF=/path/to/

Check your koha-httpd.conf for the values you need

Chris

 Thanks,
 Tom

 On 04/25/2011 05:25 PM, Galen Charlton wrote:
  Hi,
 
  On Apr 25, 2011, at 3:57 PM, Tom Hanstra wrote:
 
  OK, I have loaded some data from another database into my local Koha.
 I don't have Zebra up and going yet, but I thought I could get a jump start
by changing the parameters so that it would not use Zebra.
 
  NoZebra mode is deprecated in 3.4.0 and is not necessarily
well-supported before then.
 
 
  But, there must be some other data rebuild or step I've missed.  I know
that there are records out there because there are some pre-created lists
which produce results.  But every search I do results in no records found,
including a basic wildcard search.
 
  No Result found!
 
  No results match your search for “kw,wrdl: * ”
 
  Maybe run rebuild_nozebra.pl?  But ultimately, the real answer is to go
ahead and finish getting Zebra up and running.
 
  Regards,
 
  Galen
  --
  Galen Charlton
  VP, Data Services
  Equinox Software, Inc. / Your Library's Guide to Open Source
  email:  g...@esilibrary.com
  direct: +1 352-215-7548
  skype:  gmcharlt
  web:http://www.esilibrary.com/
 
 

 --



-
  Tom Hanstra  Systems Administrator
  Hesburgh Libraries of Notre Dame Phone: (574)631-4686
  213 Hesburgh Library Email: t...@nd.edu
  Notre Dame, IN  46556

Any idiot can face a crisis, it is this day-to-day living that wears
you out.
 Anton Chekhov

-

 ___
 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