Follett VERSION 6.00 Manuale Utente

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:



Copies/titles, by call number range



Copy transactions, by date range



Category transactions, by date range



Patrons, by a range of names, location 1 or 2, or user field 1 or 2

The output file is in a commadelimited 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 

 file extension.