1 <!-- TMPL_INCLUDE NAME="doc-head-open.inc" -->
2 <title>Koha › Cataloging › Import Patrons <!-- 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> › <!-- TMPL_IF name="uploadborrowers" --><a href="/cgi-bin/koha/tools/import_borrowers.pl">Import Patrons</a> › Results<!-- TMPL_ELSE -->Import Patrons<!-- /TMPL_IF --></div>
11 <div id="doc3" class="yui-t2">
17 <div class="yui-u first">
18 <h1>Import Patrons</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>Field to use for record matching</legend>
47 <select name="matchpoint" id="matchpoint">
48 <option value="cardnumber">Cardnumber</option>
49 <!-- TMPL_LOOP NAME="matchpoints" -->
50 <option value="<!-- TMPL_VAR NAME="code" -->"><!-- TMPL_VAR NAME="description" --></option>
56 <fieldset class="rows">
57 <legend>If matching record is already in the borrowers table:</legend><ol><li class="radio">
59 <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>
61 <input type="radio" id="overwrite_cardnumberyes" name="overwrite_cardnumber" value="1" /><label for="overwrite_cardnumberyes">Overwrite the existing one with this</label>
62 </li></ol></fieldset><fieldset class="action"><input type="submit" value="Import" /></fieldset>
69 <li>Format the file in CSV format with the following fields:</li>
71 'cardnumber', 'surname', 'firstname', 'title',
72 'othernames', 'initials', 'streetnumber', 'streettype',
73 'address', 'address2', 'city', 'zipcode',
74 'email', 'phone', 'mobile', 'fax',
75 'emailpro', 'phonepro', 'B_streetnumber', 'B_streettype',
76 'B_address', 'B_city', 'B_zipcode', 'B_email',
77 'B_phone', 'dateofbirth', 'branchcode', 'categorycode',
78 'dateenrolled', 'dateexpiry', 'gonenoaddress', 'lost',
79 'debarred', 'contactname', 'contactfirstname', 'contacttitle',
80 'borrowernotes', 'relationship', 'ethnicity', 'ethnotes',
81 'sex', 'userid', 'opacnote', 'contactnote',
82 'password', 'sort1', 'sort2'<!-- TMPL_IF NAME="ExtendedPatronAttributes" -->, 'patron_attributes'<!-- /TMPL_IF -->
84 <!-- TMPL_IF NAME="ExtendedPatronAttributes" -->
85 <li>If loading patron attributes, the 'patron_attributes' field should contain a comma-separated list of attribute types
86 and values. The attribute type code and a ':' should precede each value. For example: "INSTID:12345,LANG:fr". This
87 means that if an input record has more than one attribute, the 'patron_attributes' field must be wrapped in double quotation marks.
90 <li>Please make sure the 'branchcode' and 'categorycode' are valid entries in your database.</li>
91 <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>
98 <div class="yui-b noprint">
99 <!-- TMPL_INCLUDE NAME="tools-menu.inc" -->
102 <!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->