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" -->
4 <style type="text/css">
5 .yui-u fieldset.rows label.widelabel { width: 12em; }
6 code { background-color: yellow; }
10 <!-- TMPL_INCLUDE NAME="header.inc" -->
11 <!-- TMPL_INCLUDE NAME="patron-search.inc"-->
13 <div id="breadcrumbs"><a href="/cgi-bin/koha/mainpage.pl">Home</a> › <a href="/cgi-bin/koha/tools/tools-home.pl">Tools</a> › <a href="/cgi-bin/koha/tools/import_borrowers.pl">Import Patrons</a><!-- TMPL_IF name="uploadborrowers" --> › Results<!-- /TMPL_IF --></div>
15 <div id="doc3" class="yui-t2">
21 <div class="yui-u first">
22 <h1>Import Patrons</h1>
23 <!-- TMPL_IF name="uploadborrowers" -->
24 <h5>Import results :</h5>
26 <li><!-- TMPL_VAR name="imported" --> imported records <!-- TMPL_IF name="lastimported" -->(last was <!-- TMPL_VAR name="lastimported" -->)<!-- /TMPL_IF --></li>
27 <li><!-- TMPL_VAR name="overwritten" --> overwritten <!-- TMPL_IF name="lastoverwritten" -->(last was <!-- TMPL_VAR name="lastoverwritten" -->)<!-- /TMPL_IF --></li>
28 <li><!-- TMPL_VAR name="alreadyindb" --> not imported because already in borrowers table and overwrite disabled <!-- TMPL_IF name="lastalreadyindb" -->(last was <!-- TMPL_VAR name="lastalreadyindb" -->)<!-- /TMPL_IF --></li>
29 <li><!-- TMPL_VAR name="invalid" --> not imported because they are not in the expected format <!-- TMPL_IF name="lastinvalid" -->(last was <!-- TMPL_VAR name="lastinvalid" -->)<!-- /TMPL_IF --></li>
30 <li><!-- TMPL_VAR name="total" --> records parsed</li>
31 <li><a href="/cgi-bin/koha/tools/tools-home.pl">Back to Tools</a></li>
33 <!-- TMPL_IF NAME="ERRORS" -->
36 <h5>Error analysis:</h5>
38 <!-- TMPL_LOOP NAME="ERRORS" -->
39 <!-- TMPL_IF NAME="badheader" --><li>Header row could not be parsed</li><!-- /TMPL_IF -->
40 <!-- TMPL_LOOP NAME="missing_criticals" -->
42 <!-- TMPL_IF NAME="badparse" -->
43 Line <span class="linenumber"><!-- TMPL_VAR NAME="line" --></span> could not be parsed!
45 Critical field "<!-- TMPL_VAR NAME="key" -->" missing on line <span class="linenumber"><!-- TMPL_VAR NAME="line" --></span>
46 (borrowernumber: <!-- TMPL_VAR NAME="borrowernumber" -->; surname: <!-- TMPL_VAR NAME="surname" -->).
48 <br /><code><!-- TMPL_VAR NAME="lineraw" --></code>
57 <li>Select a file to import into the borrowers table</li>
58 <li>If a cardnumber exists in the table, you can choose whether to ignore the new one or overwrite the old one.</li>
60 <form method="post" action="<!-- TMPL_VAR name="SCRIPT_NAME" -->" enctype="multipart/form-data">
61 <fieldset class="rows">
62 <legend>Import into the borrowers table</legend>
65 <label for="uploadborrowers">Select the file to import: </label>
66 <input type="file" id="uploadborrowers" name="uploadborrowers" />
69 <fieldset class="rows">
70 <legend>Field to use for record matching</legend>
73 <select name="matchpoint" id="matchpoint">
74 <option value="cardnumber">Cardnumber</option>
75 <!-- TMPL_LOOP NAME="matchpoints" -->
76 <option value="<!-- TMPL_VAR NAME="code" -->"><!-- TMPL_VAR NAME="description" --></option>
82 <fieldset class="rows">
83 <legend>Default values</legend>
85 <!-- TMPL_LOOP NAME="columnkeys" -->
87 <label class="widelabel" for="<!-- TMPL_VAR NAME="key" -->"><!-- TMPL_VAR NAME="key" --></label>
88 <input id="<!-- TMPL_VAR NAME="key" -->" name="<!-- TMPL_VAR NAME="key" -->" />
92 <fieldset class="rows">
93 <legend>If matching record is already in the borrowers table:</legend><ol><li class="radio">
95 <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>
97 <input type="radio" id="overwrite_cardnumberyes" name="overwrite_cardnumber" value="1" /><label for="overwrite_cardnumberyes">Overwrite the existing one with this</label>
99 <fieldset class="action"><input type="submit" value="Import" /></fieldset>
106 <li><b>Download a starter CSV file with all the columns <a href="?sample=1">here</a>.</b> Values are comma-separated.</li>
107 <li>OR format your file in CSV format with the following fields:</li>
109 <!-- TMPL_LOOP name="columnkeys" -->'<!-- TMPL_VAR name="key" -->', <!-- /TMPL_LOOP -->
111 <!-- TMPL_IF NAME="ExtendedPatronAttributes" -->
112 <li>If loading patron attributes, the 'patron_attributes' field should contain a comma-separated list of attribute types
113 and values. The attribute type code and a ':' should precede each value. For example: "INSTID:12345,LANG:fr". This
114 means that if an input record has more than one attribute, the 'patron_attributes' field must be wrapped in double quotation marks.
117 <li>The fields 'branchcode' and 'categorycode' are <b>required</b> and <b>must match</b> valid entries in your database.</li>
118 <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>
119 <li>Date formats should match your system preference, and <b>must</b> be zero-padded, e.g. '01/02/2008'.</li>
120 <li>You may optionally include a header row, defining which columns you are supplying in the import file.</li>
127 <div class="yui-b noprint">
128 <!-- TMPL_INCLUDE NAME="tools-menu.inc" -->
131 <!-- TMPL_INCLUDE NAME="intranet-bottom.inc" -->