[Koha] Koha accountlines issue_id equals "zero"

2018-10-08 Thread schnydszch
Hi all! Koha 17.05.09.000 Debian 8, I'm seeing a lot of issue_id with data equals to "0" (zero) in the accountlines table in one Koha ILS installation. It must have been an error? The correct issue_id is not being recorded in the accountlines table. I'm seeing like 9,712 out of 24,000+. What could

Re: [Koha] IFLA 2018

2018-07-29 Thread schnydszch
Hi Esmael! Will be attending 2018 IFLA in Kuala Lumpur, Malaysia. I have a paper to present briefly in the Parliamentary Division on August 28. Hope to see you there and other Koha ILS users attending IFLA2018 :) -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

Re: [Koha] a warm thank you and heartfelt congratulations

2018-07-29 Thread schnydszch
Thanks for all the efforts you've done for Koha ILS and good luck Gaetan on your future endeavors! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz

Re: [Koha] Koha 18.05.00 released

2018-05-25 Thread schnydszch
Oh so global! 'Gratz and thanks for all the hard work on the awesome 18.05.00! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz

Re: [Koha] Generating Check-out Items from action_log

2018-05-24 Thread schnydszch
Hi! You can try the statistics table. statistics.type will give you 'issues', 'return', etc., just filter it to this two. It has datetime, borrowernumber, itemnumber which you can use in restoring recorda for your issues/old issues. Hth! -- Sent from:

Re: [Koha] OPAC Search Report

2017-11-23 Thread schnydszch
Hi! Looking at the database schema of Koha ILS and Koha mysql report https://wiki.koha-community.org/wiki/SQL_Reports_Library, you can use this report: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Most_Popular_Searches, the mysql code below: SELECT COUNT(*) AS Count, RIGHT(

Re: [Koha] Regarding change the case of text to proper case

2017-11-07 Thread schnydszch
To add to Vinod, in MARCEdit, that will be in Edit > Edit Shortcuts > Change case and you have lower case, UPPER CASE, Title Case, Initial case and Capitaliza Initial Character. HTH! Cheers! -- Sent from: http://koha.1045719.n5.nabble.com/Koha-general-f3047918.html

Re: [Koha] Koha password recovery doesn't seem to work

2017-10-10 Thread schnydszch
Hi Visini! Haven't tried password recovery yet in Koha but looking at the email sent through this line: /cgi-bin/koha/opac-password-recovery.pl?uniqueKey=$2a$08$DDiNbAFWtNLz80gWHQxUbe it seems the OPACbaseURL

Re: [Koha] OPAC open in new window

2017-10-10 Thread schnydszch
Hi! What exactly is happening when you click the Open in new window? Is it "The site can't be reached"? There could be a misconfiguration in the OPACBaseURL which you can edit in System Preferences > OPAC > OPACBaseURL. Please try to edit your base URL to the URL of your Koha installation, e.g.

Re: [Koha] Who created records

2017-10-09 Thread schnydszch
Hi! You can check this post: http://koha.1045719.n5.nabble.com/Staff-activity-report-td5906107.html#a5906146 and this one: http://koha.1045719.n5.nabble.com/REport-that-displays-the-bib-record-with-items-that-has-been-accomplished-by-each-staff-td5827651.html#a5827656 Vikram was right in saying

[Koha] jquery to make checkout history the default view in intranet

2017-09-20 Thread schnydszch
Dear all, Anybody tried making IntranetBiblioDefaultView other than MARC form, ISBD form, labelled MARC form and normal form (e.g. Checkout history). I'm trying to change it to jquery but can't seem to make it work. Anyone who already tried this? Cheers and thanks in advance! -- Sent from:

Re: [Koha] How to change labels on opac member entry screen

2017-07-14 Thread schnydszch
Oops, change the Student no. to Department Number. Cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/How-to-change-labels-on-opac-member-entry-screen-tp5940209p5940219.html Sent from the Koha-general mailing list archive at Nabble.com.

Re: [Koha] How to change labels on opac member entry screen

2017-07-14 Thread schnydszch
Hi, you can put this in OPACUserJS: /* Change address to Dept. Number. --*/ $(document).ready(function(){ $("#memberentry-form label[for='borrower_address']").html("Student Number:"); }); Hope that helps! -- View this message in context:

Re: [Koha] Bulk Patron Image upload zip file giving Error 500

2017-07-13 Thread schnydszch
Hi Sunil! Experienced the same, see http://koha.1045719.n5.nabble.com/batch-upload-patron-images-td5938950.html. in fact, when you take a look at the patrons just imported, the images were imported into the patron's account. I haven't taken a further look after seeing the images were indeed

Re: [Koha] Migration from INFOLIB to KOHA ILS

2017-07-12 Thread schnydszch
Hi Ms. Marian May! For the information of everyone, Infolib was developed in the Philippines, by a Filipino librarian. It's database is mysql, with some Microsoft Access, depending on the version (esp. older versions). I know that there is a way in Infolib to export MARC records, however the

[Koha] batch upload patron images

2017-06-30 Thread schnydszch
Hi all! Can somebody know the explanation to this error log below when batch uploading patron images in Koha ILS: "AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: http://localhost:8080/cgi-bin/koha/tools/picture-upload.pl; This seem apache-ish,

Re: [Koha] Maraming salamat from KohaCon2017 organizers

2017-06-27 Thread schnydszch
Dear all, I already have the numbers of registered participants for KohaCon2017 and I am happy to inform you that we had a total 188 participants during the last KohaCon both for the Main Conference and the hackfest (we had people attending only the Main Conference and some only attending the

[Koha] KohaCon2017 banner

2017-06-11 Thread schnydszch
Just almost a week to go before 2017 Koha International Conference and our banner for this Conference is now up at http://kohacon2017philippines.com/about-us/. A simple narrative on the banner you can see in the link and below: The KohaCon2017 banner depicts Bayanihan, a common tradition in

Re: [Koha] Update on Koha International Conference 2017 (KohaCon2017) to be held in Makati City, Philippines

2017-05-16 Thread schnydszch
We'll be live in a while to talk about kohacon, you can listen to it here: http://dzup.org/libradio. Pardon if it's gonna be in Taglish (Tagalog-English). -- View this message in context:

Re: [Koha] changing the font color for printing account fines

2017-05-15 Thread schnydszch
Thanks Owen. I have yet to be infront of the Koha ILS of this library I'm trying to work on, but last time it's giving me darker color. Will give feedback once I get back into this. Cheers! -- View this message in context:

[Koha] changing the font color for printing account fines

2017-05-04 Thread schnydszch
I would like to ass if any one has done or has idea on changing the font color for printing account fines? I'd like to change the color of the printed page from green to black because the library that is printing the account fines receipt uses a not-so new printer (primitive you may call it, not

[Koha] Update on Koha International Conference 2017 (KohaCon2017) to be held in Makati City, Philippines

2017-05-04 Thread schnydszch
Dear all, Here are the updates for KohaCon2017 that should have been taken note during the Koha Community monthly meeting for April 2017: 1) The organizers would like to ask that the website for kohacon2017 be added in the kohacon links of the koha community website; 2) There are now 235

[Koha] Request to add link to KohaCon2017 website from Koha Community website

2017-05-02 Thread schnydszch
The organizers of the 2017 Koha International Conference (KohaCon2017) would like that the website for the Conference be added in the Koha community website link. The URL is http://kohacon2017philippines.com/. Cheers and have a nice day! -- View this message in context:

Re: [Koha] Unable to export all marc records data from Koha ILS

2017-03-22 Thread schnydszch
cgi?id=18312 Bug 18312 - Export is broken unless a file is supplied Marc Am 22.03.2017 um 15:53 schrieb schnydszch: > It seems it's a bug. I have another server upgraded to 16.11.05 and I also > got the same. I will file a bug report for this in two days, I'd still like > to conf

Re: [Koha] Unable to export all marc records data from Koha ILS

2017-03-22 Thread schnydszch
It seems it's a bug. I have another server upgraded to 16.11.05 and I also got the same. I will file a bug report for this in two days, I'd still like to confirm with others if it really is the case. Cheers! -- View this message in context:

[Koha] Unable to export all marc records data from Koha ILS

2017-03-21 Thread schnydszch
Dear all, In Koha 16.11.05, Debian 8.x, I'm trying to export all records as MARC from my library by not choosing an item type but 'All' item types and "All Libraries". Did not upload any biblionumbers to check from. This previously worked in older Koha version, where all records are downloaded,

[Koha] Hackfest bandwidth

2017-02-02 Thread schnydszch
We, the KohaCon2017 Organizing Committee would like to ask Hackfest organizers on the bandwidth used for previous hackfests (can also be hackfests outside of KohaCon hackfest). The IT personnel of the venue sponsor for KohaCon2017 is asking the Organizing Committee this so that they can provision

Re: [Koha] KohaCon2017 Call for sponsorship

2017-01-11 Thread schnydszch
Dear Koha Community especially bigger Koha ILS support providers, We have just received result of funding proposal from the National Commission for Culture and the Arts which funds similar projects such as KohaCon and it was declined. With this being said, the KohaCon2017 Organizing Committee is

Re: [Koha] Call for news: December 2016 Newsletter

2016-12-20 Thread schnydszch
Hi Chad! Please add in the December 2016 Koha newsletter that call for sponsorships for 2017 KohaCon is now open. Possible or interested sponsors may email kohaco...@gmail.com. We have opened up three major sponsors based on the layout of the main venue, we will also have minor sponsors as well.

Re: [Koha] Acquisitions module internal server error

2016-12-14 Thread schnydszch
Hi Katrin! I've added this in Koha bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17774. Cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/Acquisitions-module-internal-server-error-tp5913371p5914060.html Sent from the Koha-general mailing list archive

Re: [Koha] Acquisitions module internal server error

2016-12-13 Thread schnydszch
Before I add this in Koha bugs, I forgot to mention that I had a plugin for barcode which is basically barcode.pl but commenting the following line: ($args{year}, $args{mon}, $args{day}) = split('-', output_pref({ dt => dt_from_string, dateformat => 'iso', dateonly => 1 }));which is to not add

Re: [Koha] Acquisitions module internal server error

2016-12-13 Thread schnydszch
Hi Katrin! I'm trying to replicate this in a new instance, I've deleted the last test instance, I can't seem to replicate. Will try again if I get access to the database of the last instance I tested. Cheers! :) -- View this message in context:

Re: [Koha] Acquisitions module internal server error

2016-12-06 Thread schnydszch
Addendum: I enabled plack in the other instance. Tested adding an order not filling up barcodes in the items, I was able to save the record and did not get internal server error. However, I got two records of the same order saved. And also, I enabled generate barcodes automatically - generated in

[Koha] Acquisitions module internal server error

2016-12-06 Thread schnydszch
I'm trying out the Acquisitions module in 16.11 in two instances. One with many test acquisitions done in the past (First instance) while the other instance almost clean slate acquisitions (Second instance). I get internal server error in the first instance whenever saving an order for a basket

Re: [Koha] Callnumber and barcode field in holds tab of the Patrons module

2016-11-29 Thread schnydszch
11:48, schnydszch wrote: > Thanks Katrin for your inputs. The library that asked this usually only has > one item, hence they asked if it will be possible when a client put a hold on > a record and then an item is filled up in the holds, or through some kind of > mechanism, the first ava

Re: [Koha] Callnumber and barcode field in holds tab of the Patrons module

2016-11-28 Thread schnydszch
rently no way to display item information for a record level hold that has not been filled. Personally I think picking a random item would be more confusing than helpful in a lot of cases - there are too many variables to make a good choice. On 23.11.2016 04:24, schnydszch wrote: > Th

Re: [Koha] Callnumber and barcode field in holds tab of the Patrons module

2016-11-22 Thread schnydszch
This I have to research yet, is there a way in the system preference to default the hold to the (nearest) available item such that it will reflect in the holds tab of patrons module? This without having to go the items. Thanks in ad1vance! -- View this message in context:

Re: [Koha] KohaCon2017 - NO MORE REGISTRATION FEE

2016-11-22 Thread schnydszch
*You read it right. ;) -- View this message in context: http://koha.1045719.n5.nabble.com/KohaCon2017-NO-MORE-REGISTRATION-FEE-tp5911777p5911784.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list

Re: [Koha] KohaCon2017 - NO MORE REGISTRATION FEE

2016-11-22 Thread schnydszch
Yes. You read it write. We, the Philippine Koha ILS volunteers for the past weeks have been talking, meeting and presenting with the stakeholders. We will keep you posted on this. Cheers! -eugene -- View this message in context:

Re: [Koha] Callnumber and barcode field in holds tab of the Patrons module

2016-11-22 Thread schnydszch
Thanks for this Katrin! Cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/Callnumber-and-barcode-field-in-holds-tab-of-the-Patrons-module-tp5911632p5911670.html Sent from the Koha-general mailing list archive at Nabble.com.

[Koha] Callnumber and barcode field in holds tab of the Patrons module

2016-11-21 Thread schnydszch
Hi all! I was trying to find where in system preference or elsewhere are the barcodes and callnumbers in holds tab of the patrons module are controlled so that they show up in the holds tab. With the current version (16.05) as well as in 3.18 it does not show. I was told previously this does show.

[Koha] mysql query xml extract value, runtime parameters and lookup of authorized values

2016-10-12 Thread schnydszch
Hi all, I have the following mysql query below to get biblio details based on target audience/course 521$a which has authorized/pre-defined values TARGET. Some records has more than one Target audience hence the ExtractValue( b.marcxml, '//datafield[@tag="521"]/subfield[@code="a"][2]') and so on.

Re: [Koha] Staff activity report

2016-10-08 Thread schnydszch
Hi! You can check on this post posted by a fellow Filipino librarian and also answered by the same http://koha.1045719.n5.nabble.com/REport-that-displays-the-bib-record-with-items-that-has-been-accomplished-by-each-staff-td5827651.html#a5827656. Copy/pasted the reports for you (with some

Re: [Koha] customizing self check out cgi-bin/koha/sco/sco-main.pl help message

2016-08-15 Thread schnydszch
Oops, my edit got lost. Well, I guess it can be reverted back by the person who's managing the wiki. If not, then I have to add them again. Cheers! On Tuesday, August 16, 2016 3:53 AM, Galen Charlton-3 [via Koha] wrote: Hi, On Mon, Aug 15,

Re: [Koha] customizing self check out cgi-bin/koha/sco/sco-main.pl help message

2016-08-15 Thread schnydszch
You're welcome! Added it already in the Koha Jquery wiki. Cheers! :) On Sunday, August 14, 2016 4:43 PM, Katrin Fischer-2 [via Koha] <ml-node+s1045719n5899656...@n5.nabble.com> wrote: Thx for sharing your solution! Am 13.08.2016 um 09:05 schrieb schnydszch: > I was able t

Re: [Koha] customizing self check out cgi-bin/koha/sco/sco-main.pl help message

2016-08-13 Thread schnydszch
I was able to resolve this and I'm sharing it so that those who will be doing similar things can take a look at this thread. First and foremost, there is SCOUserJS in order that the interface in Self Check out be further customized, there is even SCOUserCSS. Well, the key was to find the correct

[Koha] customizing self check out cgi-bin/koha/sco/sco-main.pl help message

2016-08-04 Thread schnydszch
I've been trying to figure out what to put in either SCOUserJS or OPACUserJS. Right now, instruction on how to use self check out can only be seen if the small help button is clicked. I'm trying to move the content of that in a more readable place, probably appending (?) in the main block (?),

Re: [Koha] Round the World Koha Speaking Tour

2016-06-26 Thread schnydszch
If Philippines will win the the 2017 KohaCon bid then that will be very much possible. ;) I'll inform the National Library regarding this. Cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/Round-the-World-Koha-Speaking-Tour-tp5893694p5893704.html Sent from the

Re: [Koha] 777 fields (issued with entry) not displaying

2016-06-09 Thread schnydszch
I tested adding 777 in my xslt by copying those related with 773 and replacing it with 777 and also replacing "In" with "Issued with", I have the following: Issued with:

Re: [Koha] 777 fields (issued with entry) not displaying

2016-06-09 Thread schnydszch
Hi Elaine and Heather! This could probably resolve by editing the xslt of your Koha installation and include tag 777 so that it will display in the OPAC and Staff interface. Currently, the default MARC21slim2OPACDetail.xsl which is the xslt for OPAC display has only tag 773 and 775. Take probably

[Koha] Koha instance in subdirectory and not subdomain

2016-05-22 Thread schnydszch
Hi all! Have anyone tried serving Koha instance in subdirectory (e.g. domain.com/sub) and not in subdomain (e.g. sub.domain.com). It seems there is a need to tweak in the apache server settings, but I've tried researching but to no avail. I tried "redirect" but it seems that is not possible (?).

Re: [Koha] Koha MARC modification template and field 008 position 07-10

2016-03-03 Thread schnydszch
n my spam folder and may have had the > same > > fate elsewhere. Replying for visibility (I unfortunately do not know the > > modification templates well enough to help you). > > > > 2016-02-11 7:50 GMT-07:00 schnydszch <[hidden email]>: > > > >> Good

Re: [Koha] opac-basket.tt

2016-02-21 Thread schnydszch
Hi! This could probably done through intranetuserjs of koha's system preferences. I just don't the script. Probably something like when page is in opac-basket, then 773$t and 773$g is inserted after desired field. This strategy is better because during upgrade and migration, what was in

[Koha] Koha MARC modification template and field 008 position 07-10

2016-02-11 Thread schnydszch
Good day to all! I am trying out batch record modification in 3.22 which uses MARC modification template. I see that in the action interface of the tool, we can copy fields to another field as based from the Koha 3.22 manual. I see two text boxes after the 'to field' just before 'Regex' checkbox.

Re: [Koha] Display question

2015-10-30 Thread schnydszch
How about for authorities? Are deleted authorities saved elsewhere? Or we can do the same with authorities by setting matching rules. Will the new import get the authid and controlfield '001' of the currently imported record? I'm interested with this. Thanks! -- View this message in context:

Re: [Koha] Help to assign one barcode each to 10000+ records in mrc file

2015-10-28 Thread schnydszch
Hi! Since you are usin marcedit, you can actually do this through merging provided you have 001 field or control number for your records. You can edit the records in csv/excel and then add/edit the barcodes. Convert this csv to mrk then merge the records using the 001 field as the field to use for

[Koha] Koha ILS authorites module missing interface

2015-10-27 Thread schnydszch
Hi! On a test server Debian and Koha 3.20, in the Edit/Add authorities module, the interface does not show, please see below: It's just so weird why I'm getting this. I have another test server with same

Re: [Koha] Is it possible to use a thesaurus in RDF withing KOHA?

2015-10-14 Thread schnydszch
Hi all! Regarding the AGROVOC thing, there was a module developed by the PTFS-Europe people connecting the Koha ILS of FAO to the AGROVOC web service. And regarding RDF and linked data, yeah that will be nice if the developments comes full circle, I'm also very much interested with that. Regarding

Re: [Koha] Koha error

2015-10-12 Thread schnydszch
Hi Vinod! You're question is related to this question asked before: http://koha.1045719.n5.nabble.com/Help-Software-Error-td5842000.html. You might try to read the discussion here. Cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/Koha-error-tp5856558p5856618.html Sent

Re: [Koha] koha authorities update linking authorities in subfield 0

2015-09-21 Thread schnydszch
Thanks Katrin! I will file a enhancement bug for this. Just in case for those interested, I used MARCEdit's MARC Tools and added the following XSLT to transform the MARCXML into MARCXML adding the desired Control Nos.: http://www.loc.gov/MARC21/slim;

Re: [Koha] Kohacon 2016 location

2015-09-21 Thread schnydszch
Congratulations Greece! Better luck next time Philippines! -- View this message in context: http://koha.1045719.n5.nabble.com/Kohacon-2016-location-tp5853623p5854040.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing

[Koha] koha authority plugin adding choose aside from related headings

2015-09-21 Thread schnydszch
In current iteration of Koha ILS, when authority plug-in is switch on in Cataloging and catalogers can only choose from controlled vocabularies/authorities/lists, the cataloger has to go through adding authorities/subjects through this plug-in. The cataloger is shown the authority plug-in search

Re: [Koha] koha authorities update linking authorities in subfield 0

2015-09-15 Thread schnydszch
Thanks for this Katrin! Yeah, I see this is working Katrin. However the case is if the Authorities are imports and not directly done in Koha, there is no linking between these authorities. So, in this case Borneo won't be link to Southeast Asia and vice versa unless there is subfield 9 which is

[Koha] koha authorities update linking authorities in subfield 0

2015-09-08 Thread schnydszch
In current iteration of Koha ILS, given the following marc authorities in marcxml format: The first record: 01877nz a2200433o 4500 1 Borneo g South East Asia c_7260 The second record: 02462nz a2200553o 4500 2 ... South East

Re: [Koha] Koha syck parser error

2015-08-13 Thread schnydszch
Yeah Tomas, I'm testing bug 10988. I've figured it out, it was the trailing spaces when I copy-pasted the codes (did not run the patch instead). I had to test it a virtualized lower version (3.18.6) sitting in my desktop. Thanks and cheers! :) -- View this message in context:

[Koha] Koha syck parser error

2015-08-12 Thread schnydszch
In koha 3.20.2 3.18.9 debian package install tested for both, when editing the admin.pref in order to add the lines for google authentication, I'm getting the following errors when I go to Administration - Global System Preference - Administration: Software error: Syck parser (line 117, column

Re: [Koha] Help! Software Error

2015-06-10 Thread schnydszch
Thanks Katrin! I think that's the best solution for now, to turn off AnonSuggestions. I'm also particularly curious if the web crawler is related to this spammer in opac suggestions. Oh well, will investigate further. Thanks and cheers! -- View this message in context:

Re: [Koha] Help! Software Error

2015-06-10 Thread schnydszch
It seems the borrowernumber in question does not have a username and password: http://koha.1045719.n5.nabble.com/file/n5843702/kohaopacsuggest_spam1.png as opposed to another user that has: http://koha.1045719.n5.nabble.com/file/n5843702/kohaopacsuggest_spam2.png It seems the spammer exploited

Re: [Koha] Help! Software Error

2015-06-09 Thread schnydszch
More interesting find in this particular koha server are spammed purchase suggestions from here: http://hreplib.congress.gov.ph/cgi-bin/koha/opac-suggestions.pl Sample image here: http://koha.1045719.n5.nabble.com/file/n5843576/1.jpg and here:

Re: [Koha] Help! Software Error

2015-06-09 Thread schnydszch
That will be nice MJ. So that other koha (system) administrators will be able to optimize their Koha ILS and tuned it for better performance. This robots-ignoring crawlers are annoyance especially in a very limited server space. -- View this message in context:

Re: [Koha] Help! Software Error

2015-05-29 Thread schnydszch
And oh yes once the bloated error log was deleted and the server restarted, the Koha ILS was already accessible. I'm particularly curious if that really is the case. -- View this message in context: http://koha.1045719.n5.nabble.com/Help-Software-Error-tp5842000p5842198.html Sent from the

Re: [Koha] Report help

2015-04-14 Thread schnydszch
Hi Nicole Nick! I'm particularly interested with this report. What I did before was this: ExtractValue (marcxml,'//datafield[@tag=653]/subfield[@code=a][1]') as Keywords, ExtractValue (marcxml,'//datafield[@tag=653]/subfield[@code=a][2]') as Keywords, ExtractValue

Re: [Koha] Help - kind request

2015-03-11 Thread schnydszch
Hi! Your query is related with this query weeks ago: http://koha.1045719.n5.nabble.com/REport-that-displays-the-bib-record-with-items-that-has-been-accomplished-by-each-staff-td5827651.html Hope this helps. Cheers! -- View this message in context:

Re: [Koha] Intro, and req for help :)

2015-03-07 Thread schnydszch
Hi! You can use MARCEdit's Delimited Text Translator to do this. Here is a link to help you do that: http://manual.koha-community.org/3.2/en/marceditexcel.html Cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/Intro-and-req-for-help-tp5831095p5831098.html Sent from the

Re: [Koha] REport that displays the bib record with items that has been accomplished by each staff

2015-02-11 Thread schnydszch
Hi! Manny emailed you and I've also emailed you regarding this report. However, it will be better if the report is shared here (at least on my part): Reports of All Catalog Actions SELECT b.title , b.author , i.itemnumber, i.itemcallnumber , i.barcode , l.action_id,

Re: [Koha] (Sip2) couldn't start sip2

2015-02-01 Thread schnydszch
Thanks for the reply off list regarding amazon servers and SIP. Don't forget to restart the sip server through koha-stop-sip and koha-start-sip (in Debian package) so that the settings edited in SIPconfig.xml will take effect. This one took me time when I was configuring our Koha ILS server to

[Koha] Koha news not showing

2014-09-30 Thread schnydszch
In Koha version 3.16.3 Debian package, news suddenly not does not show in our Koha ILS opac. Anybody experienced/experiencing this? The news are published and have not expired yet. Even in the admin/librarian interface, news aren't showing. The theme used is bootstrap. We've just experienced this

Re: [Koha] sql report for bibliographic records with more than one subject

2014-09-26 Thread schnydszch
So I researched on this for the past few days, scouring the internet, only to find partly the answer in mysql-xml documentation (http://dev.mysql.com/doc/refman/5.1/en/xml-functions.html), I came up with the following: SELECT ExtractValue(marcxml,'//datafield[@tag=245]/subfield[@code=a]') AS

Re: [Koha] possible bug with stage MARC import

2014-08-27 Thread schnydszch
    reverse/revert the       load and then load it again. Then it matches and all is well.             This is also 3.16.02.             Steve       [hidden email] mailto:[hidden email]             On 8/10/2014 8:53 AM, schnydszch wrote:             Hello Koha community! We're

Re: [Koha] possible bug with stage MARC import

2014-08-14 Thread schnydszch
[hidden email] On 8/10/2014 8:53 AM, schnydszch wrote: Hello Koha community! We're using Koha 3.16.2 in Koha Debian 6.x. I was importing a bunch of MARC records, but whenever I'm in the 'Stage for import' part, I get only 31%, that's for like 10 minutes which I find it weird, it should get

[Koha] possible bug with stage MARC import

2014-08-11 Thread schnydszch
Hello Koha community! We're using Koha 3.16.2 in Koha Debian 6.x. I was importing a bunch of MARC records, but whenever I'm in the 'Stage for import' part, I get only 31%, that's for like 10 minutes which I find it weird, it should get to 100% in no time since there were only 6000 MARC records. So

Re: [Koha] Case for selecting Item types preference in Koha OPAC search module

2014-06-09 Thread schnydszch
Hi! We have the same query, I posted this two weeks ago: http://koha.1045719.n5.nabble.com/koha-item-types-dropdown-instead-of-library-dropdown-td5798062.html I was actually able to implement this in the Koha ILS project I am working, I just follow the lead of Fridolin Somers. I came up with this

Re: [Koha] how to not show Look for articles in this serial in Analytics

2014-06-01 Thread schnydszch
to hide it totally - something like .analytics { display:none; } in OpacUserCSS should do the trick. As there is no indication on the record if an analytic record for it exists, there is no easy way to do what you want. Katrin -Ursprüngliche Nachricht- Von: Koha im Auftrag von schnydszch

Re: [Koha] how to not show Look for articles in this serial in Analytics

2014-06-01 Thread schnydszch
, there is no easy way to do what you want. Katrin -Ursprüngliche Nachricht- Von: Koha im Auftrag von schnydszch Gesendet: So 01.06.2014 12:42 An: [hidden email] Betreff: [Koha] how to not show Look for articles in this serial in Analytics   Hi Koha community! I've been trying to figure this one

[Koha] Holds on 'in process' materials

2014-06-01 Thread schnydszch
Hello Koha community! Is it possible to hold/reserve items that are 'in process'? 952$0 has the following values: 2 For Binding No limitation EditDelete 3 For Location No limitation EditDelete 4 For Repair

Re: [Koha] koha item types dropdown instead of library dropdown

2014-05-25 Thread schnydszch
Hi all! I just can't seem to add item types in the drop down for Library Catalog, Title, Call Number, etc. but I was able to add them in the library masthead, which was actually the title of my query. After some readings on jquery, and deciding to put it instead in the library masthead, I was able

Re: [Koha] koha item types dropdown instead of library dropdown

2014-05-24 Thread schnydszch
Hi! Still novice with jquery, but I'm trying it out, I'm at my wit's end reading on jquery. I have came up with this: $(select#masthead_search).append(option value=\mc-itype\Item type-books/option); $(input[name='q']).val('BK'); What this one do, is the text 'BK' is in the search box, But still

Re: [Koha] 'add basket group' bug in Koha 3.14.6

2014-05-22 Thread schnydszch
It seems I'm missing some columns, where do I get an sql file for this? thanks and cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/add-basket-group-bug-in-Koha-3-14-6-tp5798519p5798906.html Sent from the Koha-general mailing list archive at Nabble.com.

Re: [Koha] 'add basket group' bug in Koha 3.14.6

2014-05-22 Thread schnydszch
I have two Koha instances, and just compared them, it seems, I'll just copy the aqbasketgroups structure of the working Koha instance into the offending Koha instance. Cheers! -- View this message in context:

Re: [Koha] notes or statistics of transactions in Circulation

2014-05-22 Thread schnydszch
indicate that they have permission to check out on behalf of their bosses? By the way schnydszch your messages to the Koha list are consistently marked as Spam by GMail, so I wonder if the same is happening for other people receiving your emails. I suggest you subscribe to the list rather than

[Koha] 'add basket group' bug in Koha 3.14.6

2014-05-21 Thread schnydszch
Hello Koha community! We were trying out the Acquisitions module of Koha ILS, the version as you can see in subject post is 3.14.6, and is installed in Debian 6.x. Whenever I close a basket wherein we're notified to create a basket group for it with the same name as the Basket name, there is no

Re: [Koha] 'add basket group' bug in Koha 3.14.6

2014-05-21 Thread schnydszch
On Wednesday, May 21, 2014 8:10 AM, Jonathan Druart [via Koha] ml-node+s1045719n5798836...@n5.nabble.com wrote: It works here on 3.14.6 and master. Do you have some warnings/errors in the Koha logs? 2014-05-20 12:56 GMT+02:00 schnydszch [hidden email]: Hello Koha community! We were trying out

Re: [Koha] koha item types dropdown instead of library dropdown

2014-05-21 Thread schnydszch
   option value=All/option    option value=mc-itemtype,phr:BOOKBook/option    option value=mc-itemtype,phr:DVDDVD/option    ... /select Best regards, Le 17/05/2014 18:09, schnydszch a écrit : I forgot that the library pulldown for libraries can be hidden through global system preference

Re: [Koha] notes or statistics of transactions in Circulation

2014-05-21 Thread schnydszch
Thanks Viktor! It seems I need to file a bug for this then? Cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/notes-or-statistics-of-transactions-in-Circulation-tp5797903p579.html Sent from the Koha-general mailing list archive at Nabble.com.

[Koha] notes or statistics of transactions in Circulation

2014-05-20 Thread schnydszch
Hello Koha community! I would like to ask if the feature I'll be mentioning is under development. In the Circulation module, a note or statistics can be attach to circulation transactions. In our library, some bosses ask their staffs to borrow books for them, and these bosses aren't even in the

Re: [Koha] ***UNCHECKED*** Overdue Fines..

2014-05-20 Thread schnydszch
Hi! You may try Vimal's instructions: http://kohageek.pbworks.com/w/page/58731341/Configure%20gmail%20with%20postfix%20to%20send%20notices%20from%20Koha Cheers! -- View this message in context: http://koha.1045719.n5.nabble.com/UNCHECKED-Overdue-Fines-tp5797787p5797904.html Sent from the

[Koha] koha item types dropdown instead of library dropdown

2014-05-20 Thread schnydszch
Hi all! I have a library project that has only one main library. In tha main search of koha, is it possible to hide this drop down, i haven't seen the jquery i'll to see if this is possible. And also is it possible to put instead here drop down for items? Are there libraries who uses the same or

Re: [Koha] koha item types dropdown instead of library dropdown

2014-05-20 Thread schnydszch
I forgot that the library pulldown for libraries can be hidden through global system preference OpacAddMastheadLibraryPulldown. However, the project I'm working with would like to add a dropdown for item types, will that be possible? Thanks in advance and cheers! -- View this message in

Re: [Koha] Big problem in Staff Client, Koha 3.14.5

2014-05-01 Thread schnydszch
And also with Google Chrome, or whatever web browser you're using, try clearing the cache and cookies, that would help. In Chrome, go to settings More Privacy Content Settings Cookies All cookies and site data. Put in text box just beside Remove all the domain name of your Koha site, then

[Koha] Customizing the intranet

2014-04-30 Thread schnydszch
Hello Koha community! I will be implementing in our library having this in MARC field 937$a the Encoders, the one who entered the biblio records, 937$b Editor and 937$c Approving person (the head cataloger who approves if the bibliographic records are Okay). Although logs can be seen who added,

  1   2   >