VERSO logo

 

USER ADMINISTRATION

Chapter 3. MAINTAINING THE USER DATABASE

   

 


Preparing an Import File

NOTE: The import file can be prepared using any standard text-editing utility (such as Wordpad or Notepad), or it can be generated from a spreadsheet utility (such as Microsoft Excel).

The import file provides the means of simultaneously uploading and importing multiple patron records to your library’s database. Each line in the file contains the data for a single patron record. Patron records are separated by line breaks.

Each data line (patron record) in the file is comprised of multiple data fields, separated by delimiters (either commas or tabs). Each data line contains both mandatory and optional data fields. Data must be entered in all mandatory data fields for each data line (patron record); optional data fields may be left blank, if desired. Data fields must be entered in the following order:

Import File Field Descriptions

Field Name Description
username The unique Username or Barcode for the patron. The username can contain any combination of alphabetic and/or numeric characters, and the underscore character “_”. Do not include spaces in the username. This field is mandatory. If you do not include a username, an import error will be generated, and the record will not be imported.

NOTE: Each patron must be assigned a unique username. If you attempt to add two or more patrons with the same username, the records containing the duplicate username will be skipped or overwritten, depending on the Action on Duplicate Records option selected during upload (see Importing a File for details).

password The personal Password or PIN for the patron. The password can contain any combination of alphabetic and/or numeric characters, and the underscore character “_”. Do not include spaces in the password. This field is mandatory. If you do not include a password, an import error will be generated, and the record will not be imported.
question The reminder question for the patron’s password. This field is optional.
homelocation The Home Location for the patron. Any value entered in this field must be mapped to the corresponding Home Location. This field is mandatory.
firstname The patron’s first name. This field is optional.
initial The patron’s middle initial. This field is optional.

NOTE: If you enter the patron’s full middle name in the initial field, the system will truncate the name to show the middle initial only when the record is saved.

lastname The patron’s last name. This field is optional.
address1 First line of the patron’s mailing address (street address). This field is optional.
address2 Second line of the patron’s mailing address (street address). This field is optional.
city City for the patron’s mailing address. This field is optional.
state State for the patron’s mailing address. This field is optional.

NOTE: When entering data in the state field, enter the two-character abbreviation for the state in upper-case characters. If you enter the state in lower-case characters, or enter the complete state name, the proper state will not be saved when the record is imported.

zipcode Zip code for the patron’s mailing address. This field is optional.
country Country for the patron’s mailing address. This field is optional.
email The patron’s email address. This field is optional.
telephone The patron’s home telephone number. This field is optional.
faxnumber The patron’s fax number. This field is optional.
status

Current account status for the patron. This field is optional. This field may contain only one of the following values:

A - Active; the user’s account is enabled.

I - Inactive; the user’s account is disabled.

NOTE: If you choose to leave the status field blank, a default account status (selected during the import process) will be applied to the patron’s account.

lastactivity The last date on which activity (check out, check in, etc.) for the patron occurred. Enter the last activity date using the format “MM/DD/YYYY”, including slashes. This field is optional.
patron_group The patron group to which the patron is assigned. Any value entered in this field must be mapped to the corresponding Patron Group (see Importing a File for details). This field is optional.
patron_category The patron category to which the patron is assigned. Any value entered in this field must be mapped to the corresponding Patron Category (see Importing a File for details). This field is optional.
custom_number Any unique identifying number for the patron. This field is optional.
mobilephone The patron’s mobile/cellular telephone number. This field is optional.
workphone The patron’s work telephone number. This field is optional.
blocked Indicates whether or not the patron’s borrowing privileges are active or suspended. Enter Y (borrowing privileges are suspended, patron may not borrow materials from the library) or N (borrowing privileges are active, patron may borrow materials from the library). This field is optional. If a value is not entered in this field, the default value N is inserted.
block_reason The reason the patron’s borrowing privileges are currently suspended. It is recommended that if a value of Y is entered in the blocked field that a reason be included in the block_reason field. This field is optional.
expire_date The date on which the patron’s borrowing privileges will expire. Enter the expiration date using the format “MM/DD/YYYY”, including slashes. This field is optional.
sponsor The name of the party, group or organization sponsoring the patron. This field is optional.
comment Any comment you wish to include in the patron’s record. This field is optional.
date_added The date on which the patron’s user record was initially added to the VERSO system. Enter the date added using the format “MM/DD/YYYY”, including slashes. This field is optional.

NOTE: When a new record is added to the system and the date_added field does not contain data, the system sets the value for this field to the current calendar date. When an existing record in the system is updated and the date_added field does not contain data, the content of the date_added field in the existing record is retained.

date_updated The date on which the patron’s user record was most recently updated. Enter the date updated using the format “MM/DD/YYYY”, including slashes. This field is optional.

NOTE: When a new record is added to the system or an existing record in the system is updated and the date_updated field does not contain data, the system set the value for this field to the current calendar date.

notes Any free-form message you wish included in the Notes field of the patron’s user record. This field is optional.
fine_balance The patron’s outstanding fine/fee balance. This field is optional.
dob The patron’s date of birth. This field is optional.
message Any free-form message you wish displayed in the Message field on the Patron Status, Checkout & Reserves screen for the patron (see the Circulation User Guide for more information). This field is optional.
LDF1 ~ LDF20 Library defined fields 1 through 20. These fields are optional.

NOTE: When entering information for a Library Defined field configured as a “list” field, you must enter a valid (currently defined) option for the associated field.

nickname The patron’s Nickname. This field is optional.
foreign_key For use when importing user records from an external system where matching of existing records is determined by an alternate ID (a field other than the incoming username). When content is included in the foreign key field, matching records will be determined by comparing the content of the foreign_key field in the import file to the username field in the existing patron record.

When preparing an import file, keep the following in mind:

INCORRECT CORRECT
Williamson, Jr Williamson Jr.
620 W. Route 66, Apt. 211 620 W. Route 66 Apt. 211