Re: [Koha] Problem in importing Patron Records
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.
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@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)
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@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@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)
participants (2)
-
Elaine Bradtke -
Quoc Uy