1 <!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
2 <title>Koha › Cataloging › MARC Import</title>
3 <!-- TMPL_INCLUDE NAME="doc-head-close.inc" -->
6 <!-- TMPL_INCLUDE NAME="header.inc" -->
7 <!-- TMPL_INCLUDE NAME="cat-search.inc" -->
9 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> › <a href="/cgi-bin/koha/reports/tools-home.pl">Tools</a> › Borrower Import</div>
11 <div id="doc3" class="yui-t2">
17 <h1>Borrower 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><ol>
38 <label for="uploadborrowers">Select the file to import: </label>
40 <input type="file" id="uploadborrowers" name="uploadborrowers" /><br />
45 <fieldset class="rows">
46 <legend>If cardnumber is already in the borrowers table:</legend><ol><li class="radio">
48 <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>
50 <input type="radio" id="overwrite_cardnumberyes" name="overwrite_cardnumber" value="1" /><label for="overwrite_cardnumberyes">Overwrite the existing one with this</label>
51 </li></ol></fieldset><input type="submit" value="Import" />
57 <li>Format the file in CSV format with the following fields:</li>
59 'cardnumber', 'surname', 'firstname', 'title',
60 'othernames', 'initials', 'streetnumber', 'streettype',
61 'address', 'address2', 'city', 'zipcode',
62 'email', 'phone', 'mobile', 'fax',
63 'emailpro', 'phonepro', 'B_streetnumber', 'B_streettype',
64 'B_address', 'B_city', 'B_zipcode', 'B_email',
65 'B_phone', 'dateofbirth', 'branchcode', 'categorycode',
66 'dateenrolled', 'dateexpiry', 'gonenoaddress', 'lost',
67 'debarred', 'contactname', 'contactfirstname', 'contacttitle',
68 'borrowernotes', 'relationship', 'ethnicity', 'ethnotes',
69 'sex', 'userid', 'opacnote', 'contactnote',
70 'password', 'sort1', 'sort2'
72 <li>Please make sure the 'branchcode' and 'categorycode' are valid entries in your database</li>
73 <li>password should be stored in plaintext, and will be converted to a md5 hash(if your passwords are already crypted, talk to your systems administrator about options)</li>
80 <!-- TMPL_INCLUDE NAME="tools-menu.inc" -->
83 <!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->