Generate a Patron Data report

The Patron Data report lets you extract information about your patrons in XML format.

Note: The file does not include any data about deleted patrons.

After you have extracted patron information, you can import the XML files into a number of applications. For instance, if you import the file into a spreadsheet program, you can delete any fields you don't want, and then sort and filter the remaining data to create custom lists and reports.

To generate the report:

  1. Select Reports > Patron Reports.
  2. Under Statistics, click Patron Data. The report setup page appears.Extract Patron Data report.
  3. Do any of the following:
    1. In the first drop-down, select the option that defines the patron data you want to extract.
    2. In the from and to fields, enter a range.
      Note: You can limit to one date or a range.
      • All dates: Leave both fields blank.
      • One date: Enter the same date in both fields.
      • On or before a specific date: Leave the From field blank, and enter a date in the to field.
      • On or after a specific date: Enter a date in the From field, and leave the to field blank.
  1. Click Extract.
  2. When Report Manager opens, click View to download the XML file. Make sure to save or download the file; opening it in the browser may take an extended period of time.

For each patron, the file contains the following information:

  • Patron Barcode Number
  • District ID
  • Status
  • Last Name
  • First Name
  • Middle Name
  • Nickname
  • Gender
  • Graduation Year
  • Grade Level
  • Birth Date
  • Card Expiration date
  • Patron Type
  • User Defined 1
  • User Defined 2
  • User Defined 3
  • User Defined 4
  • User Defined 5
  • Homeroom
  • Access Level
  • User Name
  • Password Configured (Yes/No)
  • Acceptable Use Policy Filed (Yes/No)
  • Currently Teaching (Yes/No, Textbook Manager only)
  • Email 1
  • Email 2
  • Primary Address
  • Primary City
  • Primary State/Province
  • Primary Postal Code
  • Primary Phone 1
  • Primary Phone 2
  • Secondary Address
  • Secondary City
  • Secondary State/Province
  • Secondary Postal Code
  • Secondary Phone 1
  • Secondary Phone 2
  • Resource Items Out (Resource Manager only)
  • Resource Items Overdue (Resource Manager only)
  • Library Copies Out (Library Manager only)
  • Library Copies Overdue (Library Manager only)
  • Library Fine Amount (Library Manager only)
  • Library Refund Amount (Library Manager only)
  • Library Holds (Library Manager only)
  • Media Bookings (districts with Media Manager only)
  • Media Copies Out (districts with Media Manager only)
  • Media Copies Overdue (districts with Media Manager only)
  • Other [patron] Fine Amounts (Library Manager or Textbook Manager only)
  • Textbook Copies Out (Textbook Manager only)
  • Textbook Copies Overdue (Textbook Manager only)
  • Textbook Fine Amount (Textbook Manager only)
  • Textbook Refund Amount (Textbook Manager only)