Lines 2-31
Link Here
|
2 |
|
2 |
|
3 |
<h1>Patron Import</h1> |
3 |
<h1>Patron Import</h1> |
4 |
|
4 |
|
5 |
<ul> |
5 |
<p>The patron import tool can be used at any time to add patrons in bulk. It is commonly used in universities and schools when a new batch of students registers.</p> |
6 |
<li>Create a CSV file for your patron data<br/> |
6 |
|
7 |
<ul> |
7 |
<h2>Creating Patron File</h2> |
8 |
<li>Format your file with the following fields |
8 |
|
9 |
<ul> |
9 |
<p>Your Koha installation comes with a blank CSV file that you can use as a template for your patron records. If you would like to create the file yourself, make sure that your file has the following fields in this order as the header row:</p> |
10 |
<li>'surname', 'firstname', 'title', 'othernames', 'initials', 'streetnumber', 'streettype', 'address', 'address2', 'city', 'state', 'zipcode', 'country', 'email', 'phone', 'mobile', 'fax', 'emailpro', 'phonepro', 'B_streetnumber', 'B_streettype', 'B_address', 'B_address2', 'B_city', 'B_state', 'B_zipcode', 'B_country', 'B_email', 'B_phone', 'dateofbirth', 'branchcode', 'categorycode', 'dateenrolled', 'dateexpiry', 'gonenoaddress', 'lost', 'debarred', 'contactname', 'contactfirstname', 'contacttitle', 'guarantorid', 'borrowernotes', 'relationship', 'ethnicity', 'ethnotes', 'sex', 'password', 'flags', 'userid', 'opacnote', 'contactnote', 'sort1', 'sort2', 'altcontactfirstname', 'altcontactsurname', 'altcontactaddress1', 'altcontactaddress2', 'altcontactaddress3', 'altcontactstate', 'altcontactzipcode', 'altcontactcountry', 'altcontactphone', 'smsalertnumber', 'patron_attributes' |
10 |
|
11 |
<ul> |
11 |
<blockquote>borrowernumber, cardnumber, surname, firstname, title, othernames, initials, streetnumber, streettype, address, address2, city, zipcode, country, email, phone, mobile, fax, emailpro, phonepro, B_streetnumber, B_streettype, B_address, B_address2, B_city, B_zipcode, B_country, B_email, B_phone, dateofbirth, branchcode, categorycode, dateenrolled, dateexpiry, gonenoaddress, lost, debarred, contactname, contactfirstname, contacttitle, guarantorid, borrowernotes, relationship, ethnicity, ethnotes, sex, password, flags, userid, opacnote, contactnote, sort1, sort2, altcontactfirstname, altcontactsurname, altcontactaddress1, altcontactaddress2, altcontactaddress3, altcontactzipcode, altcontactcountry, altcontactphone, smsalertnumber, patron_attributes</blockquote> |
12 |
<li> |
12 |
|
13 |
<span style="background-color: #ffe599"> |
13 |
<p style="color: #990000;">Important: The 'password' value should be stored in plain text, and will be converted to a md5 hash (which is an encrypted version of the password).</p> |
14 |
TIP: Consult your system administrator if you are unsure of how to fill in the above fields.</span></li> |
14 |
|
15 |
<li> |
15 |
<ul> |
16 |
IMPORTANT: Make sure the 'branchcode' and 'categorycode' are valid entries in your database.</li> |
16 |
<li>If your passwords are already encrypted, talk to your systems administrator about options</li> |
17 |
<li>Passwords should be stored in plain text, and will be encrypted as they're imported |
17 |
</ul> |
18 |
<ul> |
18 |
|
19 |
<li> |
19 |
<p style="color: #990000;">Important: Date formats should match your system preference, and must be zero-padded, e.g. '01/02/2008'.</p> |
20 |
<span style="background-color: #ffe599"> |
20 |
|
21 |
TIP: If your passwords are already encrypted, talk to your systems administrator about options.</span></li> |
21 |
<p style="color: #990000;">Important: The fields 'branchcode' and 'categorycode' are required and must match valid entries in your database.</p> |
22 |
</ul></li> |
22 |
|
23 |
</ul></li> |
23 |
<p style="background-color: #ffe599">Tip: If loading patron attributes, the 'patron_attributes' field should contain a comma-separated list of attribute types and values.</p> |
24 |
</ul></li> |
24 |
|
25 |
</ul></li> |
25 |
<ul> |
26 |
<li>Select a file to import into the borrowers table</li> |
26 |
<li>The attribute type code and a colon should precede each value. |
27 |
<li>If a cardnumber exists in the table, you can choose whether to ignore the new one or overwrite the old one.</li> |
27 |
<ul> |
28 |
<li>Click 'Import'</li> |
28 |
<li>For example: INSTID:12345,LANG:fr or STARTDATE:January 1 2010,TRACK:Day</li> |
29 |
<li>You will be brought to a confirmation screen.</li> |
29 |
<li>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: |
30 |
</ul> |
30 |
<ul> |
31 |
</div> [% INCLUDE 'help-bottom.inc' %] |
31 |
<li>"STARTDATE:January 1, 2010","TRACK:Day"</li> |
|
|
32 |
<li>This syntax would be required if the data might have a comma in it, like a date string.</li> |
33 |
</ul> |
34 |
</li> |
35 |
</ul> |
36 |
</li> |
37 |
</ul> |
38 |
|
39 |
<h2>Importing Patrons</h2> |
40 |
|
41 |
<p>Once you have created your file, you can use the Patron Import Tool to bring the data into Koha.</p> |
42 |
|
43 |
<ul> |
44 |
<li>Choose your CSV file and choose to match on 'Cardnumber' to prevent adding of duplicate card numbers to the system</li> |
45 |
<li>Next you can choose default values to apply to all patrons you are importing |
46 |
<ul> |
47 |
<li>ex. If you're importing patrons specific to one branch you can use the field on the Import form to apply the branch code to all those you are importing.</li> |
48 |
</ul> |
49 |
</li> |
50 |
<li>Finally you need to decide on what data you want to replace if there are duplicates. |
51 |
<ul> |
52 |
<li>A matching record is found using the field you chose for matching criteria to prevent duplication</li> |
53 |
<li>If you included patron attributes in your file you can decide whether to add your values to existing values or erase existing values and enter only your new values.</li> |
54 |
</ul> |
55 |
</li> |
56 |
</ul> |
57 |
|
58 |
<p><strong>See the full documentation for Patron Import in the <a href="http://manual.koha-community.org/3.6/en/patronimport.html">manual</a> (online).</strong></p> |
59 |
|
60 |
[% INCLUDE 'help-bottom.inc' %] |