View | Details | Raw Unified | Return to bug 15231
Collapse All | Expand All

(-)a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/import_borrowers.tt (-14 / +23 lines)
Lines 96-103 Link Here
96
  [% END %]
96
  [% END %]
97
[% ELSE %]
97
[% ELSE %]
98
<ul>
98
<ul>
99
	<li>Select a file to import into the borrowers table</li>
99
    <li>Select a file to import into the borrowers table.</li>
100
	<li>If a cardnumber exists in the table, you can choose whether to ignore the new one or overwrite the old one.</li>
100
    <li>If a cardnumber exists in the table, you can choose whether to ignore the new one or overwrite the old one.</li>
101
</ul>
101
</ul>
102
<form method="post" action="[% SCRIPT_NAME %]" enctype="multipart/form-data">
102
<form method="post" action="[% SCRIPT_NAME %]" enctype="multipart/form-data">
103
<fieldset class="rows">
103
<fieldset class="rows">
Lines 193-211 Link Here
193
<div class="yui-u">
193
<div class="yui-u">
194
<h2>Notes:</h2>
194
<h2>Notes:</h2>
195
<ul>
195
<ul>
196
<li>The first line in the file must be a header row defining which columns you are supplying in the import file.</li>
196
<li><b>Header: </b>The first line in the file must be a header row defining which columns you are supplying in the import file.</li>
197
<li><b>Download a starter CSV file with all the columns <a href="?sample=1">here</a>.</b>  Values are comma-separated.</li>
197
<li><b>Separator: </b>Values are comma-separated.</li>
198
<li>OR choose which fields you want to supply from the following list:<ul><li>
198
<li><b>Starter CSV: </b> Koha provides a starter CSV with all the columns.
199
    [% FOREACH columnkey IN borrower_fields %]'[% columnkey.field %]', [% END %]
199
    <ul><li><a href="?sample=1">Download starter CSV</a></li></ul>
200
</li></ul></li>
201
[% IF ( ExtendedPatronAttributes ) %]
202
<li>If loading patron attributes, the 'patron_attributes' field should contain a comma-separated list of attribute types and values. The attribute type code and a colon should precede each value. For example: <b>INSTID:12345,LANG:fr</b> or <b>STARTDATE:January 1 2010,TRACK:Day</b>. If an input record has more than one attribute, the fields should either be entered as an unquoted string (previous examples), or with each field wrapped in separate double quotes and delimited by a comma: <b>&quot;STARTDATE:January 1, 2010&quot;,&quot;TRACK:Day&quot;</b>.  The second syntax would be required if the data might have a comma in it, like a date string.
203
</li>
200
</li>
201
<li><b>Field list: </b>Alternatively, you can create your own CSV and choose which fields you want to supply from the following list:
202
    <ul><li>
203
       [% FOREACH columnkey IN borrower_fields %]'[% columnkey.field %]', [% END %]
204
    </li></ul>
205
</li>
206
[% IF ( Koha.Preference('ExtendedPatronAttributes') == 1 ) %]
207
<li><b>Extended patron attributes: </b>If loading patron attributes, the 'patron_attributes' field should contain a comma-separated list of attribute types and values. The attribute type code and a colon should precede each value.
208
    <ul><li>Example 1: INSTID:12345,LANG:fr</b></li><li> Example 2: STARTDATE:January 1 2010,TRACK:Day</li></ul>
209
If an input record has more than one attribute, the fields should either be entered as an unquoted string (previous examples), or with each field wrapped in separate double quotes and delimited by a comma:
210
    <ul><li>Example 3: &quot;STARTDATE:January 1, 2010&quot;,&quot;TRACK:Day&quot;</li></ul>
211
The second syntax would be required if the data might have a comma in it, like a date string.</li>
204
[% END %]
212
[% END %]
205
<li>The fields 'branchcode' and 'categorycode' are <b>required</b> and <b>must match</b> valid entries in your database.</li>
213
<li><b>Required fields: </b>The fields 'branchcode' and 'categorycode' are required and must match valid entries in your database.</li>
206
<li>'password' should be stored in plaintext, and will be converted to a Bcrypt hash (if your passwords are already encrypted, talk to your system administrator about options).</li>
214
<li><b>Password: </b>Values for the field 'password' should be stored in plaintext, and will be converted to a Bcrypt hash (if your passwords are already encrypted, talk to your system administrator about options).</li>
207
<li>Date formats should match your system preference, and <b>must</b> be zero-padded, e.g. '01/02/2008'.  Alternatively,
215
<li><b>Date formats: </b> Date values should match your system preference, and must be zero-padded.
208
you can supply dates in ISO format (e.g., '2010-10-28').
216
    <ul><li>Example: '01/02/2008'</li></ul>
217
Alternatively, you can supply dates in ISO format.
218
    <ul><li>Example: '2010-10-28'</li></ul>
209
</li>
219
</li>
210
</ul>
220
</ul>
211
221
212
- 

Return to bug 15231