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

Re: [Koha-devel] bug in Acquisition module, regarding VAT management ?
by Paul 13 Dec '12

13 Dec '12

At 02:14 PM 12/13/2012 +0100, Mathieu Saby wrote: >Hi >Here is my bug : http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9280 > >I don't know exactly what is the meaning ofÂ "list item price" in vendor >records, but I am not fluent in english... Mathieu - assuming it is "retail price" (which we certainly do in this context), then it's 'prix de vente au détail' or 'prix de vente public.' Bonnes fêtes de fin d'année a+ Paul _______________________________________________ Koha-devel mailing list Koha-devel(a)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/ --- Maritime heritage and history, preservation and conservation, research and education through the written word and the arts. <http://NavalMarineArchive.com> and <http://UltraMarine.ca>

2 1

bug in Acquisition module, regarding VAT management ?
by Mathieu Saby 13 Dec '12

13 Dec '12

Hello We think we have found a bug in Acquisition module, regarding VAT management, but we want to be sure. Let's take a book whose *recommended retail price excluding tax *is 39 euros. On the vendor's website, I import the record for this book in iso2709 In the record (UNIMARC), the price is in 010$d after the ISBN. So, I found : $d39.00 EUR I stage this record in Koha with Stage Marc Records Tools. In Acquisition module, I create a vendor with: - List item price includes tax: Yes - Invoice item price includes tax: Yes - Discount: 9.0000 % - Tax rate: 5.5% I create a new basket for this vendor. I fill this basket with my stage record. I think I should have for the command line in this basket : - RRP tax included : 39 euros - Ecost tax included : 39 euros - 3,51 euros = 35,49 euros - RRP tax excluded : 39*100/105.5 = 36,96 euros - Ecost tax excluded : 35,49*100/105.5 = 33,63 euros *BUT instead I see the following values : * - RRP tax included : 42.86 euros - Ecost tax included : 39 euros - RRP tax excluded : 40,63 - Ecost tax excluded : 36,97 So, Koha considered the "39 euros" value in my record as a Ecost price. I dont think it is normal, as as chose "List item price includes tax: Yes" in vendor record. Do you agree with me? -- Mathieu Saby Service d'Informatique Documentaire Service Commun de la Documentation Université Rennes 2 Téléphone : 02 99 14 12 65 Courriel : mathieu.saby(a)univ-rennes2.fr

3 4

sanop.css still in use?
by Owen Leonard 12 Dec '12

12 Dec '12

My patch for Bug 8108, "Remove unused images from the OPAC" (http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8108) is in limbo because it removes an image which is referenced by sanop.css. This file isn't referenced by any template and hasn't been modified since before 2007. Is this file still in use? Can it be safely removed? -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org

2 2

[QA] QA-ing packaging & install tools
by Paul Poulain 11 Dec '12

11 Dec '12

Hi QA team, I was wondering who feel brave enough to QA patches related to installation & packaging, for example: 8519 Make koha-index-daemon run on startup 8840 ubuntu-pkg-check.sh fix and extend functionality 8878 koha-shell: a command to make using koha commands easier I can QA the code quality, but can't test most of those patches because i'm a dummy at sysadmin. As testing is required for QA, who can show his hand and say "will do" ? -- Paul POULAIN - BibLibre http://www.biblibre.com Free & Open Source Softwares for libraries Koha, Drupal, Piwik, Jasper

7 8

Can't search after loading a 3.8 sql dump into 3.10
by Magnus Enger 10 Dec '12

10 Dec '12

I have an instance running 3.8.7 off the official packages. I take the .sql.gz file produced by the backup-script in that installation and move it to another server where I have installed 3.10, again from the official packages. Then I create a new 3.10 instance on the new server with the same name as the instance on the old server ("esme"), gunzip the sql dump file and load it into the new installation, with this: sudo koha-mysql myinstance < dump.sql Then I do: sudo koha-upgrade-schema esme sudo koha-rebuild-zebra -f esme Everything looks good (the output from koha-upgrade-schema is here: http://paste.koha-community.org/304) but I can't search in the new installation. I get a search results page that has: 1. "You did not specify any search criteria." in the title of the page 2. "Error: Can't call method "raw" on an undefined value at /usr/share/koha/lib/C4/Search.pm line 461." in the body of the page. The only thing that happens in /var/log/koha/esme/opac-error.log is this, which seems benign: [Mon Dec 10 13:29:35 2012] [error] [client x.x.x.x] [Mon Dec 10 13:29:35 2012] opac-search.pl: Use of uninitialized value $error in concatenation (.) or string at /usr/share/koha/opac/cgi-bin/opac/opac-search.pl line 509., referer: http://esme.testing.bibkat.no/cgi-bin/koha/opac-main.pl If I create another instance on the new server, run through the web installer manually then export the records from the old server and stage/import them into the new server then searching works just fine (after I run koha-rebuild-zebra -f). As far as I can tell, the contents of /etc/koha/sites/esme/zebra-biblios.cfg are identical for the two instances. Reindexing looks like this: $ sudo koha-rebuild-zebra -f -v esme Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/esme/biblios Zebra authorities directory = /var/lib/koha/esme/authorities Koha directory = /usr/share/koha/intranet/cgi-bin BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ skipping authorities ==================== exporting biblio ==================== 101.................................................................................................. Records exported: 150 ==================== REINDEXING zebra ==================== ==================== CLEANING ==================== Zebra configuration information ================================ Zebra biblio directory = /var/lib/koha/esme/biblios Zebra authorities directory = /var/lib/koha/esme/authorities Koha directory = /usr/share/koha/intranet/cgi-bin BIBLIONUMBER in : 999$c BIBLIOITEMNUMBER in : 999$d ================================ ==================== exporting authority ==================== Records exported: 0 ==================== REINDEXING zebra ==================== skipping biblios ==================== CLEANING ==================== Anyone got any clues about what could be happening here? Best regards, Magnus Enger libriotech.no

4 4

Call for news for the December newsletter
by Daniel Grobani 10 Dec '12

10 Dec '12

Dear Koha kommunitarians, I'm harvesting news for this month's newsletter. Please send me by the 20th anything you think your fellow community members might like to know about. "News" can be as short as a sentence or as long as a paper. I especially encourage you to send me a line or two for the gossip/society column about what you're currently working on. And if you know of a go-live not announced on the list, please be sure to let me know about it. Thanks, Daniel Grobani

1 0

BZ8942
by Fridolyn SOMERS 10 Dec '12

10 Dec '12

I've proposed a big patch for a translation problem : BZ8942. It is based on a new coding rule : javascript translated strings must use double quotes : _("xxx"), never single quotes. See why in BZ discussion. If developpers agree, it should be added in wiki, in QA tools and automated test. I look for a go from community and a sign-off of patches. Best regards, -- Fridolyn SOMERS Biblibre - Pôle Support fridolyn.somers(a)biblibre.com <mailto:fridolyn.somers@biblibre.com>

2 1

Interface issues after upgrading
by MHE IT admin 08 Dec '12

08 Dec '12

Hello everyone, after some issues with me server I had to reinstall Koha and it upgraded from 3.8.6 to 3.10 now. but I realise now that all the interface is messed up. It seams some CSS is not loading, I was wondering whether any one has reported this issue. Do you have any idea how I can fix this issue? Please see our library website at: http://library.koyauniversity.org/ Thanks

2 1

help in report
by Mohamed zalabany 07 Dec '12

07 Dec '12

I need to make report to extract serials data but its not workingi think there is sothing wrong but i don't konowcould any body help me select ExtractValue(marcxml,'//datafield[@tag="501"]/subfield[@code>="a"]') as ID, ExtractValue(marcxml,'//datafield[@tag="310"]/subfield[@code>="a"]') as Freq, ExtractValue(marcxml,'//datafield[@tag="245"]/subfield[@code>="a"]') as Title, ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code>="b"]') as Publisher, ExtractValue(marcxml,'//datafield[@tag="260"]/subfield[@code>="a"]') as Publication place, ExtractValue(marcxml,'//datafield[@tag="546"]/subfield[@code>="a"]') as Language, ExtractValue(marcxml,'//datafield[@tag="500"]/subfield[@code>="a"]') as Note, ExtractValue(marcxml,'//datafield[@tag="500"]/subfield[@code>="a"]') as Subject, ExtractValue(marcxml,'//datafield[@tag="982"]/subfield[@code>="a"]') as Price, from biblioitems where itemtype = CR Mohamed El ZalabanyIntegrated library systems consultant Zalabany Knowledge Systems Team© For Libraries and Information systems Development and support mh_zalabany(a)hotmail.com Mobile: 0009989496

2 2

Search operators
by Jared Camins-Esakov 06 Dec '12

06 Dec '12

Hello. As many of you know, I have been working on rewriting Koha's search code so that it is more palatable than a plate of burned nine-day-old spaghetti. The initial part of the development is nearing completion, and I look forward to submitting a patch to the community for sign off[1]. In the course of the first section of the development, I have run into an interesting question. We currently support greater than and less than operators in our searches, but I cannot think of anywhere we might want to use them other than with dates. Does anyone have any scenarios where a greater than/less than operator would actually be useful in a bibliographic or authority search (other than in date searches)? Regards, Jared [1] If you're interested in seeing my work so far, the search rewrite branch in my public repo has all the code: http://git.cpbibliography.com/?p=koha.git;a=shortlog;h=refs/heads/search_re… The RFC is at http://wiki.koha-community.org/wiki/C_%26_P_Search_Rewrite_RFCand I would still welcome any and all comments. -- Jared Camins-Esakov Bibliographer, C & P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcamins(a)cpbibliography.com (web) http://www.cpbibliography.com/

5 4