- Koha - lists.katipo.co.nz

SMTP settings
by Father Vlasie 14 Feb '19

14 Feb '19

Dear Koha list, Is there a way to set an external SMTP server for Koha to send emails? Thank you! Father Vlasie IT Director St. Photios Orthodox Theological Seminary 510 Collier Way, Etna, CA 96027, U.S.A. Website: www.spots.school

2 2

Re: [Koha] Problem with Notices & Slips
by Katrin Fischer 13 Feb '19

13 Feb '19

Hi Abhishek, I think you might not be missing the sample notices, but some of the mandatory data. Check your database tables: message_attributes, message_transport and message_transport_types. Especially the last one should have 4 entries: email, phone, print, sms. But the others need to have data as well. Katrin On 12.02.19 09:12, अभिषेक नागर Abhishek Nãgar wrote: > I am Using Koha 18.11.02.000, Installed it via apt-get > > When i try to Add a Notice and click on save i get an alert Please > fill at least one template. (attached) > _________________________________________ > Abhishek Nagar > > > > > On Mon, 11 Feb 2019 at 11:45, Katrin Fischer <katrin.fischer.83(a)web.de > <mailto:katrin.fischer.83@web.de>> wrote: > > Hi, > > you can find examples for a lot of the notices in the wiki: > https://wiki.koha-community.org/wiki/Notices_and_Slips_Library > > If you have access to your database you could also load the sample > notices using SQL. The SQL file is part of your Koha installation. > > But not having the sample notices should not create any problems when > using the notices and slips tool. What you describe sounds like there > might be another problem. > > How did you install Koha and which version are you using? What is the > error displaying? > > Katrin > > > On 04.02.19 14:56, अभिषेक नागर Abhishek Nãgar wrote: > > Dear All, > > > > I am relatively new to Koha, installed my first instance was > able to import > > 40000+ titles from LibSys ane approx 3000 Users. > > > > Koha installation is working quite well on a 8 Gb RAM VPS > Cataloguing, > > Circulation and everything thing is working just file. But No > default > > templates are available under Notices & Slips I would like to > enable few > > email alerts. > > > > When I try to add new notice it won't allow me to do and > displays error to > > select a template while email phone body fields are not visible > while > > creating Notice. > > > > Kindly suggest how to import default notices now so that it may > work. > > > > IMO I deselected sample notices while creating instance can I > now get > > default Notices & Slips > > > > > > Abhishek Nagar > > _______________________________________________ > > Koha mailing list http://koha-community.org > > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> > https://lists.katipo.co.nz/mailman/listinfo/koha >

2 5

How to receive reports to email
by SATISH 13 Feb '19

13 Feb '19

Hi, I would like to receive check-out and check-in report in CSV or tab separated text - format on daily basis to my email automatically on daily basis. How to set cron entry to get such report automatically. Kindly share your best practices if any of the library has implemented same feature. I tried for Tools › Task scheduler for getting particular report through email, but text file received is not correctly formatted. And it has to be manually set every day. I use Ubuntu 14.04 - Koha 16.11 - installed by Package Method - along with MySql. -- *Satish MV* Librarian - Govt. Engineering College Opp. Dairy Circle, B.M.Road, Hassan 573 201 Karnataka, INDIA Mobile: +91 9449765737 Personal Email: lis4satish(a)gmail.com College Website: www. <http://www.git.edu/>gechassan.ac.in Library OPAC: http://library.gechassan.ac.in Library Portal : https://librarygechassan.wixsite.com/library

1 0

Re: [Koha] Problem with batch cover image upload
by Mai 12 Feb '19

12 Feb '19

On Sat, 2 Feb 2019 13:56:42, Katrin wrote: > Hi Mai, > > just to make sure - are you trying to upload cover images or patron images? > > What kind of files includes your zip file and how are they named? > > 3.16 is really old by now. I would have suggested to test on a newer > version, but you said you already did on 18.05. Was that a local > installation one or one of the demos? > > Katrin > Dear Katrin, Thanks for your answer. I'm trying to upload cover images from Tools > Catalog > Upload local cover image. My zip file contains one image named 0001.jpg (I've also tried with the same image on .png format) and one .txt file named "DATALINK.txt" where I've listed several biblionumbers and the image name separated by a comma; one biblionumber per line.Like this: 26794, 0001.png 26795, 0001.png ... and so on. (In case it wasn't possible pointing several IDs to the same image, I've also tried the same file with two images & two ID's; one for each and get the same error) I've tried both with and without a space between the comma and the image name. The 18.05 version I tested this on was a local installation where we're planning on migrating our whole database. Presently, we're testing a copy of the same database we have at 3.16 and checked that the IDs mentioned above do exist. The error in my intranet.error.log says the same in both installs. [Mon Feb 04 09:50:44.648135 2019] [http:error] [pid 28363] [client] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: /cgi-bin/koha/tools/upload-cover-image.pl Thanks a lot for your feedback! Regards, Mai

2 1

Koha Duplicating Items
by Myriam Torres 12 Feb '19

12 Feb '19

Hello, I want to import my newly created marc file into Koha. Everything is imported successfully in the Koha empty database, and it is creating a single record. The problem is that instead of creating a single item with all the information it creates many items with different information. This is my mrc file: =LDR 00830nam a2200349Ia 45e0 =005 $020190131144117 =008 $0051202s\\\\\\\\xxu\\\\\\\\\\\001|0|eng\d =008 190212s9999\\\\xx\\\\\\\\\\\\000\0\und\d =020 \\$a1558602976 =040 \\$aDLC =040 \\$beng =040 \\$cDLC =040 \\$dDLC =082 \\$a005.265 =100 \\$aFarquhar, Erin. =245 \4$aThe MIPS programmer's handbook =245 \0$cErin Farquhar and Philip Bunce =260 \\$aSan Francisco, Calif. =260 \\$bMorgan Kaufmann Publishers =260 \\$c1994 =300 \\$aviii, 408 p. =300 \\$bill. =300 \\$c24 cm. =500 \\$aIncludes index. =650 \\$aEmbedded computer systems --Programming. =942 \\$2ddc =942 \\$cBK =952 \\$aAKL =952 \\$bAKL =952 \\$o005.265 =952 \\$p0014915 =952 \\$yBK this are the MARC staging results : Processing bibliographic records 1 records in file 0 records not staged because of MARC error 1 records staged Did not check for matches with existing records in catalog *5 item records found and staged* Do you have any idea what i am doing wrong or why this is happening? Thank you --

3 2

Problem with Notices & Slips
by अभिषेक नागर Abhishek Nãgar 11 Feb '19

11 Feb '19

Dear All, I am relatively new to Koha, installed my first instance was able to import 40000+ titles from LibSys ane approx 3000 Users. Koha installation is working quite well on a 8 Gb RAM VPS Cataloguing, Circulation and everything thing is working just file. But No default templates are available under Notices & Slips I would like to enable few email alerts. When I try to add new notice it won't allow me to do and displays error to select a template while email phone body fields are not visible while creating Notice. Kindly suggest how to import default notices now so that it may work. IMO I deselected sample notices while creating instance can I now get default Notices & Slips Abhishek Nagar

2 1

KohaCon19 Update
by Charles Quain 09 Feb '19

09 Feb '19

Dear Koha Community On behalf of the organising group, I thought it would be useful to send an update on the preparations for KohaCon19. The website for the conference is here: https://www.interleaf.ie/kohacon19/ We are getting registrations every day and proposals for talks and workshops. Every talk and workshop proposal is being published as they are received. You can review the list at this link: https://www.interleaf.ie/kohacon-schedule/ Information will also be tweeted as proposals are received using the hashtag #kohacon19 There are plenty of slots available so do make a proposal. We would like to clarify the "workshops" times in the schedule. In the past people have felt that the term "Hackfest" can put off less technical delegates who feel they might not have anything to contribute so we changed it to "Workshops" The schedule has space for 12 workshops. 2 running in parallel over six time-slots, but more parallel sessions can be added if the demand is there. We want these to be a combination of very technical sessions and training-based sessions. We are thinking of 4 themes for these sessions: One for unstructured development (the traditional "Hackfest"), and one for each of the following. *User training* ** Hands on with X ** How a feature goes from idea to reality in community *Developer training* ** External trainer for Elastic Search ** External trainer for Mojolicious ** External trainer for DBIx::Class ** External trainer for Modern Perl Best Practice ** Elasticsearch focus group ** How to write good tests ** How to write selenium tests ** How to get to PQA (Passed Quality Assurance) ** Encouraging 'Code Golf' *Contributor training* ** How to test and signoff ** How to translate ** How to contribute to the manual ** How to join the QA team (what experience you'll need to build up before we'll invite you) ** Funding and Roadmaps? As a few of these sessions will require bringing in external trainers at a cost, we will be reaching out to the community in the next few weeks to raise sponsorship. Any questions - email kohacon19(a)interleaf.ie Regards Charles Quain <http://www.interleaf.ie/> *Charles S. Quain* Managing Director csq(a)interleaf.ie +353-1-286-5855 +353-87-978-5911 A98 YD30 www.interleaf.ie <http://www.interleaf.ie/products-services/Library-Applications/Scooter> <http://www.interleaf.ie/products-services/Library-Applications/Koha> <http://www.interleaf.ie/products-services/PC-Reservation-and-Print-Manageme…> We are hosting <https://www.interleaf.ie/kohacon19/> in Dublin in May 2019. (Click on the logo for more details) #kohacon19

1 0

Re: Problem with batch cover image upload
by Mai 08 Feb '19

08 Feb '19

Dear Katrin, Thanks for your answer. I'm trying to upload cover images from Tools > Catalog > Upload local cover image. My zip file contains one image named 0001.jpg (I've also tried with the same image on .png format) and one .txt file named "DATALINK.txt" where I've listed several biblionumbers and the image name separated by a comma; one biblionumber per line.Like this: 26794, 0001.png 26795, 0001.png ... and so on. (In case it wasn't possible pointing several IDs to the same image, I've also tried the same file with two images & two ID's; one for each and get the same error) I've tried both with and without a space between the comma and the image name. The 18.05 version I tested this on was a local installation where we're planning on migrating our whole database. Presently, we're testing a copy of the same database we have at 3.16 and checked that the IDs mentioned above do exist. The error in my intranet.error.log says the same in both installs. [Mon Feb 04 09:50:44.648135 2019] [http:error] [pid 28363] [client] AH02429: Response header name ' inflating' contains invalid characters, aborting request, referer: /cgi-bin/koha/tools/upload-cover-image.pl Thanks a lot for your feedback! Regards, Date: Sat, 2 Feb 2019 13:56:42 +0100 > From: Katrin Fischer <katrin.fischer.83(a)web.de> > To: koha(a)lists.katipo.co.nz > Subject: Re: [Koha] Problem with batch cover image upload > Message-ID: <c34e96bd-b74a-7527-f621-6a2ac8da0ed7(a)web.de> > Content-Type: text/plain; charset=utf-8; format=flowed > > Hi Mai, > > just to make sure - are you trying to upload cover images or patron images? > > What kind of files includes your zip file and how are they named? > > 3.16 is really old by now. I would have suggested to test on a newer > version, but you said you already did on 18.05. Was that a local > installation one or one of the demos? > > Katrin > > On 29.01.19 15:37, Mai wrote: > > Dear all, > > I'm running Koha 16.11 on debian 3.16 and every time I attempt uploading > a > > .zip file with cover images and datalink.txt I get an error 500. > > An error has occurred!*Error 500*This message may have been caused by any > > of the following reasons: > > > > - You made use of an external link to an item that is no longer > available > > - You followed an outdated link e.g. from a search engine or a > bookmark > > - You tried to access a page that needs authentication > > - An internal link in the client is broken and the page does not > exist > > > > What's next? > > > > - Use top menu bar to navigate to another part of Koha. > > - To report a broken link or any other issue, please contact the Koha > > Administrator > > > > I've checked out Bug 20564 > > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20564> and > this > > thread > > < > http://koha.1045719.n5.nabble.com/Bulk-Patron-Image-upload-zip-file-giving-… > >. > > When I check my intranet error logs, I even get the same but still, I > don't > > understand how to fix this. I've also tried it on Koha 18.05 with the > same > > outcome. > > Can anybody help me? > > Thank you all in advance. > > > -- Maite

2 1

koha-US meeting invite: Wednesday, February 13th, 2019
by koha-US Secretary 08 Feb '19

08 Feb '19

Date: Wednesday, February 13th, 2019 Time: 10:30 AM - 11:30 AM CST (time converter <https://www.timeanddate.com/worldclock/fixedtime.html?msg=koha-US+February+…> ) Location: https://kslib.zoom.us/j/110290143 Agenda: *https://docs.google.com/document/d/1qhCWpU2o76jOGEk8UGIMG6buXX49ETtbApcfAlJYuVk/edit?usp=sharing <https://docs.google.com/document/d/1qhCWpU2o76jOGEk8UGIMG6buXX49ETtbApcfAlJ…>* This month, we're looking at an update to the committees section of the bylaws. Members should review this document prior to the meeting. Changes are red, additions are yellow: https://docs.google.com/document/d/1qTHKr-BF2QPD0UdYW8IupQP2KlN_Zev2D6YTv2f… We will also have reports from various committees and time to discuss bugs, issues, and general Koha questions. If you have specific topics for the agenda, please send them to secretary(a)koha-us.org Meetings are held via Zoom video conferencing. A microphone and webcam are recommended but not required. Zoom is available for Windows, Mac, and Linux on desktops and Android and iOS on mobile devices. For help getting started, visit: *https://support.zoom.us/hc/en-us/categories/200101697 <https://support.zoom.us/hc/en-us/categories/200101697>* These meetings are free and open to any and all. Jason Robb koha-US secretary secretary(a)koha-us.org

1 0

Re: [Koha] Report Checked out and Checked in report with school class and section
by Ashok Francis 08 Feb '19

08 Feb '19

Thank you so much MAMSET LIBRARY. It works well. Great work. On Fri, Feb 8, 2019 at 9:14 AM MAMCET Library <mamcet.library10(a)gmail.com> wrote: > Report form Checked out > Report SQL: > > SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date, > DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date, > p.cardnumber AS Card_No, > p.firstname AS First_Name, > p.surname AS Last_Name, > p.borrowernotes AS Class_section , > p.Categorycode AS Category, > i.barcode AS Barcode, > b.title AS Title, > b.author AS Author, > p.branchcode AS Library > > FROM issues c > LEFT JOIN items i ON (c.itemnumber=i.itemnumber) > LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber) > LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) > WHERE c.issuedate > BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> > ORDER BY c.issuedate DESC > > On Fri, Feb 8, 2019 at 9:02 AM MAMCET Library <mamcet.library10(a)gmail.com> > wrote: > >> Report Checked in report >> >> SELECT old_issues.Returndate, >> borrowers.Cardnumber AS Card_No, >> borrowers.Surname AS Name, >> borrowers.borrowernotes AS Class, >> borrowers.Categorycode AS Category, >> items.Barcode AS Barcode, >> biblio.Title AS Title, >> biblio.Author AS Author >> >> FROM old_issues LEFT JOIN borrowers ON >> borrowers.borrowernumber=old_issues.borrowernumber >> LEFT JOIN items ON old_issues.itemnumber=items.itemnumber LEFT JOIN >> biblio ON items.biblionumber=biblio.biblionumber WHERE >> old_issues.returndate >> BETWEEN <<Between Date (yyyy-mm-dd)|date>> AND <<and (yyyy-mm-dd)|date>> >> ORDER BY old_issues.returndate DESC >> >> On Thu, Feb 7, 2019 at 1:12 PM Ashok Francis <ashokfrancis.tgs(a)gmail.com> >> wrote: >> >>> Dear All, >>> >>> I am running Koha 17.11.04.000 in Ubuntu at CBSE school. I have created >>> new >>> field Student class and section in Additional attributes and identifiers. >>> Every day we are taking circulation report "Date wise list of Checked out >>> Books" and also Checked in books. Is it possible to include student >>> class >>> and section in this report. It will be very useful for us. If it is >>> possible, can you please guide me? I will be thankful to you. >>> >>> Report SQL: >>> >>> SELECT DATE_FORMAT(c.issuedate, "%d %b %Y %h:%i %p") AS Issue_Date, >>> DATE_FORMAT(c.date_due, "%d %b %Y") AS Due_Date, >>> i.barcode AS Barcode, >>> b.title AS Title, >>> b.author AS Author, >>> p.cardnumber AS Card_No, >>> p.firstname AS First_Name, >>> p.surname AS Last_Name >>> FROM issues c >>> LEFT JOIN items i ON (c.itemnumber=i.itemnumber) >>> LEFT JOIN borrowers p ON (c.borrowernumber=p.borrowernumber) >>> LEFT JOIN biblio b ON (i.biblionumber=b.biblionumber) >>> WHERE c.issuedate >>> BETWEEN '2019-02-07' AND '2019-02-08' ORDER BY c.issuedate DESC >>> >>> >>> Thank you, >>> >>> Ashok Francis >>> >>> New Delhi >>> _______________________________________________ >>> Koha mailing list http://koha-community.org >>> Koha(a)lists.katipo.co.nz >>> https://lists.katipo.co.nz/mailman/listinfo/koha >>> >> >> >> -- >> Thanking you.. >> >> Librarian, >> MAMCET <http://mamcet.com/> >> Trichy-Chennai Trunk Road, >> Siruganur, Tiruchirappalli-621 105. >> >> > > -- > Thanking you.. > > Librarian, > MAMCET <http://mamcet.com/> > Trichy-Chennai Trunk Road, > Siruganur, Tiruchirappalli-621 105. > >

1 0