Follett VERSION 6.00, User Manual

Page: 587 / 730

04/04 Chapter 40 Extracting data 587
Excel imports the file, placing each field in a column with the field name in the
first row:
To edit the extraction
file easily . . .
. . . import it into a
spreadsheet program.
You can delete, rearrange, sort, and filter the rows or columns. You can run the
Find feature to locate specific certain data, or, in combination with Replace,
update it.
Examples:
To locate patrons with missing or incomplete addresses, extract the
Patrons data and filter the address columns for blanks.
To determine how many checkouts occur between 3:00 and 4:00, extract the Copy
Transaction data and analyze the date and time columns.
To see which students are actually reading books in the Geography category,
check the Extract Patron Data check box in System Setup, and extract the
Category Transaction data.
Using your data in our examples
We have prepared, using MS Excel, a few custom reports to demonstrate some of
the many possible ways to analyze your data. These reports consist of a
spreadsheet with preconfigured formulas and an interpretive graph. If you have
a Windows workstation, you can open these files and import your own data
extraction file. To do so, you must have the following:
Microsoft Excel (version 97 or later) installed
The FSC Installation disk (version 4.2 or later)
Your data extraction file and its path and filename
Important:
Do not save your data extraction file to the root directory of your
hard drive. Place it inside a folder. Make sure the extension is .txt .
Insert the FSC Installation disk into your CD drive. Using Windows Explorer,
locate and open the Extras/Samples/Reports/Extract Data folder. Select the
desired report (e.g., Collection Details.xls) by doubleclicking it. This should
launch your MS Excel and open a spreadsheet containing the custom formatting.