Re: [IUG] Multiple Cards

["Rees, Joshua" <rees at plsinfo dot org>]

One method I have used to do this is to export to Excel a list of all patrons and their barcodes.

Since Millennium exports multiple instances of the same field by using the "Repeated Field Delimiter" to separate them, Excel can then separate the field into multiple columns.
 
Thus, in Excel, multiple barcodes will be separated in the same column by the symbol used as the "Repeated Field Delimiter" 
 
In Excel, use the "Text to Columns" function to separate the multiple occurrence fields into separate columns.
 
Then sort any of the columns with the multiple barcodes.
 
 
Hope this Helps.
------------------------------------------------------------------------
Joshua Rees  Youth Services Librarian   Daly City Public Library, 40 Wembley Drive, Daly City, CA 94015 
            Phone: 650-746-8302                  Email:    rees at plsinfo dot org <mailto:rees at plsinfo dot org>  
"You know you've read a good book when  you turn the last page and feel as if you've lost a friend."
from webshots.com                                  -Paul Sweeney


________________________________

From: innopac-bounces at innovativeusers dot org on behalf of Meehan, Dawn
Sent: Wed 5/27/09 7:37
To: IUG INNOPAC List
Subject: [IUG] Multiple Cards





I have a question for everyone out there. I was wondering if there is a
way to create a list to tell me one of two things:



1)      Does a patron have multiple active barcodes?

2)      Does a patron have a card under their name twice?



I hope that makes sense. I realize this may be one or more lists. I have
been all over iug.org and could not find anything. I was not sure how to
search for (word wise) so if you could help that would be great.



Thanks in advance for help,

Dawn Meehan

Technology Trainer

Electronic Services

330-643-9145

"Recognized as one of America's Best Libraries" <<<<<
<http://www.akronlibrary.org/5star.html>











--- StripMime Report -- processed MIME parts ---
multipart/related
  multipart/alternative
    text/plain (text body -- kept)
    text/html
  image/jpeg
  image/png
---
--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC at innovativeusers dot org
Update your subscription options: http://innovativeusers.org/mailman/listinfo/innopac




--- StripMime Report -- processed MIME parts ---
multipart/mixed
  text/plain (text body -- kept)
  application/ms-tnef
---