merging files

[Jeff Kozuch]

You can merge all 38 files, then find something unique, like the  
phone number, and use "Select Duplicates" from the "Search" menu.  
Once you have the duplicates selected, you can manually review the  
records and keep what you want or propagate the phone field, select  
the records that are not empty, then remove the unselected records.

Also, if you have a serial number for your Panorama program, you  
should be able to download the documentation at ProVUE.com.

Jeff

Jeff Kozuch
President, Acacia Systems
Apple Certified Technical Coordinator
Certified Member, Apple Consultants Network
jk at acaciasystems.com
http://www.acaciasystems.com
562-437-7690


On Jun 10, 2008, at 2:25 PM, Rob Bier wrote:

> For reasons not worth going into, the community radio station where  
> I volunteer has at least 38 copies of its CD database.  Many of the  
> records in each copy duplicate those in other copies; some records  
> exist only in a single copy.  All new records now are being entered  
> into the same database.  Obviously, it would be preferable to have  
> all records (more than 30,000 of them) in the same place.  How do  
> we do this?  Can the existing files be merged so that only unique  
> records remain in the merged file, so that duplicates are  
> eliminated?  Are there other ways to clean up what years of sloppy  
> habits have caused?
>
> I have reviewed the Panorama Handbook without finding any clues.   
> Panorama Help was not loaded when the program was installed.  The  
> person who set up the system  has departed this life.
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080610/42c06e22/attachment.html