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

Using date functions in report SQL
by Wagner, Jane 25 Feb '09

25 Feb '09

Does anyone have some examples of using date functions like currdate() and month() in report SQL statements? Is this possible in Koha reports? I'm not having any luck -- even a very simple select currdate() report comes back with a generic error message. Thanks. Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner(a)ptfs.com

3 4

MARCEdit Error
by Roche III, Edward 24 Feb '09

24 Feb '09

Has anyone that is using MarcEdit ever received an Error Number: -99 when trying to use the MarcMaker option? It worked the first time I used it but now it isn't working and keeps giving me this error. The export my catalog the same way as the first time. Any ideas? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?"

1 0

Clarify timeout syspref?
by Wagner, Jane 24 Feb '09

24 Feb '09

Can someone clarify the timeout system preference? In the 3.0.x manual site, it says Inactivity timeout for cookies authentication (in seconds). This preference applies to both the staff client and the OPAC. Default Value: 12000000 If I'm doing the math right, the default value translates to an extremely large number of hours. Is seconds right for this value? Or should it be milliseconds? If seconds is correct, can someone give me background on why the default is so large, and why the manual says it shouldn't be changed after installation? I don't want to make changes here until I'm sure of what it's doing. Thanks much! Jane Wagner Library Systems Analyst PTFS Inc. Content Management and Library Solutions 6400 Goldsboro Road, Suite 200 Bethesda, MD 20817 (301) 654-8088 x 151 jwagner(a)ptfs.com

10 13

MARC fields order
by Eric Bégin 24 Feb '09

24 Feb '09

Hi, I do have an Koha installation that has a strange problem. The MARC Fields are not numerically ordered. For example, here are my 500s fields: 504 - BIBLIOGRAPHY, ETC. NOTE + - 508 - CREATION/PRODUCTION CREDITS NOTE + - 521 - TARGET AUDIENCE NOTE + - 522 - GEOGRAPHIC COVERAGE NOTE + - 524 - PREFERRED CITATION OF DESCRIBED MATERIALS NOTE + - 530 - ADDITIONAL PHYSICAL FORM AVAILABLE NOTE + - 533 - REPRODUCTION NOTE + - 538 - SYSTEM DETAILS NOTE + - 541 - IMMEDIATE SOURCE OF ACQUISITION NOTE + - 546 - LANGUAGE NOTE + - 555 - CUMULATIVE INDEX/FINDING AIDS NOTE + - 556 - INFORMATION ABOUT DOCUMENTATION NOTE + - 562 - COPY AND VERSION IDENTIFICATION NOTE + - 563 - BINDING INFORMATION + - 583 - ACTION NOTE + - 585 - EXHIBITIONS NOTE + - 586 - AWARDS NOTE + - 500 - GENERAL NOTE + - 501 - WITH NOTE + - 505 - FORMATTED CONTENTS NOTE + - 511 - PARTICIPANT OR PERFORMER NOTE + - 518 - DATE/TIME AND PLACE OF AN EVENT NOTE + - 520 - SUMMARY, ETC. + - 526 - STUDY PROGRAM INFORMATION NOTE - As you can see, the 500 field has a lot of other fields before it. As far as I can tell, this problem appeared without any change is the database. Anybody know how those fields are sorted? Could this be related to YUI? Any clue about this problem? This installation is using v3.0. Merci, Danke, Thanks, Gracias :) Eric

2 1

Various encoding
by Eric Bégin 23 Feb '09

23 Feb '09

Hi there, My database currently contains 2 type of encoding for the same characters. For example, I have Québec encoded as QueÌbec and another as QuÃ©bec. The problem was probably related to the import of records from 2.2.9 vs the one imported through z39.50. Can anybody suggests a way to fix that inconsistency? Thanks, Eric

1 0

FW: Importing Data
by Roche III, Edward 23 Feb '09

23 Feb '09

I changed the PERL5LIB value to the location of the script but still same error. Also tried running from the folder where the script is located but that gave me the same error as well. Any other ideas???? Edward Roche Technology Support/Network Admin Solanco School District edward_roche(a)solanco.k12.pa.us 717.786.2151 The greatest mistake you can make in life is to continually be afraid you will make one. Elbert Hubbard ________________________________ From: Eric Bégin [mailto:Eric.Begin@inLibro.com] Sent: Thu 2/19/2009 10:25 AM To: Roche III, Edward Subject: Re: [Koha-devel] Importing Data Hi Ed, That is correct. Some people set this script to run every X minutes using crontab to update their catalog on a regular basis. Eric Roche III, Edward wrote: Should be running this script from the command line, right? There isn't a link on Koha. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" 2976_Solanco_Comm_Graphic<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20%5bKoha-de…> MCP(rgb)<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20%5bKoha-de…> From: Eric Bégin [mailto:Eric.Begin@inLibro.com] Sent: Thursday, February 19, 2009 10:06 AM To: Roche III, Edward Cc: koha-devel Subject: Re: [Koha-devel] Importing Data Hi, I forgot to CCed the list in my previous email. (Am I doing to many things at once?) However, your error means that the C4 directory can not be reached by Perl. You have too choices 1. Set the PERL5LIB environment variable to the path containing the C4 dir (check you koha-httpd.conf file) 2. Set your current directory to the path containing the C4 dir and run the script using a relative path. Eric Roche III, Edward wrote: !@#$%@%^^ Here you go: Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at ./rebuild_zebra.pl line 5. BEGIN failed--compilation aborted at ./rebuild_zebra.pl line 5. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" 2976_Solanco_Comm_Graphic<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20%5bKoha-de…> MCP(rgb)<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20%5bKoha-de…> From: Eric Bégin [mailto:Eric.Begin@inLibro.com] Sent: Thursday, February 19, 2009 9:50 AM To: Roche III, Edward Subject: Re: [Koha-devel] Importing Data Edward, You are right when you say you really do to much things at once :) I think you forgot to paste your error. Eric Roche III, Edward wrote: Has anyone come across this error run trying to run the rebuild_zebra.pl script? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" 2976_Solanco_Comm_Graphic<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20%5bKoha-de…> MCP(rgb)<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20%5bKoha-de…> From: Eric Bégin [mailto:Eric.Begin@inLibro.com] Sent: Wednesday, February 18, 2009 4:33 PM To: Roche III, Edward Cc: koha-devel(a)lists.koha.org Subject: Re: [Koha-devel] Importing Data Ed, After importing new record in your database, you need to reindex your database by running misc/migration_tools/rebuild_zebra.pl -b -w Let us know if this solved your problem. Eric Roche III, Edward wrote: Good Afternoon Everyone I was able to export my catalog data from Follett and I imported it into Koha with no errors and it confirmed that it added 16k+ records. The problem is when I do a search it isn't returning and listing. Did I miss something? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" 2976_Solanco_Comm_Graphic<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20%5bKoha-de…> MCP(rgb)<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20%5bKoha-de…> ________________________________ _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel ________________________________ _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel

4 7

Re: [Koha-devel] FW: [Koha] data migration from excel to koha
by Koustubha Kale 22 Feb '09

22 Feb '09

1 0

Version Koha 3.00.01-stable
by Rick Welykochy 21 Feb '09

21 Feb '09

Congrats on the latest stable release of Koha. It gets better all the time. I noticed that the version number on the beta version was 3.00.01.005 That version number is on the stable release. Is that correct? cheers rickw -- ________________________________________________________________ Rick Welykochy || Praxis Services || Internet Driving Instructor I think there is a world market for about five computers. -- Thomas Watson, IBM, 1943 There is no reason for any individual to have a computer in their home. -- Ken Olsen, DEC, 1977

2 3

Koha-3.0.1 Stable release
by LAURENT Henri-Damien 20 Feb '09

20 Feb '09

Hi, we are very happy to announce Koha3.0.1 Stable has been released on http://download.koha.org/ Its name is koha-3.00.01-stable.tar.gz You can download file and signatures You can check the integrity of the package; either by verifying the provided GPG signature (.sig) or by comparing the MD5 checksum: eb3577596c172fcafd7fe0e63ef3972e koha-3.00.01-stable.tar.gz I have also tagged this in Git as "version 3.00.01 stable" v3.00.01-stable_update You can download. An extract of release notes is pasted below Cheers -- Henri-Damien LAURENT Release Maintainer Koha 3.0.1 Beta Release : This release of Koha 3.0.1 includes the following general improvements over the previous release: * General Bugfixing Authorities : Authorities structure edition Authorities edition with diacritics merging authorities Adding failover when null string searched Cataloguing : When editing an item, clearing a field. OPAC : tags Management improved shelves browsing improved improved COInS Support Improved RSS support Boolean search on Advanced Search page (more options) Added Deletion of private list fix General Output : Improving concistency of strings markup corrections Adding some untranslated strings to translation files. More consistency in dates display UNIMARC Adds the creation date of biblios to frameworks in order to improve Rss support You have to launch the script ./maintenance/UNIMARC_sync_date_created_with_marc_biblio.pl 995$2 as lost items management. If you had a previous installation of Koha without 995$2 linked to items.lost then you have to launch the script ./maintenance/sync_items_in_marc_bib.pl and rebuild indexes with rebuild_zebra.pl (see wiki.koha.org or rebuild_zebra.pl -h for documentation) Fines fixes Some sorting problems on patron names and libraries fixed js and update of strings for better coherence CGI::Session::Serialize::yaml is now required and not only CGI::Session Adding better display of links on conformance with MARC standards Fixing POD for correctness Preparing for debian packaging Adding more SIP2 functions Adding some information on reports UTF8 support improved Failover improved Many performance improvements under the hood * Adding a Subject cloud * better UNIMARC version 5 compliance * Improving diacritics management in zebra * Additional translations * Improving Quality Assurance with test suite * Adding a Renew All button to OPAC * options added to overdue_notices script Subsequent releases will be bugfix releases, and won't include new features which would require some databas changes. Koha 3.0.x Release Schedule : we plan to issue bugfix only releases on a 2 month base from now on. So Next releases should be beginning of April, June, August, October, December. Note that Windows is not supported for this version as there are blockers. Note that this version is still supporting only MySQL. Support for PostgreSQL is still very experimental. New features which have deep impact on code will be available in Koha 3.2 and subsequent releases. ============================================================================== TRANSLATIONS ============================================================================== Koha 3.0 (this release) currently has complete translations for the following languages: OPAC: ar-Arab (Arabic), da-DK (Danish), de-DE (German), el-GR (Greek), es-ES (Spanish), en (English), en-NZ (New Zealand English), fr-FR (French), hu-HU (Hungarian), it-IT (Italian), nn-NO - Norwegian Nynorsk, nb-NO Norwegian (Bokmål), nl-NL (Dutch), pt-PT (Portuguese), tr-TR (Turkish), ru-RU (Russian), uk-UA (Ukranian) Staff Client: de-DE (German), el-EL (Greek), fr-FR (French), en (English), es-ES (Spanish), it-IT (Italian), uk-UA (Ukranian), Additionally, Koha 3 (this release) has partial translations for the following languages: OPAC: am-Ethi (Amharic), bg-Cyrl (Bulgarian), fa-Arab (Persian), fi-FI (Finnish) gl (Galician), he-Hebr (Hebrew), hr-HR (Croatian), hu-HU (Hungarian), id-ID (Indonesian), ja-Japn (Japanese), kn-Knda (kannada), ko-Kore (Korean), lo-Laoo (Laoo), mi-NZ (Maori), pl-PL (Polish), pt-PT (Portuguese), sv-SE (Swedish), tet (Tetum), zh-Hans-CN (Simplified Chinese in China), zh-Hans-TW (Simplified Chinese in Taiwan) Staff Client: ar-Arab (Arabic), es-ES (Spanish), hu-HU (Hungarian), hy-Armn (Armenian), ja-Japn (Japanese), nn-NO - Norwegian Nynorsk, nb-NO Norwegian (Bokmål), ru-RU (Russian), tr-TR (Turkish), zh-Hans-CN (Simplified Chinese in China), zh-Hans-TW (Simplified Chinese in Taiwan) The Koha Team welcomes additional translations; please see http://www.kohadocs.org/usersguide/apb.html for information about translating Koha, and join the koha-translate list to volunteer: http://lists.nongnu.org/mailman/listinfo/koha-translate _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel

6 6

Re: [Koha-devel] Importing Data
by Roche III, Edward 20 Feb '09

20 Feb '09

I changed the PERLLIB value to the location of the script but still same error. Also tried running from the folder where the script is located but that gave me the same error as well. Any other ideas???? Edward Roche Technology Support/Network Admin Solanco School District edward_roche(a)solanco.k12.pa.us 717.786.2151 The greatest mistake you can make in life is to continually be afraid you will make one. Elbert Hubbard ________________________________ From: Eric Bégin [mailto:Eric.Begin@inLibro.com] Sent: Thu 2/19/2009 10:25 AM To: Roche III, Edward Subject: Re: [Koha-devel] Importing Data Hi Ed, That is correct. Some people set this script to run every X minutes using crontab to update their catalog on a regular basis. Eric Roche III, Edward wrote: Should be running this script from the command line, right? There isn't a link on Koha. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" 2976_Solanco_Comm_Graphic<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20[Koha-deve…> MCP(rgb)<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20[Koha-deve…> From: Eric Bégin [mailto:Eric.Begin@inLibro.com] Sent: Thursday, February 19, 2009 10:06 AM To: Roche III, Edward Cc: koha-devel Subject: Re: [Koha-devel] Importing Data Hi, I forgot to CCed the list in my previous email. (Am I doing to many things at once?) However, your error means that the C4 directory can not be reached by Perl. You have too choices 1. Set the PERL5LIB environment variable to the path containing the C4 dir (check you koha-httpd.conf file) 2. Set your current directory to the path containing the C4 dir and run the script using a relative path. Eric Roche III, Edward wrote: !@#$%@%^^ Here you go: Can't locate C4/Context.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.8.8 /usr/local/share/perl/5.8.8 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.8 /usr/share/perl/5.8 /usr/local/lib/site_perl .) at ./rebuild_zebra.pl line 5. BEGIN failed--compilation aborted at ./rebuild_zebra.pl line 5. Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" 2976_Solanco_Comm_Graphic<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20[Koha-deve…> MCP(rgb)<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20[Koha-deve…> From: Eric Bégin [mailto:Eric.Begin@inLibro.com] Sent: Thursday, February 19, 2009 9:50 AM To: Roche III, Edward Subject: Re: [Koha-devel] Importing Data Edward, You are right when you say you really do to much things at once :) I think you forgot to paste your error. Eric Roche III, Edward wrote: Has anyone come across this error run trying to run the rebuild_zebra.pl script? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" 2976_Solanco_Comm_Graphic<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20[Koha-deve…> MCP(rgb)<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20[Koha-deve…> From: Eric Bégin [mailto:Eric.Begin@inLibro.com] Sent: Wednesday, February 18, 2009 4:33 PM To: Roche III, Edward Cc: koha-devel(a)lists.koha.org Subject: Re: [Koha-devel] Importing Data Ed, After importing new record in your database, you need to reindex your database by running misc/migration_tools/rebuild_zebra.pl -b -w Let us know if this solved your problem. Eric Roche III, Edward wrote: Good Afternoon Everyone I was able to export my catalog data from Follett and I imported it into Koha with no errors and it confirmed that it added 16k+ records. The problem is when I do a search it isn't returning and listing. Did I miss something? Thanks Ed Edward J. Roche Network Administrator Solanco School District 717.786.2151 x2437 "At the End of the Day, Did You Play to Win or Not to Lose?" 2976_Solanco_Comm_Graphic<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20[Koha-deve…> MCP(rgb)<http://mail.solanco.k12.pa.us/exchange/edward_roche/Drafts/RE:%20[Koha-deve…> ________________________________ _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel ________________________________ _______________________________________________ Koha-devel mailing list Koha-devel(a)lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel

1 0