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="members-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</div>
10 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> › <a href="/cgi-bin/koha/tools/tools-home.pl">Tools</a> › Borrower Import</div>
12 <div id="doc3" class="yui-t2">
18 <h1>Patron import</h1>
20 <!-- TMPL_IF name="uploadborrowers" -->
21 <p>Import results :</p>
23 <li><!-- TMPL_VAR name="imported" --> imported records</li>
24 <li><!-- TMPL_VAR name="overwritten" --> overwritten</li>
25 <li><!-- TMPL_VAR name="alreadyindb" --> not imported because already in borrowers table and overwrite disabled</li>
26 <li><!-- TMPL_VAR name="invalid" --> not imported because they are not in the expected format !</li>
27 <li><!-- TMPL_VAR name="total" --> records parsed</li>
28 <li><a href="/cgi-bin/koha/tools/tools-home.pl">Back</a></li>
32 <li>Select a file to import into the borrowers table</li>
33 <li>If a cardnumber exists in the table, you can choose whether to ignore the new one or overwrite the old one.</li>
35 <form method="post" action="<!-- TMPL_VAR name="SCRIPT_NAME" -->" enctype="multipart/form-data">
36 <fieldset class="rows">
37 <legend>Import into the borrowers table</legend><ol>
39 <label for="uploadborrowers">Select the file to import: </label>
41 <input type="file" id="uploadborrowers" name="uploadborrowers" /><br />
46 <fieldset class="rows">
47 <legend>If cardnumber is already in the borrowers table:</legend><ol><li class="radio">
49 <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>
51 <input type="radio" id="overwrite_cardnumberyes" name="overwrite_cardnumber" value="1" /><label for="overwrite_cardnumberyes">Overwrite the existing one with this</label>
52 </li></ol></fieldset><input type="submit" value="Import" />
58 <li>Format the file in CSV format with the following fields:</li>
60 'cardnumber', 'surname', 'firstname', 'title',
61 'othernames', 'initials', 'streetnumber', 'streettype',
62 'address', 'address2', 'city', 'zipcode',
63 'email', 'phone', 'mobile', 'fax',
64 'emailpro', 'phonepro', 'B_streetnumber', 'B_streettype',
65 'B_address', 'B_city', 'B_zipcode', 'B_email',
66 'B_phone', 'dateofbirth', 'branchcode', 'categorycode',
67 'dateenrolled', 'dateexpiry', 'gonenoaddress', 'lost',
68 'debarred', 'contactname', 'contactfirstname', 'contacttitle',
69 'borrowernotes', 'relationship', 'ethnicity', 'ethnotes',
70 'sex', 'userid', 'opacnote', 'contactnote',
71 'password', 'sort1', 'sort2'
73 <li>Please make sure the 'branchcode' and 'categorycode' are valid entries in your database</li>
74 <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>
81 <!-- TMPL_INCLUDE NAME="tools-menu.inc" -->
84 <!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->