# # Good morning, # I am having problems getting my patron data imported into Koha. I am using Koha version 3.00.06.010 # I used the starter CSV file that is on the 'Import Patron' page to set the data in a table. I have checked the categorycode and branchcode to make sure they are correct. I received the same message for the 2750 patrons I uploaded. # Line 2 could not be parsed! |2737 561000 "Ablowaluk" "Arin" "" "" "AA" "PO BOX 513" "" "" "" "Teller" 99778 "" "642-6885" "" "" "" "" "C" "0000-00-00" 0 0 0 "" "" "TLA" "C" "3/15/11" "12/31/17" "" "" "" "" "" "" "" "" "" "" "" "M" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" | # Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF; surname: UNDEF). |2737 561000 "Ablowaluk" "Arin" "" "" "AA" "PO BOX 513" "" "" "" "Teller" 99778 "" "642-6885" "" "" "" "" "C" "0000-00-00" 0 0 0 "" "" "TLA" "C" "3/15/11" "12/31/17" "" "" "" "" "" "" "" "" "" "" "" "M" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" | # Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname: UNDEF). |2737 561000 "Ablowaluk" "Arin" "" "" "AA" "PO BOX 513" "" "" "" "Teller" 99778 "" "642-6885" "" "" "" "" "C" "0000-00-00" 0 0 0 "" "" "TLA" "C" "3/15/11" "12/31/17" "" "" "" "" "" "" "" "" "" "" "" "M" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" | # Any ideas would be appreciated, Thanks, Darla -- Darla Grediagin District Librarian Bering Strait School District Unalakleet, Alaska Web Address : http://bssdonline.org/course/view.php?id=51 Blog: http://aklibrarian1.edublogs.org/ OPAC: http://opac.bssd.org:8181/cgi-bin/koha/opac-search.pl
Darla Grediagin schreef op di 15-03-2011 om 08:46 [-0800]:
# I used the starter CSV file that is on the 'Import Patron' page to set the data in a table. I have checked the categorycode and branchcode to make sure they are correct. I received the same message for the 2750 patrons I uploaded.
# Line 2 could not be parsed! |2737 561000 "Ablowaluk" "Arin" "" "" "AA" "PO BOX 513" "" "" "" "Teller" 99778 "" "642-6885" "" "" "" "" "C" "0000-00-00" 0 0 0 "" "" "TLA" "C" "3/15/11" "12/31/17" "" "" "" "" "" "" "" "" "" "" "" "M" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" "" |
If this is what your file actually looks like, it is not a CSV file, there are no commas separating the values. I'd check the settings you're using to export the file and make sure that they're set correctly (in particular, with commas.) -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5957 6D23 8B16 EFAB FEF8 7175 14D3 6485 A99C EB6D
participants (2)
-
Darla Grediagin -
Robin Sheat