Import Patrons
Import results :
- imported records (last was )
- overwritten (last was )
- not imported because already in borrowers table and overwrite disabled (last was )
- not imported because they are not in the expected format (last was )
- records parsed
- Back to Tools
Feedback:
-
Parsing upload file
Upload parsed using
These fields found:
:
Error analysis:
- Header row could not be parsed
-
Line
could not be parsed!
has "" in unrecognized format: ""
Critical field ""
has unrecognized value ""
has unrecognized value ""
missing
(borrowernumber: ; surname: ).
- Select a file to import into the borrowers table
- If a cardnumber exists in the table, you can choose whether to ignore the new one or overwrite the old one.
Notes:
- Download a starter CSV file with all the columns here. Values are comma-separated.
- OR format your file in CSV format with the following fields:
- If loading patron attributes, the 'patron_attributes' field should contain a comma-separated list of attribute types
and values. The attribute type code and a ':' should precede each value. For example: "INSTID:12345,LANG:fr". This
means that if an input record has more than one attribute, the 'patron_attributes' field must be wrapped in double quotation marks.
- The fields 'branchcode' and 'categorycode' are required and must match valid entries in your database.
- 'password' should be stored in plaintext, and will be converted to a md5 hash (if your passwords are already encrypted, talk to your systems administrator about options).
- Date formats should match your system preference, and must be zero-padded, e.g. '01/02/2008'.
- You may optionally include a header row, defining which columns you are supplying in the import file.