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: [email protected]
          Reporter: [email protected]
        QA Contact: [email protected]
  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.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to