Re: RE: Fines Paid Review

[lmueller@xxxxxxxxxx]

The problem I have with this is that it does not show me all of the details of the transaction including who took the fine and if there was a waive of part of it.  While I can summarize and see some of the information, I cannot get to two parts together to do proper analysis.  We are a consortia of 7 libraries so we are trying to pull information for each location.

Lori Mueller
Director of Student IT Systems Services
City Colleges of Chicago
312-553-3381 (w)
312-933-2918 (mobile)

----- Original Message -----
From: "Rutherford, John (Library)" <Rutherford@xxxxxxxxxx>
Date: Thursday, January 8, 2004 11:53 am
Subject: RE: Fines Paid Review

> Its pretty easy to do. Just display the detailed
> file, print it to email then save the email message as a text file.
> 
> The file has fixed column widths, so just open it with excel, and 
> excelwill prompt you to click on the spaces between columns (break 
> points).
> after that it will convert to a regular excel file and you can use 
> filtering etc. to do more analysis, or your could export to a 
> database if
> you want more abilities to run quereis etc.
> 
> John Rutherford
> Conn State univ.
> 
> -----Original Message-----
> From: innopac-bounces@xxxxxxxxxx
> [innopac-bounces@xxxxxxxxxx]On Behalf Of lmueller@xxxxxxxxxx
> Sent: Thursday, January 08, 2004 10:34 AM
> To: innopac@xxxxxxxxxx
> Subject: Fines Paid Review
> 
> 
> I am looking for ways to pull the entire Fines Paid information 
> into a spreadsheet in order to do analysis.  The canned reports do 
> not meet my needs and I want to pull all fields in order to break 
> it down by my different libraries.  Does anyone have any 
> information on this file and how to extract it to a text file?  We 
> are having problems with FTS.
> 
> Thanks
> 
> Lori Mueller
> Director of Student IT Systems Services
> City Colleges of Chicago
> 312-553-3381 (w)
> 312-933-2918 (mobile)
> 
> --
> This message was distributed through the Innovative Users Group 
> INNOPAC list
> Public replies:  INNOPAC@xxxxxxxxxx
> Update your subscription options: 
> http://innopacusers.org/mailman/listinfo/innopac
> --
> This message was distributed through the Innovative Users Group 
> INNOPAC list
> Public replies:  INNOPAC@xxxxxxxxxx
> Update your subscription options: 
> http://innopacusers.org/mailman/listinfo/innopac