- Koha - lists.katipo.co.nz

Koha 3.8.7 released
by Chris Cormack 23 Nov '12

23 Nov '12

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 8888 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%) * English (New Zealand) (100%) * French (100%) * French (Canada) (76%) * German (100%) * German (Switzerland) (99%) * Greek (68%) * Italian (100%) * Norwegian BokmÃ¥l (68%) * Portuguese (Brazil) (99%) * Slovak (100%) * Spanish (100%) * Turkish (100%) Partial translations are available for various other languages. The Koha team welcomes additional translations; please see http://wiki.koha-community.org/wiki/Translating_Koha for information about translating Koha, and join the koha-translate list to volunteer: http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-translate The most up-to-date translations can be found at: http://translate.koha-community.org/ Release Team ====================== The release team for Koha 3.8.7 is Release Manager: Paul Poulain <paul.poulain(a)biblibre.com> Documentation Manager: Nicole C Engard <nengard(a)gmail.com> Translation Manager: FrÃ©dÃ©ric Demians <frederic(a)tamil.fr> QA Manager: Ian Walls <koha.sekjal(a)gmail.com> QA team: Marcel de Rooy <M.de.Rooy(a)rijksmuseum.nl>, Jonathan Druart <jonathan.druart(a)biblibre.com> Mason James <mason(a)kohaaloha.com> Bug Wranglers: Katrin Fischer, Magnus Enger Release Maintainer (3.4.x): Chris Nighswonger <cnighswonger(a)foundations.edu> Release Maintainer (3.6.x): Jared Camins-Esakov <jcamins(a)cpbibliography.com> Release Maintainer (3.8.x): Chris Cormack <chrisc(a)catalyst.net.nz> Credits ====================== We thank the following libraries who are known to have sponsored new features in Koha 3.8.7: We thank the following individuals who contributed patches to Koha 3.8.7. * 3 Jared Camins-Esakov * 1 Colin Campbell * 2 Chris Cormack * 1 FrÃ©dÃ©ric Demians * 2 Jonathan Druart * 4 Magnus Enger * 3 Kyle M Hall * 1 Mason James * 4 Owen Leonard * 1 Chris Nighswonger * 1 Dobrica Pavlinusic * 1 Maxime Pelletier * 2 Paul Poulain * 6 Marcel de Rooy * 5 Fridolyn SOMERS * 1 Mathieu Saby * 1 Adrien Saurat * 1 Lyon3 Team * 1 Mirko Tietgen * 5 Mark Tompsett * 1 Robert Williams We thank the following companies who contributed patches to Koha 3.8.7 * 4 ACPL * 1 Amigos Library Services * 10 Biblibre * 3 ByWater-Solutions * 3 C & P Bibliography * 2 Catalyst * 1 Foundations * 1 KohaAloha * 1 Libeo * 4 Libriotech * 1 PTFS-Europe * 6 Rijksmuseum * 1 Tamil * 1 UniversitÃ© Jean Moulin Lyon 3 * 1 UniversitÃ© Rennes 2 * 1 abunchofthings.net * 1 rot13.org * 5 unidentified We also especially thank the following individuals who tested patches for Koha 3.8.7. * 2 Tomas Cohen Arazi * 19 Jared Camins-Esakov * 50 Chris Cormack * 2 Elliott Davis * 3 FrÃ©dÃ©ric Demians * 1 Katrin Fischer * 6 Kyle M Hall * 5 Owen Leonard * 1 Julian Maurice * 3 Melia Meggs * 26 Paul Poulain * 2 Mirko Tietgen * 2 Marc Veron * 3 wajasu We regret any omissions. If a contributor has been inadvertantly missed, please send a patch against these release notes to koha-patches(a)lists.koha-community.org. Revision control notes ====================== The Koha project uses Git for version control. The current development version of Koha can be retrieved by checking out the master branch of git://git.koha-community.org/koha.git The branch for this version of Koha and future bugfixes in this release line is 3.8.x. The last Koha release was 3.8.6, which was released on October 22, 2012. Bugs and feature requests ====================== Bug reports and feature requests can be filed at the Koha bug tracker at http://bugs.koha-community.org/ Ehara taku toa i te toa takitahi, engari he toa takitini

4 3

MySQL to update dateaccessioned
by Paul 23 Nov '12

23 Nov '12

I am trying to update a bunch of various dates to 31 Dec. The following appears to be syntactically OK, finds all 1302 to be changed, but does not change them to 31 Dec. mysql> UPDATE items -> SET items.dateaccessioned=REPLACE(items.dateaccessioned,'%','2011-12-31') -> WHERE blah blah blah; Query OK, 0 rows affected (0.04 sec) Rows matched: 1302 Changed: 0 Warnings: 0 Help really appreciated ... Many thanks - Paul

2 2

504 Gateway Timeout while installing
by Ben 22 Nov '12

22 Nov '12

When I got to install in the web I get to step 3 and click next, It creates 140 tables and shows up with a Gateway Timeout error. How do I get around this? > -- > Ben CONFIDENTIALITY STATEMENT All information in this document is classified. Access is restricted to personnel with level 6 access or higher. Any unauthorized use or duplication of this document, or revealing any of the information contained with in this document to Dominion enemies, is punishable by immediate death for the individual(s) involved in compromising Dominion security.

2 1

Set principal language
by Vitor Fernandes 22 Nov '12

22 Nov '12

Hi there. I've a Koha installation with portuguese and english languages installed, but by default the OPAC and Staff Client appears in english and then it's possible to change to Portuguese. There is anyway to set the default language of Koha? I want that OPAC and Staff Client appears in Portuguese and then can change to English. Regards. Vitor Fernandes

4 6

Re: [Koha] Problem in importing Patron Records
by Elaine Bradtke 22 Nov '12

22 Nov '12

On Thu, Nov 22, 2012 at 4:36 AM, Sunil Kumar <sunil.kumar(a)ecoleglobal.com> wrote: > Dear Elaine > > Can you share the patron excel file I am constrained by the data protection act. I can't share this file with anyone who is not an employee of the organization. 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). > We have surnames, and borrower numbers for everyone. All the data is there. I can't see why the linking fails. I suppose I could try turning off the mandatory fields, but I suspect the error message is incorrect and it's something else that is causing the problem. > > 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-bounces(a)lists.katipo.co.nz > [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of > koha-request(a)lists.katipo.co.nz > Sent: 22 November 2012 04:22 > To: koha(a)lists.katipo.co.nz > Subject: Koha Digest, Vol 85, Issue 35 > > Send Koha mailing list submissions to > koha(a)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-request(a)lists.katipo.co.nz > > You can reach the person managing the list at > koha-owner(a)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 +0000 > From: Elaine Bradtke <eb(a)efdss.org> > To: Quoc Uy <nguyenquocuy_1102(a)yahoo.com> > Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Problem in importing Patron Records > Message-ID: > <CAPdfUuxghmzrirryi1PvjXR1ZWfxuKmZQ4hOkfNnk2o-JhXiXw(a)mail.gmail.com> > 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 <nguyenquocuy_1102(a)yahoo.com> > 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(a)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 +0000 > From: Elaine Bradtke <eb(a)efdss.org> > To: Quoc Uy <nguyenquocuy_1102(a)yahoo.com> > Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Problem in importing Patron Records > Message-ID: > <CAPdfUuxbF+_wYiz-RE2+6a0T6qhCAhD4bkTJAW40HyNDoLyk+w(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > 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 <eb(a)efdss.org> 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 <nguyenquocuy_1102(a)yahoo.com> > 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(a)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) > > > ------------------------------ > > Message: 3 > Date: Wed, 21 Nov 2012 07:49:20 -0600 > From: Travis Elliott Davis <elliott(a)bywatersolutions.com> > To: Samuel Desseaux <samuel.desseaux(a)ecp.fr> > Cc: Koha Devel <koha-devel(a)lists.koha-community.org>, > "Koha(a)lists.katipo.co.nz" <Koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] [Koha-devel] ldap / uid > Message-ID: > <28B78772-DE99-4F1A-9AA7-4A733AD987AF(a)bywatersolutions.com> > Content-Type: text/plain; charset=iso-8859-1 > > Samuel, > > If you want to map the userid field in Koha to "SupannAliasLogin" from your > ldap configuration simply change <userid is="uid"></userid> to <userid > is="SupannAliasLogin"></userid>. > > 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 > Elliott(a)ByWaterSolutions.com > > > > On Nov 21, 2012, at 3:34 AM, Samuel Desseaux <samuel.desseaux(a)ecp.fr> 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 >> >> <ldapserver id="ldapserver" listenref="ldapserver"> >> <hostname>*******</hostname> >> <base>ou=people,dc=ecp,dc=fr</base> >> <user>cn=syncrepl,ou=applications,dc=ecp,dc=fr</user> >> <pass>******</pass> >> <replicate>1</replicate> >> <update>1</update> >> <auth_by_bind>1</auth_by_bind> >> <principal_name>uid=%s,ou=people,dc=ecp,dc=fr</principal_name> >> <mapping> >> <firstname is="givenname"></firstname> >> <surname is="sn"></surname> >> <address is="">Ecole Centrale Paris</address> >> <city is="">Chatenay-Malabry</city> >> <zipcode is="">92290</zipcode> >> <branchcode is="">ECAM</branchcode> >> <userid is="uid"></userid> >> <password is="userpassword"></password> >> <cardnumber is="ecpbadgenumber"></cardnumber> >> <email is="mail"></email> >> <categorycode is="supannetudiplome">employee</categorycode> >> <phone is="telephonenumber">903-566-7654</phone> >> <dateenrolled is="">2012-09-01</dateenrolled> >> <dateexpiry is="">2013-09-01</dateexpiry> >> </mapping> >> </ldapserver> >> >> >> Many thanks >> >> samuel >> >> >> >> >> <samuel_desseaux.vcf>_______________________________________________ >> Koha-devel mailing list >> Koha-devel(a)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/ > > > > ------------------------------ > > Message: 4 > Date: Wed, 21 Nov 2012 21:06:23 +0000 > From: Elaine Bradtke <eb(a)efdss.org> > To: Uy nguy?n qu?c <nguyenquocuy_1102(a)yahoo.com> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Problem in importing Patron Records > Message-ID: > <CAPdfUuzUE5FDwmCkJ82bgCu=ubhVwTazC7O0DT1HieLcg-CEKg(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > 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/yyyy). For some patrons there is no expiration date (life > members). Would this be a problem - are expiration dates required? > Must I convert it to yyyy-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 > <nguyenquocuy_1102(a)yahoo.com> 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 <eb(a)efdss.org> 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 <nguyenquocuy_1102(a)yahoo.com> > 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(a)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) >> > > > > -- > 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: 5 > Date: Wed, 21 Nov 2012 22:51:55 +0000 > From: Elaine Bradtke <eb(a)efdss.org> > To: Quoc Uy <nguyenquocuy_1102(a)yahoo.com> > Cc: koha <koha(a)lists.katipo.co.nz> > Subject: Re: [Koha] Problem in importing Patron Records > Message-ID: > <CAPdfUuz-w_zjvjfCoS=555Dgo69LFgdmnkj4zf--5SfiiWq3uQ(a)mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > I changed the date format to YYYY-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 <nguyenquocuy_1102(a)yahoo.com> > 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 <eb(a)efdss.org> >> To: Uy nguy?n qu?c <nguyenquocuy_1102(a)yahoo.com> >> Cc: koha <koha(a)lists.katipo.co.nz> >> 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/yyyy). For some patrons there is no expiration date (life >> members). Would this be a problem - are expiration dates required? >> Must I convert it to yyyy-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 >> <nguyenquocuy_1102(a)yahoo.com> 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 <eb(a)efdss.org> 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 <nguyenquocuy_1102(a)yahoo.com> >>>>> 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(a)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) >>> >> >> >> >> -- >> 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 > Koha(a)lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha > > > End of Koha Digest, Vol 85, Issue 35 > ************************************ > > _______________________________________________ > Koha mailing list http://koha-community.org > Koha(a)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)

1 0

Blocking users...
by A. Şenol Armağan 22 Nov '12

22 Nov '12

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

4 5

Re: [Koha] Problem in importing Patron Records
by Uy nguyễn quốc 22 Nov '12

22 Nov '12

i think maybe when we open .csv file by Libreoffice Calc, by default, the field delimiter is semicolon. But when we open a .ods file, then save as a .csv file, the field delimiter is comma. And Koha accept comma. He got only this error as i did, it it not like not compare headerrow, or data format is not accepted. Maybe first, turn off all Mandatoryfield, then try exactly save file as .ods, next open this .ods and save as .csv. Maybe it should work. It is not because of borrowers number, Nicole engard deleted this row, and it still works. And when i imported file without first row's value, it still works.

1 0

Re: [Koha] How to check zebra server status?
by Stefano Bargioni 22 Nov '12

22 Nov '12

> How to check Zebra server is running or not? +1 for ps -C zebrasrv in Debian or Ubuntu. For more info try (requires large terminal) ps -f -C zebrasrv or ps -F -C zebrasrv Stefano

1 0

How to check zebra server status?
by Vimal Kumar V. 22 Nov '12

22 Nov '12

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

2 1

Re: [Koha] K-12 Users
by Sunil Kumar 22 Nov '12

22 Nov '12

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.kumar(a)ecoleglobal.com / info(a)ecoleglobal.com Thanks and Regards R Sunil Kumar Library Technologist -----Original Message----- From: koha-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 22 November 2012 10:07 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 85, Issue 36 Send Koha mailing list submissions to koha(a)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-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)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" <sowen(a)edzone.net> To: koha(a)lists.katipo.co.nz Subject: Re: [Koha] K-12 Users Message-ID: <50AD17AA.D5C1.000C.1(a)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 rebuild....but 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<jwellner(a)stanwood.wednet.edu> 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 jwellner(a)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(a)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" <sunil.kumar(a)ecoleglobal.com> To: <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Problem in importing Patron Records Message-ID: <000301cdc86b$050a4f30$0f1eed90$@kumar@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-bounces(a)lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] On Behalf Of koha-request(a)lists.katipo.co.nz Sent: 22 November 2012 04:22 To: koha(a)lists.katipo.co.nz Subject: Koha Digest, Vol 85, Issue 35 Send Koha mailing list submissions to koha(a)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-request(a)lists.katipo.co.nz You can reach the person managing the list at koha-owner(a)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 +0000 From: Elaine Bradtke <eb(a)efdss.org> To: Quoc Uy <nguyenquocuy_1102(a)yahoo.com> Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Problem in importing Patron Records Message-ID: <CAPdfUuxghmzrirryi1PvjXR1ZWfxuKmZQ4hOkfNnk2o-JhXiXw(a)mail.gmail.com> 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 <nguyenquocuy_1102(a)yahoo.com> 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(a)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 +0000 From: Elaine Bradtke <eb(a)efdss.org> To: Quoc Uy <nguyenquocuy_1102(a)yahoo.com> Cc: "koha(a)lists.katipo.co.nz" <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Problem in importing Patron Records Message-ID: <CAPdfUuxbF+_wYiz-RE2+6a0T6qhCAhD4bkTJAW40HyNDoLyk+w(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 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 <eb(a)efdss.org> 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 <nguyenquocuy_1102(a)yahoo.com> 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(a)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) ------------------------------ Message: 3 Date: Wed, 21 Nov 2012 07:49:20 -0600 From: Travis Elliott Davis <elliott(a)bywatersolutions.com> To: Samuel Desseaux <samuel.desseaux(a)ecp.fr> Cc: Koha Devel <koha-devel(a)lists.koha-community.org>, "Koha(a)lists.katipo.co.nz" <Koha(a)lists.katipo.co.nz> Subject: Re: [Koha] [Koha-devel] ldap / uid Message-ID: <28B78772-DE99-4F1A-9AA7-4A733AD987AF(a)bywatersolutions.com> Content-Type: text/plain; charset=iso-8859-1 Samuel, If you want to map the userid field in Koha to "SupannAliasLogin" from your ldap configuration simply change <userid is="uid"></userid> to <userid is="SupannAliasLogin"></userid>. 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 Elliott(a)ByWaterSolutions.com On Nov 21, 2012, at 3:34 AM, Samuel Desseaux <samuel.desseaux(a)ecp.fr> 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 > > <ldapserver id="ldapserver" listenref="ldapserver"> > <hostname>*******</hostname> > <base>ou=people,dc=ecp,dc=fr</base> > <user>cn=syncrepl,ou=applications,dc=ecp,dc=fr</user> > <pass>******</pass> > <replicate>1</replicate> > <update>1</update> > <auth_by_bind>1</auth_by_bind> > <principal_name>uid=%s,ou=people,dc=ecp,dc=fr</principal_name> > <mapping> > <firstname is="givenname"></firstname> > <surname is="sn"></surname> > <address is="">Ecole Centrale Paris</address> > <city is="">Chatenay-Malabry</city> > <zipcode is="">92290</zipcode> > <branchcode is="">ECAM</branchcode> > <userid is="uid"></userid> > <password is="userpassword"></password> > <cardnumber is="ecpbadgenumber"></cardnumber> > <email is="mail"></email> > <categorycode is="supannetudiplome">employee</categorycode> > <phone is="telephonenumber">903-566-7654</phone> > <dateenrolled is="">2012-09-01</dateenrolled> > <dateexpiry is="">2013-09-01</dateexpiry> > </mapping> > </ldapserver> > > > Many thanks > > samuel > > > > > <samuel_desseaux.vcf>_______________________________________________ > Koha-devel mailing list > Koha-devel(a)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/ ------------------------------ Message: 4 Date: Wed, 21 Nov 2012 21:06:23 +0000 From: Elaine Bradtke <eb(a)efdss.org> To: Uy nguy?n qu?c <nguyenquocuy_1102(a)yahoo.com> Cc: koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Problem in importing Patron Records Message-ID: <CAPdfUuzUE5FDwmCkJ82bgCu=ubhVwTazC7O0DT1HieLcg-CEKg(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 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/yyyy). For some patrons there is no expiration date (life members). Would this be a problem - are expiration dates required? Must I convert it to yyyy-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 <nguyenquocuy_1102(a)yahoo.com> 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 <eb(a)efdss.org> 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 <nguyenquocuy_1102(a)yahoo.com> 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(a)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) > -- 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: 5 Date: Wed, 21 Nov 2012 22:51:55 +0000 From: Elaine Bradtke <eb(a)efdss.org> To: Quoc Uy <nguyenquocuy_1102(a)yahoo.com> Cc: koha <koha(a)lists.katipo.co.nz> Subject: Re: [Koha] Problem in importing Patron Records Message-ID: <CAPdfUuz-w_zjvjfCoS=555Dgo69LFgdmnkj4zf--5SfiiWq3uQ(a)mail.gmail.com> Content-Type: text/plain; charset=UTF-8 I changed the date format to YYYY-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 <nguyenquocuy_1102(a)yahoo.com> 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 <eb(a)efdss.org> > To: Uy nguy?n qu?c <nguyenquocuy_1102(a)yahoo.com> > Cc: koha <koha(a)lists.katipo.co.nz> > 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/yyyy). For some patrons there is no expiration date (life > members). Would this be a problem - are expiration dates required? > Must I convert it to yyyy-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 > <nguyenquocuy_1102(a)yahoo.com> 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 <eb(a)efdss.org> 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 <nguyenquocuy_1102(a)yahoo.com> >>>> 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(a)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) >> > > > > -- > 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 Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 85, Issue 35 ************************************ ------------------------------ _______________________________________________ Koha mailing list Koha(a)lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha End of Koha Digest, Vol 85, Issue 36 ************************************

1 0