Add Patrons in Bulk (upload from a CSV file)
This page allows a batch of patrons to be inserted into the database from
a CSV (Comma Separated Value) file. This file needs at least columns for first
name, last name, the first address line, the city, state, zipcode, and
telephone. Optionally, it can also have the patron id, extra name, outstanding
fines, and expiration date. If the first line does not have column headers, the
upload program attempts to guess the columns. The recognized column names are:
- id The patron id.
- firstname The patron's first name.
- lastname The patron's last name.
- extraname The patron's extra name (usually middle name).
- address1 The patron's first address line.
- address2 The patron's second (optional) address line.
- city The patron's city.
- state The patron's state.
- zip The patron's zip code.
- telephone The patron's telephone number.
- outstandingfines The patron's outstanding fines.
- expiration The patron's expiration date.