Newbie question re synchonizing address lists (Ken Doucet)

[Michael Correll]

David and Pete's suggestions are right on target, and certainly  
appending the 2 files and then sorting by RECID is going to be the  
quickest  - especially on 200,000 records.   That latter point I  
wasn't clear on.  I wasn't really sure whether you meant 200K  
records....or 200 KB of data.   Big difference.   Doing a formulafill  
on 200,000 records is a lot of freight to haul, so it will indeed be  
slow. Might even crash.

But all this begs what may be your underlying question of data  
integrity.  Assuming your mail house is reasonably reputable and that  
they are using the latest data from the USPS, you could also assume I  
would think, that their address correction is reasonably accurate.

If you are doing a current mailing from these 200,000 records, it  
might be interesting to see how many are returned.  This would  
certainly indicate the validity of the mail house corrections.

CASS certification and Address/Zip corrections is also something you  
* could *  do in-house.   Do a quick search on  ' "address correction  
software" + mac '.   If you do it in-house, it's real ez to run the  
correction on all or a subset of your data and then import it back  
into your main DB.   And if you are using Pan to maintain -- and  
update -- your
data, it can be very easy to keep clean once you get everything  
corrected.

If you are buying data from outside sources (list brokers) and then  
assembling it... well, all I can say there is, "Caveat Emptor!"    
There is a lot of garbage out there.   Be careful.

MC.

On Feb 6, 2008, at 7:54 AM, Ken Doucet wrote:
>
> I have been following the math/formula fill to populate content of  
> field
> with values from another table using:
>
> lookup("CMEMAILV",RECID,RECID,Valid,"",0) and then wait..... At  
> this stage I
> am trying to populate 1 field from CMEMAILV but I will need to do  
> several. I
> waited 40 minutes and still nothing - my apple activity monitor is  
> showing
> cpu around 100% and Panorama not responding in Process column(I am on
> macbook pro intel) and the colour wheel is spinning .
>
> This is giving me more grief than I would have expected as all I am  
> trying
> to do eventually is join 2 tables so that I have the original  
> address fields
> along with the revised ones coming back from mailing house so I could
> analyze them.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://provue.com/pipermail/qna/attachments/20080206/b26763fc/attachment.html