This looks like a bug that I will report. The CSV file on the patron import tool has different columns from those listed on the page itself. The CSV file is correct, the text on the page is not. Click the 'CSV' link and use that file and it should solve your problems. Thanks Nicole On Fri, Nov 5, 2010 at 11:50 AM, Linda Culberson <lculber@mdah.state.ms.us> wrote:
I'm having trouble bulk loading patrons files into Koha 3.2. I used the same file I used in 3.1 with no success, so I did one manually, and then set everything to match that. I got the same errors in 3.2. both times: In the staff client, I get that the record was " not imported because they are not in the expected format" and then Critical field "surname" missing (borrowernumber: UNDEF; surname: UNDEF). I have headerrow copied from the "Import Patrons" page: 'surname', 'firstname', 'title', 'othernames', 'initials', 'streetnumber', 'streettype', 'address', 'address2', 'city', 'zipcode', 'country', 'email', 'phone', 'mobile', 'fax', 'emailpro', 'phonepro', 'B_streetnumber', 'B_streettype', 'B_address', 'B_address2', 'B_city', 'B_zipcode', 'B_country', 'B_email', 'B_phone', 'dateofbirth', 'branchcode', 'categorycode', 'dateenrolled', 'dateexpiry', 'gonenoaddress', 'lost', 'debarred', 'contactname', 'contactfirstname', 'contacttitle', 'guarantorid', 'borrowernotes', 'relationship', 'ethnicity', 'ethnotes', 'sex', 'password', 'flags', 'userid', 'opacnote', 'contactnote', 'sort1', 'sort2', 'altcontactfirstname', 'altcontactsurname', 'altcontactaddress1', 'altcontactaddress2', 'altcontactaddress3', 'altcontactzipcode', 'altcontactcountry', 'altcontactphone', 'smsalertnumber', 'privacy', 'patron_attributes' My record is: 'Crawford', 'Taz', '', 'Tazmo', '', '', '', '150 Our Street', '', 'Yazoo City, MS', '39194', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'DAH', '01', '11/05/2010', '11/05/2011', '', '', '', '', '', '', '', '', '', '', '', '', 'Tazmo', '', '11111', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', 'CountyCode:yz,PhotoID:Tx VetId 0042201,StateCode:01'
In the /var/log/koha/koha-error_log [Fri Nov 05 09:56:43 2010] [error] [client 10.8.5.33] [Fri Nov 5 09:56:43 2010] import_borrowers.pl: Use of uninitialized value $keycol in substitution (s///) at /usr/share/koha/intranet/cgi-bin/tools/import_borrowers.pl line 124, <fh00001mytest.csv> line 1., referer: http://koha.mdah.state.ms.us:8080/cgi-bin/koha/tools/import_borrowers.pl [Fri Nov 05 09:56:43 2010] [error] [client 10.8.5.33] [Fri Nov 5 09:56:43 2010] import_borrowers.pl: Use of uninitialized value $keycol in hash element at /usr/share/koha/intranet/cgi-bin/tools/import_borrowers.pl line 125, <fh00001mytest.csv> line 1., referer: http://koha.mdah.state.ms.us:8080/cgi-bin/koha/tools/import_borrowers.pl [Fri Nov 05 09:56:43 2010] [error] [client 10.8.5.33] [Fri Nov 5 09:56:43 2010] import_borrowers.pl: Use of uninitialized value $csvcolumns[0] in join or string at /usr/share/koha/intranet/cgi-bin/tools/import_borrowers.pl line 133, <fh00001mytest.csv> line 1., referer: http://koha.mdah.state.ms.us:8080/cgi-bin/koha/tools/import_borrowers.pl
So I looked at import_borrowers.pl and those lines are 122 foreach my $keycol (@csvcolumns) { 123 # columnkeys don't contain whitespace, but some stupid tools add it 124 $keycol =~ s/ +//g; 125 $csvkeycol{$keycol} = $col++; 126 } 127 #warn($borrowerline); 128 my $ext_preserve = $input->param('ext_preserve') || 0; 129 if ($extended) { 130 $matchpoint_attr_type = C4::Members::AttributeTypes->fetch($matchpoint); 131 } 132 133 push @feedback, {feedback=>1, name=>'headerrow', value=>join(', ', @csvcolumns)};
Any help would be appreciated.
-- Linda Culberson lculber@mdah.state.ms.us Archives and Records Services Division Ms. Dept. of Archives& History P. O. Box 571 Jackson, MS 39205-0571 Telephone: 601/576-6873 Facsimile: 601/576-6824
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha