1 <!-- TMPL_INCLUDE NAME="help-top.inc" -->
6 <li>Create a CSV file for your patron data<br/>
8 <li>Format your file with the following fields
10 <li>'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'
13 <span style="background-color: #ffe599">
14 TIP: Consult your system administrator if you are unsure of how to fill in the above fields.</span></li>
16 IMPORTANT: Make sure the 'branchcode' and 'categorycode' are valid entries in your database.</li>
17 <li>Passwords should be stored in plain text, and will be encrypted as they're imported
20 <span style="background-color: #ffe599">
21 TIP: If your passwords are already encrypted, talk to your systems administrator about options.</span></li>
26 <li>Select a file to import into the borrowers table</li>
27 <li>If a cardnumber exists in the table, you can choose whether to ignore the new one or overwrite the old one.</li>
28 <li>Click 'Import'</li>
29 <li>You will be brought to a confirmation screen.</li>
31 </div> <!-- TMPL_INCLUDE NAME="help-bottom.inc" -->