Re: [Koha] Import the MARC21 with Item details

2018-06-06 Thread Laxmi Lal Menaria
I'm able to import but when I go to edit item details the barcode field is blank. Without barcode I am not able to do circulation system. Get Outlook for iOS From: Indranil Das Gupta Sent: Wednesday, June 6, 2018 11:23:58 PM To: koha@lists

Re: [Koha] Help with funding the koha-community.org webserver (also short outage for Linode free upgrade!)

2018-06-06 Thread Liz Rea
Further to that, I do mostly keep the work on the website separate from the work I do for Catalyst. That excepts the occasional urgent apt or wordpress upgrade that has to happen during working hours, or urgent help requests from members of the community in relation to working with the website. I'

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-06 Thread Chris Cormack
Kia ora tātou Yay, so great to see how fast this was funded! Just a bit of background. After what happened in 2009 when we had a company in control of lots of our infrastructure, we decided to never let that happen again. Hence Liz running the www.koha-community.org site (rather than say Catalyst

Re: [Koha] Import the MARC21 with Item details

2018-06-06 Thread Indranil Das Gupta
Hi, One thing I can immediately see wrong with your records is that you have no 942 $c, which you really should. But that won't stop your records from being either staged or imported. By changing BR1 to CPL for 952 $a and $b and itype (942 $y) to BK, I could import all you records into 18.05 with

Re: [Koha] Import the MARC21 with Item details

2018-06-06 Thread SATISH
Hello, Hope this sample MARC record / example will help you. =LDR 02915nam 2200361Ia 4500 =008 180529sxx\||\||und|| =041 \\$aKannada =082 \\$a320.5 RAM =100 \\$aRamakrishna, H.T. =245 \\$aAdhunika Sarkaragalu$cHT Ramakrishna =260 \\$aTipatur$bLalitha Prkashana =300 \\

Re: [Koha] Import the MARC21 with Item details

2018-06-06 Thread Laxmi Lal Menaria
Shared link: https://www.amazon.com/clouddrive/share/jdltI5YoY66OTnJN8UGZ5YurvCcBSrETfX0juT0G2ub Get Outlook for iOS From: Laxmi Lal Menaria Sent: Wednesday, June 6, 2018 8:23:42 PM To: Michael Kuhn Cc: koha@lists.katipo.co.nz Subject: Re:

Re: [Koha] Variables in reports

2018-06-06 Thread Cab Vinton
> I assume that you were talking about the 'Runtime Variables' section of the > wiki: > > https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Variables Yup. > ... Nick, Jesse (pianohacker) and I have all played with this at one time or > another, and I think that our consensus was th

Re: [Koha] Koha - notices and slips: how to include total amount outstanding on a notice

2018-06-06 Thread Jonathan Druart
I do not think you can do that, accountlines are not passed when the notice is generated. You could take a look at the template toolkit syntax, something like [% patron.account.balance %] should display what you want. But this is a new feature and you will have to rewrite the whole template of th

Re: [Koha] Variables in reports

2018-06-06 Thread Barton Chittenden
Cab, I assume that you were talking about the 'Runtime Variables' section of the wiki: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Runtime_Variables ... Nick, Jesse (pianohacker) and I have all played with this at one time or another, and I think that our consensus was that trying t

Re: [Koha] Koha - notices and slips: how to include total amount outstanding on a notice

2018-06-06 Thread Walker-Headon, Niamh - Systems Librarian
Dear Jonathan, I am on 17.11. I have tried several different fields in an attempt to get the information I want into the notice, but to no avail. This is what I have so far: [notices and slips] <> <> <> <> <> <> <> Dear <> <>, Our records show that the following items on your Library acco

Re: [Koha] Import the MARC21 with Item details

2018-06-06 Thread Laxmi Lal Menaria
Please find attached sample 10 records file Let me know if any issue with the file. On Wed, Jun 6, 2018 at 6:34 PM, Michael Kuhn wrote: > Hi > > > Only one item type with code "ITEM001" > > > > and autoBarcode value is 'not generated automatically" > > If I understand right everything seems cor

[Koha] Variables in reports

2018-06-06 Thread Cab Vinton
Hi, All -- We have a report with the following WHERE clause: WHERE b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= dateaccessioned AND homebranch='KIMBALL') AND b.biblionumber IN (SELECT biblionumber FROM items WHERE DATE_SUB(CURDATE(),INTERVAL 3

Re: [Koha] Koha - notices and slips: how to include total amount outstanding on a notice

2018-06-06 Thread Jonathan Druart
Hello, Which version of Koha are you using? And which notices do you want to modify? IIRC longoverdue.pl only sends CHECKIN. Regards, Jonathan On Wed, 6 Jun 2018 at 07:41 Walker-Headon, Niamh - Systems Librarian < niamh.walker-hea...@it-tallaght.ie> wrote: > Dear Fellow Koha Users, > I was wond

Re: [Koha] SQL report with Comma Delimited Paramater

2018-06-06 Thread Barton Chittenden
This is not currently possible, but if you check the bywatersolutions github page, you can find a plugin called 'koha-plugin-reports-plus', or something similar (on mobile, or I'd link to it). That plugin will allow you to add a parameter that lets you enter a list. On Wed, Jun 6, 2018, 07:38 ksor

Re: [Koha] Import the MARC21 with Item details

2018-06-06 Thread Michael Kuhn
Hi > Only one item type with code "ITEM001" > > and autoBarcode value is 'not generated automatically" If I understand right everything seems correct now, but still you experience the problem. I have no further clues... (and I will be away until tomorrow evening). Maybe it will help if you s

[Koha] Sponsoring the Koha Community site server

2018-06-06 Thread مسعود محمد الشريف
Hi Liz, Thank you a million for sponsoring the Koha Community site all this time. I will be very happy to help too. A cost sheet per year for hosting, running the site, and for maintaining the Koha portal content, etc. will help contributors decide on the period of sponsoring the site for. Th

Re: [Koha] Import the MARC21 with Item details

2018-06-06 Thread Laxmi Lal Menaria
Only one item type with code "ITEM001" and autoBarcode value is 'not generated automatically" Thanks, Laxmi Lal On Mon, Jun 4, 2018 at 8:45 PM, Michael Kuhn wrote: > Hi > > > I can see $a and $b values only, others are blank. > > Have you definded a media type with Code "ITEM001" in Koha menu

[Koha] SQL report with Comma Delimited Paramater

2018-06-06 Thread ksorbo
Is it possible to create a SQL report using a parameter with comma delimited ids? Specifically I would like to be able to select random, non-contiguous items. The following sql statement works when called directly from mysql: *select * from items where barcode in (3456,2346);* However, when I cr

[Koha] Koha - notices and slips: how to include total amount outstanding on a notice

2018-06-06 Thread Walker-Headon, Niamh - Systems Librarian
Dear Fellow Koha Users, I was wondering if anyone has managed to figure out how to include the total amount outstanding in a notice. In our case we do not charge fines, but once an item is subjected to the 'longoverdue.pl' process the replacement cost of the item is added to the patrons' account

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-06 Thread Liz Rea
Victory, everyone! Goal achieved and the website is golden for another year! Thank you all so much <3 The Koha community is truly awesome. Now... To go freshen up that website :D Cheers, Liz On Wed, 6 Jun 2018, 20:39 Narcis Garcia, wrote: > It's time to propose a better alternative for send

Re: [Koha] Help with funding the koha-community.org webserver

2018-06-06 Thread Narcis Garcia
It's time to propose a better alternative for sending money: https://en.wikipedia.org/wiki/List_of_online_payment_service_providers El 06/06/18 a les 07:54, Michael Kuhn ha escrit: > Hi Liz > >> I have set up a ko-fi at https://ko-fi.com/lizrea and you can >> contribute there > > Sorry, but I d