On Thu, Nov 22, 2012 at 4:36 AM, Sunil Kumar <sunil.ku...@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-boun...@lists.katipo.co.nz > [mailto:koha-boun...@lists.katipo.co.nz] On Behalf Of > koha-requ...@lists.katipo.co.nz > Sent: 22 November 2012 04:22 > To: koha@lists.katipo.co.nz > Subject: Koha Digest, Vol 85, Issue 35 > > Send Koha mailing list submissions to > koha@lists.katipo.co.nz > > To subscribe or unsubscribe via the World Wide Web, visit > http://lists.katipo.co.nz/mailman/listinfo/koha > or, via email, send a message with subject or body 'help' to > koha-requ...@lists.katipo.co.nz > > You can reach the person managing the list at > koha-ow...@lists.katipo.co.nz > > When replying, please edit your Subject line so it is more specific than > "Re: Contents of Koha digest..." > > > Today's Topics: > > 1. Re: Problem in importing Patron Records (Elaine Bradtke) > 2. Re: Problem in importing Patron Records (Elaine Bradtke) > 3. Re: [Koha-devel] ldap / uid (Travis Elliott Davis) > 4. Re: Problem in importing Patron Records (Elaine Bradtke) > 5. Re: Problem in importing Patron Records (Elaine Bradtke) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Wed, 21 Nov 2012 20:22:18 +0000 > From: Elaine Bradtke <e...@efdss.org> > To: Quoc Uy <nguyenquocuy_1...@yahoo.com> > Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> > Subject: Re: [Koha] Problem in importing Patron Records > Message-ID: > <capdfuuxghmzrirryi1pvjxr1zwfxukmzq4hokfnnk2o-jhx...@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_1...@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@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 <e...@efdss.org> > To: Quoc Uy <nguyenquocuy_1...@yahoo.com> > Cc: "koha@lists.katipo.co.nz" <koha@lists.katipo.co.nz> > Subject: Re: [Koha] Problem in importing Patron Records > Message-ID: > <capdfuuxbf+_wyiz-re2+6a0t6qhcahd4bktjaw40hyndoly...@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 <e...@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_1...@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@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 <elli...@bywatersolutions.com> > To: Samuel Desseaux <samuel.desse...@ecp.fr> > Cc: Koha Devel <koha-de...@lists.koha-community.org>, > "Koha@lists.katipo.co.nz" <Koha@lists.katipo.co.nz> > Subject: Re: [Koha] [Koha-devel] ldap / uid > Message-ID: > <28b78772-de99-4f1a-9aa7-4a733ad98...@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 > elli...@bywatersolutions.com > > > > On Nov 21, 2012, at 3:34 AM, Samuel Desseaux <samuel.desse...@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-de...@lists.koha-community.org >> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel >> website : http://www.koha-community.org/ >> git : http://git.koha-community.org/ >> bugs : http://bugs.koha-community.org/ > > > > ------------------------------ > > Message: 4 > Date: Wed, 21 Nov 2012 21:06:23 +0000 > From: Elaine Bradtke <e...@efdss.org> > To: Uy nguy?n qu?c <nguyenquocuy_1...@yahoo.com> > Cc: koha <koha@lists.katipo.co.nz> > Subject: Re: [Koha] Problem in importing Patron Records > Message-ID: > <CAPdfUuzUE5FDwmCkJ82bgCu=ubhvwtazc7o0dt1hielcg-c...@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_1...@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 <e...@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_1...@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@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 <e...@efdss.org> > To: Quoc Uy <nguyenquocuy_1...@yahoo.com> > Cc: koha <koha@lists.katipo.co.nz> > Subject: Re: [Koha] Problem in importing Patron Records > Message-ID: > <CAPdfUuz-w_zjvjfCoS=555dgo69lfgdmnkj4zf--5sfiiwq...@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_1...@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 <e...@efdss.org> >> To: Uy nguy?n qu?c <nguyenquocuy_1...@yahoo.com> >> Cc: koha <koha@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_1...@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 <e...@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_1...@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@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@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@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
