- Koha - lists.katipo.co.nz

Re: [Koha] Problem in importing Patron Records
by Sunil Kumar 22 Nov '12

22 Nov '12

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 ************************************

1 0

Re: [Koha] K-12 Users
by Scott Owen 22 Nov '12

22 Nov '12

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

1 0

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

21 Nov '12

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)

1 0

Re: [Koha] Problem in importing Patron Records
by Quoc Uy 21 Nov '12

21 Nov '12

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.

2 2

K-12 Users
by Jeremy Wellner 21 Nov '12

21 Nov '12

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

1 0

ldap / uid
by Samuel Desseaux 21 Nov '12

21 Nov '12

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

2 1

How "Instant Fine Calculation at Checkin" works?
by Vimal Kumar V. 21 Nov '12

21 Nov '12

Dear Friends, I heard that a new feature added with Koha 3.8.1 version, http://koha-community.org/koha-3-8-1-released/ "Instant Fine Calculation at Checkin" I would like to know how it works? Documentation available? -- 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

1 0

Re: [Koha] How to change fine calculation time in Koha installation on Ubuntu packages
by Vimal Kumar V. 21 Nov '12

21 Nov '12

Dear Mark and other friends, My problem with fine calculation is as follows: default fine calculation time is 1 AM. Fine calculation does not work in the case of Koha installed on pc not working for 24x7 hours. Libraries having Koha service available between 9AM to 5 PM cant count fine. Reason is that cronjob work only on 1 PM. Installation from tarball cronjob entries can be loaded in crontab -e with timings. # FINES 5 10 * * * $KOHA_CRON_PATH/fines.pl Users can easily change the default time (1pm) to other convenient time (e.g. 9 AM) for fine calculation. My doubt is that how can I change the default time of fine calculation to another convenient timing? I would like to change time 1 PM to 10 AM. I installed Koha from Ubuntu packages. Where I can find the default fine calculation time? This information is very important for small libraries installed Koha on PC. 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

1 0

Error searching authorities koha 3.8.6-1
by cortiz 20 Nov '12

20 Nov '12

i have Koha 3.8.6-1 installled from repository on debian squeeze, language es-ES enable, I'm entering autoriodades person name, when I search for that authority returns me error message: Template process failed: file error - parse error - authorities-search-results.inc line 8: unexpected end of input at /usr/share/koha/lib/C4/Templates.pm line 127. file intranet_error.log reads: 7 [Tue Nov 20 14:16:04 2012] [error] [client 127.0.0.1] [Tue Nov 20 14:16:04 2012] authorities-home.pl: Template process failed: file error - parse error - authorities-search-results.inc line 8: unexpected end of input at /usr/share/koha/lib/C4/Templates.pm line 127., in the browser: http://127.0.0.1:8080/cgi-bin/koha/authorities/authorities-home.pl?op=do_se… I can do to fix this? -- View this message in context: http://koha.1045719.n5.nabble.com/Error-searching-authorities-koha-3-8-6-1-… Sent from the Koha-general mailing list archive at Nabble.com.

3 6

Help with documentation errors
by Nicole Engard 20 Nov '12

20 Nov '12

Hello all, I noticed that the 3.8 manual wasn't updating using the cron job we run nightly and so Larry found the following errors (note that it's not just the 3.8 English manual): 3.10, French: fr/manual.xml:2181: parser error : CharRef: invalid decimal value les amendes est de 5 &#8364 (c'est | dire qu'un adhérent ayant accumulé ^ fr/manual.xml:2181: parser error : xmlParseCharRef: invalid xmlChar value 0 les amendes est de 5 &#8364 (c'est | dire qu'un adhérent ayant accumulé ^ fr/manual.xml:2186: parser error : CharRef: invalid decimal value qui porterait la somme totale due par l'adhérent | 5 &#8364. Selon ^ fr/manual.xml:2186: parser error : xmlParseCharRef: invalid xmlChar value 0 qui porterait la somme totale due par l'adhérent | 5 &#8364. Selon ^ fr/manual.xml:5968: parser error : Opening and ending tag mismatch: chapter line 85 and section </section> ^ fr/manual.xml:15191: parser error : Opening and ending tag mismatch: book line 4 and section </section> ^ fr/manual.xml:15192: parser error : Extra content at the end of the document </chapter> ^ unable to parse fr/manual.xml 3.8, English: en/manual.xml:41551: parser error : Premature end of data in tag para line 41550 information. ^ en/manual.xml:41551: parser error : Premature end of data in tag section line 41527 information. ^ en/manual.xml:41551: parser error : Premature end of data in tag appendix line 41521 information. ^ en/manual.xml:41551: parser error : Premature end of data in tag book line 4 information. ^ unable to parse en/manual.xml 3.6, French: fr/manual.xml:18780: parser error : CharRef: invalid decimal value Ne pas rentrer de signes monétaires ($, &#8364 )</para> ^ fr/manual.xml:18780: parser error : xmlParseCharRef: invalid xmlChar value 0 Ne pas rentrer de signes monétaires ($, &#8364 )</para> ^ fr/manual.xml:18818: parser error : CharRef: invalid decimal value Ne pas rentrer de signes monétaires ($, &#8364 )</para> ^ fr/manual.xml:18818: parser error : xmlParseCharRef: invalid xmlChar value 0 Ne pas rentrer de signes monétaires ($, &#8364 )</para> ^ unable to parse fr/manual.xml -- So, it looks like the 3.10 French, 3.8 English, and 3.6 French manuals are not updating. However, the 3.6 English one should be. My question is, how do encoding errors like the ones on the English manual happen? I looked at that line in the code and see nothing, I even deleted that line and still can't save the file because it tells me that there are encoding errors in the file. Any help would be greatly appreciated so that I can get the 3.8 manual back on track. Nicole PS. If you know how to fix it you're free to submit a patch of course!!

3 4