https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=43066 Bug ID: 43066 Summary: Incorrect processing of patron import file from web interface Initiative type: --- Sponsorship --- status: Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: MARC Bibliographic record staging/import Assignee: koha-bugs@lists.koha-community.org Reporter: bernard.scaife@openfifth.co.uk QA Contact: testopia@bugs.koha-community.org Target Milestone: --- Created attachment 201907 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=201907&action=edit 3 record test patron load csv Patron import should not attempt to import header line and counts are then wrong 1. Go to import patrons tool in Koha 2. Choose attached test csv which has a header and four records NB/ You may need to adjust the branch and category code to match your system first 3. Click import 4. Import results say: 3 imported records 1 overwritten records 0 not imported because they are already in borrowers table and overwrite is disabled 1 not imported because they are not in the expected format 5 records parsed 5. Note errors shown: Error analysis Line 3 Critical field "categorycode" has unrecognized value "categorycode" (borrowernumber: UNDEF; surname: surname). cardnumber,firstname,surname,email,branchcode,categorycode,borrowernotes,userid,patron_attributes Line 3 Critical field "branchcode" has unrecognized value "branchcode" (borrowernumber: UNDEF; surname: surname). cardnumber,firstname,surname,email,branchcode,categorycode,borrowernotes,userid,patron_attributes It is trying to import the header row and should not be. 6. ftp the same csv file to the server 7. On the server, run /usr/share/koha/bin/import_patrons.pl --file /kohadevbox/koha/<testfilename> --matchpoint cardnumber --overwrite --verbose --verbose --confirm Import complete: Imported: 0 Overwritten: 3 Skipped: 0 Invalid: 0 Total: 3 Errors: $VAR1 = []; No errors, so the backend version is correct but not the staff interface -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.