Newbie question re synchonizing address lists (Ken Doucet)

[Pete]

Ken Thompson is quite good, as he helped me quite a bit with some html
coding for Panorama.  His suggestion should work for you, but will take a
little bit of time for you to learn.  My other thought was to sort the two
databases by id number and then make copies of each, but only doing a
smaller grouping.  So say your id numbers run from 000000 to 250000.  Copy
the original file, select the first 50,000 records and discard the others
and save that file as file 2. Then do a formulafill on only those 50,000.
Then do the same for the next 50,000 and so fourth.  When you have done all
of them, which should take about 25 minutes, you can then do one whole
database attaching each of the partial ones.  Just another thought.  I
wonder how long it would take in Alpha.  I might try doing the zip code
addition on there to compare the two.  Perhaps when the California guys wake
up, one will get some more ideas.  Dave is from the Univ of Ill.

Pete

------Original Message-----
-From: qna-bounces at provue.com [mailto:qna-bounces at provue.com] On Behalf Of
-Ken Doucet
-Sent: Wednesday, February 06, 2008 8:55 AM
-To: qna at provue.com
-Subject: Newbie question re synchonizing address lists (Ken Doucet)
-
-
-
-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.
-
-Thanks
-
-Ken
-
-PS how do I respond so that this will flow into thread (is it just by
-keeping subject line identical? I wanted to reply to Michael's response to
-my first post.
-_______________________________________________
-Qna mailing list
-Qna at provue.com
-http://provue.com/mailman/listinfo/qna