[Koha] On how to create a report

Hey guys, My question is how can I create a report to know how many books were cataloged from Jan till now (or any other time period)? I have tried, but I find that the manual is not clear enough on this. all the reports I created were not able to give me this info Thanks [I still have 3.10

Re: [Koha] On how to create a report

Hello Paste the following program in reports. SELECT CONCAT('',biblio.title,'') AS Title, biblio.author AS Author, items.barcode AS Barcode FROM items LEFT JOIN biblio ON (items.biblionumber=biblio.biblionumber) WHERE DATE(items.dateaccessioned) BETWEEN <> AND <> I hope this will

Re: [Koha] Z39.50 Bug -> marcxml_old on import_records table

Pedro, Please answer to the list. Yes it's the easy and lazy solution. If you want to use MySQL 5.6, you must disable STRICT_TRANS_TABLES, otherwise you will encounter some errors. But we should take care of these errors and fix them. Regards, Jonathan 2015-10-29 16:51 GMT+00:00 Pedro Amorim

Re: [Koha] On how to create a report

Thank you it worked!! You saved me!! p.s. is there anything I can add so it gives me the information of how many books each librarian cataloged? Thank you so much -- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859367.html

Re: [Koha] Display question

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] On how to create a report

Thank you! -- View this message in context: http://koha.1045719.n5.nabble.com/On-how-to-create-a-report-tp5859353p5859377.html Sent from the Koha-general mailing list archive at Nabble.com. ___ Koha mailing list http://koha-community.org

Re: [Koha] On how to create a report

You are most welcome Catarina. Please visit the link I sent. It gives many reports that we normally require. If you check the list item 6.86 and 6.87 are the reports you required. I hope either one will help you provided CataloguingLog to be on (setting in global system preferences, under

[Koha] Create a report that lists biblio number for a specific item type

I've searched the forum but cannot find an SQL report that will allow me to generate a list of biblio numbers for a specific item type (for example, list all DVDs or list all Set Texts). Should I be creating a report for this type of listing or should I be using another tool to create the

Re: [Koha] Difficulty filling out accounting info

Hi Ann, I confirm that it seems to work for me using 3.20.4 so it certainly comes from your data. Could you please make a screenshot of the form when you get the NaN and give us the rate for the currency you use? Regards, Jonathan 2015-10-29 22:27 GMT+00:00 library

Re: [Koha] On how to create a report

Hi, You may visit this wiki page : http://wiki.koha-community.org/wiki/SQL_Reports_Library and you can see all reports related to what you want , we use the following 2 reports in our library : they will give you the name of the cataloger as well but you must active action log in your syspref

[Koha] Configuring smtp mail server to work with Koha

Hello, I want to configure an smtp server so that Koha can use it to send e-mail notifications. I was expecting some sort of configuration file where I would configure the server, username, password and some other parameters but that is not the case. From my research I found 2 possible ways: 1)

[Koha] Koha Offline Circulation 1.3 Released!

Hello All, I've updated the original desktop Koha Offline Circulation app for the first time in 5 years! Coeur d'Alene Public Library has sponsored the addition of a new feature. The "Database" menu has now been renamed "Settings" and has a new option to pre-set a default directory to save your

Re: [Koha] Configuring smtp mail server to work with Koha

Hi Pedro However, Koha still doesn't send any e-mail when I manually add a new patron. NOTE: 1) AutoEmailOpacUser is set to "send" in administration -> patrons; 2) All cronjobs were left as default. I also know they are running because my new records get indexed every 5 minutes. You might try

Re: [Koha] Configuring smtp mail server to work with Koha

Hello Galen, Thank you for your reply. I have changed the Sendmail.pm file to point to smtp.gmail.com instead of localhost and am now receiving these errors: # koha-foreach --enabled --email /usr/share/koha/bin/cronjobs/ process_message_queue.pl -v koha: sending email message to patron: Admin at

[Koha] Zebra (Koha 3.20.05) - Run it as a cron job or use default daemon?

Hi all, Koha 3.20.05 on Ubuntu 14.04 LTS x64 VPS (package install) Was just wondering if it is still recommended to run zebra as a cron job (/usr/share/koha/bin/migration_tools/rebuild_zebra.pl) rather than using the zebraqueue. I've read older posts saying that this was case (ca. 2008-2013).

Re: [Koha] Configuring smtp mail server to work with Koha

Hello Michael and Mark, Thank you for your replies. Silly me, I forgot to mention I had already run the command koha-email-enable so that is not the reason. UPDATE: I had the following entry on the logs: Use of uninitialized value $OPACBaseURL in substitution $OPACBaseURL is a variable being

Re: [Koha] Koha 3.20.03 - koha-opac-error_log

Hi Ozkan, This should be related with that you didn't choose a Library in Opac interface. / / On 29-10-2015 14:15, Ozkan OZMEN wrote: Hi all, I have 2 errors at koha-opac-error_log at below: [Thu Oct 29 13:41:00 2015] opac-search.pl: C4::Context->userenv not defined! at

Re: [Koha] Koha 3.20.03 - koha-opac-error_log

Greetings, The file name is a partial misnomer. Warnings and errors go into this file. [Thu Oct 29 13:41:00 2015] opac-search.pl: C4::Context->userenv not defined! at /usr/share/koha/lib/C4/Items.pm line 1355. [Thu Oct 29 13:53:31 2015] opac-detail.pl: C4::Context->userenv not defined! at

Re: [Koha] Changing IP on Koha Server

Hi Greg, You don't say which distro you are using. On my Debian install, I have the IP addresses I use statically defined in /etc/network/interfaces . I would check there first. Best, Doug -Original Message- From: Koha [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of G P Ashe

Re: [Koha] Koha 3.20.03 - koha-opac-error_log

Hi Mengu, Thanks for your interest. So these errors doesn't important for us. Good works. Regards, Özkan ÖZMEN CENTER OF LIBRARY BALIKESIR UNIVERSITY - TURKEY YASAL UYARI: Bu elektronik posta ve onunla iletilen butun dosyalar kisiye ozeldir ve sadece gondericisi tarafindan almasi amaclanan

Re: [Koha] Configuring smtp mail server to work with Koha

Hello, I have solved the problem: Sendmail.pm needs to have smtp => 'localhost' and port => 25 and the e-mail notifications are now working. Thank you, Pedro Amorim 2015-10-30 14:23 GMT-01:00 Pedro Amorim : > Hello Galen, > > Thank you for your reply. > I have changed

[Koha] 3.20 circulation email to staff

We're testing 3.20 before installing it in production. As part of the test, I ran some items through checkout and check in. I was surprised to receive emails about both these actions at the end of the day. I have been digging around in the system preferences, but haven't yet found where to

Re: [Koha] System Time

Thank you. I have sorted this out. On Fri, Oct 30, 2015 at 12:52 PM, vinod kumar wrote: > yes Date and time taking koha from system > > On Thu, Oct 15, 2015 at 4:51 AM, Nas Yakubu wrote: > >> Hi >> >> Can anyone advise me on how to change the

[Koha] Changing IP on Koha Server

I need to change the fixed IP on Koha server. What files need to be updated manually in order that everything will work as before but with new IP (different subnet). Thanks Greg -- *Disclaimer Important*: ​ Information in this email (including attachments) is confidential. It is intended