1 <!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
2 <title>Koha › Cataloging › Patron Import <!-- TMPL_IF NAME="uploadborrowers" -->› Results<!-- /TMPL_IF --></title>
3 <!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
6 <!-- TMPL_INCLUDE NAME="header.inc" -->
7 <!-- TMPL_INCLUDE NAME="patron-search.inc"-->
9 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> › <a href="/cgi-bin/koha/tools/tools-home.pl">Tools</a> › Patron Import <!-- TMPL_IF name="uploadborrowers" --><a href="/cgi-bin/koha/tools/import_borrowers.pl">Patron Import</a> › Results<!-- TMPL_ELSE -->Patron Import<!-- /TMPL_IF --></div>
11 <div id="doc3" class="yui-t2">
17 <div class="yui-u first">
18 <h1>Patron import</h1>
19 <!-- TMPL_IF name="uploadborrowers" -->
20 <p>Import results :</p>
22 <li><!-- TMPL_VAR name="imported" --> imported records</li>
23 <li><!-- TMPL_VAR name="overwritten" --> overwritten</li>
24 <li><!-- TMPL_VAR name="alreadyindb" --> not imported because already in borrowers table and overwrite disabled</li>
25 <li><!-- TMPL_VAR name="invalid" --> not imported because they are not in the expected format !</li>
26 <li><!-- TMPL_VAR name="total" --> records parsed</li>
27 <li><a href="/cgi-bin/koha/tools/tools-home.pl">Back</a></li>
31 <li>Select a file to import into the borrowers table</li>
32 <li>If a cardnumber exists in the table, you can choose whether to ignore the new one or overwrite the old one.</li>
34 <form method="post" action="<!-- TMPL_VAR name="SCRIPT_NAME" -->" enctype="multipart/form-data">
35 <fieldset class="rows">
36 <legend>Import into the borrowers table</legend>
39 <label for="uploadborrowers">Select the file to import: </label>
40 <input type="file" id="uploadborrowers" name="uploadborrowers" />
43 <fieldset class="rows">
44 <legend>If cardnumber is already in the borrowers table:</legend><ol><li class="radio">
46 <input type="radio" id="overwrite_cardnumberno" name="overwrite_cardnumber" value="0" checked="checked" /><label for="overwrite_cardnumberno">Ignore this one, keep the existing one</label></li>
48 <input type="radio" id="overwrite_cardnumberyes" name="overwrite_cardnumber" value="1" /><label for="overwrite_cardnumberyes">Overwrite the existing one with this</label>
49 </li></ol></fieldset><fieldset class="action"><input type="submit" value="Import" /></fieldset>
56 <li>Format the file in CSV format with the following fields:</li>
58 'cardnumber', 'surname', 'firstname', 'title',
59 'othernames', 'initials', 'streetnumber', 'streettype',
60 'address', 'address2', 'city', 'zipcode',
61 'email', 'phone', 'mobile', 'fax',
62 'emailpro', 'phonepro', 'B_streetnumber', 'B_streettype',
63 'B_address', 'B_city', 'B_zipcode', 'B_email',
64 'B_phone', 'dateofbirth', 'branchcode', 'categorycode',
65 'dateenrolled', 'dateexpiry', 'gonenoaddress', 'lost',
66 'debarred', 'contactname', 'contactfirstname', 'contacttitle',
67 'borrowernotes', 'relationship', 'ethnicity', 'ethnotes',
68 'sex', 'userid', 'opacnote', 'contactnote',
69 'password', 'sort1', 'sort2'
71 <li>Please make sure the 'branchcode' and 'categorycode' are valid entries in your database.</li>
72 <li>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).</li>
80 <!-- TMPL_INCLUDE NAME="tools-menu.inc" -->
83 <!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->