Follett VERSION 6.00 - Manual (Page 585)

585
Chapter 40 Extracting data
This chapter contains general information on extracting data; instructions on how
to extract data; suggestions for using the data; and a table of the fields included
in the extraction files.
About extracting data
Extract Data allows you to retrieve information from your database without
using our Reports module. You can retrieve four types of data:
S Copies/titles, by call number range
S Copy transactions, by date range
S Category transactions, by date range
S Patrons, by a range of names, location 1 or 2, or user field 1 or 2
The output file is in a commaĆdelimited ASCII format. That is, every field in the
record is separated by a comma. (This is identical to the format of the Patrons.out
file that you can generate from Export Patrons in Patron Maintenance.) The first
record in the extract file is a header line, containing the names of the fields
included in the file. These fields, for all four files, are listed in the table at the end
of this chapter.
Note: If the Collect Patron Transaction Histories check box in System Setup is
unchecked and you have removed patron history in Utilities, data linking
patrons to copies will not be extracted.
For Union Catalog Plus: If you're running Union Catalog Plus, Copies/Titles is
the only available data type option. The extracted data will not include any
circulation statistics or patron information.
How to extract data
On the Reports main window, select File | Extract Data from the menu. In the
dialog, select the data type desired and the range. If you choose to extract
Patrons, what appears in the drop-down list depends on what you defined in
System Setup. Then click the Browse button and enter or select your destination
file name and extension.
Note: We recommend that you use the
.txt
file extension.