Re: [Koha] Problem in importing Patron Records

2015-10-18 Thread Katrin Fischer
Hi Ahmad, did you figure out the problem yet? Usually the error message is shown a bit below the part that you pasted. If you sent us that information and maybe a sample line of your patron import (personal information removed/anonymized), it would be easier to see what's going wrong. Hope this

[Koha] Problem in importing Patron Records

2015-10-13 Thread ahmnas
when i import patrons from tools and import patron and upload csv file give me message 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,

Re: [Koha] Problem in importing Patron Records

2012-11-23 Thread MJ Ray
Elaine Bradtke e...@efdss.org It appears the header row is case sensitive. Once I converted the all caps to lower case it went right in. Would have been nice to know. . I think I wrote the header row support, or at least I've worked on it at some point. The header row will be because the

Re: [Koha] Problem in importing Patron Records

2012-11-22 Thread Uy nguyễn quốc
i think maybe when we open .csv file by Libreoffice Calc, by default, the field delimiter is semicolon. But when we open a .ods file, then save as a .csv file, the field delimiter is comma. And Koha accept comma. He got only this error as i did, it it not like not compare headerrow, or data

Re: [Koha] Problem in importing Patron Records

2012-11-22 Thread Elaine Bradtke
...@lists.katipo.co.nz on behalf of Elaine Bradtke Sent: Wed 21.11.2012 23:51 To: Quoc Uy Cc: koha Subject: Re: [Koha] Problem in importing Patron Records I changed the date format to -MM-DD I also added a date to the patron records that didn't have them. I saved it as an ods file, and then closed

Re: [Koha] Problem in importing Patron Records

2012-11-22 Thread Elaine Bradtke
) -- Message: 1 Date: Wed, 21 Nov 2012 20:22:18 + 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

Re: [Koha] Problem in importing Patron Records

2012-11-22 Thread Chris Cormack
* Elaine Bradtke (e...@efdss.org) wrote: I will say having to jump through all these hoops to get the data into Koha means I probably won't be able to delegate the monthly updates to another member of staff. This is unfortunate, it shouldn't be this difficult. Yeah, that's the thing, it

Re: [Koha] Problem in importing Patron Records

2012-11-22 Thread Elaine Bradtke
Solved! It appears the header row is case sensitive. Once I converted the all caps to lower case it went right in. Would have been nice to know. . . . Thanks for everyone's input. I kept saying I wasn't going to work on the holiday. . . at least now I won't wake up in the middle of the night

Re: [Koha] Problem in importing Patron Records

2012-11-21 Thread Elaine Bradtke
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,

Re: [Koha] Problem in importing Patron Records

2012-11-21 Thread Elaine Bradtke
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

Re: [Koha] Problem in importing Patron Records

2012-11-21 Thread Fischer, Katrin
or more additional lines to help you find the problem. Hope this helps, Katrin -Original Message- From: koha-boun...@lists.katipo.co.nz on behalf of Elaine Bradtke Sent: Wed 21.11.2012 23:51 To: Quoc Uy Cc: koha Subject: Re: [Koha] Problem in importing Patron Records I changed the date

Re: [Koha] Problem in importing Patron Records

2012-11-21 Thread Elaine Bradtke
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

Re: [Koha] Problem in importing Patron Records

2012-11-21 Thread Sunil Kumar
) -- Message: 2 Date: Wed, 21 Nov 2012 20:30:42 + 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

Re: [Koha] Problem in importing Patron Records

2012-11-21 Thread Elaine Bradtke
, 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

Re: [Koha] Problem in importing Patron Records

2012-11-20 Thread Quoc Uy
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

Re: [Koha] Problem in importing Patron Records

2012-07-26 Thread Sunil Kumar
+0530 From: Prajeesh prajeesh...@gmail.com To: Koha Koha@lists.katipo.co.nz Subject: [Koha] Problem in importing Patron Records Message-ID: CAD=TC1quA1tsEA4teLQY+=xjieezo7ngk8lwr73q0pxtysz...@mail.gmail.com Content-Type: text/plain; charset=iso-8859-1 Dear all I tried to import a .csv file

Re: [Koha] Problem in importing Patron Records

2012-06-09 Thread Robin Sheat
Please reply to the list. Op 08-06-12 05:59, Prajeesh schreef: Hi Robin I used the .csv file given by koha patron upload page and used the same header row. I am attaching sample .csv file that I have tried to upload. The file you attached isn't a comma separated values file, it's a tab

Re: [Koha] Problem in importing Patron Records

2012-06-07 Thread Robin Sheat
Op 05-06-12 10:39, Prajeesh schreef: It is give correct in the .csv file. Is there any bug reported in this version regarding patron import. Please help me. The .csv file is attached. The CSV file isn't attached, however: - Header row could not be parsed this looks bad. Do you have a

[Koha] Problem in importing Patron Records

2012-06-05 Thread Prajeesh
Dear all I tried to import a .csv file to my Koha installation (version 3.06.01.000) and got the following errors. I have checked the Branch code and the Category Code. It is give correct in the .csv file. Is there any bug reported in this version regarding patron import. Please help me. The .csv

Re: [Koha] Problem in importing Patron Records

2012-06-05 Thread Paul
At 03:09 PM 6/5/2012 +0530, Prajeesh wrote: Dear all I tried to import a .csv file to my Koha installation (version 3.06.01.000) and got the following errors. I have checked the Branch code and the Category Code. It is give correct in the .csv file. Is there any bug reported in this version