[Koha] Blocking users...
Hi all, We are using KOHA but we have a problem. KOHA, prohibits those who returned late. How do I disarm it? Koha directories do not have enough information about it. - Patron has had overdue items and is blocked for 21 day (s). (We use the version of Koha 3.0609000). Thank you. S. Armagan IGU Libraries ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Blocking users...
Hi, make sure that you haven't defined 'fines in days' in your circulation rules in the administration module. Hope that helps, Katrin > -Original Message- > From: koha-boun...@lists.katipo.co.nz [mailto:koha- > boun...@lists.katipo.co.nz] On Behalf Of A. Senol Armagan > Sent: Wednesday, November 21, 2012 9:27 AM > To: Koha@lists.katipo.co.nz > Subject: [Koha] Blocking users... > > Hi all, > > We are using KOHA but we have a problem. KOHA, prohibits those who > returned late. How do I disarm it? Koha directories do not have enough > information about it. > > > - Patron has had overdue items and is blocked for 21 day (s). > > > > (We use the version of Koha 3.0609000). > > > Thank you. > > > S. Armagan > > IGU Libraries > ___ > Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Blocking users...
Sounds like you have suspensions enabled. Check your "Circulation and fines rules" and look for the column "Suspension in days (day)". Anything other than a 0 in there will be blocking your patrons Jonathan On 21 November 2012 08:27, A. Şenol Armağan wrote: > > Hi all, > > We are using KOHA but we have a problem. KOHA, prohibits those who returned > late. How do I disarm it? Koha directories do not have enough information > about > it. > > > - Patron has had overdue items and is blocked for 21 day (s). > > > > (We use the version of Koha 3.0609000). > > > Thank you. > > > S. Armagan > > IGU Libraries > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Blocking users...
> > Sounds like you have suspensions enabled. Check your "Circulation and > fines rules" and look for the column "Suspension in days (day)". > Anything other than a 0 in there will be blocking your patrons > The settings for Circulation and Fine Rules are covered in the manual at: http://manual.koha-community.org/3.6/en/patscirc.html#circfinerules ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Blocking users...
I tried that. For example, undergraduate students marked as 0. I tried to borrow again. It did not work. (I wonder, after returning all books should have tried do?) If you think the book has already lent active settings, will you? 2012/11/21 Jonathan Field > Sounds like you have suspensions enabled. Check your "Circulation and > fines rules" and look for the column "Suspension in days (day)". > Anything other than a 0 in there will be blocking your patrons > Jonathan > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] ldap / uid
Hi, I've a technical question about ldap. My connexion with the ldap is enabled. The mapping is correct but we would like to use "SupannAliasLogin" instead of "uid". Why? Our uid is like this [year of entry in the school]+supannAliasLogin example:2012desseauxs 2012:year of entry in the school desseauxs:SupannAliasLogin I don't know how to do and i i have to change the principal name Actually, we have the following configuration *** ou=people,dc=ecp,dc=fr cn=syncrepl,ou=applications,dc=ecp,dc=fr ** 1 1 1 uid=%s,ou=people,dc=ecp,dc=fr Ecole Centrale Paris Chatenay-Malabry 92290 ECAM employee 903-566-7654 2012-09-01 2013-09-01 Many thanks samuel ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] How to check zebra server status?
Dear Friends, How to check Zebra server is running or not? Regards, -- Vimal Kumar V. Mahatma Gandhi University Library Kottayam, Kerala- 686 560 Web: http://www.vimalkumar.org Blog: http://linuxhalwa.blogspot.com http://kohageek.blogspot.in --- "I forget what I was taught. I only remember what I have learnt" -Patrick White ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-devel] ldap / uid
Samuel, If you want to map the userid field in Koha to "SupannAliasLogin" from your ldap configuration simply change to . If you are asking how to bind on SupannAliasLogin you should be able to perform the step above and in the principal name field just enter %s and nothing else. That will try and bind on the username without joining any other strings. Best, Travis Elliott Davis Development Support Specialist 903.571.4257 elli...@bywatersolutions.com On Nov 21, 2012, at 3:34 AM, Samuel Desseaux wrote: > Hi, > > I've a technical question about ldap. > > My connexion with the ldap is enabled. The mapping is correct but we would > like to use "SupannAliasLogin" instead of "uid". > Why? Our uid is like this [year of entry in the school]+supannAliasLogin > > example:2012desseauxs > > 2012:year of entry in the school > desseauxs:SupannAliasLogin > > > I don't know how to do and i i have to change the principal name > > Actually, we have the following configuration > > > *** > ou=people,dc=ecp,dc=fr > cn=syncrepl,ou=applications,dc=ecp,dc=fr > ** > 1 > 1 > 1 > uid=%s,ou=people,dc=ecp,dc=fr > > > > Ecole Centrale Paris > Chatenay-Malabry > 92290 > ECAM > > > > > employee > 903-566-7654 > 2012-09-01 > 2013-09-01 > > > > > Many thanks > > samuel > > > > > ___ > Koha-devel mailing list > koha-de...@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/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problem in importing Patron Records
Here's what I'm getting (in 3.08.05): Feedback: Parsing upload file Patron upload test2.csv Content-Type : application/octet-stream Content-Disposition : form-data; name="uploadborrowers"; filename="Patron upload test2.csv" headerrow : CARDNUMBER, SURNAME, FIRSTNAME, TITLE, INITIALS, ADDRESS, ADDRESS2, CITY, ZIPCODE, COUNTRY, EMAIL, PHONE, BRANCHCODE, CATEGORYCODE, DATEEXPIRY Error analysis: Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF). Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). It's all there. Is Koha expecting the fields in a particular order? I'm supplying the header row (above). But it's not connecting the two somehow. I have tried with and without quotes around the fields, neither seems to work. Elaine On Wed, Nov 21, 2012 at 8:22 PM, Elaine Bradtke wrote: > Are you saying there should be quotes around the fields? > Because I'm getting similar failures and the fields are there, but > it's not seeing them. > Elaine > > On Tue, Nov 20, 2012 at 9:45 PM, Quoc Uy wrote: >> First, i have problem with this, too. I downloaded original file >> patron_import.csv, opened it with Libreoffice Calc, watched table borrowers >> in database by Phpmyadmin. Then i tried to fill all file with the similar >> values as what i did before (add patron manual). Next i saved file as .csv >> file, and tried import patron. I failed with message: "Line 2 Critical field >> "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... >> Next i tried to change fomats all fields in their fomats (text, number, >> date), esspecially date YYY-MM-DD. Then i saved file as .csv file, and tried >> import patron. I failed with message: "Line 2 Critical field >> "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... (same error) >> I saved .csv file as .ods file, and tried import, once more time fail. >> >> Last time, maybe i was lucky, i use that.ods file, saved as .csv file, >> then i received a message: >> >> Export text file... >> >> field delimiter , >> text delimiter " >> I press Ok, then saved. And i imported patrons without error. >> I don't understand it very clear, but just wanna share experience. Hope it >> can help someone else. >> ___ >> Koha mailing list http://koha-community.org >> Koha@lists.katipo.co.nz >> http://lists.katipo.co.nz/mailman/listinfo/koha > > > > -- > Elaine Bradtke > Data Wrangler > VWML > English Folk Dance and Song Society | http://www.efdss.org > Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY > Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance > and Song Society in London, England. If you wish to phone me > personally, send an e-mail first. I work off site) > -- > Registered Company No. 297142 > Charity Registered in England and Wales No. 305999 > --- > "Writing about music is like dancing about architecture" > --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problem in importing Patron Records
I have to set up a system to convert information from our membership list into patron files on a monthly basis to catch expired memberships. I run the file through a database called Cardbox for batch editing. Cardbox exports have never cause any problems with csv formatting before. As an experiment, I ran the Cardbox csv file through (an old version of) excel and exported a new csv file. But it didn't help, and in fact broke the date formatting (deleting the zero padding). We are using the same date format as is set in our system preferences (dd/mm/). For some patrons there is no expiration date (life members). Would this be a problem - are expiration dates required? Must I convert it to -mm-dd ? (the notes on patron import seem to imply it's OK to use your specified date format). Elaine On Wed, Nov 21, 2012 at 8:36 PM, Uy nguyễn quốc wrote: > So u have the same error as i had. I'm using Koha on Ubuntu. If u try to open > file with excel in windows, then save file as .csv, then import, i think > there is no error more. If u use in ubuntu, or debian, should follow what i > said before. Open .csv file with Libre Calc (it may ask for default- > seperated by semicolon and comma, choose those values), then fill it, save as > .ods file, then open .ods file, save as new .csv file. U can import this .csv > file. Good luck > On 22 Nov 2012, at 00:30, Elaine Bradtke wrote: > >> Here's what I'm getting (in 3.08.05): >> Feedback: >> >> Parsing upload file Patron upload test2.csv >> Content-Type : application/octet-stream >> Content-Disposition : form-data; name="uploadborrowers"; >> filename="Patron upload test2.csv" >> headerrow : CARDNUMBER, SURNAME, FIRSTNAME, TITLE, INITIALS, ADDRESS, >> ADDRESS2, CITY, ZIPCODE, COUNTRY, EMAIL, PHONE, BRANCHCODE, >> CATEGORYCODE, DATEEXPIRY >> >> >> Error analysis: >> >> Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: >> UNDEF). >> Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; >> surname: UNDEF). >> Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; >> surname: UNDEF). >> >> It's all there. >> Is Koha expecting the fields in a particular order? I'm supplying the >> header row (above). But it's not connecting the two somehow. I have >> tried with and without quotes around the fields, neither seems to >> work. >> Elaine >> >> On Wed, Nov 21, 2012 at 8:22 PM, Elaine Bradtke wrote: >>> Are you saying there should be quotes around the fields? >>> Because I'm getting similar failures and the fields are there, but >>> it's not seeing them. >>> Elaine >>> >>> On Tue, Nov 20, 2012 at 9:45 PM, Quoc Uy >>> wrote: First, i have problem with this, too. I downloaded original file patron_import.csv, opened it with Libreoffice Calc, watched table borrowers in database by Phpmyadmin. Then i tried to fill all file with the similar values as what i did before (add patron manual). Next i saved file as .csv file, and tried import patron. I failed with message: "Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... Next i tried to change fomats all fields in their fomats (text, number, date), esspecially date YYY-MM-DD. Then i saved file as .csv file, and tried import patron. I failed with message: "Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... (same error) I saved .csv file as .ods file, and tried import, once more time fail. Last time, maybe i was lucky, i use that.ods file, saved as .csv file, then i received a message: Export text file... field delimiter , text delimiter " I press Ok, then saved. And i imported patrons without error. I don't understand it very clear, but just wanna share experience. Hope it can help someone else. ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha >>> >>> >>> >>> -- >>> Elaine Bradtke >>> Data Wrangler >>> VWML >>> English Folk Dance and Song Society | http://www.efdss.org >>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY >>> Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance >>> and Song Society in London, England. If you wish to phone me >>> personally, send an e-mail first. I work off site) >>> -- >>> Registered Company No. 297142 >>> Charity Registered in England and Wales No. 305999 >>> --- >>> "Writing about music is like dancing about architecture" >>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >> >> >> >> -- >> Elaine Bradtke >> Data Wrangler >> VWML >> English Folk Dance and Song Society | http://www.efdss.org >> Cecil Sharp House, 2 Regent's
Re: [Koha] K-12 Users
Dear Jeremy, For K-12 Koha is easy to use especially if you activate the opac enhancer and display book images and all those things.. students can relate their search very fast and even you can train senior students to use "Tags" and "Comments" option; student will love these feature. For any technical help please send email to sunil.ku...@ecoleglobal.com / i...@ecoleglobal.com Thanks and Regards R Sunil Kumar Library Technologist -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of koha-requ...@lists.katipo.co.nz Sent: 22 November 2012 10:07 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 85, Issue 36 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-requ...@lists.katipo.co.nz You can reach the person managing the list at koha-ow...@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: K-12 Users (Scott Owen) 2. Re: Problem in importing Patron Records (Sunil Kumar) -- Message: 1 Date: Wed, 21 Nov 2012 18:04:27 -0500 From: "Scott Owen" To: koha@lists.katipo.co.nz Subject: Re: [Koha] K-12 Users Message-ID: <50ad17aa.d5c1.000...@edzone.net> Content-Type: text/plain; charset=utf-8 We have been using Koha for 3-4? years. Works great.we currently use it in one 4-5 grade building, but plan on moving our HS and MS to it as well. http://koha.almaschools.net/ Almost no issues.every now and then I have to run a "rebuild" when biblios get deleted out of the database other than that.it's truly plug it and forget it (and I could probably CRON that rebuildbut I just never get around to it). Feel free to contact me off list if you would like. http://www.almaschools.net/district/technology/current-technology-staff/ >>> Jeremy Wellner 11/21/2012 2:34 PM >>> Hello! I am looking for some feedback from users who have Koha and are using it in a K12 environment. We are evaluating the option to see if it would be suitable for our environment. Any feedback at all would be welcome! Thanks! Jeremy Wellner Technology Group Stanwood-Camano School District jwell...@stanwood.wednet.edu Internal: x4357 External: 360-629-1205 Cell: 425-418-4972 ?We?re here to put a dent in the universe. Otherwise why else even be here?? -Steve Jobs ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha - No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2793 / Virus Database: 2629/5910 - Release Date: 11/21/12 -- Message: 2 Date: Thu, 22 Nov 2012 10:06:58 +0530 From: "Sunil Kumar" To: Subject: Re: [Koha] Problem in importing Patron Records Message-ID: <000301cdc86b$050a4f30$0f1eed90$@ku...@ecoleglobal.com> Content-Type: text/plain; charset="us-ascii" Dear Elaine Can you share the patron excel file and also check the under system configuration "BorrowerMandatoryField" which are the fields mandatory, for uploading purpose you can remove those mandatory fields and try uploading the patron records. Regarding the borrowernumber, What i used to do is manually enter the borrowernumber (use the excel feature of auto numbering). Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF). > If Surname is mandatory field and any one row is missing the surname data, Koha will show error. Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). - check the branchcode in the .CSV file and the branchcode you have defined in Koha, if both are not matching it will show error or if .CSV have a new branch code it will again show you error. Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). = same as branchcode error - you have not defined the catagorycode in the Koha setting. Thanks and Regards R Sunil Kumar Library Technologist -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of koha-requ...@lists.katipo.co.nz Sent: 22 November 2012 04:22 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 85, Issue 35 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-requ...@lists.katipo.co.nz You can reach the person managing the list at koha-ow...@lists.katipo.co.nz When replying, please edit your Subject line so it is more speci
Re: [Koha] How to check zebra server status?
Hi, How about: ps -C zebrasrv PID TTY TIME CMD 2491 ?00:00:00 zebrasrv This is in a Centos machine. For debian the process name might be different. Regard, Senthil On 22 November 2012 11:06, Vimal Kumar V. wrote: > Dear Friends, > > How to check Zebra server is running or not? > ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] K-12 Users
Hello! I am looking for some feedback from users who have Koha and are using it in a K12 environment. We are evaluating the option to see if it would be suitable for our environment. Any feedback at all would be welcome! Thanks! Jeremy Wellner Technology Group Stanwood-Camano School District jwell...@stanwood.wednet.edu Internal: x4357 External: 360-629-1205 Cell: 425-418-4972 “We’re here to put a dent in the universe. Otherwise why else even be here?” -Steve Jobs ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problem in importing Patron Records
Hi Elaine, I think it's not the date format that is a problem here. The date format should be what you have set in the dateformat system preference. I think your problem could be, that you are not providing a borrowernumber. I found in the past that the import works nicely providing a sequential borrowernumber for all my entries in the CSV file. Also maybe try to lower case your header row. It's only a guess as I haven't tested it, but maybe it makes a difference. Another idea is that you provide a anonymized sample file of your data, so we can take a look at the headerrow and 2 or more additional lines to help you find the problem. Hope this helps, Katrin -Original Message- From: koha-boun...@lists.katipo.co.nz on behalf of Elaine Bradtke Sent: Wed 21.11.2012 23:51 To: Quoc Uy Cc: koha Subject: Re: [Koha] Problem in importing Patron Records I changed the date format to -MM-DD I also added a date to the patron records that didn't have them. I saved it as an ods file, and then closed it opened it and saved it as csv. None of these things worked. Same error messages. Elaine On Wed, Nov 21, 2012 at 9:16 PM, Quoc Uy wrote: > Better give it a try. Do exactly as i say. Maybe change fotmat YYY-MM-DD. > Because u have same error as i did. > > > > From: Elaine Bradtke > To: Uy nguy?n qu?c > Cc: koha > Sent: Thursday, November 22, 2012 12:06 AM > Subject: Re: [Koha] Problem in importing Patron Records > > I have to set up a system to convert information from our membership > list into patron files on a monthly basis to catch expired > memberships. I run the file through a database called Cardbox for > batch editing. Cardbox exports have never cause any problems with csv > formatting before. > As an experiment, I ran the Cardbox csv file through (an old version > of) excel and exported a new csv file. But it didn't help, and in > fact broke the date formatting (deleting the zero padding). > > We are using the same date format as is set in our system preferences > (dd/mm/). For some patrons there is no expiration date (life > members). Would this be a problem - are expiration dates required? > Must I convert it to -mm-dd ? (the notes on patron import seem to > imply it's OK to use your specified date format). > Elaine > On Wed, Nov 21, 2012 at 8:36 PM, Uy nguy?n qu?c > wrote: >> So u have the same error as i had. I'm using Koha on Ubuntu. If u try to >> open file with excel in windows, then save file as .csv, then import, i >> think there is no error more. If u use in ubuntu, or debian, should follow >> what i said before. Open .csv file with Libre Calc (it may ask for default- >> seperated by semicolon and comma, choose those values), then fill it, save >> as .ods file, then open .ods file, save as new .csv file. U can import this >> .csv file. Good luck >> On 22 Nov 2012, at 00:30, Elaine Bradtke wrote: >> >>> Here's what I'm getting (in 3.08.05): >>> Feedback: >>> >>> Parsing upload file Patron upload test2.csv >>> Content-Type : application/octet-stream >>> Content-Disposition : form-data; name="uploadborrowers"; >>> filename="Patron upload test2.csv" >>> headerrow : CARDNUMBER, SURNAME, FIRSTNAME, TITLE, INITIALS, ADDRESS, >>> ADDRESS2, CITY, ZIPCODE, COUNTRY, EMAIL, PHONE, BRANCHCODE, >>> CATEGORYCODE, DATEEXPIRY >>> >>> >>> Error analysis: >>> >>> Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: >>> UNDEF). >>> Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; >>> surname: UNDEF). >>> Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; >>> surname: UNDEF). >>> >>> It's all there. >>> Is Koha expecting the fields in a particular order? I'm supplying the >>> header row (above). But it's not connecting the two somehow. I have >>> tried with and without quotes around the fields, neither seems to >>> work. >>> Elaine >>> >>> On Wed, Nov 21, 2012 at 8:22 PM, Elaine Bradtke wrote: Are you saying there should be quotes around the fields? Because I'm getting similar failures and the fields are there, but it's not seeing them. Elaine On Tue, Nov 20, 2012 at 9:45 PM, Quoc Uy wrote: >First, i have problem with this, too. I downloaded original file > patron_import.csv, opened it with Libreoffice Calc, watched table > borrowers > in database by Phpmyadmin. Then i tried to fill all file with the similar > values as what i did before (add patron manual). Next i saved file as .csv > file, and tried import patron. I failed with message: "Line 2 Critical > field > "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... >Next i tried to change fomats all fields in their fomats (text, > number, date), esspecially date YYY-MM-DD. Then i saved file as .csv file, > and tried import patron. I failed with message: "Line 2 Critical field > "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... (same
Re: [Koha] Problem in importing Patron Records
Are you saying there should be quotes around the fields? Because I'm getting similar failures and the fields are there, but it's not seeing them. Elaine On Tue, Nov 20, 2012 at 9:45 PM, Quoc Uy wrote: > First, i have problem with this, too. I downloaded original file > patron_import.csv, opened it with Libreoffice Calc, watched table borrowers > in database by Phpmyadmin. Then i tried to fill all file with the similar > values as what i did before (add patron manual). Next i saved file as .csv > file, and tried import patron. I failed with message: "Line 2 Critical field > "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... > Next i tried to change fomats all fields in their fomats (text, number, > date), esspecially date YYY-MM-DD. Then i saved file as .csv file, and tried > import patron. I failed with message: "Line 2 Critical field > "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... (same error) > I saved .csv file as .ods file, and tried import, once more time fail. > > Last time, maybe i was lucky, i use that.ods file, saved as .csv file, > then i received a message: > > Export text file... > > field delimiter , > text delimiter " > I press Ok, then saved. And i imported patrons without error. > I don't understand it very clear, but just wanna share experience. Hope it > can help someone else. > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problem in importing Patron Records
Dear Elaine Can you share the patron excel file and also check the under system configuration "BorrowerMandatoryField" which are the fields mandatory, for uploading purpose you can remove those mandatory fields and try uploading the patron records. Regarding the borrowernumber, What i used to do is manually enter the borrowernumber (use the excel feature of auto numbering). Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF). > If Surname is mandatory field and any one row is missing the surname data, Koha will show error. Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). - check the branchcode in the .CSV file and the branchcode you have defined in Koha, if both are not matching it will show error or if .CSV have a new branch code it will again show you error. Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). = same as branchcode error - you have not defined the catagorycode in the Koha setting. Thanks and Regards R Sunil Kumar Library Technologist -Original Message- From: koha-boun...@lists.katipo.co.nz [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of koha-requ...@lists.katipo.co.nz Sent: 22 November 2012 04:22 To: koha@lists.katipo.co.nz Subject: Koha Digest, Vol 85, Issue 35 Send Koha mailing list submissions to koha@lists.katipo.co.nz To subscribe or unsubscribe via the World Wide Web, visit http://lists.katipo.co.nz/mailman/listinfo/koha or, via email, send a message with subject or body 'help' to koha-requ...@lists.katipo.co.nz You can reach the person managing the list at koha-ow...@lists.katipo.co.nz When replying, please edit your Subject line so it is more specific than "Re: Contents of Koha digest..." Today's Topics: 1. Re: Problem in importing Patron Records (Elaine Bradtke) 2. Re: Problem in importing Patron Records (Elaine Bradtke) 3. Re: [Koha-devel] ldap / uid (Travis Elliott Davis) 4. Re: Problem in importing Patron Records (Elaine Bradtke) 5. Re: Problem in importing Patron Records (Elaine Bradtke) -- Message: 1 Date: Wed, 21 Nov 2012 20:22:18 + From: Elaine Bradtke To: Quoc Uy Cc: "koha@lists.katipo.co.nz" Subject: Re: [Koha] Problem in importing Patron Records Message-ID: Content-Type: text/plain; charset=ISO-8859-1 Are you saying there should be quotes around the fields? Because I'm getting similar failures and the fields are there, but it's not seeing them. Elaine On Tue, Nov 20, 2012 at 9:45 PM, Quoc Uy wrote: > First, i have problem with this, too. I downloaded original file patron_import.csv, opened it with Libreoffice Calc, watched table borrowers in database by Phpmyadmin. Then i tried to fill all file with the similar values as what i did before (add patron manual). Next i saved file as .csv file, and tried import patron. I failed with message: "Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... > Next i tried to change fomats all fields in their fomats (text, > number, date), esspecially date YYY-MM-DD. Then i saved file as .csv file, and tried import patron. I failed with message: "Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... (same error) > I saved .csv file as .ods file, and tried import, once more time fail. > > Last time, maybe i was lucky, i use that.ods file, saved as .csv file, then i received a message: > > Export text file... > > field delimiter , > text delimiter " > I press Ok, then saved. And i imported patrons without error. > I don't understand it very clear, but just wanna share experience. Hope it can help someone else. > ___ > Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) -- Message: 2 Date: Wed, 21 Nov 2012 20:30:42 + From: Elaine Bradtke To: Quoc Uy Cc: "koha@lists.katipo.co.nz" Subject: Re: [Koha] Problem in importing Patron Records Message-ID: Content-Type: text/plain; charset=ISO-8859-1 Here's what I'm getting (in 3.08.05): Feedback: Parsing upload file Pat
Re: [Koha] K-12 Users
We have been using Koha for 3-4? years. Works great.we currently use it in one 4-5 grade building, but plan on moving our HS and MS to it as well. http://koha.almaschools.net/ Almost no issues.every now and then I have to run a "rebuild" when biblios get deleted out of the database other than that.it's truly plug it and forget it (and I could probably CRON that rebuildbut I just never get around to it). Feel free to contact me off list if you would like. http://www.almaschools.net/district/technology/current-technology-staff/ >>> Jeremy Wellner 11/21/2012 2:34 PM >>> Hello! I am looking for some feedback from users who have Koha and are using it in a K12 environment. We are evaluating the option to see if it would be suitable for our environment. Any feedback at all would be welcome! Thanks! Jeremy Wellner Technology Group Stanwood-Camano School District jwell...@stanwood.wednet.edu Internal: x4357 External: 360-629-1205 Cell: 425-418-4972 “We’re here to put a dent in the universe. Otherwise why else even be here?” -Steve Jobs ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha - No virus found in this message. Checked by AVG - www.avg.com Version: 2013.0.2793 / Virus Database: 2629/5910 - Release Date: 11/21/12 ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Problem in importing Patron Records
I changed the date format to -MM-DD I also added a date to the patron records that didn't have them. I saved it as an ods file, and then closed it opened it and saved it as csv. None of these things worked. Same error messages. Elaine On Wed, Nov 21, 2012 at 9:16 PM, Quoc Uy wrote: > Better give it a try. Do exactly as i say. Maybe change fotmat YYY-MM-DD. > Because u have same error as i did. > > > > From: Elaine Bradtke > To: Uy nguyễn quốc > Cc: koha > Sent: Thursday, November 22, 2012 12:06 AM > Subject: Re: [Koha] Problem in importing Patron Records > > I have to set up a system to convert information from our membership > list into patron files on a monthly basis to catch expired > memberships. I run the file through a database called Cardbox for > batch editing. Cardbox exports have never cause any problems with csv > formatting before. > As an experiment, I ran the Cardbox csv file through (an old version > of) excel and exported a new csv file. But it didn't help, and in > fact broke the date formatting (deleting the zero padding). > > We are using the same date format as is set in our system preferences > (dd/mm/). For some patrons there is no expiration date (life > members). Would this be a problem - are expiration dates required? > Must I convert it to -mm-dd ? (the notes on patron import seem to > imply it's OK to use your specified date format). > Elaine > On Wed, Nov 21, 2012 at 8:36 PM, Uy nguyễn quốc > wrote: >> So u have the same error as i had. I'm using Koha on Ubuntu. If u try to >> open file with excel in windows, then save file as .csv, then import, i >> think there is no error more. If u use in ubuntu, or debian, should follow >> what i said before. Open .csv file with Libre Calc (it may ask for default- >> seperated by semicolon and comma, choose those values), then fill it, save >> as .ods file, then open .ods file, save as new .csv file. U can import this >> .csv file. Good luck >> On 22 Nov 2012, at 00:30, Elaine Bradtke wrote: >> >>> Here's what I'm getting (in 3.08.05): >>> Feedback: >>> >>> Parsing upload file Patron upload test2.csv >>> Content-Type : application/octet-stream >>> Content-Disposition : form-data; name="uploadborrowers"; >>> filename="Patron upload test2.csv" >>> headerrow : CARDNUMBER, SURNAME, FIRSTNAME, TITLE, INITIALS, ADDRESS, >>> ADDRESS2, CITY, ZIPCODE, COUNTRY, EMAIL, PHONE, BRANCHCODE, >>> CATEGORYCODE, DATEEXPIRY >>> >>> >>> Error analysis: >>> >>> Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname: >>> UNDEF). >>> Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; >>> surname: UNDEF). >>> Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; >>> surname: UNDEF). >>> >>> It's all there. >>> Is Koha expecting the fields in a particular order? I'm supplying the >>> header row (above). But it's not connecting the two somehow. I have >>> tried with and without quotes around the fields, neither seems to >>> work. >>> Elaine >>> >>> On Wed, Nov 21, 2012 at 8:22 PM, Elaine Bradtke wrote: Are you saying there should be quotes around the fields? Because I'm getting similar failures and the fields are there, but it's not seeing them. Elaine On Tue, Nov 20, 2012 at 9:45 PM, Quoc Uy wrote: >First, i have problem with this, too. I downloaded original file > patron_import.csv, opened it with Libreoffice Calc, watched table > borrowers > in database by Phpmyadmin. Then i tried to fill all file with the similar > values as what i did before (add patron manual). Next i saved file as .csv > file, and tried import patron. I failed with message: "Line 2 Critical > field > "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... >Next i tried to change fomats all fields in their fomats (text, > number, date), esspecially date YYY-MM-DD. Then i saved file as .csv file, > and tried import patron. I failed with message: "Line 2 Critical field > "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... (same > error) >I saved .csv file as .ods file, and tried import, once more time > fail. > >Last time, maybe i was lucky, i use that.ods file, saved as .csv > file, then i received a message: > > Export text file... > > field delimiter , > text delimiter " > I press Ok, then saved. And i imported patrons without error. > I don't understand it very clear, but just wanna share experience. Hope > it can help someone else. > ___ > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel
[Koha] Koha 3.8.7 released
The Koha team is proud to announce the release of Koha 3.8.7, this is a maintenance release. IMPORTANT NOTE If you are using DOM indexing, you must do a full reindex after upgrading or you will into a lot of problems. RELEASE NOTES FOR KOHA 3.8.7 22 Nov 2012 Koha is the first free and open source software library automation package (ILS). Development is sponsored by libraries of varying types and sizes, volunteers, and support companies from around the world. The website for the Koha project is http://koha-community.org/ Koha 3.8.7 can be downloaded from: http://download.koha-community.org/koha-3.08.07.tar.gz Installation instructions can be found at: http://wiki.koha-community.org/wiki/Installation_Documentation OR in the INSTALL files that come in the tarball Koha 3.8.7 is a bugfix/maintenance release. Major fixes in 3.8.7 == Acquisitions -- 7921 major Software error while placing order Architecture, internals, and plumbing -- 9085 major Installer will not run with DEBUG set Cataloging -- 8665 critical DOM indexing fails to index some bib records Circulation -- 8253 critical fix fine doubling, when upgrading from 3.6 to 3.8 (or later) 8966 critical Koha::Calendar::is_holiday truncates the date 8213 major "Cancel All" button on holds over tab cancels both holds over and holds waiting 8939 major Fines Charged During Grace Period OPAC -- 8953 critical opac-userupdate encoding issues Searching -- 8805 major Add a biblio-zebra-indexdefs.xsl for NORMARC Templates -- 3652 critical XSS vulnerabilities Bugs fixed in 3.8.7 == About -- 8910 minor silent warnings triggered in about.pl Architecture, internals, and plumbing -- 8804 normal Quiet errors in the log from Auth.pm Authentication -- 8787 minor If OpacMaintenance is on the requested page is loaded Cataloging -- 8823 normal CatalogModuleRelink Creates Multiple Links between Bib and Auth record ($9 RLIN) 8862 normal merge.pl contains untranslatable strings Circulation -- 8834 normal Call to C4::Context::preference fails to pass $self in Circulation.pm 8841 normal Duedates set by Returnbeforeexpiry lack HH:MM 8234 minor Dates are not well sorted on Transfers to receive 8826 minor Initialization of hash triggers error log entries. Documentation -- 8568 minor Fix some errors in docs for scripts provided by the Debian packages I18N/L10N -- 8872 minor Improve encoding for xslt files, showmarc and opac-showmarc Installation and upgrade (command-line installer) -- 8749 trivial Missing Ubuntu library files in ubuntu.packages and ubuntu.12.04.packages Installation and upgrade (web-based installer) -- 9058 normal Norwegian default for CalendarFirstDayOfWeek OPAC -- 8792 normal Babeltheque tab is useless normal question marks in series title facet links 8941 normal Make title display properly for NORMARC OPAC detail view 8973 normal HTML and URL escape missing in OPAC templates 8936 minor Search RSS feeds does not show there items when subscribing in Firefox 8988 minor item status uses authorized value description for intranet Reports -- 8987 normal "New report button" broken Searching -- 8958 normal Facets are not fully UNIMARC compliant Staff Client -- 8996 normal In result page items with negative notforloan are available System Administration -- 4177 normal opaccloud missing from the system preferences interface 8907 minor Last updated date does not appear on currency edit form 8849 trivial Error log generated when not a demo system Templates -- 8898 minor Remove unused mainmenu include and related styles in the staff client 8912 minor Remove unused hold-menu.inc translate.koha-community.org -- 8968 normal JavaScript String not translatable Enhancements in 3.8.7 == Lists -- 7805 Exposing the new list permissions in opac and staff System requirements == Important notes: * Perl 5.10 is required * Zebra is required Documentation == As of Koha 3.2, the Koha manual is now maintained in DocBook. The home page for Koha documentation is http://koha-community.org/documentation/ As of the date of these release notes, only the English version of the Koha manual is available: http://manual.koha-community.org/3.8.7/en/ The Git repository for the Koha manual can be found at http://git.koha-community.org/gitweb/?p=kohadocs.git;a=summary Translations == Complete or near-complete translations of the OPAC and staff interface are available in this release for the following languages: * English (USA) * Arabic (99%) * Armenian (100%) * Basque (76%) * Chinese (Taiwan) (76%) * Danish (75%) * En