[Koha] Problem in importing Patron Records
Elaine Bradtke
eb at efdss.org
Fri Nov 23 06:41:55 NZDT 2012
On Thu, Nov 22, 2012 at 4:36 AM, Sunil Kumar
<sunil.kumar at 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 at lists.katipo.co.nz
> [mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
> koha-request at lists.katipo.co.nz
> Sent: 22 November 2012 04:22
> To: koha at lists.katipo.co.nz
> Subject: Koha Digest, Vol 85, Issue 35
>
> Send Koha mailing list submissions to
> koha at 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 at lists.katipo.co.nz
>
> You can reach the person managing the list at
> koha-owner at 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 at efdss.org>
> To: Quoc Uy <nguyenquocuy_1102 at yahoo.com>
> Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Problem in importing Patron Records
> Message-ID:
> <CAPdfUuxghmzrirryi1PvjXR1ZWfxuKmZQ4hOkfNnk2o-JhXiXw at 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 at 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 at 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 at efdss.org>
> To: Quoc Uy <nguyenquocuy_1102 at yahoo.com>
> Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Problem in importing Patron Records
> Message-ID:
> <CAPdfUuxbF+_wYiz-RE2+6a0T6qhCAhD4bkTJAW40HyNDoLyk+w at 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 at 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 at 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 at 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 at bywatersolutions.com>
> To: Samuel Desseaux <samuel.desseaux at ecp.fr>
> Cc: Koha Devel <koha-devel at lists.koha-community.org>,
> "Koha at lists.katipo.co.nz" <Koha at lists.katipo.co.nz>
> Subject: Re: [Koha] [Koha-devel] ldap / uid
> Message-ID:
> <28B78772-DE99-4F1A-9AA7-4A733AD987AF at 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 at ByWaterSolutions.com
>
>
>
> On Nov 21, 2012, at 3:34 AM, Samuel Desseaux <samuel.desseaux at 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 at 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 at efdss.org>
> To: Uy nguy?n qu?c <nguyenquocuy_1102 at yahoo.com>
> Cc: koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Problem in importing Patron Records
> Message-ID:
> <CAPdfUuzUE5FDwmCkJ82bgCu=ubhVwTazC7O0DT1HieLcg-CEKg at 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 at 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 at 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 at 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 at 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 at efdss.org>
> To: Quoc Uy <nguyenquocuy_1102 at yahoo.com>
> Cc: koha <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] Problem in importing Patron Records
> Message-ID:
> <CAPdfUuz-w_zjvjfCoS=555Dgo69LFgdmnkj4zf--5SfiiWq3uQ at 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 at 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 at efdss.org>
>> To: Uy nguy?n qu?c <nguyenquocuy_1102 at yahoo.com>
>> Cc: koha <koha at 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 at 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 at 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 at 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 at 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 at 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 at 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)
More information about the Koha
mailing list