Patron import
Import results :
- imported records
- overwritten
- not imported because already in borrowers table and overwrite disabled
- not imported because they are not in the expected format
- records parsed
- Back
- 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:
- Format the file in CSV format with the following fields:
-
'cardnumber', 'surname', 'firstname', 'title',
'othernames', 'initials', 'streetnumber', 'streettype',
'address', 'address2', 'city', 'zipcode',
'email', 'phone', 'mobile', 'fax',
'emailpro', 'phonepro', 'B_streetnumber', 'B_streettype',
'B_address', 'B_city', 'B_zipcode', 'B_email',
'B_phone', 'dateofbirth', 'branchcode', 'categorycode',
'dateenrolled', 'dateexpiry', 'gonenoaddress', 'lost',
'debarred', 'contactname', 'contactfirstname', 'contacttitle',
'borrowernotes', 'relationship', 'ethnicity', 'ethnotes',
'sex', 'userid', 'opacnote', 'contactnote',
'password', 'sort1', 'sort2'
- Please make sure the 'branchcode' and 'categorycode' are 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).